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

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	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:22:19.511373Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
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
6555c7ae-b19a-4a7c-a48a-b2817d8521f5	2026-09-29 11:43	2026-09-29 11:43	2026-09-29 11:43	AMZN	AMZN261007C00235000	call	235.0000	2026-10-07	12.1000	11.8000	12.7500	246.0950	24200.00	0.00	24200.00	20	5	40	25	1.6	0.300319194205852	0.300319194205852	false	false	false	true
694326bd-1d99-432f-a590-d61499eee7bf	2026-09-29 11:42	2026-09-29 11:42	2026-09-29 11:42	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.1600	1.1600	1.1700	246.1550	11368.00	0.00	11368.00	98	13	15262	2639	5.78325123152709	0.328707310561064	0.328707310561064	false	false	false	true
b7c3626c-0fc2-4583-bcc4-c7d495bd4457	2026-09-29 11:40	2026-09-29 11:40	2026-09-29 11:40	AMZN	AMZN261009P00235000	put	235.0000	2026-10-09	1.0900	1.0900	1.1200	246.2100	11009.00	0.00	11009.00	101	14	316	1807	0.174875484228002	0.301890859909922	0.301890859909922	false	false	false	true
f5f21453-6b8a-4dad-b2ff-84c681136004	2026-09-29 11:39	2026-09-29 11:39	2026-09-29 11:39	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.2000	1.1700	1.2000	246.4000	14040.00	14040.00	0.00	117	5	24319	4759	5.11010716537088	0.326232473078334	0.326232473078334	false	false	false	true
b4db34f2-a6d1-490a-b198-c06207037758	2026-09-29 11:38	2026-09-29 11:38	2026-09-29 11:38	AMZN	AMZN270115C00300000	call	300.0000	2027-01-15	4.2500	4.2000	4.2500	246.3000	12750.00	12750.00	0.00	30	5	1444	68138	0.0211922862426253	0.342161201216328	0.342161201216328	false	false	false	true
0e2a0d1c-10bb-42e4-b931-a1c3a07d6e1b	2026-09-29 11:35	2026-09-29 11:35	2026-09-29 11:35	AMZN	AMZN261005C00247500	call	247.5000	2026-10-05	2.9600	2.8900	2.9600	246.0000	29600.00	29600.00	0.00	100	7	925	484	1.91115702479339	0.271153576612271	0.271153576612271	false	false	false	true
b2122aaa-482b-439b-a260-11b5a78a52f8	2026-09-29 11:34	2026-09-29 11:34	2026-09-29 11:34	AMZN	AMZN261120C00270000	call	270.0000	2026-11-20	6.0500	6.0500	6.1500	246.0000	215414.00	0.00	215414.00	356	38	1422	28240	0.0503541076487252	0.374427742067712	0.374427742067712	false	false	false	true
9ff62bf5-33d8-42cc-9ede-459cc91796b3	2026-09-29 11:34	2026-09-29 11:34	2026-09-29 11:34	AMZN	AMZN261120C00275000	call	275.0000	2026-11-20	4.9500	4.9500	5.0500	246.0000	53955.00	0.00	53955.00	109	15	373	10430	0.0357622243528284	0.375697887112537	0.375697887112537	false	false	false	true
29945c3a-5cc8-4ff5-8b37-ad5e20915485	2026-09-29 11:34	2026-09-29 11:34	2026-09-29 11:34	AMZN	AMZN261030P00235000	put	235.0000	2026-10-30	6.0500	5.9000	6.1000	246.0000	36905.00	35090.00	1815.00	61	15	193	2526	0.0764053840063341	0.397134131457404	0.397134131457404	false	false	false	true
87bc0159-6081-4121-9d7d-1eaf1ffa04fe	2026-09-29 11:33	2026-09-29 11:33	2026-09-29 11:33	AMZN	AMZN261016P00232500	put	232.5000	2026-10-16	1.5600	1.5600	1.6400	246.0000	12948.00	0.00	12948.00	83	7	457	893	0.511758118701008	0.303550905191772	0.303550905191772	false	false	false	true
596def5b-a6f0-4157-8e22-b7f00e7c2dc1	2026-09-29 11:31	2026-09-29 11:31	2026-09-29 11:31	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	2.3200	2.3100	2.3700	246.0000	14384.00	0.00	14152.00	62	16	5366	4329	1.23954723954724	0.321006554268498	0.321006554268498	true	false	false	true
44b3ea18-c009-49ab-be93-cc125fb7cb5b	2026-09-29 11:31	2026-09-29 11:30	2026-09-29 11:30	AMZN	AMZN270617C00300000	call	300.0000	2027-06-17	14.4500	14.3500	14.5000	246.0000	17340.00	17340.00	0.00	12	7	113	11265	0.0100310696848646	0.353572915855376	0.353572915855376	false	false	false	true
8c256ddd-8d90-46d9-8c27-3cbde58d44b7	2026-09-29 11:30	2026-09-29 11:30	2026-09-29 11:30	AMZN	AMZN261009C00245000	call	245.0000	2026-10-09	5.4500	5.3500	5.4500	245.0000	33790.00	33790.00	0.00	62	8	275	572	0.480769230769231	0.298202010249295	0.298202010249295	true	false	false	true
ef98dcf7-fde0-4cee-b06a-7ce145bd17c5	2026-09-29 11:28	2026-09-29 11:28	2026-09-29 11:28	AMZN	AMZN261120C00270000	call	270.0000	2026-11-20	5.9500	5.9500	6.1000	246.0200	19640.00	0.00	19040.00	33	8	1064	28240	0.0376770538243626	0.37406115880793	0.375626393557836	false	false	false	true
f081ae95-039d-47e2-ba21-4e3923b9d747	2026-09-29 11:27	2026-09-29 11:27	2026-09-29 11:27	AMZN	AMZN261120C00270000	call	270.0000	2026-11-20	5.9500	5.9500	6.1000	246.0500	31535.00	0.00	31535.00	53	5	966	28240	0.0342067988668555	0.373786131244228	0.373786131244228	false	false	false	true
1a3ed767-71dc-463b-95d2-999cee84174c	2026-09-29 11:26	2026-09-29 11:26	2026-09-29 11:26	AMZN	AMZN261002C00245000	call	245.0000	2026-10-02	3.6000	3.4500	3.6500	246.0000	72000.00	66240.00	4680.00	200	13	1304	3413	0.382068561382948	0.330154307499468	0.330154307499468	true	false	false	true
290d62f4-7a3c-4743-82c8-db9cc2530603	2026-09-29 11:23	2026-09-29 11:23	2026-09-29 11:23	AMZN	AMZN261120C00255000	call	255.0000	2026-11-20	10.6500	10.6500	10.7000	245.8600	21300.00	0.00	21300.00	20	8	827	19301	0.0428475208538418	0.376294142731603	0.376294142731603	false	false	false	true
83f9e761-9b33-4f2e-937c-158e19dbcf13	2026-09-29 11:23	2026-09-29 11:23	2026-09-29 11:23	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	2.3800	2.3300	2.4000	245.8650	14041.00	13804.00	237.00	59	10	5261	4329	1.21529221529222	0.320651053351584	0.317511466410224	false	false	false	true
5c75f535-8221-4709-93b1-4b265dd50a39	2026-09-29 11:23	2026-09-29 11:23	2026-09-29 11:23	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.0500	1.0200	1.0700	245.8650	11115.00	0.00	11115.00	106	5	23426	4759	4.92246270224837	0.334183730098496	0.330932776311033	true	false	false	true
65d3138d-0ecd-4890-ac1b-d8a603ef006b	2026-09-29 11:19	2026-09-29 11:19	2026-09-29 11:19	AMZN	AMZN270917P00255000	put	255.0000	2027-09-17	33.2000	32.5500	33.2000	246.1275	245680.00	245680.00	0.00	74	14	83	2277	0.0364514712340799	0.35853481143355	0.35853481143355	false	false	false	true