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

81885edb-c971-471e-9030-76827f095778	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	AMZN	AMZN261120C00250000	call	250.0000	2026-11-20	13.6000	13.5500	13.6000	247.5450	10880.00	9520.00	0.00	8	5	714	20998	0.0340032384036575	0.373297716920594	0.373297716920594	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-28T16:28:39.612628Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
2ed12e75-c98e-4c6d-8d0c-3a62ce5b206d	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	AMZN	AMZN261120C00250000	call	250.0000	2026-11-20	13.6000	13.6000	13.8000	247.6025	20400.00	0.00	20400.00	15	5	706	20998	0.0336222497380703	0.372505388973756	0.372505388973756	false	false	false	true
f07e9ebd-e9dc-4a35-8b4e-0e290340a729	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	AMZN	AMZN261106C00250000	call	250.0000	2026-11-06	12.0000	11.5500	12.0000	247.6150	14400.00	14400.00	0.00	12	10	137	94	1.45744680851064	0.390181063167215	0.390181063167215	false	false	false	true
ca4fb36f-6573-48a6-9d33-fb38b93e5ce0	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	AMZN	AMZN261002C00252500	call	252.5000	2026-10-02	1.5000	1.4400	1.5000	247.6000	11700.00	11700.00	0.00	78	5	3662	4349	0.84203265118418	0.322441580803334	0.322441580803334	false	false	false	true
cb6fbd7c-8d87-4c02-baf5-f84d38b70859	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	AMZN	AMZN280121P00230000	put	230.0000	2028-01-21	24.2500	24.1500	24.7500	247.5000	106700.00	51030.00	55670.00	44	6	51	7663	0.00665535690982644	0.361383100527436	0.361893089528294	false	false	false	true
e6bb6c1f-d09e-4d3e-9f2d-2acf706abaab	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	AMZN	AMZN261120P00255000	put	255.0000	2026-11-20	17.4500	17.4500	17.8000	247.0900	148325.00	0.00	148325.00	85	8	175	10819	0.016175247250208	0.36939335836738	0.36939335836738	false	false	false	true
905505d8-48be-40cf-9229-6b00a9a3e348	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	AMZN	AMZN260928P00250000	put	250.0000	2026-09-28	2.8600	2.8600	3.3500	247.0900	11726.00	0.00	11726.00	41	9	1203	2839	0.423740753786545	0.730365620632872	0.730365620632872	false	false	false	true
45449936-a06c-4c28-bbfc-05d9b72ac55c	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	AMZN	AMZN261009C00250000	call	250.0000	2026-10-09	3.9000	3.8500	3.9000	247.0900	39390.00	39390.00	0.00	101	5	978	1895	0.516094986807388	0.296339434868249	0.296339434868249	false	false	false	true
82ff8c54-d0ab-4538-9bae-dcc7cf2db4e8	2026-09-28 12:25	2026-09-28 12:25	2026-09-28 12:25	AMZN	AMZN261009C00247500	call	247.5000	2026-10-09	4.9000	4.7500	4.9500	246.9337	29890.00	19600.00	0.00	61	5	1176	289	4.06920415224914	0.29408155641967	0.29408155641967	false	false	false	true
744ebf3e-8e4f-402f-a1c6-a57012410239	2026-09-28 12:24	2026-09-28 12:24	2026-09-28 12:24	AMZN	AMZN260928C00247500	call	247.5000	2026-09-28	0.3800	0.3700	0.3800	246.9100	13566.00	12806.00	0.00	357	24	42353	1076	39.3615241635688	0.315689709027416	0.315689709027416	false	false	false	true
52e15e2c-bb33-4a70-98ca-d850e73e12a0	2026-09-28 12:21	2026-09-28 12:21	2026-09-28 12:21	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.6400	0.5800	0.6400	247.1400	17216.00	17216.00	0.00	269	34	6883	6498	1.05924899969221	0.328413395335889	0.328413395335889	false	false	false	true
eef39e43-c0bd-40de-8330-1368fb4358f1	2026-09-28 12:21	2026-09-28 12:21	2026-09-28 12:21	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	2.1200	2.1100	2.1600	247.1150	22472.00	0.00	22260.00	106	5	7775	11289	0.688723536185668	0.320363491112806	0.320363491112806	false	false	false	true
92e2a280-372b-48fc-8203-031a76d071ae	2026-09-28 12:20	2026-09-28 12:20	2026-09-28 12:20	AMZN	AMZN261002C00257500	call	257.5000	2026-10-02	0.4900	0.4600	0.4900	246.7600	27097.00	26607.00	0.00	553	64	6791	5388	1.26039346696362	0.334997610837675	0.334305227562261	false	false	false	true
3b8f69e8-089e-43de-87bf-0f828f993f5b	2026-09-28 12:20	2026-09-28 12:20	2026-09-28 12:20	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.5500	0.5200	0.5500	246.7300	19580.00	19580.00	0.00	356	41	6605	6498	1.01646660510926	0.325436649425607	0.325436649425607	false	false	false	true
557127fb-1594-456b-a5e9-774677c86ce7	2026-09-28 12:20	2026-09-28 12:19	2026-09-28 12:19	AMZN	AMZN260928C00247500	call	247.5000	2026-09-28	0.2600	0.2500	0.2600	246.7300	11076.00	10426.00	0.00	426	22	40600	1076	37.7323420074349	0.278525483715248	0.278525483715248	false	false	false	true
8a9ea683-a232-43bf-9153-9bd6bca18d8b	2026-09-28 12:17	2026-09-28 12:17	2026-09-28 12:17	AMZN	AMZN261009C00245000	call	245.0000	2026-10-09	6.0000	5.8500	6.0500	246.5200	22800.00	22200.00	600.00	38	15	329	483	0.681159420289855	0.296259146005939	0.296259146005939	false	false	false	true
03094b0f-fd93-409d-9c62-f2492b28b0d6	2026-09-28 12:16	2026-09-28 12:16	2026-09-28 12:16	AMZN	AMZN261009P00240000	put	240.0000	2026-10-09	2.3500	2.2700	2.3600	246.2200	14805.00	14335.00	470.00	63	8	508	2083	0.243879020643303	0.293506607481808	0.293506607481808	true	false	false	true
4e025c4b-6ef5-4ef0-b2ae-d2d6f3c93e34	2026-09-28 12:16	2026-09-28 12:16	2026-09-28 12:16	AMZN	AMZN261009P00227500	put	227.5000	2026-10-09	0.4400	0.4200	0.4400	246.3350	41096.00	41096.00	0.00	934	38	1228	486	2.52674897119342	0.322177794179354	0.322177794179354	false	false	false	true
5066b482-a2d6-4c9a-b7e3-740aaec2d938	2026-09-28 12:12	2026-09-28 12:12	2026-09-28 12:12	AMZN	AMZN260928C00247500	call	247.5000	2026-09-28	0.1500	0.1500	0.1600	246.1900	11022.00	0.00	11022.00	747	25	38989	1076	36.2351301115242	0.285816307789691	0.278481784573347	true	false	false	true
5e924292-2a0d-4b12-a9b8-1cb82881e84d	2026-09-28 12:12	2026-09-28 12:12	2026-09-28 12:12	AMZN	AMZN260928C00245000	call	245.0000	2026-09-28	1.3500	1.3500	1.3900	246.2300	11610.00	0.00	11610.00	86	5	15182	574	26.4494773519164	0.2518684903142	0.2518684903142	true	false	false	true
fd7c2c43-6a24-4ce3-ab2c-3cd73134dff2	2026-09-28 12:09	2026-09-28 12:09	2026-09-28 12:09	AMZN	AMZN260928C00247500	call	247.5000	2026-09-28	0.1800	0.1700	0.1800	246.3199	18000.00	18000.00	0.00	1000	5	37491	1076	34.842936802974	0.286526642011746	0.286526642011746	false	false	false	true
d997a479-f58c-4cc6-be8e-f7cb70ae6b70	2026-09-28 12:09	2026-09-28 12:09	2026-09-28 12:09	AMZN	AMZN261009P00215000	put	215.0000	2026-10-09	0.1300	0.1200	0.1300	246.3201	13000.00	13000.00	0.00	1000	42	1079	795	1.35723270440252	0.393362897315734	0.393362897315734	true	false	false	true
23367c81-9af1-4500-8100-f5516ff00220	2026-09-28 12:05	2026-09-28 12:05	2026-09-28 12:05	AMZN	AMZN260928P00250000	put	250.0000	2026-09-28	3.7500	3.7500	3.9500	246.1200	20625.00	0.00	20625.00	55	18	1059	2839	0.373018668545262	0.491646243935403	0.491646243935403	false	false	false	true
52463d13-0414-4444-9822-ae4767dd036d	2026-09-28 12:05	2026-09-28 12:05	2026-09-28 12:05	AMZN	AMZN261218C00245000	call	245.0000	2026-12-18	18.0000	17.9500	18.1500	246.1300	41400.00	1800.00	19800.00	23	6	757	3938	0.192229558151346	0.353750497849596	0.353750497849596	false	false	false	true
4e867493-b875-48e0-bf49-c3ff2e21bcbb	2026-09-28 12:04	2026-09-28 12:04	2026-09-28 12:04	AMZN	AMZN281215C00300000	call	300.0000	2028-12-15	45.0000	45.0000	45.4500	246.3400	63000.00	0.00	63000.00	14	6	28	6391	0.00438116100766703	0.369581212620815	0.369581212620815	false	false	false	true
0730a677-926f-4123-bdb6-ae5cd7572e5c	2026-09-28 12:03	2026-09-28 12:03	2026-09-28 12:03	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	15.7000	15.6000	15.7500	246.3200	10990.00	9420.00	0.00	7	5	367	13921	0.0263630486315638	0.352871567446507	0.352871567446507	false	false	false	true
5b5b67d6-008d-4387-9da1-bbb90f260b68	2026-09-28 12:03	2026-09-28 12:02	2026-09-28 12:02	AMZN	AMZN261120C00260000	call	260.0000	2026-11-20	9.0500	9.0000	9.0500	246.3400	27150.00	27150.00	0.00	30	9	18693	15010	1.24536975349767	0.372694695529997	0.372694695529997	false	false	false	true
712fcf55-bbba-402d-976e-62a147eed92e	2026-09-28 12:02	2026-09-28 12:02	2026-09-28 12:02	AMZN	AMZN261218C00300000	call	300.0000	2026-12-18	3.0200	2.9500	3.0500	246.3300	82145.00	33245.00	0.00	272	2	1105	25605	0.0431556336652997	0.356363980590229	0.356363980590229	false	true	false	true
ff273817-233b-4262-bdb8-f90096a42170	2026-09-28 12:02	2026-09-28 12:02	2026-09-28 12:02	AMZN	AMZN290119C00380000	call	380.0000	2029-01-19	27.4500	27.3000	27.9000	246.3100	452925.00	178425.00	274500.00	165	27	934	1229	0.759967453213995	0.365439059084665	0.365128826866798	true	false	false	true
e74dfb93-1ffc-431d-8de2-568d43ddd9f3	2026-09-28 12:02	2026-09-28 12:02	2026-09-28 12:02	AMZN	AMZN261016P00245000	put	245.0000	2026-10-16	5.4000	5.3500	5.4500	246.2700	24828.00	18348.00	0.00	46	5	742	13664	0.0543032786885246	0.287053888223493	0.286590750524524	true	false	false	true
43901255-c228-404c-bb26-59543ca034e2	2026-09-28 12:02	2026-09-28 12:01	2026-09-28 12:01	AMZN	AMZN270115P00230000	put	230.0000	2027-01-15	9.6500	9.5500	9.7000	246.2700	57900.00	46320.00	11580.00	60	9	80	9860	0.00811359026369168	0.342127623289107	0.342127623289107	false	false	false	true
6c4eba5b-444c-45ae-9d88-8f244eed1f96	2026-09-28 11:57	2026-09-28 11:57	2026-09-28 11:57	AMZN	AMZN261218P00255000	put	255.0000	2026-12-18	19.8000	19.7500	19.8000	246.3586	59400.00	59400.00	0.00	30	6	56	2424	0.0231023102310231	0.35201156643357	0.35201156643357	false	false	false	true
57a8e6e3-195d-47a3-9880-eaacd898fba2	2026-09-28 11:56	2026-09-28 11:56	2026-09-28 11:56	AMZN	AMZN261120C00245000	call	245.0000	2026-11-20	15.3500	15.3000	15.4000	246.3400	15350.00	4605.00	3070.00	10	5	1891	3642	0.519220208676551	0.373351276525174	0.373351276525174	false	false	false	true
4464046c-6ad8-4b35-85ed-6d2ade1c70d7	2026-09-28 11:56	2026-09-28 11:55	2026-09-28 11:55	AMZN	AMZN280121P00220000	put	220.0000	2028-01-21	20.6000	20.4500	20.6000	246.4100	32960.00	32960.00	0.00	16	8	847	6602	0.128294456225386	0.362516173639431	0.362516173639431	false	false	false	true
12a85f6c-4669-4164-8b6d-14138b992362	2026-09-28 11:55	2026-09-28 11:55	2026-09-28 11:55	AMZN	AMZN261120P00245000	put	245.0000	2026-11-20	12.4000	12.3500	12.4000	246.4401	13640.00	6200.00	0.00	11	11	1281	7023	0.182400683468603	0.37128593552934	0.37128593552934	false	false	false	true
921d2bff-2c6d-4166-a47e-9029028ab204	2026-09-28 11:54	2026-09-28 11:54	2026-09-28 11:54	AMZN	AMZN261120C00280000	call	280.0000	2026-11-20	4.0700	4.0000	4.1000	246.2900	124135.00	2849.00	121286.00	305	5	1413	12887	0.109645379064173	0.374969995740877	0.374969995740877	false	false	false	true
0649a541-07b1-4ef4-b2c7-0e0bf3606f0b	2026-09-28 11:52	2026-09-28 11:52	2026-09-28 11:52	AMZN	AMZN280121P00220000	put	220.0000	2028-01-21	20.6000	20.4000	20.7000	246.4100	92700.00	92700.00	0.00	45	17	717	6602	0.10860345349894	0.362516173639431	0.362516173639431	false	false	false	true
1e54d171-370d-41d0-b319-72c66dd91c3e	2026-09-28 11:52	2026-09-28 11:51	2026-09-28 11:51	AMZN	AMZN260928C00245000	call	245.0000	2026-09-28	1.5100	1.4500	1.5200	246.3250	32013.00	32013.00	0.00	212	8	14111	574	24.5836236933798	0.298679277697575	0.305280911683672	false	false	false	true
507c8672-7886-4bbb-941c-a5c34d8e9699	2026-09-28 11:51	2026-09-28 11:51	2026-09-28 11:51	AMZN	AMZN261120P00225000	put	225.0000	2026-11-20	5.1000	5.1000	5.2000	246.3101	11730.00	0.00	11730.00	23	8	281	7076	0.039711701526286	0.379120976700208	0.379120976700208	false	false	false	true
19babfc1-0f25-4286-bda2-6896f0c6770b	2026-09-28 11:51	2026-09-28 11:51	2026-09-28 11:51	AMZN	AMZN261120P00230000	put	230.0000	2026-11-20	6.5000	6.4500	6.6000	246.3101	48750.00	26000.00	22750.00	75	5	339	12395	0.027349737797499	0.375962476246516	0.375962476246516	false	false	false	true
6ace139e-8c62-4b7c-a36d-61530b22c31d	2026-09-28 11:51	2026-09-28 11:51	2026-09-28 11:51	AMZN	AMZN270115P00215000	put	215.0000	2027-01-15	5.3500	5.3000	5.4500	246.2895	12840.00	4280.00	6955.00	24	9	2453	8025	0.305669781931464	0.347249796289995	0.347249796289995	false	false	false	true
50506af8-fa93-414a-b815-9b10f04f4345	2026-09-28 11:51	2026-09-28 11:51	2026-09-28 11:51	AMZN	AMZN270115P00215000	put	215.0000	2027-01-15	5.4000	5.3500	5.4500	246.2400	16200.00	6480.00	7020.00	30	8	1624	8025	0.202367601246106	0.348360514357738	0.348360514357738	true	false	false	true
effc71f8-a2ae-46a0-9eb8-cb2181936dde	2026-09-28 11:51	2026-09-28 11:51	2026-09-28 11:51	AMZN	AMZN270115P00215000	put	215.0000	2027-01-15	5.4000	5.3500	5.5000	246.2400	23760.00	5940.00	17820.00	44	10	1574	8025	0.19613707165109	0.348360514357738	0.348360514357738	false	false	false	true
cccee1b1-efd9-44ff-9b0d-fd8476722b10	2026-09-28 11:51	2026-09-28 11:51	2026-09-28 11:51	AMZN	AMZN270115P00215000	put	215.0000	2027-01-15	5.4000	5.3500	5.5000	246.2500	12960.00	8100.00	4860.00	24	8	1424	8025	0.177445482866044	0.348360514357738	0.348412609536547	false	false	false	true
01190f51-2395-4e41-9c6d-8e09e7c8f3f7	2026-09-28 11:51	2026-09-28 11:51	2026-09-28 11:51	AMZN	AMZN270115P00215000	put	215.0000	2027-01-15	5.4000	5.3500	5.5000	246.2400	19980.00	11340.00	8640.00	37	10	1385	8025	0.172585669781931	0.348464699420163	0.348360514357738	true	false	false	true
9730aa9d-fa35-43f3-8948-41dc2076c01c	2026-09-28 11:51	2026-09-28 11:51	2026-09-28 11:51	AMZN	AMZN270115P00215000	put	215.0000	2027-01-15	5.4000	5.4000	5.4500	246.2600	16200.00	0.00	16200.00	30	5	805	8025	0.100311526479751	0.348464699420163	0.348464699420163	false	false	false	true
bbb3eb3b-ed2f-4394-bae3-8116679ca284	2026-09-28 11:51	2026-09-28 11:51	2026-09-28 11:51	AMZN	AMZN261218P00245000	put	245.0000	2026-12-18	14.4500	14.4000	14.5500	246.2800	18785.00	2890.00	15895.00	13	10	210	5055	0.0415430267062315	0.35242172830386	0.35242172830386	true	false	false	true
e00d4327-3a53-42c9-8059-d1d5f98ab855	2026-09-28 11:51	2026-09-28 11:51	2026-09-28 11:51	AMZN	AMZN270115P00215000	put	215.0000	2027-01-15	5.4400	5.4000	5.5000	246.2800	26680.00	17985.00	5425.00	49	16	454	8025	0.0565732087227414	0.349934107958028	0.349934107958028	true	false	false	true
190342cd-5149-4060-82bf-7d2f520381cb	2026-09-28 11:51	2026-09-28 11:50	2026-09-28 11:50	AMZN	AMZN270115P00215000	put	215.0000	2027-01-15	5.4500	5.4000	5.5000	246.3400	11445.00	6540.00	0.00	21	14	133	8025	0.0165732087227414	0.350246933136626	0.350246933136626	false	false	false	true
105edfcf-1137-41f2-8782-bab89d047e8b	2026-09-28 11:50	2026-09-28 11:50	2026-09-28 11:50	AMZN	AMZN290119C00300000	call	300.0000	2029-01-19	46.7000	46.2000	46.9500	246.3200	70047.00	60707.00	9340.00	15	11	28	395	0.0708860759493671	0.370599920446802	0.370599920446802	false	false	false	true