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 = RepeatedHitsAscendingFill×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	expiry

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	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	30796170295.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
affdf22c-26c2-44aa-8cae-d3c98ee2456a	2026-08-20 09:38	2026-08-20 09:38	2026-08-20 09:38	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.5500	5.5500	5.7000	180.7400	306415.00	0.00	306415.00	552	46	1978	10402	0.190155739280908	0.187064329614264	0.187064329614264	false	false	false	true
eb3d641a-25ca-464a-b360-42a6ece8c0ff	2026-08-20 09:39	2026-08-20 09:39	2026-08-20 09:39	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.4000	5.4000	5.5000	181.1500	277065.00	0.00	277065.00	513	23	4181	10402	0.401941934243415	0.187668645449139	0.187668645449139	false	false	false	true
acf1d61c-f8e4-4d47-b511-35a2ba5c76dd	2026-08-20 09:41	2026-08-20 09:41	2026-08-20 09:41	XLI	XLI261120P00180000	put	180.0000	2026-11-20	5.5000	5.3500	5.5000	181.2050	15398.00	15398.00	0.00	28	16	5687	10402	0.546721784272255	0.190568411423468	0.191132925740194	true	false	false	true
9cf5635c-1d65-4d42-bff2-17fb90e8ebb6	2026-08-24 10:46	2026-08-24 10:46	2026-08-24 10:46	XLI	XLI261120C00175000	call	175.0000	2026-11-20	9.6000	9.4000	10.0500	179.0700	25912.00	0.00	25912.00	27	5	27	192	0.140625	0.183338680909358	0.183957276325647	false	false	false	true
bd277035-741f-445e-8b53-b070713c81a3	2026-08-25 14:05	2026-08-25 14:05	2026-08-25 14:05	XLI	XLI260904C00176000	call	176.0000	2026-09-04	3.3500	3.3500	3.5000	178.0000	80755.00	0.00	80755.00	241	48	291	2	145.5	0.166380089166062	0.166380089166062	false	false	false	true
afd943aa-8695-492d-9c8e-69a0457c6fa8	2026-09-01 12:45	2026-09-01 12:44	2026-09-01 12:44	XLI	XLI261016P00173000	put	173.0000	2026-10-16	4.1500	4.1500	4.3500	172.4100	16603.00	0.00	16603.00	40	23	190	4	47.5	0.176820243967566	0.176820243967566	false	false	false	true
82b4cdeb-eb35-418f-ba01-d79d6b18c9f1	2026-09-01 14:06	2026-09-01 14:05	2026-09-01 14:05	XLI	XLI261016P00173000	put	173.0000	2026-10-16	4.1200	4.0000	4.3000	172.6750	20583.00	0.00	20583.00	50	5	255	4	63.75	0.179954668306804	0.179954668306804	false	false	false	true
cf3743d7-bd85-48a8-b707-e2392d04f029	2026-09-09 10:22	2026-09-09 10:21	2026-09-09 10:21	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1400	0.9800	1.1400	172.5500	109667.00	109667.00	0.00	962	14	1344	4659	0.28847392144237	0.207720881838775	0.208769388598449	true	false	false	true
af9af478-6d0c-4e58-ba32-862450b25f24	2026-09-10 10:23	2026-09-10 10:23	2026-09-10 10:23	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.5600	1.5400	1.7000	170.8700	22688.00	3140.00	19548.00	145	26	258	5418	0.0476190476190476	0.201344933328471	0.202358710376772	true	false	false	true
61a70959-04a5-43c3-b766-6373feb848bf	2026-09-11 09:59	2026-09-11 09:59	2026-09-11 09:59	XLI	XLI260918P00170000	put	170.0000	2026-09-18	0.9100	0.6900	1.0100	172.0000	45412.00	45412.00	0.00	500	12	503	4965	0.101309164149043	0.199691741733671	0.199691741733671	false	false	false	true
db6cb6b2-bb06-4c8f-a5b2-c2c741b5b1ec	2026-09-11 14:26	2026-09-11 14:26	2026-09-11 14:26	XLI	XLI261016C00174000	call	174.0000	2026-10-16	3.2000	3.2000	3.3500	172.6650	109768.00	0.00	109768.00	343	44	461	109	4.22935779816514	0.164888029872303	0.164888029872303	false	false	false	true
82875680-a0c9-4c98-9f5a-8cd1fa99bee5	2026-09-17 09:51	2026-09-17 09:51	2026-09-17 09:51	XLI	XLI261218P00157000	put	157.0000	2026-12-18	1.9400	1.9400	2.2100	170.8700	99730.00	2730.00	97000.00	514	57	514	68	7.55882352941176	0.220424597724844	0.220869135630682	false	false	false	true
ca950eeb-2046-415a-91d0-59bb93ef1e0e	2026-09-18 12:50	2026-09-18 12:50	2026-09-18 12:50	XLI	XLI280121P00125000	put	125.0000	2028-01-21	2.4300	2.3800	2.8200	168.8800	12156.00	0.00	12156.00	50	10	50	8	6.25	0.261648639534876	0.263868456028277	false	false	false	true
6e628f50-7b20-47b1-9025-d9eef61d425c	2026-09-18 12:50	2026-09-18 12:50	2026-09-18 12:50	XLI	XLI280121P00175000	put	175.0000	2028-01-21	15.6200	15.6000	16.3000	168.8900	12500.00	3130.00	9370.00	8	7	8	89	0.0898876404494382	0.231430348740274	0.232088818828735	false	false	false	true
4a4d2622-1d79-4820-ae7e-275ba68f0f10	2026-09-18 12:53	2026-09-18 12:53	2026-09-18 12:53	XLI	XLI280121P00125000	put	125.0000	2028-01-21	2.4000	2.3700	2.6400	169.0000	13205.00	0.00	13205.00	55	8	498	8	62.25	0.261695398382697	0.262624069708162	false	false	false	true
89829d47-f94e-4a69-b325-364a6e7342a8	2026-09-21 13:26	2026-09-21 13:26	2026-09-21 13:26	XLI	XLI261009C00167500	call	167.5000	2026-10-09	4.5500	4.5500	4.9500	170.2550	10471.00	0.00	10471.00	23	14	26	0	0	0.183130593628344	0.183130593628344	true	false	false	true
37719b36-5905-437d-a9e1-85c0d1cedab0	2026-09-21 13:26	2026-09-21 13:26	2026-09-21 13:26	XLI	XLI261009C00172000	call	172.0000	2026-10-09	1.9500	1.9100	2.1800	170.2432	13265.00	192.00	13073.00	68	22	80	172	0.465116279069767	0.171256921400555	0.169563725145637	true	false	false	true
854143cc-2dbc-4a79-ad7d-4808f82c5457	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLI	XLI261009P00169000	put	169.0000	2026-10-09	2.1000	2.0200	2.1500	169.6700	19995.00	9939.00	10056.00	95	16	105	72	1.45833333333333	0.175127342018328	0.177211457395583	true	false	false	true
71d03c56-4f24-4180-a6e1-5a0b59206e28	2026-09-22 12:40	2026-09-22 12:40	2026-09-22 12:40	XLI	XLI261120C00180000	call	180.0000	2026-11-20	1.8900	1.8900	1.9300	169.9300	24030.00	0.00	24030.00	127	32	208	981	0.212028542303772	0.184567619655384	0.184567619655384	false	false	false	true
4e2e17ea-64ca-470b-be13-2d376bd0fa02	2026-09-22 13:02	2026-09-22 13:02	2026-09-22 13:02	XLI	XLI280121C00175000	call	175.0000	2028-01-21	18.0700	17.8500	18.5500	169.0000	16265.00	3630.00	12635.00	9	7	9	244	0.0368852459016393	0.193914861634679	0.197543115261176	false	false	false	true
16bc3fb9-187c-400b-978d-d8f0e7169b31	2026-09-22 15:54	2026-09-22 15:54	2026-09-22 15:54	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0500	1.0000	1.0600	170.0000	65238.00	40798.00	24336.00	624	24	6638	9324	0.711926211926212	0.230959995610697	0.231705557974733	false	false	false	true
6dffe419-751d-444b-913d-961c553a1bcb	2026-09-23 10:34	2026-09-23 10:34	2026-09-23 10:34	XLI	XLI261120P00172000	put	172.0000	2026-11-20	5.4200	5.3000	5.7000	170.7500	13560.00	6540.00	5940.00	25	11	35	16	2.1875	0.196325691800477	0.198167807418843	true	false	false	true
69a91dcd-0121-4be5-8c67-21d4fdeb04bb	2026-09-23 11:04	2026-09-23 11:04	2026-09-23 11:04	XLI	XLI261120C00175000	call	175.0000	2026-11-20	3.7100	3.6000	4.1000	170.4500	16310.00	375.00	15565.00	44	12	51	501	0.101796407185629	0.19113986777229	0.19113986777229	true	false	false	true
b21272c1-0fa2-427f-8efa-1844e97cf267	2026-09-23 12:59	2026-09-23 12:59	2026-09-23 12:59	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6900	2.5700	2.7600	170.6250	167955.00	167955.00	0.00	625	6	3712	10591	0.350486261920499	0.202212671144526	0.202212671144526	false	false	false	true
f66c252b-ab26-43d7-8a4d-2e0758336d26	2026-09-23 13:20	2026-09-23 13:20	2026-09-23 13:20	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6700	2.6300	2.6700	170.0000	80325.00	76629.00	3696.00	301	42	6031	10591	0.569445755830422	0.200947487275274	0.202226910714803	false	false	false	true
bc5e75b4-dbf5-4267-83a8-bcfc73183c5d	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.0000	3.1500	169.1650	67407.00	305.00	67102.00	221	47	706	14055	0.0502312344361437	0.200075512133163	0.200075512133163	false	false	false	true
77f77981-beb5-4d71-a2d3-005a34d466bc	2026-09-24 10:53	2026-09-24 10:52	2026-09-24 10:52	XLI	XLI261016C00173000	call	173.0000	2026-10-16	1.4700	1.4000	1.8000	168.8450	15243.00	588.00	14655.00	104	22	105	1547	0.0678733031674208	0.177155706285693	0.177834529088559	false	false	false	true
47c6457a-d2b6-435f-8aff-b685962bd130	2026-09-24 10:59	2026-09-24 10:58	2026-09-24 10:58	XLI	XLI261016C00170000	call	170.0000	2026-10-16	2.5400	2.5400	2.7200	168.6900	18290.00	0.00	18290.00	72	24	194	754	0.257294429708223	0.179238839062218	0.179238839062218	false	false	false	true
8612d32b-b058-45a1-a169-3b9bb0b54671	2026-09-24 11:10	2026-09-24 11:09	2026-09-24 11:09	XLI	XLI261120P00169000	put	169.0000	2026-11-20	4.8600	4.8000	4.9000	168.0000	58833.00	43313.00	0.00	121	7	217	844	0.257109004739337	0.198023530820969	0.198023530820969	false	false	false	true
1849865c-8460-424e-a13e-123d3c0ff8cd	2026-09-24 11:31	2026-09-24 11:31	2026-09-24 11:31	XLI	XLI261120C00175000	call	175.0000	2026-11-20	2.9300	2.9000	3.0000	168.4200	31598.00	15868.00	15730.00	108	10	163	495	0.329292929292929	0.192836675336657	0.193241544428233	true	false	false	true
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