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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 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

a174a96f-0246-4446-997b-23471a0082af	2026-09-14 12:49	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.4400	0.4200	0.4500	64.6300	116204.00	264.00	115940.00	2641	60	3685	8658	0.425617925617926	0.260029278810465	0.26038102049771	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	42699711298.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-14T16:49:37.903150Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
21d7e5fa-728c-4f49-99af-5dcd44878946	2026-09-14 12:49	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261016C00067000	call	67.0000	2026-10-16	1.0600	1.0600	1.1600	64.6300	43036.00	0.00	43036.00	406	15	5016	2791	1.79720530275887	0.249956808367159	0.250445676273861	false	false	false	true
06bb317e-d47c-4937-ad38-fc2261dc61d6	2026-09-14 12:49	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261016C00069000	call	69.0000	2026-10-16	0.6000	0.6000	0.6400	64.6300	11340.00	0.00	11340.00	189	10	1176	6186	0.190106692531523	0.257405295934996	0.257793553542813	false	false	false	true
903ade22-6b42-4f1e-9297-e8454a1b5731	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261016P00068000	put	68.0000	2026-10-16	4.3000	4.0500	4.3000	64.7600	81270.00	81270.00	0.00	189	10	192	249	0.771084337349398	0.322391285686405	0.322391285686405	false	false	false	true
78404f26-adbd-4b5d-91ab-94c004937deb	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261016P00067000	put	67.0000	2026-10-16	3.5500	3.3500	3.5500	64.7600	53605.00	53605.00	0.00	151	7	156	176	0.886363636363636	0.311404895007607	0.311404895007607	false	false	false	true
2efefade-2ded-4875-aaaf-9193fa60e1f3	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261120C00066000	call	66.0000	2026-11-20	2.4500	2.4500	2.5500	64.7600	24500.00	0.00	24500.00	100	14	156	141	1.1063829787234	0.252394866174578	0.252394866174578	false	false	false	true
859e53d6-3b94-4b1a-a40e-e4126432ece5	2026-09-14 12:47	2026-09-14 12:47	2026-09-14 12:47	XLE	XLE261002P00063000	put	63.0000	2026-10-02	0.8600	0.7800	0.8700	64.8800	14964.00	14878.00	86.00	174	21	253	149	1.69798657718121	0.295876470124792	0.295876470124792	true	false	false	true
cb5d219d-9bbb-4475-b04c-034aa664f627	2026-09-14 12:38	2026-09-14 12:38	2026-09-14 12:38	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.8000	0.7700	0.8000	65.0439	22800.00	22800.00	0.00	285	19	4381	11833	0.370235781289614	0.307931884323996	0.307737350860057	false	false	false	true
70826b76-29c8-43bc-8896-7af2ed636511	2026-09-14 12:36	2026-09-14 12:35	2026-09-14 12:35	XLE	XLE261016C00066000	call	66.0000	2026-10-16	1.5500	1.5500	1.6200	65.0800	42625.00	0.00	42625.00	275	10	3425	2053	1.668290306868	0.24242794332507	0.24242794332507	false	false	false	true
812e7b0e-3636-41cb-9525-59254158d997	2026-09-14 12:21	2026-09-14 12:21	2026-09-14 12:21	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.4800	0.4800	0.5100	64.9550	50400.00	0.00	50400.00	1050	56	1836	16922	0.108497813497223	0.290939729388239	0.290939729388239	true	false	false	true
7177e59a-9bb2-4433-861b-854b195fa611	2026-09-14 12:21	2026-09-14 12:21	2026-09-14 12:21	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.4800	0.4800	0.5000	64.9550	189600.00	0.00	189600.00	3950	5	5786	16922	0.341921758657369	0.290939729388239	0.290939729388239	true	false	false	true
38c004e3-e4cc-4c74-b958-5c986119eb90	2026-09-14 12:10	2026-09-14 12:10	2026-09-14 12:10	XLE	XLE260918C00065000	call	65.0000	2026-09-18	0.8100	0.8000	0.8100	64.9200	26649.00	26649.00	0.00	329	13	1672	50387	0.0331831623236152	0.308140099825858	0.308140099825858	false	false	false	true
0415ba4a-2970-48d2-bf22-6263a12af9a1	2026-09-14 12:06	2026-09-14 12:06	2026-09-14 12:06	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.2400	2.2000	2.2500	65.0200	91168.00	90496.00	672.00	407	36	960	46301	0.0207338934364269	0.280243690810751	0.280243690810751	true	false	false	true
c81d8813-37f8-45d9-ab7e-8d628fffc1b4	2026-09-14 11:46	2026-09-14 11:45	2026-09-14 11:45	XLE	XLE261016C00067000	call	67.0000	2026-10-16	1.1100	1.0700	1.1300	64.8200	17094.00	9102.00	5328.00	154	6	4322	2791	1.54854890720172	0.248100091748755	0.248100091748755	false	false	false	true
cf72a81a-5c39-485a-a992-b42839558f6d	2026-09-14 11:44	2026-09-14 11:44	2026-09-14 11:44	XLE	XLE260918P00064000	put	64.0000	2026-09-18	0.4900	0.4600	0.4900	64.8100	220990.00	220990.00	0.00	4510	30	8752	9768	0.895986895986896	0.313662399123121	0.313662399123121	false	false	false	true
7d8725ab-5c11-4914-8b3d-37fef0441126	2026-09-14 11:36	2026-09-14 11:36	2026-09-14 11:36	XLE	XLE260925C00069000	call	69.0000	2026-09-25	0.1800	0.1700	0.1900	65.0250	11178.00	0.00	11016.00	621	20	632	200	3.16	0.278421025336385	0.278421025336385	false	false	false	true
26008f05-fd1a-4031-a84b-ff29177f5129	2026-09-14 11:33	2026-09-14 11:33	2026-09-14 11:33	XLE	XLE261218C00067500	call	67.5000	2026-12-18	2.6400	2.6100	2.6500	65.0500	63096.00	63096.00	0.00	239	8	444	6677	0.0664969297588738	0.256155147053986	0.256155147053986	false	false	false	true
b8a174a5-92b6-4d4f-832e-06a633b40498	2026-09-14 11:33	2026-09-14 11:32	2026-09-14 11:32	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.8300	0.7900	0.8400	65.0100	13197.00	13197.00	0.00	159	16	3735	11833	0.315642694160399	0.312757736365042	0.312757736365042	true	false	false	true
d5807704-f5cd-473f-926b-13a06ac16d44	2026-09-14 11:32	2026-09-14 11:32	2026-09-14 11:32	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.2000	1.1600	1.2000	65.1800	15960.00	15960.00	0.00	133	8	3098	36173	0.0856439886102894	0.290643553741248	0.290643553741248	true	false	false	true
edca44d5-c26c-4645-b9d4-4942bb9d4e82	2026-09-14 11:31	2026-09-14 11:31	2026-09-14 11:31	XLE	XLE260930P00060000	put	60.0000	2026-09-30	0.2100	0.1700	0.2300	65.1950	64186.00	64186.00	0.00	3000	17	3148	1449	2.17253278122843	0.322075377739559	0.322075377739559	false	false	false	true
d895ec9c-cb0e-4b77-a0d6-f5380fe1af59	2026-09-14 11:30	2026-09-14 11:30	2026-09-14 11:30	XLE	XLE260918P00061000	put	61.0000	2026-09-18	0.0600	0.0400	0.0600	65.1283	18000.00	18000.00	0.00	3000	30	3204	19408	0.165086562242374	0.393087019556334	0.393087019556334	false	false	false	true
6347e861-7747-411a-83d7-86ab17b8b9fa	2026-09-14 11:12	2026-09-14 11:12	2026-09-14 11:12	XLE	XLE260921P00063000	put	63.0000	2026-09-21	0.3700	0.3700	0.4600	64.9100	29600.00	0.00	29600.00	800	9	1615	3357	0.481084301459637	0.304955477977536	0.304955477977536	false	false	false	true
3ccd6206-af6f-4c6a-851f-90c5ac6618aa	2026-09-14 11:11	2026-09-14 11:11	2026-09-14 11:11	XLE	XLE260918P00064000	put	64.0000	2026-09-18	0.5200	0.5200	0.5500	64.7400	11942.00	0.00	11942.00	229	7	4164	9768	0.426289926289926	0.315958250888036	0.319926216643729	true	false	false	true
9c7a8f6d-011c-4bb6-846a-1fce5462ca4e	2026-09-14 11:09	2026-09-14 11:09	2026-09-14 11:09	XLE	XLE260930C00070000	call	70.0000	2026-09-30	0.1700	0.1600	0.2000	64.6600	116535.00	323.00	116212.00	6855	35	6880	4695	1.4653887113951	0.279863478213485	0.279863478213485	false	false	false	true
b4806b96-6082-4e93-b912-2c20daaf6deb	2026-09-14 11:07	2026-09-14 11:07	2026-09-14 11:07	XLE	XLE261016P00065000	put	65.0000	2026-10-16	2.1000	2.1000	2.2100	64.9100	42057.00	12027.00	30030.00	200	6	476	4377	0.108750285583733	0.283335360816998	0.283335360816998	false	false	false	true
606410bd-711e-4be7-8540-720e9aed9039	2026-09-14 11:06	2026-09-14 11:06	2026-09-14 11:06	XLE	XLE261016C00067000	call	67.0000	2026-10-16	1.1800	1.1700	1.1800	65.0550	124018.00	124018.00	0.00	1051	5	4091	2791	1.46578287352204	0.245885549273266	0.245885549273266	true	false	false	true
afb400d1-39bd-4770-8c7f-40f20b1930fa	2026-09-14 11:06	2026-09-14 11:06	2026-09-14 11:06	XLE	XLE261016P00066000	put	66.0000	2026-10-16	2.5800	2.4100	2.5800	65.1800	13418.00	13161.00	257.00	52	14	166	270	0.614814814814815	0.29492827392991	0.295548731542277	true	false	false	true
6645597f-7498-4eb0-84e0-00b1a7bf4e2c	2026-09-14 10:58	2026-09-14 10:58	2026-09-14 10:58	XLE	XLE260918P00066000	put	66.0000	2026-09-18	1.0300	1.0100	1.0500	65.5600	14626.00	0.00	0.00	142	5	278	540	0.514814814814815	0.29404070396217	0.29404070396217	false	false	false	true
158833cf-0cc4-4cf2-871a-91deb4f1a0da	2026-09-14 10:58	2026-09-14 10:58	2026-09-14 10:58	XLE	XLE261120C00070000	call	70.0000	2026-11-20	1.4500	1.3900	1.4600	65.5900	15950.00	15950.00	0.00	110	5	3968	18759	0.211525134602058	0.260299498172092	0.260299498172092	false	false	false	true
97b124b7-c598-41fc-aa32-d1bc1ffe60d4	2026-09-14 10:52	2026-09-14 10:52	2026-09-14 10:52	XLE	XLE260918P00064000	put	64.0000	2026-09-18	0.3000	0.2900	0.3000	65.4500	72690.00	72690.00	0.00	2423	5	3817	9768	0.390765765765766	0.310865267614838	0.310865267614838	false	false	false	true
30536bf6-cf52-40aa-8c92-85c44b0be509	2026-09-14 10:47	2026-09-14 10:47	2026-09-14 10:47	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.0300	2.0000	2.0400	65.6450	22939.00	22939.00	0.00	113	6	235	46301	0.00507548433079199	0.279603038176707	0.279603038176707	true	false	false	true
0efbbdf4-1cdf-44d9-9229-2bb354e17472	2026-09-14 10:47	2026-09-14 10:47	2026-09-14 10:47	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.0300	2.0000	2.0400	65.6500	10353.00	10353.00	0.00	51	11	315	46301	0.00680330878382756	0.279734596625476	0.279734596625476	true	false	false	true
22cc9671-d1f9-467f-8f47-5c09aa62f710	2026-09-14 10:29	2026-09-14 10:28	2026-09-14 10:28	XLE	XLE261009C00067000	call	67.0000	2026-10-09	1.1700	1.1600	1.2600	65.6350	40132.00	4680.00	35452.00	343	11	343	285	1.20350877192982	0.245864006111717	0.245864006111717	true	false	false	true
d46245cf-7dad-49a1-94a6-7c6584504bc0	2026-09-14 10:14	2026-09-14 10:14	2026-09-14 10:14	XLE	XLE260918C00060000	call	60.0000	2026-09-18	5.8500	5.8500	6.0000	65.0000	12870.00	0.00	12870.00	22	7	81	55290	0.00146500271296799	0.572007909191029	0.572007909191029	false	false	false	true
d2b60e77-ac41-437a-b922-2fdd227d2178	2026-09-14 09:59	2026-09-14 09:59	2026-09-14 09:59	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.0100	0.9800	1.0300	65.7850	25250.00	1717.00	2323.00	250	7	2075	36173	0.0573632267160589	0.28906410408692	0.28906410408692	false	false	false	true
fdc8ea1e-6824-45c8-8545-e43d154bc208	2026-09-14 09:52	2026-09-14 09:52	2026-09-14 09:52	XLE	XLE261016C00067000	call	67.0000	2026-10-16	1.4400	1.4300	1.4500	65.6900	95904.00	432.00	95472.00	666	32	2995	2791	1.07309208169115	0.246643644093625	0.246643644093625	false	false	false	true
7f54298d-19bd-406c-ab6b-c5cdcdd93c17	2026-09-14 09:52	2026-09-14 09:52	2026-09-14 09:52	XLE	XLE261016C00068000	call	68.0000	2026-10-16	1.1100	1.1000	1.1800	65.6900	13875.00	444.00	13431.00	125	12	132	6937	0.019028398443131	0.250583567894758	0.250583567894758	false	false	false	true
4c531f53-c385-49af-b9c1-e42075bde8db	2026-09-14 09:52	2026-09-14 09:52	2026-09-14 09:52	XLE	XLE261016C00069000	call	69.0000	2026-10-16	0.8400	0.8400	0.9000	65.6900	58380.00	0.00	58380.00	695	29	714	6186	0.115421920465567	0.253497717686741	0.253497717686741	false	false	false	true
458d7e64-6a6e-47d6-b862-9699cb33e6d9	2026-09-14 09:52	2026-09-14 09:52	2026-09-14 09:52	XLE	XLE261120C00070000	call	70.0000	2026-11-20	1.4800	1.4800	1.5500	65.6900	533689.00	0.00	532652.00	3606	24	3691	18759	0.196758889066581	0.260053889337897	0.260053889337897	true	false	false	true
a23ab801-08ee-49d6-aa2a-72d5726d56a1	2026-09-14 09:51	2026-09-14 09:51	2026-09-14 09:51	XLE	XLE261016C00067000	call	67.0000	2026-10-16	1.5000	1.4800	1.5500	65.7900	336450.00	336300.00	150.00	2243	19	2329	2791	0.834467932640631	0.248852617879305	0.248852617879305	false	false	false	true
ad70c526-9ca4-4204-a515-4c0d910ecf61	2026-09-14 09:47	2026-09-14 09:47	2026-09-14 09:47	XLE	XLE261218C00075000	call	75.0000	2026-12-18	1.0500	1.0500	1.1000	65.0000	16695.00	0.00	16695.00	159	13	191	11190	0.0170688114387846	0.271695673003008	0.272352808123932	false	false	false	true
b285faf3-90d8-4140-a97f-b3bf6e4b9ce8	2026-09-14 09:42	2026-09-14 09:42	2026-09-14 09:42	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.4700	0.4500	0.4800	65.0000	138744.00	138274.00	0.00	2952	19	3204	11833	0.270768190653258	0.315532555043698	0.315532555043698	false	false	false	true
84683f39-fbc0-4ce5-b8af-7c55991941eb	2026-09-14 09:38	2026-09-14 09:37	2026-09-14 09:37	XLE	XLE260918C00061000	call	61.0000	2026-09-18	4.9000	4.9000	5.1500	65.9500	58800.00	0.00	58800.00	120	6	134	17585	0.00762013079328974	0.576093234284344	0.576093234284344	false	false	false	true
2b2701d3-3c42-4e08-a827-0e0a33c96fea	2026-09-14 09:37	2026-09-14 09:37	2026-09-14 09:37	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.0000	0.9600	1.0100	65.9000	148400.00	148300.00	100.00	1484	41	1733	36173	0.0479086611561109	0.292812278853143	0.292391713830189	false	false	false	true
273c97ca-0980-4d63-bcf8-645179cc7ff9	2026-09-14 09:32	2026-09-14 09:32	2026-09-14 09:32	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6500	0.6500	0.6900	65.7400	32500.00	0.00	32500.00	500	21	573	8658	0.0661815661815662	0.258180538243856	0.258180538243856	false	false	false	true
d338bef8-b108-487b-b82c-d1102d842600	2026-09-14 09:31	2026-09-14 09:31	2026-09-14 09:31	XLE	XLE261218P00072500	put	72.5000	2026-12-18	7.9000	7.7000	7.9000	65.8700	19750.00	19750.00	0.00	25	9	25	1	25	0.312242398713718	0.312242398713718	false	false	false	true
bc26f9e8-3bc2-4731-a7b1-a764d6582531	2026-09-11 16:01	2026-09-11 16:00	2026-09-11 16:00	XLE	XLE260918P00063000	put	63.0000	2026-09-18	0.2700	0.2200	0.2700	65.1400	135000.00	135000.00	0.00	5000	68	12861	5680	2.26426056338028	0.284865896136837	0.284865896136837	false	false	false	true
6dbb16ea-827a-4408-b7e1-90be71aab604	2026-09-11 15:55	2026-09-11 15:55	2026-09-11 15:55	XLE	XLE260914P00064000	put	64.0000	2026-09-14	0.1100	0.0900	0.1300	65.0750	68596.00	68561.00	0.00	6105	97	7052	293	24.0682593856655	0.200090784866967	0.206639501831278	true	false	false	true
06e552d4-77c7-4b4a-94dd-149e33b9fd2c	2026-09-11 15:26	2026-09-11 15:26	2026-09-11 15:26	XLE	XLE261120P00065000	put	65.0000	2026-11-20	2.8800	2.8800	2.9000	65.1600	11808.00	0.00	11808.00	41	6	420	4693	0.089494992542084	0.282494312511562	0.282494312511562	false	false	false	true
7b70b9f6-ea24-4161-bd93-6687b5b58b66	2026-09-11 14:50	2026-09-11 14:50	2026-09-11 14:50	XLE	XLE261016C00065000	call	65.0000	2026-10-16	2.0700	2.0300	2.0700	65.1000	11178.00	11178.00	0.00	54	6	424	8488	0.0499528746465598	0.235710032463848	0.235710032463848	true	false	false	true