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 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts728,802 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active: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	price

5b8a865b-db01-46c7-822e-d7b702e72314	2026-09-28 10:34	2026-09-28 10:33	2026-09-28 10:33	AMZN	AMZN261002P00260000	put	260.0000	2026-10-02	13.4000	12.9500	13.5500	246.8300	26800.00	26800.00	0.00	20	5	372	1364	0.272727272727273	0.352475315209187	0.352475315209187	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2655051085748.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T14:35:37.335936Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
4e203706-61ec-44d3-8e64-bdbd1cd445a8	2026-09-28 10:33	2026-09-28 10:33	2026-09-28 10:33	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	2.0800	2.0600	2.1000	246.9500	23090.00	23090.00	0.00	111	15	3036	34706	0.0874776695672218	0.290628287815167	0.291824277351328	false	false	false	true	false
7ce2b3ad-6c56-4dbf-8c91-aab3db742930	2026-09-28 10:33	2026-09-28 10:32	2026-09-28 10:32	AMZN	AMZN270917C00275000	call	275.0000	2027-09-17	28.5500	28.4500	28.6000	246.8900	42825.00	37115.00	5710.00	15	6	79	237	0.333333333333333	0.362719369428122	0.362719369428122	false	false	false	true	false
b4bab401-53dd-4815-8134-3c8a3c421343	2026-09-28 10:33	2026-09-28 10:32	2026-09-28 10:32	AMZN	AMZN270917C00285000	call	285.0000	2027-09-17	25.1500	25.0000	25.2000	246.8800	22635.00	15090.00	5030.00	9	6	37	253	0.146245059288538	0.361409689517567	0.361409689517567	false	false	false	true	false
6b8330cf-b8d2-4e4f-bcf0-7fc5004b8515	2026-09-28 10:33	2026-09-28 10:32	2026-09-28 10:32	AMZN	AMZN270917C00270000	call	270.0000	2027-09-17	30.3500	30.2500	30.3500	246.8900	21245.00	21245.00	0.00	7	5	30	162	0.185185185185185	0.363033545074026	0.363033545074026	false	false	false	true	false
d98f99c7-9a7b-4838-93e1-7b4c20c819b6	2026-09-28 10:32	2026-09-28 10:32	2026-09-28 10:32	AMZN	AMZN261120C00260000	call	260.0000	2026-11-20	9.3500	9.3000	9.3500	246.9005	18700.00	18700.00	0.00	20	7	479	15010	0.0319120586275816	0.374805762420577	0.374805762420577	false	false	false	true	false
985a1f8b-d678-4123-aa4f-7a946dec8d9d	2026-09-28 10:32	2026-09-28 10:32	2026-09-28 10:32	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	2.1100	2.0800	2.1200	246.8300	25320.00	25320.00	0.00	120	16	2446	810	3.01975308641975	0.329553533762978	0.329553533762978	true	false	false	true	false
358a6a3b-3102-468c-b31c-7990bd691f21	2026-09-28 10:32	2026-09-28 10:32	2026-09-28 10:32	AMZN	AMZN260928P00247500	put	247.5000	2026-09-28	1.1900	1.1800	1.2200	246.8300	24394.00	0.00	24394.00	205	20	2599	2151	1.20827522082752	0.331132669356846	0.326849394355094	true	false	false	true	false
442a1001-5f2b-4534-9c28-1356683d42b3	2026-09-28 10:31	2026-09-28 10:31	2026-09-28 10:31	AMZN	AMZN261002C00245000	call	245.0000	2026-10-02	4.4000	4.4000	4.4500	246.7900	178200.00	0.00	178200.00	405	8	2891	1118	2.58586762075134	0.327853966178713	0.327853966178713	true	false	false	true	false
78d75948-cf3a-4d8d-9591-dbbec8e77bab	2026-09-28 10:31	2026-09-28 10:31	2026-09-28 10:31	AMZN	AMZN261016C00250000	call	250.0000	2026-10-16	5.1000	5.1000	5.1500	246.0000	21930.00	0.00	21930.00	43	5	2847	13626	0.208938793483047	0.289349787138226	0.289349787138226	false	false	false	true	false
e3374102-c0d7-4645-99b2-dad4607239f6	2026-09-28 10:31	2026-09-28 10:30	2026-09-28 10:30	AMZN	AMZN261218C00270000	call	270.0000	2026-12-18	8.7000	8.5500	8.7000	246.0000	43500.00	43500.00	0.00	50	5	638	16016	0.0398351648351648	0.35370196751604	0.35370196751604	false	false	false	true	false
105a4b5a-e52c-4823-9546-2c02a070e796	2026-09-28 10:30	2026-09-28 10:30	2026-09-28 10:30	AMZN	AMZN261002C00245000	call	245.0000	2026-10-02	4.4500	4.4000	4.4500	246.0000	89000.00	89000.00	0.00	200	22	2453	1118	2.19409660107335	0.329870274808152	0.329870274808152	false	false	false	true	false
606ebbcc-66f5-4b23-bcfe-3b27a3e42fc4	2026-09-28 10:29	2026-09-28 10:29	2026-09-28 10:29	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.6400	0.6100	0.6500	246.0000	19320.00	19320.00	0.00	300	11	3499	6498	0.538473376423515	0.340235017285057	0.33822510581521	false	false	false	true	false
b6ca9262-5912-4caf-bfc5-782e46961d91	2026-09-28 10:28	2026-09-28 10:28	2026-09-28 10:28	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	2.1500	2.0900	2.1600	247.0000	88580.00	88365.00	215.00	412	6	4433	11289	0.392683142882452	0.325143007851526	0.325143007851526	true	false	false	true	false
782adbc1-b14e-4bc2-adcd-510979f07c96	2026-09-28 10:25	2026-09-28 10:25	2026-09-28 10:25	AMZN	AMZN260928C00245000	call	245.0000	2026-09-28	2.1500	2.1400	2.2000	246.0000	10535.00	0.00	9245.00	49	7	6544	574	11.4006968641115	0.319046444027638	0.319046444027638	true	false	false	true	false
7246b0cc-6b98-4d5c-bd5c-ff6a22031e4c	2026-09-28 10:25	2026-09-28 10:25	2026-09-28 10:25	AMZN	AMZN260928C00245000	call	245.0000	2026-09-28	2.1400	2.1400	2.2000	246.0000	10914.00	0.00	10914.00	51	8	6595	574	11.4895470383275	0.312285359349518	0.312285359349518	true	false	false	true	false
cb5929b9-f7ff-4b1c-9a72-9f890dca87b2	2026-09-28 10:25	2026-09-28 10:25	2026-09-28 10:25	AMZN	AMZN280616C00320000	call	320.0000	2028-06-16	30.9000	29.5000	30.9500	246.0000	111240.00	108150.00	0.00	36	7	36	827	0.0435308343409915	0.366410625622619	0.366410625622619	false	false	false	true	false
5aa1bd07-1ae3-4faa-b49a-bc2f680ae32c	2026-09-28 10:25	2026-09-28 10:25	2026-09-28 10:25	AMZN	AMZN261002C00255000	call	255.0000	2026-10-02	0.8400	0.8400	0.8600	247.0000	10416.00	0.00	10416.00	124	9	2882	10884	0.264792355751562	0.32651517791382	0.32651517791382	false	false	false	true	false
e02c4fbe-4f56-40ba-951d-a6636f6569a5	2026-09-28 10:25	2026-09-28 10:24	2026-09-28 10:24	AMZN	AMZN260928C00247500	call	247.5000	2026-09-28	0.7100	0.7100	0.7200	247.0000	25205.00	0.00	25205.00	355	12	14039	1076	13.0473977695167	0.360282587787874	0.360282587787874	false	false	false	true	false
dc3eccee-986f-47bd-9bd6-8784808209e4	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	AMZN	AMZN261002C00247500	call	247.5000	2026-10-02	3.2500	3.1000	3.3000	247.0000	12350.00	12350.00	0.00	38	7	1946	1928	1.00933609958506	0.327679142816465	0.327679142816465	true	false	false	true	false
900cc738-ec8d-4e82-bdb3-35645e9c834a	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	AMZN	AMZN260928C00247500	call	247.5000	2026-09-28	0.6800	0.6600	0.6900	247.0000	10318.00	8364.00	1686.00	152	10	13324	1076	12.3828996282528	0.350635178323499	0.350635178323499	false	false	false	true	false
2847327e-01d4-45bc-b681-2a32eca2a1a3	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	AMZN	AMZN261218P00240000	put	240.0000	2026-12-18	11.8500	11.8500	12.2000	246.0000	39105.00	0.00	39105.00	33	10	95	8472	0.0112134088762984	0.352754562084612	0.352754562084612	true	false	false	true	false
aa2a978a-323b-4162-aacf-03ea08187ebd	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	AMZN	AMZN260928C00250000	call	250.0000	2026-09-28	0.1000	0.0900	0.1000	246.0000	10000.00	10000.00	0.00	1000	30	10633	4113	2.58521760272307	0.373513482376557	0.373513482376557	false	false	false	true	false
3debf58a-533f-4700-bc8e-ad0241ba22f5	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	AMZN	AMZN261016C00270000	call	270.0000	2026-10-16	0.7700	0.7700	0.7900	246.0000	22330.00	0.00	22330.00	290	20	3227	30418	0.106088500230127	0.300061261002038	0.300061261002038	false	false	false	true	false
5a2bdd35-8f26-4002-8e01-f343ced74b73	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	AMZN	AMZN261012C00250000	call	250.0000	2026-10-12	4.2300	3.9500	4.2500	246.0000	21130.00	4980.00	0.00	50	5	92	0	0	0.276530167506609	0.281784768087772	false	false	false	true	false
a74a41d9-4a67-48e7-ab36-20cbce256cf4	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	AMZN	AMZN270115C00250000	call	250.0000	2027-01-15	18.5000	18.3500	18.7000	246.0000	46250.00	11100.00	35150.00	25	7	700	34127	0.0205116183666891	0.343299243369627	0.343299243369627	false	false	false	true	false
4f686d66-1527-42fb-abd5-a6acc23eb3b8	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	16.0000	16.0000	16.1500	246.0000	84800.00	0.00	84800.00	53	7	222	13921	0.0159471302348969	0.352799925085994	0.352799925085994	false	false	false	true	false
2123f003-8d2b-4343-b4a9-5f031a8edc04	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	AMZN	AMZN261016C00270000	call	270.0000	2026-10-16	0.7700	0.7700	0.7900	246.0000	13629.00	0.00	13629.00	177	12	2342	30418	0.0769938851995529	0.300530383745742	0.300530383745742	false	false	false	true	false
9bcdeefa-6c66-4da6-94d8-1966859024c5	2026-09-28 10:23	2026-09-28 10:23	2026-09-28 10:23	AMZN	AMZN261016C00270000	call	270.0000	2026-10-16	0.7800	0.7800	0.7900	246.0000	16380.00	0.00	16380.00	210	5	1968	30418	0.0646985337629035	0.301975385586156	0.301975385586156	false	false	false	true	false
8a084b07-bcbe-4369-80e3-1455b141f599	2026-09-28 10:23	2026-09-28 10:23	2026-09-28 10:23	AMZN	AMZN261016C00270000	call	270.0000	2026-10-16	0.7800	0.7800	0.8000	246.0000	68016.00	0.00	68016.00	872	64	1758	30418	0.0577947268064962	0.301925245141003	0.301925245141003	false	false	false	true	false
9461e128-c8fd-4797-acdd-ced61d6f2a46	2026-09-28 10:23	2026-09-28 10:23	2026-09-28 10:23	AMZN	AMZN270617P00175000	put	175.0000	2027-06-17	3.9500	3.9000	4.3000	246.0000	11455.00	2370.00	9085.00	29	8	29	5601	0.005177646848777	0.38123606872673	0.38123606872673	false	false	false	true	false
4a9670dd-8a23-4474-978b-4b107cdaee56	2026-09-28 10:23	2026-09-28 10:23	2026-09-28 10:23	AMZN	AMZN261002C00252500	call	252.5000	2026-10-02	1.2900	1.2400	1.3000	246.0000	13029.00	6063.00	3870.00	101	5	1902	4349	0.437341917682226	0.323620627678414	0.323620627678414	false	false	false	true	false
60a14a3d-f1d7-4d08-9995-1e08a82b4d89	2026-09-28 10:22	2026-09-28 10:22	2026-09-28 10:22	AMZN	AMZN260928C00245000	call	245.0000	2026-09-28	1.9900	1.9900	2.0300	246.0000	15323.00	0.00	15323.00	77	6	5883	574	10.2491289198606	0.318871137942791	0.318871137942791	false	false	false	true	false
e844def0-2c6c-4a97-81fc-c51d97829b15	2026-09-28 10:22	2026-09-28 10:22	2026-09-28 10:22	AMZN	AMZN261218C00270000	call	270.0000	2026-12-18	8.5000	8.5000	8.6500	246.0000	42500.00	0.00	42500.00	50	6	564	16016	0.0352147852147852	0.349989717535686	0.349989717535686	false	false	false	true	false
85196d0e-677d-4b83-8c75-4e2107ef258f	2026-09-28 10:22	2026-09-28 10:22	2026-09-28 10:22	AMZN	AMZN261002C00255000	call	255.0000	2026-10-02	0.7500	0.7500	0.7800	246.5763	11251.00	0.00	11251.00	150	9	2650	10884	0.243476662991547	0.32561709649898	0.327146502218809	false	false	false	true	false
49ae724b-2f93-4533-ba56-584331c3b3b1	2026-09-28 10:19	2026-09-28 10:19	2026-09-28 10:19	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	15.6500	15.6500	15.8000	246.1300	10955.00	0.00	10955.00	7	6	164	13921	0.0117807628762302	0.353924459760608	0.353924459760608	false	false	false	true	false
e456576e-7350-407f-96eb-ea6ebe8df190	2026-09-28 10:19	2026-09-28 10:19	2026-09-28 10:19	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	1.8400	1.8400	1.8700	246.2000	13248.00	0.00	13248.00	72	8	3568	11289	0.316059881300381	0.325155138751572	0.325155138751572	false	false	false	true	false
a8b67932-59b1-4ab7-a2e4-32f962e93094	2026-09-28 10:17	2026-09-28 10:17	2026-09-28 10:17	AMZN	AMZN270115P00175000	put	175.0000	2027-01-15	1.0500	1.0500	1.1100	246.1500	12495.00	0.00	12495.00	119	5	121	9104	0.0132908611599297	0.404467137233331	0.404467137233331	false	false	false	true	false
bc0df570-23a7-4aca-b354-e32545e0eec6	2026-09-28 10:16	2026-09-28 10:16	2026-09-28 10:16	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.7400	1.6800	1.7400	245.9700	16704.00	16704.00	0.00	96	11	1887	810	2.32962962962963	0.330250881993168	0.330250881993168	false	false	false	true	false
019d5f33-4d3a-4849-9bd6-7e4642a505f9	2026-09-28 10:16	2026-09-28 10:16	2026-09-28 10:16	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	0.9400	0.9100	0.9500	245.9700	21997.00	21997.00	0.00	234	18	2163	1348	1.60459940652819	0.334765337903325	0.333153121427057	true	false	false	true	false
1c319c18-c7e9-4864-9c9d-e12b68ea6ae3	2026-09-28 10:15	2026-09-28 10:15	2026-09-28 10:15	AMZN	AMZN261023P00230000	put	230.0000	2026-10-23	1.9500	1.9500	2.0300	246.0100	14625.00	0.00	14625.00	75	8	135	2247	0.0600801068090788	0.303073166297743	0.303073166297743	false	false	false	true	false
48fea84c-6740-442e-9ed9-706fd9bba107	2026-09-28 10:15	2026-09-28 10:15	2026-09-28 10:15	AMZN	AMZN261002C00245000	call	245.0000	2026-10-02	3.9000	3.8000	3.9500	245.8899	78390.00	76440.00	1950.00	201	17	1482	1118	1.32558139534884	0.332820057304197	0.329570954170257	false	false	false	true	false
44dc8614-c447-4e5a-be7a-1c24824ee1bd	2026-09-28 10:15	2026-09-28 10:15	2026-09-28 10:15	AMZN	AMZN261218P00250000	put	250.0000	2026-12-18	17.3500	17.3000	17.6000	245.8433	93690.00	81545.00	12145.00	54	8	140	10332	0.013550135501355	0.354635634945824	0.354635634945824	false	false	false	true	false
ab1e532a-d52d-44a8-a451-b9a43ff7437d	2026-09-28 10:15	2026-09-28 10:15	2026-09-28 10:15	AMZN	AMZN270115C00270000	call	270.0000	2027-01-15	10.5000	10.5000	10.6500	245.9483	370750.00	0.00	370750.00	353	33	447	25957	0.0172207882266826	0.341712557191845	0.341712557191845	false	false	false	true	false
95408a35-1bf6-4a4d-abaa-a26be753efd7	2026-09-28 10:15	2026-09-28 10:15	2026-09-28 10:15	AMZN	AMZN270115C00265000	call	265.0000	2027-01-15	12.1000	12.1000	12.2500	245.9483	922227.00	0.00	922227.00	762	50	1109	6918	0.160306446949986	0.342313184386849	0.342313184386849	false	false	false	true	false
4722658a-5173-430e-8ebb-25362f2121c2	2026-09-28 10:14	2026-09-28 10:14	2026-09-28 10:14	AMZN	AMZN261009C00257500	call	257.5000	2026-10-09	1.5100	1.5000	1.5900	246.3675	19479.00	151.00	19328.00	129	6	2637	499	5.28456913827655	0.300266782535651	0.300266782535651	false	false	false	true	false
11d76ac1-ca9a-4295-a18e-4f6adae16396	2026-09-28 10:13	2026-09-28 10:13	2026-09-28 10:13	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.6000	0.5900	0.6000	246.5000	14100.00	14100.00	0.00	235	7	2652	6498	0.408125577100646	0.345151811416835	0.344589844296657	false	false	false	true	false
b3550f0b-3436-4b80-b901-fb1bb6e39100	2026-09-28 10:12	2026-09-28 10:12	2026-09-28 10:12	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.9500	1.9000	1.9500	246.3650	49335.00	49335.00	0.00	253	21	1642	810	2.02716049382716	0.336344323849378	0.336344323849378	false	false	false	true	false
0211916d-b6e7-44c3-a7ab-491103329cf7	2026-09-28 10:12	2026-09-28 10:12	2026-09-28 10:12	AMZN	AMZN261002C00247500	call	247.5000	2026-10-02	2.9200	2.8600	2.9200	246.3650	24820.00	24820.00	0.00	85	17	1646	1928	0.853734439834025	0.330576420859913	0.330576420859913	true	false	false	true	false
d4681555-ba16-432e-a7d3-ed46721bd242	2026-09-28 10:11	2026-09-28 10:11	2026-09-28 10:11	AMZN	AMZN261009C00257500	call	257.5000	2026-10-09	1.4200	1.4200	1.4900	245.9400	351876.00	0.00	351876.00	2478	64	2507	499	5.02404809619238	0.300160225386646	0.300160225386646	false	false	false	true	false