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 = RepeatedHits×option_symbol = AMZN261009P00247500×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

1a839e0b-1baa-4d5b-aa02-00b75adbb530	2026-09-25 13:55	2026-09-25 13:55	2026-09-25 13:55	AMZN	AMZN261009P00247500	put	247.5000	2026-10-09	4.3000	4.2000	4.3500	249.7800	29240.00	28810.00	430.00	68	10	103	327	0.314984709480122	0.284846996374153	0.284846996374153	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2693018909521.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T18:00:15.336636Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
f6fcc815-9d0a-4782-bf7a-a54ca4501476	2026-09-30 15:54	2026-09-30 15:54	2026-09-30 15:54	AMZN	AMZN261009P00247500	put	247.5000	2026-10-09	3.3000	3.1000	3.3500	250.0500	18480.00	16830.00	0.00	56	10	490	487	1.00616016427105	0.29397649172397	0.292933372002983	true	false	false	true
e547f012-c2ac-46d6-bf3b-ad00ac6d1494	2026-10-01 13:04	2026-10-01 13:04	2026-10-01 13:04	AMZN	AMZN261009P00247500	put	247.5000	2026-10-09	3.9000	3.9000	4.0000	247.6050	898170.00	0.00	898170.00	2303	62	2680	654	4.09785932721713	0.277787312196866	0.277787312196866	false	false	false
f2d0a1e0-2a75-45d0-9fa4-d6658cd72a39	2026-10-02 12:57	2026-10-02 12:57	2026-10-02 12:57	AMZN	AMZN261009P00247500	put	247.5000	2026-10-09	2.1000	2.0700	2.1200	251.0700	10500.00	5040.00	840.00	50	8	1258	2853	0.440939362075009	0.267273761001112	0.267273761001112	false	false	false
a75b8951-2517-42e8-b291-0ae922664f72	2026-10-02 13:44	2026-10-02 13:44	2026-10-02 13:44	AMZN	AMZN261009P00247500	put	247.5000	2026-10-09	2.1000	2.1000	2.1100	251.0590	21210.00	0.00	11130.00	101	22	1416	2853	0.496319663512093	0.266982828141233	0.266982828141233	false	false	false
8c57cbdb-8102-4a55-a5ef-7d16ad00faa9	2026-10-02 14:47	2026-10-02 14:47	2026-10-02 14:47	AMZN	AMZN261009P00247500	put	247.5000	2026-10-09	2.2500	2.2000	2.2700	250.0000	20924.00	20700.00	224.00	93	14	1767	2853	0.619348054679285	0.2598863288926	0.258421580729382	true	false	false	true
1769cd67-5cac-4827-a9a6-1735af63a2cd	2026-10-02 15:48	2026-10-02 15:48	2026-10-02 15:48	AMZN	AMZN261009P00247500	put	247.5000	2026-10-09	1.8900	1.8600	1.8900	251.0000	15876.00	15876.00	0.00	84	7	2250	2853	0.788643533123028	0.256288371786568	0.256288371786568	false	false	false	true
dc741587-e012-44a3-acd3-045b68fea6f6	2026-10-02 15:53	2026-10-02 15:53	2026-10-02 15:53	AMZN	AMZN261009P00247500	put	247.5000	2026-10-09	1.7500	1.6900	1.7500	251.8150	15575.00	15575.00	0.00	89	12	2387	2853	0.836663161584297	0.259998513323743	0.258144451466145	true	false	false	true