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:ticker = XLE×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	price

2a490242-0be4-43bd-a1bb-7a29600cf3e1	2026-08-20 09:40	2026-08-20 09:39	2026-08-20 09:39	XLE	XLE260918C00067500	call	67.5000	2026-09-18	0.8200	0.7500	0.8200	64.5900	39278.00	39278.00	0.00	479	33	488	9606	0.0508015823443681	0.252322634339236	0.252322634339236	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	42266645050.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a60dc3a5-5adb-402c-88f3-de688f8f00a5	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.7500	1.7100	1.7500	64.6600	22225.00	22225.00	0.00	127	7	245	52275	0.00468675274988044	0.250334635855753	0.250334635855753	false	false	false	true	false
1844b3f4-f70f-4964-b7a5-5b17d143291a	2026-08-20 09:45	2026-08-20 09:45	2026-08-20 09:45	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.5000	4.4000	4.5000	64.5050	112500.00	84150.00	0.00	250	12	795	58525	0.0135839384878257	0.542804354584811	0.542804354584811	false	false	false	true	false
f1eb8df4-80be-4dd8-b445-f927fbc1d52f	2026-08-20 09:45	2026-08-20 09:45	2026-08-20 09:45	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.5600	4.5500	4.6500	64.5500	56981.00	0.00	56981.00	125	5	1045	58525	0.0178556172575822	0.943592258020428	0.943592258020428	false	false	false	true	false
4a08a0b6-58f9-4289-be12-475373ae83db	2026-08-20 09:45	2026-08-20 09:45	2026-08-20 09:45	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.5500	4.4500	4.5500	64.5300	56420.00	56420.00	0.00	124	12	920	58525	0.015719777872704	0.661963227154653	0.661963227154653	true	false	false	true	false
ca416e5c-4dcc-4413-8ecf-dff43dde9113	2026-08-20 09:56	2026-08-20 09:55	2026-08-20 09:55	XLE	XLE261120P00065000	put	65.0000	2026-11-20	3.4400	3.4000	3.5500	64.4000	275200.00	0.00	275200.00	800	2	801	1340	0.597761194029851	0.268226618976774	0.268226618976774	false	true	true	false	false
c097dac5-aa37-4576-b1aa-eb50e4abf729	2026-08-20 10:05	2026-08-20 10:05	2026-08-20 10:05	XLE	XLE261218C00065000	call	65.0000	2026-12-18	3.8500	3.8000	3.8500	64.5699	124355.00	124355.00	0.00	323	29	413	40003	0.0103242256830738	0.248067387250774	0.248067387250774	true	false	false	true	false
99eb8800-1ced-4a55-a7ed-f35bd71c80b6	2026-08-20 10:05	2026-08-20 10:05	2026-08-20 10:05	XLE	XLE261218C00065000	call	65.0000	2026-12-18	3.8500	3.8000	3.9000	64.5699	118580.00	99715.00	16940.00	308	5	721	40003	0.018023648226383	0.248067387250774	0.248067387250774	true	false	false	true	false
31dee4c9-9877-4b65-bc2e-af60e6997867	2026-08-20 10:05	2026-08-20 10:05	2026-08-20 10:05	XLE	XLE261218C00080000	call	80.0000	2026-12-18	0.5400	0.5200	0.5500	64.5750	27162.00	19710.00	7236.00	503	7	1519	4628	0.328219533275713	0.275482200027684	0.275482200027684	true	false	false	true	false
d161ef61-c437-49ce-9a45-dc31bdb9e9dc	2026-08-20 10:06	2026-08-20 10:06	2026-08-20 10:06	XLE	XLE260918P00065000	put	65.0000	2026-09-18	1.9300	1.9300	1.9800	64.5350	13896.00	0.00	13896.00	72	23	89	220	0.404545454545455	0.246391351483205	0.246391351483205	false	false	false	true	false
837e655a-040b-48e2-9142-2d8d698a13af	2026-08-20 10:07	2026-08-20 10:06	2026-08-20 10:07	XLE	XLE271217P00045000	put	45.0000	2027-12-17	0.9300	0.9300	0.9800	64.5100	11904.00	0.00	11904.00	128	9	249	26917	0.00925065943455809	0.294025630924658	0.293952947162631	false	false	false	true	false
c1abc69b-6126-4189-821a-290ba5fcbd4f	2026-08-20 10:09	2026-08-20 10:08	2026-08-20 10:08	XLE	XLE261016C00065000	call	65.0000	2026-10-16	2.4600	2.3700	2.4600	64.5978	368995.00	368995.00	0.00	1500	27	1676	5733	0.292342578056864	0.242431171383858	0.242431171383858	true	false	false	true	false
5ba3bbd9-0050-4a68-8246-60e1da96804c	2026-08-20 10:09	2026-08-20 10:09	2026-08-20 10:09	XLE	XLE261016C00065000	call	65.0000	2026-10-16	2.4600	2.3700	2.4700	64.5899	195772.00	173184.00	5368.00	796	31	2472	5733	0.431187859759288	0.242828176220203	0.240867274154531	true	false	false	true	false
1b71b8cc-67cd-4191-bd08-e0d6c796deef	2026-08-20 10:09	2026-08-20 10:09	2026-08-20 10:09	XLE	XLE261016C00065000	call	65.0000	2026-10-16	2.4600	2.4600	2.4700	64.5899	26814.00	0.00	26814.00	109	21	2591	5733	0.451944880516309	0.242833263871567	0.242833263871567	true	false	false	true	false
f588cd82-451c-481a-8a1e-2c1eb84b777f	2026-08-20 10:09	2026-08-20 10:09	2026-08-20 10:09	XLE	XLE260930C00070000	call	70.0000	2026-09-30	0.5600	0.5600	0.5800	64.6100	25704.00	0.00	25704.00	459	6	503	4000	0.12575	0.25016212505871	0.25016212505871	false	false	false	true	false
2abffc69-bdc8-45d9-963f-815cb0fbc60d	2026-08-20 10:12	2026-08-20 10:12	2026-08-20 10:12	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.5000	4.4500	4.6500	64.5300	112500.00	54000.00	27900.00	250	7	1415	58525	0.0241777018368219	0.33500931113837	0.984409520369252	true	false	false	true	false
6fdfea17-df04-4461-bae7-bde3933d0943	2026-08-20 10:12	2026-08-20 10:12	2026-08-20 10:12	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.5500	4.5000	4.6500	64.5300	25480.00	23205.00	2275.00	56	11	1540	58525	0.0263135412217001	0.661963227154653	0.661963227154653	false	false	false	true	false
42b4e244-377d-4a00-98e4-abe459ee6712	2026-08-20 10:12	2026-08-20 10:12	2026-08-20 10:12	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.5500	4.5000	4.5500	64.5400	12285.00	12285.00	0.00	27	9	1569	58525	0.0268090559589919	0.560955918258787	0.560955918258787	true	false	false	true	false
36eec0f7-73a9-42df-a06f-b716d08fb1b0	2026-08-20 10:12	2026-08-20 10:12	2026-08-20 10:12	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.5500	4.5000	4.5500	64.5400	15925.00	15925.00	0.00	35	8	1604	58525	0.0274070909867578	0.560955918258787	0.560955918258787	true	false	false	true	false
3f327f46-7ea1-4109-85dc-50409a511b48	2026-08-20 10:12	2026-08-20 10:12	2026-08-20 10:12	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.5500	4.5500	4.6000	64.5550	10010.00	0.00	10010.00	22	7	1626	58525	0.0277829987184964	0.787811750323688	0.787811750323688	false	false	false	true	false
020d25eb-cf18-466f-82f7-7276b5c851cc	2026-08-20 10:15	2026-08-20 10:14	2026-08-20 10:14	XLE	XLE260918P00065000	put	65.0000	2026-09-18	1.9200	1.9200	1.9700	64.5350	12672.00	0.00	12672.00	66	10	212	220	0.963636363636364	0.245012915934615	0.245012915934615	false	false	false	true	false
7183dc32-babb-4579-841f-5670db51c47c	2026-08-20 10:31	2026-08-20 10:31	2026-08-20 10:31	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.6500	1.6500	1.6800	64.5050	28875.00	0.00	28875.00	175	46	924	52275	0.0176757532281205	0.247115302356408	0.247115302356408	true	false	false	true	false
58682c36-3bfa-44ae-9504-c2a2d3fd76b1	2026-08-20 10:34	2026-08-20 10:34	2026-08-20 10:34	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.6000	4.4500	4.6000	64.6000	109020.00	109020.00	0.00	237	8	1926	58525	0.0329090132422042	0.262823853202566	0.262823853202566	false	false	false	true	false
2dba39ad-e732-41ac-84b7-a440aad0c5d1	2026-08-20 10:43	2026-08-20 10:42	2026-08-20 10:42	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.5000	4.4500	4.5500	64.5000	35550.00	18900.00	0.00	79	5	2367	58525	0.0404442545920547	0.590613622119492	0.590613622119492	false	false	false	true	false
c34266e6-09ac-43c8-8337-e701f8ff37a0	2026-08-20 10:43	2026-08-20 10:42	2026-08-20 10:42	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.5000	4.5000	4.5500	64.5000	19350.00	0.00	19350.00	43	7	2410	58525	0.0411789833404528	0.7982819810768	0.7982819810768	false	false	false	true	false
4fd3bb97-5365-420a-9911-4de588331fd2	2026-08-20 10:43	2026-08-20 10:43	2026-08-20 10:43	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.5000	4.5000	4.5500	64.5000	296101.00	0.00	296101.00	658	18	3201	58525	0.0546945749679624	0.7982819810768	0.7982819810768	false	false	false	true	false
d512cdb5-299d-462c-ab21-fd556a80d2ac	2026-08-20 11:01	2026-08-20 11:00	2026-08-20 11:00	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.4500	4.3500	4.4500	64.4450	95230.00	95230.00	0.00	214	10	3427	58525	0.0585561725758223	0.349939263285447	0.349939263285447	false	false	false	true	false
0f4b998e-368d-4c6d-b65b-eaa092084089	2026-08-20 11:01	2026-08-20 11:00	2026-08-20 11:00	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.4600	4.4500	4.5500	64.4500	122634.00	0.00	122634.00	275	8	3702	58525	0.0632550192225545	0.928332457059661	0.928332457059661	false	false	false	true	false
64c8cb05-afc9-42f9-aa7e-e48b520e7ca7	2026-08-20 11:10	2026-08-20 11:10	2026-08-20 11:10	XLE	XLE261120P00065000	put	65.0000	2026-11-20	3.5500	3.4500	3.6000	64.3700	10650.00	10650.00	0.00	30	12	1235	1340	0.921641791044776	0.275677004284458	0.275677004284458	false	false	false	true	false
2fafb74c-c053-4343-b871-3cb5f9dee389	2026-08-20 11:11	2026-08-20 11:11	2026-08-20 11:11	XLE	XLE270319P00065000	put	65.0000	2027-03-19	4.9000	4.8500	5.0000	64.4100	22050.00	4900.00	10780.00	45	10	55	336	0.163690476190476	0.275538667472243	0.275538667472243	false	false	false	true	false
8ad77c8a-e2a8-4511-93d9-e03f5bd65249	2026-08-20 11:15	2026-08-20 11:15	2026-08-20 11:15	XLE	XLE260826C00065000	call	65.0000	2026-08-26	0.5200	0.4400	0.5600	64.3950	26000.00	19500.00	6500.00	500	15	564	194	2.90721649484536	0.232651182569561	0.232651182569561	false	false	false	true	false
2c6ae03c-d67e-418f-b7fe-3fa9ca087795	2026-08-20 11:17	2026-08-20 11:17	2026-08-20 11:17	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.3500	4.3500	4.5500	64.3700	174000.00	0.00	174000.00	400	9	4104	58525	0.0701238786843229	1.07065512870911	1.07065512870911	false	true	false	true	false
5e30a715-92a1-41ec-a39d-7d5ccf7b5c83	2026-08-20 11:24	2026-08-20 11:24	2026-08-20 11:24	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.6000	1.5700	1.6300	64.3700	367520.00	365920.00	0.00	2297	14	3486	52275	0.0666857962697274	0.248528793290513	0.24918765128458	false	false	false	true	false
427f783f-d389-47dc-bd55-8447e10ed8f5	2026-08-20 11:29	2026-08-20 11:29	2026-08-20 11:29	XLE	XLE270319P00055000	put	55.0000	2027-03-19	1.3100	1.2900	1.3100	64.4363	22270.00	22270.00	0.00	170	13	372	21025	0.0176932223543401	0.275345509999449	0.275345509999449	false	false	false	true	false
835162f2-60a3-4a70-a0b7-07684417a9dd	2026-08-20 11:46	2026-08-20 11:46	2026-08-20 11:46	XLE	XLE260918P00062500	put	62.5000	2026-09-18	0.9100	0.8800	0.9100	64.4950	45500.00	45500.00	0.00	500	68	1792	9513	0.188373804267844	0.251907897943906	0.251670077522673	false	false	false	true	false
6f61ba0b-f1bc-43d7-9959-c6db77a8cd31	2026-08-20 11:50	2026-08-20 11:50	2026-08-20 11:50	XLE	XLE260828P00065000	put	65.0000	2026-08-28	1.2000	1.1500	1.2000	64.4576	14520.00	14520.00	0.00	121	13	191	110	1.73636363636364	0.244791446050065	0.244791446050065	false	false	false	true	false
e8442cba-ee9f-4e9a-955c-1ebcc8e9586d	2026-08-20 11:52	2026-08-20 11:52	2026-08-20 11:52	XLE	XLE270115P00062500	put	62.5000	2027-01-15	3.0500	3.0000	3.1000	64.5000	23790.00	12200.00	11590.00	78	13	83	866	0.0958429561200924	0.274302395129475	0.274302395129475	false	false	false	true	false
5a40843c-586d-4ca0-b8bf-d8ba1f23cf14	2026-08-20 11:55	2026-08-20 11:55	2026-08-20 11:55	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.4200	4.4000	4.5500	64.4501	135695.00	0.00	135695.00	307	18	5233	58525	0.0894147800085434	0.928119225927471	0.928119225927471	false	true	false	true	false
f1016a4a-2b03-4201-85d9-ee99a5d75692	2026-08-20 11:56	2026-08-20 11:55	2026-08-20 11:55	XLE	XLE260828P00065000	put	65.0000	2026-08-28	1.2000	1.1700	1.2000	64.4600	19028.00	15960.00	3068.00	159	11	479	110	4.35454545454545	0.245928315699378	0.239810201553002	false	false	false	true	false
952bdab9-e5c4-40b7-b66a-adb3265f74af	2026-08-20 11:58	2026-08-20 11:58	2026-08-20 11:58	XLE	XLE260828P00065000	put	65.0000	2026-08-28	1.2000	1.1700	1.2000	64.4450	14998.00	14998.00	0.00	125	5	820	110	7.45454545454545	0.240166003459561	0.240166003459561	false	false	false	true	false
6360b892-7a46-4a51-83d5-db273e8cd2ce	2026-08-20 12:23	2026-08-20 12:23	2026-08-20 12:23	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.7500	6.7500	6.9000	64.2550	37125.00	0.00	37125.00	55	7	321	29027	0.0110586695145899	0.227474359783236	0.227474359783236	false	false	false	true	false
d074dabb-8193-4ddd-b509-6a887945b42c	2026-08-20 12:41	2026-08-20 12:41	2026-08-20 12:41	XLE	XLE261218C00072500	call	72.5000	2026-12-18	1.3100	1.2600	1.3400	64.0650	20174.00	5633.00	14541.00	154	9	194	1731	0.112073945696129	0.257811614763975	0.257811614763975	false	false	false	true	false
a649acbd-9834-47dc-ac46-00291a668501	2026-08-20 12:53	2026-08-20 12:53	2026-08-20 12:53	XLE	XLE261120C00080000	call	80.0000	2026-11-20	0.3000	0.3000	0.3400	64.0400	41910.00	0.00	41910.00	1397	36	1404	944	1.48728813559322	0.28346025166125	0.28346025166125	false	false	false	true	false
6fd27ed2-e1cf-4b76-9003-be5b545d69f2	2026-08-20 12:55	2026-08-20 12:54	2026-08-20 12:54	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.4200	1.4200	1.4400	64.0000	20164.00	0.00	20164.00	142	37	3794	52275	0.0725777140124342	0.247782302862332	0.247782302862332	false	false	false	true	false
909887ca-9f7a-4550-9f8e-dc1557bf93c4	2026-08-20 13:25	2026-08-20 13:24	2026-08-20 13:24	XLE	XLE261016C00064000	call	64.0000	2026-10-16	2.5800	2.5700	2.6000	63.9850	20898.00	10320.00	10578.00	81	7	149	525	0.283809523809524	0.237476032027083	0.238017727233222	false	false	false	true	false
201ad378-577e-401b-959b-32bca246172b	2026-08-20 13:25	2026-08-20 13:25	2026-08-20 13:25	XLE	XLE261016C00064000	call	64.0000	2026-10-16	2.5800	2.5600	2.5800	63.9900	17544.00	17544.00	0.00	68	12	342	525	0.651428571428571	0.237746965407578	0.237746965407578	false	false	false	true	false
27090f79-9c43-4aa3-9410-e0b19968a296	2026-08-20 13:38	2026-08-20 13:38	2026-08-20 13:38	XLE	XLE261016C00075000	call	75.0000	2026-10-16	0.2600	0.2600	0.2700	63.9318	90376.00	0.00	90376.00	3476	26	3485	1150	3.0304347826087	0.273452353122017	0.273452353122017	false	false	false	true	false
379a9b33-f9aa-4432-a6b2-25cf1e1bbd4a	2026-08-20 13:44	2026-08-20 13:44	2026-08-20 13:44	XLE	XLE260918P00062500	put	62.5000	2026-09-18	1.0700	1.0700	1.0900	63.9350	10700.00	0.00	10700.00	100	14	2027	9513	0.213076842215915	0.248513187828896	0.248513187828896	false	false	false	true	false
8e2b0d05-2b0e-4593-9501-9f9b3ac37976	2026-08-20 13:45	2026-08-20 13:44	2026-08-20 13:44	XLE	XLE260918P00062500	put	62.5000	2026-09-18	1.0700	1.0700	1.0900	63.9350	10700.00	0.00	10700.00	100	17	2127	9513	0.223588773257647	0.248513187828896	0.248513187828896	false	false	false	true	false
4a2706de-b03b-4ef1-8328-0aba54793fbe	2026-08-20 13:56	2026-08-20 13:56	2026-08-20 13:56	XLE	XLE270617C00055000	call	55.0000	2027-06-17	11.7000	11.6000	11.7500	63.8875	694969.00	348649.00	299520.00	594	16	609	9688	0.0628612716763006	0.212143294184218	0.212143294184218	true	false	false	true	false