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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = XHB×

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

d4b60308-9c82-4470-9678-de722fc9d9b7	2026-08-28 11:18	2026-08-28 11:18	2026-08-28 11:18	XHB	XHB260904C00102000	call	102.0000	2026-09-04	2.8900	2.7700	2.8900	104.1950	29189.00	29189.00	0.00	101	5	102	0	0	0.26135840708156	0.26135840708156	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	1237559831.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c5cb46f1-6ac0-43f7-a8f9-2cff9f6cd320	2026-08-27 14:07	2026-08-27 14:07	2026-08-27 14:07	XHB	XHB260925P00120000	put	120.0000	2026-09-25	15.5000	14.3000	15.5000	104.6400	10850.00	10850.00	0.00	7	6	12	0	0	0.361306197581182	0.361306197581182	true	false	false	true	false
93ef6601-e597-4e88-8acd-0aa40333e409	2026-08-27 14:00	2026-08-27 14:00	2026-08-27 14:00	XHB	XHB260925C00103000	call	103.0000	2026-09-25	4.3000	4.2500	4.6500	104.7600	37845.00	0.00	37845.00	88	26	88	0	0	0.270764563273457	0.270764563273457	true	false	false	true	false
f1ecda1f-1ea8-48c3-b8f2-50513e201b98	2026-08-27 11:55	2026-08-27 11:55	2026-08-27 11:55	XHB	XHB261218C00092000	call	92.0000	2026-12-18	15.9000	15.9000	16.4500	105.2600	31800.00	0.00	31800.00	20	18	21	33	0.636363636363636	0.288958818984939	0.288958818984939	false	false	false	true	false
26b22cf3-ab00-4831-ada3-ca4c8b205ae9	2026-08-27 11:19	2026-08-27 11:19	2026-08-27 11:19	XHB	XHB270617P00075000	put	75.0000	2027-06-17	1.3600	1.3600	1.5800	105.4500	10744.00	0.00	10744.00	79	10	152	1	152	0.335947543444097	0.336004847529111	false	false	false	true	false
87c24386-1dfe-4c98-aeb2-43f14357b85a	2026-08-25 15:40	2026-08-25 15:39	2026-08-25 15:39	XHB	XHB260918P00106000	put	106.0000	2026-09-18	2.9000	2.8600	3.0000	106.1200	29000.00	26680.00	1160.00	100	6	350	417	0.839328537170264	0.285043255631803	0.285043255631803	false	false	false	true	false
5286b8de-08c6-4993-98e6-71d715d5953a	2026-08-25 15:39	2026-08-25 15:39	2026-08-25 15:39	XHB	XHB260918P00106000	put	106.0000	2026-09-18	2.9000	2.8500	2.9000	106.1200	14500.00	14500.00	0.00	50	6	250	417	0.599520383693046	0.285043255631803	0.285043255631803	false	false	false	true	false
30a202fa-004d-4e91-96b0-01d57b0dc731	2026-08-25 15:39	2026-08-25 15:39	2026-08-25 15:39	XHB	XHB260918P00106000	put	106.0000	2026-09-18	2.8500	2.7400	2.8500	106.1300	14250.00	12540.00	0.00	50	6	200	417	0.479616306954436	0.280850572793841	0.280850572793841	false	false	false	true	false
8921ed8e-3f86-4454-9899-707b9f876afe	2026-08-25 15:29	2026-08-25 15:29	2026-08-25 15:29	XHB	XHB260918C00106000	call	106.0000	2026-09-18	3.2500	3.2500	3.4000	106.1100	11700.00	0.00	11700.00	36	15	43	357	0.120448179271709	0.282409312282766	0.282409312282766	false	false	false	true	false
c83339ee-80a3-4303-a111-3569f893bccf	2026-08-25 12:43	2026-08-25 12:42	2026-08-25 12:42	XHB	XHB260918C00114000	call	114.0000	2026-09-18	0.7200	0.6600	0.7200	105.8300	16704.00	16704.00	0.00	232	19	1296	175	7.40571428571429	0.289455241854318	0.289455241854318	false	false	false	true	false
09d6369e-22a7-46a8-baae-d388048621d2	2026-08-25 12:41	2026-08-25 12:41	2026-08-25 12:41	XHB	XHB260918C00114000	call	114.0000	2026-09-18	0.7200	0.6500	0.7200	105.8500	66671.00	66600.00	71.00	926	50	978	175	5.58857142857143	0.288953936969968	0.288953936969968	false	false	false	true	false
782022b2-6a7d-445c-8ea7-fb3d051a53db	2026-08-25 12:19	2026-08-25 12:19	2026-08-25 12:19	XHB	XHB260918C00115000	call	115.0000	2026-09-18	0.5500	0.5000	0.5500	105.9250	15950.00	15950.00	0.00	290	23	2093	1915	1.09295039164491	0.282933439257713	0.282933439257713	false	false	false	true	false
b1878b31-3ae9-478e-b4d1-81746a230a62	2026-08-25 12:15	2026-08-25 12:15	2026-08-25 12:15	XHB	XHB260918C00115000	call	115.0000	2026-09-18	0.5600	0.5500	0.5600	105.9900	14672.00	14672.00	0.00	262	20	1727	1915	0.901827676240209	0.283025905575317	0.283025905575317	false	false	false	true	false
06af79e3-799c-4351-9fcb-f6d6b40b453f	2026-08-21 14:26	2026-08-21 14:26	2026-08-21 14:26	XHB	XHB261016P00095000	put	95.0000	2026-10-16	0.9300	0.9300	1.1300	106.6150	70334.00	212.00	70122.00	756	40	759	2	379.5	0.300585992542962	0.314364756779671	false	false	false	true	false
dc19a8a6-9d76-4036-9cb3-082bd1005292	2026-08-21 12:20	2026-08-21 12:20	2026-08-21 12:20	XHB	XHB261016P00111000	put	111.0000	2026-10-16	7.3000	6.6500	7.3000	106.3400	30660.00	30660.00	0.00	42	18	42	0	0	0.297834319318847	0.297834319318847	true	false	false	true	false
25b25689-5c5f-4d26-a4c0-f1741c730176	2026-08-21 11:38	2026-08-21 11:38	2026-08-21 11:38	XHB	XHB260828C00105000	call	105.0000	2026-08-28	2.5500	2.5500	2.7200	106.5350	11475.00	0.00	11475.00	45	16	162	0	0	0.277050864216326	0.277050864216326	false	false	false	true	false
d60fc888-db8a-4814-80f9-4ddebf036666	2026-08-21 11:35	2026-08-21 11:35	2026-08-21 11:35	XHB	XHB260828C00105000	call	105.0000	2026-08-28	2.5700	2.4700	2.5800	106.5800	17990.00	4626.00	8995.00	70	7	117	0	0	0.275215870404766	0.275215870404766	false	false	false	true	false
f9f915da-0b1c-4382-9313-3c8ccf3ca35a	2026-08-20 12:22	2026-08-20 12:22	2026-08-20 12:22	XHB	XHB260828P00104500	put	104.5000	2026-08-28	1.2600	0.8900	1.2600	106.0300	15120.00	15120.00	0.00	120	24	131	6	21.8333333333333	0.315935799513959	0.315935799513959	false	false	false	true	false
59f0b326-7bc0-4236-ab1f-8c3ae26fbc61	2026-08-19 13:15	2026-08-19 13:15	2026-08-19 13:15	XHB	XHB260828P00107000	put	107.0000	2026-08-28	1.2000	0.9700	1.3600	108.7000	420000.00	420000.00	0.00	3500	2	3501	4	875.25	0.291818784278654	0.291818784278654	false	true	true	false	true
18c41888-7db4-4747-b697-714dfe029803	2026-08-19 12:49	2026-08-19 12:49	2026-08-19 12:49	XHB	XHB260918P00100000	put	100.0000	2026-09-18	0.7900	0.7900	0.9000	108.6100	85873.00	0.00	85873.00	1087	17	1096	4848	0.226072607260726	0.305440996966699	0.305440996966699	false	false	false	true	false
3083afe0-c52a-4970-82ec-3a8ac311fd6d	2026-08-18 15:44	2026-08-18 15:44	2026-08-18 15:44	XHB	XHB261218P00105000	put	105.0000	2026-12-18	6.1400	5.9500	6.5500	106.3550	31324.00	0.00	31324.00	51	6	62	1389	0.0446364290856731	0.307097782664433	0.307097782664433	false	false	false	true	false
7531de02-bf22-471b-8e91-6f05ec58fedf	2026-08-18 11:18	2026-08-18 11:18	2026-08-18 11:18	XHB	XHB260918C00115000	call	115.0000	2026-09-18	1.0000	0.8200	1.2500	106.8700	157500.00	100.00	157400.00	1575	28	1575	291	5.41237113402062	0.282555485539487	0.282555485539487	false	false	false	true	false
a3e443bb-5414-41d4-97d3-ae6545933574	2026-08-18 10:44	2026-08-18 10:43	2026-08-18 10:43	XHB	XHB260828C00109000	call	109.0000	2026-08-28	1.3100	1.3100	1.5700	107.0200	14148.00	0.00	14148.00	108	7	176	553	0.318264014466546	0.296529852700861	0.296529852700861	true	false	false	true	false
cc0f0e9a-e8d9-446b-9ca5-463dd9ea30d2	2026-08-18 09:37	2026-08-18 09:37	2026-08-18 09:37	XHB	XHB260918C00110000	call	110.0000	2026-09-18	2.1400	2.1400	2.5400	106.3822	16050.00	0.00	16050.00	75	25	75	7791	0.00962649210627647	0.281505206614476	0.281505206614476	false	false	false	true	false
c7cbdc56-9752-4e16-a595-2f30b79742d7	2026-08-17 15:15	2026-08-17 15:15	2026-08-17 15:15	XHB	XHB261218P00098000	put	98.0000	2026-12-18	2.9500	2.7500	3.2500	108.2200	102660.00	3245.00	99415.00	348	47	843	1	843	0.308797965884166	0.308797965884166	true	false	false	true	false
4aec59c7-394f-43aa-9945-de8b8bea421f	2026-08-17 13:47	2026-08-17 13:47	2026-08-17 13:47	XHB	XHB261218P00098000	put	98.0000	2026-12-18	2.9700	2.9700	3.3000	108.0000	65637.00	0.00	65637.00	221	33	495	1	495	0.310073795711867	0.310073795711867	false	false	false	true	false
8f2469c6-50ae-490b-bd03-6737ed58fe10	2026-08-17 13:17	2026-08-17 13:16	2026-08-17 13:16	XHB	XHB260828C00109000	call	109.0000	2026-08-28	1.8500	1.8500	2.0200	108.1900	40515.00	0.00	40515.00	219	5	219	0	0	0.289473419392554	0.289473419392554	false	false	false	true	false
d542a78b-c46e-4d43-bfb6-a7dab217edff	2026-08-17 12:23	2026-08-17 12:23	2026-08-17 12:23	XHB	XHB261218P00098000	put	98.0000	2026-12-18	3.0000	3.0000	3.5000	108.2100	75300.00	0.00	75300.00	251	29	252	1	252	0.311251669485234	0.311251669485234	false	false	false	true	false
5fe28b28-cf2d-4bde-95cd-c42b9d93dc14	2026-08-17 12:01	2026-08-17 12:01	2026-08-17 12:01	XHB	XHB270617P00108000	put	108.0000	2027-06-17	10.2200	9.8000	10.9500	107.9000	20445.00	0.00	20445.00	20	6	20	0	0	0.307857214353983	0.307857214353983	false	false	false	true	false
09c8dc1e-14a2-408f-a0a4-b1f48eae69e6	2026-08-17 11:58	2026-08-17 11:58	2026-08-17 11:58	XHB	XHB280121P00075000	put	75.0000	2028-01-21	2.6200	2.6200	2.9100	107.8400	10480.00	0.00	10480.00	40	6	238	6	39.6666666666667	0.336471840805367	0.336471840805367	false	false	false	true	false