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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = XOP×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

3e9d308c-f618-4efc-a841-ce12f3e44da4	2026-09-21 13:35	2026-09-21 13:35	2026-09-21 13:35	XOP	XOP261016P00171000	put	171.0000	2026-10-16	1.5100	1.5100	1.6100	185.0000	78520.00	0.00	78520.00	520	28	547	8	68.375	0.34150817735425	0.34150817735425	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	4195475666.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
20d8eb59-4915-45ef-99d7-bbf24c2af52d	2026-09-21 15:29	2026-09-21 15:29	2026-09-21 15:29	XOP	XOP280121C00169000	call	169.0000	2028-01-21	36.9800	36.6000	38.0000	184.4800	25885.00	3705.00	22180.00	7	6	31	0	0	0.274758238913223	0.274758238913223	false	false	false	true	false
616173cf-cd19-472d-b036-e84ea2cf192a	2026-09-22 09:42	2026-09-22 09:42	2026-09-22 09:42	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.0000	2.8900	3.4500	182.6000	30000.00	4800.00	300.00	100	19	103	881	0.116912599318956	0.340370038375726	0.340370038375726	false	false	false	true	false
edb23b71-6509-4fe2-a7f3-5c79103259aa	2026-09-22 09:50	2026-09-22 09:50	2026-09-22 09:50	XOP	XOP270319P00165000	put	165.0000	2027-03-19	8.0900	8.0000	8.8500	183.0000	30750.00	3260.00	27490.00	38	5	38	23	1.65217391304348	0.348116941052696	0.349554244458541	false	false	false	true	false
fde90cb9-3113-4d08-82e7-696c7c4d5c76	2026-09-22 10:38	2026-09-22 10:38	2026-09-22 10:38	XOP	XOP261016C00185000	call	185.0000	2026-10-16	5.5000	5.3000	5.5000	183.4400	54450.00	54450.00	0.00	99	5	130	496	0.262096774193548	0.320166515679141	0.320166515679141	true	false	false	true	false
fc67b8b9-da0b-4bf6-a3a9-2b62e340ab48	2026-09-22 10:38	2026-09-22 10:38	2026-09-22 10:38	XOP	XOP261016C00185000	call	185.0000	2026-10-16	5.4500	5.3000	5.7000	183.4700	111180.00	8175.00	88835.00	204	20	334	496	0.673387096774194	0.316720591963205	0.316720591963205	false	false	false	true	false
15c72d62-167d-4ee9-bc5b-7b832fa90491	2026-09-22 10:38	2026-09-22 10:38	2026-09-22 10:38	XOP	XOP261016C00185000	call	185.0000	2026-10-16	5.4000	5.3000	5.7000	183.4600	86400.00	50760.00	29160.00	160	12	532	496	1.07258064516129	0.314315361553787	0.314315361553787	true	false	false	true	false
2cebf29f-abec-4472-8017-ce0c8bf9b9fe	2026-09-22 11:36	2026-09-22 11:36	2026-09-22 11:36	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.2900	2.2900	2.7800	184.6600	40305.00	0.00	40305.00	176	21	286	881	0.324631101021566	0.329438815663157	0.329438815663157	true	false	false	true	false
c993ad62-ff28-4178-abe1-0e6aa773ec3e	2026-09-22 11:36	2026-09-22 11:36	2026-09-22 11:36	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.3300	2.3300	2.4800	184.6600	13048.00	0.00	13048.00	56	11	342	881	0.388195232690125	0.332156620242018	0.332156620242018	true	false	false	true	false
d4229543-613e-4ce3-989e-32491429b7db	2026-09-22 11:36	2026-09-22 11:36	2026-09-22 11:36	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.3600	2.3600	2.4800	184.6600	32568.00	0.00	31152.00	138	16	617	881	0.700340522133939	0.334188621399541	0.334188621399541	false	false	false	true	false
9fe45179-5820-41a0-af89-0af54e943244	2026-09-22 11:38	2026-09-22 11:38	2026-09-22 11:38	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.3700	2.3700	2.4600	184.7100	18249.00	0.00	18249.00	77	7	778	881	0.883087400681044	0.335682986212381	0.335682986212381	true	false	false	true	false
1f7aa41b-49e2-48b2-ab20-1c1bb792fbb5	2026-09-22 11:40	2026-09-22 11:40	2026-09-22 11:40	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.3500	2.3500	2.3800	184.9600	19505.00	0.00	19505.00	83	8	1104	881	1.25312145289444	0.338398838397876	0.338398838397876	false	false	false	true	false
7f8abfc0-c510-4929-a3e5-63078dd3ff61	2026-09-22 13:03	2026-09-22 13:03	2026-09-22 13:03	XOP	XOP270319C00245000	call	245.0000	2027-03-19	3.2100	2.7600	3.4500	184.0000	10257.00	320.00	9937.00	32	6	32	134	0.238805970149254	0.335168161732738	0.335168161732738	false	false	false	true	false
e87ee53b-3fe1-4f80-b715-1d9f343d8904	2026-09-22 13:24	2026-09-22 13:24	2026-09-22 13:24	XOP	XOP261016C00194000	call	194.0000	2026-10-16	2.6900	2.6900	2.8100	184.5200	157365.00	0.00	157365.00	585	9	594	164	3.6219512195122	0.319068922307787	0.319068922307787	false	false	false	true	false
549292a5-3329-445a-9b01-8764c02d1c4c	2026-09-22 14:42	2026-09-22 14:42	2026-09-22 14:42	XOP	XOP261120P00175000	put	175.0000	2026-11-20	5.7500	5.0000	6.2000	183.6600	5175000.00	5175000.00	0.00	9000	1	9008	33	272.969696969697	0.345414500674709	0.345414500674709	false	true	false	true	true
d7d8fb2a-dc99-4306-b2b1-d4598879eb68	2026-09-23 10:00	2026-09-23 09:59	2026-09-23 09:59	XOP	XOP261218C00185000	call	185.0000	2026-12-18	12.1500	12.1500	12.8500	184.1000	14580.00	0.00	14580.00	12	8	31	323	0.0959752321981424	0.327433743277264	0.329124788981879	false	false	false	true	false
2dc0856e-c546-45c6-b794-5b2b6cb8b629	2026-09-23 11:05	2026-09-23 11:05	2026-09-23 11:05	XOP	XOP260925P00180000	put	180.0000	2026-09-25	0.9200	0.9200	1.0000	183.2500	14720.00	0.00	14628.00	160	21	165	197	0.83756345177665	0.406776675134535	0.406776675134535	false	false	false	true	false
0eff7a66-0bc7-4305-ae9c-c5cb9bb2320b	2026-09-23 11:09	2026-09-23 11:09	2026-09-23 11:09	XOP	XOP260925P00180000	put	180.0000	2026-09-25	0.7700	0.7700	1.0200	183.6600	27181.00	0.00	27181.00	353	38	518	197	2.62944162436548	0.396238524215715	0.396238524215715	false	false	false	true	false
ff364a62-0d87-474f-b177-382c1ae3321a	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	XOP	XOP260925P00186000	put	186.0000	2026-09-25	3.4500	2.6500	3.6000	184.0400	10005.00	9660.00	345.00	29	12	40	1204	0.0332225913621262	0.433363636673493	0.433363636673493	false	false	false	true	false
d935b474-6a2a-4414-878c-ec839f33209d	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	XOP	XOP261002P00180000	put	180.0000	2026-10-02	2.7200	1.8800	2.7200	182.7100	81328.00	81328.00	0.00	299	26	312	57	5.47368421052632	0.352167201878628	0.352167201878628	true	false	false	true	false
c23526a9-29f4-47f5-9c87-6a797c0a1388	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	XOP	XOP261002P00182000	put	182.0000	2026-10-02	3.5900	2.5500	3.6000	182.7100	55712.00	55712.00	0.00	155	27	157	11	14.2727272727273	0.352862742234209	0.352862742234209	false	false	false	true	false
22a92595-b31b-408a-a0be-35503c396551	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	XOP	XOP261002P00179000	put	179.0000	2026-10-02	2.3400	1.6900	2.3400	182.7100	15444.00	15444.00	0.00	66	20	68	3	22.6666666666667	0.351951118056603	0.351951118056603	true	false	false	true	false
b44e3087-3d3c-4ac2-b114-11ce5a17d55e	2026-09-23 14:57	2026-09-23 14:57	2026-09-23 14:57	XOP	XOP261016C00195000	call	195.0000	2026-10-16	2.0000	1.9200	2.0500	182.6000	27000.00	200.00	26800.00	135	6	179	1286	0.139191290824261	0.329900066995209	0.329900066995209	false	false	false	true	false
0daa161a-a66d-46f3-a008-66d7e5819aeb	2026-09-23 15:57	2026-09-23 15:57	2026-09-23 15:57	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.9000	2.9000	3.2000	182.7200	174000.00	0.00	174000.00	600	34	608	1815	0.334986225895317	0.343108106904421	0.343108106904421	true	false	false	true	false
3062e2c7-e6cb-4ef5-9760-d9a3fb647ea8	2026-09-23 15:58	2026-09-23 15:57	2026-09-23 15:57	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.9000	2.8000	2.9000	182.0000	25810.00	25810.00	0.00	89	7	697	1815	0.384022038567493	0.342195340675976	0.342195340675976	false	false	false	true	false
9930c48b-c72d-4b95-85de-c11034585a87	2026-09-23 15:58	2026-09-23 15:58	2026-09-23 15:58	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.9200	2.8000	2.9200	182.0000	17520.00	17520.00	0.00	60	8	868	1815	0.478236914600551	0.344030300606019	0.344030300606019	false	false	false	true	false
c9d7a8e0-6205-43b4-8529-bc6be8f1e584	2026-09-24 10:40	2026-09-24 10:40	2026-09-24 10:40	XOP	XOP261016C00210000	call	210.0000	2026-10-16	0.4900	0.4300	0.5000	184.9900	45325.00	24745.00	245.00	925	33	1142	3381	0.337769890564922	0.339683888269325	0.339683888269325	false	false	false	true	false
3109bfa5-a6f0-473b-9b6e-f52f4033f3e2	2026-09-24 10:42	2026-09-24 10:42	2026-09-24 10:42	XOP	XOP261016C00185000	call	185.0000	2026-10-16	6.2800	6.0500	6.3500	184.9600	404750.00	283500.00	121250.00	644	32	644	755	0.852980132450331	0.336952065021385	0.336952065021385	false	false	false	true	false
8c279e6e-1cc7-47a7-a79a-169d78d619c3	2026-09-24 10:44	2026-09-24 10:44	2026-09-24 10:44	XOP	XOP261016C00193000	call	193.0000	2026-10-16	3.1500	2.3500	3.1500	185.1150	11025.00	11025.00	0.00	35	10	35	406	0.0862068965517241	0.333369419967876	0.333369419967876	false	false	false	true	false
698b98a0-0bd5-43d4-b1eb-692e8775b4f8	2026-09-24 10:44	2026-09-24 10:44	2026-09-24 10:44	XOP	XOP261016C00191000	call	191.0000	2026-10-16	3.8000	2.8500	3.8000	185.1150	20520.00	20520.00	0.00	54	12	54	150	0.36	0.333609398152167	0.333609398152167	false	false	false	true	false
e9020a32-3bd4-46f4-bc14-bc0da36d2fd9	2026-09-24 11:04	2026-09-24 11:04	2026-09-24 11:04	XOP	XOP260925P00183000	put	183.0000	2026-09-25	0.7900	0.7900	0.9500	185.2950	22357.00	0.00	22357.00	283	43	283	192	1.47395833333333	0.442930287130528	0.442930287130528	false	false	false	true	false
111a5e6e-5ab9-4d9e-a0a9-9bf04bb4be8b	2026-09-24 12:19	2026-09-24 12:19	2026-09-24 12:19	XOP	XOP261218P00185000	put	185.0000	2026-12-18	11.8500	11.8500	12.3500	183.4700	46215.00	0.00	46215.00	39	7	50	3782	0.0132205182443152	0.339874800187187	0.339874800187187	true	false	false	true	false
23f1e369-3459-411b-a1c6-e2490df4b703	2026-09-24 13:07	2026-09-24 13:07	2026-09-24 13:07	XOP	XOP270319P00153000	put	153.0000	2027-03-19	4.3000	3.9000	4.3000	184.3200	11180.00	11180.00	0.00	26	8	26	5	5.2	0.346587585642759	0.346587585642759	false	false	false	true	false
03d4dac1-d1e9-419a-b929-b79d53ee0c38	2026-09-24 15:34	2026-09-24 15:34	2026-09-24 15:34	XOP	XOP261016P00185000	put	185.0000	2026-10-16	6.4500	5.9000	6.4500	183.9400	392140.00	392140.00	0.00	608	53	3130	3172	0.986759142496847	0.340192645694709	0.340192645694709	false	false	false	true	false