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:endpoint = /api/option-trades/flow-alerts×ticker = XLF×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

59c2470a-0871-4067-83a6-74a061716fcb	2026-09-23 14:38	2026-09-23 14:38	2026-09-23 14:38	XLF	XLF270115C00058000	call	58.0000	2027-01-15	0.9400	0.9100	0.9400	54.6600	35250.00	35250.00	0.00	375	28	1082	13423	0.0806079117931908	0.157561375597269	0.157561375597269	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	51561995189.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T18:40:32.778143Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
48917e64-691a-4334-b583-62e4828dd03d	2026-09-23 14:01	2026-09-23 14:01	2026-09-23 14:01	XLF	XLF270115C00060000	call	60.0000	2027-01-15	0.5300	0.5000	0.5400	54.8100	15953.00	15953.00	0.00	301	25	345	88976	0.00387745009890308	0.158059723257038	0.158059723257038	false	false	false	true
244589d6-ba8b-431e-aa1a-ed0a6e066bb1	2026-09-23 14:01	2026-09-23 14:01	2026-09-23 14:01	XLF	XLF270115C00056000	call	56.0000	2027-01-15	1.7400	1.6800	1.7400	54.8100	64902.00	64902.00	0.00	373	31	1977	5185	0.38129218900675	0.159520143227927	0.159520143227927	false	false	false	true
b06e64df-859f-4cbc-b334-ae3445a48e3e	2026-09-23 13:49	2026-09-23 13:49	2026-09-23 13:49	XLF	XLF260923P00055500	put	55.5000	2026-09-23	0.7000	0.7000	0.7500	54.7850	16380.00	0.00	16380.00	234	25	2480	16458	0.150686596184227	0.69760594646765	0.69760594646765	false	false	false	true
3d568c0b-efa5-4625-9670-c1c5a69e48a4	2026-09-23 13:49	2026-09-23 13:49	2026-09-23 13:49	XLF	XLF260923P00055500	put	55.5000	2026-09-23	0.7000	0.7000	0.7500	54.7850	37940.00	0.00	37940.00	542	34	2246	16458	0.136468586705554	0.69751762652183	0.69751762652183	false	false	false	true
8cfc1476-8043-452e-b9c4-64a3f75cc7d4	2026-09-23 13:49	2026-09-23 13:49	2026-09-23 13:49	XLF	XLF260923P00055500	put	55.5000	2026-09-23	0.7000	0.7000	0.7500	54.7850	67270.00	0.00	67270.00	961	40	1704	16458	0.103536274152388	0.6974734792613	0.6974734792613	false	false	false	true
e323fae5-8e0b-4c9b-b800-9b07963597f3	2026-09-23 13:37	2026-09-23 13:37	2026-09-23 13:37	XLF	XLF261218C00058000	call	58.0000	2026-12-18	0.7300	0.7100	0.7300	54.7750	51757.00	51757.00	0.00	709	22	1238	23122	0.0535420811348499	0.160875931397932	0.160875931397932	false	false	false	true
5e2d10cb-504c-487d-b2eb-b85ca1da5605	2026-09-23 13:17	2026-09-23 13:17	2026-09-23 13:17	XLF	XLF261016C00058000	call	58.0000	2026-10-16	0.1000	0.1000	0.1100	54.0000	11770.00	0.00	11770.00	1177	28	1363	37576	0.0362731530764318	0.164759872653898	0.164759872653898	false	false	false	true
c4513fd7-5f94-4775-9ccf-b24526af3305	2026-09-23 13:16	2026-09-23 13:16	2026-09-23 13:16	XLF	XLF270115C00058000	call	58.0000	2027-01-15	0.9600	0.9200	0.9600	54.0000	62112.00	62112.00	0.00	647	25	701	13423	0.0522237949787678	0.156176486920181	0.156176486920181	false	false	false	true
bff1cae9-bc8f-4999-8a97-4a5d622c307f	2026-09-23 13:16	2026-09-23 13:16	2026-09-23 13:16	XLF	XLF270115C00057000	call	57.0000	2027-01-15	1.2900	1.2300	1.2900	54.0000	242907.00	242907.00	0.00	1883	45	2166	18081	0.119794259167081	0.156778937088858	0.156778937088858	false	false	false	true
690baa0e-d4e5-4821-a533-7af6ac3ef74f	2026-09-23 13:13	2026-09-23 13:13	2026-09-23 13:13	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.2400	1.2400	1.3200	54.0000	310066.00	0.00	310066.00	2500	44	21379	20012	1.06830901459125	1.05103768223835	1.05103768223835	false	false	false	true
e0568ccb-8ceb-4275-85c5-4c4e68b3fb03	2026-09-23 13:12	2026-09-23 13:12	2026-09-23 13:12	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.2600	1.1700	1.3200	54.0000	199584.00	18900.00	180684.00	1584	28	17963	20012	0.897611433140116	0.360758864632218	0.996945774907823	true	false	false	true
dca320d8-7772-41cf-a5a2-c7d834a119b9	2026-09-23 12:50	2026-09-23 12:50	2026-09-23 12:50	XLF	XLF270115C00056000	call	56.0000	2027-01-15	1.7000	1.6600	1.7100	54.7750	217940.00	213520.00	4420.00	1282	65	1604	5185	0.309353905496625	0.157616916239137	0.157616916239137	false	false	false	true
e7b5db5b-15da-49f7-8360-003bb12f27a8	2026-09-23 12:22	2026-09-23 12:22	2026-09-23 12:22	XLF	XLF261016C00057000	call	57.0000	2026-10-16	0.2100	0.2000	0.2100	54.7750	14070.00	14070.00	0.00	670	11	861	45068	0.0191044643649596	0.159079230895536	0.159079230895536	false	false	false	true
ba4702cf-969c-4db7-8bef-cb3b543cae1f	2026-09-23 12:22	2026-09-23 12:22	2026-09-23 12:22	XLF	XLF261016C00055500	call	55.5000	2026-10-16	0.6200	0.6000	0.6200	54.7750	28768.00	28768.00	0.00	464	11	527	2878	0.183113273106324	0.160007920324898	0.160007920324898	false	false	false	true
84057e2c-7cb0-4c3b-9515-489fa085d4b3	2026-09-23 11:27	2026-09-23 11:27	2026-09-23 11:27	XLF	XLF270617P00052000	put	52.0000	2027-06-17	1.8200	1.8200	1.8800	54.7850	12012.00	0.00	12012.00	66	8	106	2003	0.0529206190713929	0.201961723223747	0.201961723223747	false	false	false	true
cfba7f89-fdf2-4e60-892c-14c675d68db9	2026-09-23 11:26	2026-09-23 11:26	2026-09-23 11:26	XLF	XLF261016C00055000	call	55.0000	2026-10-16	0.8700	0.8400	0.8700	54.8250	10875.00	10875.00	0.00	125	5	548	34513	0.0158780749282879	0.161812694637519	0.161812694637519	false	false	false	true
94c7a918-efe8-489b-a92f-438e46b934eb	2026-09-23 11:26	2026-09-23 11:26	2026-09-23 11:26	XLF	XLF261016C00055000	call	55.0000	2026-10-16	0.8700	0.8400	0.8800	54.8250	10875.00	2175.00	8700.00	125	5	423	34513	0.0122562512676383	0.161812694637519	0.161812694637519	false	false	false	true
6f11b1df-a8f0-4bbd-b37d-63463ccbd5e8	2026-09-23 11:24	2026-09-23 11:24	2026-09-23 11:24	XLF	XLF261016C00055000	call	55.0000	2026-10-16	0.8600	0.8400	0.8700	54.8050	21500.00	13846.00	7654.00	250	10	298	34513	0.00863442760698867	0.161811165918782	0.161811165918782	false	false	false	true
ff863131-f700-4f28-ae9f-53f1b919d6bb	2026-09-23 11:23	2026-09-23 11:23	2026-09-23 11:23	XLF	XLF261016C00056000	call	56.0000	2026-10-16	0.4500	0.4200	0.4600	54.8100	11255.00	11255.00	0.00	250	7	584	18378	0.0317771248231581	0.160264669218188	0.158244377385567	false	false	false	true
c6918a30-aa23-4bfa-94c2-f860377d9f50	2026-09-23 11:22	2026-09-23 11:22	2026-09-23 11:22	XLF	XLF261016P00054000	put	54.0000	2026-10-16	0.5200	0.4900	0.5200	54.8050	86372.00	86372.00	0.00	1661	50	2111	43897	0.0480898466865617	0.168009976069309	0.168009976069309	false	false	false	true
a6bc36b8-131f-4d72-a397-50c18c96f606	2026-09-23 11:12	2026-09-23 11:12	2026-09-23 11:12	XLF	XLF260925C00055000	call	55.0000	2026-09-25	0.2300	0.2000	0.2500	54.8150	21505.00	391.00	21114.00	935	18	5123	1413	3.62561924982307	0.190488146310294	0.190488146310294	true	false	false	true
37de9d20-08b8-43ff-add5-de683cfa7909	2026-09-23 11:12	2026-09-23 11:12	2026-09-23 11:12	XLF	XLF260925C00055000	call	55.0000	2026-09-25	0.2300	0.2300	0.2700	54.8150	24702.00	0.00	24702.00	1074	47	4188	1413	2.96390658174098	0.190488146310294	0.190488146310294	true	false	false	true
ac0a9d38-f888-4b34-902c-6883ed33abe6	2026-09-23 11:04	2026-09-23 11:04	2026-09-23 11:04	XLF	XLF260925C00055000	call	55.0000	2026-09-25	0.2500	0.2400	0.2600	54.8150	12300.00	5725.00	5175.00	492	13	2554	1413	1.80750176928521	0.203116694061935	0.203116694061935	true	false	false	true
305c66dd-53d5-479c-84eb-4dc5ad68ee61	2026-09-23 11:04	2026-09-23 11:04	2026-09-23 11:04	XLF	XLF260925C00055000	call	55.0000	2026-09-25	0.2500	0.2400	0.2500	54.8150	32550.00	32550.00	0.00	1302	19	1807	1413	1.27883934890304	0.203116694061935	0.203116694061935	true	false	false	true
a97d43fc-df31-4ca5-8d1e-b574bc588753	2026-09-23 11:01	2026-09-23 11:01	2026-09-23 11:01	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.1600	1.1600	1.2200	54.8000	115768.00	0.00	115768.00	998	27	12375	20012	0.61837897261643	0.59271869297997	0.59271869297997	false	false	false	true
6752965b-9f00-4ea5-9067-6b599b548932	2026-09-23 10:50	2026-09-23 10:50	2026-09-23 10:50	XLF	XLF261016P00055000	put	55.0000	2026-10-16	0.8500	0.8100	0.8500	54.9300	94520.00	94520.00	0.00	1112	27	1431	40940	0.0349535906204201	0.160681937433663	0.160681937433663	false	false	false	true
2ae1ca9b-e3c8-4110-bfed-1b2b50165a2e	2026-09-23 10:45	2026-09-23 10:45	2026-09-23 10:45	XLF	XLF261023C00055500	call	55.5000	2026-10-23	0.8200	0.7900	0.8200	54.9350	88724.00	88724.00	0.00	1082	38	2275	125	18.2	0.158677308736073	0.158677308736073	false	false	false	true
af5eb576-3e32-4a6f-af4a-0f2a9b4d1a18	2026-09-23 10:39	2026-09-23 10:38	2026-09-23 10:38	XLF	XLF261023C00055500	call	55.5000	2026-10-23	0.8500	0.8300	0.8500	54.9999	30175.00	30175.00	0.00	355	17	796	125	6.368	0.159129576137604	0.158770741833665	false	false	false	true
e2f09ae3-3412-42d3-b1fa-66d4c85c22c0	2026-09-23 10:38	2026-09-23 10:38	2026-09-23 10:38	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.9700	0.9700	1.0700	55.0050	242500.00	0.00	242500.00	2500	6	11375	20012	0.568408954627224	0.704604136045605	0.704604136045605	false	false	false	true
d20ada76-545a-45ff-9f1a-8fa1be00067b	2026-09-23 10:38	2026-09-23 10:38	2026-09-23 10:38	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.9600	0.9600	1.0100	55.0150	160512.00	0.00	160512.00	1672	34	8875	20012	0.443483909654207	0.514546912008804	0.514546912008804	false	false	false	true
4ac98b55-1c0e-4f4e-90c0-8ea0d5e7ffcc	2026-09-23 10:38	2026-09-23 10:38	2026-09-23 10:38	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.9600	0.9300	0.9600	55.0100	31488.00	31488.00	0.00	328	6	7203	20012	0.359934039576254	0.449115611559019	0.449115611559019	true	false	false	true
bd9666bc-2efc-46e7-a8e2-5aa3ecd606e3	2026-09-23 10:37	2026-09-23 10:37	2026-09-23 10:37	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.9400	0.8700	0.9400	55.0450	38634.00	38634.00	0.00	411	5	6804	20012	0.339996002398561	0.427387072149694	0.427387072149694	true	false	false	true
ca97ef1e-62bc-4da7-b386-3cd8509a5df6	2026-09-23 10:34	2026-09-23 10:34	2026-09-23 10:34	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1000	0.1000	0.1100	55.0150	10370.00	0.00	10370.00	1037	16	17062	74555	0.228851183689893	0.318516957548924	0.318516957548924	false	false	false	true
0f343cd1-f8af-4fd3-a920-8d8ec83e33f8	2026-09-23 10:34	2026-09-23 10:34	2026-09-23 10:34	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.9700	0.9700	1.0100	55.0200	121056.00	0.00	121056.00	1248	31	6375	20012	0.318558864681191	0.532105563403244	0.532105563403244	false	false	false	true
1e9380f9-27b7-4cad-8118-c215e1d899d2	2026-09-23 10:34	2026-09-23 10:33	2026-09-23 10:33	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1000	0.1000	0.1200	55.0150	32190.00	0.00	32190.00	3219	20	15463	74555	0.207403929984575	0.318516957548924	0.318516957548924	false	false	false	true
06cf4f6b-c911-4e9f-bf96-b697ba32ac70	2026-09-23 10:33	2026-09-23 10:33	2026-09-23 10:33	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.9600	0.9200	0.9600	55.0200	54624.00	43296.00	0.00	569	13	4815	20012	0.240605636618029	0.51612060024984	0.51612060024984	true	false	false	true
fc797502-1417-4086-b487-51cc7746de5e	2026-09-23 10:33	2026-09-23 10:33	2026-09-23 10:33	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1000	0.1000	0.1200	55.0250	40110.00	0.00	40110.00	4011	30	11501	74555	0.154261954261954	0.31865636328447	0.31865636328447	false	false	false	true
31e95b35-7408-4ada-a11d-1b0c3a692883	2026-09-23 10:33	2026-09-23 10:33	2026-09-23 10:33	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1000	0.1000	0.1200	55.0300	11200.00	0.00	11200.00	1120	35	7490	74555	0.100462745624036	0.318726051835253	0.318726051835253	false	false	false	true
f00127b3-60f9-4d02-9257-bb43fbdbeef6	2026-09-23 10:28	2026-09-23 10:28	2026-09-23 10:28	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.0400	1.0400	1.0500	54.9350	44616.00	0.00	44616.00	429	8	4174	20012	0.208574855086948	0.263442926253347	0.263442926253347	false	false	false	true
82d7034d-3694-4b00-aec3-34da5ae98455	2026-09-23 10:28	2026-09-23 10:28	2026-09-23 10:28	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.0400	1.0400	1.0500	54.9350	35794.00	1890.00	33904.00	344	12	3745	20012	0.187137717369578	0.263442926253347	0.263442926253347	false	false	false	true
f7d55a51-e0d8-43a7-b993-45f5fb17a5fc	2026-09-23 10:28	2026-09-23 10:28	2026-09-23 10:28	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.0500	1.0400	1.0600	54.9400	73290.00	67830.00	0.00	698	20	2784	20012	0.139116530081951	0.263442926253347	0.322671826716728	true	false	false	true
aeb56c76-f5b9-4089-851d-0192c01db842	2026-09-23 10:28	2026-09-23 10:28	2026-09-23 10:28	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.0400	1.0400	1.0500	54.9420	35360.00	0.00	35360.00	340	29	2086	20012	0.104237457525485	0.263442926253347	0.263442926253347	false	false	false	true
fbdae3f8-79ff-45ba-95b8-2f5fffa02c01	2026-09-23 10:28	2026-09-23 10:28	2026-09-23 10:28	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.0400	0.9300	1.0500	54.9500	38584.00	38376.00	0.00	371	8	1746	20012	0.0872476514091545	0.263442926253347	0.263442926253347	false	false	false	true
52cd945d-9737-4d84-bce3-23f305779af7	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	XLF	XLF261023C00055000	call	55.0000	2026-10-23	1.1100	1.1000	1.1800	54.0000	14652.00	0.00	14652.00	132	18	311	24	12.9583333333333	0.163582528284828	0.163804198735073	false	false	false	true
1fbbb812-17f5-495d-85ee-c8ef3bafe4fb	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	XLF	XLF261023C00055000	call	55.0000	2026-10-23	1.1100	1.1100	1.1800	54.0000	15984.00	0.00	15984.00	144	8	179	24	7.45833333333333	0.163377745270107	0.163377745270107	false	false	false	true
16b67d3c-25c8-48c8-9e0a-d28fbff2843b	2026-09-23 10:23	2026-09-23 10:22	2026-09-23 10:22	XLF	XLF261218C00058000	call	58.0000	2026-12-18	0.7800	0.7200	0.7800	55.0450	34710.00	34710.00	0.00	445	17	483	23122	0.0208891964362944	0.157682674065228	0.157682674065228	false	false	false	true
9097ca2b-3eb0-4d37-83ca-0c628c68fd94	2026-09-23 10:22	2026-09-23 10:22	2026-09-23 10:22	XLF	XLF260923C00055000	call	55.0000	2026-09-23	0.1600	0.1600	0.1800	55.0150	40528.00	0.00	40528.00	2533	43	4256	3262	1.30472103004292	0.272687424370823	0.272687424370823	false	false	false	true
2ddb39e7-0e84-4e0e-935a-770fc9f85478	2026-09-23 10:22	2026-09-23 10:22	2026-09-23 10:22	XLF	XLF261120C00058000	call	58.0000	2026-11-20	0.4800	0.4700	0.5200	55.0250	149952.00	576.00	149376.00	3124	37	3265	13806	0.236491380559177	0.158144557484944	0.158144557484944	false	false	false	true
a692076b-7775-47e0-9c32-501a116cd61c	2026-09-23 10:21	2026-09-23 10:21	2026-09-23 10:21	XLF	XLF261030P00054000	put	54.0000	2026-10-30	0.6800	0.6800	0.7500	55.0250	16796.00	0.00	16796.00	247	10	248	268	0.925373134328358	0.174059616286935	0.174059616286935	false	false	false	true