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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = XLI×

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

509a379e-447a-406e-b9b6-e91c86a309bc	2026-09-16 14:14	2026-09-16 14:14	2026-09-16 14:14	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.3500	1.2800	1.4000	170.0600	34425.00	34425.00	0.00	255	9	1258	1255	1.00239043824701	0.170993971271564	0.170993971271564	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30388493380.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T18:26:46.257544Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
157002fa-9af5-483d-8b11-f9c919217a1b	2026-09-16 14:14	2026-09-16 14:14	2026-09-16 14:14	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.3500	1.2400	1.4000	170.0600	57645.00	57645.00	0.00	427	23	903	1255	0.719521912350598	0.170993971271564	0.170993971271564	true	false	false	true
6fd96af4-3487-40e5-ae6a-76e63ba2148b	2026-09-16 14:07	2026-09-16 14:07	2026-09-16 14:07	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.4000	1.2400	1.5200	170.0900	15540.00	15540.00	0.00	111	19	389	1255	0.30996015936255	0.174031693362987	0.174031693362987	false	false	false	true
a3ef1a31-7b68-4d0c-91b0-a3c94055b839	2026-09-16 14:07	2026-09-16 14:07	2026-09-16 14:07	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.4000	1.1200	1.4100	170.0600	32473.00	32473.00	0.00	232	24	232	1255	0.184860557768924	0.174819199151633	0.174819199151633	false	false	false	true
6e2e98ff-8399-413b-976b-f83e8c62e96f	2026-09-16 13:39	2026-09-16 13:39	2026-09-16 13:39	XLI	XLI260918P00171000	put	171.0000	2026-09-18	1.6400	1.5200	1.6400	170.2150	18860.00	18860.00	0.00	115	36	384	436	0.880733944954128	0.244137681925356	0.244137681925356	false	false	false	true
6c7cf8d6-6544-472b-91df-48e8341dece6	2026-09-16 13:22	2026-09-16 13:22	2026-09-16 13:22	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1800	1.0800	1.2200	170.0700	20532.00	20532.00	0.00	174	36	1468	4817	0.304753996263234	0.245497370404006	0.245497370404006	false	false	false	true
deebdb2c-6c24-4e34-b161-9200b5b877ec	2026-09-16 13:11	2026-09-16 13:11	2026-09-16 13:11	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1200	1.0200	1.1200	170.1100	10640.00	10640.00	0.00	95	17	1179	4817	0.244758148225036	0.237362586699559	0.237362586699559	false	false	false	true
4d87f652-d035-46bc-be91-38333bb370c5	2026-09-16 13:11	2026-09-16 13:11	2026-09-16 13:11	XLI	XLI260918P00171000	put	171.0000	2026-09-18	1.7100	1.5600	1.7100	170.1100	10089.00	10089.00	0.00	59	15	218	436	0.5	0.245603721267682	0.245603721267682	false	false	false	true
161ed94a-a986-49d8-b01a-5e158faa1b9e	2026-09-16 13:11	2026-09-16 13:11	2026-09-16 13:11	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1200	1.0200	1.1200	170.1100	11088.00	11088.00	0.00	99	19	1286	4817	0.266971143865476	0.237362586699559	0.237362586699559	false	false	false	true
a601ac2a-231d-4c77-8426-70824f4d6cbe	2026-09-16 12:58	2026-09-16 12:58	2026-09-16 12:58	XLI	XLI261016P00170000	put	170.0000	2026-10-16	3.5000	3.4000	3.5000	170.2500	28700.00	28700.00	0.00	82	25	190	1869	0.101658640984484	0.200068989813787	0.200068989813787	false	false	false	true
70cc63bb-5d48-42e0-8745-bafae50430b4	2026-09-16 12:58	2026-09-16 12:58	2026-09-16 12:58	XLI	XLI261016P00169000	put	169.0000	2026-10-16	3.1000	3.0000	3.1000	170.2500	35030.00	35030.00	0.00	113	26	239	376	0.63563829787234	0.203056323903053	0.203056323903053	false	false	false	true
f1dfd433-ae73-4cc8-99b5-6a5ab93a579b	2026-09-16 12:06	2026-09-16 12:06	2026-09-16 12:06	XLI	XLI260925P00169000	put	169.0000	2026-09-25	1.7000	1.6600	1.7700	170.2900	258740.00	258400.00	340.00	1522	25	2289	177	12.9322033898305	0.221794303461701	0.221794303461701	false	false	false	true
803701f9-3739-4826-bd60-6142c2cd6245	2026-09-16 11:55	2026-09-16 11:54	2026-09-16 11:54	XLI	XLI260925P00169000	put	169.0000	2026-09-25	1.6700	1.5500	1.6700	170.3473	127588.00	127588.00	0.00	764	23	766	177	4.32768361581921	0.221073177837231	0.221073177837231	false	false	false	true
a5d97744-5a1d-43c4-88bb-ac6b33420ee7	2026-09-16 11:54	2026-09-16 11:54	2026-09-16 11:54	XLI	XLI261016P00170000	put	170.0000	2026-10-16	3.4500	3.2000	3.5000	170.4000	10350.00	10350.00	0.00	30	6	86	1869	0.0460139111824505	0.200996698439735	0.200996698439735	true	false	false	true
f537c03c-abc4-4557-a43d-482f060f9ae9	2026-09-16 11:51	2026-09-16 11:51	2026-09-16 11:51	XLI	XLI260918P00171000	put	171.0000	2026-09-18	1.4800	1.2800	1.4800	170.5000	23384.00	23384.00	0.00	158	20	159	436	0.364678899082569	0.244873957600107	0.244873957600107	false	false	false	true
b3765bb6-4341-42fa-8cb5-930dd7a0dcd6	2026-09-16 11:50	2026-09-16 11:50	2026-09-16 11:50	XLI	XLI270319P00163000	put	163.0000	2027-03-19	5.4500	5.1000	5.4500	170.5450	41965.00	41965.00	0.00	77	20	77	246	0.313008130081301	0.215200113177791	0.215200113177791	false	false	false	true
d8880186-2082-4550-bf36-cb8d5416d88e	2026-09-16 11:44	2026-09-16 11:44	2026-09-16 11:44	XLI	XLI260925P00163000	put	163.0000	2026-09-25	0.4000	0.3600	0.4600	170.3000	40520.00	40240.00	280.00	1013	13	1013	197	5.14213197969543	0.24748394635559	0.24748394635559	false	false	false	true
804ef78f-6840-4095-8aa3-fb5c4f83b14d	2026-09-16 11:26	2026-09-16 11:26	2026-09-16 11:26	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1100	1.0300	1.1100	170.2900	24753.00	24753.00	0.00	223	44	1049	4817	0.217770396512352	0.252113993569704	0.252113993569704	false	false	false	true
db3117e5-ca47-486f-aa1f-50bc41d213a1	2026-09-16 11:25	2026-09-16 11:25	2026-09-16 11:25	XLI	XLI261009P00164000	put	164.0000	2026-10-09	1.2100	1.2100	1.4300	170.2350	18200.00	0.00	18200.00	150	16	152	93	1.63440860215054	0.215991185230828	0.215206859000893	true	false	false	true
83ef983a-2cd9-45ea-9aa8-205d41d543d0	2026-09-16 10:38	2026-09-16 10:38	2026-09-16 10:38	XLI	XLI260918P00169000	put	169.0000	2026-09-18	1.0600	0.9700	1.0600	169.4600	10706.00	10706.00	0.00	101	31	461	1057	0.436140018921476	0.258771433293129	0.258771433293129	false	false	false	true
8f763f91-f7e3-4355-959b-3e204b4b3148	2026-09-16 10:02	2026-09-16 10:01	2026-09-16 10:01	XLI	XLI260918C00171000	call	171.0000	2026-09-18	0.6600	0.6000	0.6600	169.3700	23562.00	23562.00	0.00	357	10	501	235	2.13191489361702	0.259652619734153	0.259652619734153	false	false	false	true
b096f9b6-4354-4781-860c-3a8832cf892c	2026-09-16 09:59	2026-09-16 09:59	2026-09-16 09:59	XLI	XLI260918P00169000	put	169.0000	2026-09-18	1.1000	0.9600	1.1000	169.4200	25850.00	25850.00	0.00	235	31	360	1057	0.340586565752129	0.263316591574376	0.263316591574376	false	false	false	true
87e5efc0-c6b7-46d9-ba4d-2f107ec903f5	2026-09-16 09:59	2026-09-16 09:59	2026-09-16 09:59	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.5800	1.4100	1.5800	169.4200	11850.00	11850.00	0.00	75	15	325	4817	0.0674693792817106	0.257455231682971	0.257455231682971	false	false	false	true
be7d8af1-fc94-4feb-a6ba-09816aedb255	2026-09-16 09:54	2026-09-16 09:54	2026-09-16 09:54	XLI	XLI260918P00169000	put	169.0000	2026-09-18	1.0500	0.9600	1.0500	169.5100	13125.00	13125.00	0.00	125	40	125	1057	0.118259224219489	0.261128933540333	0.261128933540333	false	false	false	true
53dca497-2e8a-458e-bac3-e58a69c508ea	2026-09-15 15:12	2026-09-15 15:11	2026-09-15 15:11	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.2000	1.1500	1.2300	168.9900	68760.00	59640.00	8400.00	573	47	1273	5	254.6	0.179958777560161	0.179958777560161	false	false	false	true
dd5d3630-d11b-4abd-a2d1-ef5a8d232819	2026-09-15 13:59	2026-09-15 13:59	2026-09-15 13:59	XLI	XLI261016P00164000	put	164.0000	2026-10-16	1.9500	1.8400	1.9700	169.1750	199680.00	197534.00	2146.00	1024	15	3946	972	4.059670781893	0.217914841872467	0.218514493967436	false	false	false	true
161e840a-1b7a-45c3-92b9-3648f3587517	2026-09-15 13:24	2026-09-15 13:24	2026-09-15 13:24	XLI	XLI260925P00169000	put	169.0000	2026-09-25	2.3500	2.2800	2.3600	168.9801	40184.00	40184.00	0.00	171	28	171	34	5.02941176470588	0.21792251421475	0.21792251421475	false	false	false	true
e489f29c-5e3d-4277-86ab-07e5e6320703	2026-09-15 13:22	2026-09-15 13:22	2026-09-15 13:22	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.2000	1.1400	1.2700	168.9700	10320.00	0.00	9960.00	86	31	314	5	62.8	0.180193405971989	0.180427934168364	false	false	false	true
35cc7f0c-73c3-46f6-a622-75f578f25b5e	2026-09-15 13:16	2026-09-15 13:15	2026-09-15 13:15	XLI	XLI261016P00170000	put	170.0000	2026-10-16	4.2000	3.8500	4.3000	169.0800	13860.00	13860.00	0.00	33	5	235	2022	0.1162215628091	0.204853886075757	0.204853886075757	false	false	false	true
ed47ec44-0f7c-458d-91de-c719f0456589	2026-09-15 12:52	2026-09-15 12:52	2026-09-15 12:52	XLI	XLI261218C00175000	call	175.0000	2026-12-18	4.7500	4.7000	4.7500	169.3700	14250.00	14250.00	0.00	30	7	30	226	0.132743362831858	0.186259721864856	0.186259721864856	false	false	false	true
347d8367-7233-4e1c-a0ab-8cff45b5445d	2026-09-15 12:40	2026-09-15 12:40	2026-09-15 12:40	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.7400	1.7400	1.8200	169.0000	24012.00	0.00	24012.00	138	17	696	5706	0.121976866456362	0.217604725862897	0.217604725862897	true	false	false	true
4c2807db-7c4b-4bf1-9abd-87a477d99315	2026-09-15 12:39	2026-09-15 12:39	2026-09-15 12:39	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.7900	1.7200	1.7900	169.0000	14678.00	4654.00	0.00	82	5	545	5706	0.0955134945671223	0.224594429161775	0.224594429161775	false	false	false	true
1c08edc9-770f-41c0-89a5-78672391c1c9	2026-09-15 12:34	2026-09-15 12:33	2026-09-15 12:33	XLI	XLI261002C00171000	call	171.0000	2026-10-02	1.9300	1.6100	2.0100	169.0000	11001.00	10808.00	193.00	57	15	60	4	15	0.176656750010429	0.176656750010429	true	false	false	true
025b1716-7722-4298-bf32-c6d2f3c8f8a7	2026-09-15 12:28	2026-09-15 12:28	2026-09-15 12:28	XLI	XLI261218C00171000	call	171.0000	2026-12-18	6.5000	6.3500	6.5000	169.0000	36400.00	36400.00	0.00	56	19	56	2	28	0.189997326503842	0.189997326503842	false	false	false	true
dffead5e-fbc5-42d7-8618-26f3acb5bc9b	2026-09-15 12:26	2026-09-15 12:26	2026-09-15 12:26	XLI	XLI261016P00164000	put	164.0000	2026-10-16	1.9300	1.8900	1.9900	169.0000	10229.00	386.00	9843.00	53	11	2848	972	2.93004115226337	0.215782419318698	0.215782419318698	true	false	false	true
c0fdba91-3346-46f3-900f-a23a75f53731	2026-09-15 12:24	2026-09-15 12:24	2026-09-15 12:24	XLI	XLI261218C00173000	call	173.0000	2026-12-18	5.4500	5.1500	5.4500	168.0000	24525.00	24525.00	0.00	45	12	45	1042	0.0431861804222649	0.18816984429867	0.18816984429867	true	false	false	true
e6882408-58a0-4628-ba1d-ac4ab212a78b	2026-09-15 11:55	2026-09-15 11:55	2026-09-15 11:55	XLI	XLI260925P00168000	put	168.0000	2026-09-25	1.9400	1.7800	1.9400	168.8000	36472.00	36472.00	0.00	188	32	188	24	7.83333333333333	0.215843030039996	0.215843030039996	false	false	false	true
e260ba15-447e-49a9-9005-7c13545a0274	2026-09-15 11:29	2026-09-15 11:29	2026-09-15 11:29	XLI	XLI261016P00164000	put	164.0000	2026-10-16	2.1300	2.0400	2.1300	168.6400	347734.00	338633.00	8889.00	1633	66	2758	972	2.83744855967078	0.219335207118654	0.218165279144935	true	false	false	true
4098aa6d-0c4c-4b98-9bde-e934e66fbd0d	2026-09-15 11:21	2026-09-15 11:21	2026-09-15 11:21	XLI	XLI261016P00164000	put	164.0000	2026-10-16	2.1000	1.9900	2.1000	168.6200	142380.00	142380.00	0.00	678	47	1125	972	1.15740740740741	0.217228850516002	0.217228850516002	false	false	false	true
34840c1d-8ea9-4868-9cdf-f43d9b0e8ff4	2026-09-15 11:17	2026-09-15 11:17	2026-09-15 11:17	XLI	XLI270319C00189000	call	189.0000	2027-03-19	2.9800	2.9800	3.1000	168.6300	16390.00	0.00	16390.00	55	16	75	10	7.5	0.175927911728978	0.175927911728978	true	false	false	true
6f616a59-77fd-42bb-b8a5-b2ed5ef243e7	2026-09-15 11:03	2026-09-15 11:03	2026-09-15 11:03	XLI	XLI270319C00170000	call	170.0000	2027-03-19	10.1000	9.9000	10.2500	168.0000	21210.00	15150.00	6060.00	21	5	21	102	0.205882352941176	0.187373840021	0.187373840021	false	false	false	true
6fd89592-94f3-4bdb-a5b0-0d99e0b14cfa	2026-09-15 10:58	2026-09-15 10:58	2026-09-15 10:58	XLI	XLI260925P00164000	put	164.0000	2026-09-25	0.7800	0.6800	0.7800	168.0000	11154.00	11154.00	0.00	143	20	155	11	14.0909090909091	0.224792546732199	0.224265526398428	false	false	false	true
6bfa9a6e-e6ac-4944-bb01-bc5ede0ccb29	2026-09-15 10:50	2026-09-15 10:50	2026-09-15 10:50	XLI	XLI260925P00166000	put	166.0000	2026-09-25	1.2200	1.1000	1.2200	168.7300	18788.00	18788.00	0.00	154	23	159	4	39.75	0.217222217116478	0.217222217116478	false	false	false	true
c90060bd-d56c-4035-a919-d63da16c7a8d	2026-09-15 10:43	2026-09-15 10:42	2026-09-15 10:42	XLI	XLI260925C00169000	call	169.0000	2026-09-25	1.9200	1.9200	2.1400	168.7700	22464.00	0.00	22464.00	117	9	117	2	58.5	0.174394823935282	0.174394823935282	true	false	false	true
e0c25a77-7fcf-49cd-8f4e-4d0623707479	2026-09-15 10:39	2026-09-15 10:39	2026-09-15 10:39	XLI	XLI261016P00164000	put	164.0000	2026-10-16	1.9500	1.8500	1.9500	168.8700	54210.00	54210.00	0.00	278	35	431	972	0.443415637860082	0.212713555542038	0.212713555542038	false	false	false	true
5f3c0a2b-4940-48f0-b000-15ae524297e7	2026-09-15 10:29	2026-09-15 10:29	2026-09-15 10:29	XLI	XLI261016P00164000	put	164.0000	2026-10-16	1.9000	1.7900	1.9000	168.9500	28689.00	28689.00	0.00	151	17	152	972	0.156378600823045	0.211095260115362	0.210496060926604	false	false	false	true
1593209d-4076-4113-a74b-354d008e62d7	2026-09-15 10:11	2026-09-15 10:11	2026-09-15 10:11	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.8100	1.6200	1.8100	169.1800	27874.00	27874.00	0.00	154	24	427	5706	0.0748335085874518	0.227351063769589	0.227351063769589	false	false	false	true
5c4dedfc-d6d1-4a03-9e21-ac7d655333e9	2026-09-15 10:06	2026-09-15 10:06	2026-09-15 10:06	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.7400	1.7400	1.8100	169.1600	16008.00	0.00	16008.00	92	23	261	5706	0.0457413249211356	0.213669443476598	0.213669443476598	true	false	false	true
acea9c70-0d88-4c12-a1b5-6fd0dde24698	2026-09-15 10:06	2026-09-15 10:06	2026-09-15 10:06	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.7300	1.5500	1.8100	169.1600	17300.00	5017.00	2768.00	100	6	109	5706	0.0191026989134245	0.211991048610781	0.211991048610781	false	false	false	true
b91a1d07-1591-46bc-aefa-c24cf512a1f3	2026-09-15 09:33	2026-09-15 09:33	2026-09-15 09:33	XLI	XLI261016C00170000	call	170.0000	2026-10-16	3.6600	3.6500	3.9000	169.8158	21975.00	0.00	21975.00	60	6	60	302	0.198675496688742	0.174753892065331	0.177292904677353	false	false	false	true