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 rows

Sources in this table

uw_flow_alerts728,802 rows

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

4225fd27-184c-4d85-a4e4-6f6209296e64	2026-09-29 14:00	2026-09-29 14:00	2026-09-29 14:00	AMZN	AMZN280616C00270000	call	270.0000	2028-06-16	46.2000	45.2000	46.2000	246.7400	101640.00	101640.00	0.00	22	6	40	1074	0.037243947858473	0.366280675432961	0.366280675432961	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-29T18:00:33.837310Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
e6b34e50-e6ce-4b9b-9649-35071777d695	2026-09-29 13:58	2026-09-29 13:58	2026-09-29 13:58	AMZN	AMZN261002P00240000	put	240.0000	2026-10-02	0.7300	0.7300	0.7700	246.5400	12557.00	74.00	12483.00	172	14	2559	9795	0.261255742725881	0.332100603200232	0.332100603200232	false	false	false	true
af3b59f3-1105-492d-8679-38c01968f440	2026-09-29 13:52	2026-09-29 13:52	2026-09-29 13:52	AMZN	AMZN270115C00230000	call	230.0000	2027-01-15	29.5000	29.3000	29.5750	246.6800	109150.00	2950.00	106200.00	37	6	97	10082	0.00962110692322952	0.351383620695672	0.351383620695672	false	false	false	true
e7235a09-b90f-4117-8e4d-7500abd2914f	2026-09-29 13:50	2026-09-29 13:50	2026-09-29 13:50	AMZN	AMZN261002C00225000	call	225.0000	2026-10-02	22.0000	21.7000	22.3500	246.7400	88017.00	2235.00	85782.00	40	5	1092	346	3.15606936416185	0.580058747682132	0.717988589112016	false	false	false	true
7b95dd83-e48d-4502-b081-232e8a21ca9f	2026-09-29 13:50	2026-09-29 13:50	2026-09-29 13:50	AMZN	AMZN261002C00242500	call	242.5000	2026-10-02	5.6800	5.5000	5.7500	246.7400	11360.00	11360.00	0.00	20	5	934	779	1.198973042362	0.344185700390258	0.344185700390258	false	false	false	true
1f74aaab-5d0e-42e3-a9bc-4e6e75c5ac57	2026-09-29 13:50	2026-09-29 13:50	2026-09-29 13:50	AMZN	AMZN261002C00235000	call	235.0000	2026-10-02	12.1800	11.7500	12.3000	246.7850	24360.00	24360.00	0.00	20	5	2239	335	6.68358208955224	0.390068692134363	0.390068692134363	false	false	false	true
49066b35-0679-4dca-a81a-1db89bf3b25a	2026-09-29 13:50	2026-09-29 13:50	2026-09-29 13:50	AMZN	AMZN261002C00235000	call	235.0000	2026-10-02	12.1400	11.7500	12.3000	246.7200	48540.00	48540.00	0.00	40	5	2119	335	6.32537313432836	0.395929919138227	0.392993190985311	false	false	false	true
1a9e499b-f2ce-47dd-8bd9-56d1b1f0fcde	2026-09-29 13:49	2026-09-29 13:49	2026-09-29 13:49	AMZN	AMZN261002C00237500	call	237.5000	2026-10-02	9.8000	9.5500	9.9500	246.7450	19600.00	19600.00	0.00	20	5	742	214	3.46728971962617	0.363357348213933	0.363357348213933	false	false	false	true
9674ceeb-8511-4329-afc8-412cdce11222	2026-09-29 13:45	2026-09-29 13:45	2026-09-29 13:45	AMZN	AMZN261002C00252500	call	252.5000	2026-10-02	1.0500	1.0400	1.0700	246.8700	20475.00	17220.00	3255.00	195	7	2817	5638	0.499645264278113	0.33839395313696	0.33839395313696	false	false	false	true
c641cd90-8b20-44df-aec5-3c3fac58760a	2026-09-29 13:45	2026-09-29 13:45	2026-09-29 13:45	AMZN	AMZN270115P00205000	put	205.0000	2027-01-15	3.4900	3.4000	3.6000	246.9300	45698.00	0.00	45698.00	131	6	273	8363	0.032643788114313	0.358661102535974	0.358661102535974	false	false	false	true
771f52f1-5611-48ee-ace4-3bc4181ead6d	2026-09-29 13:43	2026-09-29 13:43	2026-09-29 13:43	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.2200	0.2200	0.2300	246.6901	14102.00	0.00	14102.00	641	44	9345	8004	1.16754122938531	0.348155827679873	0.348155827679873	false	false	false	true
2d850923-9fd3-4b00-bf7b-eaea36770f71	2026-09-29 13:40	2026-09-29 13:40	2026-09-29 13:40	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.5200	1.5000	1.5200	247.1500	21281.00	21281.00	0.00	140	5	37651	4759	7.91153603698256	0.324613356773241	0.326555496809299	false	false	false	true
76bfd4a7-ed1e-4653-9fb8-00bac67268b7	2026-09-29 13:40	2026-09-29 13:40	2026-09-29 13:40	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.4800	1.4800	1.5100	247.0800	14950.00	150.00	14800.00	101	7	37503	4759	7.88043706661063	0.327115319522738	0.323224962810025	false	false	false	true
96bbb109-fa14-42cc-9847-a7763b7f7237	2026-09-29 13:40	2026-09-29 13:39	2026-09-29 13:39	AMZN	AMZN261016C00250000	call	250.0000	2026-10-16	5.1000	4.9500	5.1000	247.0800	82620.00	82620.00	0.00	162	6	3351	12764	0.262535255405829	0.292876704318166	0.292343568261609	false	false	false	true
269097a3-4e03-4714-b60a-1761fd8acb58	2026-09-29 13:40	2026-09-29 13:39	2026-09-29 13:39	AMZN	AMZN260930P00247500	put	247.5000	2026-09-30	1.9200	1.9200	1.9600	247.0000	13824.00	0.00	13824.00	72	12	5688	1874	3.03521878335112	0.324076274556896	0.324076274556896	true	false	false	true
0e9911c8-18a1-413d-8d43-2b4eaaa9af47	2026-09-29 13:35	2026-09-29 13:35	2026-09-29 13:35	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.5400	1.4800	1.5400	247.0600	15400.00	15400.00	0.00	100	6	36732	4759	7.71842824122715	0.33670999829198	0.33670999829198	false	false	false	true
9b77d88e-4a37-4964-821a-b871533a9ff6	2026-09-29 13:34	2026-09-29 13:34	2026-09-29 13:34	AMZN	AMZN261120C00265000	call	265.0000	2026-11-20	7.6100	7.6000	7.7000	246.9300	38066.00	0.00	38066.00	50	5	316	21433	0.0147436196519386	0.374271108323058	0.374850717786976	false	false	false	true
ecbf90d1-b179-4602-9d61-3d04170f72c8	2026-09-29 13:33	2026-09-29 13:33	2026-09-29 13:33	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.4400	1.4400	1.4800	246.9988	13968.00	0.00	13968.00	97	17	36430	4759	7.65496953141416	0.322742254564262	0.322742254564262	true	false	false	true
d6ed708b-96cb-4703-8d1a-c2fb4f6af502	2026-09-29 13:33	2026-09-29 13:33	2026-09-29 13:33	AMZN	AMZN260930C00245000	call	245.0000	2026-09-30	2.8300	2.8300	2.9000	246.9988	18961.00	0.00	18961.00	67	7	11387	3144	3.62181933842239	0.315282287110441	0.315282287110441	false	false	false	true
2b0045a1-16ec-43b8-9f29-ea40af63cab0	2026-09-29 13:32	2026-09-29 13:32	2026-09-29 13:32	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.4100	1.4000	1.4400	246.8900	19879.00	0.00	19879.00	141	11	36248	4759	7.61672620298382	0.326515514620472	0.32455941126193	true	false	false	true
189abeab-464f-4035-ad49-d7fe2b174e83	2026-09-29 13:32	2026-09-29 13:32	2026-09-29 13:32	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.2900	0.2700	0.3100	247.0900	18329.00	16113.00	59.00	640	48	8415	8004	1.05134932533733	0.353996868314935	0.361433305114483	true	false	false	true
3331f76d-491e-4cce-afa4-bf7a1ea9656c	2026-09-29 13:32	2026-09-29 13:32	2026-09-29 13:32	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.2800	0.2700	0.2800	247.1495	12600.00	12600.00	0.00	450	18	7775	8004	0.971389305347326	0.351205607216133	0.351205607216133	false	false	false	true
23124c82-de81-4cfc-a20d-5f419d476fe3	2026-09-29 13:32	2026-09-29 13:32	2026-09-29 13:32	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.5000	1.4700	1.5100	247.0700	14436.00	14436.00	0.00	96	11	35890	4759	7.54150031519227	0.32802191723455	0.329967367679152	true	false	false	true
63416623-951a-4b62-8b38-c93a3895fa63	2026-09-29 13:32	2026-09-29 13:32	2026-09-29 13:32	AMZN	AMZN261023C00250000	call	250.0000	2026-10-23	6.4000	6.1500	6.4000	247.0700	34560.00	34560.00	0.00	54	27	1669	2046	0.815738025415445	0.29683893668114	0.294618516133066	true	false	false	true
f4cab5f8-232f-4161-b4ba-75ad23487a43	2026-09-29 13:32	2026-09-29 13:31	2026-09-29 13:31	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.4500	1.4400	1.4700	247.0200	25955.00	0.00	23635.00	179	6	35785	4759	7.51943685648245	0.322793890922275	0.322793890922275	false	false	false	true
f4818e55-2491-4447-8f88-ef4f9c9f4241	2026-09-29 13:31	2026-09-29 13:31	2026-09-29 13:31	AMZN	AMZN261016C00255000	call	255.0000	2026-10-16	3.2500	3.1000	3.2500	246.9970	27625.00	27625.00	0.00	85	11	2678	9649	0.277541714167271	0.292398715866587	0.292398715866587	false	false	false	true
65704a4f-e8d6-4562-9ec3-1f14fa36437d	2026-09-29 13:31	2026-09-29 13:31	2026-09-29 13:31	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	16.0000	15.7500	16.0500	246.9970	30400.00	28800.00	1600.00	19	6	870	14102	0.0616933768259821	0.353959697561024	0.353959697561024	false	false	false	true
446098e7-8424-4057-90b3-ed669fca3215	2026-09-29 13:31	2026-09-29 13:31	2026-09-29 13:31	AMZN	AMZN261016C00247500	call	247.5000	2026-10-16	6.1500	5.9500	6.2000	246.8494	51645.00	51030.00	615.00	84	10	742	1182	0.627749576988156	0.292475522787124	0.293649403462706	false	false	false	true
cdba3d59-f530-4947-8f62-8ca024e5057f	2026-09-29 13:27	2026-09-29 13:27	2026-09-29 13:27	AMZN	AMZN261002C00247500	call	247.5000	2026-10-02	2.5300	2.5000	2.5300	246.5900	30360.00	30360.00	0.00	120	12	4850	3491	1.38928673732455	0.329015454632047	0.327459453633483	true	false	false	true
bdde5a8a-551a-4d4a-bc4a-c426f82ff554	2026-09-29 13:27	2026-09-29 13:27	2026-09-29 13:27	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.2300	1.2100	1.2600	246.5900	19683.00	19683.00	0.00	160	15	35261	4759	7.40932969111158	0.319154295547379	0.322621641095404	true	false	false	true
80536588-d9e2-4e64-82af-daef33a8e376	2026-09-29 13:26	2026-09-29 13:26	2026-09-29 13:26	AMZN	AMZN261016C00250000	call	250.0000	2026-10-16	4.8000	4.8000	4.8500	246.4650	14880.00	0.00	14880.00	31	16	3151	12764	0.246866186148543	0.291013185457529	0.291013185457529	true	false	false	true
4c1e49e9-30c0-4a75-81a2-3cedd0c01b0a	2026-09-29 13:24	2026-09-29 13:24	2026-09-29 13:24	AMZN	AMZN261002C00247500	call	247.5000	2026-10-02	2.4500	2.4500	2.4800	246.3950	36754.00	494.00	36260.00	150	15	4727	3491	1.3540532798625	0.328460731611375	0.328460731611375	false	false	false	true
ee804b37-dc74-4b4f-8dec-4dbb7c1cf5c8	2026-09-29 13:21	2026-09-29 13:21	2026-09-29 13:21	AMZN	AMZN261009C00250000	call	250.0000	2026-10-09	3.3500	3.3000	3.3500	246.3500	27805.00	27805.00	0.00	83	9	1218	2546	0.478397486252946	0.297241016876153	0.296225768585222	false	false	false	true
5353ca1a-644c-483c-a329-d8542574e5e5	2026-09-29 13:21	2026-09-29 13:21	2026-09-29 13:21	AMZN	AMZN261005C00247500	call	247.5000	2026-10-05	2.9300	2.8800	2.9300	246.3500	26956.00	26956.00	0.00	92	16	1209	484	2.49793388429752	0.270781168284203	0.269313340374347	false	false	false	true
04e91bbd-bd18-43ca-be2a-8cc6e2ab636b	2026-09-29 13:21	2026-09-29 13:21	2026-09-29 13:21	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.0600	1.0600	1.0900	246.3100	10388.00	0.00	10388.00	98	13	25670	2639	9.7271693823418	0.320257550701315	0.320257550701315	false	false	false	true
77b9e520-b145-49fd-9733-ab03ca4650a5	2026-09-29 13:19	2026-09-29 13:19	2026-09-29 13:19	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.0700	1.0700	1.1000	246.2600	11770.00	0.00	11770.00	110	6	25347	2639	9.60477453580902	0.318498144974973	0.318498144974973	false	false	false	true
16a1d8c5-7d86-40fe-8021-148d4b9b1d0a	2026-09-29 13:19	2026-09-29 13:19	2026-09-29 13:19	AMZN	AMZN261120P00265000	put	265.0000	2026-11-20	24.6000	24.5000	24.7500	246.2500	76260.00	73800.00	2460.00	31	6	63	6535	0.00964039785768936	0.376204677169179	0.376204677169179	false	false	false	true
faacd143-251a-47f4-b3f9-07a3256a7400	2026-09-29 13:18	2026-09-29 13:18	2026-09-29 13:18	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	2.2900	2.2600	2.2900	246.1450	14427.00	14427.00	0.00	63	10	6533	4329	1.50912450912451	0.322233038263251	0.322233038263251	true	false	false	true
8e76be9b-aa54-4432-870e-aeb9204e86fe	2026-09-29 13:18	2026-09-29 13:18	2026-09-29 13:18	AMZN	AMZN261002P00237500	put	237.5000	2026-10-02	0.4400	0.4100	0.4400	246.1450	70532.00	70532.00	0.00	1603	46	2408	4900	0.491428571428571	0.339138065126942	0.339138065126942	false	false	false	true
a0b8eaa6-72af-4dfb-abe0-b997516feae9	2026-09-29 13:18	2026-09-29 13:18	2026-09-29 13:18	AMZN	AMZN270115C00250000	call	250.0000	2027-01-15	18.0000	18.0000	18.2000	246.1800	32400.00	0.00	32400.00	18	5	3207	34612	0.0926557263376863	0.342919641262207	0.342919641262207	false	false	false	true
c76e104e-cfef-49a8-a53c-db45cd8d191e	2026-09-29 13:15	2026-09-29 13:15	2026-09-29 13:15	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	0.9900	0.9700	1.0000	246.4800	13366.00	13366.00	0.00	135	7	24522	2639	9.29215611974233	0.319223196630883	0.320571205555589	false	false	false	true
a452c0ae-037e-400b-a546-02179d3273b3	2026-09-29 13:15	2026-09-29 13:15	2026-09-29 13:15	AMZN	AMZN261218C00230000	call	230.0000	2026-12-18	27.0500	26.9500	27.6000	246.5500	67625.00	0.00	67625.00	25	5	232	4097	0.0566268000976324	0.361605937662703	0.361605937662703	false	false	false	true
ef1814cc-037d-4a90-871e-3f8f55f595b7	2026-09-29 13:14	2026-09-29 13:13	2026-09-29 13:13	AMZN	AMZN261218P00240000	put	240.0000	2026-12-18	12.0000	12.0000	12.1000	246.4450	18000.00	0.00	18000.00	15	10	207	8647	0.0239389383601249	0.353587894757419	0.353587894757419	true	false	false	true
94452d8a-fb3c-4812-a767-3570425c4bdc	2026-09-29 13:14	2026-09-29 13:13	2026-09-29 13:13	AMZN	AMZN260930C00245000	call	245.0000	2026-09-30	2.4700	2.4700	2.5200	246.4300	19266.00	0.00	19266.00	78	12	10959	3144	3.48568702290076	0.319545937678383	0.319545937678383	true	false	false	true
37b919e8-cceb-4595-9b1f-49c8b21a1639	2026-09-29 13:12	2026-09-29 13:12	2026-09-29 13:12	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.1600	1.1300	1.1700	246.3200	33987.00	33872.00	115.00	293	34	33922	4759	7.12796806051692	0.324608893811961	0.32259408415177	true	false	false	true
e431c136-4d05-4e58-a9d5-f6a789908e02	2026-09-29 13:12	2026-09-29 13:12	2026-09-29 13:12	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.0300	1.0200	1.0300	246.4000	21527.00	21527.00	0.00	209	14	23755	2639	9.00151572565366	0.320855304011839	0.320855304011839	true	false	false	true
5b69b0ef-f2a7-48d8-bfe3-211ddb97a884	2026-09-29 13:12	2026-09-29 13:12	2026-09-29 13:12	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	0.4900	0.4900	0.5000	246.3900	12887.00	0.00	12887.00	263	27	24009	3659	6.56162886034436	0.331729185853697	0.331729185853697	false	false	false	true
2a3ddfbf-df6b-4da2-9f56-9efad018d208	2026-09-29 13:10	2026-09-29 13:10	2026-09-29 13:10	AMZN	AMZN261120C00260000	call	260.0000	2026-11-20	9.0500	9.0000	9.2000	246.5100	20815.00	0.00	20815.00	23	6	1335	32473	0.0411110768946509	0.374668366722737	0.374668366722737	false	false	false	true
9f9bbead-7a86-4383-8b0e-30c7866cd3fe	2026-09-29 13:10	2026-09-29 13:10	2026-09-29 13:10	AMZN	AMZN271217P00230000	put	230.0000	2027-12-17	23.7500	23.4500	23.8000	246.5900	135375.00	133000.00	2375.00	57	11	444	2230	0.199103139013453	0.364062736900647	0.364062736900647	false	false	false	true
0482b073-067d-41ab-abd5-de4d9bc36be5	2026-09-29 13:10	2026-09-29 13:10	2026-09-29 13:10	AMZN	AMZN271217P00230000	put	230.0000	2027-12-17	23.7300	23.3500	23.7500	246.5900	75920.00	40370.00	0.00	32	5	387	2230	0.173542600896861	0.36353427052331	0.364062736900647	true	false	false	true