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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = XOP×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

088f7155-4098-424a-a93d-df9ed13a6501	2026-09-25 15:49	2026-09-25 15:49	2026-09-25 15:49	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.2000	2.9500	3.2000	181.0000	263360.00	263360.00	0.00	823	40	1857	20895	0.088872936109117	0.363099038021588	0.363099038021588	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	4078763579.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:51:07.574812Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
4a3cfc1b-d062-4342-982a-dc8ecff8e1a8	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	XOP	XOP261016C00181000	call	181.0000	2026-10-16	6.8000	6.4500	6.8500	181.9700	22440.00	22440.00	0.00	33	6	55	8	6.875	0.350679909805341	0.350679909805341	false	false	false	true
fb1ecb9b-392a-42b2-ae17-af4de9028d04	2026-09-25 14:52	2026-09-25 14:52	2026-09-25 14:52	XOP	XOP270319C00190000	call	190.0000	2027-03-19	13.5900	12.9500	13.6500	180.0000	23100.00	21750.00	1350.00	17	5	17	336	0.0505952380952381	0.317806387338402	0.316805456590322	false	false	false	true
b0752fdd-ab18-4ced-877e-e5d5b2cd3c77	2026-09-25 14:46	2026-09-25 14:45	2026-09-25 14:45	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.2500	3.2000	3.2500	180.0000	42250.00	42250.00	0.00	130	7	955	20895	0.0457047140464226	0.34356416369195	0.34356416369195	true	false	false	true
4fb2aea4-c434-43b2-93c2-9c968b7d5347	2026-09-25 14:46	2026-09-25 14:45	2026-09-25 14:45	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.3000	3.2000	3.3000	180.8100	41580.00	41580.00	0.00	126	6	805	20895	0.0385259631490787	0.346678956023086	0.346678956023086	true	false	false	true
21ed0e4e-775f-40db-bcd3-61abdcb956c1	2026-09-25 14:45	2026-09-25 14:45	2026-09-25 14:45	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.3500	3.2500	3.3500	180.8250	55275.00	55275.00	0.00	165	7	679	20895	0.0324958123953099	0.350203062873536	0.350203062873536	false	false	false	true
7e4fb1bb-4cc4-409a-9635-c00a02e75e9d	2026-09-25 14:45	2026-09-25 14:45	2026-09-25 14:45	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.4000	3.3500	3.4000	180.8400	35675.00	34000.00	1675.00	105	8	373	20895	0.0178511605647284	0.350514149613939	0.353723332968772	true	false	false	true
81da39c1-24e2-4b7b-838c-83368aa2e52f	2026-09-25 14:45	2026-09-25 14:45	2026-09-25 14:45	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.5000	3.3500	3.5000	180.6000	90650.00	90650.00	0.00	259	26	268	20895	0.0128260349365877	0.355097858992281	0.355097858992281	false	false	false	true
ef628f3c-af2c-4744-94c1-e0ae2fe8364c	2026-09-25 14:19	2026-09-25 14:19	2026-09-25 14:19	XOP	XOP270319C00185000	call	185.0000	2027-03-19	15.5100	14.9500	15.7500	180.6200	27915.00	21720.00	4645.00	18	5	18	215	0.0837209302325581	0.316474009674481	0.320501008745359	false	false	false	true
705c7bfa-495d-4781-bc3a-6d1f4966df47	2026-09-25 12:58	2026-09-25 12:58	2026-09-25 12:58	XOP	XOP270617C00240000	call	240.0000	2027-06-17	5.4600	5.2000	5.6500	180.6000	10376.00	4381.00	5995.00	19	7	19	31	0.612903225806452	0.322933173241953	0.322271840019318	false	false	false	true
f59ded64-35a7-47b3-8571-becb95d86a39	2026-09-25 12:56	2026-09-25 12:56	2026-09-25 12:56	XOP	XOP261016C00180000	call	180.0000	2026-10-16	6.6000	6.1500	6.6000	180.5600	11220.00	11220.00	0.00	17	6	44	2288	0.0192307692307692	0.354123892383269	0.354123892383269	false	false	false	true
37d6a2a5-817c-49ea-9583-2424718c690b	2026-09-25 12:34	2026-09-25 12:34	2026-09-25 12:34	XOP	XOP270319C00200000	call	200.0000	2027-03-19	10.1500	9.7500	10.1500	180.6000	15225.00	15225.00	0.00	15	6	15	354	0.0423728813559322	0.321796998226303	0.321796998226303	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
f530b6f0-e022-4be7-a133-ea54de3e110f	2026-09-21 13:15	2026-09-21 13:15	2026-09-21 13:15	XOP	XOP270115P00145000	put	145.0000	2027-01-15	1.6300	1.6300	1.7600	184.5300	13366.00	0.00	13366.00	82	19	82	250	0.328	0.358945603216268	0.358945603216268	false	false	false	true
ae6cd02f-49ad-47b8-ac86-457ad9ec5290	2026-09-21 12:32	2026-09-21 12:32	2026-09-21 12:32	XOP	XOP270319C00225000	call	225.0000	2027-03-19	5.8500	5.8000	6.1500	184.6700	12870.00	1170.00	11700.00	22	5	32	25	1.28	0.327906810569294	0.327906810569294	false	false	false	true
4d1cda48-e07f-4268-9e11-d96d1d6ca574	2026-09-21 12:13	2026-09-21 12:13	2026-09-21 12:13	XOP	XOP261218P00185000	put	185.0000	2026-12-18	11.4500	11.4000	11.6500	184.6150	53815.00	41220.00	12595.00	47	8	57	3746	0.0152162306460224	0.338032938794881	0.338032938794881	false	false	false	true
e537e74e-acaa-4151-8f54-2eb9047daf69	2026-09-21 11:12	2026-09-21 11:12	2026-09-21 11:12	XOP	XOP260925P00175000	put	175.0000	2026-09-25	0.2500	0.2500	0.4300	185.0000	12500.00	0.00	8300.00	500	51	502	42	11.952380952381	0.386434904456919	0.386434904456919	false	false	false	true