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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = unknown×ticker = HALO×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	expirydate

26f74e80-5076-43f3-8714-3ffe7604055d	2026-08-18 13:52	2026-08-18 13:52	2026-08-18 13:52	HALO	HALO270319C00100000	call	100.0000	2027-03-19	15.5000	13.6000	15.5000	105.0450	40292.00	40292.00	0.00	26	11	27	51	0.529411764705882	0.372055241815352	0.372055241815352	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	12250974120.00	2026-11-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
74a4f368-8ba0-41dc-a5d2-4c26414fa981	2026-08-19 14:49	2026-08-19 14:49	2026-08-19 14:49	HALO	HALO270319C00095000	call	95.0000	2027-03-19	20.2000	18.0000	20.2000	107.7150	18180.00	18180.00	0.00	9	9	9	25	0.36	0.369836658833294	0.369836658833294	false	false	false	true
f5cfac1a-cbe6-42f4-bd30-2235ffcb2678	2026-08-20 10:27	2026-08-20 10:27	2026-08-20 10:27	HALO	HALO261218P00090000	put	90.0000	2026-12-18	2.4800	1.9000	2.5000	106.9000	26500.00	14250.00	12250.00	107	6	127	27	4.7037037037037	0.390632635038732	0.390632635038732	false	false	false	true
07a29f11-fdce-46df-bd15-549a4fccdc1d	2026-08-21 14:13	2026-08-21 14:13	2026-08-21 14:13	HALO	HALO271217C00120000	call	120.0000	2027-12-17	17.0000	16.0000	17.0000	108.0000	156400.00	156400.00	0.00	92	18	99	115	0.860869565217391	0.389140749839694	0.389140749839694	false	false	false	true
ab963e1d-4349-4c86-a882-e524a8414da9	2026-09-02 12:01	2026-09-02 12:01	2026-09-02 12:01	HALO	HALO261016P00110000	put	110.0000	2026-10-16	5.4000	5.0000	6.8000	108.6100	10800.00	8100.00	2700.00	20	10	20	0	0	0.329069467979216	0.327895217138459	false	false	false	true
2a31eae7-cc82-4263-8255-0fbedbe33603	2026-09-03 12:45	2026-09-03 12:44	2026-09-03 12:44	HALO	HALO260918C00110000	call	110.0000	2026-09-18	3.3200	2.4000	3.4000	110.4350	13278.00	13278.00	0.00	40	11	47	1190	0.0394957983193277	0.346604463310532	0.294742739230553	false	false	false	true
ed3cf187-0c9e-4f7f-aa47-b09933c25ffe	2026-09-04 14:26	2026-09-04 14:26	2026-09-04 14:26	HALO	HALO270319C00140000	call	140.0000	2027-03-19	3.6000	3.3000	3.6000	110.1500	10079.00	10079.00	0.00	28	14	89	1	89	0.358688362875069	0.358288988700665	false	false	false	true
eadcf6fb-99b7-4d39-b1eb-c5bbf85bb26f	2026-09-04 15:02	2026-09-04 15:02	2026-09-04 15:02	HALO	HALO270319C00140000	call	140.0000	2027-03-19	3.6000	3.3000	3.6000	110.1300	10078.00	10078.00	0.00	28	13	256	1	256	0.358080081615813	0.358080081615813	false	false	false	true
428aab93-65c3-4b0e-9906-88e8df5d6fbc	2026-09-11 10:16	2026-09-11 10:16	2026-09-11 10:16	HALO	HALO271217C00105000	call	105.0000	2027-12-17	20.6000	20.5000	23.5000	107.0600	269867.00	0.00	267807.00	131	35	132	288	0.458333333333333	0.352572016034539	0.355216584530239	false	false	false	true
fec3d665-b912-49c0-9598-6af790cfb523	2026-09-16 13:34	2026-09-16 13:34	2026-09-16 13:34	HALO	HALO271217C00120000	call	120.0000	2027-12-17	16.1000	13.0000	16.1000	109.2100	138449.00	136849.00	1600.00	86	17	86	413	0.208232445520581	0.36554962173068	0.365343088341536	false	false	false	true
662febc8-bded-4368-8f1b-94ebf24c749d	2026-09-23 13:36	2026-09-23 13:36	2026-09-23 13:36	HALO	HALO261016C00115000	call	115.0000	2026-10-16	3.1300	2.5000	3.4000	112.7350	10955.00	4760.00	0.00	35	5	45	163	0.276073619631902	0.379202847597235	0.338903254968002	false	false	false	true
5ed50bfc-b3a8-4838-a61a-ec58c3b9d6fb	2026-09-28 09:42	2026-09-28 09:42	2026-09-28 09:42	HALO	HALO261120C00120000	call	120.0000	2026-11-20	4.3000	3.7000	4.3000	112.9400	19350.00	19350.00	0.00	45	5	80	70	1.14285714285714	0.397949222101519	0.397949222101519	false	false	false	true