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:option_symbol = AMZN261016C00260000×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

7fa47a8b-c447-4ea6-b778-c151d3245047	2026-09-22 14:12	2026-09-22 14:12	2026-09-22 14:12	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	6.0000	6.0000	6.0500	255.2700	17400.00	0.00	17400.00	29	5	9145	27807	0.328874024526198	0.29840659992212	0.29874340136091	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	2750294234589.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T18:18:27.911867Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
6746f822-0575-4f9a-920c-3bf231482df0	2026-09-22 14:02	2026-09-22 14:02	2026-09-22 14:02	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	6.2200	6.1500	6.2500	255.7500	16792.00	6220.00	10572.00	27	6	8651	27807	0.311108713633258	0.299113433334605	0.299113433334605	false	false	false	true
5da65f44-8b0c-40ad-a445-ea4f5056f1ff	2026-09-22 13:01	2026-09-22 13:01	2026-09-22 13:01	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	5.6500	5.6000	5.7000	254.0000	110165.00	84175.00	0.00	195	11	8074	27807	0.290358542812961	0.297546871646413	0.297546871646413	true	false	false	true
48779bee-5b13-4d60-bdf0-b1f1ca44e39b	2026-09-22 12:30	2026-09-22 12:30	2026-09-22 12:30	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	5.5500	5.5000	5.6000	254.3000	38295.00	33300.00	0.00	69	5	7487	27807	0.269248750314669	0.297211516663302	0.297211516663302	false	false	false	true
4157f2cf-6960-4837-9f64-23c0fcee00f3	2026-09-22 11:26	2026-09-22 11:26	2026-09-22 11:26	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	6.2500	6.2500	6.3500	255.0000	71250.00	0.00	71250.00	114	14	5131	27807	0.184521882979106	0.296837514932669	0.297353753666727	false	false	false	true
8db564d1-9a45-4f5c-b00a-84fc65c1a4c3	2026-09-22 11:14	2026-09-22 11:14	2026-09-22 11:14	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	6.0000	5.9500	6.1500	255.3950	34200.00	0.00	34200.00	57	12	4808	27807	0.172906102779876	0.296635746976147	0.296635746976147	false	false	false	true
41e8c47b-e5a6-4490-8f59-1f15c0ab8d2a	2026-09-22 10:38	2026-09-22 10:38	2026-09-22 10:38	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	6.9000	6.9000	6.9500	257.2110	11730.00	0.00	11730.00	17	10	3789	27807	0.136260653792211	0.299525302077308	0.299525302077308	true	false	false	true
2bb0126e-19a2-45ef-9a42-eb29492f19ed	2026-09-22 10:38	2026-09-22 10:38	2026-09-22 10:38	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	6.9400	6.9000	6.9500	257.2300	56177.00	47893.00	8284.00	81	26	3734	27807	0.134282734563239	0.300908768220067	0.300706474941257	false	false	false	true
552d9baf-879e-4e8b-8906-aa5adda2bbcc	2026-09-22 10:36	2026-09-22 10:36	2026-09-22 10:36	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	6.7500	6.6500	6.7500	256.9100	13500.00	13500.00	0.00	20	6	3599	27807	0.12942784191031	0.299197485857929	0.299197485857929	true	false	false	true	false
61896b53-f623-438d-8612-4162beaa8b9c	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	6.3600	6.0000	6.6000	255.3100	11450.00	7205.00	4245.00	18	8	54	27807	0.00194195706117165	0.304735183961831	0.298069638002342	true	false	false	true
77e17f64-25a4-4e53-a312-a60c587c7c49	2026-09-21 15:48	2026-09-21 15:47	2026-09-21 15:47	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	7.9800	7.9000	8.0000	258.0000	39900.00	39900.00	0.00	50	5	11518	27073	0.425442322609242	0.304544500331538	0.304544500331538	false	false	false	true
c47bece4-8048-47e9-9df9-8ed3ee615551	2026-09-21 15:42	2026-09-21 15:42	2026-09-21 15:42	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	7.8500	7.8250	7.9500	258.5800	10990.00	0.00	9420.00	14	5	11364	27073	0.419753998448639	0.303465029130912	0.303465029130912	false	false	false	true
29ad6388-80e3-40c1-b66d-5323dd88e4ea	2026-09-21 15:03	2026-09-21 15:03	2026-09-21 15:03	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	7.8500	7.8500	8.0000	258.0000	56530.00	0.00	56530.00	72	14	8949	27073	0.330550733202822	0.302534595477839	0.302534595477839	true	false	false	true
3848b5b6-90b0-4b8d-b7ac-a0200cc93940	2026-09-21 15:02	2026-09-21 15:02	2026-09-21 15:02	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	8.0000	7.9000	8.0000	258.0000	17596.00	17596.00	0.00	22	9	8867	27073	0.32752188527315	0.303692385826574	0.303692385826574	false	false	false	true
8663379e-5e04-4070-82e6-fd1f8e9c479d	2026-09-21 14:50	2026-09-21 14:50	2026-09-21 14:50	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	7.7500	7.7500	7.8500	258.4400	177475.00	0.00	177475.00	229	15	8713	27073	0.321833561112548	0.302356500265525	0.302356500265525	true	false	false	true
d8623daa-475b-4d20-9b68-da23d2aace0b	2026-09-21 14:09	2026-09-21 14:09	2026-09-21 14:09	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	7.7000	7.6000	7.8000	258.0000	17710.00	4620.00	11550.00	23	6	7793	27073	0.287851364828427	0.302257565023767	0.302257565023767	false	false	false	true
cc6c8fa7-2b6d-4673-8b0c-a1318669f169	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	8.0000	7.9500	8.0000	258.0000	29600.00	29600.00	0.00	37	10	7489	27073	0.276622465186717	0.301999534211664	0.301999534211664	false	false	false	true
a312039e-aec0-4852-bf1e-2dcdb99a97e7	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	7.9000	7.9000	7.9500	258.0000	39500.00	0.00	39500.00	50	7	7419	27073	0.274036863295534	0.301255592387542	0.301255592387542	true	false	false	true
d3452459-4a6a-4171-80a2-de21ed7e04e8	2026-09-21 13:04	2026-09-21 13:04	2026-09-21 13:04	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	7.4000	7.3500	7.4000	257.7800	14800.00	14800.00	0.00	20	5	7007	27073	0.258818749307428	0.301434086207863	0.301434086207863	false	false	false	true
dd794571-2660-4a55-886f-c0188367f68a	2026-09-21 12:47	2026-09-21 12:47	2026-09-21 12:47	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	7.7000	7.6500	7.7000	258.3886	22330.00	22330.00	0.00	29	12	6428	27073	0.237432127950356	0.301888716205411	0.30145318047914	true	false	false	true
af52089d-b219-44df-94a9-90627448594c	2026-09-21 12:37	2026-09-21 12:37	2026-09-21 12:37	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	7.7000	7.6500	7.7500	258.2846	40040.00	33110.00	6930.00	52	7	4971	27073	0.183614671443874	0.303270727494642	0.303370109445048	false	false	false	true
1457b346-0b7d-4364-a583-198f026934ca	2026-09-21 12:30	2026-09-21 12:30	2026-09-21 12:30	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	7.5000	7.4500	7.5000	257.0000	107250.00	107250.00	0.00	143	5	4581	27073	0.169209175192997	0.301977402065616	0.301977402065616	false	false	false	true
c0c11265-4517-4884-a99e-f48a8c06c453	2026-09-21 12:07	2026-09-21 12:07	2026-09-21 12:07	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	7.0000	6.9500	7.0000	257.0800	18200.00	18200.00	0.00	26	14	4063	27073	0.150075721198242	0.299024534876528	0.299024534876528	false	false	false	true
df3b2c52-6f78-43f6-b291-c75a4776179c	2026-09-18 10:27	2026-09-18 10:27	2026-09-18 10:27	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	5.2500	5.2000	5.2500	252.4900	303430.00	303430.00	0.00	578	46	1942	25042	0.0775497164763198	0.289234404961528	0.289234404961528	false	false	false	true
70d39fcc-cf79-4731-843d-a7c5bb4bad44	2026-09-16 13:06	2026-09-16 13:06	2026-09-16 13:06	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	4.2500	4.2500	4.4000	247.7100	112200.00	0.00	112200.00	264	6	2659	23013	0.115543388519532	0.304365247289703	0.304365247289703	false	false	false	true
02994158-a32f-4259-abd1-0aae81a64b9c	2026-09-09 15:00	2026-09-09 15:00	2026-09-09 15:00	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	7.2000	7.1500	7.2000	252.2850	123840.00	123840.00	0.00	172	19	4972	18791	0.264594752807195	0.314177364448462	0.314177364448462	true	false	false	true
518c31ac-3c0d-4ead-b92f-1ba6c6a286dc	2026-09-04 15:45	2026-09-04 15:45	2026-09-04 15:45	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	10.4500	10.4250	10.5000	258.4800	104540.00	20940.00	83600.00	100	9	3980	17892	0.222445785826068	0.303468097566655	0.304261436118166	false	false	false	true
a9b4f188-6b51-4dca-a8b8-54a802bff94b	2026-09-04 10:04	2026-09-04 10:04	2026-09-04 10:04	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	10.1000	10.0000	10.2000	258.3140	101000.00	10100.00	75750.00	100	6	317	17892	0.0177174156047395	0.296114236399106	0.296114236399106	false	false	false	true
2639ebf8-f461-44c5-8192-468f8f870b7b	2026-08-27 13:20	2026-08-27 13:20	2026-08-27 13:20	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	9.8600	9.7500	9.9500	255.5450	612025.00	424525.00	118200.00	621	56	2780	15534	0.178962276297155	0.299049298308541	0.30007054771865	true	false	false	true
f0f9a2c6-90dc-4138-b8fb-8b0f4da7c693	2026-08-27 12:47	2026-08-27 12:47	2026-08-27 12:47	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	10.1500	10.1000	10.3000	256.4100	201985.00	0.00	201985.00	199	6	1949	15534	0.125466718166602	0.295595141239212	0.295595141239212	false	false	false	true
5c73daa4-5476-4484-9268-9dee357be88e	2026-08-18 11:19	2026-08-18 11:19	2026-08-18 11:19	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	13.5000	13.5000	13.6000	260.5717	116100.00	0.00	116100.00	86	10	697	15047	0.0463215258855586	0.297718244184661	0.297718244184661	false	false	false	true
e191b929-5f60-4d63-b544-bfb711a85853	2026-08-18 11:18	2026-08-18 11:18	2026-08-18 11:18	AMZN	AMZN261016C00260000	call	260.0000	2026-10-16	13.5500	13.5500	13.7000	260.6200	109755.00	0.00	109755.00	81	6	427	15047	0.0283777497175517	0.298281459132726	0.298281459132726	false	false	false	true