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:option_symbol = XLI260918P00170000×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

be71cd71-2d80-49f8-8b8c-203e49d5cc75	2026-09-03 15:10	2026-09-03 15:10	2026-09-03 15:10	XLI	XLI260918P00170000	put	170.0000	2026-09-18	0.8800	0.8700	1.0000	174.2650	12760.00	0.00	12760.00	145	29	208	3795	0.0548089591567852	0.181549410752825	0.18061898805369	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30796170295.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
8477b1b4-07d4-445a-8f8a-d1326773096f	2026-09-04 11:31	2026-09-04 11:31	2026-09-04 11:31	XLI	XLI260918P00170000	put	170.0000	2026-09-18	0.7100	0.6300	0.7300	174.8250	106500.00	21797.00	12780.00	1500	22	1508	3959	0.380904268754736	0.182591540425864	0.182591540425864	false	false	false	true
cf3743d7-bd85-48a8-b707-e2392d04f029	2026-09-09 10:22	2026-09-09 10:21	2026-09-09 10:21	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1400	0.9800	1.1400	172.5500	109667.00	109667.00	0.00	962	14	1344	4659	0.28847392144237	0.207720881838775	0.208769388598449	true	false	false	true
4daadeb2-2d43-4f5f-8079-0f0b1f2b7695	2026-09-09 10:22	2026-09-09 10:21	2026-09-09 10:21	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1400	0.9800	1.1400	172.5500	26334.00	26334.00	0.00	231	35	382	4659	0.0819918437432925	0.208769388598449	0.208769388598449	true	false	false	true
77001dc0-429c-48f1-8a60-e7a899adcf80	2026-09-10 10:23	2026-09-10 10:23	2026-09-10 10:23	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.5600	1.4900	1.5600	170.8700	15600.00	10452.00	0.00	100	6	113	5418	0.0208564045773348	0.201344933328471	0.201344933328471	false	false	false	true
af9af478-6d0c-4e58-ba32-862450b25f24	2026-09-10 10:23	2026-09-10 10:23	2026-09-10 10:23	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.5600	1.5400	1.7000	170.8700	22688.00	3140.00	19548.00	145	26	258	5418	0.0476190476190476	0.201344933328471	0.202358710376772	true	false	false	true
2d847728-673c-4ea7-894e-a1db69091a6a	2026-09-10 10:23	2026-09-10 10:23	2026-09-10 10:23	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.5600	1.5400	1.5600	170.9000	11544.00	8424.00	0.00	74	5	398	5418	0.0734588409007014	0.202605581393321	0.202605581393321	false	false	false	true
48a7a560-22ba-426b-8345-aa19ab1733c1	2026-09-10 10:25	2026-09-10 10:25	2026-09-10 10:25	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.3800	1.2500	1.3800	171.3300	10074.00	10074.00	0.00	73	6	471	5418	0.0869324473975637	0.201651473855499	0.201651473855499	false	false	false	true
61a70959-04a5-43c3-b766-6373feb848bf	2026-09-11 09:59	2026-09-11 09:59	2026-09-11 09:59	XLI	XLI260918P00170000	put	170.0000	2026-09-18	0.9100	0.6900	1.0100	172.0000	45412.00	45412.00	0.00	500	12	503	4965	0.101309164149043	0.199691741733671	0.199691741733671	false	false	false	true
a29c12e5-6e18-4a93-8ec9-499877fef377	2026-09-14 09:32	2026-09-14 09:32	2026-09-14 09:32	XLI	XLI260918P00170000	put	170.0000	2026-09-18	2.5300	2.1100	2.8000	168.4800	12634.00	12634.00	0.00	50	6	73	5272	0.0138467374810319	0.242011161340439	0.242011161340439	false	false	false	true
2d26c1d3-2728-4675-9030-447b08310f9c	2026-09-14 10:18	2026-09-14 10:18	2026-09-14 10:18	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.7000	1.6100	1.7000	169.0000	17000.00	11050.00	0.00	100	6	191	5272	0.0362291350531108	0.231311267775408	0.231311267775408	false	false	false	true
20c9f33a-7727-4c52-84f7-bdff1148c368	2026-09-14 10:18	2026-09-14 10:18	2026-09-14 10:18	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.7000	1.6600	1.8100	169.0000	25500.00	510.00	24990.00	150	32	341	5272	0.0646813353566009	0.231311267775408	0.231311267775408	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
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
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
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
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
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
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
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
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
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