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:alert_rule = RepeatedHitsDescendingFill×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	expiry

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	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	30374218340.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T18:32:33.635262Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
0e9d4ec9-8abf-4651-9d5e-a20e26b0e517	2026-09-24 11:32	2026-09-24 11:32	2026-09-24 11:32	XLI	XLI261016P00165000	put	165.0000	2026-10-16	1.5300	1.2400	1.5500	168.3600	13880.00	771.00	13109.00	91	34	204	1309	0.155844155844156	0.188688639214932	0.186191776387633	true	false	false	true
22d3c27a-870a-4809-8a1a-4608a8cbde62	2026-09-24 10:35	2026-09-24 10:35	2026-09-24 10:35	XLI	XLI270115C00175000	call	175.0000	2027-01-15	5.4900	5.4500	5.7500	169.2850	28525.00	0.00	20825.00	52	6	54	3391	0.0159245060454143	0.186382361354669	0.185038498151273	false	false	false	true
0de447e7-04c0-4e42-8df0-db92b6d60614	2026-09-24 10:02	2026-09-24 10:01	2026-09-24 10:01	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.0500	3.0500	3.1500	169.1650	90014.00	0.00	90014.00	295	8	1001	14055	0.0712202063322661	0.200487763522074	0.200487763522074	false	false	false	true
d56b6d60-19da-4699-a690-9261e0a77e7a	2026-09-23 13:50	2026-09-23 13:50	2026-09-23 13:50	XLI	XLI261120C00172000	call	172.0000	2026-11-20	5.1600	4.8500	5.2000	170.7100	10845.00	10845.00	0.00	21	5	21	16	1.3125	0.194711939637072	0.194711939637072	false	false	false	true
7aa38c8d-0c7b-4625-bd9d-5282f6a01e13	2026-09-23 11:04	2026-09-23 11:04	2026-09-23 11:04	XLI	XLI261120C00176000	call	176.0000	2026-11-20	3.3100	3.3000	3.3500	170.4500	14546.00	670.00	13876.00	44	13	94	2	47	0.191760012557988	0.190603345071166	true	false	false	true
f8981d3c-13d0-4066-8e7e-06e4162c05db	2026-09-23 11:02	2026-09-23 11:02	2026-09-23 11:02	XLI	XLI261023P00170000	put	170.0000	2026-10-23	2.8900	2.6800	2.9400	170.6000	48259.00	47973.00	286.00	167	40	167	61	2.73770491803279	0.176719362103804	0.175162105173063	true	false	false	true
f3b5b5cb-e946-41da-b31d-3f0be7ffad07	2026-09-22 13:02	2026-09-22 13:02	2026-09-22 13:02	XLI	XLI280121C00175000	call	175.0000	2028-01-21	18.1300	18.0500	18.2000	169.0000	43500.00	23595.00	18100.00	24	8	61	244	0.25	0.197543115261176	0.196881450381106	false	false	false	true
915191da-aa51-47d8-8f43-8d2d40e1064a	2026-09-22 12:25	2026-09-22 12:25	2026-09-22 12:25	XLI	XLI261016C00172000	call	172.0000	2026-10-16	2.1800	2.1100	2.2600	169.8900	15912.00	15695.00	217.00	73	12	101	1456	0.0693681318681319	0.168170227760733	0.167582651666127	true	false	false	true
790dc6b0-d8e1-4d23-aa9d-d22fb072941b	2026-09-22 11:07	2026-09-22 11:07	2026-09-22 11:07	XLI	XLI261023C00172000	call	172.0000	2026-10-23	2.5900	2.2500	2.6000	169.0000	26389.00	16295.00	10094.00	102	13	102	9	11.3333333333333	0.171886912873722	0.171886912873722	true	false	false	true
7385333e-5fde-4738-8f95-843d6e52be7d	2026-09-22 09:50	2026-09-22 09:49	2026-09-22 09:49	XLI	XLI261016P00168000	put	168.0000	2026-10-16	2.0800	1.9400	2.2600	169.9300	37285.00	37285.00	0.00	179	23	187	745	0.251006711409396	0.190832267362803	0.180856616821125	true	false	false	true
333df164-e858-4657-9701-460959b01cb7	2026-09-22 09:50	2026-09-22 09:49	2026-09-22 09:49	XLI	XLI261016P00160000	put	160.0000	2026-10-16	0.5600	0.5500	0.6200	169.8900	17293.00	0.00	17293.00	311	50	422	15594	0.0270616903937412	0.212641690633417	0.211490070114873	false	false	false	true
c4dbdbe6-d0a6-41c7-a199-4cc0eddee75d	2026-09-21 14:07	2026-09-21 14:07	2026-09-21 14:07	XLI	XLI261016P00160000	put	160.0000	2026-10-16	0.6000	0.5300	0.5900	170.0000	55132.00	55132.00	0.00	921	22	2442	1418	1.72214386459803	0.217406176726922	0.216295356798558	true	false	false	true
a2f2ad4d-0b64-4403-a275-301b29f34824	2026-09-17 11:18	2026-09-17 11:17	2026-09-17 11:17	XLI	XLI270917P00145000	put	145.0000	2027-09-17	4.5400	3.9500	5.4000	169.0200	58160.00	6675.00	9495.00	128	59	157	0	0	0.248824533116495	0.244272747023521	true	false	false	true
2d5bedba-bc5a-4517-a0d8-f4fb17d32321	2026-09-17 11:18	2026-09-17 11:17	2026-09-17 11:17	XLI	XLI270917P00145000	put	145.0000	2027-09-17	4.3800	3.9500	4.4000	169.0200	55156.00	55156.00	0.00	126	47	283	0	0	0.244272747023521	0.243126380136538	true	false	false	true
d19b058f-9061-4094-bf68-99f81adf1009	2026-09-17 11:17	2026-09-17 11:17	2026-09-17 11:17	XLI	XLI270917P00130000	put	130.0000	2027-09-17	2.2900	1.5600	3.7000	169.0200	39006.00	35076.00	1334.00	170	108	170	0	0	0.265954464552855	0.259394210652841	true	false	false	true
38ccf1ee-eec5-4343-9634-9d88884ce353	2026-09-16 15:24	2026-09-16 15:24	2026-09-16 15:24	XLI	XLI261016P00160000	put	160.0000	2026-10-16	1.3700	1.1000	1.3800	167.6600	16968.00	16968.00	0.00	124	25	142	1422	0.09985935302391	0.229004421891174	0.22685379604193	true	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
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
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
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
3e021e67-9598-4b75-8929-217ab4026d33	2026-09-11 14:24	2026-09-11 14:23	2026-09-11 14:23	XLI	XLI270319C00190000	call	190.0000	2027-03-19	4.0700	3.7500	4.1000	172.7000	11790.00	5715.00	6075.00	29	5	29	454	0.0638766519823789	0.17930188131196	0.178155814859665	false	false	false	true
5c1bfe49-32fa-48e2-89bb-95a43bef1393	2026-09-11 13:08	2026-09-11 13:08	2026-09-11 13:08	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0800	1.0000	1.0800	172.5700	23588.00	16740.00	6848.00	219	20	718	10063	0.0713504919010235	0.233059323206901	0.232394084351916	false	false	false	true
8f07a9d5-f9b8-4cbd-894f-c5bb5a08edf7	2026-09-10 15:05	2026-09-10 15:05	2026-09-10 15:05	XLI	XLI261120P00145000	put	145.0000	2026-11-20	0.6300	0.4300	0.6300	170.0200	44409.00	44037.00	0.00	705	42	705	43	16.3953488372093	0.265031336109054	0.265031336109054	false	false	false	true
3fad432f-89fd-4ccf-941c-d9b4a1f4b381	2026-09-08 09:46	2026-09-08 09:46	2026-09-08 09:46	XLI	XLI261016C00166000	call	166.0000	2026-10-16	10.8100	10.1500	10.8500	175.2800	22710.00	22710.00	0.00	21	5	21	0	0	0.186258409504183	0.182559490323791	false	false	false	true
c85bd094-ada1-4fa1-9e56-32ca1e5d2fd8	2026-09-03 15:55	2026-09-03 15:55	2026-09-03 15:55	XLI	XLI261016C00169000	call	169.0000	2026-10-16	7.8100	7.5500	8.1500	174.3900	13280.00	12495.00	785.00	17	14	19	1	19	0.172416415503052	0.169843497779337	false	false	false	true
e774829a-d03f-4d89-afdd-32c2e3c7c63f	2026-09-03 11:33	2026-09-03 11:33	2026-09-03 11:33	XLI	XLI260925P00179000	put	179.0000	2026-09-25	6.1900	5.7500	6.2000	174.0800	17340.00	16730.00	610.00	28	12	28	15	1.86666666666667	0.203674716975083	0.202315084214175	true	false	false	true
5eb712a3-ca4c-4a10-b659-2c72233b6d1a	2026-09-03 11:33	2026-09-03 11:33	2026-09-03 11:33	XLI	XLI260925P00180000	put	180.0000	2026-09-25	6.9000	6.4500	7.3000	174.0750	20005.00	9730.00	9590.00	29	6	29	62	0.467741935483871	0.204244171174356	0.196931408551572	true	false	false	true
c7fc9998-4a53-477a-8770-cb59a5cdce85	2026-09-01 10:03	2026-09-01 10:03	2026-09-01 10:03	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.8300	0.7900	0.8300	173.9200	12581.00	9711.00	1886.00	152	26	3367	44	76.5227272727273	0.202491315479288	0.200822199327036	false	false	false	true
01f8c97b-4e2f-4c60-ad0c-795a5efd1330	2026-09-01 09:58	2026-09-01 09:58	2026-09-01 09:58	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.8000	0.7500	0.8100	173.9064	22229.00	11022.00	8363.00	279	24	1715	44	38.9772727272727	0.198331460452917	0.196656192401807	false	false	false	true
da090df8-7a73-4fe0-8593-03209d7a4be8	2026-09-01 09:54	2026-09-01 09:54	2026-09-01 09:54	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.7800	0.6900	0.7900	173.8600	11545.00	2341.00	4602.00	148	7	477	44	10.8409090909091	0.199544538580585	0.197861769338316	false	false	false	true
31ca0bf4-cc13-4e8d-84e5-5d5e558d0a07	2026-09-01 09:54	2026-09-01 09:54	2026-09-01 09:54	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.7900	0.6900	0.7900	173.8600	11053.00	10897.00	78.00	140	26	266	44	6.04545454545455	0.199544538580585	0.197861769338316	false	false	false	true
39d4e743-616f-4040-8689-9753180277f4	2026-08-28 12:40	2026-08-28 12:39	2026-08-28 12:39	XLI	XLI261120C00190000	call	190.0000	2026-11-20	1.9300	1.9100	2.1100	176.9800	16209.00	7195.00	9014.00	84	16	108	3341	0.0323256510026938	0.171848628863314	0.169939611850695	true	false	false	true
7c85fac7-3208-4df9-9f87-7e2cb20f90b9	2026-08-28 11:52	2026-08-28 11:52	2026-08-28 11:52	XLI	XLI260918C00182000	call	182.0000	2026-09-18	0.8600	0.8600	0.9300	176.0000	52038.00	89.00	51949.00	605	21	626	1235	0.506882591093117	0.153176561020314	0.150878880976718	false	false	false	true
9abf9c69-133b-4ccc-b6b8-18d4b7249677	2026-08-25 13:14	2026-08-25 13:14	2026-08-25 13:14	XLI	XLI260904C00182500	call	182.5000	2026-09-04	0.5700	0.5500	0.6500	178.4950	22000.00	112.00	21888.00	386	48	402	19	21.1578947368421	0.159351595998553	0.158190902269447	false	false	false	true
c1e42926-f8f4-42be-8599-4bbcbccea80e	2026-08-21 10:06	2026-08-21 10:06	2026-08-21 10:06	XLI	XLI260828C00182000	call	182.0000	2026-08-28	1.0400	1.0100	1.2600	180.3400	10838.00	104.00	10734.00	104	14	107	29	3.68965517241379	0.170513378030225	0.16944759408304	true	false	false	true
5767ebe1-24e2-448b-8c88-08af735f5fcd	2026-08-17 14:20	2026-08-17 14:20	2026-08-17 14:20	XLI	XLI261120P00185000	put	185.0000	2026-11-20	5.8000	5.5000	5.8000	187.0050	275480.00	275480.00	0.00	475	48	639	351	1.82051282051282	0.2012134290449	0.2012134290449	false	false	false	true
c3e9435f-be08-4414-a2f6-5aab9ee3c490	2026-08-17 12:38	2026-08-17 12:37	2026-08-17 12:37	XLI	XLI261120P00180000	put	180.0000	2026-11-20	4.0100	4.0000	4.2000	187.1300	234744.00	0.00	234744.00	586	56	633	11811	0.0535941071882144	0.207497434491719	0.205997082373098	false	false	false	true
2c28681c-3ccf-4e74-a2ab-76690b8bbbb6	2026-08-17 12:37	2026-08-17 12:37	2026-08-17 12:37	XLI	XLI260918P00165000	put	165.0000	2026-09-18	0.3400	0.1800	0.3500	187.1100	37992.00	37992.00	0.00	1104	71	9072	56245	0.161294337274424	0.274427171683608	0.276120202000651	false	false	false	true