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 = FloorTradeLargeCap×endpoint = /api/option-trades/flow-alerts×ticker = ZS×

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

27254d94-b701-4236-97a4-a98ba0f1883f	2026-09-23 09:54	2026-09-23 09:54	2026-09-23 09:54	ZS	ZS261016C00185000	call	185.0000	2026-10-16	31.7800	30.4000	33.3000	214.1700	635600.00	0.00	635600.00	200	3	201	735	0.273469387755102	0.566501851472092	0.566501851472092	false	true	true	false	false	FloorTradeLargeCap	85cc2f90-fef8-4e3c-8c5c-01d1ead51af1	1	Common Stock	Technology	34967079986.00	2026-11-24	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T13:55:29.867504Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
74b8eb96-eb15-4fd7-ad21-bd345cdc727f	2026-09-15 12:56	2026-09-15 12:56	2026-09-15 12:56	ZS	ZS261016C00220000	call	220.0000	2026-10-16	5.3000	5.0000	5.7500	195.3400	212000.00	0.00	212000.00	400	1	484	831	0.582430806257521	0.588734093368078	0.588734093368078	false	true	false
65b6bfd6-22d1-4b73-bb7e-8cfe330808b0	2026-09-04 10:13	2026-09-04 10:13	2026-09-04 10:13	ZS	ZS261016C00185000	call	185.0000	2026-10-16	7.0500	6.3500	7.4500	170.6800	141000.00	141000.00	0.00	200	1	259	87	2.97701149425287	0.528588503944909	0.528588503944909	false	true	false
0f2f78d3-7a56-4094-92b8-2b2003ede350	2026-08-24 15:12	2026-08-24 15:11	2026-08-24 15:11	ZS	ZS270617C00150000	call	150.0000	2027-06-17	51.7500	51.7500	55.3000	176.3500	517500.00	0.00	517500.00	100	1	103	233	0.44206008583691	0.594848933946673	0.594848933946673	false	true	false
227fd815-8f4a-41db-9439-169c57a3c6e1	2026-08-20 14:53	2026-08-20 14:52	2026-08-20 14:52	ZS	ZS270115C00230000	call	230.0000	2027-01-15	11.8500	11.3500	12.9500	176.1800	474000.00	0.00	474000.00	400	1	402	1105	0.363800904977376	0.605692659513559	0.605692659513559	false	true	false
bb55f0fd-d716-44a2-8eff-53395d0327f8	2026-08-14 15:58	2026-08-14 15:58	2026-08-14 15:58	ZS	ZS280121C00470000	call	470.0000	2028-01-21	12.3500	10.5000	13.7000	183.5750	123500.00	123500.00	0.00	100	1	100	431	0.232018561484919	0.629682227027819	0.629682227027819	false	true	false