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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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

ae3a91d9-b25e-40bf-8356-5575d189bf97	2026-09-21 14:43	2026-09-21 14:43	2026-09-21 14:43	XLE	XLE261016P00061500	put	61.5000	2026-10-16	1.0400	1.0200	1.0500	62.9600	10729.00	10729.00	0.00	103	7	6287	0	0	0.269147562334123	0.267211600355058	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	41312140321.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T18:46:35.766190Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
5eece057-910f-42bd-bb09-05ad31842064	2026-09-21 14:43	2026-09-21 14:43	2026-09-21 14:43	XLE	XLE261016C00064500	call	64.5000	2026-10-16	1.1500	1.1200	1.1500	62.9600	19665.00	19665.00	0.00	171	5	387	0	0	0.263173297950229	0.263173297950229	false	false	false	true
832ae459-a757-4c8f-8326-6859c7747ad4	2026-09-21 14:33	2026-09-21 14:33	2026-09-21 14:33	XLE	XLE261218P00064000	put	64.0000	2026-12-18	3.6000	3.5500	3.6000	62.9150	118080.00	118080.00	0.00	328	26	361	2887	0.1250432975407	0.272721542285465	0.272721542285465	true	false	false	true
919ba3d2-207e-4407-b0e5-36e1da9d80e3	2026-09-21 14:17	2026-09-21 14:17	2026-09-21 14:17	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.5000	1.4800	1.5000	62.8850	97050.00	97050.00	0.00	647	19	1597	19916	0.0801867844948785	0.257900779638143	0.257900779638143	false	false	false	true
d640bf37-c8ab-4e1e-a649-aca513fdf77c	2026-09-21 14:12	2026-09-21 14:12	2026-09-21 14:12	XLE	XLE261016P00059000	put	59.0000	2026-10-16	0.4300	0.4300	0.4400	62.8350	10750.00	0.00	10750.00	250	21	534	15627	0.0341716260318679	0.275208780377168	0.275208780377168	true	false	false	true
c2120c66-6533-4ec0-ab0c-efc86c872974	2026-09-21 14:11	2026-09-21 14:11	2026-09-21 14:11	XLE	XLE260923C00063000	call	63.0000	2026-09-23	0.4000	0.3900	0.4100	62.8300	15968.00	15568.00	400.00	398	52	1717	345	4.9768115942029	0.255181136832624	0.260610051685188	false	false	false	true
a3db3fa0-97a8-46cc-a28f-215bbc3b97d4	2026-09-21 14:09	2026-09-21 14:08	2026-09-21 14:08	XLE	XLE260923C00063000	call	63.0000	2026-09-23	0.3900	0.3900	0.4000	62.0000	15600.00	0.00	15600.00	400	21	1319	345	3.8231884057971	0.243595280506588	0.243595280506588	false	false	false	true
aa4acf64-7481-43d1-9f83-d9070f048477	2026-09-21 13:59	2026-09-21 13:59	2026-09-21 13:59	XLE	XLE270319C00071000	call	71.0000	2027-03-19	2.0600	1.9800	2.0700	62.8050	17716.00	13596.00	4120.00	86	8	87	147	0.591836734693878	0.253473906490674	0.253473906490674	false	false	false	true
7116cf9f-1732-432d-a8c6-11a6e159c8bd	2026-09-21 13:59	2026-09-21 13:58	2026-09-21 13:58	XLE	XLE260923C00063000	call	63.0000	2026-09-23	0.3900	0.3700	0.3900	62.8150	11934.00	11934.00	0.00	306	21	832	345	2.41159420289855	0.253404146182158	0.253404146182158	false	false	false	true
c75238a5-d07b-469c-98c9-17c500c5001c	2026-09-21 13:57	2026-09-21 13:57	2026-09-21 13:57	XLE	XLE261016C00065000	call	65.0000	2026-10-16	0.9000	0.8900	0.9100	62.7750	65430.00	51930.00	13500.00	727	19	2523	18261	0.13816329883358	0.260581911970967	0.260581911970967	true	false	false	true
19a8b853-099c-4d77-b661-e864a7ac5974	2026-09-21 13:56	2026-09-21 13:56	2026-09-21 13:56	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.8300	1.8300	1.8400	62.8050	11346.00	0.00	11346.00	62	16	3003	51079	0.0587912840893518	0.271911691001033	0.271911691001033	false	false	false	true
1d469068-28eb-4170-994d-7140e813e838	2026-09-21 13:49	2026-09-21 13:48	2026-09-21 13:48	XLE	XLE271217C00057500	call	57.5000	2027-12-17	10.7500	10.7500	10.8000	62.7500	31175.00	0.00	31175.00	29	29	82	62627	0.0013093394222939	0.210658648542308	0.210658648542308	false	false	false	true
67830fe5-0845-4986-9fd5-069208c5f38e	2026-09-21 13:49	2026-09-21 13:48	2026-09-21 13:48	XLE	XLE271217C00057500	call	57.5000	2027-12-17	10.7500	10.7500	10.8000	62.7500	56975.00	0.00	56975.00	53	53	53	62627	0.00084628035831191	0.210658648542308	0.210658648542308	false	false	false	true
d6b35fab-4e5c-40d1-813b-3697b879b683	2026-09-21 13:47	2026-09-21 13:47	2026-09-21 13:47	XLE	XLE260925C00063000	call	63.0000	2026-09-25	0.6600	0.6500	0.6600	62.7650	13200.00	13200.00	0.00	200	9	666	128	5.203125	0.289196887055109	0.289196887055109	false	false	false	true
44cd39d2-f213-42d8-abb4-225fe0392a3f	2026-09-21 13:41	2026-09-21 13:40	2026-09-21 13:40	XLE	XLE261016C00066500	call	66.5000	2026-10-16	0.5100	0.5100	0.5200	62.7150	54162.00	0.00	54162.00	1062	19	8140	0	0	0.260443830493987	0.260443830493987	false	false	false	true
c052ccfe-3fbc-49b4-8744-2ae29589c467	2026-09-21 13:34	2026-09-21 13:34	2026-09-21 13:34	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.8300	1.8300	1.8500	62.0000	13542.00	0.00	13542.00	74	17	2802	51079	0.0548562031363183	0.269553068574591	0.269553068574591	false	false	false	true
4c730b50-7ddb-4427-95b3-632f66485849	2026-09-21 13:34	2026-09-21 13:34	2026-09-21 13:34	XLE	XLE261120P00054000	put	54.0000	2026-11-20	0.2800	0.2800	0.2900	62.0000	17976.00	0.00	17976.00	642	18	1892	16	118.25	0.287353635099157	0.287353635099157	false	false	false	true
6cbece58-d421-4892-9994-27c33b3fea7e	2026-09-21 13:31	2026-09-21 13:31	2026-09-21 13:31	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.8300	1.8300	1.8400	62.7400	10248.00	0.00	10248.00	56	13	2726	51079	0.0533683118306936	0.26989661021633	0.270040870208241	false	false	false	true
7f303f94-4065-42c2-81d7-f642a1059168	2026-09-21 13:30	2026-09-21 13:30	2026-09-21 13:30	XLE	XLE261120P00054000	put	54.0000	2026-11-20	0.2900	0.2900	0.3100	62.7050	36250.00	0.00	36250.00	1250	39	1250	16	78.125	0.28953848416471	0.28953848416471	false	false	false	true
55ef92f8-4d26-492b-a387-0eec6ac64bd2	2026-09-21 13:28	2026-09-21 13:28	2026-09-21 13:28	XLE	XLE261016C00066000	call	66.0000	2026-10-16	0.6000	0.6000	0.6100	62.6600	61380.00	0.00	61380.00	1023	8	2018	8006	0.252060954284287	0.260004506166669	0.260004506166669	false	false	false	true
ac8d3b88-4171-4f21-9105-a828761e96a1	2026-09-21 13:23	2026-09-21 13:23	2026-09-21 13:23	XLE	XLE261016C00065500	call	65.5000	2026-10-16	0.7100	0.7100	0.7200	62.0000	62764.00	0.00	62764.00	884	18	1655	0	0	0.259122473998859	0.259122473998859	false	false	false	true
11447ca3-e159-42d0-8d02-82d371ca5268	2026-09-21 13:10	2026-09-21 13:10	2026-09-21 13:10	XLE	XLE261016P00058000	put	58.0000	2026-10-16	0.3200	0.3100	0.3200	62.6000	30944.00	30944.00	0.00	967	29	7697	12693	0.606397226817931	0.281294280004913	0.281294280004913	true	false	false	true
7ac460df-96ba-4a10-9cf3-8a8fe16066f9	2026-09-21 13:08	2026-09-21 13:08	2026-09-21 13:08	XLE	XLE261016C00066500	call	66.5000	2026-10-16	0.5000	0.4900	0.5100	62.6250	99950.00	1350.00	98600.00	1999	6	6916	0	0	0.262379488504405	0.262379488504405	false	false	false	true
6050b32f-c755-4465-8156-248886d3908b	2026-09-21 13:08	2026-09-21 13:08	2026-09-21 13:08	XLE	XLE261016C00066000	call	66.0000	2026-10-16	0.6000	0.5900	0.6100	62.6400	13920.00	1560.00	12360.00	232	12	602	8006	0.0751936047964027	0.260955237678862	0.260955237678862	false	false	false	true
c982b553-b319-4643-abb3-0d5bdcca6056	2026-09-21 13:07	2026-09-21 13:07	2026-09-21 13:07	XLE	XLE261016C00067000	call	67.0000	2026-10-16	0.4200	0.4200	0.4300	62.6650	22134.00	0.00	22134.00	527	9	838	22648	0.0370010596962204	0.262705304705471	0.262705304705471	false	false	false	true
7ab80a41-22e3-4877-b85a-bbb57b68d381	2026-09-21 13:01	2026-09-21 13:01	2026-09-21 13:01	XLE	XLE260923P00062000	put	62.0000	2026-09-23	0.2600	0.2500	0.2700	62.6750	36608.00	0.00	35048.00	1408	21	10610	6594	1.60903851986655	0.290812385470879	0.290812385470879	false	false	false	true
8a7f2f7a-cb1b-4981-b48e-f3159f521a93	2026-09-21 12:57	2026-09-21 12:57	2026-09-21 12:57	XLE	XLE260923C00064000	call	64.0000	2026-09-23	0.1100	0.1000	0.1200	62.6103	12276.00	0.00	11275.00	1116	22	1914	494	3.87449392712551	0.289531980549194	0.289531980549194	false	false	false	true
634758e3-3963-4c52-862e-cf29dd94c5c4	2026-09-21 12:51	2026-09-21 12:51	2026-09-21 12:51	XLE	XLE261218C00064000	call	64.0000	2026-12-18	2.9200	2.9100	2.9700	62.0000	16352.00	0.00	16060.00	56	10	236	1922	0.122788761706556	0.266904963053533	0.266904963053533	false	false	false	true
5b6044c7-4068-4339-8ec0-2cd331112202	2026-09-21 12:49	2026-09-21 12:48	2026-09-21 12:48	XLE	XLE261120P00063000	put	63.0000	2026-11-20	2.6600	2.6400	2.6600	62.6250	45752.00	45752.00	0.00	172	22	1114	421	2.64608076009501	0.265200789004358	0.265200789004358	false	false	false	true
b5d79121-dc2b-48b2-b556-63eff62cef3a	2026-09-21 12:49	2026-09-21 12:48	2026-09-21 12:48	XLE	XLE260925P00064000	put	64.0000	2026-09-25	1.6200	1.6200	1.6400	62.6250	162000.00	0.00	162000.00	1000	20	1612	5101	0.316016467359341	0.289420833513676	0.289420833513676	false	false	false	true
9c43baec-913a-4ff6-b291-33cbedf21965	2026-09-21 12:45	2026-09-21 12:45	2026-09-21 12:45	XLE	XLE261120P00063000	put	63.0000	2026-11-20	2.6600	2.6500	2.6700	62.6250	38570.00	36708.00	0.00	145	5	942	421	2.2375296912114	0.265200789004358	0.265200789004358	false	false	false	true
7bdb4d68-8345-4d81-b703-2e8d66f6fdc8	2026-09-21 12:31	2026-09-21 12:31	2026-09-21 12:31	XLE	XLE261016P00058000	put	58.0000	2026-10-16	0.3200	0.3100	0.3200	62.0000	18624.00	18624.00	0.00	582	7	6364	12693	0.501378712676278	0.281861205814921	0.281861205814921	true	false	false	true
8c7b6c9a-d08a-4abc-b652-5a132688dff9	2026-09-21 12:31	2026-09-21 12:31	2026-09-21 12:31	XLE	XLE261016C00064000	call	64.0000	2026-10-16	1.1900	1.1800	1.1900	62.0000	83300.00	83300.00	0.00	700	10	4234	3746	1.13027229044314	0.261924267303635	0.261924267303635	true	false	false	true
142612e8-cef5-43ae-97d5-044b70371b44	2026-09-21 12:27	2026-09-21 12:26	2026-09-21 12:26	XLE	XLE261016P00064000	put	64.0000	2026-10-16	2.3700	2.3700	2.3800	62.6250	48585.00	0.00	48585.00	205	7	452	21831	0.0207045027712885	0.257945421527757	0.257945421527757	false	false	false	true
fd6dfb26-6571-4e38-ac14-3f6258472036	2026-09-21 12:24	2026-09-21 12:24	2026-09-21 12:24	XLE	XLE261120C00065000	call	65.0000	2026-11-20	1.8500	1.8200	1.8500	62.5600	46250.00	46250.00	0.00	250	19	815	30607	0.0266278955794426	0.266251514759509	0.266251514759509	false	false	false	true
7671db84-1048-49a9-beb8-72c24f8554ca	2026-09-21 12:20	2026-09-21 12:20	2026-09-21 12:20	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.9200	2.9000	2.9200	62.0000	523264.00	523264.00	0.00	1792	6	1879	60583	0.0310153013221531	0.266222869593356	0.266222869593356	false	false	false	true
2d3903f2-7688-4170-9b7f-e61d2c391a71	2026-09-21 12:19	2026-09-21 12:19	2026-09-21 12:19	XLE	XLE261016P00058000	put	58.0000	2026-10-16	0.3200	0.3100	0.3200	62.0000	30368.00	30368.00	0.00	949	40	5672	12693	0.446860474277161	0.280726885590774	0.280726885590774	true	false	false	true
3d9792c8-7e40-4e63-825d-2aeeffb80173	2026-09-21 12:16	2026-09-21 12:16	2026-09-21 12:16	XLE	XLE261016C00064000	call	64.0000	2026-10-16	1.1900	1.1700	1.1900	62.6250	61730.00	61730.00	0.00	520	19	1577	3746	0.42098238120662	0.261288477058135	0.261288477058135	true	false	false	true
d70f3e10-b93d-475f-9ddd-b93a525cb216	2026-09-21 12:12	2026-09-21 12:12	2026-09-21 12:12	XLE	XLE280121C00057500	call	57.5000	2028-01-21	10.7000	10.6500	10.9000	62.5500	71691.00	0.00	70621.00	67	11	133	1223	0.10874897792314	0.199855230145117	0.199855230145117	false	false	false	true
8e6bcbdb-a2e5-4200-868f-7c86562d06e3	2026-09-21 12:12	2026-09-21 12:12	2026-09-21 12:12	XLE	XLE280121P00057500	put	57.5000	2028-01-21	3.9900	3.8000	4.0000	62.5500	25560.00	25560.00	0.00	64	8	64	1126	0.0568383658969805	0.281320892205546	0.281320892205546	false	false	false	true
791dcc58-9d7b-40ef-a7bf-6c40cfe7d65c	2026-09-21 12:11	2026-09-21 12:11	2026-09-21 12:11	XLE	XLE260925C00063500	call	63.5000	2026-09-25	0.4100	0.4000	0.4100	62.5700	12669.00	12669.00	0.00	309	8	673	497	1.35412474849095	0.2961864705155	0.2961864705155	true	false	false	true
84737558-9bc5-4441-9b4a-22de7c2d33f5	2026-09-21 12:11	2026-09-21 12:11	2026-09-21 12:11	XLE	XLE260923P00062000	put	62.0000	2026-09-23	0.3200	0.3000	0.3200	62.5950	96000.00	96000.00	0.00	3000	29	8731	6594	1.32408249924173	0.311848913822321	0.311848913822321	true	false	false	true
3737f028-4d34-4279-b21c-95eda9ed1c1b	2026-09-21 12:06	2026-09-21 12:06	2026-09-21 12:06	XLE	XLE261002C00065000	call	65.0000	2026-10-02	0.4000	0.4000	0.4100	62.7500	64920.00	0.00	64920.00	1623	16	6439	362	17.7872928176796	0.267391714768482	0.267391714768482	false	false	false	true
ecf6331b-c669-4964-8c59-1e6f904a092a	2026-09-21 12:04	2026-09-21 12:04	2026-09-21 12:04	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.8200	1.8100	1.8200	62.7300	225862.00	225862.00	0.00	1241	17	2590	51079	0.0507057694943127	0.268839961664293	0.268839961664293	true	false	false	true
ba22b8c4-730c-484f-a316-f3eba7f0d25d	2026-09-21 12:01	2026-09-21 12:01	2026-09-21 12:01	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.8000	1.7600	1.8000	62.8050	189180.00	189180.00	0.00	1051	13	1340	51079	0.0262338730202236	0.269168167305068	0.269168167305068	true	false	false	true
18d0026f-19db-4e41-a0d5-537e9f010358	2026-09-21 12:01	2026-09-21 12:01	2026-09-21 12:01	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.8000	1.7600	1.8000	62.8050	35820.00	35820.00	0.00	199	34	289	51079	0.00565790246480941	0.269168167305068	0.269168167305068	true	false	false	true
a3332f4a-0452-496b-8eaa-475c398ff729	2026-09-21 11:55	2026-09-21 11:55	2026-09-21 11:55	XLE	XLE281215P00046000	put	46.0000	2028-12-15	1.9500	1.8700	1.9500	62.8200	11700.00	11700.00	0.00	60	13	128	1500	0.0853333333333333	0.290434741540824	0.290434741540824	false	false	false	true
c901ed5f-3539-42f8-87d6-19ebfb26ab1a	2026-09-21 11:55	2026-09-21 11:55	2026-09-21 11:55	XLE	XLE270115P00062500	put	62.5000	2027-01-15	3.3000	3.2500	3.3000	62.8250	14850.00	14850.00	0.00	45	8	142	2827	0.050229925716307	0.275517658532876	0.275517658532876	false	false	false	true
8b5c3747-d1fb-4d93-80c8-f7949f4c57aa	2026-09-21 11:54	2026-09-21 11:54	2026-09-21 11:54	XLE	XLE281215P00046000	put	46.0000	2028-12-15	1.9400	1.8700	1.9400	62.8250	13192.00	13192.00	0.00	68	10	68	1500	0.0453333333333333	0.289930901944058	0.289930901944058	false	false	false	true
25a5cfc3-82c1-471e-9b8b-c1d938f01eaf	2026-09-21 11:50	2026-09-21 11:50	2026-09-21 11:50	XLE	XLE261120P00063000	put	63.0000	2026-11-20	2.5700	2.5600	2.6000	62.8100	11308.00	0.00	11308.00	44	5	593	421	1.40855106888361	0.264903981144961	0.264903981144961	true	false	false	true