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

853dcf94-7b98-4fdb-9b25-17be7a9fb9cb	2026-09-25 15:33	2026-09-25 15:33	2026-09-25 15:33	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.9800	1.9700	1.9800	62.1200	78408.00	78408.00	0.00	396	31	1085	54776	0.0198079450854389	0.270953852330191	0.270953852330191	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	40486178216.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:35:55.847824Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
00c61d35-48dd-495a-9cf6-e38d4350ef4e	2026-09-25 15:33	2026-09-25 15:33	2026-09-25 15:33	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.9700	1.9700	2.0900	62.1050	27777.00	0.00	27777.00	141	28	689	54776	0.0125785015335183	0.26957115172152	0.26957115172152	true	false	false	true
ca4694a4-0d41-4bd4-8b30-1eba688fe4a3	2026-09-25 12:20	2026-09-25 12:20	2026-09-25 12:20	XLE	XLE261218P00060000	put	60.0000	2026-12-18	2.0000	1.9600	2.0000	61.0000	98000.00	800.00	0.00	490	78	539	54776	0.00984007594566964	0.261517100332229	0.261517100332229	true	false	false	true
817a2ca8-b554-45f6-9394-3122deb90085	2026-09-24 12:30	2026-09-24 12:30	2026-09-24 12:30	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.8600	1.7900	1.8600	62.6950	93000.00	93000.00	0.00	500	42	560	54740	0.010230179028133	0.275768775548045	0.275768775548045	true	false	false	true
1feec3cd-075f-4996-8844-0664b9f7fae1	2026-09-23 14:42	2026-09-23 14:42	2026-09-23 14:42	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.9400	1.9200	1.9400	62.3250	33368.00	33368.00	0.00	172	11	240	54548	0.00439979467624844	0.270525188431131	0.270525188431131	false	false	false	true
e5dc769b-4d43-49b0-b1d0-74ad7d953039	2026-09-22 11:37	2026-09-22 11:37	2026-09-22 11:37	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.9300	1.9300	2.0100	62.4700	49987.00	0.00	49987.00	259	25	335	54422	0.00615559883870494	0.272687911895551	0.272687911895551	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
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
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
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
fe1e2ac4-c5e6-4677-b0b3-48a7f0890d3d	2026-09-18 14:32	2026-09-18 14:32	2026-09-18 14:32	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.5000	1.4700	1.5100	64.4397	377400.00	360600.00	16800.00	2516	27	2790	49000	0.0569387755102041	0.280957406796229	0.280957406796229	false	false	false	true
1dc30797-c958-4e95-a7d8-828dc3e3200a	2026-09-18 12:39	2026-09-18 12:38	2026-09-18 12:38	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.4600	1.4300	1.4600	64.4950	15622.00	15622.00	0.00	107	14	157	49000	0.00320408163265306	0.278449401392427	0.278449401392427	false	false	false	true
68c6e753-3354-42c8-9b61-6754067ba580	2026-09-11 14:22	2026-09-11 14:22	2026-09-11 14:22	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.4100	1.3700	1.4100	65.1750	38493.00	38493.00	0.00	273	16	899	48754	0.0184395126553719	0.280141452943478	0.280141452943478	false	false	false	true
a39664b9-e3b2-4eab-85b5-f157d3bcd5e6	2026-09-10 09:30	2026-09-10 09:30	2026-09-10 09:30	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.3100	1.0000	1.3200	66.0600	26229.00	11557.00	0.00	200	9	200	48512	0.00412269129287599	0.28937863562855	0.288384825581349	false	false	false	true
5b205728-dfed-4332-b35e-f51d88463f5c	2026-09-08 13:49	2026-09-08 13:49	2026-09-08 13:49	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.4800	1.4700	1.4900	64.6084	47656.00	46768.00	0.00	322	7	5800	47405	0.122349963084063	0.269643894774212	0.269643894774212	false	false	false	true
e7ab91e1-833f-42a6-84e1-633387e93297	2026-09-08 13:37	2026-09-08 13:37	2026-09-08 13:37	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.5000	1.4800	1.5000	64.5400	46950.00	46950.00	0.00	313	5	2888	47405	0.0609218436873748	0.26989547169522	0.26989547169522	false	false	false	true
4f0146ed-c223-49ab-b96c-fa13030fd3e2	2026-08-31 15:51	2026-08-31 15:51	2026-08-31 15:51	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.6900	1.6900	1.7000	63.9350	10140.00	0.00	10140.00	60	13	3176	44363	0.0715911908572459	0.263522906808159	0.263522906808159	false	false	false	true
5d9d162f-99af-41fe-8ef3-edd883d917dd	2026-08-31 15:42	2026-08-31 15:42	2026-08-31 15:42	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.6900	1.6600	1.6900	63.8750	118469.00	118469.00	0.00	701	26	3095	44363	0.0697653449947028	0.262102538678024	0.262102538678024	true	false	false	true
d4cbea27-7efe-467f-bb5d-759736fde0ee	2026-08-31 15:40	2026-08-31 15:39	2026-08-31 15:39	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.7000	1.6600	1.7100	63.8650	224740.00	223720.00	0.00	1322	10	2385	44363	0.0537610170637694	0.262719740002207	0.262719740002207	true	false	false	true
d28f046c-2c79-443d-9e0b-ca68322c0992	2026-08-31 15:40	2026-08-31 15:39	2026-08-31 15:39	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.7000	1.6600	1.7000	63.8650	59670.00	59670.00	0.00	351	39	1063	44363	0.0239614092825102	0.262719740002207	0.262719740002207	true	false	false	true
ed73f516-ba6e-4181-bde9-6d39c921436b	2026-08-27 14:09	2026-08-27 14:09	2026-08-27 14:09	XLE	XLE261218P00060000	put	60.0000	2026-12-18	2.1200	2.0700	2.1200	62.6600	71232.00	71232.00	0.00	336	29	3919	22514	0.174069467886648	0.263051679970258	0.263051679970258	true	false	false	true
c7a92feb-adce-40a5-8f0c-6208573dfe57	2026-08-26 13:27	2026-08-26 13:26	2026-08-26 13:26	XLE	XLE261218P00060000	put	60.0000	2026-12-18	2.1300	2.1000	2.1300	62.6850	37062.00	37062.00	0.00	174	9	1069	21699	0.0492649430849348	0.26357885415343	0.26357885415343	false	false	false	true
10f3ad68-4029-47bf-8567-87e2c4fc3729	2026-08-26 13:26	2026-08-26 13:26	2026-08-26 13:26	XLE	XLE261218P00060000	put	60.0000	2026-12-18	2.1300	2.1000	2.1400	62.6950	39618.00	39618.00	0.00	186	5	895	21699	0.0412461403751325	0.263836600968486	0.263836600968486	false	false	false	true
d07db467-8298-4a4b-9819-29a7fb4de17e	2026-08-26 09:40	2026-08-26 09:40	2026-08-26 09:40	XLE	XLE261218P00060000	put	60.0000	2026-12-18	2.4000	2.3600	2.5100	62.0300	12000.00	0.00	12000.00	50	5	180	21699	0.00829531314807134	0.267352072424671	0.267352072424671	false	false	false	true
f5f62c99-d719-4a0d-94e0-0b71edb3a254	2026-08-24 14:32	2026-08-24 14:32	2026-08-24 14:32	XLE	XLE261218P00060000	put	60.0000	2026-12-18	2.0600	2.0300	2.0600	63.0200	33114.00	33114.00	0.00	161	6	5049	8618	0.585866790438617	0.264641675465345	0.263847160643325	true	false	false	true
cf7404a6-f64c-4efb-b456-e9afcfe3ade1	2026-08-24 14:32	2026-08-24 14:32	2026-08-24 14:32	XLE	XLE261218P00060000	put	60.0000	2026-12-18	2.0600	2.0600	2.0700	63.0200	67774.00	0.00	2060.00	329	43	4888	8618	0.567184961708053	0.264641675465345	0.264641675465345	false	false	false	true
caf3fb1f-e853-4003-9ef6-68bd53d6b94a	2026-08-20 15:35	2026-08-20 15:35	2026-08-20 15:35	XLE	XLE261218P00060000	put	60.0000	2026-12-18	2.0100	1.9600	2.0100	63.7250	41406.00	41406.00	0.00	206	6	651	7898	0.0824259306153457	0.27369537643175	0.27369537643175	false	false	false	true