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 = 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

0c0177e5-ca95-4744-97ae-56ff214927fa	2026-09-23 11:03	2026-09-23 11:03	2026-09-23 11:03	XLI	XLI261002C00168000	call	168.0000	2026-10-02	3.5500	3.5000	3.7000	170.5400	12070.00	355.00	11715.00	34	13	41	10	4.1	0.179217508059649	0.179217508059649	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30465909299.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T15:04:15.950179Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
3e96db5a-f5a3-487c-8954-496dace77de5	2026-09-23 10:56	2026-09-23 10:56	2026-09-23 10:56	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6600	2.6600	2.7500	170.6700	38304.00	0.00	38304.00	144	23	2183	10591	0.206118402417147	0.20192620268493	0.20192620268493	false	false	false	true
1bdcb7c7-b1d7-480e-a559-52377d23fa80	2026-09-23 10:56	2026-09-23 10:56	2026-09-23 10:56	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6800	2.6600	2.6800	170.6700	24656.00	24656.00	0.00	92	8	2039	10591	0.192521952601265	0.20277863393393	0.20277863393393	true	false	false	true
0e5c1b29-82c3-4fab-8622-daa6db2bc45c	2026-09-23 10:56	2026-09-23 10:56	2026-09-23 10:56	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.7000	2.6500	2.7000	170.6100	24570.00	18360.00	0.00	91	6	1947	10591	0.183835331885563	0.202874461681478	0.202874461681478	false	false	false	true
1d82ad2d-7738-4fed-b11d-f09dd4859af9	2026-09-23 10:56	2026-09-23 10:56	2026-09-23 10:56	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6900	2.6900	2.7500	170.6000	42233.00	0.00	42233.00	157	21	1856	10591	0.175243130960249	0.20232322567095	0.20232322567095	false	false	false	true
626fd119-64b7-4426-8aee-503f0b4610d2	2026-09-23 10:56	2026-09-23 10:56	2026-09-23 10:56	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.7000	2.6800	2.7000	170.6000	14040.00	11340.00	0.00	52	5	1652	10591	0.155981493721084	0.202748359239449	0.202748359239449	false	false	false	true
195d83b8-3585-426f-be9b-447b46f9bcc9	2026-09-23 10:56	2026-09-23 10:56	2026-09-23 10:56	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6800	2.6800	2.7600	170.6650	85224.00	0.00	85224.00	318	15	1600	10591	0.151071664620905	0.202715791601604	0.202715791601604	false	false	false	true
855fae57-fe19-4c10-bc29-20a1ea578811	2026-09-23 10:45	2026-09-23 10:45	2026-09-23 10:45	XLI	XLI261016C00172000	call	172.0000	2026-10-16	2.5400	2.5400	2.8100	170.5300	10922.00	0.00	10922.00	43	16	96	1534	0.0625814863102999	0.177003598146793	0.177003598146793	true	false	false	true
5ffe71cd-5db4-4315-ac1f-6c289e613bac	2026-09-23 10:34	2026-09-23 10:34	2026-09-23 10:34	XLI	XLI261120P00169000	put	169.0000	2026-11-20	4.1100	4.1000	4.4500	170.7500	50530.00	8300.00	42230.00	123	18	123	118	1.04237288135593	0.200728164737456	0.200728164737456	false	false	false	true
4056103f-f034-49ee-8d43-cae89e601d45	2026-09-23 10:34	2026-09-23 10:34	2026-09-23 10:34	XLI	XLI261120P00171000	put	171.0000	2026-11-20	4.9500	4.9500	5.2000	170.7500	18315.00	0.00	18315.00	37	20	242	1110	0.218018018018018	0.198234030281971	0.198234030281971	false	false	false	true
9f5646d6-92ae-4001-8028-474741a0a13f	2026-09-23 10:28	2026-09-23 10:28	2026-09-23 10:28	XLI	XLI261009C00168000	call	168.0000	2026-10-09	4.2500	4.1000	4.7500	170.4500	19555.00	425.00	19130.00	46	15	46	0	0	0.186078566174832	0.188145233275728	true	false	false	true
a5a3fdc8-8abb-49f3-bbd0-6ee6e0a05cba	2026-09-23 10:27	2026-09-23 10:27	2026-09-23 10:27	XLI	XLI261120P00171000	put	171.0000	2026-11-20	5.1500	5.1000	5.2000	170.4600	10300.00	3090.00	0.00	20	6	197	1110	0.177477477477477	0.200665202559905	0.200665202559905	false	false	false	true
d753a304-617b-4d1f-b52b-bb1781973c2d	2026-09-23 10:27	2026-09-23 10:27	2026-09-23 10:27	XLI	XLI261120P00171000	put	171.0000	2026-11-20	5.1500	5.1000	5.2000	170.4600	14420.00	5665.00	0.00	28	5	163	1110	0.146846846846847	0.201011012001312	0.200665202559905	false	false	false	true
bd438cf9-afe0-44a8-be03-a9583151abba	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	XLI	XLI261009C00170000	call	170.0000	2026-10-09	3.0000	3.0000	3.4000	170.0000	11700.00	0.00	11700.00	39	5	40	52	0.769230769230769	0.181790844030405	0.181790844030405	false	false	false	true
335f85ec-2216-4523-9523-84f5346b1433	2026-09-23 10:24	2026-09-23 10:24	2026-09-23 10:24	XLI	XLI261016C00170000	call	170.0000	2026-10-16	3.7500	3.7500	3.9000	170.7000	17625.00	0.00	17625.00	47	18	84	881	0.0953461975028377	0.185233453845447	0.185233453845447	true	false	false	true
7c3aac38-b64f-4d1c-956f-71194345b64f	2026-09-23 10:14	2026-09-23 10:14	2026-09-23 10:14	XLI	XLI261009C00174000	call	174.0000	2026-10-09	1.3900	1.2800	1.3900	171.0000	13344.00	13344.00	0.00	96	20	96	11	8.72727272727273	0.172404912712845	0.172404912712845	false	false	false	true
7ef5f82f-3f0d-4db7-bd4f-1c5dce0ec45c	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	XLI	XLI261120C00176000	call	176.0000	2026-11-20	3.6000	3.2500	3.7000	170.0000	18000.00	17640.00	360.00	50	6	50	2	25	0.193679747987154	0.193679747987154	false	false	false	true
400b8f81-fbbf-43fd-9fca-e098c8430490	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	XLI	XLI260925C00172000	call	172.0000	2026-09-25	0.5100	0.4300	0.5100	170.0000	39321.00	39321.00	0.00	771	30	945	1191	0.793450881612091	0.201464338702443	0.201464338702443	false	false	false	true
ee78e69d-cfaa-48ad-80d7-9b85f19dd01d	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	XLI	XLI261120C00185000	call	185.0000	2026-11-20	1.1000	0.9400	1.2500	170.0000	10340.00	8360.00	1980.00	94	7	125	2545	0.0491159135559921	0.185946260012239	0.185946260012239	false	false	false	true
7f6e2665-f59f-486a-bb9c-a5a09f2d19dd	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	XLI	XLI261023C00172000	call	172.0000	2026-10-23	2.6000	2.6000	3.1000	169.0000	17160.00	0.00	17160.00	66	7	66	72	0.916666666666667	0.175830883409614	0.175830883409614	true	false	false	true
b5499860-d22a-41ae-b5fd-12111f5d5427	2026-09-22 15:54	2026-09-22 15:54	2026-09-22 15:54	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.8100	2.8100	2.8700	170.0000	12645.00	0.00	12645.00	45	9	2429	9910	0.24510595358224	0.204549848431608	0.204549848431608	false	false	false	true
066457ca-0a31-4901-953c-3224388a27ba	2026-09-22 15:54	2026-09-22 15:54	2026-09-22 15:54	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.8100	2.8000	2.8700	170.0000	78680.00	281.00	78399.00	280	26	2263	9910	0.228355196770938	0.204423573760913	0.204423573760913	false	false	false	true
fdeec8be-76bf-4e2d-8d14-d623a45e5a46	2026-09-22 15:54	2026-09-22 15:54	2026-09-22 15:54	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.8300	2.8300	2.8400	170.0000	26885.00	0.00	26885.00	95	8	1907	9910	0.192431886982846	0.204880658709357	0.204880658709357	false	false	false	true
baf44445-be8b-4583-b4c8-416456bb336c	2026-09-22 15:52	2026-09-22 15:52	2026-09-22 15:52	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.8500	2.8500	2.8900	170.4650	29640.00	0.00	29640.00	104	7	1430	9910	0.144298688193744	0.205906080379899	0.205906080379899	false	false	false	true
f992b03b-5cde-418f-9e6c-1f176673c8bf	2026-09-22 15:51	2026-09-22 15:51	2026-09-22 15:51	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.8700	2.8700	2.8800	170.4100	10906.00	0.00	10906.00	38	11	1319	9910	0.133097880928355	0.206042960624537	0.206042960624537	false	false	false	true
0a65d89a-1116-446d-99d2-aa352aecb72f	2026-09-22 15:48	2026-09-22 15:48	2026-09-22 15:48	XLI	XLI261016C00177000	call	177.0000	2026-10-16	0.9100	0.7600	0.9100	170.3500	19565.00	19565.00	0.00	215	20	684	2130	0.32112676056338	0.172435184762453	0.172435184762453	false	false	false	true
05a058b8-dd49-4b0c-a4ab-1dfed7d33c4e	2026-09-22 15:48	2026-09-22 15:48	2026-09-22 15:48	XLI	XLI261016C00179000	call	179.0000	2026-10-16	0.6000	0.4800	0.6000	170.3500	42060.00	42060.00	0.00	701	44	715	228	3.1359649122807	0.17528324333873	0.17528324333873	false	false	false	true
95452d34-9bba-457b-b35b-15c813b0e0f2	2026-09-22 15:46	2026-09-22 15:46	2026-09-22 15:46	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.7500	4.7000	4.8000	170.2700	47025.00	10450.00	30875.00	99	18	577	46187	0.0124926927490419	0.199255040193396	0.199255040193396	false	false	false	true
1228d06f-c802-4ce9-b6ce-3b9f70872ba4	2026-09-22 15:42	2026-09-22 15:42	2026-09-22 15:42	XLI	XLI261120P00168000	put	168.0000	2026-11-20	3.9500	3.9500	4.0000	170.2700	19750.00	0.00	19750.00	50	5	454	28098	0.0161577336465229	0.202532984900464	0.202532984900464	false	false	false	true
f0875bf4-863a-450e-b0e4-9706f33ebd24	2026-09-22 15:06	2026-09-22 15:06	2026-09-22 15:06	XLI	XLI261009C00175000	call	175.0000	2026-10-09	0.8300	0.7600	0.8300	170.0600	31124.00	31042.00	82.00	375	33	378	22	17.1818181818182	0.167521244978792	0.167521244978792	false	false	false	true
d6ce51b1-d25d-48a7-b8af-f47decee8bde	2026-09-22 14:55	2026-09-22 14:55	2026-09-22 14:55	XLI	XLI260925C00172000	call	172.0000	2026-09-25	0.4000	0.3400	0.4000	170.0400	15400.00	15400.00	0.00	385	16	464	928	0.5	0.177806336041642	0.177806336041642	false	false	false	true
82258b82-a703-4b8d-b2f0-f9f74c5a3882	2026-09-22 14:55	2026-09-22 14:55	2026-09-22 14:55	XLI	XLI261016P00165000	put	165.0000	2026-10-16	1.1800	1.1800	1.2800	170.0300	12273.00	0.00	12273.00	104	30	148	1082	0.136783733826248	0.186697610787335	0.187434355254108	false	false	false	true
99bf11d1-6461-4e42-83dc-9732a6a9c48d	2026-09-22 14:50	2026-09-22 14:50	2026-09-22 14:50	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0900	1.0900	1.1400	170.0300	18203.00	0.00	5450.00	167	8	3974	9324	0.426211926211926	0.230480723073607	0.230480723073607	false	false	false	true
b8f0fd79-e759-4cdb-8d65-7faf31d91831	2026-09-22 14:31	2026-09-22 14:31	2026-09-22 14:31	XLI	XLI261120P00171000	put	171.0000	2026-11-20	5.4000	5.3000	5.4000	169.8750	53460.00	53460.00	0.00	99	27	106	1072	0.0988805970149254	0.198325201804478	0.198325201804478	false	false	false	true
418bea62-3a8e-42e3-9069-480b77e1d8cc	2026-09-22 14:12	2026-09-22 14:12	2026-09-22 14:12	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.8500	4.7500	4.8500	170.0550	94090.00	94090.00	0.00	194	40	461	46187	0.00998116353086366	0.199403589605202	0.199403589605202	false	false	false	true
5e6fc665-8abd-4f8f-883e-6fd82bebbea0	2026-09-22 13:57	2026-09-22 13:57	2026-09-22 13:57	XLI	XLI261002C00172000	call	172.0000	2026-10-02	1.1500	1.1000	1.1500	170.1500	117990.00	117990.00	0.00	1026	25	1084	14	77.4285714285714	0.165180339105315	0.165180339105315	false	false	false	true
0c4a0410-fcd3-4a81-92a0-f39038aeb126	2026-09-22 13:43	2026-09-22 13:43	2026-09-22 13:43	XLI	XLI261120P00168000	put	168.0000	2026-11-20	4.1000	4.0500	4.1500	169.7300	13120.00	0.00	6560.00	32	6	393	28098	0.0139867606235319	0.200219408258079	0.200143370437206	false	false	false	true
79a6b9b8-ac19-4ff4-8bce-36a31e64c527	2026-09-22 13:31	2026-09-22 13:30	2026-09-22 13:30	XLI	XLI261120C00183000	call	183.0000	2026-11-20	1.3800	1.3300	1.3800	169.0000	235014.00	235014.00	0.00	1703	24	1778	21	84.6666666666667	0.190847463880887	0.190847463880887	false	false	false	true
603f35c6-406f-4247-815d-2d2949d5c141	2026-09-22 13:10	2026-09-22 13:10	2026-09-22 13:10	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.1000	1.1000	1.1100	169.8800	10560.00	0.00	10560.00	96	5	3659	9324	0.392428142428142	0.229804607434533	0.229804607434533	false	false	false	true
07cd2d3a-5a29-4069-aa0d-5d7cdacf2ae1	2026-09-22 13:10	2026-09-22 13:10	2026-09-22 13:10	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.1000	1.0700	1.1000	169.8500	113410.00	113410.00	0.00	1031	30	3464	9324	0.371514371514371	0.229532390060834	0.229532390060834	false	false	false	true
1f382fbe-6899-4bca-92cc-c3925207497e	2026-09-22 13:09	2026-09-22 13:09	2026-09-22 13:09	XLI	XLI261120P00168000	put	168.0000	2026-11-20	4.0000	3.9500	4.0500	169.8400	13200.00	10400.00	2800.00	33	7	175	28098	0.00622820129546587	0.198016651031843	0.198016651031843	false	false	false	true
0fbf7afa-59f3-4afc-88ac-b500cc35bb5d	2026-09-22 13:09	2026-09-22 13:09	2026-09-22 13:09	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0900	1.0600	1.0900	169.8600	22018.00	22018.00	0.00	202	20	2244	9324	0.240669240669241	0.228942684882892	0.228942684882892	false	false	false	true
1c166e86-9f32-4ce1-bb38-5acdc918767e	2026-09-22 13:08	2026-09-22 13:08	2026-09-22 13:08	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0800	1.0600	1.0800	169.8400	10476.00	10476.00	0.00	97	11	1905	9324	0.204311454311454	0.228078948046311	0.228078948046311	false	false	false	true
0c8e2cc3-cc2c-44f7-99dd-fe5662acecf5	2026-09-22 13:08	2026-09-22 13:08	2026-09-22 13:08	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0800	1.0600	1.0800	169.8100	18252.00	18252.00	0.00	169	16	1808	9324	0.193908193908194	0.22780736942133	0.22780736942133	false	false	false	true
1cd8880e-1cf4-4d15-bb21-1ae376498cc9	2026-09-22 13:08	2026-09-22 13:08	2026-09-22 13:08	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0800	1.0800	1.1000	169.8100	11016.00	0.00	1944.00	102	9	1639	9324	0.175782925782926	0.22780736942133	0.22780736942133	true	false	false	true
d5a6ab64-dcaa-4751-93b7-eac8ba51d775	2026-09-22 13:08	2026-09-22 13:08	2026-09-22 13:08	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.8500	4.7500	4.8500	169.8101	22310.00	22310.00	0.00	46	10	94	46187	0.0020352047112824	0.195305061391158	0.195305061391158	true	false	false	true
3fa14358-43e1-4be3-a830-fad1a3fd6f44	2026-09-22 13:02	2026-09-22 13:02	2026-09-22 13:02	XLI	XLI261016P00159000	put	159.0000	2026-10-16	0.4500	0.3200	0.4800	169.0000	47250.00	225.00	47025.00	1050	21	1050	0	0	0.213596259889296	0.213596259889296	false	false	false	true
1ff42d00-bdf2-4cd3-bdfa-09bad88fe78c	2026-09-22 12:49	2026-09-22 12:49	2026-09-22 12:49	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0500	1.0200	1.0500	170.1450	13335.00	13335.00	0.00	127	15	1537	9324	0.164843414843415	0.228757328566967	0.228757328566967	false	false	false	true
06e8d124-ade3-49f6-af76-aa97d8ff8998	2026-09-22 12:49	2026-09-22 12:49	2026-09-22 12:49	XLI	XLI261016C00177000	call	177.0000	2026-10-16	0.8400	0.8200	0.8400	170.1050	34272.00	34272.00	0.00	408	42	431	2130	0.202347417840376	0.170970723876626	0.170970723876626	false	false	false	true
7cea6d76-320f-4e27-ac52-7af609cf81b7	2026-09-22 12:49	2026-09-22 12:49	2026-09-22 12:49	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.9000	2.8300	2.9000	170.1050	28990.00	26100.00	2890.00	100	11	479	9910	0.048335015136226	0.203391537685523	0.20297725758172	true	false	false	true