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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 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

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	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:29:42.133638Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
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
ad082890-a808-4f34-a436-e5945f12448a	2026-09-29 10:23	2026-09-29 10:23	2026-09-29 10:23	AMZN	AMZN260930C00245000	call	245.0000	2026-09-30	2.3400	2.2900	2.3400	246.0600	40010.00	40010.00	0.00	171	16	4525	3144	1.43924936386768	0.341339227030475	0.33993698014182	true	false	false	true
1f550cef-df0d-42d8-bad3-8b44c7fb4ca6	2026-09-29 10:23	2026-09-29 10:23	2026-09-29 10:23	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.1100	1.1000	1.1100	246.0150	24975.00	24975.00	0.00	225	5	10412	4759	2.18785459130069	0.336700118996272	0.338231083141687	false	false	false	true
e1c5dec3-dada-4963-bc32-3660b33b768e	2026-09-29 10:22	2026-09-29 10:22	2026-09-29 10:22	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.3000	1.2900	1.3200	245.9500	21450.00	0.00	21320.00	165	9	10081	2639	3.82000757862827	0.340490868542558	0.340490868542558	true	false	false	true
9ff516dd-e707-4718-b652-6bcb1f4bd9a7	2026-09-29 10:22	2026-09-29 10:22	2026-09-29 10:22	AMZN	AMZN261023C00270000	call	270.0000	2026-10-23	1.0900	1.0500	1.0900	245.7702	12208.00	12208.00	0.00	112	7	344	3792	0.0907172995780591	0.296275402322111	0.296275402322111	false	false	false	true
87594203-84e1-4fb9-87ff-dfa74bec22f7	2026-09-29 10:20	2026-09-29 10:20	2026-09-29 10:20	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.4300	1.4000	1.4300	245.7000	16016.00	16016.00	0.00	112	9	9657	2639	3.65934065934066	0.345473212117566	0.345473212117566	false	false	false	true
abda8023-1feb-42c4-83ec-402c836aaafb	2026-09-29 10:20	2026-09-29 10:20	2026-09-29 10:20	AMZN	AMZN261002C00245000	call	245.0000	2026-10-02	3.4000	3.3500	3.4500	245.8300	11220.00	8500.00	1020.00	33	7	491	3413	0.143861705244653	0.329233899827828	0.329233899827828	false	false	false	true
c7eeec04-64a5-4344-96bf-304ce690c0c3	2026-09-29 10:17	2026-09-29 10:17	2026-09-29 10:17	AMZN	AMZN261002P00242500	put	242.5000	2026-10-02	1.4200	1.4100	1.4600	245.9106	23146.00	0.00	17750.00	163	8	837	3434	0.243739079790332	0.320428535672083	0.320428535672083	false	false	false	true
8cafd5f0-f8f4-4e75-b8ed-5dd58d4e63da	2026-09-29 10:17	2026-09-29 10:17	2026-09-29 10:17	AMZN	AMZN261009C00265000	call	265.0000	2026-10-09	0.4400	0.4400	0.4500	245.8950	30492.00	0.00	30492.00	693	31	751	2381	0.315413691726165	0.309593469356802	0.309593469356802	false	false	false	true
15c8096c-ba37-41ad-8a54-a9c40135ed00	2026-09-29 10:17	2026-09-29 10:17	2026-09-29 10:17	AMZN	AMZN261106C00265000	call	265.0000	2026-11-06	5.8000	5.7000	5.8000	245.9240	11020.00	11020.00	0.00	19	5	115	227	0.506607929515419	0.391045088726266	0.391045088726266	false	false	false	true
bdf86d19-fd1c-459d-89ab-d43d9541306f	2026-09-29 10:17	2026-09-29 10:16	2026-09-29 10:16	AMZN	AMZN261106C00265000	call	265.0000	2026-11-06	5.8000	5.7000	5.8000	245.9000	10440.00	3480.00	0.00	18	5	79	227	0.348017621145374	0.391311097755393	0.391311097755393	true	false	false	true
457334d2-5f0e-41a0-86b2-8bb4fa626c58	2026-09-29 10:16	2026-09-29 10:16	2026-09-29 10:16	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.3400	1.3400	1.3600	245.8450	30820.00	0.00	30820.00	230	5	9210	2639	3.48995831754452	0.339824662685001	0.339824662685001	false	false	false	true
a7fff8df-8f91-45b2-8b80-ab0dc6b9a926	2026-09-29 10:15	2026-09-29 10:15	2026-09-29 10:15	AMZN	AMZN261218C00230000	call	230.0000	2026-12-18	26.6000	26.6000	26.9000	246.0700	125020.00	0.00	125020.00	47	6	78	4097	0.0190383207224799	0.358820489951873	0.358820489951873	false	false	false	true
368abcd4-99ca-47f3-b801-23dc7cfac038	2026-09-29 10:15	2026-09-29 10:15	2026-09-29 10:15	AMZN	AMZN270115C00255000	call	255.0000	2027-01-15	15.6500	15.6500	15.7500	246.0900	43820.00	0.00	43820.00	28	9	85	4895	0.017364657814096	0.340068831274702	0.340068831274702	false	false	false	true
1cbc031e-0113-43a6-8414-a22d2b6ef01e	2026-09-29 10:13	2026-09-29 10:13	2026-09-29 10:13	AMZN	AMZN261016C00265000	call	265.0000	2026-10-16	1.0700	1.0400	1.0700	246.1400	14873.00	14873.00	0.00	139	7	1195	22089	0.0540993254561094	0.296754012969232	0.296754012969232	false	false	false	true
d31e3b48-11bc-4252-b036-514255e90559	2026-09-29 10:13	2026-09-29 10:13	2026-09-29 10:13	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.2600	1.2300	1.2600	246.1401	15120.00	15120.00	0.00	120	18	8748	2639	3.31489200454718	0.347760237873897	0.347760237873897	false	false	false	true
3de5a63d-9ad7-4702-863e-fa6f6e4c6d86	2026-09-29 10:13	2026-09-29 10:13	2026-09-29 10:13	AMZN	AMZN270319P00210000	put	210.0000	2027-03-19	7.6500	7.6500	7.8500	246.0000	61997.00	0.00	61997.00	81	5	108	11126	0.00970699262987597	0.362630979361463	0.362630979361463	false	false	false	true
5013e64f-9b36-4345-8c87-a7b9688f134f	2026-09-29 10:12	2026-09-29 10:12	2026-09-29 10:12	AMZN	AMZN261016C00255000	call	255.0000	2026-10-16	2.8600	2.8300	2.9000	245.0000	11726.00	10582.00	1144.00	41	5	393	9649	0.0407296092859364	0.289402187560747	0.289402187560747	false	false	false	true
f7d53728-badf-4530-bc59-251824670371	2026-09-29 10:12	2026-09-29 10:12	2026-09-29 10:12	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.0900	1.0900	1.1000	245.0000	20060.00	440.00	19620.00	184	13	7782	4759	1.63521748266443	0.343398289252134	0.341333493906491	false	false	false	true
480cf388-09b6-4a15-a23a-af0e091abb07	2026-09-29 10:12	2026-09-29 10:12	2026-09-29 10:12	AMZN	AMZN261120C00260000	call	260.0000	2026-11-20	8.7000	8.6500	8.7500	245.0000	84390.00	21750.00	36540.00	97	9	533	32473	0.0164136359437071	0.371234861443845	0.371398535128783	false	false	false	true
8b8ff826-1bb2-4836-9771-3489c31e4f8f	2026-09-29 10:12	2026-09-29 10:11	2026-09-29 10:11	AMZN	AMZN261120C00260000	call	260.0000	2026-11-20	8.7000	8.5000	8.7500	245.0000	49590.00	47850.00	870.00	57	12	412	32473	0.0126874634311582	0.371780368336662	0.371780368336662	true	false	false	true
216056e1-d6d7-4d00-8f35-95ac8ba280c4	2026-09-29 10:12	2026-09-29 10:11	2026-09-29 10:11	AMZN	AMZN261002C00247500	call	247.5000	2026-10-02	2.2100	2.1700	2.2200	245.0000	17901.00	17680.00	0.00	81	9	872	3491	0.249785161844744	0.326730862185718	0.326730862185718	false	false	false	true
ff59cb7b-8822-4226-b883-e75970c240f2	2026-09-29 10:11	2026-09-29 10:11	2026-09-29 10:11	AMZN	AMZN290119C00330000	call	330.0000	2029-01-19	37.5000	36.6500	37.7000	245.0000	37500.00	3750.00	33750.00	10	6	10	362	0.0276243093922652	0.364015190546184	0.364095788709263	false	false	false	true
b49d2181-60ce-4095-b7da-1887e18ae3d2	2026-09-29 10:10	2026-09-29 10:10	2026-09-29 10:10	AMZN	AMZN261120C00290000	call	290.0000	2026-11-20	2.4600	2.4000	2.4700	245.0000	369000.00	210084.00	3690.00	1500	118	1808	16342	0.110635173173418	0.37679414160734	0.376519232754771	false	false	false	true
19c9a32d-8600-48be-973b-d23dfd844332	2026-09-29 10:10	2026-09-29 10:10	2026-09-29 10:10	AMZN	AMZN280121C00390000	call	390.0000	2028-01-21	10.5200	10.4000	10.6000	245.0000	21039.00	7384.00	12600.00	20	14	21	5713	0.00367582706108875	0.356127555260659	0.355700358654534	false	false	false	true
8cf9d5de-1169-4b6e-b1e5-24f7d784f39a	2026-09-29 10:09	2026-09-29 10:09	2026-09-29 10:09	AMZN	AMZN261005C00247500	call	247.5000	2026-10-05	2.6300	2.6200	2.6500	245.6950	20777.00	2630.00	18147.00	79	7	395	484	0.816115702479339	0.268654153087176	0.268654153087176	true	false	false	true
dbad2114-47e9-4102-8cfa-e6e5476f5016	2026-09-29 10:08	2026-09-29 10:08	2026-09-29 10:08	AMZN	AMZN290119C00340000	call	340.0000	2029-01-19	35.0500	35.0500	35.1000	245.6550	108655.00	0.00	108655.00	31	5	82	51	1.6078431372549	0.363628115287359	0.363628115287359	false	false	false	true
52d38c08-cb07-4085-8389-2705e4eeee8d	2026-09-29 10:08	2026-09-29 10:08	2026-09-29 10:08	AMZN	AMZN261120P00200000	put	200.0000	2026-11-20	1.3200	1.3100	1.3500	245.7000	14388.00	132.00	14256.00	109	22	1035	9894	0.104608853850819	0.4083843860199	0.4083843860199	false	false	false	true
4ba1f037-9bba-41b1-8e62-ceeb461cc617	2026-09-29 10:07	2026-09-29 10:07	2026-09-29 10:07	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	15.1500	15.0000	15.2000	245.6020	39390.00	36360.00	3030.00	26	8	342	14102	0.0242518791660757	0.351233648469365	0.351233648469365	false	false	false	true
5ffca633-e4de-4dd8-b83b-01c0c61dcc7d	2026-09-29 10:06	2026-09-29 10:06	2026-09-29 10:06	AMZN	AMZN271217C00350000	call	350.0000	2027-12-17	14.5000	14.2500	14.5000	245.6322	21750.00	21750.00	0.00	15	6	36	5984	0.00601604278074866	0.355911964174745	0.355911964174745	false	false	false	true
68172b96-72d2-4a41-baa1-98cf36ce986f	2026-09-29 10:06	2026-09-29 10:05	2026-09-29 10:05	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.5000	1.4600	1.5100	245.5300	19347.00	19201.00	146.00	129	11	7599	2639	2.87949981053429	0.347850771601525	0.336691147555892	false	false	false	true
13cf6b89-a94c-49b9-8dfe-8780a628640b	2026-09-29 10:04	2026-09-29 10:04	2026-09-29 10:04	AMZN	AMZN271217C00350000	call	350.0000	2027-12-17	14.5000	14.4500	14.5500	245.4300	30450.00	29000.00	1450.00	21	9	21	5984	0.00350935828877005	0.356544485636947	0.356544485636947	false	false	false	true
65ec4ff6-1104-464d-b093-3708e081efd4	2026-09-29 10:04	2026-09-29 10:04	2026-09-29 10:04	AMZN	AMZN261106P00250000	put	250.0000	2026-11-06	14.1000	13.7500	14.1500	245.4087	14100.00	7050.00	5640.00	10	5	25	63	0.396825396825397	0.385933840363976	0.385933840363976	false	false	false	true
38b470da-a61b-46b4-b314-238c010568ad	2026-09-29 10:03	2026-09-29 10:03	2026-09-29 10:03	AMZN	AMZN261016P00232500	put	232.5000	2026-10-16	1.6500	1.6500	1.7300	245.4250	12210.00	0.00	12210.00	74	7	211	893	0.236282194848824	0.299696015651033	0.299696015651033	false	false	false	true
4d1b110a-5f76-4f88-b1bc-01d5f1bf82d0	2026-09-29 10:02	2026-09-29 10:02	2026-09-29 10:02	AMZN	AMZN261120P00200000	put	200.0000	2026-11-20	1.3500	1.3400	1.3900	245.1900	17415.00	0.00	17415.00	129	20	619	9894	0.062563169597736	0.407953093749836	0.407781352650631	false	false	false	true
1a235624-6f39-482c-9bd6-8a6ec62b09e2	2026-09-29 10:02	2026-09-29 10:02	2026-09-29 10:02	AMZN	AMZN271217C00400000	call	400.0000	2027-12-17	8.4000	8.1500	8.4000	245.2250	57120.00	57120.00	0.00	68	14	68	1805	0.0376731301939058	0.358925610155995	0.358925610155995	false	false	false	true
6471845b-1c99-4fcd-90d4-3b3cf8661d59	2026-09-29 10:02	2026-09-29 10:02	2026-09-29 10:02	AMZN	AMZN271217C00390000	call	390.0000	2027-12-17	9.2500	9.2500	9.4500	245.3900	35150.00	0.00	35150.00	38	5	196	1001	0.195804195804196	0.356610308339512	0.356610308339512	false	false	false	true
b98a7aea-ee59-4d0c-9d1b-b08c4bc19b65	2026-09-29 10:01	2026-09-29 10:01	2026-09-29 10:01	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	1.3200	1.2700	1.3200	245.5700	13200.00	13200.00	0.00	100	8	2187	12748	0.171556322560402	0.335588455865377	0.335588455865377	false	false	false	true
98f6c652-9213-41e2-a665-6e2d1e6806f6	2026-09-29 10:00	2026-09-29 10:00	2026-09-29 10:00	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	2.4500	2.4500	2.5200	245.7500	17396.00	246.00	17150.00	71	8	746	4329	0.172326172326172	0.320792665478041	0.321927419330466	false	false	false	true
c07785ee-addd-4b92-9a91-6c2945ed425f	2026-09-29 10:00	2026-09-29 10:00	2026-09-29 10:00	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.5200	1.5200	1.5400	245.5270	21280.00	0.00	21280.00	140	6	5676	2639	2.15081470253884	0.348238085264875	0.348238085264875	false	false	false	true
1d0791b8-b213-4a1d-839a-9389e5bd0c13	2026-09-29 10:00	2026-09-29 09:59	2026-09-29 09:59	AMZN	AMZN270115C00300000	call	300.0000	2027-01-15	4.0000	4.0000	4.1000	245.2600	20400.00	0.00	20400.00	51	8	347	68138	0.00509260618157269	0.340121908012378	0.340403037780416	false	false	false	true
573cf591-1bc3-4e12-98cb-a127cedeee53	2026-09-29 10:00	2026-09-29 09:59	2026-09-29 09:59	AMZN	AMZN261120P00200000	put	200.0000	2026-11-20	1.3600	1.3600	1.4100	245.3299	19448.00	0.00	19448.00	143	15	241	9894	0.0243581968870022	0.40934461766862	0.40934461766862	false	false	false	true
33b453f2-f39a-460a-923f-f661625f229d	2026-09-29 09:59	2026-09-29 09:59	2026-09-29 09:59	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	2.6700	2.6500	2.6900	245.0000	20554.00	7788.00	10363.00	77	14	508	4329	0.117348117348117	0.326103460037304	0.326160010773503	false	false	false	true
668807a6-3680-419e-90b4-08d3df183a2a	2026-09-29 09:59	2026-09-29 09:59	2026-09-29 09:59	AMZN	AMZN261016C00265000	call	265.0000	2026-10-16	1.0000	0.9900	1.0000	245.0000	12100.00	12100.00	0.00	121	5	713	22089	0.0322785096654443	0.297709940227314	0.297709940227314	false	false	false	true
f6ae64d3-c1f0-4f04-a9a8-4c1a491fc81b	2026-09-29 09:59	2026-09-29 09:58	2026-09-29 09:58	AMZN	AMZN280121P00250000	put	250.0000	2028-01-21	34.2000	33.7500	34.5500	245.0000	160740.00	3420.00	157320.00	47	6	47	4848	0.00969471947194719	0.363425761959649	0.363425761959649	false	false	false	true