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:source = uw_flow_alerts×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

f8e60d17-d9f9-48f0-81cd-38b1faf69c5e	2026-08-17 10:21	2026-08-17 10:20	2026-08-17 10:20	XLI	XLI260918P00181000	put	181.0000	2026-09-18	1.6400	1.6300	1.7600	186.7200	109880.00	0.00	109880.00	670	9	672	1114	0.603231597845601	0.186296992927095	0.186296992927095	false	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-08-17T14:25:15.386684Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
1dccda5f-427e-4f0d-a04b-ab9be67be39a	2026-08-17 10:45	2026-08-17 10:45	2026-08-17 10:45	XLI	XLI260918C00190000	call	190.0000	2026-09-18	2.6300	2.5100	2.8500	186.6700	13150.00	0.00	13150.00	50	5	57	5770	0.00987868284228769	0.172382637139625	0.172382637139625	false	false	false	true
2ec11e61-5344-4fae-8d07-bb29f6cb3a31	2026-08-17 11:05	2026-08-17 11:05	2026-08-17 11:05	XLI	XLI260918C00190000	call	190.0000	2026-09-18	2.5100	2.5100	2.7200	186.6400	116464.00	0.00	116464.00	464	46	521	5770	0.0902946273830156	0.167309210312741	0.167309210312741	false	false	false	true
70fb7a02-e55e-4d6a-86bc-6b056b90fd00	2026-08-17 11:48	2026-08-17 11:48	2026-08-17 11:48	XLI	XLI260918P00190000	put	190.0000	2026-09-18	5.1500	5.1500	5.4500	186.7300	11845.00	0.00	11845.00	23	8	45	107	0.420560747663551	0.165522481404247	0.165805532020289	false	false	false	true
81cf5784-99ad-49bf-819f-1407ecc55cbd	2026-08-17 12:29	2026-08-17 12:29	2026-08-17 12:29	XLI	XLI260918P00181000	put	181.0000	2026-09-18	1.4700	1.4700	1.5300	187.0600	14553.00	0.00	14553.00	99	27	780	1114	0.700179533213645	0.181440811753529	0.181440811753529	false	false	false	true
ade593c8-bcee-4cdc-a440-61ca372d8db0	2026-08-17 12:36	2026-08-17 12:36	2026-08-17 12:36	XLI	XLI260918P00165000	put	165.0000	2026-09-18	0.2600	0.2000	0.2600	187.1000	33319.00	29494.00	0.00	1297	39	1957	56245	0.0347942039292382	0.257704209831795	0.259700125852892	false	false	false	true
ed02eb8a-4b22-4781-be14-e3c84aaf5117	2026-08-17 12:36	2026-08-17 12:36	2026-08-17 12:36	XLI	XLI260918P00165000	put	165.0000	2026-09-18	0.2600	0.2000	0.2600	187.1000	16692.00	16692.00	0.00	642	24	4746	56245	0.0843808338518979	0.259700125852892	0.259700125852892	false	false	false	true
ee0a3669-26fb-480c-8f1f-b5ba0d2b6565	2026-08-17 12:37	2026-08-17 12:37	2026-08-17 12:37	XLI	XLI260918P00165000	put	165.0000	2026-09-18	0.2800	0.2600	0.2800	187.1200	18424.00	18424.00	0.00	658	36	6397	56245	0.113734554182594	0.263739366347183	0.263739366347183	false	false	false	true
3157714d-ea94-467e-a6b8-e3d0218b5f91	2026-08-17 12:37	2026-08-17 12:37	2026-08-17 12:37	XLI	XLI260918P00165000	put	165.0000	2026-09-18	0.2700	0.2400	0.2800	187.1200	19547.00	19520.00	27.00	733	45	5738	56245	0.102017957151747	0.259870020476677	0.261824520512148	false	false	false	true
63eceabe-667a-4463-93d0-e74be4c4f87f	2026-08-17 12:37	2026-08-17 12:37	2026-08-17 12:37	XLI	XLI260918P00165000	put	165.0000	2026-09-18	0.3000	0.2800	0.3000	187.1100	11190.00	11190.00	0.00	373	35	7206	56245	0.128118054938217	0.267372834180823	0.267372834180823	false	false	false	true
e7d8f9a5-0a76-4b73-b305-0cad4e7ca267	2026-08-17 12:37	2026-08-17 12:37	2026-08-17 12:37	XLI	XLI260918P00165000	put	165.0000	2026-09-18	0.3300	0.3100	0.3300	187.1100	12355.00	12355.00	0.00	376	35	7912	56245	0.140670281802827	0.270959420130557	0.272707376094291	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
bd75508f-e0f1-4e04-a0ab-54d2e29e8b20	2026-08-17 12:37	2026-08-17 12:37	2026-08-17 12:37	XLI	XLI260918C00182000	call	182.0000	2026-09-18	7.5000	6.9500	7.5500	187.1150	36728.00	36728.00	0.00	49	6	57	1158	0.0492227979274611	0.184080290715634	0.184080290715634	false	false	false	true
6e078d55-4491-405d-bdf3-d82371e21961	2026-08-17 12:37	2026-08-17 12:37	2026-08-17 12:37	XLI	XLI260918P00165000	put	165.0000	2026-09-18	0.3600	0.3400	0.3600	187.1100	28512.00	28512.00	0.00	792	15	10008	56245	0.177935816517024	0.277787755146011	0.277787755146011	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
7013166c-fd93-441c-b139-b11593638016	2026-08-17 12:38	2026-08-17 12:37	2026-08-17 12:37	XLI	XLI261120P00180000	put	180.0000	2026-11-20	4.0000	3.9500	4.2000	187.1300	100800.00	400.00	100400.00	252	30	910	11811	0.0770468207603082	0.205997082373098	0.205997082373098	false	false	false	true
c50bce35-dde0-47cf-8152-0cfa8dcb366e	2026-08-17 12:42	2026-08-17 12:42	2026-08-17 12:42	XLI	XLI261120P00180000	put	180.0000	2026-11-20	3.9500	3.9000	4.1000	187.2600	253985.00	395.00	253590.00	643	18	1806	11811	0.152908305816612	0.205669621891663	0.205669621891663	false	false	false	true
1ad4acbf-937d-4e46-bc55-6b96161f42a8	2026-08-17 12:42	2026-08-17 12:42	2026-08-17 12:42	XLI	XLI261120P00180000	put	180.0000	2026-11-20	3.9000	3.9000	4.0000	187.2600	93990.00	0.00	93990.00	241	16	2047	11811	0.173313013292693	0.204162211203834	0.204162211203834	false	false	false	true
b9875b0b-d0b2-49b2-8f07-f54804a173d9	2026-08-17 12:43	2026-08-17 12:42	2026-08-17 12:42	XLI	XLI261120P00180000	put	180.0000	2026-11-20	3.9000	3.9000	4.0000	187.2850	11700.00	0.00	11700.00	30	6	2104	11811	0.178139022944713	0.204387319261213	0.204387319261213	false	false	false	true
165b53f3-43d2-4652-b076-c1d3cde4bc78	2026-08-17 12:43	2026-08-17 12:42	2026-08-17 12:42	XLI	XLI261120P00180000	put	180.0000	2026-11-20	3.9000	3.8500	4.0000	187.2850	10530.00	0.00	10530.00	27	9	2074	11811	0.175599017864702	0.204387319261213	0.204387319261213	false	false	false	true
81d37f39-5ce0-4e75-8ce9-7ecafa38ded5	2026-08-17 12:43	2026-08-17 12:43	2026-08-17 12:43	XLI	XLI261120P00180000	put	180.0000	2026-11-20	3.8500	3.8500	3.9500	187.3100	86625.00	0.00	86625.00	225	17	3069	11811	0.259842519685039	0.203101467328781	0.203101467328781	false	false	false	true
9d2699fa-55fb-455c-9714-980192e49c3f	2026-08-17 12:43	2026-08-17 12:43	2026-08-17 12:43	XLI	XLI260918C00182000	call	182.0000	2026-09-18	7.7000	7.1000	7.7000	187.3150	20788.00	20788.00	0.00	27	18	85	1158	0.0734024179620035	0.18704532328126	0.18704532328126	false	false	false	true
f3d97f20-00f1-4577-9ce2-4c0dd38083cf	2026-08-17 12:43	2026-08-17 12:43	2026-08-17 12:43	XLI	XLI261120P00180000	put	180.0000	2026-11-20	3.8000	3.8000	3.8500	187.3299	15200.00	0.00	15200.00	40	5	3659	11811	0.309795952925239	0.201766314687078	0.201766314687078	false	false	false	true
71109caf-60f3-441c-89e6-2e93bc67b25c	2026-08-17 12:43	2026-08-17 12:43	2026-08-17 12:43	XLI	XLI261120P00180000	put	180.0000	2026-11-20	3.8000	3.8000	3.8500	187.3300	69160.00	0.00	69160.00	182	15	3841	11811	0.325205317077301	0.201767210149396	0.201767210149396	false	false	false	true
7279e4c6-7c35-4dd8-b40c-77590e79478b	2026-08-17 12:43	2026-08-17 12:43	2026-08-17 12:43	XLI	XLI261218P00186000	put	186.0000	2026-12-18	6.8500	6.7000	6.9000	187.3350	56170.00	685.00	55485.00	82	20	82	2	41	0.200714777216739	0.200714777216739	false	false	false	true
4bad5305-728c-443d-9771-6595c44ccc94	2026-08-17 12:43	2026-08-17 12:43	2026-08-17 12:43	XLI	XLI261218P00184000	put	184.0000	2026-12-18	6.0500	6.0500	6.1000	187.3350	21175.00	0.00	21175.00	35	11	35	2	17.5	0.202137487086269	0.202137487086269	false	false	false	true
619176af-6102-4759-b7e6-03e4ed3b201c	2026-08-17 12:44	2026-08-17 12:44	2026-08-17 12:44	XLI	XLI261120P00190000	put	190.0000	2026-11-20	7.9000	7.7000	7.9000	187.3000	118495.00	118495.00	0.00	150	29	150	790	0.189873417721519	0.196355407824874	0.196355407824874	false	false	false	true
825b2eb8-7260-4fcb-87a3-52dda1833049	2026-08-17 12:44	2026-08-17 12:44	2026-08-17 12:44	XLI	XLI261120P00185000	put	185.0000	2026-11-20	5.5500	5.4000	5.6000	187.2750	29970.00	29970.00	0.00	54	6	164	351	0.467236467236467	0.197325428237964	0.197325428237964	false	false	false	true
33d93aab-58d3-4975-afec-1f9ee7f8b9bc	2026-08-17 12:48	2026-08-17 12:48	2026-08-17 12:48	XLI	XLI270319P00181000	put	181.0000	2027-03-19	7.0500	7.0500	7.2500	187.3100	52875.00	0.00	52875.00	75	20	75	1	75	0.207816863729381	0.207816863729381	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
04522865-068e-4c33-968f-5027637933d9	2026-08-17 15:47	2026-08-17 15:47	2026-08-17 15:47	XLI	XLI260918P00160000	put	160.0000	2026-09-18	0.2000	0.2000	0.2300	186.4899	10280.00	0.00	10280.00	514	31	732	18023	0.0406147700160906	0.290188851409342	0.290188851409342	false	false	false	true
a3ebf19e-6da0-466a-bbe1-05b5d5a57713	2026-08-18 09:39	2026-08-18 09:39	2026-08-18 09:39	XLI	XLI280121C00200000	call	200.0000	2028-01-21	16.2000	15.1000	17.4000	184.0000	32400.00	1620.00	30780.00	20	9	20	1404	0.0142450142450142	0.203122306419139	0.203122306419139	false	false	false	true
580c415a-fafb-4bcc-bef2-35250312a493	2026-08-18 10:12	2026-08-18 10:12	2026-08-18 10:12	XLI	XLI260918C00190000	call	190.0000	2026-09-18	1.7000	1.5100	1.9500	184.4900	100300.00	510.00	99790.00	590	40	591	5620	0.105160142348754	0.167279440321042	0.167279440321042	true	false	false	true
5f930ea8-c87d-46c7-91d6-dfed1da8b00f	2026-08-18 10:46	2026-08-18 10:45	2026-08-18 10:45	XLI	XLI260918C00195000	call	195.0000	2026-09-18	0.6400	0.6400	0.8100	184.3900	30785.00	0.00	30785.00	481	47	486	7685	0.0632400780741705	0.165866834180492	0.166687846792683	false	false	false	true
89eb3acf-5bd8-41e3-a6ca-db1b9c6ec1ee	2026-08-18 10:46	2026-08-18 10:46	2026-08-18 10:46	XLI	XLI260918C00195000	call	195.0000	2026-09-18	0.6400	0.5500	0.6400	184.3800	30016.00	30016.00	0.00	469	26	957	7685	0.124528301886792	0.165984732166604	0.165984732166604	true	false	false	true
862f2d19-9096-4b2e-8652-a17ab4f13239	2026-08-18 10:46	2026-08-18 10:46	2026-08-18 10:46	XLI	XLI260918C00195000	call	195.0000	2026-09-18	0.6400	0.5500	0.6400	184.3800	32960.00	32960.00	0.00	515	16	1472	7685	0.191541964866623	0.165984732166604	0.165984732166604	true	false	false	true
9e8793e7-4780-4f7d-9bd9-74ff7073354a	2026-08-18 11:17	2026-08-18 11:17	2026-08-18 11:17	XLI	XLI260918P00175000	put	175.0000	2026-09-18	0.9400	0.8200	0.9400	184.1800	34686.00	34686.00	0.00	369	42	372	3931	0.0946324090562198	0.196464893686987	0.196464893686987	false	false	false	true
3b172573-10b9-4a35-b197-570cc56b6422	2026-08-18 13:46	2026-08-18 13:46	2026-08-18 13:46	XLI	XLI270319C00180000	call	180.0000	2027-03-19	15.0000	15.0000	15.7000	183.7800	16505.00	0.00	16505.00	11	6	17	42	0.404761904761905	0.192961832080594	0.192961832080594	true	false	false	true
a8944d98-d2c1-4e0b-9557-bc9717e78167	2026-08-18 14:09	2026-08-18 14:09	2026-08-18 14:09	XLI	XLI261120C00180000	call	180.0000	2026-11-20	10.0200	10.0000	10.5500	183.6900	22050.00	1005.00	21045.00	22	9	22	358	0.0614525139664804	0.188835936232108	0.190272091586695	false	false	false	true
b27c4963-5fe2-4c4b-81e9-6ecbec70db49	2026-08-18 14:52	2026-08-18 14:52	2026-08-18 14:52	XLI	XLI260918P00175000	put	175.0000	2026-09-18	0.9900	0.9300	0.9900	183.7400	15444.00	15444.00	0.00	156	30	539	3931	0.137115237852964	0.194683713030896	0.194683713030896	false	false	false	true
eefb0959-8b7c-41ba-ada0-ae4734fc5292	2026-08-18 15:29	2026-08-18 15:29	2026-08-18 15:29	XLI	XLI261002C00197500	call	197.5000	2026-10-02	0.7700	0.7700	0.9800	183.7950	83776.00	0.00	83776.00	1088	24	1091	0	0	0.172161547954555	0.172161547954555	false	false	false	true
d379c8cd-755f-4a07-b9f2-ea25557b5b27	2026-08-18 15:44	2026-08-18 15:44	2026-08-18 15:44	XLI	XLI261016C00183000	call	183.0000	2026-10-16	6.2200	6.0000	6.6000	183.7600	18664.00	0.00	18664.00	30	10	42	0	0	0.177802351233176	0.177802351233176	false	false	false	true
15edb301-38c2-41cb-ab84-7018d3f80bc6	2026-08-19 09:40	2026-08-19 09:40	2026-08-19 09:40	XLI	XLI261120C00180000	call	180.0000	2026-11-20	9.6000	9.5000	10.3000	183.1900	11520.00	960.00	10560.00	12	7	12	401	0.029925187032419	0.187909957482574	0.187909957482574	false	false	false	true
813468ec-e58a-45f0-97b2-b48bd09135e4	2026-08-19 09:56	2026-08-19 09:56	2026-08-19 09:56	XLI	XLI260904C00182000	call	182.0000	2026-09-04	3.7500	3.2500	3.7500	183.5000	10125.00	10125.00	0.00	27	8	27	1	27	0.180723469173954	0.180723469173954	true	false	false	true
152c7738-ef51-4a18-99c3-b21f62d6688c	2026-08-19 10:12	2026-08-19 10:11	2026-08-19 10:11	XLI	XLI260828P00180000	put	180.0000	2026-08-28	0.9000	0.6500	0.9000	182.5150	19259.00	19259.00	0.00	214	27	214	128	1.671875	0.172313011903425	0.172313011903425	true	false	false	true
7aa5aae5-acbe-4dc1-abb5-cccf08b5c367	2026-08-19 10:20	2026-08-19 10:20	2026-08-19 10:20	XLI	XLI260904C00181000	call	181.0000	2026-09-04	4.0500	3.5000	4.0500	183.0300	25110.00	25110.00	0.00	62	17	62	5	12.4	0.179623746337526	0.179623746337526	true	false	false	true
045485c6-087d-4848-a5f7-5bbabbdec6f4	2026-08-19 13:46	2026-08-19 13:46	2026-08-19 13:46	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.1000	4.8500	5.1000	182.4900	143310.00	143310.00	0.00	281	6	281	11046	0.0254390729675901	0.193526416353382	0.193526416353382	false	false	false	true
68ce918c-dfa0-4dec-9cd4-5d20703da0ab	2026-08-19 13:46	2026-08-19 13:46	2026-08-19 13:46	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.1000	5.0500	5.2000	182.5000	53040.00	0.00	53040.00	104	6	1346	11046	0.121854064819844	0.193635865678012	0.193635865678012	false	false	false	true
f5eb8345-f2e7-49ea-91e3-2e9b381c7edb	2026-08-19 14:45	2026-08-19 14:45	2026-08-19 14:45	XLI	XLI260918C00185000	call	185.0000	2026-09-18	2.3400	2.3400	2.4100	182.2400	33696.00	0.00	33696.00	144	28	174	3246	0.0536044362292052	0.158307811784743	0.158307811784743	false	false	false	true
6f5e6559-bb32-44ae-97c7-53a4c82844ab	2026-08-19 15:23	2026-08-19 15:23	2026-08-19 15:23	XLI	XLI260828C00187000	call	187.0000	2026-08-28	0.4300	0.3900	0.4800	181.9700	31474.00	84.00	31390.00	732	32	737	19	38.7894736842105	0.171306161395437	0.168487364787002	false	false	false	true