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:ticker = XLI×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

c7e6d3e3-ebbe-42c3-96c3-3f233d669cf9	2026-09-24 12:12	2026-09-24 12:12	2026-09-24 12:12	XLI	XLI261120P00169000	put	169.0000	2026-11-20	5.0000	5.0000	5.1000	168.0000	31000.00	0.00	31000.00	62	20	318	844	0.376777251184834	0.196123000906463	0.196123000906463	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30374218340.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T16:13:55.044964Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
b9c68088-9cb9-419e-b492-51c47e023a95	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	XLI	XLI270115P00175000	put	175.0000	2027-01-15	9.2500	9.0500	10.1000	169.4500	28680.00	1850.00	25900.00	31	13	31	1460	0.0212328767123288	0.198185658496895	0.198185658496895	false	false	false	true	false
5fd95af0-50bc-4842-b1a1-a05f4cdfca53	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	XLI	XLI261002P00168000	put	168.0000	2026-10-02	1.0200	0.9100	1.5400	169.0000	11141.00	4285.00	6856.00	109	20	216	259	0.833976833976834	0.17597041903243	0.178144161309605	false	false	false	true	false
458321f5-0ac8-4aaf-96b1-886d6d58c7fe	2026-09-24 12:27	2026-09-24 12:27	2026-09-24 12:27	XLI	XLI261120P00170000	put	170.0000	2026-11-20	5.0500	5.0000	5.1500	169.2600	26765.00	0.00	26765.00	53	5	55	43922	0.00125221984426939	0.195894886240414	0.195894886240414	true	false	false	true	false
efd828db-8eb8-4d76-bac1-268c050849c1	2026-09-24 12:41	2026-09-24 12:41	2026-09-24 12:41	XLI	XLI261120P00169000	put	169.0000	2026-11-20	4.1500	4.1500	4.2500	169.9900	50630.00	0.00	50630.00	122	21	540	844	0.639810426540284	0.192349280248881	0.192189060886232	true	false	false	true	false
e4b9fd05-cb61-499a-8685-3f04cb634b5e	2026-09-24 12:45	2026-09-24 12:45	2026-09-24 12:45	XLI	XLI261016P00168000	put	168.0000	2026-10-16	2.1600	2.0300	2.1600	169.5300	39096.00	39096.00	0.00	181	24	621	1385	0.448375451263538	0.183490961547081	0.183490961547081	false	false	false	true	false
0d9a126c-e749-401d-b1e2-230813fc770b	2026-09-24 13:07	2026-09-24 13:07	2026-09-24 13:07	XLI	XLI261120C00160000	call	160.0000	2026-11-20	12.5000	12.2000	12.5000	169.6600	45000.00	45000.00	0.00	36	6	36	360	0.1	0.216938817170559	0.216938817170559	false	false	false	true	false
54795c16-1694-4a22-9d0e-f564ba6e135e	2026-09-24 13:17	2026-09-24 13:17	2026-09-24 13:17	XLI	XLI261016P00157000	put	157.0000	2026-10-16	0.3300	0.3300	0.4000	169.6800	20196.00	0.00	20196.00	612	47	614	2	307	0.230981759357702	0.230981759357702	false	false	false	true	false
67cd4e7c-eeb7-4b84-a74b-aa2d8c2116a8	2026-09-24 13:36	2026-09-24 13:36	2026-09-24 13:36	XLI	XLI261120P00163000	put	163.0000	2026-11-20	2.4800	2.0900	2.5800	169.1700	15373.00	12152.00	3221.00	62	6	62	227	0.273127753303965	0.20416749639267	0.203723672797225	false	false	false	true	false
319041ff-2164-446f-9b78-70d4fe3b0416	2026-09-24 13:36	2026-09-24 13:36	2026-09-24 13:36	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.0900	2.7500	3.1000	169.1700	22570.00	18910.00	3660.00	73	11	1084	14055	0.0771255780860904	0.202203961997109	0.200143844319063	false	false	false	true	false
bf92cc0a-7090-4dc0-82ae-6e65ef19d145	2026-09-24 14:02	2026-09-24 14:02	2026-09-24 14:02	XLI	XLI261120P00179000	put	179.0000	2026-11-20	11.0000	10.4500	11.0000	168.0000	12100.00	12100.00	0.00	11	10	39	0	0	0.198413812494628	0.198413812494628	true	false	false	true	false
00f763b5-66f9-4018-bc9d-ae91d5a338f5	2026-09-24 14:26	2026-09-24 14:26	2026-09-24 14:26	XLI	XLI261023C00167000	call	167.0000	2026-10-23	5.1200	4.6000	5.1500	169.3096	13315.00	13315.00	0.00	26	6	26	0	0	0.188165586712217	0.188165586712217	false	false	false	true	false
e8a2e336-473c-46f4-be72-2fb951dd8954	2026-09-24 15:35	2026-09-24 15:34	2026-09-24 15:34	XLI	XLI261218C00180000	call	180.0000	2026-12-18	2.7800	2.6200	2.7800	169.0700	49762.00	49762.00	0.00	179	28	237	3896	0.0608316221765914	0.189789953446028	0.189789953446028	false	false	false	true	false
39d598da-deae-49b7-afab-1951ee052ee3	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	XLI	XLI261002P00174000	put	174.0000	2026-10-02	4.7500	4.7500	5.7000	169.5300	20425.00	0.00	20425.00	43	14	43	5	8.6	0.191293888235854	0.191293888235854	true	false	false	true	false
dc97094e-e994-4cbc-b28f-48d0b6584dc2	2026-09-25 09:40	2026-09-25 09:40	2026-09-25 09:40	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.7800	2.6900	2.8000	169.9400	384972.00	384972.00	0.00	1384	21	1394	13344	0.104466426858513	0.201242028237015	0.201403736924967	true	false	false	true	false
025ec701-e774-4b12-8f5c-e47f1a42388d	2026-09-25 09:40	2026-09-25 09:40	2026-09-25 09:40	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.7900	2.6900	2.8800	169.9500	305273.00	131127.00	174146.00	1096	96	2584	13344	0.193645083932854	0.200808771624311	0.199831690064068	true	false	false	true	false
ef36418f-9863-4131-8715-ce1485289af7	2026-09-25 09:41	2026-09-25 09:41	2026-09-25 09:41	XLI	XLI261002P00177500	put	177.5000	2026-10-02	7.4300	7.3000	9.2000	170.1800	11895.00	755.00	11140.00	16	8	16	0	0	0.233225836511936	0.191002316002437	false	false	false	true	false
593c92ec-231b-4c25-9fa1-54776bade14e	2026-09-25 09:41	2026-09-25 09:41	2026-09-25 09:41	XLI	XLI261002P00177000	put	177.0000	2026-10-02	6.9600	6.8500	8.7500	170.1800	12525.00	2100.00	10425.00	18	6	18	21	0.857142857142857	0.221541653520288	0.232593784423577	true	false	false	true	false
a4d21785-95cc-48a3-b6fe-f4ceafabf76b	2026-09-25 09:42	2026-09-25 09:42	2026-09-25 09:42	XLI	XLI261002P00175000	put	175.0000	2026-10-02	5.0500	5.0500	6.8000	170.2000	17170.00	0.00	17170.00	34	10	34	20	1.7	0.19455778930299	0.19455778930299	false	false	false	true	false
0123c96e-f62c-45a2-9d1c-b49d85bcc6b1	2026-09-25 09:45	2026-09-25 09:45	2026-09-25 09:45	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.7600	2.7600	2.8600	169.8584	77004.00	0.00	77004.00	279	44	5006	13344	0.375149880095923	0.199048394206155	0.199048394206155	false	false	false	true	false
f91f78ab-e097-4dce-80f1-1662d2752cd9	2026-09-25 09:54	2026-09-25 09:54	2026-09-25 09:54	XLI	XLI261016P00165000	put	165.0000	2026-10-16	1.1100	1.1100	1.4700	170.1300	17317.00	112.00	17205.00	156	40	156	1419	0.109936575052854	0.194933377071983	0.194933377071983	true	false	false	true	false
e93d7897-b125-4a23-890f-cbbd8baf7695	2026-09-25 10:51	2026-09-25 10:51	2026-09-25 10:51	XLI	XLI261023C00182500	call	182.5000	2026-10-23	0.3700	0.3700	0.4800	169.5500	14656.00	0.00	14656.00	396	53	400	0	0	0.187715351560143	0.187953911827522	true	false	false	true	false
01660c16-72b6-4d1f-829d-e1628be85d16	2026-09-25 11:04	2026-09-25 11:03	2026-09-25 11:03	XLI	XLI261009P00168000	put	168.0000	2026-10-09	1.4700	1.4700	1.7700	169.8200	16171.00	0.00	16171.00	110	12	110	76	1.44736842105263	0.179372667165641	0.179372667165641	true	false	false	true	false
c818beaf-0d64-4a52-96b9-4cda79f26eef	2026-09-25 11:10	2026-09-25 11:10	2026-09-25 11:10	XLI	XLI261023C00168000	call	168.0000	2026-10-23	4.4000	4.2000	5.6500	169.3884	34765.00	445.00	34320.00	79	24	79	0	0	0.180680718803785	0.183436565039484	true	false	false	true	false
bee846b9-7f6d-433f-bdd6-66f5f6f2797d	2026-09-25 11:58	2026-09-25 11:58	2026-09-25 11:58	XLI	XLI261120P00175000	put	175.0000	2026-11-20	7.2500	7.2500	7.6500	170.0000	21750.00	0.00	21750.00	30	6	31	12900	0.0024031007751938	0.188935458782069	0.188935458782069	true	false	false	true	false
65e26c78-c796-4471-bbf5-0498616c2f2f	2026-09-25 12:05	2026-09-25 12:05	2026-09-25 12:05	XLI	XLI261023P00167500	put	167.5000	2026-10-23	1.9800	1.9800	3.2000	170.6800	13277.00	0.00	13277.00	67	21	67	17	3.94117647058824	0.188897757324879	0.188897757324879	true	false	false	true	false
2636c863-a908-47ad-9f76-db9f007ea2d1	2026-09-25 12:09	2026-09-25 12:09	2026-09-25 12:09	XLI	XLI261016P00166000	put	166.0000	2026-10-16	1.1300	1.0900	1.3000	170.9400	22566.00	9379.00	13187.00	200	18	232	1269	0.182821118991332	0.191066580281644	0.191854146011704	true	false	false	true	false
d9ec7cb7-f01c-42d9-aa06-9081eee4eed9	2026-09-25 12:53	2026-09-25 12:53	2026-09-25 12:53	XLI	XLI261016P00165000	put	165.0000	2026-10-16	0.9900	0.9100	0.9900	170.4050	12078.00	12078.00	0.00	122	31	375	1419	0.264270613107822	0.190208153669368	0.190208153669368	true	false	false	true	false
db24477d-4d2f-49df-ac65-e4f5728b3878	2026-09-25 13:53	2026-09-25 13:53	2026-09-25 13:53	XLI	XLI261002P00169000	put	169.0000	2026-10-02	0.9600	0.9000	0.9700	170.1800	22656.00	22464.00	192.00	236	45	349	256	1.36328125	0.162975801434219	0.162975801434219	true	false	false	true	false
7953ad77-e0c8-4a40-b5fb-3f31fb4025d9	2026-09-25 14:26	2026-09-25 14:26	2026-09-25 14:26	XLI	XLI261218P00180000	put	180.0000	2026-12-18	11.5500	11.3500	11.5500	170.1600	286440.00	286440.00	0.00	248	25	248	386	0.642487046632124	0.202451422082209	0.202451422082209	false	false	false	true	false
d148d676-26eb-4eb2-aa23-b6d4b36e7d97	2026-09-25 14:37	2026-09-25 14:37	2026-09-25 14:37	XLI	XLI261023C00168000	call	168.0000	2026-10-23	4.9500	4.9500	5.3000	170.1400	15841.00	0.00	15841.00	32	14	125	0	0	0.185575150775675	0.185575150775675	true	false	false	true	false
7b6af78c-eaba-4b86-a3d0-85d22f179fbe	2026-09-25 15:04	2026-09-25 15:04	2026-09-25 15:04	XLI	XLI261002C00170000	call	170.0000	2026-10-02	1.5300	1.4800	1.6300	169.0000	17608.00	152.00	15762.00	115	16	257	262	0.980916030534351	0.166736170449066	0.164604457066787	false	false	false	true	false
65205ec7-c41f-496b-802a-ef8b281304b1	2026-09-25 15:05	2026-09-25 15:05	2026-09-25 15:05	XLI	XLI261218C00180000	call	180.0000	2026-12-18	3.0000	3.0000	3.1000	169.0000	60062.00	0.00	60062.00	200	32	205	4071	0.0503561778432818	0.191644588138629	0.190262966704228	false	false	false	true	false
ab0a4cd2-fe9b-49c2-8392-ecbf39a71be7	2026-09-25 15:38	2026-09-25 15:38	2026-09-25 15:38	XLI	XLI270115C00185000	call	185.0000	2027-01-15	2.5500	2.4800	2.5900	170.0000	26778.00	23464.00	0.00	105	33	115	8504	0.0135230479774224	0.180983797808987	0.182289212770516	false	false	false	true	false
13425d56-18c8-4481-8eba-af77a51aafe4	2026-09-25 15:45	2026-09-25 15:45	2026-09-25 15:45	XLI	XLI261016C00160000	call	160.0000	2026-10-16	11.2000	10.6000	11.2500	170.0000	23520.00	23520.00	0.00	21	6	29	6	4.83333333333333	0.220210264820921	0.220210264820921	true	false	false	true	false
f429a497-3b0a-418b-8c4d-c3b8d57cfe4a	2026-09-25 15:46	2026-09-25 15:46	2026-09-25 15:46	XLI	XLI261002P00171000	put	171.0000	2026-10-02	1.7500	1.7500	2.1100	170.0000	17337.00	528.00	16809.00	99	31	101	58	1.74137931034483	0.162450911517603	0.162450911517603	false	false	false	true	false
c960b8b8-376b-44e4-8701-22a24660b6da	2026-09-25 15:46	2026-09-25 15:46	2026-09-25 15:46	XLI	XLI261016P00170000	put	170.0000	2026-10-16	2.4700	2.4600	2.7800	170.0000	30629.00	0.00	30382.00	124	11	211	1851	0.1139924365208	0.176761187963197	0.176761187963197	true	false	false	true	false
020805bc-3459-4271-8a88-df4209b37abd	2026-09-25 15:46	2026-09-25 15:46	2026-09-25 15:46	XLI	XLI261016P00169000	put	169.0000	2026-10-16	2.0600	2.0600	2.3100	170.0000	10712.00	0.00	10712.00	52	14	110	610	0.180327868852459	0.178223511640407	0.178223511640407	false	false	false	true	false
7f2a3f05-5420-4797-89be-6437c011d6f2	2026-09-25 15:48	2026-09-25 15:48	2026-09-25 15:48	XLI	XLI270115C00185000	call	185.0000	2027-01-15	2.6000	2.6000	2.6600	170.0000	11440.00	0.00	11440.00	44	18	1249	8504	0.146872060206961	0.181035683892426	0.181035683892426	false	false	false	true	false