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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = AMZN271217C00305000×

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

ef183e1f-5242-41f4-9d62-608d5d05d602	2026-09-30 12:11	2026-09-30 12:11	2026-09-30 12:11	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	26.9000	26.8500	27.0500	251.9100	462680.00	94150.00	368530.00	172	20	1745	1065	1.63849765258216	0.359817351675417	0.359817351675417	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2660659968805.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T16:13:44.335833Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
d71589c2-082e-48dd-aac9-a96b0aa2bc4a	2026-09-30 12:10	2026-09-30 12:10	2026-09-30 12:10	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	26.9000	26.7000	27.2000	251.9000	704780.00	279760.00	425020.00	262	11	809	1065	0.75962441314554	0.359898741787663	0.359858046536258	true	false	false	true
5c4999b2-6438-447b-802a-5dab13e23547	2026-09-30 12:10	2026-09-30 12:10	2026-09-30 12:10	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	26.9000	26.8500	27.2000	251.8900	831213.00	94150.00	737063.00	309	24	1118	1065	1.04976525821596	0.359898741787663	0.359898741787663	true	false	false	true
433d3cde-1bb5-4bad-8641-5ad327470cb4	2026-09-30 12:09	2026-09-30 12:09	2026-09-30 12:09	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	26.9000	26.6500	26.9000	251.8600	564900.00	564900.00	0.00	210	6	372	1065	0.349295774647887	0.360224317909365	0.360020829889447	false	false	false	true
cc6cfd12-153f-4a0c-b2ac-a664b9dedf18	2026-09-30 12:09	2026-09-30 12:08	2026-09-30 12:08	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	26.9000	26.5500	27.3500	251.7600	435780.00	430400.00	5380.00	162	6	162	1065	0.152112676056338	0.360427815787336	0.360427815787336	true	false	false	true
5c41ca7b-31b5-4d05-b396-47e0dd383e11	2026-09-28 14:39	2026-09-28 14:39	2026-09-28 14:39	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.4500	24.7500	246.0000	234650.00	200070.00	32110.00	95	20	1595	2073	0.769416304872166	0.360177362638743	0.360177362638743	true	false	false	true
b558215f-f110-4e4b-ab86-b220206391d3	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.5000	24.7500	246.0000	106210.00	2470.00	103740.00	43	5	1368	2073	0.659913169319826	0.360197299926451	0.360197299926451	false	false	false	true
c7d10ff3-24dd-41e6-878c-42f9fdde03fe	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.4500	24.7500	246.6950	456947.00	350737.00	106210.00	185	22	1325	2073	0.639170284611674	0.360237174898342	0.360237174898342	true	false	false	true
3f344e3c-c73b-487a-8554-2db1a10a16be	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.7000	24.7500	246.6950	172900.00	0.00	172900.00	70	6	1056	2073	0.509406657018813	0.360237174898342	0.360237174898342	false	false	false	true
2e6e5462-a268-4410-b16f-5630b97ad94e	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.7000	24.7500	246.6950	207480.00	0.00	207480.00	84	8	1140	2073	0.549927641099855	0.360237174898342	0.360237174898342	false	false	false	true
e111a9ad-4e61-4822-a866-2f9b0cd471cd	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.4500	24.8000	246.6950	1215156.00	1076836.00	138320.00	492	13	958	2073	0.462132175590931	0.360237174898342	0.360237174898342	true	false	false	true
f4f08206-edc5-4dc5-8228-b1f147e94c9a	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.4500	25.1500	246.7000	321097.00	66687.00	254410.00	130	31	136	2073	0.0656054027978775	0.360217237346302	0.360217237346302	true	false	false	true
f1c1d67c-dc37-4b56-9377-a13a8e56fd76	2026-09-28 14:38	2026-09-28 14:38	2026-09-28 14:38	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	24.7000	24.7000	24.8000	246.7000	815100.00	0.00	815100.00	330	7	466	2073	0.224794983116257	0.360217237346302	0.360217237346302	false	false	false	true
14dc396a-b232-44d0-aa4a-63fe4c64e948	2026-09-18 09:51	2026-09-18 09:51	2026-09-18 09:51	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	27.8000	27.6000	28.1000	252.8700	433680.00	417000.00	16680.00	156	8	1172	785	1.49299363057325	0.360024381973569	0.360119394078176	true	false	false	true
f37183ee-2f8f-495b-9a0a-66c20a8bd8bb	2026-09-18 09:51	2026-09-18 09:51	2026-09-18 09:51	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	27.8000	27.6000	27.8000	252.8400	417000.00	417000.00	0.00	150	7	966	785	1.23057324840764	0.360240689223794	0.360240689223794	false	false	false	true
4c5de970-0d12-4652-b0d9-b548b478e349	2026-09-18 09:51	2026-09-18 09:51	2026-09-18 09:51	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	27.8000	27.6500	28.2000	252.8350	194601.00	139000.00	55601.00	70	5	766	785	0.975796178343949	0.360260905419802	0.360350347630111	false	false	false	true
dcd7f37b-eea2-466c-b7ee-fe41617a4145	2026-09-18 09:51	2026-09-18 09:50	2026-09-18 09:50	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	27.8000	27.7000	28.2000	252.8200	350281.00	141780.00	208501.00	126	6	696	785	0.886624203821656	0.360321554588984	0.360321554588984	false	false	false	true
d58f2228-2df7-43fe-9944-57f4bd78c37e	2026-09-18 09:51	2026-09-18 09:50	2026-09-18 09:50	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	27.8000	27.6500	27.8000	252.8200	208500.00	208500.00	0.00	75	5	570	785	0.726114649681529	0.360523724797805	0.360321554588984	false	false	false	true
45ea240a-2093-456a-bc30-396ee8e7750c	2026-09-18 09:49	2026-09-18 09:49	2026-09-18 09:49	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	27.8000	27.5000	28.0500	252.7200	653300.00	230740.00	353060.00	235	16	411	785	0.523566878980892	0.360665249741962	0.360725904756295	true	false	false	true
fea76b5e-fd6d-41fa-878a-734be711c838	2026-09-17 12:10	2026-09-17 12:10	2026-09-17 12:10	AMZN	AMZN271217C00305000	call	305.0000	2027-12-17	27.8000	27.4500	28.1500	251.8900	625525.00	625525.00	0.00	225	10	227	557	0.40754039497307	0.362993750606165	0.362912814661171	false	false	false	true