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:alert_rule = RepeatedHitsDescendingFill×endpoint = /api/option-trades/flow-alerts×ticker = SNX×

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

7cf3c692-997b-49cf-993f-c216b2aadb72	2026-10-01 10:49	2026-10-01 10:49	2026-10-01 10:49	SNX	SNX261218C00270000	call	270.0000	2026-12-18	17.7600	15.6000	17.8000	265.6100	195390.00	191850.00	3540.00	110	20	110	66	1.66666666666667	0.382307179972273	0.382307179972273	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	21680336389.00	2027-01-14	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T14:49:50.749242Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
f161de08-df99-4a67-a017-cfc9227ff06a	2026-09-25 10:12	2026-09-25 10:11	2026-09-25 10:11	SNX	SNX261016C00300000	call	300.0000	2026-10-16	2.7500	2.5500	3.5000	275.2500	17055.00	3410.00	13645.00	62	8	162	417	0.388489208633094	0.391858217897811	0.397252487180684	true	false
624c3fef-96e2-4fb5-aa68-1ab9b0e159e4	2026-09-25 09:43	2026-09-25 09:42	2026-09-25 09:42	SNX	SNX261120C00300000	call	300.0000	2026-11-20	9.0800	9.0000	9.5000	279.3700	333179.00	87419.00	20760.00	367	45	370	353	1.04815864022663	0.378320011070812	0.378320011070812	false	false
ca5b1c6e-2a35-4751-9216-0cc6c1939163	2026-09-24 10:29	2026-09-24 10:29	2026-09-24 10:29	SNX	SNX261218C00240000	call	240.0000	2026-12-18	23.4100	23.4000	26.2000	249.5350	140450.00	0.00	140450.00	60	8	65	2728	0.0238269794721408	0.36997389603808	0.358849084298879	false	false
93d8d4db-8e58-48e8-850d-2716bf5a0d3e	2026-09-24 10:07	2026-09-24 10:07	2026-09-24 10:07	SNX	SNX270319C00260000	call	260.0000	2027-03-19	29.1400	26.6000	29.2000	255.4250	291410.00	137180.00	0.00	100	5	100	22	4.54545454545455	0.409172851023236	0.407743079802802	false	false
6982e4e0-ba39-48ee-913e-6d894ca93758	2026-09-23 15:59	2026-09-23 15:59	2026-09-23 15:59	SNX	SNX261016P00290000	put	290.0000	2026-10-16	15.2900	13.9000	16.5000	287.0000	15288.00	12250.00	3038.00	10	6	80	5	16	0.504077566231633	0.504077566231633	false	false
e7630087-ad9c-46ea-a90c-f299f57b9ea9	2026-09-23 13:19	2026-09-23 13:19	2026-09-23 13:19	SNX	SNX261016C00300000	call	300.0000	2026-10-16	11.3900	10.6000	11.4000	295.0000	28484.00	28484.00	0.00	25	5	155	466	0.332618025751073	0.446219494678978	0.445880697546224	true	false
82698d99-2e4b-4aac-a26a-1a4bc565cb41	2026-09-08 10:55	2026-09-08 10:55	2026-09-08 10:55	SNX	SNX261016C00270000	call	270.0000	2026-10-16	10.5700	10.0000	10.7000	261.2800	14800.00	14800.00	0.00	14	9	27	26	1.03846153846154	0.416125970718264	0.41011283032183	false	false
a099afde-aae8-4746-a0c2-8f482e32be55	2026-08-28 12:27	2026-08-28 12:27	2026-08-28 12:27	SNX	SNX270319P00200000	put	200.0000	2027-03-19	8.2100	6.6000	9.9000	254.3900	12321.00	3346.00	8975.00	15	7	15	0	0	0.433351217183753	0.433351217183753	false	false	false