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:source = uw_flow_alerts×ticker = USO×

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

20ec794c-a3de-4a10-ac15-b74cf0163169	2026-09-23 10:57	2026-09-23 10:57	2026-09-23 10:57	USO	USO261030C00162000	call	162.0000	2026-10-30	4.5000	4.3000	4.5000	147.0900	12150.00	12150.00	0.00	27	6	94	532	0.176691729323308	0.514367416745418	0.514367416745418	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	Financial Services	1228364647.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T14:57:22.994560Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
5ba45f4a-4cbd-48ef-ab18-1d212b4d0cae	2026-09-23 10:55	2026-09-23 10:55	2026-09-23 10:55	USO	USO261023C00155000	call	155.0000	2026-10-23	5.5500	5.3500	5.7000	147.0700	17205.00	16650.00	555.00	31	8	51	256	0.19921875	0.510855033977038	0.508907246131652	true	false	false	true
4b90acf4-e3bc-4929-b4dc-b62de86bf25b	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	USO	USO261009P00141000	put	141.0000	2026-10-09	3.5500	3.2000	3.5500	146.0000	23785.00	23785.00	0.00	67	20	73	350	0.208571428571429	0.512259392398587	0.512259392398587	false	false	false	true
74fa9eff-3402-4154-b9c3-cef13b397017	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	USO	USO261016P00144000	put	144.0000	2026-10-16	5.9500	5.9500	6.1000	146.0000	10710.00	0.00	10710.00	18	8	59	187	0.315508021390374	0.514772369518675	0.514772369518675	false	false	false	true
9ae79461-cd55-4cc5-ab29-f945a1531e6b	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	USO	USO261016P00135000	put	135.0000	2026-10-16	2.8300	2.8300	3.0500	146.0000	23489.00	0.00	23489.00	83	21	335	5520	0.0606884057971014	0.522385278059683	0.522385278059683	false	false	false	true
d6a2cec2-1aec-48e0-a086-6bad3896825f	2026-09-23 10:51	2026-09-23 10:51	2026-09-23 10:51	USO	USO261009C00142000	call	142.0000	2026-10-09	9.5500	8.2500	10.0500	147.6500	20050.00	15280.00	4770.00	21	7	21	40	0.525	0.509772590837564	0.509772590837564	true	false	false	true
57d1c629-1936-46ba-9c9a-72376c817914	2026-09-23 10:51	2026-09-23 10:51	2026-09-23 10:51	USO	USO261009C00141000	call	141.0000	2026-10-09	10.1900	8.8000	10.8000	147.6500	12225.00	5100.00	7125.00	12	7	12	92	0.130434782608696	0.510689458277705	0.510689458277705	true	false	false	true
125b9a55-1025-4fd9-b82c-df3a460bf583	2026-09-23 10:51	2026-09-23 10:51	2026-09-23 10:51	USO	USO261009C00168000	call	168.0000	2026-10-09	1.2100	0.8400	1.2400	147.1200	23982.00	12199.00	11783.00	199	5	236	233	1.01287553648069	0.559963092092194	0.559963092092194	true	false	false	true
d9b39885-f5aa-4e9a-b33b-5772d88ea5d4	2026-09-23 10:50	2026-09-23 10:50	2026-09-23 10:50	USO	USO261023C00150000	call	150.0000	2026-10-23	7.9500	7.7500	8.0000	147.9713	17490.00	15105.00	2385.00	22	12	82	223	0.367713004484305	0.511768373040097	0.511768373040097	true	false	false	true
d19d83a9-8a6e-42ee-9c85-22e19748cdeb	2026-09-23 10:48	2026-09-23 10:48	2026-09-23 10:48	USO	USO261120C00147000	call	147.0000	2026-11-20	12.2000	11.3500	12.6000	148.0100	10980.00	10980.00	0.00	9	5	32	35	0.914285714285714	0.481438164076426	0.479374091080518	true	false	false	true
2de073f2-3956-441c-b029-794467bb5cde	2026-09-23 10:47	2026-09-23 10:47	2026-09-23 10:47	USO	USO260930P00138000	put	138.0000	2026-09-30	1.0600	0.8900	1.1000	147.8650	26925.00	26818.00	107.00	254	11	363	814	0.445945945945946	0.551150646526069	0.552087675042906	true	false	false	true
1beeea73-d28d-4bcb-9364-040359768fe3	2026-09-23 10:47	2026-09-23 10:47	2026-09-23 10:47	USO	USO261016C00154000	call	154.0000	2026-10-16	5.3000	5.3000	5.4500	147.9350	10070.00	0.00	10070.00	19	6	46	167	0.275449101796407	0.517919741374493	0.517919741374493	true	false	false	true
02387571-890b-4c4f-9226-3e837ae09136	2026-09-23 10:47	2026-09-23 10:47	2026-09-23 10:47	USO	USO261030C00158000	call	158.0000	2026-10-30	5.9000	5.9000	6.1000	147.9350	15930.00	0.00	15930.00	27	11	76	328	0.231707317073171	0.51146593189642	0.51146593189642	true	false	false	true
15583a75-46e2-45b9-9d19-b407276ad289	2026-09-23 10:47	2026-09-23 10:47	2026-09-23 10:47	USO	USO261016C00160000	call	160.0000	2026-10-16	3.6500	3.6500	3.8000	147.9750	10220.00	0.00	10220.00	28	10	121	5118	0.023642047674873	0.531934589147148	0.531934589147148	true	false	false	true
7e3f8a55-b8bd-4d75-9181-a10d7f689b46	2026-09-23 10:45	2026-09-23 10:45	2026-09-23 10:45	USO	USO261016C00156000	call	156.0000	2026-10-16	4.8000	4.7000	4.8000	148.2682	65280.00	65280.00	0.00	136	7	324	829	0.390832328106152	0.522072661501041	0.522072661501041	true	false	false	true
b841b7e2-f79c-4850-95f6-daeb5ea58ad5	2026-09-23 10:45	2026-09-23 10:45	2026-09-23 10:45	USO	USO261016C00151000	call	151.0000	2026-10-16	6.4300	6.4000	6.8000	148.1800	12864.00	0.00	12864.00	20	8	106	14506	0.00730732110850682	0.505547482949012	0.509599216564118	true	false	false	true
7f41023e-0b45-4800-aab5-187aaa35728f	2026-09-23 10:44	2026-09-23 10:44	2026-09-23 10:44	USO	USO261023C00153000	call	153.0000	2026-10-23	6.8000	6.6000	6.9000	148.1674	17000.00	16320.00	680.00	25	6	60	209	0.287081339712919	0.512161731236437	0.512161731236437	true	false	false	true
71b01558-8631-457f-bcbc-35e0c69316ba	2026-09-23 10:44	2026-09-23 10:44	2026-09-23 10:44	USO	USO261030C00152000	call	152.0000	2026-10-30	8.0500	7.8000	8.2000	148.1674	20930.00	20930.00	0.00	26	5	75	147	0.510204081632653	0.503444899136585	0.503444899136585	false	false	false	true
fc55356e-6323-4cec-98a4-eb14348f9434	2026-09-23 10:42	2026-09-23 10:42	2026-09-23 10:42	USO	USO260930C00149000	call	149.0000	2026-09-30	3.9000	3.9000	4.0500	147.8500	12480.00	0.00	12480.00	32	8	146	479	0.304801670146138	0.536771682502758	0.536771682502758	true	false	false	true
b93faf07-b651-47d6-bd54-dc993a431b30	2026-09-23 10:42	2026-09-23 10:42	2026-09-23 10:42	USO	USO261009P00138000	put	138.0000	2026-10-09	2.3900	2.0400	2.3900	147.8500	12663.00	12189.00	236.00	53	14	110	379	0.29023746701847	0.51738445375593	0.514262118436646	false	false	false	true
3437b2ca-8805-495c-b287-27e08a1f49f4	2026-09-23 10:41	2026-09-23 10:41	2026-09-23 10:41	USO	USO261016C00153000	call	153.0000	2026-10-16	5.6000	5.6000	5.7500	147.8600	10082.00	0.00	10082.00	18	11	102	414	0.246376811594203	0.515337512869523	0.515337512869523	false	false	false	true
5eee3b89-9600-479a-b20c-3d457a5afcb7	2026-09-23 10:41	2026-09-23 10:41	2026-09-23 10:41	USO	USO261016C00152000	call	152.0000	2026-10-16	6.0000	6.0000	6.1500	147.9290	10206.00	0.00	10206.00	17	8	34	281	0.120996441281139	0.514100995097952	0.514100995097952	false	false	false	true
da7e7098-9d01-41bc-9930-121e0e1915e7	2026-09-23 10:41	2026-09-23 10:41	2026-09-23 10:41	USO	USO260930C00149000	call	149.0000	2026-09-30	3.9500	3.9000	4.2500	147.9100	13430.00	0.00	13430.00	34	9	114	479	0.237995824634656	0.53938093717221	0.53938093717221	true	false	false	true
eb5dc2ca-ab33-43fe-8753-3a55e059f4e2	2026-09-23 10:40	2026-09-23 10:40	2026-09-23 10:40	USO	USO261016C00151000	call	151.0000	2026-10-16	6.4000	6.4000	6.6000	148.0199	10880.00	0.00	10880.00	17	7	84	14506	0.00579070729353371	0.510661456344731	0.510661456344731	false	false	false	true
a4713c20-fbfc-415b-a5c6-a0282e11ea24	2026-09-23 10:40	2026-09-23 10:40	2026-09-23 10:40	USO	USO261002C00160000	call	160.0000	2026-10-02	1.4400	1.4400	1.5000	147.9300	346320.00	0.00	346320.00	2405	18	2635	1674	1.57407407407407	0.565252984435226	0.565252984435226	false	false	false	true
8857df6d-9c76-4e98-80a5-2aae47188cc6	2026-09-23 10:39	2026-09-23 10:39	2026-09-23 10:39	USO	USO261009C00149000	call	149.0000	2026-10-09	5.7500	5.5500	5.7500	147.5700	16100.00	16100.00	0.00	28	7	108	258	0.418604651162791	0.510812353368462	0.510812353368462	true	false	false	true
9d8eaa05-66fd-481e-bbcf-dcf71c51f359	2026-09-23 10:39	2026-09-23 10:39	2026-09-23 10:39	USO	USO261120P00120000	put	120.0000	2026-11-20	2.0200	1.9300	2.0300	147.5000	18369.00	18169.00	200.00	91	22	454	2918	0.155586017820425	0.505378601164629	0.50704109455898	true	false	false	true
42c8cbfe-f0c3-4b0d-9cd8-8c1c78eb8faf	2026-09-23 10:38	2026-09-23 10:38	2026-09-23 10:38	USO	USO261023P00148000	put	148.0000	2026-10-23	8.5500	8.5500	8.7500	147.7694	20520.00	0.00	20520.00	24	10	47	264	0.178030303030303	0.514201318180285	0.514201318180285	true	false	false	true
cee458b6-7878-4bf0-827d-7a8f1664b9f1	2026-09-23 10:36	2026-09-23 10:36	2026-09-23 10:36	USO	USO261016P00140000	put	140.0000	2026-10-16	4.1000	4.0000	4.2000	147.6300	10250.00	9020.00	0.00	25	5	487	8324	0.0585055261893321	0.516107680615348	0.516107680615348	false	false	false	true
dacd9482-4b99-41fb-86e2-4aceeb7a4a77	2026-09-23 10:34	2026-09-23 10:34	2026-09-23 10:34	USO	USO261120P00120000	put	120.0000	2026-11-20	1.9900	1.8900	2.0200	147.6800	50067.00	49872.00	195.00	251	18	301	2918	0.103152844413982	0.510340889658121	0.503879808470927	true	false	false	true
465974ef-7831-44ba-9f3c-ee06d16896e9	2026-09-23 10:34	2026-09-23 10:33	2026-09-23 10:33	USO	USO261218P00110000	put	110.0000	2026-12-18	1.6400	1.4500	1.6400	147.7950	73800.00	2788.00	0.00	450	30	502	8466	0.0592960075596504	0.510099418752495	0.510099418752495	true	false	false	true
a2a81a6f-20f5-4099-8ffe-f428b4280534	2026-09-23 10:31	2026-09-23 10:31	2026-09-23 10:31	USO	USO261016C00153000	call	153.0000	2026-10-16	5.4500	5.4500	5.6000	147.5700	10355.00	0.00	10355.00	19	7	65	414	0.157004830917874	0.513503321691111	0.513503321691111	false	false	false	true
53a9a7ab-130c-4618-a90a-a01986c0e1cb	2026-09-23 10:29	2026-09-23 10:29	2026-09-23 10:29	USO	USO260925C00148000	call	148.0000	2026-09-25	2.6100	2.2100	2.9500	147.9400	11745.00	2088.00	9657.00	45	14	730	1105	0.660633484162896	0.600585440246398	0.600585440246398	false	false	false	true
3d65c039-ef76-4418-819e-fba673cb87e0	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	USO	USO261030P00135000	put	135.0000	2026-10-30	3.8500	3.8500	3.9500	147.0000	13860.00	0.00	13860.00	36	9	42	575	0.0730434782608696	0.503910588708793	0.503910588708793	true	false	false	true
61853d3a-e3b9-4a62-a32d-256efe9e07fc	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	USO	USO261016P00132000	put	132.0000	2026-10-16	1.9400	1.9400	2.1700	147.0000	18236.00	0.00	18236.00	94	22	131	393	0.333333333333333	0.526755902676538	0.526755902676538	false	false	false	true
85933754-ab3d-4a1a-9643-a080d236575e	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	USO	USO261016C00150000	call	150.0000	2026-10-16	6.4000	6.4000	6.5500	147.0000	17280.00	0.00	17280.00	27	5	171	6234	0.0274302213666987	0.504672207659264	0.504672207659264	false	false	false	true
7190078b-5be8-40e2-a1dd-8110bb90baaf	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	USO	USO261023P00130000	put	130.0000	2026-10-23	2.0000	1.8100	2.0000	147.0000	23000.00	23000.00	0.00	115	27	209	1508	0.138594164456233	0.499623983002264	0.499623983002264	false	false	false	true
556d56ea-7631-43fe-a79b-71d6ef91fec2	2026-09-23 10:04	2026-09-23 10:04	2026-09-23 10:04	USO	USO261030P00120000	put	120.0000	2026-10-30	1.1400	1.1300	1.3100	147.0000	13908.00	0.00	13794.00	122	31	127	494	0.257085020242915	0.532655495048813	0.532655495048813	false	false	false	true
b4db8ded-0a4a-4aab-854c-a12816acba35	2026-09-23 10:02	2026-09-23 10:02	2026-09-23 10:02	USO	USO261030P00125000	put	125.0000	2026-10-30	1.7300	1.6800	1.7800	147.0000	20364.00	8782.00	10717.00	118	17	121	318	0.380503144654088	0.517718540450773	0.517718540450773	false	false	false	true
5a5a9813-e103-415e-bd29-e98de854fb78	2026-09-23 10:02	2026-09-23 10:02	2026-09-23 10:02	USO	USO261023C00180000	call	180.0000	2026-10-23	1.5500	1.5500	1.6400	147.0000	17980.00	0.00	17980.00	116	30	118	866	0.136258660508083	0.573089303406526	0.573089303406526	false	false	false	true
a0b29f15-a616-47a4-9a5d-7a5662e6b379	2026-09-23 10:02	2026-09-23 10:02	2026-09-23 10:02	USO	USO261016C00167000	call	167.0000	2026-10-16	2.1500	2.0200	2.1500	147.0000	24725.00	24725.00	0.00	115	22	116	4	29	0.536616768111789	0.536616768111789	false	false	false	true
9ef0bc08-68d9-49fe-9c57-e81b552cd2b1	2026-09-23 10:02	2026-09-23 10:01	2026-09-23 10:01	USO	USO260925P00147000	put	147.0000	2026-09-25	2.1200	2.0600	2.1600	147.0000	48547.00	47912.00	0.00	229	7	244	2234	0.109221128021486	0.563321170738081	0.563321170738081	false	false	false	true
c3e0abaf-a175-46c5-ab73-6ce779124d58	2026-09-23 10:01	2026-09-23 10:01	2026-09-23 10:01	USO	USO261009P00142000	put	142.0000	2026-10-09	3.6000	3.4500	3.6000	147.0000	19800.00	19800.00	0.00	55	8	71	176	0.403409090909091	0.505626318731279	0.505626318731279	false	false	false	true
1c6b17be-2ae6-4a95-8686-4522791e8db7	2026-09-23 09:58	2026-09-23 09:58	2026-09-23 09:58	USO	USO261120C00157000	call	157.0000	2026-11-20	8.1500	7.9500	8.4000	147.8000	35045.00	1630.00	33415.00	43	12	46	493	0.0933062880324544	0.489087224507595	0.489087224507595	true	false	false	true
f61b0b82-c9d3-4923-b1f1-92a86665e660	2026-09-23 09:58	2026-09-23 09:58	2026-09-23 09:58	USO	USO261030C00157000	call	157.0000	2026-10-30	6.1000	6.1000	6.3000	147.9212	18300.00	0.00	18300.00	30	7	34	207	0.164251207729469	0.504698359691615	0.504698359691615	true	false	false	true
78c6c713-802c-4f04-9137-ece08bb36547	2026-09-23 09:58	2026-09-23 09:58	2026-09-23 09:58	USO	USO261030C00157500	call	157.5000	2026-10-30	5.9500	5.9000	6.1500	147.9212	21420.00	0.00	20825.00	36	10	75	97	0.77319587628866	0.505539610145957	0.505539610145957	true	false	false	true
683feca4-f46a-4649-bb90-5ce594f7c5db	2026-09-23 09:58	2026-09-23 09:58	2026-09-23 09:58	USO	USO261030C00162000	call	162.0000	2026-10-30	4.7500	4.7000	4.9500	147.9212	20900.00	0.00	18525.00	44	11	44	532	0.0827067669172932	0.513381541931331	0.513381541931331	true	false	false	true
e4c8ac44-9db3-4f5d-a07e-986e8c692d0f	2026-09-23 09:57	2026-09-23 09:57	2026-09-23 09:57	USO	USO260930C00151000	call	151.0000	2026-09-30	3.1500	3.1500	3.2500	147.9700	11025.00	0.00	11025.00	35	5	193	274	0.704379562043796	0.539984386599266	0.539984386599266	true	false	false	true
be1b43bc-e8ab-4c1b-b6af-99a94508bda0	2026-09-23 09:55	2026-09-23 09:55	2026-09-23 09:55	USO	USO261023C00150000	call	150.0000	2026-10-23	7.7500	7.5500	7.7500	147.9900	11625.00	11625.00	0.00	15	7	18	223	0.0807174887892377	0.499398444593979	0.499398444593979	false	false	false	true
e26cbaa8-2fc1-43df-84ab-6e7c871e3a89	2026-09-23 09:54	2026-09-23 09:54	2026-09-23 09:54	USO	USO261016P00131000	put	131.0000	2026-10-16	1.5800	1.5200	1.6100	148.0250	12801.00	12487.00	314.00	81	25	82	797	0.10288582183187	0.513851971976527	0.513851971976527	true	false	false	true