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:option_symbol = USO261016C00170000×ticker = USO×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	expiry

7c63f598-5346-4da6-8f47-6ef7045905b5	2026-08-18 12:20	2026-08-18 12:20	2026-08-18 12:20	USO	USO261016C00170000	call	170.0000	2026-10-16	2.4100	2.3100	2.5800	130.9750	18316.00	0.00	18316.00	76	7	81	872	0.0928899082568807	0.580216784712569	0.580153698871422	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-08-18T16:50:14.134420Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bf1e57b1-7181-4d43-8e93-d442d1a765c6	2026-09-09 15:03	2026-09-09 15:03	2026-09-09 15:03	USO	USO261016C00170000	call	170.0000	2026-10-16	3.5000	3.3500	3.5000	149.7250	19250.00	19250.00	0.00	55	13	3118	1628	1.91523341523342	0.520521063715858	0.520521063715858	false	false	false	true
6047a930-0011-4cde-878d-5ee46e9ae147	2026-09-10 11:21	2026-09-10 11:21	2026-09-10 11:21	USO	USO261016C00170000	call	170.0000	2026-10-16	5.4500	5.4500	5.5000	154.9900	59405.00	0.00	59405.00	109	21	377	3938	0.095733875063484	0.55193643076805	0.55193643076805	false	false	false	true
2b94cd38-bf8e-4a6b-83b4-5e28e8de2a16	2026-09-10 11:52	2026-09-10 11:52	2026-09-10 11:52	USO	USO261016C00170000	call	170.0000	2026-10-16	6.0500	6.0500	6.2500	156.0600	40535.00	0.00	40535.00	67	22	606	3938	0.153885220924327	0.56473721879447	0.56473721879447	false	false	false	true
90019af0-1a27-4dda-ac42-da87d1460ee7	2026-09-10 12:43	2026-09-10 12:43	2026-09-10 12:43	USO	USO261016C00170000	call	170.0000	2026-10-16	6.5000	6.5000	6.8000	156.0000	16900.00	0.00	16900.00	26	5	859	3938	0.218131030980193	0.57741869973347	0.57741869973347	true	false	false	true
5f2c3b7d-8839-403d-bc40-a8d6dc45b630	2026-09-10 13:03	2026-09-10 13:03	2026-09-10 13:03	USO	USO261016C00170000	call	170.0000	2026-10-16	6.4000	6.1500	6.5000	156.5500	21120.00	21120.00	0.00	33	5	960	3938	0.243778567800914	0.57419166112168	0.57419166112168	false	false	false	true
b7ad79b9-dea3-466b-ab92-f1cbe4ee192a	2026-09-10 13:52	2026-09-10 13:52	2026-09-10 13:52	USO	USO261016C00170000	call	170.0000	2026-10-16	6.8500	6.8000	7.1000	157.0600	14385.00	0.00	14385.00	21	5	1185	3938	0.300914169629253	0.588220447711896	0.588220447711896	false	false	false	true
0962f487-b3a5-49ba-8306-6b31337e4b47	2026-09-10 13:52	2026-09-10 13:52	2026-09-10 13:52	USO	USO261016C00170000	call	170.0000	2026-10-16	6.8500	6.8000	7.1000	157.0600	25345.00	0.00	24660.00	37	9	1164	3938	0.295581513458608	0.588220447711896	0.588220447711896	true	false	false	true
2ed404f9-ed01-4ed8-bc36-f3989d9dbec7	2026-09-10 14:28	2026-09-10 14:28	2026-09-10 14:28	USO	USO261016C00170000	call	170.0000	2026-10-16	7.2000	7.2000	7.6500	158.0800	15120.00	0.00	15120.00	21	9	1301	3938	0.330370746571864	0.586085885579867	0.586085885579867	false	false	false	true
db9cc3f6-b4f0-4196-b821-2fc4c8ddd959	2026-09-10 14:28	2026-09-10 14:28	2026-09-10 14:28	USO	USO261016C00170000	call	170.0000	2026-10-16	7.1000	7.0000	7.6500	157.8500	35500.00	0.00	35500.00	50	26	1352	3938	0.343321482986287	0.585512474315463	0.585512474315463	true	false	false	true
4e13cf3f-1f82-4085-957e-918b3ddaa840	2026-09-10 15:59	2026-09-10 15:59	2026-09-10 15:59	USO	USO261016C00170000	call	170.0000	2026-10-16	7.5500	7.2500	7.5500	158.3500	43035.00	43035.00	0.00	57	18	1658	3938	0.421025901472829	0.598858423114748	0.598858423114748	true	false	false	true
57f91626-2465-4492-bfbb-a43e1e8619cb	2026-09-11 14:22	2026-09-11 14:21	2026-09-11 14:21	USO	USO261016C00170000	call	170.0000	2026-10-16	5.5500	5.3000	5.5500	154.5700	53272.00	53272.00	0.00	96	5	1123	4171	0.269239990409974	0.573636800347404	0.573636800347404	false	false	false	true
bff1d89f-199f-4c5c-be62-2e6940d5c8ec	2026-09-14 14:47	2026-09-14 14:47	2026-09-14 14:47	USO	USO261016C00170000	call	170.0000	2026-10-16	5.2500	5.0500	5.2500	155.4000	27825.00	27825.00	0.00	53	9	727	4175	0.174131736526946	0.566172125865634	0.566172125865634	false	false	false	true
b75e1d5f-47b3-4d8d-8c43-1676b70fd7a8	2026-09-15 11:14	2026-09-15 11:14	2026-09-15 11:14	USO	USO261016C00170000	call	170.0000	2026-10-16	7.4900	7.2000	7.5000	160.6700	18720.00	18720.00	0.00	25	5	621	4281	0.145059565522074	0.591849558736121	0.586361667953702	false	false	false	true
0c5eae14-c95c-4379-a2e0-0461d527a0c7	2026-09-15 11:18	2026-09-15 11:18	2026-09-15 11:18	USO	USO261016C00170000	call	170.0000	2026-10-16	7.2000	7.1500	7.4500	160.5100	29525.00	720.00	28805.00	41	13	662	4281	0.154636767110488	0.578624875476569	0.578961131962471	true	false	false	true
346318be-64d6-4d2b-8e0b-ec5fb36f9495	2026-09-15 12:56	2026-09-15 12:56	2026-09-15 12:56	USO	USO261016C00170000	call	170.0000	2026-10-16	8.1000	8.1000	8.3500	162.2900	25920.00	0.00	25920.00	32	9	842	4281	0.196683017986452	0.587189158955058	0.587189158955058	false	false	false	true
f7ca2db9-f708-42db-a555-bec5dd238899	2026-09-15 12:56	2026-09-15 12:56	2026-09-15 12:56	USO	USO261016C00170000	call	170.0000	2026-10-16	8.1500	8.1500	8.2500	162.2900	18745.00	0.00	18745.00	23	7	915	4281	0.213735108619481	0.58987529154481	0.58987529154481	false	false	false	true
faf353af-a7d9-4d29-a8b7-e8ae544b05f0	2026-09-15 12:56	2026-09-15 12:56	2026-09-15 12:56	USO	USO261016C00170000	call	170.0000	2026-10-16	8.2000	8.2000	8.2500	162.2599	32800.00	0.00	32800.00	40	10	973	4281	0.227283345012847	0.593264559095353	0.593264559095353	false	false	false	true
74541be4-f18a-4ab9-8a2a-d981891d6a60	2026-09-15 12:56	2026-09-15 12:56	2026-09-15 12:56	USO	USO261016C00170000	call	170.0000	2026-10-16	8.2000	8.2000	8.2500	162.2900	37720.00	0.00	37720.00	46	12	1019	4281	0.238028498014483	0.592560750570721	0.592560750570721	false	false	false	true
30242a61-38a5-429a-88fc-5eea9ee44e17	2026-09-16 09:32	2026-09-16 09:32	2026-09-16 09:32	USO	USO261016C00170000	call	170.0000	2026-10-16	6.1500	6.1000	6.6000	159.1150	93545.00	1865.00	91680.00	152	27	170	3952	0.0430161943319838	0.563573161508178	0.560690461826375	true	false	false	true
530d6433-04e9-4f79-a66d-4aa7d0821a68	2026-09-16 11:23	2026-09-16 11:23	2026-09-16 11:23	USO	USO261016C00170000	call	170.0000	2026-10-16	4.9900	4.8000	5.1000	155.8400	28430.00	28430.00	0.00	57	6	512	3952	0.129554655870445	0.559968145916951	0.559968145916951	false	false	false	true
5d8cd156-6b1e-4614-a067-2f199b935278	2026-09-16 12:35	2026-09-16 12:35	2026-09-16 12:35	USO	USO261016C00170000	call	170.0000	2026-10-16	5.2500	5.2500	5.4000	156.7707	299250.00	0.00	299250.00	570	9	1308	3952	0.330971659919028	0.557368302155977	0.557368302155977	false	false	false	true
0418c24a-b799-4c5c-8c17-d3c711587879	2026-09-16 14:00	2026-09-16 13:59	2026-09-16 13:59	USO	USO261016C00170000	call	170.0000	2026-10-16	5.0000	4.9000	5.3000	156.0000	150000.00	143500.00	6500.00	300	5	1649	3952	0.417257085020243	0.548742863926833	0.548742863926833	false	false	false	true
6cb454c9-0274-44e2-92fc-066429c0996d	2026-09-17 10:17	2026-09-17 10:17	2026-09-17 10:17	USO	USO261016C00170000	call	170.0000	2026-10-16	3.6000	3.4000	3.6000	153.8701	39224.00	39224.00	0.00	109	19	187	5217	0.0358443549932912	0.518664694061482	0.518664694061482	false	false	false	true
1cf1fa60-e732-494b-8ab8-1e24af759a32	2026-09-17 11:05	2026-09-17 11:05	2026-09-17 11:05	USO	USO261016C00170000	call	170.0000	2026-10-16	3.7500	3.6000	3.7500	155.1017	10875.00	10875.00	0.00	29	7	557	5217	0.106766340808894	0.505091196045818	0.505091196045818	true	false	false	true
4546827d-51ea-42fe-b734-44a44c36c913	2026-09-17 11:30	2026-09-17 11:29	2026-09-17 11:29	USO	USO261016C00170000	call	170.0000	2026-10-16	3.7500	3.7000	3.8500	154.6971	112500.00	52875.00	37500.00	300	8	879	5217	0.168487636572743	0.512935616106219	0.512935616106219	false	false	false	true
22c08387-c562-4a4f-9709-3bda197ff440	2026-09-17 11:32	2026-09-17 11:32	2026-09-17 11:32	USO	USO261016C00170000	call	170.0000	2026-10-16	3.7500	3.7000	3.8000	154.5700	81375.00	47625.00	19500.00	217	5	1479	5217	0.283496262219666	0.515396580080956	0.515396580080956	false	false	false	true
a2172c4c-7f89-42df-b765-bcb2bd895172	2026-09-17 12:15	2026-09-17 12:15	2026-09-17 12:15	USO	USO261016C00170000	call	170.0000	2026-10-16	3.9500	3.9500	4.0500	155.0060	39895.00	0.00	39895.00	101	12	1850	5217	0.354609929078014	0.520250154999103	0.520250154999103	false	false	false	true
f7fbec88-b0ea-4338-90ac-ee10406e39b1	2026-09-17 12:20	2026-09-17 12:20	2026-09-17 12:20	USO	USO261016C00170000	call	170.0000	2026-10-16	4.0500	4.0500	4.1000	155.0510	47385.00	0.00	47385.00	117	21	2030	5217	0.389112516772091	0.525966668222534	0.525966668222534	false	false	false	true
4fe90ed0-7b0c-4f37-b503-7d69789ebacd	2026-09-17 12:20	2026-09-17 12:20	2026-09-17 12:20	USO	USO261016C00170000	call	170.0000	2026-10-16	4.0500	4.0500	4.1000	155.0510	11340.00	0.00	7695.00	28	5	1913	5217	0.366685834770941	0.525966668222534	0.525966668222534	false	false	false	true
1521b8e6-ac2f-4de8-a2a3-65f8322064ae	2026-09-17 12:28	2026-09-17 12:28	2026-09-17 12:28	USO	USO261016C00170000	call	170.0000	2026-10-16	4.0500	4.0000	4.2000	155.0800	37665.00	0.00	34830.00	93	18	2136	5217	0.409430707303048	0.52539449690028	0.52539449690028	false	false	false	true
a6968486-715f-4177-816b-ef4a5cf480c1	2026-09-17 12:54	2026-09-17 12:54	2026-09-17 12:54	USO	USO261016C00170000	call	170.0000	2026-10-16	4.5500	4.4500	4.6000	156.1500	45045.00	910.00	44135.00	99	20	2299	5217	0.440674717270462	0.536249397126775	0.536249397126775	false	false	false	true
8c76dd6e-ed68-4da5-ab2e-c75953bc0982	2026-09-17 15:42	2026-09-17 15:42	2026-09-17 15:42	USO	USO261016C00170000	call	170.0000	2026-10-16	3.8500	3.8500	3.9500	155.2700	346500.00	0.00	346500.00	900	12	3292	5217	0.63101399271612	0.508461303578265	0.508461303578265	false	false	false	true
667e52a5-aafc-4c46-b152-84c7fecb4485	2026-09-18 09:59	2026-09-18 09:59	2026-09-18 09:59	USO	USO261016C00170000	call	170.0000	2026-10-16	4.3000	4.3000	4.3500	157.1600	467840.00	0.00	467840.00	1088	6	1174	5845	0.200855431993157	0.50908303645575	0.50908303645575	false	false	false	true
cc86fdb4-6f55-40cc-8189-56891f770563	2026-09-21 10:05	2026-09-21 10:05	2026-09-21 10:05	USO	USO261016C00170000	call	170.0000	2026-10-16	1.9700	1.9700	2.0500	148.7100	11820.00	0.00	11820.00	60	5	373	7010	0.0532097004279601	0.524088507776833	0.524088507776833	false	false	false	true
36e3ac36-4640-4a1f-b73f-99a0a8a6b4a6	2026-09-21 15:25	2026-09-21 15:25	2026-09-21 15:25	USO	USO261016C00170000	call	170.0000	2026-10-16	1.9000	1.9000	1.9700	148.4700	38760.00	0.00	38760.00	204	28	1101	7010	0.157061340941512	0.521631251301072	0.521631251301072	true	false	false	true
abc39da6-8f00-4696-9b3e-e76c11a200de	2026-09-21 15:26	2026-09-21 15:26	2026-09-21 15:26	USO	USO261016C00170000	call	170.0000	2026-10-16	1.8900	1.8900	1.9600	148.5000	94500.00	0.00	94500.00	500	37	1897	7010	0.270613409415121	0.520127497208871	0.520127497208871	true	false	false	true
8192373f-6635-4e12-88f4-29b8ff4bb9b3	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	USO	USO261016C00170000	call	170.0000	2026-10-16	1.3500	1.3500	1.3800	145.6100	92880.00	0.00	27135.00	688	11	769	7918	0.0971204849709523	0.523506984410675	0.523506984410675	true	false	false	true
cbb3a1c6-7a16-4490-89de-637e6dd89f8b	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	USO	USO261016C00170000	call	170.0000	2026-10-16	1.3500	1.3500	1.3800	145.5700	54000.00	0.00	54000.00	400	33	1169	7918	0.147638292498106	0.523846183227329	0.524185386173081	false	false	false	true
905d4965-6192-459e-bd85-7902ec4051d0	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	USO	USO261016C00170000	call	170.0000	2026-10-16	1.3600	1.3100	1.3900	145.5100	40936.00	32504.00	8432.00	301	8	1581	7918	0.199671634251074	0.526390041756658	0.526390041756658	true	false	false	true
848026db-dd58-4117-b23a-71f088395f0a	2026-09-23 13:04	2026-09-23 13:04	2026-09-23 13:04	USO	USO261016C00170000	call	170.0000	2026-10-16	1.6000	1.5400	1.6000	147.0900	11040.00	11040.00	0.00	69	8	2929	8033	0.364620938628159	0.53783804887272	0.53783804887272	false	false	false	true
58c4c9b3-2cb6-49be-9e8f-4939561f9b67	2026-09-25 13:52	2026-09-25 13:52	2026-09-25 13:52	USO	USO261016C00170000	call	170.0000	2026-10-16	1.6100	1.5800	1.6300	148.3700	25760.00	22057.00	1288.00	160	16	2472	7077	0.349300551080967	0.540531197107849	0.540531197107849	false	false	false	true
59ab3fb4-ce1f-4e69-a282-d0c88f4a1e3a	2026-09-25 13:52	2026-09-25 13:52	2026-09-25 13:52	USO	USO261016C00170000	call	170.0000	2026-10-16	1.6200	1.5800	1.6200	148.3600	17820.00	972.00	0.00	110	7	2582	7077	0.364843860392822	0.54184185751847	0.54184185751847	false	false	false	true
9ada2f8e-8ea3-4997-b595-b26b43578dc5	2026-09-25 14:00	2026-09-25 14:00	2026-09-25 14:00	USO	USO261016C00170000	call	170.0000	2026-10-16	1.5500	1.5500	1.6100	148.0000	20150.00	0.00	20150.00	130	8	2762	7077	0.390278366539494	0.539229823936438	0.539229823936438	false	false	false	true