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

3ac80ef6-9567-4888-97dd-53552265eb2b	2026-09-28 10:11	2026-09-28 10:11	2026-09-28 10:11	AMZN	AMZN261009C00262500	call	262.5000	2026-10-09	0.7600	0.7600	0.8100	245.9400	53580.00	0.00	53580.00	705	25	807	554	1.45667870036101	0.307080381930195	0.307080381930195	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-28T14:11:27.545413Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
03524b0b-9868-428e-a06c-a27f712faf59	2026-09-28 10:11	2026-09-28 10:10	2026-09-28 10:10	AMZN	AMZN261002C00257500	call	257.5000	2026-10-02	0.4500	0.4500	0.4600	246.1000	11970.00	0.00	11970.00	266	12	841	5388	0.156087602078693	0.341272601276525	0.341272601276525	false	false	false	true	false
74200374-17be-4565-b1d3-499f67181741	2026-09-28 10:09	2026-09-28 10:09	2026-09-28 10:09	AMZN	AMZN261218P00245000	put	245.0000	2026-12-18	14.7500	14.7000	14.8000	245.9100	45725.00	16225.00	25075.00	31	10	166	5055	0.0328387734915925	0.355479471353188	0.355479471353188	false	false	false	true	false
56d6ff1f-1005-401f-abf1-10b1a37b5871	2026-09-28 10:06	2026-09-28 10:06	2026-09-28 10:06	AMZN	AMZN270115C00250000	call	250.0000	2027-01-15	17.9000	17.8000	17.9000	245.4250	89500.00	89500.00	0.00	50	12	488	34127	0.0142995282327776	0.346756315341275	0.346756315341275	true	false	false	true	false
38e9bb45-9508-44ec-af4b-6bf02dbe53e2	2026-09-28 10:03	2026-09-28 10:03	2026-09-28 10:03	AMZN	AMZN260928P00245000	put	245.0000	2026-09-28	0.5200	0.5100	0.5200	245.6950	19916.00	19916.00	0.00	383	42	7276	1199	6.06839032527106	0.323322897067944	0.323322897067944	false	false	false	true	false
38e5b5d3-4aa5-49ab-a9cd-054839d9da66	2026-09-28 10:02	2026-09-28 10:02	2026-09-28 10:02	AMZN	AMZN271217C00245000	call	245.0000	2027-12-17	46.2300	45.9000	46.4500	245.9622	101715.00	73995.00	4620.00	22	22	45	1014	0.0443786982248521	0.366977189758887	0.367469045769381	false	false	false	true	false
39510458-e11b-4edc-90f4-bd041c425f9b	2026-09-28 10:02	2026-09-28 10:02	2026-09-28 10:02	AMZN	AMZN271217C00245000	call	245.0000	2027-12-17	46.1800	45.8000	46.3000	245.9700	73880.00	9235.00	4615.00	16	16	23	1014	0.0226824457593688	0.366436282774655	0.366928124470205	false	false	false	true	false
50c8246f-245a-4e32-9841-1b9e8b704f1d	2026-09-28 10:02	2026-09-28 10:02	2026-09-28 10:02	AMZN	AMZN261120C00280000	call	280.0000	2026-11-20	4.1100	4.0500	4.2000	245.9550	164041.00	8260.00	155781.00	399	8	690	12887	0.0535423294793202	0.379786351820287	0.379786351820287	false	false	false	true	false
c75e9e6f-92ed-4bc5-9bbf-70142fc7bcef	2026-09-28 10:02	2026-09-28 10:02	2026-09-28 10:02	AMZN	AMZN261120C00275000	call	275.0000	2026-11-20	5.1000	5.0500	5.1000	245.9050	255000.00	255000.00	0.00	500	31	821	10391	0.0790106823212395	0.380412962899619	0.380412962899619	false	false	false	true	false
2285b0ff-4cce-44c2-b4ca-31bff8898dd1	2026-09-28 10:00	2026-09-28 10:00	2026-09-28 10:00	AMZN	AMZN261030C00250000	call	250.0000	2026-10-30	10.1000	10.0000	10.4000	245.7750	28280.00	1010.00	27270.00	28	6	181	2594	0.0697764070932922	0.39982123053479	0.39982123053479	false	false	false	true	false
e68eed99-8629-43a0-ac6c-c090f4e1f192	2026-09-28 09:59	2026-09-28 09:59	2026-09-28 09:59	AMZN	AMZN261016C00245000	call	245.0000	2026-10-16	7.1000	6.9500	7.2500	245.8850	17750.00	0.00	14200.00	25	5	265	4654	0.0569402664374731	0.294223343528443	0.294223343528443	true	false	false	true	false
d0b9cc88-3206-4d95-b46a-8635e2646458	2026-09-28 09:58	2026-09-28 09:58	2026-09-28 09:58	AMZN	AMZN260928C00245000	call	245.0000	2026-09-28	1.6700	1.6300	1.6700	246.0000	16700.00	16700.00	0.00	100	15	3960	574	6.89895470383275	0.33283319142353	0.33283319142353	true	false	false	true	false
df2cb9b7-a5d8-4646-918a-ffe143a6a654	2026-09-28 09:58	2026-09-28 09:58	2026-09-28 09:58	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	2.0300	2.0300	2.0600	246.0000	27811.00	0.00	27811.00	137	6	2347	34706	0.0676251944908661	0.296825832377334	0.296825832377334	false	false	false	true	false
65c246a3-cb88-4ca2-a411-f18915b87570	2026-09-28 09:58	2026-09-28 09:57	2026-09-28 09:57	AMZN	AMZN270716C00320000	call	320.0000	2027-07-16	12.1500	11.6500	12.2000	246.0000	59530.00	55890.00	1210.00	49	16	59	2606	0.0226400613967767	0.355296532685239	0.355296532685239	true	false	false	true	false
b2814f7e-f3f9-43cd-abc1-2a572ee6d372	2026-09-28 09:57	2026-09-28 09:57	2026-09-28 09:57	AMZN	AMZN281215C00340000	call	340.0000	2028-12-15	34.4500	34.4000	36.3500	246.0000	354875.00	10485.00	344390.00	103	13	103	1353	0.0761271249076127	0.369158514252562	0.371560606663585	true	false	false	true	false
153796c2-2290-44b4-80a3-fac94f444e3a	2026-09-28 09:56	2026-09-28 09:56	2026-09-28 09:56	AMZN	AMZN260930C00252500	call	252.5000	2026-09-30	0.4300	0.4300	0.4500	245.0000	14190.00	0.00	14190.00	330	6	1935	6498	0.297783933518006	0.344834928818976	0.344834928818976	false	false	false	true	false
85c24f46-4092-4661-9838-754305efd470	2026-09-28 09:56	2026-09-28 09:56	2026-09-28 09:56	AMZN	AMZN271217C00250000	call	250.0000	2027-12-17	43.8000	43.5000	44.1000	245.0000	35040.00	0.00	26280.00	8	8	54	10487	0.00514923238295032	0.367588308520285	0.367588308520285	false	false	false	true	false
c83f69d2-8f87-4eb8-b340-4d5feaf3014a	2026-09-28 09:55	2026-09-28 09:55	2026-09-28 09:55	AMZN	AMZN261002P00247500	put	247.5000	2026-10-02	4.3000	4.3000	4.4500	245.6600	1297790.00	0.00	1297790.00	3018	58	3155	3165	0.996840442338073	0.32016488602474	0.326775045258318	false	false	false	true	false
94ad5056-0973-498f-ab8d-3864ae84afb4	2026-09-28 09:55	2026-09-28 09:55	2026-09-28 09:55	AMZN	AMZN261016P00245000	put	245.0000	2026-10-16	5.8100	5.8000	6.0500	245.6600	47648.00	0.00	47648.00	82	7	285	13664	0.0208577283372365	0.290400040862436	0.292842372388714	true	false	false	true	false
054d8305-3f5f-417b-9bff-ff72cace9fbd	2026-09-28 09:55	2026-09-28 09:55	2026-09-28 09:55	AMZN	AMZN261002P00250000	put	250.0000	2026-10-02	5.9000	5.9000	6.1000	245.6600	643219.00	0.00	643219.00	1090	23	1234	4709	0.262051390953493	0.3171034692765	0.325865271438419	false	false	false	true	false
0bc26ab5-34f2-4eb4-ae33-ae8a3f815bc1	2026-09-28 09:55	2026-09-28 09:55	2026-09-28 09:55	AMZN	AMZN261009P00235000	put	235.0000	2026-10-09	1.4100	1.4100	1.5600	245.5550	12269.00	284.00	11985.00	87	13	161	1361	0.118295371050698	0.306755185615149	0.3075341377257	false	false	false	true	false
81aaca8d-a0f2-4c2e-8289-e3c986ad6fd4	2026-09-28 09:54	2026-09-28 09:54	2026-09-28 09:54	AMZN	AMZN261120C00300000	call	300.0000	2026-11-20	1.7600	1.7000	1.7600	245.4800	21648.00	21648.00	0.00	123	17	549	20177	0.0272091985924568	0.388037336955569	0.388037336955569	false	false	false	true	false
dd604bee-ab40-40f0-b3b0-2322a2ecd638	2026-09-28 09:54	2026-09-28 09:54	2026-09-28 09:54	AMZN	AMZN270115C00300000	call	300.0000	2027-01-15	4.3000	4.3000	4.4000	245.4300	14190.00	0.00	14190.00	33	8	610	67339	0.00905864357950074	0.346366403962711	0.346366403962711	false	false	false	true	false
8cbbb851-8ac3-4ce8-b114-35928169fa6a	2026-09-28 09:54	2026-09-28 09:54	2026-09-28 09:54	AMZN	AMZN261120P00235000	put	235.0000	2026-11-20	8.6300	8.6000	8.8500	245.4900	475501.00	287991.00	187510.00	551	45	566	7105	0.0796622097114708	0.379337162032787	0.379337162032787	false	false	false	true	false
1f955fa2-06aa-43b4-a07f-f7f5855dcc3e	2026-09-28 09:54	2026-09-28 09:54	2026-09-28 09:54	AMZN	AMZN261120P00240000	put	240.0000	2026-11-20	10.7000	10.6500	10.7000	245.4900	136960.00	136960.00	0.00	128	24	173	9743	0.0177563378836087	0.378133751738839	0.378133751738839	true	false	false	true	false
4b1c8239-5f3e-4c9d-9c76-e55879277697	2026-09-28 09:54	2026-09-28 09:54	2026-09-28 09:54	AMZN	AMZN261005C00247500	call	247.5000	2026-10-05	3.1000	3.0000	3.2000	245.7300	12400.00	0.00	11470.00	40	18	147	398	0.369346733668342	0.281791117549451	0.281791117549451	true	false	false	true	false
a6b67634-a380-4a92-89f0-278e9b6b418a	2026-09-28 09:54	2026-09-28 09:54	2026-09-28 09:54	AMZN	AMZN261218P00220000	put	220.0000	2026-12-18	5.6500	5.5500	5.7000	245.7700	1672225.00	696080.00	633190.00	2960	29	2989	10662	0.280341399362221	0.364373654140711	0.363991894094632	true	false	false	true	false
23958c44-d347-4636-9c2b-4a02a76b762a	2026-09-28 09:52	2026-09-28 09:52	2026-09-28 09:52	AMZN	AMZN260928C00247500	call	247.5000	2026-09-28	0.3500	0.3400	0.3500	245.0000	16660.00	16660.00	0.00	476	19	5714	1076	5.31040892193309	0.387901388844803	0.387901388844803	false	false	false	true	false
3ea5a20e-ab18-489d-a46f-75074b0b4522	2026-09-28 09:52	2026-09-28 09:52	2026-09-28 09:52	AMZN	AMZN260928C00245000	call	245.0000	2026-09-28	1.3300	1.3300	1.3800	245.0000	21679.00	0.00	21679.00	163	28	3164	574	5.51219512195122	0.329628859890499	0.348160231904589	true	false	false	true	false
9b7b4f13-e61a-413e-be55-88c064aedc68	2026-09-28 09:51	2026-09-28 09:51	2026-09-28 09:51	AMZN	AMZN260930C00245000	call	245.0000	2026-09-30	2.8300	2.7600	2.8800	245.6950	56566.00	46978.00	0.00	200	6	1484	1082	1.37153419593346	0.335019032497854	0.335019032497854	false	false	false	true	false
ad508bff-ae07-4adf-ac21-24740d1fec72	2026-09-28 09:51	2026-09-28 09:51	2026-09-28 09:51	AMZN	AMZN260930C00247500	call	247.5000	2026-09-30	1.7100	1.6700	1.7100	245.7000	14535.00	14535.00	0.00	85	14	1123	810	1.38641975308642	0.341385147281301	0.341385147281301	false	false	false	true	false
17677f3c-2ee4-4aaf-802a-7c306f391b2c	2026-09-28 09:51	2026-09-28 09:51	2026-09-28 09:51	AMZN	AMZN261120P00245000	put	245.0000	2026-11-20	12.9000	12.7000	12.9000	245.6700	45150.00	45150.00	0.00	35	6	154	7023	0.0219279510180834	0.375584034017348	0.375584034017348	false	false	false	true	false
3cdfc2dc-5910-4b75-9141-850cc098769f	2026-09-28 09:51	2026-09-28 09:50	2026-09-28 09:50	AMZN	AMZN281215C00250000	call	250.0000	2028-12-15	63.2000	63.0000	63.5500	245.6900	189600.00	126400.00	63200.00	30	6	43	6722	0.00639690568283249	0.377713091821708	0.377713091821708	false	false	false	true	false
faf3c349-dbeb-422a-be8f-787285aede45	2026-09-28 09:51	2026-09-28 09:50	2026-09-28 09:50	AMZN	AMZN260928C00245000	call	245.0000	2026-09-28	1.3100	1.3100	1.3600	245.7500	12578.00	0.00	12578.00	96	14	2936	574	5.11498257839721	0.343420138540948	0.33933422182346	true	false	false	true	false
c4e78195-d8d8-430c-8c98-dcaa5e5cee6c	2026-09-28 09:50	2026-09-28 09:50	2026-09-28 09:50	AMZN	AMZN261009C00250000	call	250.0000	2026-10-09	3.4100	3.3500	3.5000	245.7350	10924.00	0.00	10924.00	32	6	126	1895	0.066490765171504	0.300832549745468	0.300832549745468	false	false	false	true	false
20e4944d-f361-41b2-b3ac-b8ef2c7cb5db	2026-09-28 09:48	2026-09-28 09:48	2026-09-28 09:48	AMZN	AMZN261218C00260000	call	260.0000	2026-12-18	11.6200	11.5500	11.6500	245.9500	30212.00	30212.00	0.00	26	5	109	14995	0.00726908969656552	0.355388681542091	0.355388681542091	false	false	false	true	false
c33fc33f-28e5-4d86-9853-58af96d6eb08	2026-09-28 09:47	2026-09-28 09:47	2026-09-28 09:47	AMZN	AMZN261002P00245000	put	245.0000	2026-10-02	2.8200	2.7700	2.8400	246.0350	17202.00	16638.00	564.00	61	12	532	4018	0.132404181184669	0.327858353021103	0.327858353021103	false	false	false	true	false
6cac1aee-b6b0-45ae-b153-92cf2abcd99f	2026-09-28 09:47	2026-09-28 09:47	2026-09-28 09:47	AMZN	AMZN261218C00250000	call	250.0000	2026-12-18	15.7000	15.6500	15.9000	246.0300	15700.00	0.00	15700.00	10	6	108	13921	0.00775806335751742	0.356128176322988	0.356128176322988	true	false	false	true	false
892217e5-d8a2-405a-adfe-5fa148497626	2026-09-28 09:46	2026-09-28 09:46	2026-09-28 09:46	AMZN	AMZN260930P00250000	put	250.0000	2026-09-30	4.9500	4.9500	5.2000	246.0800	1210814.00	0.00	1210814.00	2446	70	2932	1622	1.80764488286067	0.331176214077485	0.350684368583046	false	false	false	true	false
865c6ee5-2b4f-4627-8618-14f41d5b03d7	2026-09-28 09:46	2026-09-28 09:46	2026-09-28 09:46	AMZN	AMZN260930P00252500	put	252.5000	2026-09-30	6.9000	6.9000	7.2500	246.0800	340860.00	0.00	340860.00	494	14	584	313	1.86581469648562	0.313715451511738	0.346209591755695	false	false	false	true	false
64dfba11-778d-4b79-954c-f2b1f682e3bb	2026-09-28 09:46	2026-09-28 09:46	2026-09-28 09:46	AMZN	AMZN261009P00240000	put	240.0000	2026-10-09	2.4900	2.4900	2.6100	246.0850	38346.00	0.00	38346.00	154	15	231	2083	0.110897743638982	0.300312457418515	0.300312457418515	true	false	false	true	false
eb004b18-35bf-4fd4-a8d1-58cce1f8ca19	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	1.9900	1.9900	2.0400	245.9100	39203.00	0.00	39203.00	197	19	1152	1489	0.77367360644728	0.336925057106301	0.336925057106301	true	false	false	true	false
5f6cd494-3f1e-4258-b55e-a2f829a08f21	2026-09-28 09:45	2026-09-28 09:44	2026-09-28 09:44	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	2.0000	1.9600	2.0000	246.0190	45000.00	45000.00	0.00	225	5	1637	34706	0.0471676367198755	0.298545274113612	0.298545274113612	false	false	false	true	false
689a5ecc-c0ee-4b8b-ad3d-27814e438b45	2026-09-28 09:44	2026-09-28 09:44	2026-09-28 09:44	AMZN	AMZN270917P00200000	put	200.0000	2027-09-17	10.9500	10.9000	11.2000	245.9100	24090.00	1095.00	22995.00	22	13	69	2714	0.0254237288135593	0.362529912323534	0.362529912323534	false	false	false	true	false
c1427eed-1f15-4a28-9d8d-83392cccb4ff	2026-09-28 09:44	2026-09-28 09:44	2026-09-28 09:44	AMZN	AMZN261002C00250000	call	250.0000	2026-10-02	1.7900	1.7900	1.8400	245.7100	17900.00	0.00	17900.00	100	8	2024	11289	0.179289573921517	0.337129632595096	0.337129632595096	false	false	false	true	false
5176b735-6229-4c85-a257-d5d06efb58d4	2026-09-28 09:44	2026-09-28 09:44	2026-09-28 09:44	AMZN	AMZN261002P00242500	put	242.5000	2026-10-02	2.0000	1.9900	2.0800	245.7550	22800.00	0.00	22800.00	114	9	718	2645	0.271455576559546	0.335689173027628	0.335689173027628	true	false	false	true	false
219d5b6f-e605-4d6b-b8ac-b80c63ee72ec	2026-09-28 09:43	2026-09-28 09:43	2026-09-28 09:43	AMZN	AMZN261005C00247500	call	247.5000	2026-10-05	3.0000	3.0000	3.2000	245.2500	21330.00	0.00	21330.00	71	7	105	398	0.263819095477387	0.301144455664439	0.289885309290891	true	false	false	true	false
77722c3c-c82e-4a26-8089-b2063d68b41f	2026-09-28 09:42	2026-09-28 09:42	2026-09-28 09:42	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	1.8700	1.8500	1.8900	245.1900	84405.00	71434.00	12971.00	451	5	1368	34706	0.0394168155362185	0.300712813160492	0.301542005259362	false	false	false	true	false
37ec6bee-ed60-452b-9d99-ef97ef391568	2026-09-28 09:42	2026-09-28 09:42	2026-09-28 09:42	AMZN	AMZN260930P00245000	put	245.0000	2026-09-30	2.2400	2.2400	2.3300	245.4200	42112.00	0.00	42112.00	188	17	913	1489	0.61316319677636	0.339194386598717	0.341128036555516	true	false	false	true	false
b3baf130-3b4f-4afd-bbbd-4819df27953d	2026-09-28 09:41	2026-09-28 09:41	2026-09-28 09:41	AMZN	AMZN270115C00275000	call	275.0000	2027-01-15	9.0000	9.0000	9.2000	245.3000	12600.00	0.00	12600.00	14	7	129	64045	0.002014208759466	0.344023856018616	0.344023856018616	false	false	false	true	false