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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	21556885350.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
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
abc1eab8-0e8c-42d0-aeb9-ccf82ae82fc1	2026-09-14 15:02	2026-09-14 15:02	2026-09-14 15:02	XLU	XLU260918C00043000	call	43.0000	2026-09-18	0.0800	0.0600	0.0800	41.9500	14568.00	14568.00	0.00	1821	11	5256	4480	1.17321428571429	0.226455268094426	0.226455268094426	true	false	false	true
30355eb2-4b37-48c3-ac86-6aded7eb41b1	2026-09-14 14:44	2026-09-14 14:44	2026-09-14 14:44	XLU	XLU261016C00043000	call	43.0000	2026-10-16	0.3200	0.3000	0.3200	41.9050	17536.00	17536.00	0.00	548	45	816	7274	0.112180368435524	0.138158194093909	0.138158194093909	true	false	false	true
a272bac6-d54f-4475-92f2-f769533f4084	2026-09-14 13:11	2026-09-14 13:11	2026-09-14 13:11	XLU	XLU261218C00043000	call	43.0000	2026-12-18	0.9800	0.9500	0.9800	41.9000	51254.00	51254.00	0.00	523	44	705	1507	0.467816854678169	0.148004856502266	0.148263759859555	false	false	false	true
bfb58f0f-dbd8-4b9c-9cea-252ae6f408e0	2026-09-14 11:56	2026-09-14 11:55	2026-09-14 11:55	XLU	XLU261218P00037500	put	37.5000	2026-12-18	0.2100	0.1800	0.2100	41.8901	16884.00	16884.00	0.00	804	33	1575	8429	0.186854905682762	0.194907312701309	0.194907312701309	false	false	false	true
dcc4a805-0c9b-4a68-96e6-1f8c1ce25ba3	2026-09-14 11:49	2026-09-14 11:49	2026-09-14 11:49	XLU	XLU261218P00037500	put	37.5000	2026-12-18	0.2100	0.1800	0.2100	41.8850	14238.00	14238.00	0.00	678	38	771	8429	0.0914699252580377	0.194770676590237	0.194770676590237	false	false	false	true
86c50395-dd9c-4abc-8e0a-abcdc3a8676d	2026-09-14 10:58	2026-09-14 10:58	2026-09-14 10:58	XLU	XLU261016P00042000	put	42.0000	2026-10-16	0.9300	0.9000	0.9300	41.8300	99882.00	99882.00	0.00	1074	29	2204	15065	0.14629936939927	0.186045921640067	0.186045921640067	false	false	false	true
196c431e-53b0-4f41-8f5b-5476adc7831d	2026-09-14 10:57	2026-09-14 10:57	2026-09-14 10:57	XLU	XLU261016P00042000	put	42.0000	2026-10-16	0.9000	0.8600	0.9000	41.8550	14580.00	14580.00	0.00	162	31	792	15065	0.0525721871888483	0.182456832644157	0.182456832644157	true	false	false	true
a6bc24f6-35c1-4fcd-a064-4d1d8a508aa2	2026-09-14 10:08	2026-09-14 10:07	2026-09-14 10:07	XLU	XLU260918P00042500	put	42.5000	2026-09-18	0.6700	0.6200	0.6700	41.9500	17420.00	17420.00	0.00	260	7	266	15919	0.0167095923110748	0.192884562835523	0.192884562835523	true	false	false	true
df80f98e-559f-4d84-a853-949fb498a334	2026-09-14 09:35	2026-09-14 09:35	2026-09-14 09:35	XLU	XLU281215P00040000	put	40.0000	2028-12-15	2.4500	2.4500	2.6500	42.4057	12250.00	0.00	12250.00	50	8	50	12631	0.00395851476526007	0.199190105980289	0.199190105980289	false	false	false	true
34d26075-c6d2-40fb-a948-4ce8eed79a35	2026-09-11 10:51	2026-09-11 10:51	2026-09-11 10:51	XLU	XLU260918C00043500	call	43.5000	2026-09-18	0.1000	0.1000	0.1100	42.5500	24760.00	0.00	24760.00	2476	24	2485	3340	0.744011976047904	0.169649256680034	0.169649256680034	false	false	false	true
9ab2db38-72a2-4f83-b8f6-06cb667927c8	2026-09-10 15:48	2026-09-10 15:48	2026-09-10 15:48	XLU	XLU260918P00042500	put	42.5000	2026-09-18	0.3600	0.3100	0.3600	42.6350	138312.00	138312.00	0.00	3842	8	4419	11562	0.382200311364816	0.175086160293259	0.175086160293259	true	false	false	true
3af3b9af-cc92-4f18-8fa5-d3e71e2741c8	2026-09-10 10:19	2026-09-10 10:19	2026-09-10 10:19	XLU	XLU270617C00046000	call	46.0000	2027-06-17	1.5400	1.5400	1.5500	43.0500	22330.00	0.00	22330.00	145	14	259	2061	0.125667151868025	0.144380536557652	0.144522447897199	false	false	false	true
b978f33c-6042-4698-8ad6-a7dd2286b38f	2026-09-10 09:59	2026-09-10 09:59	2026-09-10 09:59	XLU	XLU260918C00043500	call	43.5000	2026-09-18	0.2200	0.2200	0.2500	42.8600	17952.00	0.00	17952.00	816	15	885	2369	0.373575348248206	0.180545162699819	0.180545162699819	true	false	false	true
b260457d-5062-43c6-b898-e00620e65a7d	2026-09-10 09:35	2026-09-10 09:34	2026-09-10 09:34	XLU	XLU261016C00043000	call	43.0000	2026-10-16	0.8000	0.7800	0.8900	43.0701	17760.00	7680.00	10080.00	222	5	1680	3763	0.446452298697847	0.125476221855702	0.125476221855702	false	false	false	true
ccad18d8-f379-45d9-be88-6e1e4ee8c50a	2026-09-09 14:22	2026-09-09 14:22	2026-09-09 14:22	XLU	XLU270115C00044000	call	44.0000	2027-01-15	1.3100	1.2900	1.3200	43.0450	40610.00	40610.00	0.00	310	10	493	8160	0.0604166666666667	0.147081931952672	0.147081931952672	false	false	false	true
ff60aacb-f6e9-4792-8f18-00371e9f824a	2026-09-09 13:37	2026-09-09 13:37	2026-09-09 13:37	XLU	XLU260918P00043000	put	43.0000	2026-09-18	0.4500	0.4400	0.4800	42.8950	11140.00	0.00	11140.00	250	19	301	12023	0.0250353489145804	0.15130377987833	0.158755809570985	false	false	false	true
57edf259-4813-463e-b0ab-aef877cac448	2026-09-09 11:52	2026-09-09 11:52	2026-09-09 11:52	XLU	XLU261016P00043000	put	43.0000	2026-10-16	0.9900	0.9500	0.9900	42.8850	11781.00	11781.00	0.00	119	6	387	2264	0.170936395759717	0.186907535379767	0.186907535379767	false	false	false	true
669d84f9-9c4a-4064-9c8a-feac6c7d114b	2026-09-09 11:12	2026-09-09 11:12	2026-09-09 11:12	XLU	XLU270115C00044000	call	44.0000	2027-01-15	1.2500	1.2200	1.2700	42.9200	12375.00	4750.00	7625.00	99	10	132	8160	0.0161764705882353	0.146936153158359	0.146936153158359	false	false	false	true