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: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	price

a3173357-ee3a-45bd-afc7-900b00f5f177	2026-08-25 14:12	2026-08-25 14:12	2026-08-25 14:12	XLI	XLI260904C00175000	call	175.0000	2026-09-04	4.3000	4.1000	4.3500	178.0000	18060.00	17630.00	0.00	42	15	42	2	21	0.177795005474505	0.177795005474505	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30796170295.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e15fd55b-80b7-4b19-9d6a-10b76bb6ca83	2026-08-25 15:12	2026-08-25 15:11	2026-08-25 15:11	XLI	XLI270115P00175000	put	175.0000	2027-01-15	6.2000	6.0500	6.2000	178.4400	27280.00	27280.00	0.00	44	7	44	1538	0.0286085825747724	0.204169043843481	0.204169043843481	true	false	false	true	false
85af0f7a-a567-49f5-b2d7-345ae03b859f	2026-08-25 15:12	2026-08-25 15:11	2026-08-25 15:11	XLI	XLI270115P00175000	put	175.0000	2027-01-15	6.2000	6.0500	6.2000	178.4250	27280.00	27280.00	0.00	44	5	88	1538	0.0572171651495449	0.204037928054123	0.204037928054123	true	false	false	true	false
1dcc57b2-34e9-4720-a68d-ab8fb505ac53	2026-08-26 10:03	2026-08-26 10:03	2026-08-26 10:03	XLI	XLI261218P00160000	put	160.0000	2026-12-18	1.6300	1.5300	1.6300	180.6599	25428.00	25428.00	0.00	156	26	157	3571	0.0439652758331	0.227888906543366	0.227888906543366	false	false	false	true	false
a512065b-9062-4798-852f-e2c7756765a3	2026-08-26 10:11	2026-08-26 10:11	2026-08-26 10:11	XLI	XLI260828C00183000	call	183.0000	2026-08-28	0.2900	0.1600	0.2900	180.8300	11890.00	11890.00	0.00	410	46	412	43	9.58139534883721	0.19004568231326	0.19004568231326	false	false	false	true	false
cb88976b-6b49-4604-9a4d-4c4f06b6a588	2026-08-26 10:26	2026-08-26 10:26	2026-08-26 10:26	XLI	XLI261218P00160000	put	160.0000	2026-12-18	1.6400	1.5200	1.6400	180.5600	11480.00	11480.00	0.00	70	22	227	3571	0.0635676281153739	0.227736120614155	0.227736120614155	false	false	false	true	false
8e2360e5-d041-404c-b645-e8da8dd812b7	2026-08-27 10:07	2026-08-27 10:07	2026-08-27 10:07	XLI	XLI260911P00178000	put	178.0000	2026-09-11	2.0200	1.8900	2.0200	178.2000	41208.00	41208.00	0.00	204	28	207	14	14.7857142857143	0.156395206856212	0.156395206856212	false	false	false	true	false
a0a527de-911f-4b09-a371-076c8f6599ca	2026-08-27 10:43	2026-08-27 10:43	2026-08-27 10:43	XLI	XLI260918C00185000	call	185.0000	2026-09-18	0.8000	0.7800	0.9100	178.8350	28080.00	4800.00	23280.00	351	41	405	3724	0.10875402792696	0.156004836096407	0.156004836096407	false	false	false	true	false
fd5dbe6b-9ecb-433d-b34f-39a4efc84a01	2026-08-27 10:46	2026-08-27 10:46	2026-08-27 10:46	XLI	XLI260918C00185000	call	185.0000	2026-09-18	0.8200	0.8100	0.9100	179.0923	52398.00	82.00	52316.00	639	53	1044	3724	0.280343716433942	0.153272865148145	0.153272865148145	false	false	false	true	false
3938d2e2-8f70-4a23-bbf7-23bcace4a12a	2026-08-27 11:06	2026-08-27 11:05	2026-08-27 11:05	XLI	XLI260828P00177000	put	177.0000	2026-08-28	0.2100	0.2100	0.2900	179.0600	14511.00	0.00	14511.00	691	20	713	166	4.29518072289157	0.238861189658682	0.238861189658682	false	false	false	true	false
8094ef31-1cd0-4d51-a71f-f88bf1a1af1a	2026-08-27 11:39	2026-08-27 11:39	2026-08-27 11:39	XLI	XLI260918C00184000	call	184.0000	2026-09-18	1.0100	1.0100	1.1300	179.0600	55550.00	0.00	55550.00	550	42	582	393	1.48091603053435	0.151279136067347	0.151279136067347	false	false	false	true	false
646b0972-319d-402d-b695-626bcd96c8f9	2026-08-27 12:10	2026-08-27 12:10	2026-08-27 12:10	XLI	XLI261016C00180000	call	180.0000	2026-10-16	4.4000	4.4000	4.7500	178.9600	17160.00	0.00	17160.00	39	13	45	70	0.642857142857143	0.168478402530532	0.168478402530532	false	false	false	true	false
2ac71948-ab8d-4894-a487-99524df17121	2026-08-27 12:18	2026-08-27 12:18	2026-08-27 12:18	XLI	XLI261120C00185000	call	185.0000	2026-11-20	4.1000	4.1000	4.3500	178.8600	130380.00	0.00	130380.00	318	36	319	2683	0.118896757361163	0.17451876866918	0.17451876866918	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
746fb205-b8ef-40dd-8daf-db40695935f1	2026-08-28 14:19	2026-08-28 14:18	2026-08-28 14:18	XLI	XLI280121P00150000	put	150.0000	2028-01-21	5.7500	5.3000	6.0500	177.1200	172500.00	172500.00	0.00	300	1	300	1150	0.260869565217391	0.245621943872663	0.245621943872663	false	true	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
7c78905c-7613-4a8e-8e40-5db3148a4df5	2026-08-31 14:59	2026-08-31 14:58	2026-08-31 14:58	XLI	XLI261120C00190000	call	190.0000	2026-11-20	1.4800	1.2800	1.5300	175.3250	193436.00	193436.00	0.00	1307	1	1320	3347	0.394383029578727	0.170325606123132	0.170325606123132	false	true	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false