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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = AMZN×

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

4b89aeeb-a5a9-494f-8f09-2d4cc9214789	2026-09-24 09:50	2026-09-24 09:50	2026-09-24 09:50	AMZN	AMZN261120C00300000	call	300.0000	2026-11-20	2.0000	2.0000	2.0400	246.4600	23600.00	0.00	23600.00	118	9	385	18191	0.0211643120224287	0.380763279322456	0.380763279322456	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2688704384092.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T13:51:23.785124Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
ba1180ea-605b-4793-9277-99706710caf5	2026-09-24 09:48	2026-09-24 09:48	2026-09-24 09:48	AMZN	AMZN270917P00170000	put	170.0000	2027-09-17	4.9500	4.9500	5.1000	246.7600	13860.00	0.00	13860.00	28	9	112	763	0.146788990825688	0.377796000789048	0.377796000789048	false	false	false	true
bc635403-504f-4e91-8c71-6d7ced1ec864	2026-09-24 09:48	2026-09-24 09:47	2026-09-24 09:47	AMZN	AMZN261023C00265000	call	265.0000	2026-10-23	2.5000	2.4700	2.5100	246.6100	29750.00	29750.00	0.00	119	6	1190	5286	0.225122966326145	0.298825361923062	0.298345338315107	false	false	false	true
7405b2c0-b9ce-4d4a-8f4d-028e408829ed	2026-09-24 09:47	2026-09-24 09:46	2026-09-24 09:46	AMZN	AMZN260925P00247500	put	247.5000	2026-09-25	2.3700	2.3700	2.4100	246.5700	11139.00	0.00	11139.00	47	6	1235	4429	0.27884398284037	0.365287814544009	0.365287814544009	false	false	false	true
8df02489-813b-42fd-a618-5b2897c8932e	2026-09-24 09:46	2026-09-24 09:46	2026-09-24 09:46	AMZN	AMZN260928C00252500	call	252.5000	2026-09-28	0.8000	0.7500	0.8100	246.5500	40000.00	40000.00	0.00	500	6	927	3702	0.250405186385737	0.269163615585845	0.269163615585845	false	false	false	true
6b76c3ac-18f3-4ff3-8307-f041f13cdaba	2026-09-24 09:46	2026-09-24 09:46	2026-09-24 09:46	AMZN	AMZN270115P00240000	put	240.0000	2027-01-15	14.1500	14.0000	14.2500	246.5100	45280.00	45280.00	0.00	32	5	34	6728	0.00505350772889417	0.347674333002843	0.347164789818061	false	false	false	true
e2ba02e7-1400-453d-bb0c-c9ee40ab1a8e	2026-09-24 09:45	2026-09-24 09:45	2026-09-24 09:45	AMZN	AMZN261120C00295000	call	295.0000	2026-11-20	2.4800	2.4500	2.5000	246.2300	25264.00	21323.00	3941.00	102	10	148	22772	0.00649920955559459	0.380600397793441	0.380600397793441	false	false	false	true
01b24c6d-b66e-4e4b-816a-fc151905f652	2026-09-24 09:45	2026-09-24 09:45	2026-09-24 09:45	AMZN	AMZN261218C00270000	call	270.0000	2026-12-18	9.0000	9.0000	9.2500	246.2850	34200.00	0.00	34200.00	38	8	157	12545	0.0125149461937027	0.355962675032213	0.355962675032213	false	false	false	true
92bde56c-9b6a-4705-a978-1b6ad413e51d	2026-09-24 09:45	2026-09-24 09:45	2026-09-24 09:45	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	2.1900	2.1400	2.2800	246.3500	55404.00	215.00	55189.00	253	30	453	446	1.01569506726457	0.282420105804642	0.28606407528113	true	false	false	true
01938671-9fc7-4ee5-9dc0-c0ce717cc45a	2026-09-24 09:45	2026-09-24 09:45	2026-09-24 09:45	AMZN	AMZN260925C00247500	call	247.5000	2026-09-25	1.5000	1.4900	1.6000	246.4200	39191.00	0.00	39191.00	261	20	2869	4279	0.670483757887357	0.380801921872616	0.382407286083837	true	false	false	true
c3e90379-b088-492e-b3b2-d1788d7c50af	2026-09-24 09:44	2026-09-24 09:44	2026-09-24 09:44	AMZN	AMZN260928C00250000	call	250.0000	2026-09-28	1.3700	1.3500	1.4100	246.4750	31236.00	137.00	31099.00	228	19	477	1344	0.354910714285714	0.265001936363096	0.265001936363096	true	false	false	true
1c8d4303-81f2-4c7e-b648-42d423cfceb0	2026-09-24 09:44	2026-09-24 09:44	2026-09-24 09:44	AMZN	AMZN260925C00247500	call	247.5000	2026-09-25	1.5500	1.5500	1.5800	246.5540	15810.00	0.00	15810.00	102	6	2573	4279	0.601308716989951	0.383012106634887	0.383012106634887	false	false	false	true
6d2ba530-6783-4942-a796-f896d9daa44a	2026-09-24 09:43	2026-09-24 09:43	2026-09-24 09:43	AMZN	AMZN270115C00300000	call	300.0000	2027-01-15	4.8000	4.8000	4.9000	246.3477	29760.00	0.00	29760.00	62	5	489	65773	0.00743466163927447	0.34842872321413	0.34842872321413	false	false	false	true
5b96d75b-8985-4279-9b2c-8a1037148086	2026-09-24 09:43	2026-09-24 09:42	2026-09-24 09:42	AMZN	AMZN270319C00260000	call	260.0000	2027-03-19	21.0900	21.0500	21.5000	246.5100	75936.00	0.00	75936.00	36	5	42	2702	0.0155440414507772	0.359804100499545	0.360682721976087	false	false	false	true
e7118cd9-0b80-496b-b71d-9e83e3c09396	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	AMZN	AMZN261120C00275000	call	275.0000	2026-11-20	5.7500	5.6500	5.7500	246.7250	89125.00	89125.00	0.00	155	7	305	9645	0.0316226023846553	0.379869629539264	0.379869629539264	false	false	false	true
a7a9f66c-40f9-4102-9dcc-2c51d01ed679	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	AMZN	AMZN261120C00275000	call	275.0000	2026-11-20	5.7500	5.7500	5.8000	246.7800	54625.00	0.00	10925.00	95	6	150	9645	0.015552099533437	0.379406765112938	0.379406765112938	false	false	false	true
d3fce94c-8d1f-4b74-b75b-3c2ff7180d0b	2026-09-24 09:40	2026-09-24 09:40	2026-09-24 09:40	AMZN	AMZN261016P00255000	put	255.0000	2026-10-16	11.5500	11.4000	11.6000	246.9800	25410.00	24255.00	1155.00	22	6	125	7430	0.0168236877523553	0.295465109520817	0.295465109520817	false	false	false	true
aaabc0d4-6994-461f-a945-75d1f0d6d3b0	2026-09-24 09:40	2026-09-24 09:40	2026-09-24 09:40	AMZN	AMZN261016C00300000	call	300.0000	2026-10-16	0.1400	0.1300	0.1400	247.0000	12740.00	12740.00	0.00	910	15	1060	38381	0.0276178317396629	0.365094989775296	0.365027950156097	false	false	false	true
5e328247-5523-4632-b0d4-324ce7c1d119	2026-09-24 09:39	2026-09-24 09:39	2026-09-24 09:39	AMZN	AMZN261002C00245000	call	245.0000	2026-10-02	5.6000	5.6000	5.7500	247.0300	24080.00	0.00	24080.00	43	5	113	665	0.169924812030075	0.302074080785284	0.302074080785284	false	false	false	true
d93c59ba-3f91-4249-b3b9-b76979ee8e19	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	AMZN	AMZN260925C00247500	call	247.5000	2026-09-25	1.8700	1.8600	1.9400	247.0500	31413.00	0.00	31413.00	168	18	2027	4279	0.473708810469736	0.393050607027574	0.399871149041849	false	false	false	true
01655953-96a8-4697-ab2c-7ae97e8fe08f	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	AMZN	AMZN261120C00255000	call	255.0000	2026-11-20	12.0000	11.9000	12.2500	247.1950	13200.00	1200.00	12000.00	11	10	32	19006	0.0016836788382616	0.377612199686342	0.377612199686342	true	false	false	true
35f7e0b5-2e5d-4b49-b8b7-718f402f70d1	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	AMZN	AMZN260925C00250000	call	250.0000	2026-09-25	1.0400	1.0000	1.0400	247.2750	21004.00	20800.00	0.00	202	20	4215	8012	0.52608587119321	0.408662367768088	0.404274676230523	false	false	false	true
47dfcad0-7c55-46a4-a873-84e9e90e27b3	2026-09-24 09:37	2026-09-24 09:36	2026-09-24 09:36	AMZN	AMZN260925C00257500	call	257.5000	2026-09-25	0.1500	0.1400	0.1500	247.3350	10155.00	10155.00	0.00	677	16	7406	14529	0.509739142404846	0.481495086794602	0.481495086794602	false	false	false	true
c7e624f2-6d0f-4a21-b1eb-8b4f3406df89	2026-09-24 09:37	2026-09-24 09:36	2026-09-24 09:36	AMZN	AMZN260925C00250000	call	250.0000	2026-09-25	1.0700	1.0300	1.0700	247.3800	11556.00	11556.00	0.00	108	14	3932	8012	0.490763854218672	0.408035001267638	0.408035001267638	true	false	false	true
963f32d6-dafc-46d9-83f8-7c03d352b28b	2026-09-24 09:36	2026-09-24 09:36	2026-09-24 09:36	AMZN	AMZN261002C00265000	call	265.0000	2026-10-02	0.4700	0.4400	0.4700	247.3300	12634.00	12634.00	0.00	270	10	1159	5577	0.207817823202439	0.331072733451159	0.329324696306449	false	false	false	true
ab995465-cfb0-45eb-8f6a-6adcdbc40eba	2026-09-24 09:36	2026-09-24 09:36	2026-09-24 09:36	AMZN	AMZN260925C00247500	call	247.5000	2026-09-25	1.9800	1.9800	2.0500	247.3800	37830.00	406.00	37424.00	191	33	1711	4279	0.399859780322505	0.396034205086784	0.401841921675044	true	false	false	true
d4f795f5-a2e3-4258-b8dd-3a57179b3712	2026-09-24 09:36	2026-09-24 09:36	2026-09-24 09:36	AMZN	AMZN261218C00230000	call	230.0000	2026-12-18	28.2300	28.2000	29.2500	247.1046	98812.00	0.00	98812.00	35	6	35	4020	0.00870646766169154	0.36919617326906	0.36919617326906	false	false	false	true
01775860-5be8-4ba2-8f6c-aac4e5911a53	2026-09-24 09:36	2026-09-24 09:36	2026-09-24 09:36	AMZN	AMZN260928P00247500	put	247.5000	2026-09-28	2.8400	2.8400	2.9800	247.2000	15052.00	0.00	15052.00	53	9	125	808	0.15470297029703	0.263393511183153	0.265603828747385	true	false	false	true
08251e64-2c0d-4c1e-a052-84e5d4576d7f	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	AMZN	AMZN260925C00257500	call	257.5000	2026-09-25	0.1600	0.1400	0.1600	247.2900	16000.00	16000.00	0.00	1000	46	6231	14529	0.428866405120793	0.491436347314698	0.489884111798597	false	false	false	true
3f810a7b-22dd-4588-be59-e5d31c2eb2ae	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	AMZN	AMZN261002P00242500	put	242.5000	2026-10-02	2.2900	2.1500	2.3800	247.3550	26798.00	1150.00	25648.00	117	29	164	936	0.175213675213675	0.301803533891451	0.303342972633118	true	false	false	true
80abe55e-dce3-4513-b409-560f748797db	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	17.0000	17.0000	17.2500	247.3297	28900.00	0.00	28900.00	17	5	27	12867	0.00209839123338774	0.359844625866373	0.359844625866373	false	false	false	true
46ab2932-6b8e-4a30-976d-9393cef67992	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	AMZN	AMZN260925C00257500	call	257.5000	2026-09-25	0.1600	0.1500	0.1600	247.3297	12800.00	12800.00	0.00	800	10	5024	14529	0.345791176268153	0.488342921488705	0.488342921488705	false	false	false	true
9ad79ea6-d6ab-41d5-aa07-dc113e92be03	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	3.2000	3.2000	3.3000	246.9000	16000.00	0.00	16000.00	50	7	165	3611	0.0456937136527278	0.30458617529845	0.306456746350152	true	false	false	true
887e4646-8258-4574-b1cf-4f378d6893ad	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	AMZN	AMZN261016C00245000	call	245.0000	2026-10-16	8.6000	8.5500	8.9000	246.9600	42140.00	860.00	41280.00	49	24	69	3638	0.0189664650907092	0.301552520568078	0.301552520568078	true	false	false	true
3642a5a5-acdd-47e2-b545-0ac71bd2a042	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	AMZN	AMZN260925C00247500	call	247.5000	2026-09-25	1.8600	1.8000	1.8800	246.9299	37260.00	37260.00	0.00	200	11	1067	4279	0.249357326478149	0.414689824087415	0.408847466850139	false	false	false	true
30a5bcd6-d072-401a-97d1-e98532f510ba	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	AMZN	AMZN261016P00245000	put	245.0000	2026-10-16	6.0000	5.9500	6.2500	246.8899	46200.00	0.00	45600.00	77	8	114	13279	0.00858498380902176	0.298123473522284	0.298123473522284	true	false	false	true
887ea7c7-7405-4900-8368-cb73f772e6eb	2026-09-24 09:33	2026-09-24 09:33	2026-09-24 09:33	AMZN	AMZN261030C00250000	call	250.0000	2026-10-30	11.2500	11.0500	11.5500	246.7000	22500.00	0.00	22500.00	20	8	58	1576	0.0368020304568528	0.397152335059967	0.398355461804463	true	false	false	true
f624e2f8-4fbb-4c9b-9d02-30b0449350b3	2026-09-24 09:33	2026-09-24 09:33	2026-09-24 09:33	AMZN	AMZN260925C00257500	call	257.5000	2026-09-25	0.1300	0.1200	0.1300	246.7450	12896.00	12896.00	0.00	992	20	3072	14529	0.211439190584349	0.489635272828538	0.489635272828538	false	false	false	true
12f00eed-9054-4fc4-8292-d77a7b01975c	2026-09-24 09:33	2026-09-24 09:33	2026-09-24 09:33	AMZN	AMZN260925C00250000	call	250.0000	2026-09-25	1.0200	0.9800	1.0200	246.8700	10098.00	10098.00	0.00	99	9	2654	8012	0.331253120319521	0.431331024645369	0.431331024645369	false	false	false	true
ba7ff298-bd04-4707-afae-692b036c466c	2026-09-24 09:32	2026-09-24 09:32	2026-09-24 09:32	AMZN	AMZN260925P00247500	put	247.5000	2026-09-25	2.5500	2.5200	2.6300	246.5700	25475.00	0.00	25475.00	100	6	595	4429	0.134341837886656	0.394865016309	0.404707916350726	false	false	false	true
2a85befa-87f5-4cd3-88d7-2e1286a8718a	2026-09-23 15:55	2026-09-23 15:55	2026-09-23 15:55	AMZN	AMZN260925C00252500	call	252.5000	2026-09-25	1.2700	1.2700	1.2900	249.3550	11811.00	0.00	11811.00	93	8	18452	5457	3.38134506138904	0.340030792457185	0.340030792457185	false	false	false	true
4d8ae720-74f6-40d8-8f2f-a532bc7d56e4	2026-09-23 15:54	2026-09-23 15:54	2026-09-23 15:54	AMZN	AMZN260925P00247500	put	247.5000	2026-09-25	1.6500	1.5800	1.6500	249.1800	15675.00	15675.00	0.00	95	10	12988	3800	3.41789473684211	0.32984695368839	0.32984695368839	false	false	false	true
f1b81bc1-9c49-4ac7-8155-012bd9aefb3d	2026-09-23 15:54	2026-09-23 15:54	2026-09-23 15:54	AMZN	AMZN261120P00275000	put	275.0000	2026-11-20	30.5000	30.2500	30.5000	249.3020	143350.00	143350.00	0.00	47	7	54	1788	0.0302013422818792	0.379326776145205	0.379326776145205	false	false	false	true
de60b63d-3dc1-4c5a-b054-4a1c2f5e9e7f	2026-09-23 15:54	2026-09-23 15:54	2026-09-23 15:54	AMZN	AMZN261009C00247500	call	247.5000	2026-10-09	7.4000	7.1500	7.4000	249.3000	22200.00	22200.00	0.00	30	10	275	89	3.08988764044944	0.304032717758866	0.300163058202022	true	false	false	true
adbc286c-9dac-4ec3-a9a5-b721e53026ff	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	4.2000	4.0500	4.2000	248.6850	47040.00	47040.00	0.00	112	6	5666	2796	2.02646638054363	0.302089529251471	0.302089529251471	false	false	false	true
5b085a55-c6d7-4e5f-9354-130262ddb3cd	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	AMZN	AMZN270115C00220000	call	220.0000	2027-01-15	39.5900	37.9500	39.6000	248.7150	217738.00	194008.00	0.00	55	6	85	6541	0.0129949548998624	0.38452439588342	0.384998633043402	false	false	false	true
f1939ea0-acec-4392-9c0d-69953d30eaf7	2026-09-23 15:51	2026-09-23 15:51	2026-09-23 15:51	AMZN	AMZN260925C00247500	call	247.5000	2026-09-25	3.2200	3.0000	3.2500	248.7800	160958.00	160958.00	0.00	500	8	10060	829	12.1351025331725	0.339922787668833	0.339349949396295	false	false	false	true
ed17a57d-c88b-4542-8737-e859f58e4ad7	2026-09-23 15:50	2026-09-23 15:50	2026-09-23 15:50	AMZN	AMZN260925P00245000	put	245.0000	2026-09-25	1.0000	1.0000	1.0200	248.5050	14200.00	0.00	14200.00	142	10	9032	8272	1.09187620889749	0.32468074318781	0.32468074318781	false	false	false	true
4f24d850-a84a-4572-9ec0-b783713cae59	2026-09-23 15:50	2026-09-23 15:50	2026-09-23 15:50	AMZN	AMZN260925C00250000	call	250.0000	2026-09-25	1.8600	1.8300	1.8600	248.4700	20088.00	20088.00	0.00	108	17	21611	4029	5.3638620004964	0.343738278978431	0.343738278978431	true	false	false	true
566d251e-d0f9-4d83-9e14-44084a1b6f46	2026-09-23 15:50	2026-09-23 15:50	2026-09-23 15:50	AMZN	AMZN260925C00250000	call	250.0000	2026-09-25	2.0600	2.0000	2.1800	249.0200	10700.00	0.00	10700.00	52	6	21458	4029	5.3258873169521	0.335048655982812	0.330496310583002	false	false	false	true