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×sorted by created_at ↑×

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

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	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	1237559831.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
56cf763e-0de6-44a9-be47-d47e2657f5db	2026-08-28 11:23	2026-08-28 11:23	2026-08-28 11:23	XHB	XHB270917P00075000	put	75.0000	2027-09-17	1.8800	1.8300	2.3000	104.2400	12614.00	386.00	12228.00	67	17	67	0	0	0.321764344806217	0.322845856312366	false	false	false	true	false
399c84b5-0734-4e3e-9f1d-ffa11d298f55	2026-08-28 11:24	2026-08-28 11:24	2026-08-28 11:24	XHB	XHB270917P00075000	put	75.0000	2027-09-17	1.7700	1.7100	2.1200	104.3200	30049.00	0.00	30049.00	170	42	378	0	0	0.318417055094944	0.318362963402852	false	false	false	true	false
5336052f-819c-4aa5-a985-d7255e43a237	2026-09-01 12:25	2026-09-01 12:25	2026-09-01 12:25	XHB	XHB260911P00099000	put	99.0000	2026-09-11	0.7900	0.6000	0.7900	101.5100	13667.00	13667.00	0.00	173	18	173	2	86.5	0.272646850249244	0.272646850249244	false	false	false	true	false
15db0bf8-2a9c-4a37-a7ee-6ae03e9bca2f	2026-09-01 12:25	2026-09-01 12:25	2026-09-01 12:25	XHB	XHB260911P00098000	put	98.0000	2026-09-11	0.5900	0.4100	0.5900	101.5100	13629.00	13629.00	0.00	231	5	231	3	77	0.283480182050266	0.283480182050266	false	false	false	true	false
689aead6-dc37-42f2-b73b-f9bd16f9165b	2026-09-01 12:26	2026-09-01 12:26	2026-09-01 12:26	XHB	XHB261009P00100000	put	100.0000	2026-10-09	2.9100	2.4500	3.1000	101.4700	12221.00	11935.00	286.00	42	17	42	0	0	0.292444786942782	0.287710159820038	true	false	false	true	false
39ee64d5-5669-442a-85e4-bb8a2aed5a19	2026-09-01 12:50	2026-09-01 12:50	2026-09-01 12:50	XHB	XHB270319C00109000	call	109.0000	2027-03-19	6.1500	5.7000	6.1500	101.4250	10455.00	10455.00	0.00	17	6	27	4	6.75	0.277014774127394	0.277014774127394	false	false	false	true	false
10e9c035-2593-48e5-b3bc-74ca0ee744e5	2026-09-02 12:17	2026-09-02 12:17	2026-09-02 12:17	XHB	XHB261016P00095000	put	95.0000	2026-10-16	1.4300	1.4300	1.5700	101.4800	28171.00	0.00	28171.00	197	36	197	829	0.237635705669481	0.29248120072321	0.29248120072321	false	false	false	true	false
de4a7dcf-6c90-451b-8eb2-115870714d6b	2026-09-02 15:07	2026-09-02 15:07	2026-09-02 15:07	XHB	XHB260911P00101000	put	101.0000	2026-09-11	1.4900	1.2300	1.4900	101.5200	10728.00	10728.00	0.00	72	10	653	74	8.82432432432432	0.280794283366158	0.280794283366158	false	false	false	true	false
02810bed-5c29-422c-a77b-2c09aacb29e4	2026-09-02 15:41	2026-09-02 15:41	2026-09-02 15:41	XHB	XHB260911P00101000	put	101.0000	2026-09-11	1.5300	1.5300	1.7700	101.2950	11169.00	0.00	6885.00	73	5	844	74	11.4054054054054	0.271207384648585	0.271207384648585	false	false	false	true	false
7ddb201c-c6c4-4eb3-bada-a140152308b8	2026-09-02 15:43	2026-09-02 15:43	2026-09-02 15:43	XHB	XHB260911P00101000	put	101.0000	2026-09-11	1.5400	1.3300	1.5500	101.3300	10950.00	5868.00	3388.00	71	10	1136	74	15.3513513513514	0.276901129809045	0.27531469649356	false	false	false	true	false
7dfb4d23-fd76-4842-bd83-c7dd71f5ab2d	2026-09-02 15:43	2026-09-02 15:43	2026-09-02 15:43	XHB	XHB260911P00101000	put	101.0000	2026-09-11	1.5500	1.3300	1.5700	101.3500	11935.00	2480.00	9455.00	77	5	1213	74	16.3918918918919	0.278335873805431	0.278335873805431	false	false	false	true	false
652803a3-a08e-4894-a9d1-ca24f0d1cbbd	2026-09-03 10:03	2026-09-03 10:03	2026-09-03 10:03	XHB	XHB261023P00114000	put	114.0000	2026-10-23	13.1000	11.2000	13.2500	101.5300	14415.00	13095.00	1320.00	11	11	11	0	0	0.327029659391287	0.333112327848281	true	false	false	true	false
7cb7e05d-e05f-493f-ac62-3b24a9a5f048	2026-09-03 10:32	2026-09-03 10:32	2026-09-03 10:32	XHB	XHB260925P00113500	put	113.5000	2026-09-25	12.6900	10.3000	12.8000	101.1100	12690.00	7590.00	5100.00	10	7	11	0	0	0.37562848161491	0.395193602013457	true	false	false	true	false
07dc5eaa-dba6-4e9c-b27e-0b461a5d2bc2	2026-09-03 10:32	2026-09-03 10:32	2026-09-03 10:32	XHB	XHB260925P00111000	put	111.0000	2026-09-25	10.3000	8.3500	10.5000	101.0800	17505.00	15450.00	2055.00	17	17	17	2	8.5	0.343998515586254	0.343998515586254	true	false	false	true	false
889e0080-6852-44c6-8be0-6ac19311d0e2	2026-09-04 11:51	2026-09-04 11:51	2026-09-04 11:51	XHB	XHB270319P00102000	put	102.0000	2027-03-19	7.4500	7.2000	7.4500	103.0500	10430.00	10430.00	0.00	14	5	24	6	4	0.298797915807792	0.298797915807792	false	false	false	true	false
549bfd5b-dd23-41ea-9d41-5f35ffe2771c	2026-09-04 15:54	2026-09-04 15:54	2026-09-04 15:54	XHB	XHB270319P00102000	put	102.0000	2027-03-19	7.4000	7.1000	7.4000	103.3700	11100.00	11100.00	0.00	15	5	71	6	11.8333333333333	0.301480130024472	0.301480130024472	false	false	false	true	false
38ac9007-f6d5-4ddd-a2e9-ba6e17548ed5	2026-09-08 09:42	2026-09-08 09:42	2026-09-08 09:42	XHB	XHB261016P00117000	put	117.0000	2026-10-16	15.4800	13.4500	15.5000	101.9000	15475.00	15475.00	0.00	10	5	10	0	0	0.366355636870632	0.373074450772685	true	false	false	true	false
875aa8df-bb62-4748-b7dd-26902c675a81	2026-09-08 10:06	2026-09-08 10:06	2026-09-08 10:06	XHB	XHB260925C00103000	call	103.0000	2026-09-25	1.9600	1.9500	2.9100	101.7800	26813.00	0.00	26813.00	137	13	137	88	1.55681818181818	0.277547168330946	0.276394774750092	true	false	false	true	false
dd5596f3-0698-48b0-ac4d-8468d0af053e	2026-09-08 11:55	2026-09-08 11:55	2026-09-08 11:55	XHB	XHB261016C00111000	call	111.0000	2026-10-16	0.9100	0.7500	1.3700	101.5500	182000.00	0.00	182000.00	2000	1	2000	8	250	0.281997926165805	0.281997926165805	false	true	false	true	true
c45611d6-338f-41f1-8f33-14cc2f04fbba	2026-09-08 11:58	2026-09-08 11:58	2026-09-08 11:58	XHB	XHB260925P00105500	put	105.5000	2026-09-25	5.1500	4.5500	5.2500	101.5300	16480.00	15965.00	515.00	32	19	39	12	3.25	0.322407784493654	0.322407784493654	true	false	false	true	false