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

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

2a3d3f5b-3c9d-4170-a5ba-c90d228dae2a	2026-09-21 14:40	2026-09-21 14:39	2026-09-21 14:39	XLF	XLF270319P00050000	put	50.0000	2027-03-19	0.7200	0.7200	0.7500	55.9450	21600.00	0.00	21600.00	300	27	755	57821	0.0130575396482247	0.205384342670749	0.205384342670749	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	52856627577.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T18:42:48.011261Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
24adc0ee-cea1-47de-87aa-712b649b3254	2026-09-21 14:28	2026-09-21 14:28	2026-09-21 14:28	XLF	XLF260925C00056000	call	56.0000	2026-09-25	0.3400	0.3200	0.3400	55.0000	27710.00	27710.00	0.00	815	6	5588	4662	1.1986271986272	0.15403474143878	0.15403474143878	false	false	false	true
7c1c9c8a-5f28-4f76-b1bb-a2349db8d981	2026-09-21 14:26	2026-09-21 14:26	2026-09-21 14:26	XLF	XLF270319P00050000	put	50.0000	2027-03-19	0.7200	0.7200	0.7400	55.9200	18360.00	0.00	18360.00	255	22	455	57821	0.00786911329793674	0.20496517004521	0.20496517004521	false	false	false	true
34bb34f3-d5c4-457f-b25f-c1c4c8455ba7	2026-09-21 14:19	2026-09-21 14:19	2026-09-21 14:19	XLF	XLF270617C00060000	call	60.0000	2027-06-17	2.1300	2.1100	2.1600	55.8750	20022.00	11076.00	8946.00	94	7	2050	3322	0.617098133654425	0.159236103770008	0.159236103770008	false	false	false	true
7785d693-70fc-412a-b7c6-9de92c7b82b5	2026-09-21 13:59	2026-09-21 13:59	2026-09-21 13:59	XLF	XLF261016P00056000	put	56.0000	2026-10-16	0.8500	0.8500	0.8700	55.9150	21250.00	0.00	21250.00	250	5	477	204319	0.00233458464459987	0.151373835525839	0.151373835525839	false	false	false	true
d6d3a53a-5411-480c-ad40-7223976c591d	2026-09-21 13:58	2026-09-21 13:58	2026-09-21 13:58	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1200	0.0800	0.1200	55.9000	72000.00	72000.00	0.00	6000	53	11000	58141	0.189195232280147	0.338570419084395	0.338570419084395	false	false	false	true
1b3c7654-fa0e-49f3-9ffa-6114646bd3e3	2026-09-21 13:58	2026-09-21 13:58	2026-09-21 13:58	XLF	XLF270115P00040000	put	40.0000	2027-01-15	0.1300	0.0800	0.1300	55.9050	65000.00	65000.00	0.00	5000	27	5000	58141	0.0859978328546121	0.343541961150162	0.343541961150162	false	false	false	true
32843b38-c1ff-4c4c-b43b-5de9ef853ec9	2026-09-21 13:27	2026-09-21 13:27	2026-09-21 13:27	XLF	XLF260924C00056000	call	56.0000	2026-09-24	0.3100	0.3100	0.3400	56.0050	14973.00	0.00	14973.00	483	10	517	180	2.87222222222222	0.147258374413534	0.147258374413534	false	false	false	true
9c744937-3284-496b-88ea-f56472ddf4ef	2026-09-21 13:01	2026-09-21 13:01	2026-09-21 13:01	XLF	XLF260930P00056000	put	56.0000	2026-09-30	0.4800	0.4800	0.5000	55.9450	24000.00	0.00	24000.00	500	22	4360	17055	0.255643506303137	0.136933096270355	0.136933096270355	false	false	false	true
f26b15f7-50e4-43ee-874a-d6079182f8bf	2026-09-21 13:00	2026-09-21 13:00	2026-09-21 13:00	XLF	XLF260930P00055000	put	55.0000	2026-09-30	0.1700	0.1700	0.1900	55.9450	15589.00	0.00	15589.00	917	20	2017	17793	0.113359186196819	0.151177209938275	0.151177209938275	false	false	false	true
56a425b1-b598-458a-aadd-371d283df7eb	2026-09-21 12:59	2026-09-21 12:59	2026-09-21 12:59	XLF	XLF270115C00053000	call	53.0000	2027-01-15	4.3500	4.1000	4.3500	55.9250	18270.00	18270.00	0.00	42	6	55	6794	0.00809537827494848	0.167573994343459	0.167573994343459	false	false	false	true
c273e2eb-6ae5-41bf-9dcd-a7527901f49c	2026-09-21 12:49	2026-09-21 12:49	2026-09-21 12:49	XLF	XLF261016C00057500	call	57.5000	2026-10-16	0.3500	0.3400	0.3500	55.9350	16555.00	16555.00	0.00	473	15	3109	0	0	0.148992367058099	0.148992367058099	false	false	false	true
53613c89-c957-45b5-9d11-77cfab50a4f8	2026-09-21 12:49	2026-09-21 12:49	2026-09-21 12:49	XLF	XLF261023C00058500	call	58.5000	2026-10-23	0.2200	0.2000	0.2300	55.9300	21560.00	21560.00	0.00	980	15	981	786	1.24809160305344	0.145202292366592	0.145202292366592	false	false	false	true
f5265cea-4050-469c-9d78-bb5651aca5f6	2026-09-21 12:27	2026-09-21 12:27	2026-09-21 12:27	XLF	XLF270319C00064000	call	64.0000	2027-03-19	0.4600	0.4400	0.4600	55.8750	10350.00	10350.00	0.00	225	12	710	673	1.05497771173848	0.153175451222146	0.153175451222146	false	false	false	true
047b3a84-184a-44e0-811c-a5bd030862c6	2026-09-21 12:25	2026-09-21 12:25	2026-09-21 12:25	XLF	XLF261016C00057000	call	57.0000	2026-10-16	0.4800	0.4700	0.4800	55.8650	34896.00	34896.00	0.00	727	21	862	41950	0.0205482717520858	0.150440581971211	0.150440581971211	false	false	false	true
473a3cd9-295e-447e-8771-48379c1bff55	2026-09-21 12:21	2026-09-21 12:21	2026-09-21 12:21	XLF	XLF270319C00064000	call	64.0000	2027-03-19	0.4700	0.4400	0.4700	55.8950	18330.00	18330.00	0.00	390	13	390	673	0.579494799405646	0.153913589857874	0.153913589857874	false	false	false	true
fc7a9fb1-6573-40c7-bca0-7e29af07b920	2026-09-21 12:10	2026-09-21 12:09	2026-09-21 12:09	XLF	XLF261016C00057500	call	57.5000	2026-10-16	0.3400	0.3300	0.3400	55.9250	17136.00	17136.00	0.00	504	18	2299	0	0	0.147465667532109	0.147465667532109	false	false	false	true
9995418a-6055-483b-874f-7311191f7f2d	2026-09-21 11:51	2026-09-21 11:51	2026-09-21 11:51	XLF	XLF261016C00057500	call	57.5000	2026-10-16	0.3300	0.3200	0.3300	55.8899	54054.00	54054.00	0.00	1638	15	1795	0	0	0.147293919621782	0.147293919621782	false	false	false	true
ff16d18e-50fb-4a04-a34b-e14a279705a1	2026-09-21 11:46	2026-09-21 11:46	2026-09-21 11:46	XLF	XLF270115C00055000	call	55.0000	2027-01-15	2.8900	2.7900	2.8900	55.9050	15606.00	15606.00	0.00	54	5	82	83753	0.000979069406469022	0.158366110208936	0.158366110208936	false	false	false	true
39cc1249-677d-4337-b913-caca66bfc7c8	2026-09-21 10:42	2026-09-21 10:42	2026-09-21 10:42	XLF	XLF270115C00065000	call	65.0000	2027-01-15	0.1600	0.1500	0.1600	55.8950	16000.00	16000.00	0.00	1000	24	1111	44764	0.0248190510231436	0.162380925095216	0.162380925095216	true	false	false	true
cc831165-3dce-4e3a-a340-44caddb89262	2026-09-21 10:40	2026-09-21 10:40	2026-09-21 10:40	XLF	XLF270917P00045000	put	45.0000	2027-09-17	0.8800	0.8400	0.9100	55.8600	16016.00	16016.00	0.00	182	6	995	0	0	0.245918064520024	0.245918064520024	false	false	false	true
55ccb097-1f9c-43fd-b817-73fde54facea	2026-09-18 14:21	2026-09-18 14:21	2026-09-18 14:21	XLF	XLF260925C00056000	call	56.0000	2026-09-25	0.2900	0.2700	0.2900	55.8950	73863.00	73863.00	0.00	2547	10	3166	374	8.46524064171123	0.103640322413757	0.103640322413757	false	false	false	true
8dd7e764-4575-4ab9-ac8f-87c9ca1c7cfb	2026-09-18 14:03	2026-09-18 14:03	2026-09-18 14:03	XLF	XLF261120P00053000	put	53.0000	2026-11-20	0.5500	0.5500	0.5800	55.8600	107690.00	0.00	107690.00	1958	5	1962	17866	0.10981753050487	0.189196242547378	0.189196242547378	false	false	false	true
22d17433-1220-4036-b7df-ab56eb6138a7	2026-09-18 13:43	2026-09-18 13:43	2026-09-18 13:43	XLF	XLF261120C00055000	call	55.0000	2026-11-20	2.0800	2.0700	2.1700	55.8200	65936.00	0.00	64688.00	317	10	325	642	0.506230529595016	0.152172634791523	0.152172634791523	true	false	false	true
85737fe1-de54-496d-9b5c-a9345142975c	2026-09-18 10:39	2026-09-18 10:39	2026-09-18 10:39	XLF	XLF261016C00057000	call	57.0000	2026-10-16	0.4200	0.4100	0.4200	55.7500	108150.00	108150.00	0.00	2575	9	3640	40529	0.0898122332157221	0.13705388730061	0.13705388730061	false	false	false	true
e7cf194b-b63c-4782-8020-98236cea0eb0	2026-09-18 10:33	2026-09-18 10:33	2026-09-18 10:33	XLF	XLF261016P00055000	put	55.0000	2026-10-16	0.6400	0.6200	0.6500	55.7800	81344.00	81280.00	0.00	1271	31	1300	42388	0.0306690572803624	0.171201074349454	0.171201074349454	false	false	false	true
ddadfde0-0d02-4e82-9f7b-3feb938579fc	2026-09-18 10:31	2026-09-18 10:31	2026-09-18 10:31	XLF	XLF281215P00060000	put	60.0000	2028-12-15	6.5000	6.5000	6.8500	55.8200	111800.00	0.00	111800.00	172	20	172	327	0.525993883792049	0.225315092310067	0.225315092310067	false	false	false	true
07c44ef2-c434-4f38-b55c-4947ffeb1b88	2026-09-18 10:31	2026-09-18 10:31	2026-09-18 10:31	XLF	XLF281215C00061000	call	61.0000	2028-12-15	5.7500	5.5000	5.7500	55.8150	70150.00	70150.00	0.00	122	9	122	211	0.578199052132701	0.160449588609179	0.160449588609179	false	false	false	true
28d369fe-3c22-4002-93f4-75c30454efe8	2026-09-18 10:29	2026-09-18 10:29	2026-09-18 10:29	XLF	XLF261016P00056000	put	56.0000	2026-10-16	1.0700	1.0500	1.0700	55.7750	97905.00	97905.00	0.00	915	27	1171	203488	0.0057546390941972	0.169077284204442	0.169077284204442	false	false	false	true
55690109-d1b5-408a-be32-06d00cf48b1e	2026-09-18 09:49	2026-09-18 09:49	2026-09-18 09:49	XLF	XLF260930P00055000	put	55.0000	2026-09-30	0.3700	0.3600	0.4300	55.6114	99678.00	1628.00	98013.00	2694	80	4484	19093	0.234850468758184	0.164024498723923	0.164024498723923	true	false	false	true
97848e45-614a-4ebd-af53-8bbb711cc265	2026-09-18 09:49	2026-09-18 09:48	2026-09-18 09:48	XLF	XLF260930P00055000	put	55.0000	2026-09-30	0.3800	0.3500	0.4100	55.6150	66652.00	2812.00	63840.00	1754	33	1754	19093	0.0918661289477819	0.167076496219707	0.167076496219707	true	false	false	true
e553f2eb-6efe-4440-bef9-0b170265666f	2026-09-17 14:52	2026-09-17 14:52	2026-09-17 14:52	XLF	XLF261009C00055500	call	55.5000	2026-10-09	1.0500	1.0500	1.1300	55.9750	50400.00	0.00	50400.00	480	7	500	96	5.20833333333333	0.12932470430003	0.12932470430003	false	false	false	true
3d3fd7e0-a201-4287-9b63-475ed5ba1588	2026-09-17 12:12	2026-09-17 12:11	2026-09-17 12:11	XLF	XLF260918C00056000	call	56.0000	2026-09-18	0.2200	0.2200	0.2600	56.0150	53064.00	0.00	53064.00	2412	11	8640	29999	0.288009600320011	0.178966219342317	0.178966219342317	true	false	false	true
64e94dad-16fb-4a7d-a5dc-93ce1205112c	2026-09-17 12:03	2026-09-17 12:03	2026-09-17 12:03	XLF	XLF260930P00057000	put	57.0000	2026-09-30	1.3000	1.3000	1.3300	56.0250	64871.00	0.00	64871.00	499	16	512	1183	0.43279797125951	0.181478873243007	0.181478873243007	true	false	false	true
c44e1576-95cd-4753-a3cc-e7346e87ca0a	2026-09-17 11:42	2026-09-17 11:42	2026-09-17 11:42	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2600	0.2500	0.2800	55.9550	53274.00	0.00	50206.00	2049	16	25761	33196	0.77602723219665	0.203655454732932	0.203655454732932	false	false	false	true
7c34a916-5283-4db4-a3bd-3bc7d398588a	2026-09-17 11:15	2026-09-17 11:14	2026-09-17 11:14	XLF	XLF270630C00058000	call	58.0000	2027-06-30	2.9500	2.9100	2.9500	55.8050	329515.00	314765.00	0.00	1117	16	2055	2070	0.992753623188406	0.154734067377586	0.154734067377586	true	false	false	true
d8aae814-5e07-4dcf-819f-ad15b233a015	2026-09-17 11:14	2026-09-17 11:14	2026-09-17 11:14	XLF	XLF270630C00058000	call	58.0000	2027-06-30	2.9500	2.9000	3.1000	55.8000	247210.00	217415.00	29795.00	838	13	838	2070	0.404830917874396	0.154865202005154	0.154865202005154	true	false	false	true
e61e2508-40e7-4969-aa97-3d82f6d7c431	2026-09-17 10:48	2026-09-17 10:48	2026-09-17 10:48	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2800	0.2800	0.2900	55.7350	56000.00	0.00	56000.00	2000	52	23707	33196	0.714152307506929	0.199774141712288	0.199774141712288	false	false	false	true
2de65098-fc97-41df-9255-6ff2637d4faa	2026-09-17 10:20	2026-09-17 10:20	2026-09-17 10:20	XLF	XLF260918C00056000	call	56.0000	2026-09-18	0.1500	0.1400	0.1600	55.7150	54315.00	54300.00	15.00	3621	16	4013	29999	0.13377112570419	0.228555364187611	0.228555364187611	false	false	false	true
1f23fb5e-80f7-4507-ad5b-56f3cca4e0e6	2026-09-17 09:31	2026-09-17 09:31	2026-09-17 09:31	XLF	XLF261016C00057000	call	57.0000	2026-10-16	0.6300	0.5800	0.8100	56.1650	151074.00	819.00	150255.00	2398	53	2398	37173	0.0645091867753477	0.144997001449058	0.144997001449058	false	false	false	true
523b0212-8bad-42e9-b14b-89506c5b77b2	2026-09-16 15:41	2026-09-16 15:41	2026-09-16 15:41	XLF	XLF270319P00057000	put	57.0000	2027-03-19	3.0000	3.0000	3.1000	55.6950	120000.00	0.00	120000.00	400	10	559	6372	0.0877275580665411	0.188383589800152	0.188383589800152	false	false	false	true
ed8500a7-cbe6-44df-8b45-8fd55dc72cb8	2026-09-16 15:36	2026-09-16 15:35	2026-09-16 15:35	XLF	XLF261120P00054000	put	54.0000	2026-11-20	0.9400	0.9400	0.9900	55.6950	424598.00	0.00	424598.00	4517	59	4700	21456	0.219052945563013	0.195098947587845	0.195098947587845	false	false	false	true
ca330c93-47f0-4441-a926-8db95267b556	2026-09-16 15:36	2026-09-16 15:35	2026-09-16 15:35	XLF	XLF261023P00056000	put	56.0000	2026-10-23	1.3400	1.3400	1.4300	55.6950	72494.00	0.00	72494.00	541	32	545	94	5.79787234042553	0.18397227791121	0.18397227791121	false	false	false	true
9ffa0095-d32b-40c7-ae0a-5673615522dd	2026-09-16 15:35	2026-09-16 15:35	2026-09-16 15:35	XLF	XLF261009P00055000	put	55.0000	2026-10-09	0.6900	0.6800	0.7800	55.6959	144278.00	0.00	144278.00	2091	41	2102	512	4.10546875	0.190724866843571	0.188539294057472	true	false	false	true
32ab9408-a5b8-472b-8a73-9d720f82f335	2026-09-16 15:22	2026-09-16 15:22	2026-09-16 15:22	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3800	0.3600	0.3800	55.4750	144438.00	144438.00	0.00	3801	43	7131	28490	0.25029835029835	0.209180336575969	0.209180336575969	false	false	false	true
dbb4d974-afc8-4cfb-9471-cfaed4eedeb8	2026-09-16 15:21	2026-09-16 15:21	2026-09-16 15:21	XLF	XLF260916P00055500	put	55.5000	2026-09-16	0.1700	0.1500	0.1800	55.5050	59058.00	58429.00	612.00	3474	77	5750	417	13.78896882494	0.909830230250232	0.909830230250232	false	false	false	true
d149eea5-51da-4e36-847d-4b489dd14819	2026-09-16 15:08	2026-09-16 15:08	2026-09-16 15:08	XLF	XLF270319P00058000	put	58.0000	2027-03-19	3.5000	3.4500	3.5000	55.8000	65450.00	65450.00	0.00	187	8	1589	10859	0.146330232986463	0.189295836511298	0.189130401204834	false	false	false	true
b109612e-6fce-476a-b463-0af849b821ce	2026-09-16 14:30	2026-09-16 14:30	2026-09-16 14:30	XLF	XLF270617P00054000	put	54.0000	2027-06-17	2.0700	1.9900	2.1800	56.3800	1035000.00	196650.00	838350.00	5000	22	5010	15534	0.322518346852066	0.201794877922987	0.201794877922987	true	false	false	true
8e1e50ca-8331-4b11-b68f-34b1a1a559fb	2026-09-16 10:40	2026-09-16 10:39	2026-09-16 10:39	XLF	XLF261016C00058000	call	58.0000	2026-10-16	0.4800	0.4700	0.4800	56.6400	146544.00	146544.00	0.00	3053	13	5254	32880	0.159793187347932	0.145765102372176	0.145765102372176	false	false	false	true
58f51ace-56d3-47f8-adb7-c9382b2107a7	2026-09-16 10:17	2026-09-16 10:17	2026-09-16 10:17	XLF	XLF261016P00056000	put	56.0000	2026-10-16	0.8300	0.8100	0.8400	56.0000	329427.00	216879.00	0.00	3969	27	4717	203334	0.0231982845957882	0.17720199380403	0.17720199380403	false	false	false	true