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:option_symbol = XLE260821C00060000×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

46bb833d-484e-498e-8c9c-65f4d4b40ee6	2026-08-14 15:57	2026-08-14 15:57	2026-08-14 15:57	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.1000	1.9900	2.1000	61.9200	15960.00	15960.00	0.00	76	11	1390	65869	0.0211024913085063	0.21896878497273	0.21896878497273	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-17T13:32:33.788843Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
5c5df34f-c90b-407a-81c4-403c5d6fa069	2026-08-17 10:01	2026-08-17 10:00	2026-08-17 10:00	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.2800	2.2700	2.3000	62.1800	22116.00	0.00	21888.00	97	8	2071	64458	0.0321294486332185	0.263343439414036	0.263343439414036	true	false	false	true
f824a746-a9ed-44d8-a2b5-441c8b8c7c2a	2026-08-17 10:09	2026-08-17 10:09	2026-08-17 10:09	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.3500	2.3500	2.4600	62.3050	11767.00	0.00	11767.00	50	6	2251	64458	0.0349219646901859	0.205366502752334	0.205366502752334	false	false	false	true
0522a755-ff85-46c6-a556-a1c82c4ac5fa	2026-08-17 10:20	2026-08-17 10:20	2026-08-17 10:20	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.3900	2.3900	2.4600	62.3050	11950.00	0.00	11950.00	50	9	2370	64458	0.0367681280834031	0.259073000350403	0.259073000350403	false	false	false	true
30bbd4fd-3075-429a-9796-b1dd0cbe2247	2026-08-17 12:57	2026-08-17 12:57	2026-08-17 12:57	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.4400	2.4400	2.4500	62.3650	48800.00	0.00	48800.00	200	11	5112	64458	0.0793074560178721	0.252865922970775	0.252865922970775	false	false	false	true
ba7248e5-34a5-4b45-a87b-795b43d0381b	2026-08-17 13:12	2026-08-17 13:12	2026-08-17 13:12	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.4900	2.3900	2.5000	62.4200	122012.00	122012.00	0.00	490	5	6076	64458	0.0942629309007416	0.251180605652369	0.251180605652369	false	false	false	true
0adc7fae-fa6e-4762-b7fa-a4040aaf89a7	2026-08-17 15:00	2026-08-17 14:59	2026-08-17 14:59	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.7300	2.7300	2.7800	62.6650	105924.00	0.00	105924.00	388	17	7471	64458	0.115904930342238	0.263358039647522	0.263358039647522	true	false	false	true
78629008-dd0d-4f6f-bb08-bcdd4bb432d9	2026-08-17 15:23	2026-08-17 15:23	2026-08-17 15:23	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.5800	2.5700	2.6500	62.5200	51543.00	0.00	51543.00	200	23	7751	64458	0.120248844208632	0.229624446146803	0.245430490733844	false	false	false	true
95601204-55e3-418a-b191-8758a12a5ddb	2026-08-17 15:25	2026-08-17 15:24	2026-08-17 15:24	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.5500	2.5500	2.6500	62.4650	17850.00	0.00	17850.00	70	7	7821	64458	0.12133482267523	0.272105312092684	0.272105312092684	false	false	false	true
7fb27e40-38af-468a-8b0a-37f28d6586e6	2026-08-17 15:28	2026-08-17 15:28	2026-08-17 15:28	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.5500	2.5500	2.6500	62.4739	17850.00	0.00	17850.00	70	21	7891	64458	0.122420801141829	0.255838986364155	0.262774037870897	false	false	false	true
7659e3f2-7230-4589-840a-b018f9bc7c60	2026-08-17 15:33	2026-08-17 15:33	2026-08-17 15:33	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.5700	2.5200	2.5700	62.4950	96632.00	96632.00	0.00	376	8	8404	64458	0.130379471904186	0.263132073925414	0.263132073925414	false	false	false	true
d36ccc70-40ca-492f-b2de-3a49cda52c22	2026-08-17 15:34	2026-08-17 15:34	2026-08-17 15:34	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.6000	2.5300	2.6000	62.5150	89700.00	89700.00	0.00	345	6	8754	64458	0.135809364237178	0.27614362565268	0.27614362565268	false	false	false	true
56c2c2f6-b1c6-4be5-af88-61e87e7176a6	2026-08-18 10:34	2026-08-18 10:34	2026-08-18 10:34	XLE	XLE260821C00060000	call	60.0000	2026-08-21	3.3700	3.3500	3.5000	63.3700	23600.00	0.00	23600.00	70	7	269	58943	0.00456373106221265	0.458538774805522	0.323312904952659	false	false	false	true
801e3024-d71c-4ca4-bc92-82d1ace31889	2026-08-19 13:26	2026-08-19 13:26	2026-08-19 13:26	XLE	XLE260821C00060000	call	60.0000	2026-08-21	3.7500	3.7500	3.8000	63.7300	15375.00	0.00	15375.00	41	6	300	58693	0.005111342068049	0.366930332704089	0.366930332704089	false	false	false	true
8ffa57a2-a73e-4d4f-a308-2550db68f768	2026-08-20 09:36	2026-08-20 09:36	2026-08-20 09:36	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.4500	4.4500	4.6000	64.4600	61420.00	0.00	61420.00	138	18	400	58525	0.00683468603161042	1.01339497512572	1.01339497512572	false	false	false	true
178871a7-e709-4fff-aa48-810b7f9dd5b1	2026-08-20 09:36	2026-08-20 09:36	2026-08-20 09:36	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.4500	4.3500	4.4500	64.4500	110360.00	110360.00	0.00	248	22	262	58525	0.00447671935070483	0.614797841752708	0.614797841752708	true	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
9510f2be-2440-46c5-9c37-a845a028b51d	2026-08-21 15:46	2026-08-21 15:46	2026-08-21 15:46	XLE	XLE260821C00060000	call	60.0000	2026-08-21	3.7700	3.7000	3.8000	63.7450	47132.00	47132.00	0.00	125	8	665	56944	0.0116781399269458	7.36100453223399	5.82313708312378	false	false	false	true