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

3a25c082-c64c-4cb0-a5e9-c323de84e722	2026-09-02 12:30	2026-09-02 12:30	2026-09-02 12:30	XLI	XLI270319C00173000	call	173.0000	2027-03-19	11.2000	10.8000	11.2500	172.7001	25760.00	24640.00	1120.00	23	12	33	3	11	0.191709994250068	0.191709994250068	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-02T16:56:20.498446Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
04d6f601-0c25-4e86-9dd2-4c3512f28df3	2026-09-02 12:30	2026-09-02 12:30	2026-09-02 12:30	XLI	XLI261016C00177000	call	177.0000	2026-10-16	2.5200	2.5200	2.6000	172.7000	150444.00	0.00	150444.00	597	15	600	6	100	0.166394161387271	0.166394161387271	false	false	false	true
9d0cfe25-5cc1-46d0-a173-8beb83c93bd9	2026-09-02 12:11	2026-09-02 12:11	2026-09-02 12:11	XLI	XLI261016C00168000	call	168.0000	2026-10-16	7.5000	7.5000	7.6500	172.9600	43500.00	0.00	43500.00	58	18	58	0	0	0.16920403441709	0.16920403441709	false	false	false	true
1a3bb92c-fb10-4401-992f-2833e9a893f2	2026-09-02 11:39	2026-09-02 11:39	2026-09-02 11:39	XLI	XLI270319P00172000	put	172.0000	2027-03-19	8.0000	7.8000	8.0000	173.1100	14400.00	14400.00	0.00	18	11	38	8	4.75	0.200000799193424	0.200000799193424	false	false	false	true
2f712b10-81cf-4515-9319-4bfabb79f1e9	2026-09-02 11:32	2026-09-02 11:32	2026-09-02 11:32	XLI	XLI260911P00170000	put	170.0000	2026-09-11	0.7000	0.7000	0.8400	173.0850	14910.00	0.00	14910.00	213	23	218	35	6.22857142857143	0.176589815868251	0.176589815868251	false	false	false	true
b0536770-68f8-4b9c-8aec-832ef828615a	2026-09-02 11:01	2026-09-02 11:01	2026-09-02 11:01	XLI	XLI260904C00172000	call	172.0000	2026-09-04	1.6700	1.6700	1.8000	172.9650	13694.00	0.00	13694.00	82	19	128	21	6.09523809523809	0.215483701831606	0.215483701831606	false	false	false	true
0f52606d-5541-4199-8d06-d1ceea02315d	2026-09-02 10:55	2026-09-02 10:55	2026-09-02 10:55	XLI	XLI260904C00171000	call	171.0000	2026-09-04	2.4100	2.4100	2.5400	172.9600	13496.00	0.00	13496.00	56	11	56	2	28	0.225653728639471	0.225653728639471	false	false	false	true
5bcd866e-55c2-43ab-8f0b-eb9b00eede7d	2026-09-02 10:45	2026-09-02 10:45	2026-09-02 10:45	XLI	XLI260918C00177000	call	177.0000	2026-09-18	1.0600	1.0600	1.1900	173.1500	10706.00	0.00	10706.00	101	27	141	194	0.72680412371134	0.166654269754453	0.166654269754453	false	false	false	true
cf740fc8-07e0-4044-8c06-d2a9ed1fdbe0	2026-09-02 10:18	2026-09-02 10:18	2026-09-02 10:18	XLI	XLI270319P00173000	put	173.0000	2027-03-19	8.5000	8.3500	8.5000	172.8550	14450.00	14450.00	0.00	17	7	28	8	3.5	0.1986733227478	0.1986733227478	false	false	false	true	false
08b505b2-1a77-4d07-95f2-6fcc63bf7952	2026-09-02 10:05	2026-09-02 10:05	2026-09-02 10:05	XLI	XLI260925C00170000	call	170.0000	2026-09-25	4.3500	3.8000	4.3500	172.2000	15225.00	15225.00	0.00	35	15	35	0	0	0.167193450252643	0.167193450252643	true	false	false	true
459249fc-cffb-4759-a688-10084a70c6e4	2026-09-02 10:02	2026-09-02 10:02	2026-09-02 10:02	XLI	XLI260925C00179000	call	179.0000	2026-09-25	0.6700	0.6700	0.8000	171.9500	39396.00	0.00	39396.00	588	17	628	1	628	0.161324976040565	0.161324976040565	false	false	false	true
cce82d88-97dd-47ef-82a2-5051f0f2aef4	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	XLI	XLI261016C00173000	call	173.0000	2026-10-16	3.9000	3.9000	3.9500	172.0000	352170.00	0.00	352170.00	903	6	1000	5	200	0.167600591455739	0.167600591455739	false	false	false	true
72aac84e-10f1-4217-b585-d56f2ba27b67	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	XLI	XLI261120P00169000	put	169.0000	2026-11-20	4.0500	3.7000	4.0500	171.9300	12150.00	12150.00	0.00	30	8	30	48	0.625	0.189810920414103	0.189810920414103	true	false	false	true
27d04877-d517-4905-ba3a-d57b05ad1b08	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	XLI	XLI261016P00165000	put	165.0000	2026-10-16	1.6000	1.5100	1.6000	172.0200	125120.00	125120.00	0.00	782	24	786	157	5.00636942675159	0.191287734760524	0.191287734760524	false	false	false	true
9f68e233-f57a-4624-a3c8-870d3f21a914	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	XLI	XLI261016C00173000	call	173.0000	2026-10-16	3.9000	3.9000	4.2000	172.0500	36270.00	0.00	36270.00	93	5	93	5	18.6	0.166540916533808	0.166540916533808	true	false	false	true
cf0976e1-d3e8-4a56-90e1-c942cda022c9	2026-09-02 09:35	2026-09-02 09:35	2026-09-02 09:35	XLI	XLI260904P00172000	put	172.0000	2026-09-04	1.0100	0.5800	1.0100	172.1300	13028.00	13028.00	0.00	129	38	131	54	2.42592592592593	0.214760099429173	0.214760099429173	true	false	false	true
23f48a3f-fedf-4b2a-a58b-3b9ae6606a01	2026-09-02 09:35	2026-09-02 09:34	2026-09-02 09:34	XLI	XLI260918C00177500	call	177.5000	2026-09-18	0.8400	0.7300	0.8400	172.3500	18480.00	18480.00	0.00	220	46	1454	36	40.3888888888889	0.176009680043962	0.176009680043962	false	false	false	true
98a72505-dc2d-4135-8c86-ec4bdc07b036	2026-09-02 09:34	2026-09-02 09:34	2026-09-02 09:34	XLI	XLI260918C00177500	call	177.5000	2026-09-18	0.8200	0.7300	0.8200	172.3964	13448.00	13448.00	0.00	164	40	1216	36	33.7777777777778	0.173212006202081	0.173212006202081	false	false	false	true
c50a183a-cc69-41e5-b8f2-115d03373b33	2026-09-02 09:34	2026-09-02 09:33	2026-09-02 09:33	XLI	XLI260918C00177500	call	177.5000	2026-09-18	0.7500	0.6700	0.7600	172.2800	34575.00	34500.00	75.00	461	36	631	36	17.5277777777778	0.169144173484228	0.169144173484228	false	false	false	true
50dd1aed-7b65-4a26-84e3-190d4b97b295	2026-09-01 14:48	2026-09-01 14:48	2026-09-01 14:48	XLI	XLI260911P00168000	put	168.0000	2026-09-11	0.5200	0.3800	0.5200	172.3200	16692.00	16692.00	0.00	321	29	321	1	321	0.179932518488635	0.179932518488635	false	false	false	true
4fc9a578-b1d0-46b6-984e-1cd9e578c472	2026-09-01 14:45	2026-09-01 14:45	2026-09-01 14:45	XLI	XLI260918P00171000	put	171.0000	2026-09-18	1.7600	1.5800	1.7600	172.4300	14784.00	14784.00	0.00	84	17	86	212	0.405660377358491	0.171569837323417	0.171569837323417	false	false	false	true
5875dca0-8e2c-4974-8238-551db0e9b55d	2026-09-01 13:15	2026-09-01 13:15	2026-09-01 13:15	XLI	XLI260911C00178000	call	178.0000	2026-09-11	0.3100	0.3100	0.4300	172.3700	38626.00	0.00	38626.00	1246	21	1255	38	33.0263157894737	0.165981108309369	0.165981108309369	false	false	false	true
bc84b80f-da1b-48c0-ad23-5d4a762c7cc9	2026-09-01 12:44	2026-09-01 12:44	2026-09-01 12:44	XLI	XLI261218P00173000	put	173.0000	2026-12-18	6.0500	6.0500	6.4000	172.4100	24200.00	0.00	24200.00	40	5	100	52	1.92307692307692	0.180930480148608	0.180930480148608	false	false	false	true
749459c6-533d-488c-824a-bcd4f4badc5a	2026-09-01 12:25	2026-09-01 12:25	2026-09-01 12:25	XLI	XLI260918C00181000	call	181.0000	2026-09-18	0.3300	0.3300	0.4200	172.7600	10791.00	0.00	10791.00	327	32	1179	301	3.91694352159468	0.167457919259274	0.167457919259274	false	false	false	true
9985532b-a174-4612-b286-01f57281b72e	2026-09-01 11:58	2026-09-01 11:57	2026-09-01 11:57	XLI	XLI260918C00181000	call	181.0000	2026-09-18	0.3600	0.3600	0.4200	173.0750	28189.00	0.00	28152.00	783	58	852	301	2.83056478405316	0.166591729980743	0.166591729980743	true	false	false	true
aba422f4-bd2e-4285-9ff0-9f3cfc87b29e	2026-09-01 10:02	2026-09-01 10:02	2026-09-01 10:02	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.8500	0.8000	0.8500	174.0200	26265.00	26265.00	0.00	309	14	2654	44	60.3181818181818	0.199450381653173	0.199450381653173	false	false	false	true
9a12f9c5-b489-46e0-af75-1ac7f1508b98	2026-09-01 09:56	2026-09-01 09:56	2026-09-01 09:56	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.8000	0.7200	0.8200	173.9200	10400.00	2080.00	8320.00	130	6	1273	44	28.9318181818182	0.197479594843768	0.197479594843768	false	false	false	true
2cd6cc60-bc77-4e2b-83b5-cd1ab9e503f1	2026-09-01 09:36	2026-09-01 09:36	2026-09-01 09:36	XLI	XLI260918P00165000	put	165.0000	2026-09-18	0.3900	0.2900	0.4100	174.5800	14664.00	14586.00	40.00	376	45	391	53397	0.00732250875517351	0.214422515712251	0.215926443193317	false	false	false	true
a7f6180a-9277-41c9-835f-a3cbad516d37	2026-08-31 15:42	2026-08-31 15:42	2026-08-31 15:42	XLI	XLI280121C00185000	call	185.0000	2028-01-21	16.5000	16.1500	16.8000	175.2050	16500.00	16500.00	0.00	10	7	11	138	0.0797101449275362	0.204694930736115	0.204694930736115	false	false	false	true
0f1608f7-b928-4c38-93b8-c23ef71c370c	2026-08-31 14:33	2026-08-31 14:32	2026-08-31 14:32	XLI	XLI261016P00164000	put	164.0000	2026-10-16	0.9700	0.9700	1.0200	175.2750	65960.00	0.00	65960.00	680	31	702	35	20.0571428571429	0.198566155282469	0.198566155282469	false	false	false	true
89106315-b083-4fd5-a846-823ca3aea977	2026-08-31 13:40	2026-08-31 13:39	2026-08-31 13:39	XLI	XLI261016P00160000	put	160.0000	2026-10-16	0.6200	0.6200	0.7000	175.1400	12773.00	0.00	12710.00	206	38	212	351	0.603988603988604	0.21250975412631	0.21250975412631	false	false	false	true
d756447a-6d95-4740-8b27-ff0daf6ed811	2026-08-31 13:01	2026-08-31 13:01	2026-08-31 13:01	XLI	XLI261218C00205000	call	205.0000	2026-12-18	0.5600	0.5500	0.6300	175.0450	11592.00	56.00	11536.00	207	38	210	132	1.59090909090909	0.18003270564043	0.18003270564043	false	false	false	true
29056c92-5810-4200-b02c-f84f69d3e2c5	2026-08-31 12:33	2026-08-31 12:33	2026-08-31 12:33	XLI	XLI260925C00185000	call	185.0000	2026-09-25	0.3900	0.2400	0.4400	175.1950	27963.00	78.00	27885.00	717	17	718	4	179.5	0.16000930991085	0.16000930991085	false	false	false	true
0f7ee7de-5cff-47e6-91cb-9e057ecb57e7	2026-08-31 12:23	2026-08-31 12:23	2026-08-31 12:23	XLI	XLI261016C00183000	call	183.0000	2026-10-16	1.4800	1.4700	1.5500	175.0301	18648.00	0.00	18648.00	126	40	128	44	2.90909090909091	0.161371060569668	0.161371060569668	false	false	false	true
64059b95-119a-476a-afda-41c8d2018836	2026-08-31 12:10	2026-08-31 12:09	2026-08-31 12:09	XLI	XLI261016P00165000	put	165.0000	2026-10-16	1.1600	1.1600	1.2500	175.0050	13340.00	0.00	13340.00	115	15	120	32	3.75	0.19664013165368	0.19664013165368	false	false	false	true
8f139389-d8ea-4928-b7f7-321c1b6e7572	2026-08-31 11:59	2026-08-31 11:59	2026-08-31 11:59	XLI	XLI260918P00168000	put	168.0000	2026-09-18	0.5500	0.4800	0.5600	175.0850	18645.00	18645.00	0.00	339	41	340	589	0.577249575551783	0.187156739755751	0.187156739755751	false	false	false	true
27e907cb-4a81-4d1c-aa5c-12465fab831f	2026-08-31 10:17	2026-08-31 10:17	2026-08-31 10:17	XLI	XLI270319C00172000	call	172.0000	2027-03-19	13.2500	13.1500	13.9000	175.1800	30485.00	10620.00	19865.00	23	9	23	0	0	0.190225949319358	0.189590930793091	false	false	false	true
3bcfa1b2-df65-40e4-b70a-882a069ba67c	2026-08-28 14:40	2026-08-28 14:40	2026-08-28 14:40	XLI	XLI261120P00151000	put	151.0000	2026-11-20	0.5700	0.4800	0.7800	177.1900	15162.00	57.00	15105.00	266	38	447	12	37.25	0.237825215936906	0.237825215936906	true	false	false	true
291536ee-21da-4571-91fa-17574edd690c	2026-08-28 14:35	2026-08-28 14:35	2026-08-28 14:35	XLI	XLI261120P00151000	put	151.0000	2026-11-20	0.5600	0.5600	0.7800	177.1700	10136.00	0.00	10136.00	181	34	181	12	15.0833333333333	0.23674185412905	0.23674185412905	false	false	false	true
e4ce4dfa-fcbc-4821-8348-2d093088b231	2026-08-28 13:00	2026-08-28 13:00	2026-08-28 13:00	XLI	XLI260918P00173000	put	173.0000	2026-09-18	1.1700	1.0900	1.1700	176.9500	11934.00	11934.00	0.00	102	24	111	492	0.225609756097561	0.168736616328956	0.168736616328956	false	false	false	true
36a2e984-ed30-4d80-b0f8-5288e1a999a8	2026-08-28 12:54	2026-08-28 12:54	2026-08-28 12:54	XLI	XLI270617C00210000	call	210.0000	2027-06-17	3.2500	3.1500	3.2500	177.0600	26650.00	26650.00	0.00	82	5	82	61	1.34426229508197	0.178563741439505	0.178563741439505	false	false	false	true
aaa921aa-9efa-4df7-a682-2ce7b53b7b0f	2026-08-28 12:53	2026-08-28 12:52	2026-08-28 12:52	XLI	XLI260918C00175000	call	175.0000	2026-09-18	4.1500	3.8000	4.1500	177.0800	17015.00	17015.00	0.00	41	15	41	312	0.131410256410256	0.163101882286406	0.163101882286406	true	false	false	true
d10977ff-0c3a-4152-a507-0bc3193d6f03	2026-08-28 12:07	2026-08-28 12:07	2026-08-28 12:07	XLI	XLI261009C00189000	call	189.0000	2026-10-09	0.7500	0.7500	1.0100	177.0000	67050.00	0.00	67050.00	894	18	972	0	0	0.166506108474317	0.166506108474317	false	false	false	true
88827350-441f-440f-8803-d2e9dd95a158	2026-08-28 11:04	2026-08-28 11:04	2026-08-28 11:04	XLI	XLI260918C00179000	call	179.0000	2026-09-18	2.0100	2.0100	2.0800	177.4300	15477.00	0.00	15477.00	77	12	77	399	0.192982456140351	0.150049925754046	0.150049925754046	false	false	false	true
bade22fe-7d8c-4512-b572-b6343c4ca935	2026-08-28 10:12	2026-08-28 10:11	2026-08-28 10:11	XLI	XLI260911C00183000	call	183.0000	2026-09-11	0.4500	0.3500	0.5000	177.9500	45045.00	45.00	45000.00	1001	23	1001	124	8.07258064516129	0.141331109072837	0.141331109072837	false	false	false	true
212f37b6-f8c7-4823-b036-8b32afd95f4f	2026-08-28 10:02	2026-08-28 10:02	2026-08-28 10:02	XLI	XLI270617C00190000	call	190.0000	2027-06-17	9.3400	9.2500	10.1000	178.2200	13080.00	945.00	12135.00	14	6	14	1347	0.0103934669636229	0.185440189804494	0.183933422546412	false	false	false	true
2d94ec28-53bf-4601-9882-6aab74fdc26b	2026-08-27 14:56	2026-08-27 14:56	2026-08-27 14:56	XLI	XLI280121C00167000	call	167.0000	2028-01-21	29.0000	28.7500	30.6500	178.5900	26100.00	0.00	26100.00	9	5	10	41	0.24390243902439	0.206202610312309	0.206202610312309	false	false	false	true
66454f3a-f026-4b58-8180-cc4817d76986	2026-08-27 14:50	2026-08-27 14:50	2026-08-27 14:50	XLI	XLI261016C00180000	call	180.0000	2026-10-16	4.2000	4.2000	4.4000	178.7300	18900.00	0.00	18900.00	45	10	97	70	1.38571428571429	0.165297246533677	0.165297246533677	false	false	false	true
ad0f52e0-2c17-4e82-8387-ca30a9010cf3	2026-08-27 14:01	2026-08-27 14:00	2026-08-27 14:00	XLI	XLI260918C00179000	call	179.0000	2026-09-18	2.9900	2.9900	3.1500	179.0600	25116.00	0.00	25116.00	84	23	86	441	0.195011337868481	0.156955489423797	0.156955489423797	false	false	false	true
33f00bd3-3d84-4a12-8040-750b345285ef	2026-08-27 13:38	2026-08-27 13:38	2026-08-27 13:38	XLI	XLI280121C00200000	call	200.0000	2028-01-21	12.4000	12.4000	12.8000	179.1700	44640.00	0.00	44640.00	36	12	139	1403	0.0990734141126158	0.192514059788643	0.192514059788643	true	false	false	true