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

20b155ab-f96b-4178-aad4-19fe3da01980	2026-09-29 12:28	2026-09-29 12:27	2026-09-29 12:27	AMZN	AMZN261030P00235000	put	235.0000	2026-10-30	5.8500	5.8000	5.9500	246.9850	10530.00	7605.00	2925.00	18	5	220	2526	0.0870942201108472	0.397276854947481	0.397276854947481	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-29T16:30:08.808043Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
a50c5d16-202a-4cd1-b9cc-92173d121f8f	2026-09-29 12:27	2026-09-29 12:27	2026-09-29 12:27	AMZN	AMZN261120C00250000	call	250.0000	2026-11-20	13.2500	13.1000	13.3500	246.9900	23850.00	3975.00	19875.00	18	8	775	21248	0.0364740210843374	0.375488350554055	0.375488350554055	true	false	false	true
88b87920-e64f-4c9f-b6e0-34887755709f	2026-09-29 12:27	2026-09-29 12:27	2026-09-29 12:27	AMZN	AMZN271217P00260000	put	260.0000	2027-12-17	38.5500	38.3500	38.5500	246.9600	73244.00	73244.00	0.00	19	11	114	2576	0.0442546583850932	0.368231469538264	0.368231469538264	false	false	false	true
6f6f2515-8c97-4973-b49a-bd7791ba4826	2026-09-29 12:27	2026-09-29 12:27	2026-09-29 12:27	AMZN	AMZN271217P00250000	put	250.0000	2027-12-17	33.2000	33.2000	33.4000	246.9700	132800.00	0.00	59760.00	40	5	45	2389	0.0188363331938049	0.366940273229601	0.366940273229601	false	false	false	true
d217daf8-e499-4f48-b48f-ea93b7849a89	2026-09-29 12:26	2026-09-29 12:26	2026-09-29 12:26	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.4300	1.4200	1.4300	246.9750	22165.00	22165.00	0.00	155	5	28448	4759	5.977726413112	0.322913541231253	0.322913541231253	false	false	false	true
f9ba3273-8dce-4768-b3fb-125c9f90b885	2026-09-29 12:26	2026-09-29 12:26	2026-09-29 12:26	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	1.9800	1.9800	2.0200	246.8900	25542.00	0.00	25542.00	129	10	5743	4329	1.32663432663433	0.321374814763506	0.321374814763506	false	false	false	true
02ebe0ff-213a-4d40-b8b9-9c4cb57daa21	2026-09-29 12:26	2026-09-29 12:26	2026-09-29 12:26	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	0.9000	0.8900	0.9200	246.9100	11790.00	0.00	9990.00	131	5	17230	2639	6.52898825312618	0.328744281598219	0.330133306774346	true	false	false	true
bc83c8c8-6725-4367-b1f5-00c9be52f192	2026-09-29 12:26	2026-09-29 12:26	2026-09-29 12:26	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.4000	1.4000	1.4100	246.8600	37800.00	0.00	37800.00	270	21	28236	4759	5.93317923933599	0.32718395502975	0.32718395502975	true	false	false	true
201f12ae-ce26-4fa1-b854-0e2fd77a800b	2026-09-29 12:24	2026-09-29 12:24	2026-09-29 12:24	AMZN	AMZN261007C00250000	call	250.0000	2026-10-07	2.8500	2.8300	2.9000	246.8300	28500.00	0.00	28500.00	100	5	313	143	2.18881118881119	0.283624270434519	0.283624270434519	false	false	false	true
1ecfbdec-ab14-454f-9421-58502a1a3609	2026-09-29 12:24	2026-09-29 12:24	2026-09-29 12:24	AMZN	AMZN261120C00250000	call	250.0000	2026-11-20	13.2000	13.1500	13.2500	246.8750	79200.00	63360.00	0.00	60	5	757	21248	0.0356268825301205	0.375722221612463	0.375722221612463	false	false	false	true
b72d0d09-8fd2-42fe-8825-16e97125cf77	2026-09-29 12:24	2026-09-29 12:23	2026-09-29 12:23	AMZN	AMZN261002P00247500	put	247.5000	2026-10-02	3.1500	3.1000	3.2500	246.8500	27090.00	0.00	27090.00	86	7	628	6237	0.100689434022767	0.319362826798114	0.319658025996871	true	false	false	true
7a4d2094-7ae2-4699-bbf1-2845818ef209	2026-09-29 12:22	2026-09-29 12:22	2026-09-29 12:22	AMZN	AMZN260930C00245000	call	245.0000	2026-09-30	2.8000	2.7700	2.8300	246.8531	19600.00	10080.00	5600.00	70	7	9890	3144	3.14567430025445	0.330428244120834	0.330428244120834	true	false	false	true
e12969d6-18f3-4458-8c83-932e70293601	2026-09-29 12:21	2026-09-29 12:21	2026-09-29 12:21	AMZN	AMZN261120C00240000	call	240.0000	2026-11-20	18.3500	18.2500	18.3500	246.8400	27525.00	5505.00	0.00	15	5	387	8273	0.0467786776260123	0.378565846163871	0.378565846163871	false	false	false	true
c312c43c-eac8-4e6f-a35c-2412aa65a8b0	2026-09-29 12:21	2026-09-29 12:20	2026-09-29 12:20	AMZN	AMZN261023C00270000	call	270.0000	2026-10-23	1.2000	1.1700	1.2300	246.7900	16080.00	3000.00	13080.00	134	5	642	3792	0.169303797468354	0.294785481892141	0.294785481892141	false	false	false	true
acbd8e1a-f980-480d-b929-893ef054533b	2026-09-29 12:20	2026-09-29 12:20	2026-09-29 12:20	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	1.6200	1.6200	1.6500	246.7900	34182.00	0.00	34182.00	211	15	8610	12748	0.675400062754942	0.325216745625109	0.325216745625109	true	false	false	true
1753ac87-73d5-4326-acf2-ade29c35f060	2026-09-29 12:20	2026-09-29 12:20	2026-09-29 12:20	AMZN	AMZN281215P00280000	put	280.0000	2028-12-15	58.5400	58.5000	59.3000	246.7900	251718.00	0.00	251718.00	43	5	43	2090	0.0205741626794258	0.387151179065549	0.387151179065549	false	false	false	true
ba2ba274-a209-4022-ae5a-f9a837da09b7	2026-09-29 12:20	2026-09-29 12:20	2026-09-29 12:20	AMZN	AMZN261002C00235000	call	235.0000	2026-10-02	12.1100	11.8000	12.2000	246.7208	24220.00	24220.00	0.00	20	5	475	335	1.41791044776119	0.386766499906951	0.386766499906951	false	false	false	true
471bc188-d16b-4788-9bae-2919117f5334	2026-09-29 12:15	2026-09-29 12:15	2026-09-29 12:15	AMZN	AMZN270917P00215000	put	215.0000	2027-09-17	15.1500	15.1500	15.3000	246.5500	19695.00	0.00	19695.00	13	5	127	1400	0.0907142857142857	0.357401993076147	0.357401993076147	false	false	false	true
2aff7387-5d90-4311-bac9-802bd6e256c2	2026-09-29 12:15	2026-09-29 12:15	2026-09-29 12:15	AMZN	AMZN270917P00215000	put	215.0000	2027-09-17	15.1500	15.1500	15.3000	246.6250	42420.00	0.00	42420.00	28	9	102	1400	0.0728571428571429	0.357642797569005	0.357642797569005	false	false	false	true
2547c246-ef17-49b8-afb6-24abc964584d	2026-09-29 12:15	2026-09-29 12:15	2026-09-29 12:15	AMZN	AMZN270917P00215000	put	215.0000	2027-09-17	15.1500	15.1500	15.3000	246.5900	10605.00	0.00	10605.00	7	6	40	1400	0.0285714285714286	0.357530442541048	0.357530442541048	false	false	false	true
f1b8461f-942f-441b-a745-1d1b1e3c3a49	2026-09-29 12:15	2026-09-29 12:14	2026-09-29 12:14	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.2800	1.2600	1.2900	246.6100	10496.00	10496.00	0.00	82	6	26913	4759	5.65517965959235	0.324916836368829	0.324916836368829	false	false	false	true
80543c06-8233-46ed-b31b-c6d9e2b7dae7	2026-09-29 12:15	2026-09-29 12:14	2026-09-29 12:14	AMZN	AMZN260930C00245000	call	245.0000	2026-09-30	2.6300	2.5800	2.6500	246.6100	34473.00	34473.00	0.00	131	17	9594	3144	3.05152671755725	0.328604069629607	0.332800413231095	true	false	false	true
4f7d044d-3ba0-4f16-8207-099b28bdd28e	2026-09-29 12:08	2026-09-29 12:08	2026-09-29 12:08	AMZN	AMZN261002C00245000	call	245.0000	2026-10-02	3.7800	3.7000	3.8000	246.0000	15136.00	15136.00	0.00	40	5	1704	3413	0.499267506592441	0.335797038373704	0.332824703260581	false	false	false	true
20c3028c-594f-4032-9c32-30ca21ccc782	2026-09-29 12:07	2026-09-29 12:07	2026-09-29 12:07	AMZN	AMZN270617C00280000	call	280.0000	2027-06-17	19.9500	19.8000	20.0500	246.0000	19950.00	19950.00	0.00	10	5	65	9407	0.00690974805995535	0.35367378287338	0.35367378287338	false	false	false	true
d20ee33e-9c71-46c7-bb14-0a9120d77393	2026-09-29 12:06	2026-09-29 12:06	2026-09-29 12:06	AMZN	AMZN260930P00262500	put	262.5000	2026-09-30	16.2600	16.1000	16.4500	246.0000	32520.00	0.00	32520.00	20	5	224	7	32	0.578507231822035	0.578507231822035	false	false	false	true
bafef51a-e25b-4e6f-a578-f76b797a0f8a	2026-09-29 12:06	2026-09-29 12:06	2026-09-29 12:06	AMZN	AMZN270115P00245000	put	245.0000	2027-01-15	15.9000	15.8500	15.9500	246.0000	79500.00	11130.00	3180.00	50	6	95	5715	0.0166229221347332	0.340430785980257	0.340430785980257	false	false	false	true
61be0c7a-3567-4500-8958-33ae511d81dc	2026-09-29 12:04	2026-09-29 12:04	2026-09-29 12:04	AMZN	AMZN270115C00250000	call	250.0000	2027-01-15	18.0000	17.9500	18.1000	246.0000	59400.00	3600.00	54000.00	33	6	2291	34612	0.0661909164451635	0.342719958064819	0.342719958064819	false	false	false	true
405f16a6-9342-4358-bce0-733ba2bf7905	2026-09-29 12:03	2026-09-29 12:03	2026-09-29 12:03	AMZN	AMZN260930P00240000	put	240.0000	2026-09-30	0.1600	0.1600	0.1700	246.0000	15760.00	0.00	15760.00	985	36	5105	3529	1.44658543496741	0.34856822172665	0.349191190344779	true	false	false	true
4ae4b252-b33c-4d3b-8b4b-e6152e876c32	2026-09-29 12:03	2026-09-29 12:03	2026-09-29 12:03	AMZN	AMZN260930C00235000	call	235.0000	2026-09-30	11.2600	11.1500	11.4000	246.0000	16890.00	0.00	16890.00	15	5	153	140	1.09285714285714	0.423342278170136	0.423342278170136	false	false	false	true
4c518690-ba9d-49be-99b2-17eda4193050	2026-09-29 12:02	2026-09-29 12:02	2026-09-29 12:02	AMZN	AMZN261002P00262500	put	262.5000	2026-10-02	15.7500	15.6500	16.5500	246.0000	15750.00	0.00	15750.00	10	5	318	160	1.9875	0.442561057883834	0.442561057883834	false	false	false	true
51bbfc47-c625-4434-9598-d334d90731a4	2026-09-29 12:02	2026-09-29 12:02	2026-09-29 12:02	AMZN	AMZN261009P00240000	put	240.0000	2026-10-09	2.2100	2.1200	2.2400	246.1000	18345.00	18125.00	220.00	83	10	308	2136	0.144194756554307	0.294703152412871	0.296862303315539	true	false	false	true
1b86530d-444b-4b47-9549-b002478acd7e	2026-09-29 12:00	2026-09-29 12:00	2026-09-29 12:00	AMZN	AMZN290119C00370000	call	370.0000	2029-01-19	28.9500	28.9500	29.1000	246.3450	26055.00	0.00	14475.00	9	5	9	28	0.321428571428571	0.362309652086205	0.362309652086205	true	false	false	true
6bb317b6-2042-4ea7-93e6-1265d753f9c8	2026-09-29 11:58	2026-09-29 11:58	2026-09-29 11:58	AMZN	AMZN261002C00245000	call	245.0000	2026-10-02	3.7000	3.6500	3.7000	246.2850	74000.00	74000.00	0.00	200	11	1647	3413	0.482566656900088	0.334013759791779	0.334013759791779	false	false	false	true
b0ed77b8-07c9-40bc-9ade-17ecfb35e6f2	2026-09-29 11:57	2026-09-29 11:56	2026-09-29 11:56	AMZN	AMZN261218C00260000	call	260.0000	2026-12-18	11.5500	11.5500	11.6000	246.3100	17325.00	0.00	17325.00	15	5	518	14989	0.034558676362666	0.352725133390308	0.352725133390308	true	false	false	true
299d521a-2883-47ff-a3ec-082b9fa248d7	2026-09-29 11:54	2026-09-29 11:54	2026-09-29 11:54	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	2.2500	2.1700	2.2500	246.2100	11250.00	11250.00	0.00	50	7	5484	4329	1.26680526680527	0.32081384045167	0.32081384045167	false	false	false	true
de0e8326-112c-4d3a-a8da-5ed968fa58a7	2026-09-29 11:53	2026-09-29 11:53	2026-09-29 11:53	AMZN	AMZN261120C00325000	call	325.0000	2026-11-20	0.5300	0.5300	0.6200	246.2900	10600.00	0.00	10600.00	200	6	641	21332	0.0300487530470654	0.389982412376491	0.389982412376491	false	false	false	true
a4f12189-d702-487b-aaf7-5ecf29d21137	2026-09-29 11:53	2026-09-29 11:53	2026-09-29 11:53	AMZN	AMZN261120C00260000	call	260.0000	2026-11-20	9.0000	9.0000	9.1000	246.3300	11700.00	0.00	11700.00	13	5	1097	32473	0.0337819111261664	0.375258105505411	0.375258105505411	true	false	false	true
5587c31c-60bc-4e20-b986-770a9ef924ef	2026-09-29 11:53	2026-09-29 11:53	2026-09-29 11:53	AMZN	AMZN261120C00325000	call	325.0000	2026-11-20	0.5200	0.5200	0.6200	246.4200	10400.00	0.00	10400.00	200	10	441	21332	0.0206731670729421	0.388041838792251	0.388041838792251	false	false	false	true
fb24594c-773e-49f8-a048-76982807885d	2026-09-29 11:52	2026-09-29 11:52	2026-09-29 11:52	AMZN	AMZN261009C00260000	call	260.0000	2026-10-09	0.9300	0.9300	0.9500	246.5100	13950.00	0.00	13950.00	150	6	1744	3838	0.454403335070349	0.297969947288628	0.297969947288628	false	false	false	true
5b2f825b-3b14-4322-a8da-a8118d6d4a54	2026-09-29 11:48	2026-09-29 11:48	2026-09-29 11:48	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	0.5000	0.5000	0.5300	246.4000	10000.00	0.00	10000.00	200	15	16943	3659	4.63050013664936	0.33388562791975	0.33388562791975	false	false	false	true
8c00d94a-6e62-4d32-9377-1fa118eb9f3e	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	0.5100	0.5100	0.5400	246.5246	10200.00	0.00	10200.00	200	10	16648	3659	4.54987701557803	0.3295333523572	0.3295333523572	false	false	false	true
dfccafec-3139-43cb-ac16-6e858a773af0	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	AMZN	AMZN260930C00250000	call	250.0000	2026-09-30	0.5100	0.5100	0.5300	246.5246	10149.00	0.00	10149.00	199	5	16447	3659	4.49494397376332	0.3295333523572	0.3295333523572	false	false	false	true
97b9b951-df6e-47f5-b57a-0f0f8b21bfce	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	AMZN	AMZN261023P00240000	put	240.0000	2026-10-23	4.3500	4.3000	4.4500	246.2500	21750.00	870.00	16530.00	50	6	82	3268	0.0250917992656059	0.29322217305586	0.29322217305586	false	false	false	true
966cf4c1-1584-46f1-9cdb-c9bf01a60931	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	AMZN	AMZN261002C00245000	call	245.0000	2026-10-02	3.6000	3.5000	3.6000	246.1500	25560.00	25560.00	0.00	71	12	1423	3413	0.416935247582772	0.335367293207269	0.331462965331984	true	false	false	true
486c4c2b-6f9d-4e03-8291-0fdcbe709526	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	AMZN	AMZN261002C00247500	call	247.5000	2026-10-02	2.3500	2.2900	2.3600	246.1500	13400.00	13400.00	0.00	57	6	2022	3491	0.579203666571183	0.331298614193991	0.330595421485444	false	false	false	true
2cdb32e4-9970-4270-9d14-232d77d15b1c	2026-09-29 11:47	2026-09-29 11:47	2026-09-29 11:47	AMZN	AMZN261002C00260000	call	260.0000	2026-10-02	0.1800	0.1700	0.1800	246.3800	13752.00	13752.00	0.00	764	10	4011	18925	0.211941875825627	0.363749269933508	0.361989985955346	true	false	false	true
36a6df1c-8812-46f2-a7bb-1c7f8102de5a	2026-09-29 11:46	2026-09-29 11:46	2026-09-29 11:46	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.0800	1.0700	1.0800	246.0600	21600.00	21600.00	0.00	200	25	25131	4759	5.2807312460601	0.328634532814848	0.328634532814848	true	false	false	true
a26f8aa5-7006-453d-8b5f-e18476f60eec	2026-09-29 11:46	2026-09-29 11:46	2026-09-29 11:46	AMZN	AMZN261120P00255000	put	255.0000	2026-11-20	18.1000	17.9000	18.1000	246.0600	117650.00	117650.00	0.00	65	15	81	10911	0.00742370085235084	0.374726281414964	0.374726281414964	false	false	false	true
ab3f78a4-ad2b-411a-baee-72e55619db95	2026-09-29 11:45	2026-09-29 11:45	2026-09-29 11:45	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.0900	1.0800	1.1000	246.1300	21723.00	0.00	8316.00	200	6	24928	4759	5.23807522588779	0.323260388246206	0.325303121381485	false	false	false	true
9536b094-9647-4fcd-8e58-6ca8cddb5a62	2026-09-29 11:43	2026-09-29 11:43	2026-09-29 11:43	AMZN	AMZN261023P00225000	put	225.0000	2026-10-23	1.1700	1.1600	1.2000	246.0950	17550.00	2925.00	14625.00	150	12	234	2311	0.101254868022501	0.312879665382387	0.312879665382387	false	false	false	true