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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 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 = XLU×

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

39f9dbd4-e376-4002-9353-183a7071c1f7	2026-09-21 11:17	2026-09-21 11:17	2026-09-21 11:17	XLU	XLU261016P00039000	put	39.0000	2026-10-16	0.1300	0.1200	0.1400	40.8648	17433.00	0.00	17290.00	1341	20	1431	2964	0.482793522267206	0.174779826378363	0.174779826378363	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	21151218504.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T15:19:12.034191Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
8c5614a7-3181-47a7-839e-d8c0a6fdd779	2026-09-21 11:01	2026-09-21 11:00	2026-09-21 11:00	XLU	XLU261030P00038000	put	38.0000	2026-10-30	0.1200	0.1200	0.1600	40.7650	37716.00	0.00	37716.00	3143	9	3146	5	629.2	0.183235200484733	0.183235200484733	false	false	false	true
fb0b2050-a0af-48a3-9e45-c85ee01df18f	2026-09-21 10:38	2026-09-21 10:38	2026-09-21 10:38	XLU	XLU270115P00036000	put	36.0000	2027-01-15	0.2000	0.1900	0.2200	40.7450	11480.00	20.00	11460.00	574	10	576	1590	0.362264150943396	0.191941809898079	0.191941809898079	false	false	false	true
9c340906-5a37-4138-82b9-d50ad69f5cd1	2026-09-21 10:06	2026-09-21 10:06	2026-09-21 10:06	XLU	XLU261023P00039500	put	39.5000	2026-10-23	0.2900	0.2900	0.3600	40.6100	14500.00	0.00	14500.00	500	9	501	316	1.58544303797468	0.160272683589835	0.160272683589835	false	false	false	true
93de0015-6a8a-4201-ad44-b830fe52ed52	2026-09-18 14:54	2026-09-18 14:53	2026-09-18 14:53	XLU	XLU261016P00041000	put	41.0000	2026-10-16	0.6700	0.6700	0.6800	41.2550	11323.00	0.00	11323.00	169	14	999	2834	0.352505292872265	0.186538858761364	0.186538858761364	false	false	false	true
69f67eb3-7364-4c8f-a00e-1e898e2e21cf	2026-09-18 14:52	2026-09-18 14:52	2026-09-18 14:52	XLU	XLU270319C00042000	call	42.0000	2027-03-19	1.7100	1.6200	1.7200	41.2300	15224.00	15224.00	0.00	89	19	253	60	4.21666666666667	0.14135464295713	0.142218682227471	false	false	false	true
24ec4cb5-b4b4-4f6f-a16d-bf1b05c70d68	2026-09-18 13:51	2026-09-18 13:51	2026-09-18 13:51	XLU	XLU270617P00040000	put	40.0000	2027-06-17	1.6500	1.6100	1.6800	41.2150	19140.00	9240.00	9900.00	116	11	3344	34430	0.0971246006389776	0.198025495273265	0.198025495273265	true	false	false	true
f1572fd4-e40f-43ba-8393-a994f29413d1	2026-09-18 13:49	2026-09-18 13:48	2026-09-18 13:48	XLU	XLU270617P00040000	put	40.0000	2027-06-17	1.6500	1.6200	1.6500	41.2150	17160.00	17160.00	0.00	104	8	3117	34430	0.0905315132152193	0.198025495273265	0.198025495273265	false	false	false	true
6a301899-5c5f-413e-99c3-b21f8eceaeda	2026-09-18 13:36	2026-09-18 13:36	2026-09-18 13:36	XLU	XLU261218C00041000	call	41.0000	2026-12-18	1.5400	1.5100	1.5400	41.2150	88088.00	88088.00	0.00	572	45	805	714	1.12745098039216	0.146089933783559	0.146089933783559	false	false	false	true
70a54302-f909-4d4e-8fa3-3c57165d6c41	2026-09-18 13:34	2026-09-18 13:34	2026-09-18 13:34	XLU	XLU261016P00039000	put	39.0000	2026-10-16	0.1500	0.1500	0.1700	41.1700	34245.00	0.00	34245.00	2283	28	2362	182	12.978021978022	0.190715617008171	0.190715617008171	false	false	false	true
4798c670-6b50-450c-a865-83b97cd72f3a	2026-09-18 13:12	2026-09-18 13:12	2026-09-18 13:12	XLU	XLU270115C00042500	call	42.5000	2027-01-15	0.9600	0.9400	1.0000	41.1101	12192.00	96.00	12096.00	127	10	152	5517	0.0275512053652347	0.140150807446615	0.140146234353942	false	false	false	true
a2fd39b1-53ce-442e-8532-0207cfa0391e	2026-09-18 10:33	2026-09-18 10:33	2026-09-18 10:33	XLU	XLU261218P00036500	put	36.5000	2026-12-18	0.1700	0.1500	0.1700	41.2694	18309.00	18309.00	0.00	1077	33	1079	475	2.27157894736842	0.202328431117509	0.202328431117509	false	false	false	true
e4ecdd81-61be-4d2f-b05b-2309f454f0a2	2026-09-18 10:14	2026-09-18 10:14	2026-09-18 10:14	XLU	XLU281215P00030000	put	30.0000	2028-12-15	0.5500	0.3500	0.5600	41.2050	10890.00	1155.00	9735.00	198	18	198	9197	0.0215287593780581	0.223837175227294	0.223837175227294	false	false	false	true
eb0c9c0d-15b8-4146-a348-e995ce43f086	2026-09-18 10:11	2026-09-18 10:11	2026-09-18 10:11	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.3400	0.3400	0.3700	41.2100	52632.00	0.00	52632.00	1548	30	7824	10371	0.754411339311542	0.188415906457136	0.188415906457136	false	false	false	true
12dbc120-01e7-487f-b8c6-a19fba201210	2026-09-18 10:09	2026-09-18 10:09	2026-09-18 10:09	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.3500	0.3400	0.3600	41.1950	20405.00	20090.00	0.00	583	13	6265	10371	0.604088323208948	0.190078291612468	0.190078291612468	true	false	false	true
c1001258-060e-489c-bb93-e47451a5ffc6	2026-09-18 10:07	2026-09-18 10:07	2026-09-18 10:07	XLU	XLU261009C00042500	call	42.5000	2026-10-09	0.1600	0.1600	0.1900	41.2000	14400.00	0.00	14400.00	900	19	912	43	21.2093023255814	0.14273009712137	0.14273009712137	false	false	false	true
c8c664ed-118b-4550-84ca-3e694fa70b3b	2026-09-18 09:57	2026-09-18 09:57	2026-09-18 09:57	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.3500	0.3100	0.3500	41.1550	13790.00	13790.00	0.00	394	30	3076	10371	0.296596278083116	0.187258454137214	0.187258454137214	true	false	false	true
b2371f57-5e58-4bad-95be-4d6da98d8b19	2026-09-18 09:57	2026-09-18 09:57	2026-09-18 09:57	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.3500	0.2100	0.3500	41.1550	91210.00	91210.00	0.00	2606	14	5682	10371	0.547873879085913	0.187258454137214	0.187258454137214	true	false	false	true
769c6fd2-5597-497f-913d-39a42558b643	2026-09-18 09:52	2026-09-18 09:52	2026-09-18 09:52	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.3400	0.3100	0.3400	41.1700	52598.00	52598.00	0.00	1547	25	2682	10371	0.258605727509401	0.185617805702394	0.185617805702394	true	false	false	true
76c0ea7d-b505-4047-9bac-016f9880ba59	2026-09-17 14:42	2026-09-17 14:42	2026-09-17 14:42	XLU	XLU261016C00042000	call	42.0000	2026-10-16	0.5100	0.4900	0.5100	41.6150	21420.00	21420.00	0.00	420	15	1239	18559	0.0667600625033676	0.133893541374079	0.133893541374079	false	false	false	true
06b646fa-fc26-4837-8186-85dce857f530	2026-09-17 12:58	2026-09-17 12:58	2026-09-17 12:58	XLU	XLU261218P00040500	put	40.5000	2026-12-18	0.8200	0.8100	0.8500	41.6550	26814.00	0.00	26814.00	327	9	348	2165	0.160739030023095	0.180867988454387	0.180867988454387	false	false	false	true
122877ed-4bf9-411c-99c1-771377740941	2026-09-17 12:54	2026-09-17 12:53	2026-09-17 12:53	XLU	XLU270115C00042500	call	42.5000	2027-01-15	1.2100	1.2100	1.2500	41.6600	10285.00	0.00	10285.00	85	21	87	5268	0.0165148063781321	0.139397605245011	0.139397605245011	false	false	false	true
5c13cba0-b8c1-48e1-b278-9d1a3362497b	2026-09-17 10:44	2026-09-17 10:44	2026-09-17 10:44	XLU	XLU261016C00043000	call	43.0000	2026-10-16	0.2100	0.2000	0.2100	41.4450	10500.00	10500.00	0.00	500	11	1659	8104	0.204713721618954	0.14842118078745	0.14842118078745	false	false	false	true
e702bd10-942e-40b4-b5d1-4cbca2472d87	2026-09-16 15:44	2026-09-16 15:44	2026-09-16 15:44	XLU	XLU260918P00041500	put	41.5000	2026-09-18	0.4300	0.4300	0.5100	41.1750	106511.00	0.00	106511.00	2477	21	3235	5804	0.55737422467264	0.196236906359102	0.196236906359102	false	false	false	true
62fb5117-35b1-4e59-b9a8-17f98d44e7dc	2026-09-16 15:44	2026-09-16 15:44	2026-09-16 15:44	XLU	XLU260918P00041500	put	41.5000	2026-09-18	0.4400	0.4200	0.4400	41.1750	22968.00	22968.00	0.00	522	7	758	5804	0.130599586492074	0.205588259439561	0.205588259439561	true	false	false	true
da914845-5d15-46bb-bed7-cfa508eff28e	2026-09-16 14:40	2026-09-16 14:40	2026-09-16 14:40	XLU	XLU261016C00043000	call	43.0000	2026-10-16	0.2400	0.2400	0.2600	41.3950	19872.00	0.00	19872.00	828	30	2267	7299	0.310590491848198	0.15734705168996	0.15734705168996	false	false	false	true
d94103df-f58b-4c78-99b3-f1e65520bc02	2026-09-16 13:52	2026-09-16 13:52	2026-09-16 13:52	XLU	XLU261016C00043000	call	43.0000	2026-10-16	0.2500	0.2400	0.2600	41.0000	23800.00	500.00	21275.00	952	18	1405	7299	0.192492122208522	0.152729640239007	0.152729640239007	false	false	false	true
dcf0eef0-0649-486d-af15-6202a6da6f75	2026-09-16 13:33	2026-09-16 13:33	2026-09-16 13:33	XLU	XLU261016P00042000	put	42.0000	2026-10-16	1.1800	1.1800	1.2100	41.4550	91922.00	0.00	91922.00	779	20	1006	14486	0.0694463620046942	0.201796958178368	0.201796958178368	false	false	false	true
ac99a6a8-104a-40d5-a193-cd1716229408	2026-09-16 13:33	2026-09-16 13:33	2026-09-16 13:33	XLU	XLU261016P00042000	put	42.0000	2026-10-16	1.1800	1.1700	1.1800	41.4550	14750.00	14750.00	0.00	125	16	211	14486	0.0145657876570482	0.201796958178368	0.201796958178368	true	false	false	true
86018f1a-7c7a-4679-bd52-41fb87aa9b24	2026-09-16 12:56	2026-09-16 12:56	2026-09-16 12:56	XLU	XLU270319C00044000	call	44.0000	2027-03-19	1.1700	1.1600	1.1700	41.5950	19071.00	19071.00	0.00	163	17	181	201	0.900497512437811	0.150245146729343	0.150245146729343	false	false	false	true
e99c4fd5-7b61-40e2-a7d4-0d5de97ff8a8	2026-09-16 12:11	2026-09-16 12:10	2026-09-16 12:10	XLU	XLU280121C00043000	call	43.0000	2028-01-21	3.1000	3.1000	3.2500	41.5435	22940.00	0.00	22940.00	74	24	74	1650	0.0448484848484848	0.130478824548023	0.130478824548023	false	false	false	true
c362ab6e-f145-47d9-8fd2-4efc4a57404f	2026-09-16 12:09	2026-09-16 12:09	2026-09-16 12:09	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.2900	0.2900	0.3100	41.5400	11397.00	0.00	11397.00	393	11	796	12054	0.0660361705657873	0.190201678353942	0.190201678353942	false	false	false	true
5b57911b-2c8d-4ff7-b1d7-7099c43a9f5f	2026-09-16 11:27	2026-09-16 11:27	2026-09-16 11:27	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.1900	1.1300	1.1900	41.5799	20111.00	20111.00	0.00	169	33	171	466	0.366952789699571	0.192993683177032	0.192993683177032	false	false	false	true
80d043ff-824e-47b6-9b34-d3e90a00365b	2026-09-15 15:34	2026-09-15 15:33	2026-09-15 15:33	XLU	XLU260918P00042500	put	42.5000	2026-09-18	1.1100	1.1100	1.1900	41.4001	111000.00	0.00	111000.00	1000	65	2050	14488	0.14149641082275	0.195460234421414	0.195637826631793	false	false	false	true
f04acba0-6c0f-49cf-907f-e4696915ed82	2026-09-15 15:32	2026-09-15 15:32	2026-09-15 15:32	XLU	XLU270115C00042500	call	42.5000	2027-01-15	1.1300	1.1200	1.1400	41.4050	12656.00	10622.00	0.00	112	16	639	4826	0.132407791131372	0.142404842502919	0.142404842502919	false	false	false	true
92ea5f15-6f9b-4194-98c3-f659addeb618	2026-09-15 14:39	2026-09-15 14:38	2026-09-15 14:38	XLU	XLU270115C00045000	call	45.0000	2027-01-15	0.4300	0.4300	0.4800	41.4400	21500.00	0.00	21500.00	500	9	730	12137	0.0601466589766829	0.146475970490642	0.146475970490642	false	false	false	true
d3f71332-358b-467b-a340-d70d44268504	2026-09-15 13:57	2026-09-15 13:57	2026-09-15 13:57	XLU	XLU270115C00042000	call	42.0000	2027-01-15	1.3700	1.3600	1.3700	41.4800	50964.00	50964.00	0.00	372	28	7891	1018	7.75147347740668	0.139765790046403	0.140040056817361	false	false	false	true
6ae26497-4cee-48c5-b1fd-53c89d7a6d28	2026-09-15 13:46	2026-09-15 13:46	2026-09-15 13:46	XLU	XLU260918C00041500	call	41.5000	2026-09-18	0.3200	0.2500	0.3200	41.4650	16000.00	16000.00	0.00	500	25	568	236	2.40677966101695	0.220436080447288	0.220436080447288	false	false	false	true
6efb3085-ef0b-43b3-8a57-330da809f038	2026-09-15 13:46	2026-09-15 13:46	2026-09-15 13:46	XLU	XLU260918P00041500	put	41.5000	2026-09-18	0.3300	0.2700	0.3300	41.4639	16500.00	16500.00	0.00	500	37	673	5323	0.126432462896863	0.212724829584628	0.212352748218089	false	false	false	true
2743f1b9-471a-4488-ba8d-c3deafb3baef	2026-09-15 13:12	2026-09-15 13:11	2026-09-15 13:11	XLU	XLU260925C00041500	call	41.5000	2026-09-25	0.3800	0.3500	0.3900	41.4250	42066.00	31464.00	988.00	1107	52	3186	49	65.0204081632653	0.144326209576679	0.144326209576679	false	false	false	true
03e30d33-70f6-45e3-a8b1-49fcbcba4ddb	2026-09-15 13:12	2026-09-15 13:11	2026-09-15 13:11	XLU	XLU260925C00041500	call	41.5000	2026-09-25	0.3800	0.3800	0.4000	41.4250	13262.00	0.00	13262.00	349	16	3535	49	72.1428571428571	0.144326209576679	0.144326209576679	false	false	false	true
c0375e70-c30c-494f-8523-608f880e7b6b	2026-09-15 13:11	2026-09-15 13:11	2026-09-15 13:11	XLU	XLU260925C00041500	call	41.5000	2026-09-25	0.3700	0.3400	0.3700	41.4250	11544.00	11544.00	0.00	312	35	1796	49	36.6530612244898	0.1406698123832	0.1406698123832	false	false	false	true
8fa4b37e-cadf-48a3-8350-9749da356f63	2026-09-15 13:11	2026-09-15 13:11	2026-09-15 13:11	XLU	XLU260925C00041500	call	41.5000	2026-09-25	0.3600	0.3300	0.3700	41.4200	35568.00	22608.00	12960.00	988	48	1484	49	30.2857142857143	0.137910553970518	0.137910553970518	false	false	false	true
b727c1e4-b0ca-44e1-88bd-0fa2503f8640	2026-09-15 13:11	2026-09-15 13:10	2026-09-15 13:10	XLU	XLU260925C00041500	call	41.5000	2026-09-25	0.3500	0.3300	0.3600	41.4200	11305.00	11305.00	0.00	323	14	496	49	10.1224489795918	0.134253102353758	0.134253102353758	false	false	false	true
e12724c2-cdc6-4822-b1de-89c2cfad68b9	2026-09-15 12:08	2026-09-15 12:08	2026-09-15 12:08	XLU	XLU270115C00042500	call	42.5000	2027-01-15	1.1000	1.0700	1.1100	41.3700	55000.00	55000.00	0.00	500	25	520	4826	0.107749689183589	0.140683011780589	0.140922056999642	false	false	false	true
93d9fb80-3733-4263-850c-34b56a772d1d	2026-09-15 11:55	2026-09-15 11:54	2026-09-15 11:54	XLU	XLU261218C00041000	call	41.0000	2026-12-18	1.6400	1.6400	1.7000	41.3999	61336.00	0.00	61336.00	374	13	451	415	1.08674698795181	0.141433595004357	0.141433595004357	false	false	false	true
28f960c3-c09d-47a3-b773-e1b47841022c	2026-09-15 11:35	2026-09-15 11:35	2026-09-15 11:35	XLU	XLU270115C00047500	call	47.5000	2027-01-15	0.2000	0.1500	0.2000	41.5460	88540.00	88540.00	0.00	4427	7	11932	22254	0.536173272220724	0.162939622482281	0.162939622482281	false	true	false	true
3d29bdb8-09f6-4701-997d-766f4818a757	2026-09-15 11:28	2026-09-15 11:28	2026-09-15 11:28	XLU	XLU261218P00037000	put	37.0000	2026-12-18	0.1900	0.1800	0.1900	41.5000	14098.00	14098.00	0.00	742	33	2366	390	6.06666666666667	0.195711381977997	0.195711381977997	false	false	false	true
5fd824a3-9960-49ea-812c-9cfc1a2947ed	2026-09-15 11:18	2026-09-15 11:18	2026-09-15 11:18	XLU	XLU261218P00037000	put	37.0000	2026-12-18	0.1900	0.1800	0.1900	41.5150	17233.00	17233.00	0.00	907	36	1624	390	4.16410256410256	0.19611094998409	0.19611094998409	false	false	false	true
d6a7c2b0-2890-4584-85c3-7efef26398e9	2026-09-15 11:08	2026-09-15 11:07	2026-09-15 11:07	XLU	XLU261218P00037000	put	37.0000	2026-12-18	0.1900	0.1800	0.1900	41.0000	13604.00	13604.00	0.00	716	18	717	390	1.83846153846154	0.194916500525393	0.194916500525393	false	false	false	true