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:alert_rule = RepeatedHits×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

e875482b-f7c2-4331-9830-30764b18da11	2026-09-24 10:52	2026-09-24 10:52	2026-09-24 10:52	AMZN	AMZN261218C00245000	call	245.0000	2026-12-18	18.9500	18.5500	19.0000	246.8700	24635.00	22740.00	1895.00	13	7	195	3418	0.0570509069631363	0.355717608760081	0.355717608760081	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-24T14:53:28.868411Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
908e25ca-a41b-4d20-a0cc-11dcb7bed3b7	2026-09-24 10:50	2026-09-24 10:50	2026-09-24 10:50	AMZN	AMZN261218P00250000	put	250.0000	2026-12-18	17.3500	17.2750	17.3750	246.5400	107570.00	102365.00	0.00	62	6	366	9869	0.0370858242983078	0.354251233447969	0.354251233447969	false	false	false	true
713eeca7-4d49-445c-9401-0cb52e34a64d	2026-09-24 10:49	2026-09-24 10:49	2026-09-24 10:49	AMZN	AMZN260925P00245000	put	245.0000	2026-09-25	1.1700	1.1700	1.1900	246.0000	16848.00	0.00	16848.00	144	16	12490	10197	1.22487005982152	0.340057942059299	0.340057942059299	true	false	false	true
8b88c0ad-aed5-4024-a85d-e44f64d952a8	2026-09-24 10:49	2026-09-24 10:49	2026-09-24 10:49	AMZN	AMZN260930C00257500	call	257.5000	2026-09-30	0.6000	0.6000	0.6200	246.0000	18540.00	0.00	18540.00	309	28	476	1102	0.431941923774955	0.298203964715299	0.298203964715299	false	false	false	true
42d6e289-f379-497e-988a-a3375d666f64	2026-09-24 10:49	2026-09-24 10:49	2026-09-24 10:49	AMZN	AMZN260930C00260000	call	260.0000	2026-09-30	0.4000	0.4000	0.4200	246.0000	76080.00	0.00	76080.00	1902	53	2218	1827	1.21401204159825	0.307415543465489	0.307415543465489	false	false	false	true
9e262a2e-7c59-4836-afc4-86f5e4fbb598	2026-09-24 10:49	2026-09-24 10:48	2026-09-24 10:48	AMZN	AMZN271217P00220000	put	220.0000	2027-12-17	20.1000	19.8500	20.1000	246.0000	209040.00	209040.00	0.00	104	14	107	3837	0.0278863695595517	0.365702210143545	0.365702210143545	false	false	false	true
f64614e5-3e00-44e6-a498-5baed6702c26	2026-09-24 10:48	2026-09-24 10:48	2026-09-24 10:48	AMZN	AMZN270617C00275000	call	275.0000	2027-06-17	22.2500	21.9000	22.5000	246.0000	22250.00	13350.00	8900.00	10	5	31	3246	0.00955021565003081	0.358210563704593	0.358210563704593	false	false	false	true
845c17db-bf77-4e0a-933c-f82a6c0d1ccf	2026-09-24 10:48	2026-09-24 10:48	2026-09-24 10:48	AMZN	AMZN261218C00265000	call	265.0000	2026-12-18	10.4000	10.3000	10.4500	246.0000	96720.00	7280.00	87360.00	93	7	167	5751	0.029038428099461	0.352807624562863	0.352807624562863	false	false	false	true
27c42301-f0cd-4f5f-8502-c8e53dd0772a	2026-09-24 10:47	2026-09-24 10:47	2026-09-24 10:47	AMZN	AMZN261218P00250000	put	250.0000	2026-12-18	17.4000	17.3000	17.4500	246.0000	106140.00	3480.00	5220.00	61	7	243	9869	0.0246225554767454	0.353294060055288	0.353294060055288	false	false	false	true
6318b834-c2f3-4647-8447-f8cbd4982539	2026-09-24 10:47	2026-09-24 10:47	2026-09-24 10:47	AMZN	AMZN261030C00265000	call	265.0000	2026-10-30	5.6500	5.6000	5.7500	246.0000	418665.00	390415.00	28250.00	741	47	823	541	1.52125693160813	0.392892307766265	0.39260881902846	false	false	false	true
36ba9c4d-f1da-47a3-802f-e73a41ee2cc3	2026-09-24 10:47	2026-09-24 10:47	2026-09-24 10:47	AMZN	AMZN261120C00270000	call	270.0000	2026-11-20	6.6000	6.5000	6.6500	246.0000	1038147.00	1028940.00	9207.00	1573	52	2028	42415	0.0478132736060356	0.373817797423649	0.373369345184324	false	false	false	true
e734fd25-b25c-446f-b5b1-86870e968ec6	2026-09-24 10:46	2026-09-24 10:46	2026-09-24 10:46	AMZN	AMZN260930C00255000	call	255.0000	2026-09-30	0.9000	0.8700	0.9000	246.0000	18810.00	18720.00	0.00	209	22	2023	2777	0.728483975513144	0.290538738971852	0.290538738971852	false	false	false	true
80a2c0c6-3da1-4528-b562-13d9feffdf63	2026-09-24 10:46	2026-09-24 10:46	2026-09-24 10:46	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	16.0500	15.9500	16.2000	246.0750	48150.00	41730.00	6420.00	30	5	1515	12867	0.117743063651201	0.353728593059052	0.353728593059052	false	false	false	true
3be65509-2b0a-4ec7-8547-fa21b4992b84	2026-09-24 10:45	2026-09-24 10:45	2026-09-24 10:45	AMZN	AMZN270115C00300000	call	300.0000	2027-01-15	4.6000	4.5500	4.6500	246.0550	28980.00	0.00	28520.00	63	5	1194	65773	0.0181533455977377	0.344644946921814	0.344644946921814	false	false	false	true
8827de36-b50f-4b21-aa8f-b7415c8adae5	2026-09-24 10:44	2026-09-24 10:44	2026-09-24 10:44	AMZN	AMZN261016P00245000	put	245.0000	2026-10-16	6.1000	6.0000	6.1500	246.1300	37820.00	37210.00	610.00	62	6	432	13279	0.0325325702236614	0.288345379227552	0.288345379227552	true	false	false	true
69cbb52c-f7f8-42b8-847d-ff00afcf711a	2026-09-24 10:35	2026-09-24 10:35	2026-09-24 10:35	AMZN	AMZN260925C00250000	call	250.0000	2026-09-25	0.7500	0.7300	0.7500	246.8650	15000.00	15000.00	0.00	200	15	11512	8012	1.43684473290065	0.369405361119931	0.369405361119931	false	false	false	true
28f95fc7-d9e2-41d5-8f09-a2030517de50	2026-09-24 10:30	2026-09-24 10:29	2026-09-24 10:29	AMZN	AMZN261218P00250000	put	250.0000	2026-12-18	17.2500	17.2000	17.4000	246.6400	120750.00	69000.00	51750.00	70	9	146	9869	0.0147937987638059	0.353143770304076	0.353143770304076	false	false	false	true
e83e9f1d-bfca-4260-af4a-51112029cd3d	2026-09-24 10:29	2026-09-24 10:29	2026-09-24 10:29	AMZN	AMZN260925C00247500	call	247.5000	2026-09-25	1.5200	1.5000	1.5200	246.6850	15200.00	15200.00	0.00	100	10	9460	4279	2.2107969151671	0.365913139511669	0.365913139511669	false	false	false	true
4097e801-c2bf-4445-b26d-b045d01f8baa	2026-09-24 10:28	2026-09-24 10:28	2026-09-24 10:28	AMZN	AMZN280121P00185000	put	185.0000	2028-01-21	9.9500	9.7000	10.0000	246.9600	121390.00	120395.00	0.00	122	15	122	1999	0.0610305152576288	0.370219323763406	0.370219323763406	false	false	false	true
5c6850ae-497f-46e5-80eb-31d7c031320b	2026-09-24 10:27	2026-09-24 10:26	2026-09-24 10:26	AMZN	AMZN261030C00250000	call	250.0000	2026-10-30	11.1500	10.9500	11.1500	246.9950	11150.00	11150.00	0.00	10	5	259	1576	0.164340101522843	0.390382541494591	0.390382541494591	true	false	false	true
3ddd4052-f9fd-4565-a661-07766ace8f34	2026-09-24 10:25	2026-09-24 10:25	2026-09-24 10:25	AMZN	AMZN260930C00255000	call	255.0000	2026-09-30	1.0100	1.0100	1.0600	246.8500	12524.00	0.00	12524.00	124	10	1682	2777	0.605689593086064	0.289499243391864	0.289499243391864	false	false	false	true
d5830dd8-bfad-48f0-a1c7-429a0462b822	2026-09-24 10:22	2026-09-24 10:22	2026-09-24 10:22	AMZN	AMZN270115C00290000	call	290.0000	2027-01-15	6.3000	6.2000	6.4000	246.5300	63000.00	52290.00	9450.00	100	8	168	16535	0.0101602661022074	0.343428363283129	0.343428363283129	false	false	false	true
a8a7f73a-638b-4b6a-b20d-fc10c6be9d46	2026-09-24 10:22	2026-09-24 10:22	2026-09-24 10:22	AMZN	AMZN261016C00265000	call	265.0000	2026-10-16	1.7000	1.6900	1.7000	246.7550	12410.00	12410.00	0.00	73	5	644	21361	0.0301484012920743	0.295790735276883	0.295790735276883	false	false	false	true
64ebd03d-f168-4b5e-afdf-8660138862dc	2026-09-24 10:22	2026-09-24 10:21	2026-09-24 10:21	AMZN	AMZN280121C00350000	call	350.0000	2028-01-21	16.8000	16.7500	17.0000	246.7900	36960.00	26880.00	10080.00	22	8	61	11509	0.00530019984360066	0.357968568718449	0.357968568718449	false	false	false	true
b8931b23-5c14-41ab-a8c4-07f88fbbf3ff	2026-09-24 10:21	2026-09-24 10:21	2026-09-24 10:21	AMZN	AMZN261218C00220000	call	220.0000	2026-12-18	34.9500	34.8000	35.9500	246.9000	20970.00	3495.00	13980.00	6	6	31	2706	0.0114560236511456	0.370499762154142	0.370499762154142	true	false	false	true
9b86a342-f180-4dec-956a-72d24ac92855	2026-09-24 10:21	2026-09-24 10:21	2026-09-24 10:21	AMZN	AMZN260925P00247500	put	247.5000	2026-09-25	2.1100	2.1100	2.1400	246.8890	11183.00	0.00	11183.00	53	5	3070	4429	0.693158726574848	0.349319452099806	0.349319452099806	false	false	false	true
cb589322-42c8-42ee-87a1-8e67039f1870	2026-09-24 10:19	2026-09-24 10:19	2026-09-24 10:19	AMZN	AMZN261016P00260000	put	260.0000	2026-10-16	15.2000	15.0500	15.2000	246.6400	59280.00	1520.00	0.00	39	19	106	8382	0.0126461465044142	0.286018880639888	0.286018880639888	false	false	false	true
58acc8df-0c85-42d2-98bc-415a18fc8ddc	2026-09-24 10:19	2026-09-24 10:19	2026-09-24 10:19	AMZN	AMZN261016C00270000	call	270.0000	2026-10-16	1.0800	1.0600	1.0800	246.6400	17280.00	17280.00	0.00	160	11	1194	30185	0.0395560708961405	0.300540084046504	0.300540084046504	false	false	false	true
fe2d369d-ec21-4640-aaf9-62b7944158df	2026-09-24 10:19	2026-09-24 10:19	2026-09-24 10:19	AMZN	AMZN271217C00350000	call	350.0000	2027-12-17	15.3500	15.0000	15.4000	246.6200	13815.00	10745.00	0.00	9	8	41	5818	0.00704709522172568	0.359981077135813	0.359981077135813	false	false	false	true
f1fdb304-5c44-410e-8c47-15e31aefec0b	2026-09-24 10:18	2026-09-24 10:18	2026-09-24 10:18	AMZN	AMZN261120P00200000	put	200.0000	2026-11-20	1.5200	1.5200	1.5900	246.3600	19456.00	0.00	19456.00	128	27	788	8814	0.089403222146585	0.40863085698572	0.40863085698572	false	false	false	true
0adf2233-cdd4-4aa9-a443-668fb7168d59	2026-09-24 10:17	2026-09-24 10:17	2026-09-24 10:17	AMZN	AMZN261120C00280000	call	280.0000	2026-11-20	4.4000	4.3000	4.4000	245.7964	43962.00	43962.00	0.00	100	6	768	11892	0.0645812310797175	0.376273775001486	0.376273775001486	false	false	false	true
ef566ed8-d931-427b-b971-d83114c32b3b	2026-09-24 10:17	2026-09-24 10:17	2026-09-24 10:17	AMZN	AMZN260925C00245000	call	245.0000	2026-09-25	2.3000	2.2400	2.3000	245.7400	18400.00	18400.00	0.00	80	5	2158	1252	1.72364217252396	0.36927637368118	0.36927637368118	false	false	false	true
ce32bc34-cc23-4bec-be5c-7bf602c918f1	2026-09-24 10:16	2026-09-24 10:16	2026-09-24 10:16	AMZN	AMZN270917P00210000	put	210.0000	2027-09-17	14.3400	14.1000	14.4000	245.8150	119005.00	74620.00	40080.00	83	9	450	1593	0.282485875706215	0.364471566413979	0.364471566413979	false	false	false	true
17b4ea4e-cad9-417b-a863-0b68968ae596	2026-09-24 10:16	2026-09-24 10:16	2026-09-24 10:16	AMZN	AMZN270917P00210000	put	210.0000	2027-09-17	14.3000	14.1000	14.3500	245.8150	22880.00	5720.00	11440.00	16	5	126	1593	0.0790960451977401	0.363795054451803	0.363795054451803	false	false	false	true
52e2b8b0-1b3c-4e45-9bdd-793cdb3db3b5	2026-09-24 10:16	2026-09-24 10:16	2026-09-24 10:16	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	15.9500	15.8500	16.0500	245.8350	79750.00	47850.00	31900.00	50	5	447	12867	0.0347400326416414	0.354246629727941	0.354246629727941	false	false	false	true
2d384e3a-8524-4203-ad4e-64004d940809	2026-09-24 10:14	2026-09-24 10:14	2026-09-24 10:14	AMZN	AMZN261120C00295000	call	295.0000	2026-11-20	2.4500	2.3900	2.4500	246.3850	11270.00	11270.00	0.00	46	7	222	22772	0.00974881433339189	0.379137206584143	0.379137206584143	false	false	false	true
a9e81436-11ff-429b-be4e-ef2d0a49b680	2026-09-24 10:13	2026-09-24 10:13	2026-09-24 10:13	AMZN	AMZN260925C00245000	call	245.0000	2026-09-25	2.6900	2.6900	2.7900	246.4350	18830.00	0.00	18830.00	70	12	1911	1252	1.52635782747604	0.364256355819572	0.364256355819572	true	false	false	true
f03d0ff2-dce5-4a8b-b884-9e3fb71f1d14	2026-09-24 10:13	2026-09-24 10:13	2026-09-24 10:13	AMZN	AMZN270115P00245000	put	245.0000	2027-01-15	16.3500	16.3500	16.7500	246.4000	274680.00	0.00	274680.00	168	13	185	5891	0.03140383636055	0.343425739197017	0.343425739197017	false	false	false	true
a1a35baf-31e2-47ca-a4bf-d07005f925bd	2026-09-24 10:11	2026-09-24 10:11	2026-09-24 10:11	AMZN	AMZN260925P00245000	put	245.0000	2026-09-25	1.3500	1.3200	1.3500	246.0700	11070.00	11070.00	0.00	82	6	9195	10197	0.901735804648426	0.360224455609189	0.360224455609189	true	false	false	true
69dfe37d-fb4a-4f37-a647-a5ed705931b7	2026-09-24 10:11	2026-09-24 10:11	2026-09-24 10:11	AMZN	AMZN261016P00260000	put	260.0000	2026-10-16	15.7500	15.3000	15.8500	246.1300	18900.00	3150.00	6300.00	12	12	64	8382	0.00763540921021236	0.294706072329523	0.294706072329523	true	false	false	true
f154dcc1-380c-48e4-acb4-75e99a80f499	2026-09-24 10:10	2026-09-24 10:10	2026-09-24 10:10	AMZN	AMZN261030C00250000	call	250.0000	2026-10-30	11.0000	10.9000	11.1000	246.5300	16500.00	13200.00	0.00	15	5	176	1576	0.111675126903553	0.39298172383666	0.39298172383666	false	false	false	true
fa550f08-b44e-44aa-b5a3-a8959153ef57	2026-09-24 10:09	2026-09-24 10:09	2026-09-24 10:09	AMZN	AMZN260925C00247500	call	247.5000	2026-09-25	1.5500	1.5300	1.5800	246.6900	13795.00	155.00	13485.00	89	9	6952	4279	1.62467866323907	0.371376822096107	0.371376822096107	false	false	false	true
3d91af73-7b45-4215-af46-e32d130fe400	2026-09-24 10:09	2026-09-24 10:09	2026-09-24 10:09	AMZN	AMZN270115P00225000	put	225.0000	2027-01-15	8.3500	8.3000	8.3500	246.7340	66800.00	66800.00	0.00	80	14	286	13368	0.0213943746259725	0.348523782056258	0.348430252375651	false	false	false	true
69432c80-37cf-434e-949c-6ee621876643	2026-09-24 10:09	2026-09-24 10:09	2026-09-24 10:09	AMZN	AMZN260925C00250000	call	250.0000	2026-09-25	0.7500	0.7400	0.7500	246.7100	19950.00	19950.00	0.00	266	9	8681	8012	1.08349975037444	0.379631918339849	0.379014711739728	true	false	false	true
67f69419-daeb-4c21-96e5-e8f41164f473	2026-09-24 10:09	2026-09-24 10:09	2026-09-24 10:09	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	2.9800	2.9100	2.9900	246.7200	48872.00	48872.00	0.00	164	9	1696	3611	0.469675990030462	0.296591164207336	0.296026954234091	false	false	false	true
55724e5a-85f9-4f4a-a58f-1b4bb4da8338	2026-09-24 10:09	2026-09-24 10:08	2026-09-24 10:08	AMZN	AMZN260925C00247500	call	247.5000	2026-09-25	1.5000	1.5000	1.5300	246.6000	13950.00	0.00	13950.00	93	11	6640	4279	1.55176443094181	0.369245008656529	0.369245008656529	false	false	false	true
e5c7d162-cf0c-46f4-8683-7579048bb047	2026-09-24 10:08	2026-09-24 10:08	2026-09-24 10:08	AMZN	AMZN261120C00290000	call	290.0000	2026-11-20	3.0000	3.0000	3.1000	246.5500	37500.00	0.00	37500.00	125	12	295	16166	0.0182481751824818	0.376169137418402	0.376169137418402	false	false	false	true
9b29a8b8-8e66-410d-bba5-edabad8242b7	2026-09-24 10:08	2026-09-24 10:08	2026-09-24 10:08	AMZN	AMZN261120C00290000	call	290.0000	2026-11-20	3.0000	2.9200	3.1000	246.5850	37500.00	7500.00	300.00	125	8	170	16166	0.0105158975627861	0.375930410415585	0.375930410415585	false	false	false	true
3343e4a3-3c7e-4177-ace1-a3dec769f923	2026-09-24 10:08	2026-09-24 10:08	2026-09-24 10:08	AMZN	AMZN261016P00260000	put	260.0000	2026-10-16	15.5000	15.4000	15.7000	246.4000	15500.00	6200.00	1550.00	10	10	52	8382	0.00620376998329754	0.292259884939335	0.292259884939335	false	false	false	true
d622356e-b963-4101-9410-867f816f084d	2026-09-24 10:08	2026-09-24 10:08	2026-09-24 10:08	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	16.3500	16.2500	16.4500	246.4700	11445.00	4905.00	1635.00	7	5	239	12867	0.0185746483251729	0.355711336752272	0.355711336752272	false	false	false	true