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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_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	expirydate

1d276100-dd07-42ae-b1ea-22adb86929cf	2026-09-21 15:21	2026-09-21 15:21	2026-09-21 15:21	XLE	XLE261231P00060000	put	60.0000	2026-12-31	2.1300	1.9900	2.1300	62.6750	12135.00	12135.00	0.00	57	6	342	312	1.09615384615385	0.278121224869993	0.278121224869993	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	41312140321.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:25:50.208697Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
245e4a18-ef03-4d47-91dd-4f0e3e93fc1e	2026-09-21 15:09	2026-09-21 15:09	2026-09-21 15:09	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.5000	1.4700	1.5000	62.7500	168600.00	168600.00	0.00	1124	7	2749	19916	0.138029724844346	0.261087571771111	0.261087571771111	false	false	false	true
b8eb19a9-66d7-4cbe-94e3-b900749883cf	2026-09-21 15:09	2026-09-21 15:08	2026-09-21 15:08	XLE	XLE261016C00065000	call	65.0000	2026-10-16	0.9600	0.9500	0.9600	62.7850	30336.00	30336.00	0.00	316	33	3937	18261	0.215596079075626	0.270048453905935	0.270048453905935	true	false	false	true
3a99655e-e2a3-45ec-8122-999186c6dca3	2026-09-21 15:08	2026-09-21 15:08	2026-09-21 15:08	XLE	XLE260925C00063000	call	63.0000	2026-09-25	0.7100	0.7100	0.7200	62.7950	10792.00	0.00	10792.00	152	5	1076	128	8.40625	0.302974370523673	0.302974370523673	false	false	false	true
327753ab-2fc7-4fc9-b4d4-6ba25f083ba7	2026-09-21 15:08	2026-09-21 15:08	2026-09-21 15:08	XLE	XLE260925C00063000	call	63.0000	2026-09-25	0.7100	0.7100	0.7200	62.7950	13703.00	0.00	13703.00	193	8	924	128	7.21875	0.302974370523673	0.302974370523673	false	false	false	true
df1d55f3-2126-48ef-906f-b20102ffc96f	2026-09-21 15:07	2026-09-21 15:07	2026-09-21 15:07	XLE	XLE261218C00066000	call	66.0000	2026-12-18	2.3000	2.3000	2.3400	62.8350	10350.00	0.00	10350.00	45	10	152	3528	0.0430839002267574	0.271758739010003	0.271758739010003	false	false	false	true
13bbab3d-4b7e-4831-87e1-6cc327883ab9	2026-09-21 15:07	2026-09-21 15:07	2026-09-21 15:07	XLE	XLE270115P00045000	put	45.0000	2027-01-15	0.1000	0.0900	0.1000	62.8324	19190.00	19190.00	0.00	1919	21	8362	55846	0.149733194857286	0.320888906402384	0.320888906402384	true	false	false	true
1f08ffb5-5c82-4288-94f7-3faca3e449dc	2026-09-21 15:07	2026-09-21 15:06	2026-09-21 15:06	XLE	XLE270115P00045000	put	45.0000	2027-01-15	0.1000	0.0800	0.1000	62.8750	18900.00	18900.00	0.00	1890	35	6410	55846	0.114779930523225	0.321393494071119	0.321393494071119	true	false	false	true
dc32551c-9fb7-472b-b680-3167fe5fc959	2026-09-21 15:06	2026-09-21 15:06	2026-09-21 15:06	XLE	XLE261016C00065000	call	65.0000	2026-10-16	0.9700	0.9600	0.9700	62.8650	44135.00	43553.00	0.00	455	10	3553	18261	0.194567657850063	0.267185399957587	0.267185399957587	true	false	false	true
b67d3cd6-11f2-4ead-8188-f7a027e498a9	2026-09-21 15:06	2026-09-21 15:06	2026-09-21 15:06	XLE	XLE261016C00065000	call	65.0000	2026-10-16	0.9700	0.9600	0.9700	62.8699	47724.00	47724.00	0.00	492	46	3098	18261	0.169651169158316	0.266907387174649	0.266907387174649	true	false	false	true
4a8c4e33-3908-4244-a5b1-c59ad3971a17	2026-09-21 14:59	2026-09-21 14:59	2026-09-21 14:59	XLE	XLE261030P00063000	put	63.0000	2026-10-30	2.0800	2.0400	2.0800	62.8900	98800.00	98800.00	0.00	475	30	597	157	3.80254777070064	0.264010835014374	0.264010835014374	false	false	false	true
6bef7cfa-c2c9-4085-bdce-d5c7fad7ad1f	2026-09-21 14:55	2026-09-21 14:55	2026-09-21 14:55	XLE	XLE270115P00062500	put	62.5000	2027-01-15	3.3000	3.2500	3.3000	62.9300	39600.00	39600.00	0.00	120	15	442	2827	0.156349487088787	0.278698074862914	0.278698074862914	false	false	false	true
1fdc79a3-2c15-4e1f-b592-ea7b816fc6c9	2026-09-21 14:51	2026-09-21 14:51	2026-09-21 14:51	XLE	XLE270115P00045000	put	45.0000	2027-01-15	0.0900	0.0800	0.0900	62.9550	12357.00	12357.00	0.00	1373	13	3374	55846	0.060416144397092	0.316812290643725	0.316812290643725	true	false	false	true
6bd7768a-551f-469a-b2c8-ce40000b6b92	2026-09-21 14:49	2026-09-21 14:49	2026-09-21 14:49	XLE	XLE270115P00045000	put	45.0000	2027-01-15	0.0900	0.0900	0.1000	62.0000	13869.00	0.00	36.00	1541	95	1572	55846	0.0281488378755864	0.316987425675548	0.316987425675548	false	false	false	true
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
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	false
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