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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = SPXW260819C07700000×ticker = SPXW×sorted by created_at ↑×

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

0bcb9504-ef55-40c6-a37f-69c1b351e3c2	2026-08-18 10:12	2026-08-18 10:11	2026-08-18 10:11	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	21.9800	21.6000	22.2000	7699.4800	219840.00	219840.00	0.00	100	20	1128	655	1.72213740458015	0.134722935445493	0.136588939235022	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-18T14:15:30.654866Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
fa4a67b8-a24a-4733-b618-ff005c2b15ef	2026-08-18 11:43	2026-08-18 11:43	2026-08-18 11:43	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	20.3000	20.3000	20.4000	7700.1800	136010.00	0.00	136010.00	67	7	2481	655	3.78778625954198	0.123188279686568	0.123188279686568	false	false	false	true
559d9020-667a-4d66-9358-dd1d8dfcc8dc	2026-08-18 11:45	2026-08-18 11:45	2026-08-18 11:45	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	20.5000	20.4000	20.7000	7700.7100	184500.00	159900.00	24600.00	90	7	2604	655	3.97557251908397	0.122746614742215	0.122746614742215	false	false	false	true
d7b7e489-8409-42c2-a0a8-52f7cb6668b9	2026-08-18 15:58	2026-08-18 15:58	2026-08-18 15:58	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	13.8500	13.6000	13.9000	7670.0000	138510.00	138510.00	0.00	100	16	8284	655	12.6473282442748	0.108671396886222	0.108671396886222	false	false	false	true
9b2b9da8-a003-42e7-bb7a-19a0fd9309ef	2026-08-18 15:59	2026-08-18 15:58	2026-08-18 15:58	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	14.8000	14.8000	15.0000	7670.0000	148000.00	0.00	148000.00	100	10	8499	655	12.975572519084	0.108512217912199	0.108512217912199	false	false	false	true
c6b50d7a-924f-4e6b-b6ca-92765c56e6ad	2026-08-19 09:30	2026-08-19 09:30	2026-08-19 09:30	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	29.0000	28.8000	29.5000	7723.4300	504600.00	191400.00	313200.00	174	12	240	2637	0.0910125142207053	0.168952835378206	0.168952835378206	false	false	false	true
c3339d16-7b82-451d-9c87-0be24a43267f	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	33.4700	33.4000	33.7000	7731.1300	184110.00	0.00	110400.00	55	12	4990	2637	1.89230185817217	0.159454456035161	0.15478254380543	true	false	false	true
c8003d19-d532-465d-8ff1-84d54a28ff86	2026-08-19 14:10	2026-08-19 14:10	2026-08-19 14:10	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	14.3200	14.2000	14.5000	7710.7700	143170.00	137410.00	5760.00	100	7	10664	2637	4.04398938187334	0.176124587503896	0.173495052748843	false	false	false	true