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:endpoint = /api/option-trades/flow-alerts×ticker = XLB×

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

fb15570c-020c-4230-ba53-d34bb9b1cba1	2026-09-22 15:48	2026-09-22 15:48	2026-09-22 15:48	XLB	XLB261218C00053000	call	53.0000	2026-12-18	1.0600	0.8800	1.0600	50.6250	10600.00	10600.00	0.00	100	21	660	986	0.669371196754564	0.183253968294758	0.183253968294758	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	8016201232.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
7dcdab37-a178-4819-9f5d-9033deabb447	2026-09-22 14:43	2026-09-22 14:43	2026-09-22 14:43	XLB	XLB261218P00052000	put	52.0000	2026-12-18	2.3700	2.2200	2.3700	50.4700	61620.00	61620.00	0.00	260	30	305	801	0.380774032459426	0.183081976762523	0.183081976762523	false	false	false	true
f04926e1-90d5-4bfa-a324-a2bb26bb6348	2026-09-22 13:29	2026-09-22 13:29	2026-09-22 13:29	XLB	XLB261016P00050000	put	50.0000	2026-10-16	0.7100	0.6700	0.7100	50.2850	11715.00	11715.00	0.00	165	22	276	2230	0.123766816143498	0.176160821380292	0.176160821380292	false	false	false	true
f7b8ee5b-d19e-40b6-a18e-cbdccfc4be87	2026-09-22 12:07	2026-09-22 12:07	2026-09-22 12:07	XLB	XLB261218C00052000	call	52.0000	2026-12-18	1.1900	1.0600	1.1900	50.1600	11424.00	11424.00	0.00	96	21	113	139	0.81294964028777	0.179344083412768	0.179344083412768	false	false	false	true
b2aa4bf6-2435-4af2-9519-a793349c21dc	2026-09-21 13:39	2026-09-21 13:39	2026-09-21 13:39	XLB	XLB270115P00050000	put	50.0000	2027-01-15	1.9100	1.8800	1.9100	49.8450	93017.00	93017.00	0.00	487	31	487	6905	0.0705286024619841	0.193542252072835	0.193542252072835	false	false	false	true
03d409ec-8f04-4472-b64b-6c85b53d9d6f	2026-09-21 13:32	2026-09-21 13:32	2026-09-21 13:32	XLB	XLB261218C00054000	call	54.0000	2026-12-18	0.5500	0.4700	0.6900	49.9050	10132.00	0.00	9912.00	184	5	185	200	0.925	0.177481729497037	0.181509695397709	false	false	false	true
0d5c660b-d975-4697-b607-6798b3863fa5	2026-09-21 11:50	2026-09-21 11:50	2026-09-21 11:50	XLB	XLB261009C00050000	call	50.0000	2026-10-09	0.8100	0.6900	0.8100	49.8750	11177.00	11177.00	0.00	138	23	139	3	46.3333333333333	0.18634159374716	0.18634159374716	true	false	false	true
47e99de6-64a6-4211-8653-5f49ced09bb2	2026-09-21 10:32	2026-09-21 10:32	2026-09-21 10:32	XLB	XLB261016P00048000	put	48.0000	2026-10-16	0.3900	0.3600	0.5000	49.8650	15286.00	0.00	15286.00	396	23	444	580	0.76551724137931	0.218596158722531	0.210935067209694	true	false	false	true
27344781-e92d-4c58-8c2d-54c152462bce	2026-09-18 10:39	2026-09-18 10:39	2026-09-18 10:39	XLB	XLB261218C00053000	call	53.0000	2026-12-18	0.8600	0.7100	0.8600	50.0400	13669.00	13500.00	169.00	159	30	160	624	0.256410256410256	0.178540095950543	0.177831734943556	true	false	false	true
7441fd25-a816-470d-96b7-966d69981acd	2026-09-16 16:00	2026-09-16 15:59	2026-09-16 15:59	XLB	XLB261016C00052000	call	52.0000	2026-10-16	0.4300	0.4300	0.6200	50.0000	11954.00	0.00	11954.00	278	15	1637	309	5.29773462783171	0.170244531854326	0.170244531854326	false	false	false	true
e8bbf5ef-845f-4f83-b133-6776d3bc7264	2026-09-16 10:05	2026-09-16 10:04	2026-09-16 10:04	XLB	XLB261016C00051000	call	51.0000	2026-10-16	0.9500	0.9500	1.0700	50.8550	32226.00	96.00	32130.00	339	7	1055	1893	0.557316428948759	0.163416120992446	0.161696004717203	true	false	false	true
e0ae9c0c-50be-4f39-8914-0ceee4fd4847	2026-09-16 10:05	2026-09-16 10:04	2026-09-16 10:04	XLB	XLB261016C00051000	call	51.0000	2026-10-16	0.9500	0.9500	1.0700	50.8550	11313.00	672.00	10641.00	119	9	1174	1893	0.620179609086107	0.163416120992446	0.161696004717203	true	false	false	true
b16f6dac-15bb-44c4-9b78-00a6864fda80	2026-09-15 14:59	2026-09-15 14:58	2026-09-15 14:58	XLB	XLB261218C00046000	call	46.0000	2026-12-18	5.5000	5.4500	5.7500	50.6450	15400.00	0.00	15400.00	28	7	30	2232	0.0134408602150538	0.199421720519521	0.199421720519521	true	false	false	true
2482b0eb-499a-415c-9457-e00cfa36e706	2026-09-15 13:21	2026-09-15 13:20	2026-09-15 13:20	XLB	XLB270115P00051000	put	51.0000	2027-01-15	2.2500	2.2000	2.2700	50.5750	50400.00	50400.00	0.00	224	29	299	197	1.51776649746193	0.205466965187172	0.205466965187172	false	false	false	true
af8b8692-6f08-4b39-ba7c-811e2896e86d	2026-09-15 10:28	2026-09-15 10:28	2026-09-15 10:28	XLB	XLB261016P00050000	put	50.0000	2026-10-16	0.9600	0.8400	0.9600	50.4300	14400.00	14400.00	0.00	150	23	161	1614	0.0997521685254027	0.212422245302761	0.212422245302761	false	false	false	true
1c855551-5ff3-4251-8e00-4d5d954beb25	2026-09-15 09:54	2026-09-15 09:54	2026-09-15 09:54	XLB	XLB261016C00051000	call	51.0000	2026-10-16	0.8200	0.7300	0.8300	50.4300	16400.00	5576.00	7380.00	200	12	245	452	0.542035398230089	0.170746863046502	0.170746863046502	false	false	false	true
09792cbc-69d9-4b55-bc72-a4c2fa1c516f	2026-09-14 13:48	2026-09-14 13:48	2026-09-14 13:48	XLB	XLB261218P00051000	put	51.0000	2026-12-18	2.0700	1.8700	2.0900	50.5250	10556.00	10556.00	0.00	51	17	52	545	0.0954128440366973	0.205064317587598	0.205064317587598	true	false	false	true
0fc95949-af0b-4950-a9a4-4b2d9e407f62	2026-09-14 11:18	2026-09-14 11:18	2026-09-14 11:18	XLB	XLB270115C00060000	call	60.0000	2027-01-15	0.2100	0.2100	0.3000	50.3600	13020.00	0.00	13020.00	620	32	1855	40592	0.0456986598344501	0.195580786778216	0.195580786778216	false	false	false	true
5d3766ec-92a5-454d-b406-7b33eabf8ff4	2026-09-14 10:47	2026-09-14 10:46	2026-09-14 10:46	XLB	XLB270115C00060000	call	60.0000	2027-01-15	0.2200	0.2200	0.3000	50.4400	10230.00	0.00	10230.00	465	32	1235	40592	0.0304247142294048	0.196272286328661	0.196272286328661	false	false	false	true
06c1c479-7a85-411a-80a9-a09721672d54	2026-09-14 10:16	2026-09-14 10:16	2026-09-14 10:16	XLB	XLB270115C00060000	call	60.0000	2027-01-15	0.2300	0.2300	0.3000	50.0000	12352.00	0.00	12352.00	537	27	769	40592	0.0189446196294836	0.195571919246041	0.195571919246041	false	false	false	true
4ebbf5d5-1891-431b-89b3-fe203ca198c9	2026-09-14 09:51	2026-09-14 09:51	2026-09-14 09:51	XLB	XLB261218C00046000	call	46.0000	2026-12-18	5.5000	5.4500	5.9000	50.5500	12650.00	0.00	12650.00	23	7	23	2239	0.0102724430549352	0.212076363801921	0.20369217261046	true	false	false	true
56af260f-2c0f-4a39-ad3b-f2669ed3855f	2026-09-11 13:32	2026-09-11 13:32	2026-09-11 13:32	XLB	XLB261016C00053000	call	53.0000	2026-10-16	0.4900	0.4400	0.5000	51.1250	10976.00	10878.00	98.00	224	20	299	616	0.48538961038961	0.176915719867746	0.176915719867746	true	false	false	true
a8d6b7ae-0f2d-4de2-952b-6cec7063d19b	2026-09-10 15:27	2026-09-10 15:27	2026-09-10 15:27	XLB	XLB260911C00050500	call	50.5000	2026-09-11	0.4600	0.3300	0.4900	50.7250	41262.00	92.00	41170.00	897	16	901	62	14.5322580645161	0.314387076627536	0.314387076627536	false	false	false	true
ce5dc7c3-1835-4929-bb22-585025eb033c	2026-09-10 13:38	2026-09-10 13:37	2026-09-10 13:37	XLB	XLB270115P00050000	put	50.0000	2027-01-15	1.8500	1.7900	1.8500	50.6900	17575.00	17575.00	0.00	95	27	100	6915	0.0144613159797542	0.210954171805827	0.210954171805827	false	false	false	true
117cb918-6c73-4b80-9dae-b16b82ffc51d	2026-09-10 10:30	2026-09-10 10:30	2026-09-10 10:30	XLB	XLB261002P00051000	put	51.0000	2026-10-02	1.0700	0.9400	1.0700	50.8150	12519.00	12519.00	0.00	117	15	117	33	3.54545454545455	0.207968300109581	0.207968300109581	true	false	false	true
d846fc50-bbe5-4211-b31f-38207dcaea24	2026-09-10 10:09	2026-09-10 10:08	2026-09-10 10:08	XLB	XLB270115P00050500	put	50.5000	2027-01-15	2.0300	1.8600	2.1200	50.7300	29841.00	29841.00	0.00	147	30	149	53	2.81132075471698	0.208702758910528	0.208702758910528	false	false	false	true
b9aa8713-5822-4a87-afba-6cd4f644ccd0	2026-09-09 10:31	2026-09-09 10:31	2026-09-09 10:31	XLB	XLB261009C00051500	call	51.5000	2026-10-09	1.2500	1.1200	1.2500	51.0000	13625.00	13625.00	0.00	109	14	109	0	0	0.166088613349916	0.166088613349916	false	false	false	true
335f896d-2b32-4371-9f7a-24910b371ec6	2026-09-08 11:35	2026-09-08 11:35	2026-09-08 11:35	XLB	XLB260925P00052000	put	52.0000	2026-09-25	0.7300	0.6100	0.7400	52.3400	26648.00	26648.00	0.00	365	25	379	13	29.1538461538462	0.20950633846029	0.207239332825638	true	false	false	true
ffccde6d-bf10-4969-8c88-73d9bd9388dd	2026-09-04 13:45	2026-09-04 13:45	2026-09-04 13:45	XLB	XLB261016P00054000	put	54.0000	2026-10-16	2.1300	1.9900	2.1400	52.5150	13425.00	13425.00	0.00	63	6	81	164	0.49390243902439	0.199447557953418	0.197969690660543	true	false	false	true
b5617468-b856-4a7e-ad86-38c3d5bc5759	2026-09-04 09:45	2026-09-04 09:45	2026-09-04 09:45	XLB	XLB260918C00052000	call	52.0000	2026-09-18	0.9300	0.7400	0.9400	52.3100	33854.00	33854.00	0.00	364	20	365	10	36.5	0.179440431172985	0.176928184478952	true	false	false	true
41ef0e15-b9b5-4f70-8ba1-8760f5e518df	2026-09-03 12:46	2026-09-03 12:46	2026-09-03 12:46	XLB	XLB261016C00053000	call	53.0000	2026-10-16	1.1700	1.1000	1.1800	52.7700	16171.00	16171.00	0.00	138	11	143	112	1.27678571428571	0.162489536353594	0.161104895779613	true	false	false	true
b1eb3274-149f-4d69-910f-148302a6279b	2026-09-03 10:30	2026-09-03 10:30	2026-09-03 10:30	XLB	XLB261016P00052000	put	52.0000	2026-10-16	1.0700	1.0700	1.1800	52.5250	24717.00	0.00	24717.00	231	15	237	498	0.475903614457831	0.19876340073664	0.19876340073664	false	false	false	true
93ef145c-9b38-4473-a54b-1353af1784ed	2026-09-02 12:42	2026-09-02 12:42	2026-09-02 12:42	XLB	XLB260925P00051500	put	51.5000	2026-09-25	0.4200	0.3600	0.5100	52.9950	26208.00	11844.00	14364.00	624	11	631	5	126.2	0.197814997088141	0.197814997088141	false	false	false	true
b334e0b3-ccfe-470e-8c45-7bc17bdd6336	2026-09-02 11:18	2026-09-02 11:17	2026-09-02 11:17	XLB	XLB260904C00052500	call	52.5000	2026-09-04	0.7000	0.7000	0.7700	53.0500	11200.00	0.00	11200.00	160	10	346	266	1.30075187969925	0.224784980224424	0.224784980224424	false	false	false	true
8b0a139b-34e1-40dc-9761-ddc76c4a28f3	2026-09-02 09:33	2026-09-02 09:33	2026-09-02 09:33	XLB	XLB260918C00052500	call	52.5000	2026-09-18	0.9700	0.5600	0.9700	52.6900	12222.00	12222.00	0.00	126	18	127	4035	0.0314745972738538	0.187567428964809	0.187567428964809	true	false	false	true
17a284b0-e0d1-4fea-845c-653d4f7e34d1	2026-09-01 14:17	2026-09-01 14:16	2026-09-01 14:16	XLB	XLB260925C00052500	call	52.5000	2026-09-25	0.8300	0.7100	1.0100	52.3350	26061.00	25980.00	81.00	314	19	314	473	0.66384778012685	0.159855182121131	0.154251611249504	true	false	false	true
3ebf7ee1-55e3-4876-a111-79b3e29ddfbc	2026-09-01 12:41	2026-09-01 12:41	2026-09-01 12:41	XLB	XLB261002C00051500	call	51.5000	2026-10-02	1.5400	1.3400	1.5500	52.2350	30339.00	30339.00	0.00	197	18	197	0	0	0.172028063339888	0.170261408330953	true	false	false	true
c42e1ae3-b362-4887-adb2-ffae90a5f8d4	2026-08-31 12:45	2026-08-31 12:45	2026-08-31 12:45	XLB	XLB260904C00053500	call	53.5000	2026-09-04	0.1000	0.1000	0.1300	52.6200	10000.00	0.00	10000.00	1000	44	2047	438	4.67351598173516	0.174469873371379	0.174469873371379	false	false	false	true
24003971-d33a-4e99-b538-13bc6df4cb22	2026-08-31 10:07	2026-08-31 10:07	2026-08-31 10:07	XLB	XLB260918C00050000	call	50.0000	2026-09-18	3.2500	3.2500	3.3000	52.9900	11700.00	0.00	11700.00	36	10	44	2029	0.0216855593888615	0.234368473183759	0.234368473183759	false	false	false	true
cce7bb35-fe69-4d15-9765-610a6455ba1f	2026-08-28 13:34	2026-08-28 13:34	2026-08-28 13:34	XLB	XLB261016C00054000	call	54.0000	2026-10-16	1.0000	0.9100	1.0000	53.0100	14100.00	14100.00	0.00	141	30	144	123	1.17073170731707	0.170109781855443	0.170109781855443	true	false	false	true
c4d50517-b123-464c-a49c-990aeae6ab94	2026-08-28 12:22	2026-08-28 12:22	2026-08-28 12:22	XLB	XLB260911P00053000	put	53.0000	2026-09-11	0.6700	0.5600	0.6700	52.9100	15878.00	15812.00	66.00	237	28	289	18	16.0555555555556	0.160530961691825	0.160530961691825	true	false	false	true
fc6320a3-c1b6-49e6-806d-1716d0501d19	2026-08-28 11:50	2026-08-28 11:50	2026-08-28 11:50	XLB	XLB270115C00052500	call	52.5000	2027-01-15	3.2000	3.2000	3.3000	53.0000	16000.00	0.00	16000.00	50	6	50	1161	0.0430663221360896	0.19296134172431	0.19296134172431	false	false	false	true
754c1ea9-9e13-4518-9303-b6d7346e9d86	2026-08-27 09:49	2026-08-27 09:49	2026-08-27 09:49	XLB	XLB261218C00055000	call	55.0000	2026-12-18	1.8500	1.7400	1.8500	53.2100	24050.00	24050.00	0.00	130	23	141	800	0.17625	0.198962050400273	0.198962050400273	false	false	false	true
dab1b91e-e0e9-4392-bd1c-3ca562ee00d0	2026-08-26 14:34	2026-08-26 14:34	2026-08-26 14:34	XLB	XLB261218C00060000	call	60.0000	2026-12-18	0.6400	0.5500	0.6600	53.6850	20927.00	128.00	20799.00	327	5	851	3143	0.27076041998091	0.19897073732662	0.19897073732662	false	false	false	true
82b0a3d4-3db9-4273-83ba-f49e4494b2b4	2026-08-26 10:48	2026-08-26 10:48	2026-08-26 10:48	XLB	XLB260828P00054000	put	54.0000	2026-08-28	0.4600	0.3300	0.4600	53.7650	13478.00	13478.00	0.00	293	37	323	17	19	0.21139004608462	0.21139004608462	true	false	false	true
bc84a5b0-e8c5-4621-a7f5-02b802284e49	2026-08-26 09:46	2026-08-26 09:46	2026-08-26 09:46	XLB	XLB261218C00060000	call	60.0000	2026-12-18	0.6800	0.6800	0.7600	53.9900	15776.00	0.00	15776.00	232	17	272	3143	0.0865415208399618	0.196272567041484	0.196272567041484	false	false	false	true
973de64a-7cd6-41b7-acce-20f1466f4dff	2026-08-26 09:41	2026-08-26 09:41	2026-08-26 09:41	XLB	XLB260918C00055000	call	55.0000	2026-09-18	0.6100	0.4800	0.6100	53.9200	14273.00	14273.00	0.00	234	16	240	92145	0.00260459059091649	0.186279461342744	0.186279461342744	true	false	false	true
7cadb40d-9a5d-4f30-8f1e-f332634cac7f	2026-08-24 15:48	2026-08-24 15:48	2026-08-24 15:48	XLB	XLB261218C00053000	call	53.0000	2026-12-18	3.0500	2.7800	3.0500	53.4550	15244.00	15244.00	0.00	50	5	51	617	0.0826580226904376	0.20487706390465	0.20487706390465	false	false	false	true
260a3f31-2e50-4ad8-bdcd-a46d951118ae	2026-08-24 12:09	2026-08-24 12:09	2026-08-24 12:09	XLB	XLB260918P00052500	put	52.5000	2026-09-18	0.6200	0.5600	1.3000	53.4550	15194.00	15128.00	66.00	245	35	325	1242	0.261674718196457	0.195361578037498	0.203195045699481	false	false	false	true
5d2274cc-0983-44f5-808e-c6c86c0d9c3b	2026-08-24 12:01	2026-08-24 12:01	2026-08-24 12:01	XLB	XLB261218C00052000	call	52.0000	2026-12-18	3.6000	3.4500	3.7500	53.4550	49680.00	41400.00	8280.00	138	6	139	175	0.794285714285714	0.204492210380736	0.204492210380736	false	false	false	true