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:sector = Consumer Cyclical×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

cd7fc8bf-bd41-49e3-b57c-6ec351479b06	2026-09-29 12:48	2026-09-29 12:48	2026-09-29 12:48	AMZN	AMZN261120P00235000	put	235.0000	2026-11-20	7.8500	7.8000	7.8500	247.2350	42390.00	42390.00	0.00	54	11	286	7498	0.0381435049346492	0.375926945269387	0.375926945269387	false	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-29T16:54:42.907148Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
35ed4733-8306-4c6c-8d26-1c677c13cbf6	2026-09-29 12:48	2026-09-29 12:47	2026-09-29 12:47	AMZN	AMZN261002C00247500	call	247.5000	2026-10-02	2.9000	2.8600	2.9000	247.2800	29000.00	29000.00	0.00	100	5	3914	3491	1.12116871956459	0.331822158934841	0.331822158934841	false	false	false	true
df94f4bf-92f7-4205-9015-80a21a93beb8	2026-09-29 12:47	2026-09-29 12:47	2026-09-29 12:47	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	1.8700	1.8700	1.9700	247.0000	18887.00	0.00	18887.00	101	8	6146	4329	1.41972741972742	0.324398820070253	0.324398820070253	false	false	false	true
f1313fd0-13e6-4231-848f-f8050c0027ab	2026-09-29 12:46	2026-09-29 12:46	2026-09-29 12:46	AMZN	AMZN261016C00250000	call	250.0000	2026-10-16	5.1500	5.0500	5.1500	247.0000	17510.00	10300.00	0.00	34	6	2951	12764	0.231197116891257	0.292137417169519	0.292137417169519	false	false	false	true
9052413e-270b-49d0-8fbe-aca91cfdf01a	2026-09-29 12:46	2026-09-29 12:46	2026-09-29 12:46	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.5600	1.5600	1.5800	247.0000	14209.00	0.00	12168.00	91	7	30842	4759	6.48077327169573	0.325516474826001	0.323577546238908	false	false	false	true
50ff3113-49ed-4683-b488-93811c959819	2026-09-29 12:46	2026-09-29 12:46	2026-09-29 12:46	AMZN	AMZN261016C00250000	call	250.0000	2026-10-16	5.1500	5.0500	5.2000	247.0000	11845.00	11845.00	0.00	23	5	2917	12764	0.228533375117518	0.291714773438627	0.291714773438627	false	false	false	true
9a156b91-08b7-4c20-af9e-661f124d4e2a	2026-09-29 12:46	2026-09-29 12:46	2026-09-29 12:46	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.5500	1.5300	1.5600	247.0000	15810.00	15810.00	0.00	102	8	30675	4759	6.44568186593822	0.33319094484724	0.33319094484724	false	false	false	true
4e5da8e9-7d6f-4b7f-993c-630d9cf4fab3	2026-09-29 12:46	2026-09-29 12:45	2026-09-29 12:45	AMZN	AMZN261005C00265000	call	265.0000	2026-10-05	0.1400	0.1300	0.1500	247.0000	10472.00	0.00	10136.00	748	17	947	727	1.30261348005502	0.299095763102486	0.299095763102486	false	false	false	true
f6db4b50-a983-4e70-971d-052e477e900f	2026-09-29 12:45	2026-09-29 12:45	2026-09-29 12:45	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.5200	1.5000	1.5300	247.0000	10184.00	6688.00	0.00	67	5	30557	4759	6.42088674091196	0.331186880576323	0.327361413441424	true	false	false	true
4b1b550d-bbf1-4a45-bce0-146dd111e337	2026-09-29 12:45	2026-09-29 12:45	2026-09-29 12:45	AMZN	AMZN261002C00247500	call	247.5000	2026-10-02	2.7800	2.7500	2.8000	247.0000	10564.00	10564.00	0.00	38	5	3679	3491	1.05385276425093	0.32888559403691	0.32888559403691	false	false	false	true
2d17d29b-a807-4844-93a6-a03093cf4ae0	2026-09-29 12:45	2026-09-29 12:45	2026-09-29 12:45	AMZN	AMZN261218C00290000	call	290.0000	2026-12-18	4.2500	4.2500	4.3500	247.0000	37400.00	0.00	37400.00	88	13	149	5722	0.0260398462076197	0.351124297471956	0.351124297471956	false	false	false	true
ff61991c-b5d6-45e4-ac80-2f1bcc9aa6a5	2026-09-29 12:43	2026-09-29 12:43	2026-09-29 12:43	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.5500	1.5300	1.5500	247.1900	31000.00	31000.00	0.00	200	5	30295	4759	6.36583315822652	0.326750577426987	0.326750577426987	false	false	false	true
ee43b529-d900-4afd-98cd-9744de82ba6b	2026-09-29 12:42	2026-09-29 12:42	2026-09-29 12:42	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	0.6300	0.6300	0.6500	247.1000	12600.00	0.00	12600.00	200	21	20072	3659	5.48565181743646	0.326106988195481	0.326106988195481	false	false	false	true
f46102ed-3342-4958-8ace-de8e84c29ccd	2026-09-29 12:40	2026-09-29 12:40	2026-09-29 12:40	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	1.9400	1.9000	1.9700	246.9750	27741.00	27548.00	193.00	143	10	6012	4329	1.38877338877339	0.322071549956718	0.31933803698431	false	false	false	true
edf76c71-47c5-4b0a-a347-66d5c3c851ba	2026-09-29 12:39	2026-09-29 12:39	2026-09-29 12:39	AMZN	AMZN280121P00240000	put	240.0000	2028-01-21	28.9000	28.9000	29.1000	247.0000	135830.00	0.00	135830.00	47	5	118	3927	0.0300483829895595	0.363834837296066	0.363834837296066	false	false	false	true
6735e699-a249-4b00-bc3a-f3d2cd3088be	2026-09-29 12:36	2026-09-29 12:36	2026-09-29 12:36	AMZN	AMZN290119C00360000	call	360.0000	2029-01-19	31.4000	30.5500	31.9500	247.0000	37680.00	3140.00	34540.00	12	8	24	46	0.521739130434783	0.363787279148291	0.363787279148291	false	false	false	true
cd2ac662-f536-4f5c-bb91-393428253dda	2026-09-29 12:36	2026-09-29 12:36	2026-09-29 12:36	AMZN	AMZN261016P00252500	put	252.5000	2026-10-16	9.0000	8.9000	9.0000	247.0000	12599.00	12599.00	0.00	14	14	70	364	0.192307692307692	0.28970591523395	0.28970591523395	false	false	false	true
72aaa851-4dc3-4b36-a88f-85c9647dac25	2026-09-29 12:35	2026-09-29 12:35	2026-09-29 12:35	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	0.8500	0.8300	0.8700	247.0000	10181.00	0.00	10181.00	120	16	18126	2639	6.86851079954528	0.329000882490186	0.326650940197497	true	false	false	true
3853da2e-bd35-4fad-b39c-9f2270532b73	2026-09-29 12:35	2026-09-29 12:35	2026-09-29 12:35	AMZN	AMZN261016P00242500	put	242.5000	2026-10-16	3.9500	3.9000	4.1000	247.0000	20540.00	395.00	19750.00	52	5	168	673	0.24962852897474	0.291227440500194	0.291227440500194	false	false	false	true
29596fe6-60f9-49a4-9e1d-5762283cc419	2026-09-29 12:35	2026-09-29 12:35	2026-09-29 12:35	AMZN	AMZN261120P00245000	put	245.0000	2026-11-20	12.1000	12.0500	12.2500	247.0000	13310.00	1210.00	12100.00	11	11	381	7982	0.0477323978952643	0.372869155923049	0.37292812079191	false	false	false	true
08c3bbc4-7289-442c-a661-2df077dac3aa	2026-09-29 12:35	2026-09-29 12:35	2026-09-29 12:35	AMZN	AMZN261030C00275000	call	275.0000	2026-10-30	3.0000	3.0000	3.1000	246.0000	55800.00	0.00	55800.00	186	21	801	3671	0.218196676654862	0.395568616024669	0.395568616024669	false	false	false	true
f5d5b63c-de65-4684-b7d8-a955a12688cf	2026-09-29 12:35	2026-09-29 12:35	2026-09-29 12:35	AMZN	AMZN261218P00245000	put	245.0000	2026-12-18	14.1000	14.0500	14.1500	246.0000	11280.00	2820.00	1410.00	8	6	560	5275	0.106161137440758	0.352972080069472	0.352972080069472	false	false	false	true
80554850-0e21-4051-b021-e4e89a2608e4	2026-09-29 12:34	2026-09-29 12:34	2026-09-29 12:34	AMZN	AMZN261030C00275000	call	275.0000	2026-10-30	3.0000	3.0000	3.1000	246.0000	91316.00	0.00	91316.00	304	14	554	3671	0.150912557886135	0.396661374288781	0.395667740505719	false	false	false	true
427b4d2b-fe63-4868-b619-5b59a7a626ab	2026-09-29 12:32	2026-09-29 12:32	2026-09-29 12:32	AMZN	AMZN261002C00247500	call	247.5000	2026-10-02	2.6500	2.5800	2.6500	246.0000	32595.00	32595.00	0.00	123	12	2469	3491	0.707247207103982	0.327270852521899	0.327270852521899	false	false	false	true
34c4b757-ba4b-4402-84c3-8fb315e0b9d1	2026-09-29 12:31	2026-09-29 12:31	2026-09-29 12:31	AMZN	AMZN260930P00247500	put	247.5000	2026-09-30	1.9400	1.9100	1.9900	246.0000	15718.00	15522.00	196.00	81	7	2631	1874	1.40394877267876	0.325861160757548	0.323368287307508	false	false	false	true
7b95847b-4172-451e-a675-5ea7706eebab	2026-09-29 12:31	2026-09-29 12:31	2026-09-29 12:31	AMZN	AMZN271217P00260000	put	260.0000	2027-12-17	38.5900	38.3500	38.6000	246.0000	23154.00	23154.00	0.00	6	5	184	2576	0.0714285714285714	0.368664458364979	0.368664458364979	false	false	false	true
7ba6d06a-561a-4919-815c-637f46ff699c	2026-09-29 12:31	2026-09-29 12:31	2026-09-29 12:31	AMZN	AMZN271217P00260000	put	260.0000	2027-12-17	38.6000	38.4000	38.6500	246.0000	46320.00	38600.00	0.00	12	8	178	2576	0.0690993788819876	0.368664458364979	0.368664458364979	false	false	false	true
3bc63c1a-6e85-4680-9623-9f63500873b6	2026-09-29 12:29	2026-09-29 12:29	2026-09-29 12:29	AMZN	AMZN261218C00270000	call	270.0000	2026-12-18	8.5500	8.4500	8.5500	247.0100	64125.00	64125.00	0.00	75	13	707	16209	0.0436177432290703	0.351138506564357	0.351138506564357	false	false	false	true
0d643546-516d-4b70-8aa0-756af6c9db94	2026-09-29 12:29	2026-09-29 12:29	2026-09-29 12:29	AMZN	AMZN271217P00260000	put	260.0000	2027-12-17	38.6000	38.2000	38.6000	246.9700	77200.00	77200.00	0.00	20	9	142	2576	0.0551242236024845	0.368742100272255	0.368742100272255	false	false	false	true
b903bfb7-0c99-46fd-8296-f02a44f28dea	2026-09-29 12:28	2026-09-29 12:28	2026-09-29 12:28	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.4400	1.4400	1.4500	246.9800	25057.00	145.00	24912.00	174	10	28762	4759	6.04370666106325	0.326815068452035	0.324419194163277	false	false	false	true
20b155ab-f96b-4178-aad4-19fe3da01980	2026-09-29 12:28	2026-09-29 12:27	2026-09-29 12:27	AMZN	AMZN261030P00235000	put	235.0000	2026-10-30	5.8500	5.8000	5.9500	246.9850	10530.00	7605.00	2925.00	18	5	220	2526	0.0870942201108472	0.397276854947481	0.397276854947481	false	false	false	true
a50c5d16-202a-4cd1-b9cc-92173d121f8f	2026-09-29 12:27	2026-09-29 12:27	2026-09-29 12:27	AMZN	AMZN261120C00250000	call	250.0000	2026-11-20	13.2500	13.1000	13.3500	246.9900	23850.00	3975.00	19875.00	18	8	775	21248	0.0364740210843374	0.375488350554055	0.375488350554055	true	false	false	true
88b87920-e64f-4c9f-b6e0-34887755709f	2026-09-29 12:27	2026-09-29 12:27	2026-09-29 12:27	AMZN	AMZN271217P00260000	put	260.0000	2027-12-17	38.5500	38.3500	38.5500	246.9600	73244.00	73244.00	0.00	19	11	114	2576	0.0442546583850932	0.368231469538264	0.368231469538264	false	false	false	true
6f6f2515-8c97-4973-b49a-bd7791ba4826	2026-09-29 12:27	2026-09-29 12:27	2026-09-29 12:27	AMZN	AMZN271217P00250000	put	250.0000	2027-12-17	33.2000	33.2000	33.4000	246.9700	132800.00	0.00	59760.00	40	5	45	2389	0.0188363331938049	0.366940273229601	0.366940273229601	false	false	false	true
d217daf8-e499-4f48-b48f-ea93b7849a89	2026-09-29 12:26	2026-09-29 12:26	2026-09-29 12:26	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.4300	1.4200	1.4300	246.9750	22165.00	22165.00	0.00	155	5	28448	4759	5.977726413112	0.322913541231253	0.322913541231253	false	false	false	true
f9ba3273-8dce-4768-b3fb-125c9f90b885	2026-09-29 12:26	2026-09-29 12:26	2026-09-29 12:26	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	1.9800	1.9800	2.0200	246.8900	25542.00	0.00	25542.00	129	10	5743	4329	1.32663432663433	0.321374814763506	0.321374814763506	false	false	false	true
02ebe0ff-213a-4d40-b8b9-9c4cb57daa21	2026-09-29 12:26	2026-09-29 12:26	2026-09-29 12:26	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	0.9000	0.8900	0.9200	246.9100	11790.00	0.00	9990.00	131	5	17230	2639	6.52898825312618	0.328744281598219	0.330133306774346	true	false	false	true
bc83c8c8-6725-4367-b1f5-00c9be52f192	2026-09-29 12:26	2026-09-29 12:26	2026-09-29 12:26	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.4000	1.4000	1.4100	246.8600	37800.00	0.00	37800.00	270	21	28236	4759	5.93317923933599	0.32718395502975	0.32718395502975	true	false	false	true
201f12ae-ce26-4fa1-b854-0e2fd77a800b	2026-09-29 12:24	2026-09-29 12:24	2026-09-29 12:24	AMZN	AMZN261007C00250000	call	250.0000	2026-10-07	2.8500	2.8300	2.9000	246.8300	28500.00	0.00	28500.00	100	5	313	143	2.18881118881119	0.283624270434519	0.283624270434519	false	false	false	true
1ecfbdec-ab14-454f-9421-58502a1a3609	2026-09-29 12:24	2026-09-29 12:24	2026-09-29 12:24	AMZN	AMZN261120C00250000	call	250.0000	2026-11-20	13.2000	13.1500	13.2500	246.8750	79200.00	63360.00	0.00	60	5	757	21248	0.0356268825301205	0.375722221612463	0.375722221612463	false	false	false	true
b72d0d09-8fd2-42fe-8825-16e97125cf77	2026-09-29 12:24	2026-09-29 12:23	2026-09-29 12:23	AMZN	AMZN261002P00247500	put	247.5000	2026-10-02	3.1500	3.1000	3.2500	246.8500	27090.00	0.00	27090.00	86	7	628	6237	0.100689434022767	0.319362826798114	0.319658025996871	true	false	false	true
7a4d2094-7ae2-4699-bbf1-2845818ef209	2026-09-29 12:22	2026-09-29 12:22	2026-09-29 12:22	AMZN	AMZN260930C00245000	call	245.0000	2026-09-30	2.8000	2.7700	2.8300	246.8531	19600.00	10080.00	5600.00	70	7	9890	3144	3.14567430025445	0.330428244120834	0.330428244120834	true	false	false	true
e12969d6-18f3-4458-8c83-932e70293601	2026-09-29 12:21	2026-09-29 12:21	2026-09-29 12:21	AMZN	AMZN261120C00240000	call	240.0000	2026-11-20	18.3500	18.2500	18.3500	246.8400	27525.00	5505.00	0.00	15	5	387	8273	0.0467786776260123	0.378565846163871	0.378565846163871	false	false	false	true
c312c43c-eac8-4e6f-a35c-2412aa65a8b0	2026-09-29 12:21	2026-09-29 12:20	2026-09-29 12:20	AMZN	AMZN261023C00270000	call	270.0000	2026-10-23	1.2000	1.1700	1.2300	246.7900	16080.00	3000.00	13080.00	134	5	642	3792	0.169303797468354	0.294785481892141	0.294785481892141	false	false	false	true
acbd8e1a-f980-480d-b929-893ef054533b	2026-09-29 12:20	2026-09-29 12:20	2026-09-29 12:20	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	1.6200	1.6200	1.6500	246.7900	34182.00	0.00	34182.00	211	15	8610	12748	0.675400062754942	0.325216745625109	0.325216745625109	true	false	false	true
1753ac87-73d5-4326-acf2-ade29c35f060	2026-09-29 12:20	2026-09-29 12:20	2026-09-29 12:20	AMZN	AMZN281215P00280000	put	280.0000	2028-12-15	58.5400	58.5000	59.3000	246.7900	251718.00	0.00	251718.00	43	5	43	2090	0.0205741626794258	0.387151179065549	0.387151179065549	false	false	false	true
ba2ba274-a209-4022-ae5a-f9a837da09b7	2026-09-29 12:20	2026-09-29 12:20	2026-09-29 12:20	AMZN	AMZN261002C00235000	call	235.0000	2026-10-02	12.1100	11.8000	12.2000	246.7208	24220.00	24220.00	0.00	20	5	475	335	1.41791044776119	0.386766499906951	0.386766499906951	false	false	false	true
471bc188-d16b-4788-9bae-2919117f5334	2026-09-29 12:15	2026-09-29 12:15	2026-09-29 12:15	AMZN	AMZN270917P00215000	put	215.0000	2027-09-17	15.1500	15.1500	15.3000	246.5500	19695.00	0.00	19695.00	13	5	127	1400	0.0907142857142857	0.357401993076147	0.357401993076147	false	false	false	true
2aff7387-5d90-4311-bac9-802bd6e256c2	2026-09-29 12:15	2026-09-29 12:15	2026-09-29 12:15	AMZN	AMZN270917P00215000	put	215.0000	2027-09-17	15.1500	15.1500	15.3000	246.6250	42420.00	0.00	42420.00	28	9	102	1400	0.0728571428571429	0.357642797569005	0.357642797569005	false	false	false	true
2547c246-ef17-49b8-afb6-24abc964584d	2026-09-29 12:15	2026-09-29 12:15	2026-09-29 12:15	AMZN	AMZN270917P00215000	put	215.0000	2027-09-17	15.1500	15.1500	15.3000	246.5900	10605.00	0.00	10605.00	7	6	40	1400	0.0285714285714286	0.357530442541048	0.357530442541048	false	false	false	true