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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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

89386ee9-f99a-4f06-a42e-8387fd1e011d	2026-09-10 14:48	2026-09-10 14:48	2026-09-10 14:48	XHB	XHB261030P00104000	put	104.0000	2026-10-30	9.0500	6.7500	9.0500	96.3800	11760.00	11760.00	0.00	13	8	13	0	0	0.31885300424507	0.31885300424507	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	1260949095.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
8dbd4fa4-a2d6-46c1-8d11-cf29479e0dd5	2026-09-10 12:42	2026-09-10 12:42	2026-09-10 12:42	XHB	XHB260918P00095000	put	95.0000	2026-09-18	1.1300	0.9900	1.1300	96.0000	24069.00	24069.00	0.00	213	21	716	1756	0.407744874715262	0.345932766683144	0.345932766683144	false	false	false	true
5cb57991-d78a-4181-b819-c7a3b40faf8e	2026-09-10 10:43	2026-09-10 10:43	2026-09-10 10:43	XHB	XHB260911P00097000	put	97.0000	2026-09-11	1.2000	0.9200	1.4000	96.8950	56880.00	1200.00	55680.00	474	19	475	34	13.9705882352941	0.56907380433808	0.56907380433808	false	false	false	true
8eca80f5-c464-4776-bdea-596f0ac3d4f7	2026-09-10 09:47	2026-09-10 09:47	2026-09-10 09:47	XHB	XHB261002P00107500	put	107.5000	2026-10-02	11.1900	9.6000	11.2000	96.6700	13425.00	13425.00	0.00	12	10	12	7	1.71428571428571	0.376722175440286	0.376722175440286	true	false	false	true
f8fcb427-6f7f-46d9-a2a0-109850d886b5	2026-09-10 09:30	2026-09-10 09:30	2026-09-10 09:30	XHB	XHB260918P00111000	put	111.0000	2026-09-18	13.2500	11.9500	13.9000	97.4300	26500.00	26500.00	0.00	20	5	20	20	1	0.654273827354932	0.654273827354932	false	false	false	true
8ec17a73-3ce6-4f6d-b6a8-a5986d3026c2	2026-09-09 12:37	2026-09-09 12:36	2026-09-09 12:36	XHB	XHB261218C00115000	call	115.0000	2026-12-18	1.4200	1.3000	1.4200	99.1300	180766.00	180766.00	0.00	1273	25	1279	37	34.5675675675676	0.277579006031024	0.277579006031024	false	false	false	true
39354c06-a75a-493b-a62f-0625683200a8	2026-09-09 10:55	2026-09-09 10:55	2026-09-09 10:55	XHB	XHB260925P00090000	put	90.0000	2026-09-25	0.1600	0.0600	0.2300	99.9100	30784.00	16.00	30768.00	1924	20	1924	11	174.909090909091	0.322990059533249	0.322990059533249	false	false	false	true
59d2cf67-8ece-4f66-8230-497d0c1b73db	2026-09-09 10:22	2026-09-09 10:22	2026-09-09 10:22	XHB	XHB270115C00110000	call	110.0000	2027-01-15	3.4000	3.2000	3.4000	100.3700	38760.00	38760.00	0.00	114	19	180	82	2.19512195121951	0.27327432148056	0.27327432148056	false	false	false	true
44d7d142-b7ef-48ec-bb22-3bef63ec66ea	2026-09-08 15:57	2026-09-08 15:57	2026-09-08 15:57	XHB	XHB260918C00105000	call	105.0000	2026-09-18	0.7600	0.5500	0.7700	100.8600	30096.00	27436.00	2660.00	396	36	2253	662	3.40332326283988	0.326350340855692	0.326350340855692	false	false	false	true
1e86f2e6-b676-4e1b-b4cf-669eb41b95f5	2026-09-08 15:57	2026-09-08 15:57	2026-09-08 15:57	XHB	XHB260918C00105000	call	105.0000	2026-09-18	0.7700	0.5500	0.7800	100.8900	30415.00	30415.00	0.00	395	5	1753	662	2.64803625377644	0.326865551600394	0.326865551600394	false	false	false	true
c327567c-bd0e-4fe4-8454-d41ee4521881	2026-09-08 15:54	2026-09-08 15:54	2026-09-08 15:54	XHB	XHB260918C00105000	call	105.0000	2026-09-18	0.7500	0.6900	0.7600	100.9500	28275.00	22575.00	2250.00	377	16	656	662	0.990936555891239	0.320254139373489	0.320254139373489	false	false	false	true
e2e29af9-3258-458c-a487-1d199ee578b7	2026-09-08 15:50	2026-09-08 15:50	2026-09-08 15:50	XHB	XHB260918C00105000	call	105.0000	2026-09-18	0.7500	0.7500	1.0900	101.1000	13950.00	0.00	13950.00	186	13	279	662	0.421450151057402	0.313261903420714	0.313261903420714	false	false	false	true
1e78111f-bc74-4c55-b868-a8b2aa77d666	2026-09-08 14:49	2026-09-08 14:48	2026-09-08 14:48	XHB	XHB261002P00104500	put	104.5000	2026-10-02	4.9500	4.1000	4.9500	101.2800	11380.00	10890.00	490.00	23	19	23	0	0	0.31006655350481	0.31006655350481	true	false	false	true
85b712fa-2cc0-41dc-a718-1b07fb868bb9	2026-09-08 14:00	2026-09-08 14:00	2026-09-08 14:00	XHB	XHB261218P00100000	put	100.0000	2026-12-18	5.0000	5.0000	5.2500	101.3300	87506.00	0.00	87506.00	175	34	176	446	0.394618834080717	0.292496846688056	0.292496846688056	false	false	false	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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