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

309b9228-2bf2-43d0-980c-7017ba4942d6	2026-09-29 10:48	2026-09-29 10:48	2026-09-29 10:48	AMZN	AMZN261005C00245000	call	245.0000	2026-10-05	4.2500	4.2500	4.3500	246.5400	12758.00	0.00	12758.00	30	5	110	158	0.69620253164557	0.264968208548643	0.266593205425159	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	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-29T14:51:17.841886Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
af6c7b2b-5377-49ab-809d-2d43af529f93	2026-09-29 10:47	2026-09-29 10:47	2026-09-29 10:47	AMZN	AMZN270716C00260000	call	260.0000	2027-07-16	29.2000	29.2000	29.7000	246.6100	73000.00	0.00	73000.00	25	6	142	1015	0.139901477832512	0.354303236047985	0.354303236047985	false	false	false	true
8636e61d-1a93-4eb2-8e23-882175a1f92a	2026-09-29 10:46	2026-09-29 10:46	2026-09-29 10:46	AMZN	AMZN261106C00265000	call	265.0000	2026-11-06	6.1000	6.0500	6.2000	246.6850	21350.00	0.00	21350.00	35	10	201	227	0.885462555066079	0.393167007998867	0.393167007998867	false	false	false	true
d43f7dfa-9fb3-43d9-b210-d47eddfa17a7	2026-09-29 10:46	2026-09-29 10:46	2026-09-29 10:46	AMZN	AMZN261106C00265000	call	265.0000	2026-11-06	6.1000	6.1000	6.3000	246.6600	10980.00	0.00	10980.00	18	5	160	227	0.704845814977974	0.393448235341293	0.393448235341293	false	false	false	true
1ff6ff99-4af8-4991-a66c-887b0117accb	2026-09-29 10:44	2026-09-29 10:44	2026-09-29 10:44	AMZN	AMZN261218P00225000	put	225.0000	2026-12-18	6.6500	6.5500	6.6500	246.9100	23940.00	23940.00	0.00	36	5	97	6818	0.0142270460545615	0.361902364457153	0.361902364457153	false	false	false	true
8c8d81c2-ff4e-48db-a5a8-784fc566b9c1	2026-09-29 10:43	2026-09-29 10:43	2026-09-29 10:43	AMZN	AMZN270115C00265000	call	265.0000	2027-01-15	12.3500	12.3500	12.4500	246.7636	98800.00	0.00	98800.00	80	9	119	6390	0.018622848200313	0.342433813717657	0.342433813717657	false	false	false	true
77b2b571-a4c9-4627-a3a9-1271a5d55168	2026-09-29 10:42	2026-09-29 10:42	2026-09-29 10:42	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	15.9500	15.9000	16.0000	246.7600	84535.00	4785.00	70180.00	53	23	562	14102	0.0398525031910367	0.355579485061042	0.355579485061042	false	false	false	true
75528a5d-b0f6-43dc-87b6-73b74dd7fda5	2026-09-29 10:42	2026-09-29 10:42	2026-09-29 10:42	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	16.0000	15.7500	16.0000	246.7600	31990.00	31990.00	0.00	20	8	509	14102	0.0360941710395689	0.356666423351966	0.356666423351966	false	false	false	true
f70e4072-e838-4887-b839-2722406b166f	2026-09-29 10:42	2026-09-29 10:42	2026-09-29 10:42	AMZN	AMZN261120C00260000	call	260.0000	2026-11-20	9.2000	9.1500	9.2500	246.5800	13800.00	10120.00	3680.00	15	5	944	32473	0.029070304560712	0.378074061827339	0.378074061827339	false	false	false	true
3ca358c1-f901-4b21-a1f5-b93e6dfa7708	2026-09-29 10:42	2026-09-29 10:42	2026-09-29 10:42	AMZN	AMZN261120C00255000	call	255.0000	2026-11-20	11.0500	10.9500	11.0500	246.5700	110500.00	110500.00	0.00	100	12	435	19301	0.0225376923475468	0.378539912949133	0.378539912949133	false	false	false	true
7fac741b-a34d-48e7-8770-cdd1d28fe41a	2026-09-29 10:42	2026-09-29 10:41	2026-09-29 10:41	AMZN	AMZN261016P00232500	put	232.5000	2026-10-16	1.5100	1.4700	1.5100	246.6100	18271.00	18271.00	0.00	121	11	334	893	0.374020156774916	0.304741841997573	0.304741841997573	false	false	false	true
5d683eaf-e8c1-45af-8444-3709c7d0d315	2026-09-29 10:41	2026-09-29 10:41	2026-09-29 10:41	AMZN	AMZN261030C00245000	call	245.0000	2026-10-30	12.6900	12.4750	12.7500	246.6500	906035.00	26670.00	879365.00	714	10	764	662	1.15407854984894	0.400499589562657	0.399614675521208	false	false	false	true
837b5bbc-cfea-4101-aa07-e87b59a83563	2026-09-29 10:39	2026-09-29 10:39	2026-09-29 10:39	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	2.1500	2.1500	2.1800	246.4400	29670.00	0.00	29670.00	138	8	2257	4329	0.521367521367521	0.32032414851285	0.32032414851285	false	false	false	true
c609f065-2851-41f9-89cf-d8c89e55a72a	2026-09-29 10:38	2026-09-29 10:38	2026-09-29 10:38	AMZN	AMZN270917C00280000	call	280.0000	2027-09-17	26.2000	25.9500	26.5000	246.2900	39300.00	20960.00	18340.00	15	8	47	703	0.0668563300142248	0.358540250114128	0.358540250114128	false	false	false	true
36b8dd80-c526-4a38-b6e4-816271ca74f7	2026-09-29 10:38	2026-09-29 10:38	2026-09-29 10:38	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	2.2200	2.2000	2.2500	246.3300	11982.00	9546.00	2436.00	54	6	1896	4329	0.437976437976438	0.320990247396816	0.320849915371702	false	false	false	true
277cd0be-5e4c-4e1f-bd7e-f2ad9b5c55a0	2026-09-29 10:38	2026-09-29 10:38	2026-09-29 10:38	AMZN	AMZN270917C00295000	call	295.0000	2027-09-17	21.6000	21.5000	21.6000	246.2560	15120.00	15120.00	0.00	7	7	15	237	0.0632911392405063	0.357481669117059	0.357481669117059	false	false	false	true
16927205-c166-4cc6-87e9-194a38b6d273	2026-09-29 10:38	2026-09-29 10:38	2026-09-29 10:38	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	2.2600	2.2600	2.2800	246.1800	16498.00	0.00	16498.00	73	5	1803	4329	0.416493416493416	0.320504841383748	0.320504841383748	false	false	false	true
2a05f641-9c44-43d2-962b-9a9e62be3d57	2026-09-29 10:37	2026-09-29 10:37	2026-09-29 10:37	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	0.5100	0.5100	0.5300	246.1450	10275.00	0.00	10275.00	200	11	11249	3659	3.07433725061492	0.353634339907658	0.350894195380687	true	false	false	true
441601fe-dc58-4b82-a00b-308564d0fd68	2026-09-29 10:37	2026-09-29 10:37	2026-09-29 10:37	AMZN	AMZN261218P00195000	put	195.0000	2026-12-18	1.6400	1.6400	1.7500	246.1751	27880.00	0.00	27880.00	170	7	186	5167	0.0359976775691891	0.38618708461218	0.38618708461218	false	false	false	true
063145e7-8615-4491-ada8-8163df822674	2026-09-29 10:37	2026-09-29 10:37	2026-09-29 10:37	AMZN	AMZN270115C00260000	call	260.0000	2027-01-15	13.9000	13.8500	14.0500	246.3480	34750.00	4170.00	9730.00	25	5	83	10392	0.0079869130100077	0.341600487643452	0.341600487643452	false	false	false	true
8f5b9ec7-00f5-47f5-bda0-e483527517fb	2026-09-29 10:36	2026-09-29 10:36	2026-09-29 10:36	AMZN	AMZN270115C00275000	call	275.0000	2027-01-15	9.2000	9.0500	9.3500	246.6500	16560.00	0.00	11960.00	18	5	151	64298	0.00234844007589661	0.340643134264083	0.340643134264083	false	false	false	true
b68fdca7-e5b4-447b-a97b-43968839cdb0	2026-09-29 10:36	2026-09-29 10:36	2026-09-29 10:36	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.5100	1.5000	1.5200	246.8400	28087.00	152.00	27935.00	186	8	14499	4759	3.04664845555789	0.349156284803357	0.352420638620748	false	false	false	true
8e8d1f97-3dba-4f8b-9a6f-fcd3c4142502	2026-09-29 10:36	2026-09-29 10:36	2026-09-29 10:36	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	1.7200	1.7200	1.7400	246.9000	30960.00	0.00	30960.00	180	16	4321	12748	0.338955130216505	0.332750054422553	0.332750054422553	true	false	false	true
8d4c74d2-39c1-4ef2-9691-7184f72fe785	2026-09-29 10:36	2026-09-29 10:36	2026-09-29 10:36	AMZN	AMZN261002C00247500	call	247.5000	2026-10-02	2.7100	2.7100	2.7400	246.9000	28455.00	0.00	28455.00	105	8	1353	3491	0.387568032082498	0.33132861170601	0.33132861170601	false	false	false	true
7ad3fbe1-e68f-4560-9928-5c98a8f91dd7	2026-09-29 10:36	2026-09-29 10:36	2026-09-29 10:36	AMZN	AMZN261218C00245000	call	245.0000	2026-12-18	18.4000	18.1500	18.4000	246.8200	11040.00	11040.00	0.00	6	5	140	4398	0.0318326512050932	0.356183176515026	0.356183176515026	false	false	false	true
1e241172-a1c0-4a28-a05a-cd6117a23f8c	2026-09-29 10:36	2026-09-29 10:36	2026-09-29 10:36	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.4500	1.4500	1.4900	246.8000	23498.00	298.00	23200.00	162	7	14120	4759	2.96700987602437	0.350043990736935	0.342204658431349	false	false	false	true
3d062965-c36b-4c6a-8bf3-e59f74e1c86c	2026-09-29 10:36	2026-09-29 10:35	2026-09-29 10:35	AMZN	AMZN261002C00252500	call	252.5000	2026-10-02	1.0000	0.9700	1.0000	246.7700	19800.00	19800.00	0.00	198	6	1109	5638	0.196700957786449	0.334560123106011	0.334560123106011	false	false	false	true
eb2e950d-c7d8-4dfe-b956-d10541225c4b	2026-09-29 10:35	2026-09-29 10:35	2026-09-29 10:35	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	0.6400	0.6200	0.6400	246.7350	10624.00	10624.00	0.00	166	18	9998	3659	2.73244055752938	0.350637855639129	0.350637855639129	false	false	false	true
b2788a27-2d1c-4633-a97e-f377c9a52c6e	2026-09-29 10:34	2026-09-29 10:34	2026-09-29 10:34	AMZN	AMZN270617C00280000	call	280.0000	2027-06-17	20.0500	19.8500	20.0500	246.6400	20050.00	12030.00	0.00	10	6	31	9407	0.00329541830551717	0.353069592558632	0.353069592558632	false	false	false	true
4441c579-2335-4adb-83c1-bc093dad0fba	2026-09-29 10:33	2026-09-29 10:33	2026-09-29 10:33	AMZN	AMZN261005C00247500	call	247.5000	2026-10-05	3.1000	3.0000	3.1500	246.6675	55490.00	55490.00	0.00	179	10	750	484	1.5495867768595	0.271007640981102	0.271007640981102	true	false	false	true
f39aadef-8917-43fe-aee3-f6f9753e6632	2026-09-29 10:33	2026-09-29 10:33	2026-09-29 10:33	AMZN	AMZN261120C00255000	call	255.0000	2026-11-20	10.8500	10.8000	10.9500	246.4500	73780.00	1085.00	72695.00	68	14	311	19301	0.0161131547588208	0.37421048478931	0.374576506340566	false	false	false	true
549f9b0e-62df-43d2-92c4-620be08e7a6e	2026-09-29 10:33	2026-09-29 10:33	2026-09-29 10:33	AMZN	AMZN270115C00265000	call	265.0000	2027-01-15	12.0000	11.9500	12.1500	246.1750	14400.00	2400.00	10800.00	12	10	33	6390	0.00516431924882629	0.340343863424457	0.340343863424457	false	false	false	true
943bd2d3-2e1b-4a3c-8a95-f3302382cf4b	2026-09-29 10:31	2026-09-29 10:31	2026-09-29 10:31	AMZN	AMZN261120P00250000	put	250.0000	2026-11-20	15.0000	14.8500	15.0000	246.3300	18000.00	18000.00	0.00	12	6	385	21313	0.0180640923380097	0.372959704420649	0.372959704420649	true	false	false	true
b612441f-c7c4-4bf4-a448-4a550ca598f7	2026-09-29 10:30	2026-09-29 10:30	2026-09-29 10:30	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.3200	1.3100	1.3300	246.4700	13200.00	11220.00	0.00	100	6	12726	4759	2.67409119562933	0.344470971481811	0.344470971481811	true	false	false	true
671c9b6a-849f-4dfc-8e00-6015dfd8e5d7	2026-09-29 10:30	2026-09-29 10:29	2026-09-29 10:29	AMZN	AMZN270319P00225000	put	225.0000	2027-03-19	11.9600	11.9000	12.0000	246.4250	443612.00	61140.00	382472.00	371	44	387	6679	0.0579428058092529	0.356167385998907	0.356167385998907	false	false	false	true
11e1947f-1cf0-4dc4-bfda-11be4a0c1ef4	2026-09-29 10:29	2026-09-29 10:29	2026-09-29 10:29	AMZN	AMZN261009C00247500	call	247.5000	2026-10-09	4.4500	4.2500	4.5000	246.4550	18245.00	17800.00	445.00	41	8	480	1036	0.463320463320463	0.296245083289818	0.296096180634156	true	false	false	true
da92df47-109f-422e-9a78-e7ce361fd5b1	2026-09-29 10:29	2026-09-29 10:29	2026-09-29 10:29	AMZN	AMZN270115C00300000	call	300.0000	2027-01-15	4.2500	4.1500	4.2500	246.2950	12744.00	12744.00	0.00	30	5	596	68138	0.00874695470956001	0.341626663305322	0.342187047736287	false	false	false	true
aa14e5f7-797a-490d-add4-cebb0df26298	2026-09-29 10:29	2026-09-29 10:29	2026-09-29 10:29	AMZN	AMZN261016C00250000	call	250.0000	2026-10-16	4.8000	4.6500	4.8500	246.4300	12480.00	10560.00	1440.00	26	12	996	12764	0.0780319649012849	0.291739012139575	0.291739012139575	true	false	false	true
d915d211-b5a2-47be-905c-19fa284237c9	2026-09-29 10:29	2026-09-29 10:29	2026-09-29 10:29	AMZN	AMZN261009C00250000	call	250.0000	2026-10-09	3.3500	3.2000	3.4000	246.4366	15410.00	15075.00	0.00	46	14	436	2546	0.171249018067557	0.294022656051974	0.294022656051974	true	false	false	true
41c81dd5-0c1b-497e-b932-3b1a832a48a8	2026-09-29 10:28	2026-09-29 10:28	2026-09-29 10:28	AMZN	AMZN270115C00250000	call	250.0000	2027-01-15	18.0000	17.8500	18.2000	246.2500	163800.00	144000.00	19800.00	91	5	1131	34612	0.032676528371663	0.342220550694563	0.342220550694563	false	false	false	true
79c1d27e-fb9c-4934-944d-c93b6dbfa1ce	2026-09-29 10:28	2026-09-29 10:27	2026-09-29 10:27	AMZN	AMZN260930C00245000	call	245.0000	2026-09-30	2.5700	2.5700	2.6300	246.4350	29041.00	0.00	29041.00	113	13	4938	3144	1.5706106870229	0.339569439391915	0.339569439391915	true	false	false	true
89932550-8805-44e5-92bb-eca97bd32336	2026-09-29 10:27	2026-09-29 10:27	2026-09-29 10:27	AMZN	AMZN270617C00250000	call	250.0000	2027-06-17	31.8000	31.3000	32.5000	246.5100	41340.00	0.00	41340.00	13	5	85	7139	0.0119064294719148	0.358864820317727	0.358864820317727	false	false	false	true
480e4e08-a7b9-4674-8f21-295423a24c5b	2026-09-29 10:27	2026-09-29 10:27	2026-09-29 10:27	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	1.5400	1.4700	1.5400	246.4900	16478.00	16478.00	0.00	107	10	3681	12748	0.288751176655162	0.327671743826886	0.327671743826886	true	false	false	true
bd984a4e-c8b4-4cd3-9b52-e4cb81ade015	2026-09-29 10:27	2026-09-29 10:27	2026-09-29 10:27	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	1.5300	1.4600	1.5300	246.4500	28764.00	28764.00	0.00	188	14	3570	12748	0.280043928459366	0.328046990380953	0.328046990380953	false	false	false	true
26cca5c5-5c38-41a6-a8bc-922f29818800	2026-09-29 10:27	2026-09-29 10:27	2026-09-29 10:27	AMZN	AMZN261002C00247500	call	247.5000	2026-10-02	2.4800	2.3900	2.4800	246.4500	15115.00	15115.00	0.00	61	7	1066	3491	0.305356631337726	0.327911437253907	0.329040987203048	false	false	false	true
fd25ff90-8dfb-41da-a6fc-6254b3ea2640	2026-09-29 10:26	2026-09-29 10:26	2026-09-29 10:26	AMZN	AMZN270115C00300000	call	300.0000	2027-01-15	4.2000	4.1500	4.2000	246.0800	21000.00	21000.00	0.00	50	7	562	68138	0.00824796736035692	0.341893231760046	0.341893231760046	false	false	false	true
3097cd26-6b22-400e-896f-60669e81d52b	2026-09-29 10:25	2026-09-29 10:25	2026-09-29 10:25	AMZN	AMZN261016C00252500	call	252.5000	2026-10-16	3.7000	3.5500	3.7500	246.1100	12210.00	11840.00	0.00	33	7	89	587	0.151618398637138	0.289882881813537	0.289882881813537	false	false	false	true
11187513-dd96-4baf-8099-80b79a837c64	2026-09-29 10:25	2026-09-29 10:25	2026-09-29 10:25	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	0.5000	0.4800	0.5000	246.1100	10000.00	10000.00	0.00	200	12	8317	3659	2.27302541678054	0.350082396130417	0.350082396130417	true	false	false	true
d5ee8d68-c3db-4e9e-a2e1-4ac285779de5	2026-09-29 10:25	2026-09-29 10:25	2026-09-29 10:25	AMZN	AMZN261016P00250000	put	250.0000	2026-10-16	8.0000	7.9500	8.0500	246.0850	10400.00	1600.00	800.00	13	5	119	14570	0.00816746739876459	0.287079634420152	0.287079634420152	false	false	false	true
fe2f3048-dff2-4625-b660-5dbc64a8f1d3	2026-09-29 10:24	2026-09-29 10:24	2026-09-29 10:24	AMZN	AMZN280121P00260000	put	260.0000	2028-01-21	39.6500	39.6500	40.0000	245.9100	182390.00	0.00	182390.00	46	7	46	2638	0.0174374526156179	0.366647655943471	0.366647655943471	false	false	false	true