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:source = uw_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	expirydate

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	LowHistoricVolumeFloor	b356ec2b-92e1-458a-934a-7719f71c40bc	1	ETF	—	4155355939.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T18:44:24.241276Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
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
e1d77160-6d5e-42ff-8728-1992152e5d0c	2026-09-21 10:47	2026-09-21 10:47	2026-09-21 10:47	XOP	XOP261016P00196000	put	196.0000	2026-10-16	13.0000	12.5000	13.2000	185.0085	29900.00	28595.00	1305.00	23	7	23	138	0.166666666666667	0.325898741418253	0.328995637711141	true	false	false	true
6dd65fa0-d7ef-47be-b604-4444d6e74c82	2026-09-21 10:47	2026-09-21 10:47	2026-09-21 10:47	XOP	XOP261016P00185000	put	185.0000	2026-10-16	5.9300	5.2500	6.0500	185.3200	11860.00	8310.00	3550.00	20	9	120	3053	0.0393056010481494	0.329156881797451	0.326561131646649	false	false	false	true
89aaed97-0419-49ac-a11b-e765cb54feea	2026-09-21 10:35	2026-09-21 10:34	2026-09-21 10:34	XOP	XOP270319C00190000	call	190.0000	2027-03-19	16.6100	16.5000	17.9500	185.6900	66455.00	26575.00	39880.00	40	7	85	288	0.295138888888889	0.327394644952035	0.324172323615952	false	false	false	true
54e92c38-ee77-492a-84a5-ec54036b8f8d	2026-09-21 10:35	2026-09-21 10:34	2026-09-21 10:34	XOP	XOP270319C00180000	call	180.0000	2027-03-19	21.1900	21.1000	23.4000	185.7400	10593.00	4230.00	6363.00	5	5	6	812	0.00738916256157635	0.318085527040262	0.319890695824505	false	false	false	true
c4175278-f0c3-4170-bee7-d5a7c16eeb00	2026-09-21 10:24	2026-09-21 10:23	2026-09-21 10:23	XOP	XOP261016P00165000	put	165.0000	2026-10-16	0.6800	0.6700	0.8200	186.0000	12036.00	0.00	12036.00	177	25	225	25307	0.0088908207215395	0.35119693761588	0.35119693761588	false	false	false	true
b4270454-26f0-4b8b-9386-96463fe28491	2026-09-18 15:56	2026-09-18 15:55	2026-09-18 15:55	XOP	XOP261218P00180000	put	180.0000	2026-12-18	7.3000	6.6000	7.3000	190.0000	27740.00	27740.00	0.00	38	9	174	235	0.740425531914894	0.342918858738442	0.342918858738442	false	false	false	true
4b77182f-aff4-4e4c-abcf-fd03a82704c1	2026-09-18 15:34	2026-09-18 15:33	2026-09-18 15:33	XOP	XOP261218P00180000	put	180.0000	2026-12-18	7.3000	7.0500	7.3000	190.8600	17520.00	17520.00	0.00	24	12	136	235	0.578723404255319	0.345242463478673	0.345242463478673	false	false	false	true
2e8a7689-dd5d-4d55-ad77-4ee1b6940863	2026-09-18 15:08	2026-09-18 15:08	2026-09-18 15:08	XOP	XOP261016C00193000	call	193.0000	2026-10-16	5.8000	5.8000	6.3500	191.0300	32480.00	0.00	32480.00	56	7	64	43	1.48837209302326	0.305414892293434	0.305414892293434	true	false	false	true
5c94f942-c0ef-43dc-aa05-1c2dd50b1892	2026-09-18 13:06	2026-09-18 13:06	2026-09-18 13:06	XOP	XOP261218P00180000	put	180.0000	2026-12-18	7.3000	6.9000	7.3000	190.8400	22630.00	22630.00	0.00	31	9	72	235	0.306382978723404	0.345056990713739	0.345056990713739	false	false	false	true
62b81619-1756-4470-9054-a6181b76e80d	2026-09-18 13:02	2026-09-18 13:02	2026-09-18 13:02	XOP	XOP261218P00180000	put	180.0000	2026-12-18	7.3000	6.9000	7.3000	190.8800	29200.00	29200.00	0.00	40	13	41	235	0.174468085106383	0.345427864369631	0.345427864369631	true	false	false	true
3b85ad68-7925-4631-9f68-b4ca84008656	2026-09-18 12:53	2026-09-18 12:53	2026-09-18 12:53	XOP	XOP261023P00170000	put	170.0000	2026-10-23	1.3100	1.3100	1.5900	191.0450	37335.00	0.00	37335.00	285	21	295	57	5.17543859649123	0.350645370397037	0.350645370397037	false	false	false	true
c31d9ce8-af04-416e-bce6-8646d0801343	2026-09-18 11:03	2026-09-18 11:03	2026-09-18 11:03	XOP	XOP261120P00195000	put	195.0000	2026-11-20	11.7500	11.7500	11.8500	192.3600	327825.00	0.00	327825.00	279	6	289	39	7.41025641025641	0.347622993618265	0.347622993618265	false	false	false	true
55effd1a-36b5-40e3-b56c-8ef963ad52ab	2026-09-18 10:48	2026-09-18 10:48	2026-09-18 10:48	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.7000	5.5500	5.8500	193.0994	11408.00	7423.00	1705.00	20	7	29	5747	0.00504611101444232	0.349032048323938	0.349032048323938	false	false	false	true
387c6176-533f-48db-8f89-15b561a7944b	2026-09-18 10:37	2026-09-18 10:37	2026-09-18 10:37	XOP	XOP261016C00191000	call	191.0000	2026-10-16	7.5000	6.9000	7.5000	192.5300	28500.00	28500.00	0.00	38	5	75	44	1.70454545454545	0.302080562311511	0.302080562311511	true	false	false	true
08325559-4da0-433c-ae75-b375eaad29e7	2026-09-18 10:02	2026-09-18 10:02	2026-09-18 10:02	XOP	XOP260918C00170000	call	170.0000	2026-09-18	22.3000	22.3000	23.0000	192.5900	15610.00	0.00	15610.00	7	5	32	7449	0.00429587864142838	3.12907944285016	3.12907944285016	false	false	false	true
e274a3c8-2f7c-4c6c-9c20-48229d93e8bb	2026-09-18 09:55	2026-09-18 09:55	2026-09-18 09:55	XOP	XOP260918C00170000	call	170.0000	2026-09-18	22.1000	22.1000	23.1000	192.2100	41990.00	0.00	41990.00	19	5	25	7449	0.00335615518861592	3.71663849949724	3.71663849949724	false	false	false	true
955bb9f4-e1e8-423b-9011-4f118f8cae8e	2026-09-18 09:50	2026-09-18 09:50	2026-09-18 09:50	XOP	XOP280121C00235000	call	235.0000	2028-01-21	16.4700	15.3500	16.7500	192.7000	46108.00	46108.00	0.00	28	10	28	5	5.6	0.298004654104855	0.298004654104855	false	false	false	true
ff2c5f6a-b34d-4c5a-93e0-a1751c0defe0	2026-09-18 09:34	2026-09-18 09:34	2026-09-18 09:34	XOP	XOP261120P00185000	put	185.0000	2026-11-20	7.3500	7.0500	7.5500	191.7400	18375.00	17640.00	735.00	25	25	474	3	158	0.350897537953169	0.350897537953169	false	false	false	true
22757760-79af-4cb1-bb6f-73bf5519759e	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	XOP	XOP261120P00185000	put	185.0000	2026-11-20	7.3500	7.1000	7.3500	191.7300	17640.00	17640.00	0.00	24	6	429	3	143	0.350777436064459	0.350777436064459	false	false	false	true	false
fa62f88a-9e9d-4dcf-a9c5-78c9cc48adad	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	XOP	XOP261120P00185000	put	185.0000	2026-11-20	7.3000	6.7500	7.3500	191.9850	13870.00	13870.00	0.00	19	19	389	3	129.666666666667	0.352145459474034	0.352145459474034	false	false	false	true
9df8e942-ebf4-4bd6-bc6a-88b37bea15ee	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	XOP	XOP261120P00185000	put	185.0000	2026-11-20	6.5000	6.5000	0.0000	192.7900	78650.00	78650.00	0.00	121	6	121	3	40.3333333333333	0.334460040423235	0.334460040423235	false	false	false	true
33d03db8-86f9-4a0c-abc8-5a89d1a8a695	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	XOP	XOP261120P00185000	put	185.0000	2026-11-20	6.5000	6.5000	8.7500	192.7900	64365.00	0.00	64365.00	99	5	256	3	85.3333333333333	0.33480147173639	0.334460040423235	false	false	false	true
407ecb94-d0e0-4a83-b31d-a840793034b2	2026-09-17 15:49	2026-09-17 15:49	2026-09-17 15:49	XOP	XOP261016C00210000	call	210.0000	2026-10-16	1.6700	1.5400	1.7400	192.0000	32899.00	32899.00	0.00	197	9	753	1749	0.430531732418525	0.316419994533445	0.316419994533445	false	false	false	true
cd0f8af1-5c68-4177-ad8c-1b10b9986301	2026-09-17 15:49	2026-09-17 15:49	2026-09-17 15:49	XOP	XOP261016C00210000	call	210.0000	2026-10-16	1.6900	1.5400	1.6900	192.5850	15041.00	13520.00	0.00	89	11	556	1749	0.31789594053745	0.316835430587365	0.316835430587365	false	false	false	true
5ea0c43e-8090-4a5c-8bdf-bfbc36637aea	2026-09-17 15:43	2026-09-17 15:43	2026-09-17 15:43	XOP	XOP261016C00210000	call	210.0000	2026-10-16	1.7100	1.6900	1.7200	192.5500	12678.00	9788.00	2890.00	74	11	354	1749	0.202401372212693	0.319337224814777	0.319337224814777	true	false	false	true
03469d90-9fd5-4d9e-838d-2f5f15659a46	2026-09-17 15:43	2026-09-17 15:43	2026-09-17 15:43	XOP	XOP261016C00210000	call	210.0000	2026-10-16	1.7300	1.6900	1.7400	192.5300	19761.00	17226.00	2535.00	114	6	239	1749	0.136649514008005	0.320957508277928	0.317540234983762	true	false	false	true
bd2d9c44-36a3-4328-a52b-588b7405448f	2026-09-17 15:40	2026-09-17 15:40	2026-09-17 15:40	XOP	XOP270319C00200000	call	200.0000	2027-03-19	16.1500	15.7000	16.1500	192.7125	25840.00	25840.00	0.00	16	10	64	270	0.237037037037037	0.32069234034425	0.32069234034425	false	false	false	true
2a7e8090-aa97-41d0-a719-3b380f2ed9b3	2026-09-17 14:55	2026-09-17 14:55	2026-09-17 14:55	XOP	XOP261016P00190000	put	190.0000	2026-10-16	6.2000	6.0500	6.2000	192.5950	309997.00	309997.00	0.00	500	51	817	5150	0.158640776699029	0.358236257746621	0.358236257746621	false	false	false	true
9f1936a1-fc92-4479-a67e-f144003d263e	2026-09-17 13:23	2026-09-17 13:23	2026-09-17 13:23	XOP	XOP261218C00200000	call	200.0000	2026-12-18	10.3000	10.3000	10.5000	192.6100	13390.00	0.00	13390.00	13	5	68	1494	0.0455153949129853	0.3266762417028	0.3266762417028	true	false	false	true
5b3b6db3-e09d-47d1-9bb9-7b1e7fa94277	2026-09-17 13:02	2026-09-17 13:02	2026-09-17 13:02	XOP	XOP261218C00205000	call	205.0000	2026-12-18	8.1000	8.1000	8.6500	192.4950	11340.00	0.00	11340.00	14	9	14	134	0.104477611940299	0.318562502143983	0.318562502143983	false	false	false	true
44b3c8b3-d700-499f-ae56-6d7246a318ed	2026-09-17 12:46	2026-09-17 12:46	2026-09-17 12:46	XOP	XOP260925P00183000	put	183.0000	2026-09-25	0.9300	0.9300	1.1600	192.3900	10137.00	0.00	10137.00	109	22	109	70	1.55714285714286	0.363373447937563	0.363373447937563	false	false	false	true