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

4f1a6bea-78e3-403c-8407-cac9c26b5c86	2026-09-28 10:58	2026-09-28 10:58	2026-09-28 10:58	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.4600	0.4200	0.4800	39.2450	13800.00	12282.00	1518.00	300	10	6058	20627	0.293692732825908	0.213840018627374	0.213840018627374	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	21034678613.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T15:01:52.060675Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
b5f08a72-f8c6-40f8-9e80-de75fcd578a7	2026-09-28 10:55	2026-09-28 10:55	2026-09-28 10:55	XLU	XLU261009C00040500	call	40.5000	2026-10-09	0.2300	0.2200	0.2300	39.2500	17342.00	17342.00	0.00	754	24	4342	4348	0.998620055197792	0.24095195935744	0.24095195935744	false	false	false	true
390441d8-d6fe-4cc8-8d43-6cd62463ed64	2026-09-28 10:55	2026-09-28 10:55	2026-09-28 10:55	XLU	XLU261009C00040500	call	40.5000	2026-10-09	0.2300	0.2200	0.2300	39.2500	20355.00	20355.00	0.00	885	20	5227	4348	1.20216191352346	0.24095195935744	0.24095195935744	false	false	false	true
fe63067e-ca03-45aa-94b9-c2f7c60fea7a	2026-09-28 10:55	2026-09-28 10:55	2026-09-28 10:55	XLU	XLU261009C00040500	call	40.5000	2026-10-09	0.2300	0.2100	0.2400	39.2450	15640.00	3933.00	11707.00	680	10	2419	4348	0.556347746090156	0.241520578399986	0.241520578399986	false	false	false	true
24b94275-bdda-4bf9-967f-f25fd9184617	2026-09-28 10:55	2026-09-28 10:55	2026-09-28 10:55	XLU	XLU261009C00040500	call	40.5000	2026-10-09	0.2300	0.2200	0.2400	39.2450	26335.00	22241.00	2921.00	1145	45	3564	4348	0.8196872125115	0.241520578399986	0.241520578399986	false	false	false	true
8a664f97-a67d-42af-807b-1a1e0e1a0309	2026-09-28 10:55	2026-09-28 10:55	2026-09-28 10:55	XLU	XLU261009C00040500	call	40.5000	2026-10-09	0.2300	0.2200	0.2600	39.2600	26726.00	0.00	26726.00	1162	14	1389	4348	0.319457221711132	0.239813630864622	0.239813630864622	true	false	false	true
a2f2f19e-1021-4548-b924-95fd3d562f87	2026-09-28 10:52	2026-09-28 10:52	2026-09-28 10:52	XLU	XLU261120C00042000	call	42.0000	2026-11-20	0.3900	0.3900	0.4000	39.2800	20865.00	0.00	20865.00	535	17	1711	3373	0.50726356359324	0.204046711044383	0.204046711044383	false	false	false	true
2506ec05-799c-4c63-9265-85cfa61782dd	2026-09-28 10:37	2026-09-28 10:36	2026-09-28 10:36	XLU	XLU261120C00042000	call	42.0000	2026-11-20	0.4100	0.4100	0.4200	39.4000	26650.00	0.00	26650.00	650	25	721	3373	0.213756300029647	0.202300790338436	0.202300790338436	false	false	false	true
1dd448cd-7c0e-4eaf-b46f-18299836088c	2026-09-28 10:26	2026-09-28 10:26	2026-09-28 10:26	XLU	XLU261016C00041000	call	41.0000	2026-10-16	0.2400	0.2300	0.2500	39.0000	17328.00	0.00	17304.00	722	53	1040	34681	0.0299876012802399	0.220415751997423	0.219989218284307	false	false	false	true
6a72a6e6-1658-4cc2-b4c1-2df279d199ca	2026-09-28 10:21	2026-09-28 10:20	2026-09-28 10:20	XLU	XLU261009C00040000	call	40.0000	2026-10-09	0.4000	0.4000	0.4300	39.3501	41880.00	0.00	41880.00	1047	43	5130	28298	0.181284896459114	0.239394289088845	0.239394289088845	false	false	false	true
6141895f-1f12-4adb-9251-1a95889ec370	2026-09-28 10:17	2026-09-28 10:17	2026-09-28 10:17	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5400	0.5400	0.5500	39.3900	41202.00	0.00	41202.00	763	24	5552	20627	0.269161778251806	0.221062637501599	0.221062637501599	false	false	false	true
2422abad-4bd4-4273-a4bd-4adbd91cf907	2026-09-28 10:17	2026-09-28 10:17	2026-09-28 10:17	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5500	0.5400	0.5600	39.3900	17435.00	0.00	16830.00	317	28	4789	20627	0.232171425801134	0.224016218697697	0.224016218697697	false	false	false	true
d25fa68b-9042-454f-b51e-3324b0279366	2026-09-28 10:10	2026-09-28 10:10	2026-09-28 10:10	XLU	XLU270115P00040000	put	40.0000	2027-01-15	1.7400	1.7400	1.8300	39.4700	10962.00	0.00	10962.00	63	8	67	32984	0.00203128789716226	0.201262810825111	0.201262810825111	false	false	false	true
5d049983-13fe-4409-82c0-c85678b0438d	2026-09-28 10:10	2026-09-28 10:10	2026-09-28 10:10	XLU	XLU271217C00040000	call	40.0000	2027-12-17	3.3600	3.2500	3.4500	39.4500	33573.00	4020.00	29553.00	100	8	102	658	0.155015197568389	0.140600541996043	0.141215793701806	false	false	false	true
ebaa9dbb-e990-4532-9511-f0c3200297e0	2026-09-28 10:10	2026-09-28 10:09	2026-09-28 10:09	XLU	XLU261016C00039000	call	39.0000	2026-10-16	1.0300	1.0200	1.0300	39.4350	44898.00	43878.00	0.00	436	9	636	1226	0.518760195758564	0.211905024120576	0.214898912739206	true	false	false	true
962fdd7d-e69a-4dfc-a868-17b8351225f1	2026-09-28 10:01	2026-09-28 10:01	2026-09-28 10:01	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.2100	0.2000	0.2200	39.2850	19299.00	17787.00	273.00	919	57	5836	39679	0.147080319564505	0.290167065876142	0.290167065876142	false	false	false	true
d2a932cb-69b0-4f5b-861d-04771986e1ea	2026-09-28 10:00	2026-09-28 10:00	2026-09-28 10:00	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.2100	0.2000	0.2300	39.3000	18123.00	12180.00	4914.00	863	44	3701	39679	0.0932735199979838	0.287092010079274	0.287092010079274	false	false	false	true
94e4d87e-e80b-4928-ac55-b5b41747c390	2026-09-28 10:00	2026-09-28 10:00	2026-09-28 10:00	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.2100	0.2000	0.2200	39.3000	12453.00	8820.00	3633.00	593	27	4398	39679	0.11083948688223	0.287092010079274	0.287092010079274	false	false	false	true
50774b41-1056-4fa8-b5d1-9ee35e2893b3	2026-09-28 09:59	2026-09-28 09:59	2026-09-28 09:59	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.2100	0.1900	0.2200	39.0000	18144.00	12327.00	5817.00	864	44	2770	39679	0.0698102270722548	0.285035795815054	0.285035795815054	false	false	false	true
44e989f0-9eeb-45d9-954d-c9cc6fa67d2b	2026-09-28 09:59	2026-09-28 09:59	2026-09-28 09:59	XLU	XLU261016C00039500	call	39.5000	2026-10-16	0.7300	0.7100	0.7300	39.0000	168995.00	168995.00	0.00	2315	12	2651	1028	2.57879377431907	0.221433314373126	0.221433314373126	true	false	false	true
7de7e8c5-1695-451e-aa7a-c868194a1e7e	2026-09-28 09:47	2026-09-28 09:47	2026-09-28 09:47	XLU	XLU261120C00040000	call	40.0000	2026-11-20	1.0000	0.9800	1.0400	39.3500	21300.00	0.00	21300.00	213	5	2505	11468	0.218433903034531	0.198350531154952	0.198350531154952	false	false	false	true
52217469-41c9-4746-a1c6-52642446be6d	2026-09-28 09:43	2026-09-28 09:43	2026-09-28 09:43	XLU	XLU261009C00040000	call	40.0000	2026-10-09	0.3700	0.3400	0.3800	39.3100	82103.00	21164.00	18500.00	2219	38	2235	28298	0.0789808467029472	0.233275890560384	0.233275890560384	true	false	false	true
250929a1-43c5-4a71-9857-8bff9e745d6d	2026-09-28 09:41	2026-09-28 09:41	2026-09-28 09:41	XLU	XLU270319C00045000	call	45.0000	2027-03-19	0.5000	0.4900	0.5000	39.2209	15000.00	15000.00	0.00	300	28	751	40935	0.0183461585440332	0.18378368111378	0.18378368111378	false	false	false	true
a003c509-a9fd-486f-a9fc-1c56f8c59623	2026-09-28 09:39	2026-09-28 09:39	2026-09-28 09:39	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.4500	0.4200	0.4700	39.1800	16875.00	2970.00	13365.00	375	33	2314	20627	0.112183061036506	0.218009516037297	0.218009516037297	true	false	false	true
47641f4b-e4e0-439e-8deb-c55c0f5a540b	2026-09-28 09:34	2026-09-28 09:33	2026-09-28 09:33	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.4700	0.4700	0.4900	39.2600	23594.00	0.00	23594.00	502	18	1269	20627	0.0615213070247734	0.215188884238408	0.215188884238408	true	false	false	true
9fd8c8ff-2fe3-4891-aa54-0845f3e04694	2026-09-28 09:33	2026-09-28 09:33	2026-09-28 09:33	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.4700	0.4600	0.4800	39.2800	23453.00	20116.00	3337.00	499	12	615	20627	0.0298152906384835	0.212925783027974	0.212925783027974	true	false	false	true
515ef6bd-0535-476b-bc38-822e201fcb8d	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	XLU	XLU261009C00040000	call	40.0000	2026-10-09	0.4600	0.4600	0.5300	39.0000	13938.00	0.00	13938.00	303	34	31909	180	177.272222222222	0.207372848008608	0.207372848008608	false	false	false	true
9026491d-7e48-474c-a523-be46e262ac2f	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.6100	0.5900	0.6100	39.5750	25132.00	25132.00	0.00	412	25	19763	3753	5.26592059685585	0.201160019079844	0.201160019079844	false	false	false	true
27a79636-c918-4901-85e4-5068c037625a	2026-09-25 15:51	2026-09-25 15:50	2026-09-25 15:50	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.3300	0.3300	0.3500	39.0000	23925.00	0.00	23925.00	725	43	90384	5014	18.0263262863981	0.226965060087891	0.226965060087891	false	false	false	true
260843fa-346f-48a7-8b30-42cac6f686bd	2026-09-25 15:50	2026-09-25 15:50	2026-09-25 15:50	XLU	XLU270115C00040000	call	40.0000	2027-01-15	1.5800	1.5100	1.5800	39.0000	39500.00	39500.00	0.00	250	6	1566	3085	0.507617504051864	0.17470399536991	0.17470399536991	false	false	false	true
19c096a1-a4f9-46a7-8f21-34f3117131a8	2026-09-25 15:50	2026-09-25 15:50	2026-09-25 15:50	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.6100	0.5800	0.6100	39.0000	11224.00	11224.00	0.00	184	18	18917	3753	5.04050093258726	0.199981839062328	0.199981839062328	false	false	false	true
4edaf5a7-e144-4e7a-a9c8-1bb6404cdf0b	2026-09-25 15:45	2026-09-25 15:45	2026-09-25 15:45	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5900	0.5800	0.5900	39.0000	18467.00	18467.00	0.00	313	6	18305	3753	4.87743138822275	0.200478481227721	0.200478481227721	false	false	false	true
10f3b6f0-9687-47e5-ba70-5b5415618f91	2026-09-25 15:45	2026-09-25 15:45	2026-09-25 15:45	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5900	0.5800	0.5900	39.0000	18290.00	18290.00	0.00	310	15	17992	3753	4.79403144151346	0.201057540547675	0.201057540547675	false	false	false	true
a8dc39f9-4a95-41c6-a4d1-58ea5fccff62	2026-09-25 15:45	2026-09-25 15:44	2026-09-25 15:44	XLU	XLU261120C00040000	call	40.0000	2026-11-20	1.1100	1.1000	1.1100	39.0000	16650.00	16650.00	0.00	150	9	9990	3656	2.73249452954048	0.198040321537057	0.198040321537057	false	false	false	true
e10c9012-5d9f-4611-a7ee-fb1cc0e61ac1	2026-09-25 15:44	2026-09-25 15:44	2026-09-25 15:44	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5700	0.5600	0.5700	39.0000	19209.00	19209.00	0.00	337	19	17640	3753	4.70023980815348	0.197985765715581	0.197985765715581	false	false	false	true
72baa755-53a6-4c9b-aaac-ab66deda7ef9	2026-09-25 15:44	2026-09-25 15:44	2026-09-25 15:44	XLU	XLU261120C00040000	call	40.0000	2026-11-20	1.1100	1.1000	1.1100	39.0000	11100.00	11100.00	0.00	100	10	9818	3656	2.68544857768053	0.198040321537057	0.198040321537057	false	false	false	true
14e700d5-0e4f-4c33-b977-49cd887ac144	2026-09-25 15:44	2026-09-25 15:44	2026-09-25 15:44	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5700	0.5600	0.5700	39.0000	23655.00	23655.00	0.00	415	38	17303	3753	4.61044497735145	0.198558379756237	0.198558379756237	false	false	false	true
9ce7447b-5cc2-4584-8afb-5a67369f7335	2026-09-25 15:37	2026-09-25 15:37	2026-09-25 15:37	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5600	0.5100	0.5600	39.0000	11200.00	11200.00	0.00	200	14	16339	3753	4.35358379962697	0.19927623004758	0.19927623004758	false	false	false	true
e562961b-6362-4881-b402-7682d9cce195	2026-09-25 15:37	2026-09-25 15:37	2026-09-25 15:37	XLU	XLU261002P00039000	put	39.0000	2026-10-02	0.2400	0.2300	0.2400	39.0000	13872.00	13872.00	0.00	578	6	741	2410	0.30746887966805	0.20672311894577	0.20672311894577	true	false	false	true
5fc05787-368d-4b4a-80a5-bf28dfbe65c3	2026-09-25 15:35	2026-09-25 15:35	2026-09-25 15:35	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.6900	0.6900	0.7100	39.4600	37812.00	0.00	37812.00	548	17	18295	485	37.7216494845361	0.195454409709353	0.195454409709353	true	false	false	true
b7a66618-f8b7-452c-bc50-20cafabbdc95	2026-09-25 15:34	2026-09-25 15:34	2026-09-25 15:34	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.7000	0.6900	0.7000	39.4450	14000.00	14000.00	0.00	200	5	17721	485	36.5381443298969	0.1981183195214	0.1981183195214	false	false	false	true
9a40cda8-d9f4-48e6-8986-de7361efffcb	2026-09-25 15:32	2026-09-25 15:32	2026-09-25 15:32	XLU	XLU261016C00039000	call	39.0000	2026-10-16	1.0500	1.0300	1.0500	39.4550	26145.00	26145.00	0.00	249	31	930	336	2.76785714285714	0.199017409532966	0.199017409532966	false	false	false	true
852e8923-3745-4d4d-bd2b-516a3590ef15	2026-09-25 15:32	2026-09-25 15:32	2026-09-25 15:32	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5300	0.5300	0.5800	39.4601	79713.00	54.00	79659.00	1504	66	16041	3753	4.27418065547562	0.195542220932722	0.192829672327013	true	false	false	true
d572b681-8f24-4561-9f2b-1276e8345140	2026-09-25 15:31	2026-09-25 15:31	2026-09-25 15:31	XLU	XLU261120C00043000	call	43.0000	2026-11-20	0.2700	0.2600	0.2800	39.4500	14256.00	0.00	13527.00	528	26	21766	1392	15.6364942528736	0.203141437981762	0.202925170840427	false	false	false	true
12098273-c8dc-44e3-b899-c8db509c0bf4	2026-09-25 15:31	2026-09-25 15:31	2026-09-25 15:31	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.2700	0.2700	0.2900	39.4500	53190.00	0.00	53190.00	1970	39	89054	5014	17.761069006781	0.221606292230973	0.221606292230973	true	false	false	true
6e5adb15-db55-4ced-b2fd-08f976291554	2026-09-25 15:29	2026-09-25 15:29	2026-09-25 15:29	XLU	XLU261016C00039500	call	39.5000	2026-10-16	0.7700	0.7400	0.7800	39.4400	14014.00	14014.00	0.00	182	14	693	534	1.29775280898876	0.199984134616284	0.199984134616284	false	false	false	true
cfe52e4c-b6d6-4b6a-bd56-5e04f743c62d	2026-09-25 15:27	2026-09-25 15:27	2026-09-25 15:27	XLU	XLU281215C00040000	call	40.0000	2028-12-15	4.6500	4.6500	4.8000	39.4500	64635.00	0.00	64635.00	139	15	477	229	2.08296943231441	0.110641505548064	0.110641505548064	false	false	false	true
1ea04efc-0717-49cb-b14c-187d615fe336	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.6700	0.6700	0.6950	39.4550	10720.00	0.00	10720.00	160	13	16864	485	34.7711340206186	0.192270627916258	0.192270627916258	true	false	false	true
bbc89c0c-40c1-42a7-80a8-e1db24be79f7	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.6700	0.6700	0.7200	39.4550	97820.00	0.00	97820.00	1460	34	16704	485	34.4412371134021	0.192270627916258	0.192270627916258	true	false	false	true
d9956f7d-fcf7-4063-9f99-2df47d5a6f6a	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.6800	0.6700	0.6900	39.4550	52904.00	0.00	52836.00	778	12	15244	485	31.4309278350515	0.194017452978398	0.194017452978398	true	false	false	true