Options flow alerts (market-wide)

core.flow_alerts

Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×ticker = SPX×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

1e154038-7398-48ec-a6fe-74047aaad855	2026-08-28 15:56	2026-08-28 15:56	2026-08-28 15:56	SPX	SPX270617C08475000	call	8475.0000	2027-06-17	198.8400	198.8000	199.1000	7714.5300	159070.00	0.00	139180.00	8	5	59	1233	0.0478507704785077	0.139530386931182	0.139570165626938	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T19:57:19.773601Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b1467459-3771-4435-8491-09aac3b1b29c	2026-08-27 10:12	2026-08-27 10:12	2026-08-27 10:12	SPX	SPX260918P07800000	put	7800.0000	2026-09-18	128.6300	128.1000	128.8000	7705.2200	1955220.00	1955220.00	0.00	152	26	194	24089	0.00805346838806094	0.111583992581349	0.111724807597949	false	false	false	true
1aac5cc4-2f46-4249-b8d5-85e86a7a30c9	2026-08-25 15:55	2026-08-25 15:55	2026-08-25 15:55	SPX	SPX270617C08650000	call	8650.0000	2027-06-17	143.7300	143.1000	144.0000	7677.3600	158100.00	158100.00	0.00	11	5	39	3024	0.0128968253968254	0.138218912991904	0.138307489008235	false	false	false	true
1e42a628-3c0a-452c-a2c6-a11e8a252a50	2026-08-25 15:29	2026-08-25 15:29	2026-08-25 15:29	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	198.4500	198.0000	198.6000	7669.6400	119070.00	79370.00	39700.00	6	5	168	3247	0.0517400677548506	0.135814374335811	0.135881324429026	false	false	false	true
dfa75073-60f4-4725-a700-d2df17eab183	2026-08-25 11:10	2026-08-25 11:10	2026-08-25 11:10	SPX	SPX260918C07700000	call	7700.0000	2026-09-18	85.4800	85.0000	85.4000	7664.4900	17095000.00	0.00	0.00	2000	18	4059	34741	0.116836015083043	0.119160050002935	0.119032368597202	false	false	false	true
5a8e1437-82bb-467d-bb77-d59fa8083bd9	2026-08-25 10:36	2026-08-25 10:36	2026-08-25 10:36	SPX	SPX260918C07475000	call	7475.0000	2026-09-18	246.3100	244.5000	246.3000	7663.4200	738938.00	0.00	0.00	30	20	30	9926	0.00302236550473504	0.147631545721774	0.147648347809047	false	false	false	true
ca639a7f-80ca-4313-9404-e80c55f6e802	2026-08-25 10:01	2026-08-25 10:01	2026-08-25 10:01	SPX	SPX260918C07700000	call	7700.0000	2026-09-18	91.2000	91.0000	91.6000	7674.3000	793460.00	18260.00	775200.00	87	9	408	34741	0.011744048818399	0.120237913843074	0.120365300554935	false	false	false	true
813ef549-74f7-47ce-804f-c94acee008e7	2026-08-25 10:01	2026-08-25 10:01	2026-08-25 10:01	SPX	SPX260918C07700000	call	7700.0000	2026-09-18	91.2600	90.9000	91.6000	7673.5600	1441860.00	1368820.00	0.00	158	23	321	34741	0.00923980311447569	0.120704136445631	0.120831540565163	false	false	false	true
a1473b28-bad3-44bd-91a1-970637ed5362	2026-08-24 15:42	2026-08-24 15:42	2026-08-24 15:42	SPX	SPX261120P07750000	put	7750.0000	2026-11-20	224.9400	224.6000	225.2000	7654.3500	179950.00	134970.00	0.00	8	6	152	2734	0.055596196049744	0.141835081401915	0.141835081401915	false	false	false	true
f4396deb-8f14-4454-8bad-a80625499ddd	2026-08-24 15:11	2026-08-24 15:11	2026-08-24 15:11	SPX	SPX261120C07750000	call	7750.0000	2026-11-20	195.1800	194.7000	195.3000	7658.0600	156140.00	156140.00	0.00	8	6	91	3064	0.0296997389033943	0.1363980732629	0.136464735782191	false	false	false	true
9b3994ab-adea-4338-9ae2-02d670205cf7	2026-08-24 09:46	2026-08-24 09:46	2026-08-24 09:46	SPX	SPX260918P07750000	put	7750.0000	2026-09-18	144.5000	144.4000	145.0000	7644.4000	621370.00	72300.00	549070.00	43	5	152	20474	0.00742405001465273	0.119195626359412	0.119461152526461	false	false	false	true
ebaa87cb-18b8-41aa-8e78-2ce0c368e055	2026-08-21 10:26	2026-08-21 10:26	2026-08-21 10:26	SPX	SPX260918C07735000	call	7735.0000	2026-09-18	76.3000	76.2000	76.7000	7669.2700	877440.00	0.00	877440.00	115	9	243	4357	0.0557723204039477	0.113287319259771	0.113526494261956	false	false	false	true
3d16ba6c-5f9f-4296-a54e-82e40a7a2f1d	2026-08-20 15:57	2026-08-20 15:57	2026-08-20 15:57	SPX	SPX260918C07700000	call	7700.0000	2026-09-18	87.3000	86.7000	87.6000	7640.0800	1920660.00	1920660.00	0.00	220	8	15968	26276	0.607702846704217	0.121515037892978	0.121477089349158	false	false	false	true
0383b288-df96-4505-83f1-0edc19e70eb3	2026-08-20 14:55	2026-08-20 14:55	2026-08-20 14:55	SPX	SPX270115P07700000	put	7700.0000	2027-01-15	261.0700	260.7000	261.6000	7655.5400	182750.00	78390.00	104360.00	7	5	473	2182	0.216773602199817	0.154117278372329	0.154117278372329	false	false	false	true
4b7d30eb-a9bb-4582-8454-02258066fbff	2026-08-20 12:15	2026-08-20 12:15	2026-08-20 12:15	SPX	SPX270115C07750000	call	7750.0000	2027-01-15	312.7200	312.2000	313.5000	7673.7500	156360.00	31290.00	93790.00	5	5	92	1447	0.0635798203178991	0.14860960895774	0.148764464162206	false	false	false	true
e6301caa-aa56-403a-a64e-57940b9b3d0a	2026-08-20 10:07	2026-08-20 10:07	2026-08-20 10:07	SPX	SPX261218P07600000	put	7600.0000	2026-12-18	200.5300	199.7000	200.7000	7682.3600	4010560.00	1404020.00	2606540.00	200	14	216	17173	0.0125778838874978	0.161761815307569	0.161821340994973	false	false	false	true
d3224f51-2469-43e7-a79a-b0ac7d6210f9	2026-08-20 10:06	2026-08-20 10:06	2026-08-20 10:06	SPX	SPX261120C08100000	call	8100.0000	2026-11-20	68.7700	68.4000	69.2000	7680.3100	206320.00	192560.00	0.00	30	9	30	8557	0.0035059016010284	0.122871120628174	0.122952642368445	false	false	false	true
cb70c94b-6e04-4bfd-8250-d9692b2fa304	2026-08-20 10:00	2026-08-20 10:00	2026-08-20 10:00	SPX	SPX260918P07750000	put	7750.0000	2026-09-18	127.2000	126.9000	127.7000	7688.4700	1068440.00	152760.00	737460.00	84	12	91	20013	0.00454704442112627	0.123263693901995	0.123263693901995	false	false	false	true
4fab111e-2e8f-4107-bfbe-6c2aafd68f79	2026-08-20 09:31	2026-08-20 09:31	2026-08-20 09:31	SPX	SPX261120C08200000	call	8200.0000	2026-11-20	46.2900	46.0000	47.0000	7686.7700	694380.00	0.00	694380.00	150	12	150	6527	0.0229814616209591	0.11915819371883	0.11944668326155	false	false	false	true
29540a73-1041-47da-b5e4-3e0e4eb848d1	2026-08-19 16:53	2026-08-19 16:31	2026-08-19 16:31	SPX	SPX260821C07750000	call	7750.0000	2026-08-21	5.9500	5.4000	8.5000	7707.9800	104140.00	0.00	104140.00	175	6	9934	15886	0.625330479667632	0.0866538660490724	0.0878700895825863	false	false	false	true
477bcbab-e4ec-4cf7-88b5-7c112b381c5d	2026-08-19 15:56	2026-08-19 15:56	2026-08-19 15:56	SPX	SPX270617C08450000	call	8450.0000	2027-06-17	218.9000	218.4000	219.3000	7701.7000	131340.00	43820.00	87520.00	6	5	81	450	0.18	0.143590403131353	0.143590403131353	false	false	false	true
a022d5a2-aa93-476a-be95-83a37167263c	2026-08-19 12:27	2026-08-19 12:27	2026-08-19 12:27	SPX	SPX260821P07730000	put	7730.0000	2026-08-21	20.9600	20.0000	21.6000	7730.5000	209560.00	188660.00	20900.00	100	11	656	477	1.37526205450734	0.096094874113855	0.096094874113855	false	false	false	true
44d6b3a0-30c7-4f86-8711-083c2ab79978	2026-08-19 12:03	2026-08-19 12:03	2026-08-19 12:03	SPX	SPX260821C07730000	call	7730.0000	2026-08-21	24.1400	23.1000	24.6000	7731.7800	195560.00	86950.00	108610.00	81	9	384	1045	0.367464114832536	0.0976665708701341	0.0993067088773654	false	false	false	true
9592458c-c96b-4235-a06d-0e6119f275f0	2026-08-19 11:40	2026-08-19 11:40	2026-08-19 11:40	SPX	SPX260918C07950000	call	7950.0000	2026-09-18	26.3700	26.1000	26.5000	7723.5000	532620.00	76560.00	456060.00	202	7	1550	8109	0.191145640646196	0.105825669712105	0.106325566776132	false	false	false	true
2f1c0dcb-a213-4df2-a56e-fb30065536ba	2026-08-18 10:54	2026-08-18 10:54	2026-08-18 10:54	SPX	SPX260821P07600000	put	7600.0000	2026-08-21	6.6700	6.4000	7.3000	7701.5600	325340.00	94830.00	230510.00	488	10	2630	17015	0.154569497502204	0.137007330015466	0.137662891886335	false	false	false	true
0c906e02-91f4-4c38-a3e2-7585c6231cd0	2026-08-18 10:22	2026-08-18 10:22	2026-08-18 10:22	SPX	SPX260821P07650000	put	7650.0000	2026-08-21	13.7000	13.4000	13.8000	7702.4600	683520.00	505530.00	163030.00	499	6	898	8984	0.0999554764024933	0.123434623343921	0.123876018535394	true	false	false	true
6b2e0d18-8ae2-4020-bde2-4675bb1f7a7e	2026-08-18 10:11	2026-08-18 10:11	2026-08-18 10:11	SPX	SPX260821P07700000	put	7700.0000	2026-08-21	29.7600	28.1000	31.2000	7699.3300	297600.00	184360.00	113240.00	100	10	1877	7735	0.242663219133807	0.109260190144275	0.110101685694963	false	false	false	true
d8b2ca10-f7b5-45e6-a8c2-16626a190a88	2026-08-17 15:17	2026-08-17 15:17	2026-08-17 15:17	SPX	SPX260918P07000000	put	7000.0000	2026-09-18	12.3300	12.3000	12.6000	7754.4600	106010.00	0.00	106010.00	86	10	1083	330343	0.00327841062168716	0.227202891705737	0.227597737790058	false	false	false	true
2afff304-8759-469e-bf04-a411dfbffdb4	2026-08-17 10:31	2026-08-17 10:30	2026-08-17 10:30	SPX	SPX270917C08500000	call	8500.0000	2027-09-17	348.5400	349.4000	350.9000	7775.4000	9236430.00	0.00	0.00	265	18	1082	3659	0.295709210166712	0.152685500677607	0.152688655900748	false	false	false	true
a4427e0b-ea0c-42db-9e45-e7205ba1305d	2026-08-17 10:16	2026-08-17 10:16	2026-08-17 10:16	SPX	SPX270917C08500000	call	8500.0000	2027-09-17	351.7400	349.7000	351.1000	7775.9200	9497074.00	0.00	0.00	270	18	812	3659	0.221918556982782	0.153560149399334	0.153628701137174	false	false	false	true
fa9f9184-7eec-46db-8463-043254627165	2026-08-17 10:07	2026-08-17 10:07	2026-08-17 10:07	SPX	SPX270917C08500000	call	8500.0000	2027-09-17	350.7900	349.3000	350.7000	7773.8100	9471412.00	0.00	0.00	270	18	272	3659	0.0743372506149221	0.153607338049075	0.153610493388033	false	false	false	true
e4e47d72-e997-40f7-b586-c908b9ad73b7	2026-08-17 09:56	2026-08-17 09:55	2026-08-17 09:55	SPX	SPX261218P07400000	put	7400.0000	2026-12-18	135.8900	135.0000	136.5000	7777.4800	5027950.00	1383150.00	3644800.00	370	22	371	24615	0.0150721105017266	0.182428416610065	0.182770851668547	false	false	false	true
4d8530eb-39cd-4633-8874-f4978fa36a6d	2026-08-14 16:36	2026-08-14 16:24	2026-08-14 16:24	SPX	SPX260918C08000000	call	8000.0000	2026-09-18	35.1100	33.7000	37.7000	7785.7600	200100.00	0.00	200100.00	57	5	1679	266469	0.00630092055736315	0.10470585638541	0.105106293312822	false	false	false	true