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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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 = XLE×

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

f6ab8ee4-75d2-406e-b6f8-6839dad8c544	2026-09-16 14:39	2026-09-16 14:39	2026-09-16 14:39	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5400	2.4400	2.5400	64.4150	11938.00	11938.00	0.00	47	10	817	15647	0.0522144820093309	0.280482858609991	0.280482858609991	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	43018974758.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
c5a9a896-e8e9-4879-8442-8edc67075547	2026-09-16 13:57	2026-09-16 13:57	2026-09-16 13:57	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.5300	0.5200	0.5300	64.0000	15158.00	15158.00	0.00	286	15	5938	37787	0.157143991319766	0.300956244234971	0.300956244234971	false	false	false	true
f1bf5d6a-5c6a-4667-9513-9d00145f1b6d	2026-09-16 13:55	2026-09-16 13:55	2026-09-16 13:55	XLE	XLE261002P00065000	put	65.0000	2026-10-02	1.8200	1.7500	1.8200	64.0000	18197.00	18197.00	0.00	100	7	122	1778	0.0686164229471316	0.317265378847544	0.311712208823824	false	false	false	true
a5d8bd5c-37b2-4ac2-a608-ce2fe583d326	2026-09-16 13:40	2026-09-16 13:40	2026-09-16 13:40	XLE	XLE270115P00050000	put	50.0000	2027-01-15	0.2700	0.2500	0.2800	64.6650	12609.00	12582.00	27.00	467	29	493	56836	0.00867407980857203	0.306929920399636	0.306929920399636	false	false	false	true
26ba927d-68fd-4ea8-aa78-ba04e4a78839	2026-09-16 13:38	2026-09-16 13:38	2026-09-16 13:38	XLE	XLE260925C00065000	call	65.0000	2026-09-25	0.8200	0.8150	0.8600	64.6300	50922.00	0.00	50922.00	621	16	1329	1387	0.958183129055516	0.237983862631428	0.237983862631428	true	false	false	true
0308fd47-5803-4a07-b270-021c7b1e6a12	2026-09-16 13:33	2026-09-16 13:33	2026-09-16 13:33	XLE	XLE260930C00065000	call	65.0000	2026-09-30	1.0600	1.0600	1.0700	64.6750	15900.00	0.00	12508.00	150	7	690	7202	0.0958067203554568	0.231159971570627	0.231159971570627	false	false	false	true
6f8f7e88-2e8c-4e63-b4c0-456a7e6923f1	2026-09-16 13:20	2026-09-16 13:20	2026-09-16 13:20	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.7400	0.7400	0.7600	64.6900	37000.00	0.00	37000.00	500	5	6176	19544	0.316004911993451	0.302930610691817	0.302930610691817	true	false	false	true
a7238306-22d2-416a-b87a-138159a375e5	2026-09-16 13:11	2026-09-16 13:11	2026-09-16 13:11	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.5300	0.5200	0.5300	64.6250	11395.00	11395.00	0.00	215	5	5563	37787	0.147219943366766	0.298776498908523	0.298776498908523	false	false	false	true
e248df91-d058-4297-bb45-74c2c891d484	2026-09-16 13:08	2026-09-16 13:08	2026-09-16 13:08	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.5200	0.5200	0.5400	64.7150	47528.00	0.00	47528.00	914	26	2709	37787	0.0716913224124699	0.299907077343111	0.299907077343111	true	false	false	true
0df903c6-d895-4506-a11f-ec40eff93bb6	2026-09-16 13:08	2026-09-16 13:08	2026-09-16 13:08	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.5200	0.5200	0.5300	64.7150	131300.00	0.00	131300.00	2525	11	5234	37787	0.138513245296001	0.299907077343111	0.299907077343111	true	false	false	true
f6c14522-a29d-4b75-b9f8-99f58042d6ea	2026-09-16 13:01	2026-09-16 13:01	2026-09-16 13:01	XLE	XLE261231C00065000	call	65.0000	2026-12-31	3.6600	3.6500	3.8000	64.6550	18312.00	0.00	18312.00	50	9	105	1932	0.0543478260869565	0.247227470512541	0.248870570335238	false	false	false	true
f71f02e6-bfc9-4b05-944d-1425b5d553e9	2026-09-16 12:57	2026-09-16 12:57	2026-09-16 12:57	XLE	XLE270115P00062500	put	62.5000	2027-01-15	2.8700	2.8200	2.8700	64.7050	37884.00	37884.00	0.00	132	17	158	2634	0.0599848139711465	0.291891701798394	0.291635990571655	false	false	false	true
504962e2-0c64-443e-a28a-50f6786d2d8c	2026-09-16 12:54	2026-09-16 12:54	2026-09-16 12:54	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.3500	0.3300	0.3500	64.7600	38395.00	38395.00	0.00	1097	25	20372	21744	0.936902133922002	0.328203049063558	0.328203049063558	false	false	false	true
e3e4f482-eb5f-4ce4-9231-5c9ee5cdd516	2026-09-16 12:52	2026-09-16 12:52	2026-09-16 12:52	XLE	XLE260918C00065000	call	65.0000	2026-09-18	0.5000	0.4900	0.5000	64.7800	24950.00	24950.00	0.00	499	26	3493	47643	0.0733161219906387	0.311770386384458	0.311770386384458	true	false	false	true
847ad8f7-8123-4e98-a6b0-bcacadad07cf	2026-09-16 12:14	2026-09-16 12:13	2026-09-16 12:13	XLE	XLE260918P00063000	put	63.0000	2026-09-18	0.1300	0.1300	0.1400	64.6500	34399.00	14.00	34385.00	2646	19	9308	16390	0.56790726052471	0.353401203495021	0.34457040708934	false	false	false	true
06a49fe9-36e2-4c86-a49e-8318e7838113	2026-09-16 12:14	2026-09-16 12:13	2026-09-16 12:13	XLE	XLE260921P00064000	put	64.0000	2026-09-21	0.6200	0.6100	0.6800	64.6500	14694.00	62.00	14632.00	237	5	270	116	2.32758620689655	0.307105025171942	0.307105025171942	false	false	false	true
21e71e95-cde4-4398-81bc-6778e03c3099	2026-09-16 11:49	2026-09-16 11:49	2026-09-16 11:49	XLE	XLE260916C00065000	call	65.0000	2026-09-16	0.0400	0.0300	0.0400	64.3150	14492.00	14492.00	0.00	3623	56	7012	223	31.4439461883408	0.431752075193618	0.431752075193618	false	false	false	true
9c5a9866-337e-45a5-81a5-1553d795cde3	2026-09-16 11:47	2026-09-16 11:47	2026-09-16 11:47	XLE	XLE260925P00063500	put	63.5000	2026-09-25	0.9200	0.8300	0.9300	64.2600	11592.00	11500.00	92.00	126	21	2919	2453	1.18997146351406	0.322383648722476	0.322383648722476	true	false	false	true
e61c835c-9baa-43df-a1d4-0de08b2ba1db	2026-09-16 11:47	2026-09-16 11:47	2026-09-16 11:47	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.8500	0.8300	0.8500	64.5162	34172.00	34172.00	0.00	403	16	4198	19544	0.21479738027016	0.303627231319012	0.306124153199271	true	false	false	true
ab42b86a-0d6f-4f21-8b03-eb6f3628f2bc	2026-09-16 11:35	2026-09-16 11:35	2026-09-16 11:35	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.3700	0.3700	0.3800	64.4550	74703.00	0.00	74703.00	2019	14	11928	21744	0.548565121412804	0.314112280800108	0.314112280800108	true	false	false	true
9e8ef428-3fd8-426e-95c3-931cfe4d954b	2026-09-16 11:35	2026-09-16 11:35	2026-09-16 11:35	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.3900	0.3900	0.4000	64.4299	59553.00	0.00	59553.00	1527	5	9901	21744	0.455344002943341	0.319261809187196	0.319261809187196	true	false	false	true
952d7c9d-baf0-4dce-b782-0fa5f050335d	2026-09-16 11:35	2026-09-16 11:35	2026-09-16 11:35	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.3900	0.3900	0.4000	64.4299	18447.00	0.00	18447.00	473	29	8374	21744	0.385117733627667	0.319261809187196	0.319261809187196	true	false	false	true
d0143ef8-4603-4968-a82d-71dc4caa14e2	2026-09-16 11:18	2026-09-16 11:18	2026-09-16 11:18	XLE	XLE260918P00063500	put	63.5000	2026-09-18	0.3100	0.2900	0.3100	64.2558	10788.00	10788.00	0.00	348	12	1048	8123	0.12901637326111	0.328872863119935	0.328872863119935	false	false	false	true
d945742a-94ac-4787-bf79-5c455cf27bbe	2026-09-16 11:16	2026-09-16 11:16	2026-09-16 11:16	XLE	XLE261120C00069000	call	69.0000	2026-11-20	1.2900	1.2100	1.2900	64.1950	17802.00	17802.00	0.00	138	14	145	146	0.993150684931507	0.264907159831187	0.264907159831187	true	false	false	true
31b1f2bf-1b70-4dd0-b36b-aea61fc09b75	2026-09-16 11:12	2026-09-16 11:12	2026-09-16 11:12	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.5000	0.5000	0.5100	63.9600	32250.00	0.00	32250.00	645	10	7889	21744	0.362812729948492	0.319807499893317	0.319807499893317	false	false	false	true
b2fe401d-63f1-4583-83d9-ea0f780daedb	2026-09-16 11:12	2026-09-16 11:12	2026-09-16 11:12	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.5000	0.5000	0.5200	63.9550	25850.00	0.00	25850.00	517	9	7243	21744	0.333103384841795	0.31941330943861	0.31941330943861	false	false	false	true
50457a25-276c-4c9b-9a55-f5bb0d3f9907	2026-09-16 11:12	2026-09-16 11:11	2026-09-16 11:11	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.5200	0.4900	0.5200	63.9150	26832.00	26832.00	0.00	516	6	6476	21744	0.297829286239882	0.322426080456475	0.322426080456475	true	false	false	true
74510a8f-2e2d-4f3b-b286-872fc56ed38f	2026-09-16 11:11	2026-09-16 11:11	2026-09-16 11:11	XLE	XLE260918P00064500	put	64.5000	2026-09-18	0.8800	0.8800	0.9100	63.9750	44000.00	0.00	44000.00	500	14	1066	2710	0.393357933579336	0.310811035348698	0.310811035348698	false	false	false	true
5788f885-48b5-4ccc-a115-b07a21755ccf	2026-09-16 11:10	2026-09-16 11:10	2026-09-16 11:10	XLE	XLE261218C00070000	call	70.0000	2026-12-18	1.5300	1.5300	1.5800	64.0000	12240.00	0.00	12240.00	80	6	133	7792	0.0170687885010267	0.265481170145011	0.265481170145011	false	false	false	true
006d0207-3f07-48a5-a223-c0c4e9a3f19a	2026-09-16 11:09	2026-09-16 11:09	2026-09-16 11:09	XLE	XLE260918C00066000	call	66.0000	2026-09-18	0.0800	0.0800	0.0900	63.9000	16936.00	0.00	16936.00	2117	30	5137	17990	0.285547526403558	0.342060970692583	0.342060970692583	false	false	false	true
deee012b-2cad-416e-8992-1d4315caed44	2026-09-16 11:09	2026-09-16 11:09	2026-09-16 11:09	XLE	XLE261016P00064000	put	64.0000	2026-10-16	2.1000	2.0700	2.1200	63.9600	14700.00	8400.00	6300.00	70	8	2544	22373	0.113708487909534	0.298784280708911	0.298784280708911	true	false	false	true
a00d32c9-a5f6-48ef-8dd7-b2ea763ba507	2026-09-16 11:07	2026-09-16 11:07	2026-09-16 11:07	XLE	XLE260925P00063500	put	63.5000	2026-09-25	1.0500	1.0400	1.0500	64.0200	17115.00	17115.00	0.00	163	5	1467	2453	0.598043212392988	0.330782127466736	0.330782127466736	false	false	false	true
487cac3f-ad5c-4135-9e79-9628a4d8188a	2026-09-16 11:07	2026-09-16 11:07	2026-09-16 11:07	XLE	XLE270617C00067500	call	67.5000	2027-06-17	4.7000	4.6500	4.7000	64.0500	18330.00	18330.00	0.00	39	10	143	23895	0.00598451558903536	0.2378037590464	0.2378037590464	false	false	false	true
53906ef0-2de5-4a43-b975-134fd58b0081	2026-09-16 11:03	2026-09-16 11:03	2026-09-16 11:03	XLE	XLE261016P00064000	put	64.0000	2026-10-16	2.0000	2.0000	2.0400	64.1100	50000.00	0.00	50000.00	250	9	1963	22373	0.0877396862289367	0.294645415047427	0.294645415047427	false	false	false	true
d6b23448-021f-4d31-b800-fe8e395d0cd1	2026-09-16 11:01	2026-09-16 11:01	2026-09-16 11:01	XLE	XLE260925C00065000	call	65.0000	2026-09-25	0.6700	0.6400	0.6800	64.1400	27135.00	27135.00	0.00	405	9	582	1387	0.419610670511896	0.252140370850795	0.252140370850795	false	false	false	true
c4b68f29-b5e9-4737-bd6e-df7545088fc0	2026-09-16 11:00	2026-09-16 11:00	2026-09-16 11:00	XLE	XLE270319P00059000	put	59.0000	2027-03-19	2.2200	2.2200	2.2300	64.0900	15540.00	0.00	15540.00	70	5	224	4122	0.054342552159146	0.275677002065737	0.275677002065737	false	false	false	true
06b2a2a7-5f79-4093-8685-c44f752cbb66	2026-09-16 11:00	2026-09-16 11:00	2026-09-16 11:00	XLE	XLE270319P00059000	put	59.0000	2027-03-19	2.2300	2.1200	2.2300	64.0850	19176.00	18954.00	222.00	86	20	154	4122	0.0373605046094129	0.276261464156683	0.276261464156683	false	false	false	true
ec1941a8-d4c5-414c-93e4-a47e78704fc9	2026-09-16 10:59	2026-09-16 10:59	2026-09-16 10:59	XLE	XLE270319P00059000	put	59.0000	2027-03-19	2.2300	2.1200	2.2300	64.1150	15164.00	15164.00	0.00	68	13	68	4122	0.0164968461911693	0.276793106459447	0.276793106459447	false	false	false	true
f3a5062c-fe15-4bac-b3da-af1d2eabb5b9	2026-09-16 10:58	2026-09-16 10:58	2026-09-16 10:58	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5500	2.4800	2.5500	64.2450	22440.00	22440.00	0.00	88	17	571	15647	0.0364926183933022	0.277989717580038	0.277989717580038	false	false	false	true
8a953350-08c0-41af-99c9-77ac074d3596	2026-09-16 10:58	2026-09-16 10:58	2026-09-16 10:58	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.4500	6.4500	6.6000	64.2450	58050.00	0.00	58050.00	90	7	157	28129	0.00558142841906929	0.234373512281081	0.234373512281081	false	false	false	true
dc6432d6-b0ef-4ef3-a4b1-dfecd2daa7f6	2026-09-16 10:58	2026-09-16 10:58	2026-09-16 10:58	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5500	2.4800	2.5500	64.2650	17595.00	17595.00	0.00	69	14	483	15647	0.0308685370997635	0.278360118315113	0.278360118315113	false	false	false	true
65b520b5-e557-4bbb-9ef0-5fb8f403d44f	2026-09-16 10:57	2026-09-16 10:57	2026-09-16 10:57	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.9700	0.9300	0.9700	64.3400	56357.00	56357.00	0.00	581	6	2229	19544	0.114050347932869	0.311802015918574	0.309895375955128	true	false	false	true
6386f3a2-215b-41c1-9d0b-7827c9baba4f	2026-09-16 10:50	2026-09-16 10:50	2026-09-16 10:50	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5500	2.4800	2.5500	64.2700	17340.00	17340.00	0.00	68	15	405	15647	0.0258835559532179	0.27845266081762	0.27845266081762	false	false	false	true
4792a2f4-e7c4-42cb-b122-90f616ef45f0	2026-09-16 10:46	2026-09-16 10:46	2026-09-16 10:46	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5500	2.4800	2.5500	64.3250	17595.00	17595.00	0.00	69	11	307	15647	0.0196203745126861	0.279469111673	0.279469111673	false	false	false	true
25ab45f3-f3c1-4fc6-8e27-3edb01a8df2a	2026-09-16 10:46	2026-09-16 10:46	2026-09-16 10:46	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.9800	0.9500	0.9800	64.3350	41552.00	41552.00	0.00	424	5	1609	19544	0.0823270568972575	0.313740707043719	0.313740707043719	true	false	false	true
c02731e4-15ca-4708-b946-ba315a9fbaf3	2026-09-16 10:45	2026-09-16 10:45	2026-09-16 10:45	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5500	2.4800	2.5500	64.3600	16575.00	16575.00	0.00	65	14	211	15647	0.013485013101553	0.280114503175654	0.280114503175654	false	false	false	true
29b47256-fb85-407f-adfc-3141f77a75f8	2026-09-16 10:45	2026-09-16 10:45	2026-09-16 10:45	XLE	XLE270115C00065000	call	65.0000	2027-01-15	3.7500	3.7500	3.9000	64.3600	30035.00	2660.00	27375.00	80	14	350	33197	0.0105431213663885	0.245720326011331	0.245720326011331	false	false	false	true
328dea48-836e-4427-a785-1ca2aff81e3d	2026-09-16 10:34	2026-09-16 10:34	2026-09-16 10:34	XLE	XLE280121P00045000	put	45.0000	2028-01-21	0.8700	0.8700	0.9300	64.5200	40020.00	0.00	40020.00	460	11	860	1530	0.562091503267974	0.290209180259283	0.290209180259283	false	false	false	true
6cd04a3a-c529-43b0-b2c6-c190d80833da	2026-09-16 10:31	2026-09-16 10:31	2026-09-16 10:31	XLE	XLE261016C00062000	call	62.0000	2026-10-16	3.4500	3.3000	3.5000	64.0000	15180.00	14835.00	345.00	44	9	45	7216	0.00623614190687361	0.239665874437496	0.237112500071915	true	false	false	true
17d09547-b8a4-4882-ae3f-7c2bfc77d702	2026-09-16 10:28	2026-09-16 10:28	2026-09-16 10:28	XLE	XLE270115P00060000	put	60.0000	2027-01-15	2.0100	1.9000	2.0400	64.0000	649834.00	649633.00	201.00	3233	46	3241	26658	0.121577012529072	0.289436555664029	0.29001735298211	true	false	false	true