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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	21723451602.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"}	2026-09-15	2026-09-15 21:15	2026-09-15 21:15
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
bf7b6e2a-ad14-4035-a7da-44f15225929f	2026-09-09 11:09	2026-09-09 11:09	2026-09-09 11:09	XLU	XLU270115C00043500	call	43.5000	2027-01-15	1.4800	1.4300	1.9300	42.9450	10508.00	0.00	10508.00	71	5	71	737	0.096336499321574	0.146290125563512	0.146290125563512	false	false	false	true
e622d470-c034-4a22-968a-8da5664baf2d	2026-09-09 10:26	2026-09-09 10:26	2026-09-09 10:26	XLU	XLU280121C00045500	call	45.5000	2028-01-21	3.0500	2.9400	3.0500	43.0000	15250.00	15250.00	0.00	50	10	50	463	0.107991360691145	0.153930297571017	0.153930297571017	false	false	false	true
a087a739-6d0e-4147-a467-a321e30b7717	2026-09-08 14:10	2026-09-08 14:09	2026-09-08 14:09	XLU	XLU260925P00043000	put	43.0000	2026-09-25	0.4100	0.4100	0.4700	43.6050	75194.00	0.00	75194.00	1834	9	1939	2599	0.746056175452097	0.187467753273435	0.187467753273435	true	false	false	true
a89e5a8e-c3c3-4a79-ba10-998f91d87ff8	2026-09-08 13:44	2026-09-08 13:44	2026-09-08 13:44	XLU	XLU270115P00041500	put	41.5000	2027-01-15	0.8800	0.8500	0.8800	43.5200	44000.00	44000.00	0.00	500	10	1500	11965	0.125365649811952	0.190325992714419	0.190325992714419	true	false	false	true
42e6f5f4-1638-4c40-81fc-31a420e23e57	2026-09-08 13:44	2026-09-08 13:43	2026-09-08 13:43	XLU	XLU270115P00041500	put	41.5000	2027-01-15	0.8800	0.8500	0.8800	43.5300	79200.00	79200.00	0.00	900	11	1000	11965	0.0835770998746344	0.190643764327578	0.190643764327578	true	false	false	true
fc5ff74f-c7da-4f3f-83c7-e077c0c483ca	2026-09-08 13:08	2026-09-08 13:08	2026-09-08 13:08	XLU	XLU261016P00042000	put	42.0000	2026-10-16	0.3600	0.3500	0.3600	43.5300	10692.00	10692.00	0.00	297	17	447	14125	0.031646017699115	0.179424429447272	0.179424429447272	false	false	false	true
c08a8bae-5018-4ed6-9844-535d37b5c28b	2026-09-08 11:51	2026-09-08 11:51	2026-09-08 11:51	XLU	XLU261016C00045000	call	45.0000	2026-10-16	0.3700	0.3300	0.3700	43.6163	18500.00	18500.00	0.00	500	11	1719	4738	0.362811312790207	0.147097149819108	0.147097149819108	false	false	false	true
684f1ac2-a331-4d80-9674-b8d31814caaa	2026-09-08 11:50	2026-09-08 11:50	2026-09-08 11:50	XLU	XLU260918C00045000	call	45.0000	2026-09-18	0.0900	0.0900	0.1000	43.5900	21033.00	0.00	21033.00	2337	8	3174	55381	0.057312074538199	0.172219624807844	0.172219624807844	true	false	false	true
fd31ccbc-a22f-4ea9-8807-5236a893b626	2026-09-08 11:44	2026-09-08 11:44	2026-09-08 11:44	XLU	XLU260918P00043500	put	43.5000	2026-09-18	0.4000	0.4000	0.4300	43.5850	27600.00	0.00	27600.00	690	6	2412	7881	0.306052531404644	0.160824755268467	0.160824755268467	true	false	false	true
c9b63f35-565a-4ffa-93cd-ab6d85c54ea5	2026-09-08 11:43	2026-09-08 11:43	2026-09-08 11:43	XLU	XLU260918P00043500	put	43.5000	2026-09-18	0.4100	0.4100	0.4900	43.5950	36203.00	0.00	36203.00	883	9	1415	7881	0.179545742926025	0.165900231837471	0.165900231837471	true	false	false	true
3985c794-0d7c-43c2-929d-079f3306cf03	2026-09-08 11:43	2026-09-08 11:43	2026-09-08 11:43	XLU	XLU260918P00043500	put	43.5000	2026-09-18	0.4100	0.4100	0.4900	43.5950	20869.00	0.00	20869.00	509	39	532	7881	0.067504123842152	0.165900231837471	0.165900231837471	true	false	false	true
0d5c609a-ab66-46b0-a985-eacface139ad	2026-09-08 10:40	2026-09-08 10:40	2026-09-08 10:40	XLU	XLU280121P00045000	put	45.0000	2028-01-21	3.8000	3.7000	3.9500	43.6550	19380.00	13680.00	5700.00	51	7	51	5280	0.00965909090909091	0.219955391002588	0.219955391002588	false	false	false	true
7fc226a8-8828-440d-8903-f794c0fadf3d	2026-09-08 10:03	2026-09-08 10:03	2026-09-08 10:03	XLU	XLU261016C00043000	call	43.0000	2026-10-16	1.0500	1.0000	1.0600	43.4350	16601.00	16601.00	0.00	158	11	426	5090	0.0836935166994106	0.126784107151125	0.128694713808174	true	false	false	true
d11339a4-0561-45b3-aa7e-0ce9447fa678	2026-09-04 13:22	2026-09-04 13:21	2026-09-04 13:21	XLU	XLU260918C00044000	call	44.0000	2026-09-18	0.1800	0.1700	0.1800	42.9900	10044.00	10044.00	0.00	558	30	741	3435	0.215720524017467	0.153760865253307	0.153760865253307	false	false	false	true
d79a5648-5d67-45ff-aa44-338e98856ebb	2026-09-04 13:19	2026-09-04 13:19	2026-09-04 13:19	XLU	XLU261218P00038500	put	38.5000	2026-12-18	0.2100	0.2100	0.2300	43.0000	13608.00	0.00	13608.00	648	25	1210	1984	0.609879032258065	0.184597153146231	0.184597153146231	false	false	false	true
d02c4969-a125-4207-b5f7-756a9b61351b	2026-09-04 11:53	2026-09-04 11:53	2026-09-04 11:53	XLU	XLU260918P00043000	put	43.0000	2026-09-18	0.4300	0.4000	0.4400	43.0850	21500.00	21500.00	0.00	500	9	635	11433	0.055540977871075	0.148963706310517	0.148963706310517	false	false	false	true
923675f0-a0ff-4009-be92-ff4b2840541e	2026-09-04 11:19	2026-09-04 11:19	2026-09-04 11:19	XLU	XLU260911C00043000	call	43.0000	2026-09-11	0.4700	0.4300	0.4800	43.2100	14100.00	14100.00	0.00	300	9	971	444	2.18693693693694	0.141030215591426	0.141030215591426	false	false	false	true
72f1c1e3-683b-46ed-97d6-330190bcf5e6	2026-09-03 12:27	2026-09-03 12:27	2026-09-03 12:27	XLU	XLU261218C00044000	call	44.0000	2026-12-18	1.1200	1.1200	1.1700	43.0450	12208.00	0.00	12208.00	109	5	2163	41460	0.0521707670043415	0.14305618658547	0.14305618658547	false	false	false	true
d604a62f-4d86-4361-be30-6345b93a4a4a	2026-09-03 11:26	2026-09-03 11:26	2026-09-03 11:26	XLU	XLU261016C00043000	call	43.0000	2026-10-16	0.8600	0.8600	0.9000	42.9850	101050.00	0.00	101050.00	1175	9	1617	6134	0.263612650798826	0.130388662089295	0.130388662089295	false	false	false	true
612dd4ec-4688-44c7-bc18-4cfe205a8060	2026-09-03 11:18	2026-09-03 11:17	2026-09-03 11:17	XLU	XLU261016C00045000	call	45.0000	2026-10-16	0.2300	0.2200	0.2500	42.9650	11500.00	2599.00	8901.00	500	18	667	5343	0.124836234325285	0.141326171251407	0.141326171251407	true	false	false	true
d168bcbf-0094-47c2-ae08-4451971c0410	2026-09-03 10:43	2026-09-03 10:43	2026-09-03 10:43	XLU	XLU261218C00044000	call	44.0000	2026-12-18	1.1000	1.1000	1.1800	42.9400	44000.00	0.00	44000.00	400	41	1104	41460	0.0266280752532561	0.14609975738248	0.14609975738248	false	false	false	true
3603e357-02d8-4dda-923b-de1069039cf4	2026-09-03 10:33	2026-09-03 10:33	2026-09-03 10:33	XLU	XLU261218C00044000	call	44.0000	2026-12-18	1.0500	1.0500	1.1500	42.8151	12810.00	0.00	7245.00	122	12	486	41460	0.0117221418234443	0.146701421367584	0.146701421367584	false	false	false	true
f6b11e3a-99d8-448f-bd46-7a8344e74a6c	2026-09-02 15:32	2026-09-02 15:32	2026-09-02 15:32	XLU	XLU270115C00043000	call	43.0000	2027-01-15	1.5800	1.5300	1.6000	42.6403	31600.00	31600.00	0.00	200	5	206	1221	0.168714168714169	0.142709932325095	0.142709932325095	false	false	false	true
a5780de8-64d6-4d59-b5f9-f747cd9c2e97	2026-09-02 11:35	2026-09-02 11:35	2026-09-02 11:35	XLU	XLU261016C00043000	call	43.0000	2026-10-16	0.7000	0.6800	0.7100	42.4600	14000.00	14000.00	0.00	200	7	1430	4623	0.309322950465066	0.145459092806964	0.145459092806964	false	false	false	true
7de23d10-6470-4c4b-8ca1-7178ce8b83c0	2026-09-01 14:49	2026-09-01 14:49	2026-09-01 14:49	XLU	XLU261016C00045000	call	45.0000	2026-10-16	0.2000	0.1600	0.2000	42.3899	10000.00	10000.00	0.00	500	8	1140	4499	0.253389642142698	0.156687067220845	0.156687067220845	false	false	false	true