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:alert_rule = RepeatedHitsDescendingFill×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	expiry

46e39192-998c-46e5-91f9-6fdc9d1a32dd	2026-08-27 13:45	2026-08-27 13:45	2026-08-27 13:45	USO	USO260909P00124000	put	124.0000	2026-09-09	1.7600	1.6400	2.3100	129.0500	14431.00	2491.00	11940.00	82	16	208	37	5.62162162162162	0.405729970384591	0.394743401565234	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	Financial Services	1228364647.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T17:46:53.178792Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
18affccc-d1ab-4b3f-ac06-973a6f9d1c57	2026-08-26 11:56	2026-08-26 11:56	2026-08-26 11:56	USO	USO260902P00132000	put	132.0000	2026-09-02	5.0500	4.7000	5.0500	128.6701	65130.00	65130.00	0.00	129	15	134	63	2.12698412698413	0.441070447719119	0.433511133146457	true	false	false	true
86e11681-98fa-488f-a0a3-fc100c0fdb9a	2026-08-26 11:51	2026-08-26 11:51	2026-08-26 11:51	USO	USO260911C00134000	call	134.0000	2026-09-11	2.4700	2.1500	2.5800	128.4700	56240.00	46892.00	9348.00	228	6	286	65	4.4	0.426752186751077	0.423737334907856	true	false	false	true
8599f209-5a6d-47d3-be3c-6ee04b63049c	2026-08-26 11:51	2026-08-26 11:51	2026-08-26 11:51	USO	USO260911C00135000	call	135.0000	2026-09-11	2.2500	1.8500	2.3200	128.4450	12845.00	12410.00	435.00	57	9	98	118	0.830508474576271	0.432214208567954	0.428057154616403	true	false	false	true
1beb065c-839e-4cc7-ae76-b8be00a7549c	2026-08-26 11:17	2026-08-26 11:17	2026-08-26 11:17	USO	USO260911P00130000	put	130.0000	2026-09-11	5.8500	5.5000	6.0000	127.7320	14030.00	13450.00	580.00	24	13	26	45	0.577777777777778	0.442166606405572	0.437442146725915	true	false	false	true
490c0031-0574-4b13-a895-123f25e7efe9	2026-08-26 11:14	2026-08-26 11:14	2026-08-26 11:14	USO	USO260911C00136000	call	136.0000	2026-09-11	1.8300	1.3700	1.8350	127.7800	19942.00	19942.00	0.00	109	24	166	34	4.88235294117647	0.43693694473052	0.43693694473052	true	false	false	true
29f569f2-d17a-4f7f-927e-b90f400d31a8	2026-08-26 11:06	2026-08-26 11:06	2026-08-26 11:06	USO	USO261218P00130000	put	130.0000	2026-12-18	13.1500	13.0500	13.2500	127.4450	13154.00	5264.00	0.00	10	5	73	2862	0.0255066387141859	0.443272783803654	0.443272783803654	false	false	false	true
bec652e8-ba1e-4c25-97e8-97066a6208bf	2026-08-26 10:45	2026-08-26 10:45	2026-08-26 10:45	USO	USO260904C00136000	call	136.0000	2026-09-04	0.9900	0.8100	1.0000	127.2200	74580.00	74291.00	192.00	752	15	2254	226	9.97345132743363	0.471961740180359	0.464709120630301	true	false	false	true
8e7176a4-3a64-4303-8848-29c17c301ae8	2026-08-26 09:51	2026-08-26 09:51	2026-08-26 09:51	USO	USO260918C00133500	call	133.5000	2026-09-18	3.0000	2.1300	3.0500	126.9400	12597.00	8700.00	3897.00	42	8	50	11	4.54545454545455	0.428232517725135	0.428232517725135	true	false	false	true
46370ecf-af3c-4b42-b72c-d0b68e93fe6d	2026-08-25 15:39	2026-08-25 15:39	2026-08-25 15:39	USO	USO260828C00135000	call	135.0000	2026-08-28	0.3200	0.3100	0.3500	127.5900	31023.00	7392.00	18912.00	961	12	3268	3735	0.874966532797858	0.505335576905097	0.509771940866188	false	false	false	true
58e4c2eb-9cfe-49e4-9d68-3ac4c4972f23	2026-08-25 12:51	2026-08-25 12:51	2026-08-25 12:51	USO	USO261016P00122000	put	122.0000	2026-10-16	5.2500	5.0000	5.2500	127.8500	142788.00	142788.00	0.00	272	54	1857	1974	0.940729483282675	0.43184342008631	0.43184342008631	true	false	false	true
f28b8702-ec6e-4b59-a9be-c126d6d0e313	2026-08-25 10:30	2026-08-25 10:30	2026-08-25 10:30	USO	USO260918C00120000	call	120.0000	2026-09-18	10.8500	10.5500	10.8500	128.5300	244115.00	241955.00	2160.00	225	11	268	2828	0.0947666195190948	0.425891280195957	0.413520229111345	true	false	false	true
32a60005-85cd-4c08-9657-e3bb024b2015	2026-08-25 10:00	2026-08-25 10:00	2026-08-25 10:00	USO	USO260828C00135000	call	135.0000	2026-08-28	0.5100	0.4300	0.5100	128.2100	38000.00	38000.00	0.00	750	6	1612	3735	0.431593038821954	0.547442847480608	0.543843504828498	false	false	false	true
0e9302e4-3a6e-441d-8d4d-cf76e17cce13	2026-08-25 09:44	2026-08-25 09:44	2026-08-25 09:44	USO	USO261016P00114000	put	114.0000	2026-10-16	2.4800	2.3000	2.5000	127.8100	58200.00	14576.00	43624.00	235	5	687	1443	0.476091476091476	0.421092169192434	0.419620567812703	false	false	false	true
60abda5e-d77e-4291-ae10-11a26b4e8818	2026-08-24 15:52	2026-08-24 15:52	2026-08-24 15:52	USO	USO261218P00120000	put	120.0000	2026-12-18	6.8500	6.5500	6.8500	132.1601	171188.00	171188.00	0.00	250	12	291	2759	0.105472997462849	0.445163687086412	0.444770216998655	false	false	false	true
b2a94732-c0e8-4f56-a60f-6bfb1466c8a9	2026-08-24 10:30	2026-08-24 10:30	2026-08-24 10:30	USO	USO260911C00138000	call	138.0000	2026-09-11	3.1000	2.9300	3.1000	132.0200	114334.00	114334.00	0.00	369	7	993	44	22.5681818181818	0.460627254937413	0.45997680499732	false	false	false	true
d555a272-276f-40f2-90cd-99f432db2c31	2026-08-21 13:39	2026-08-21 13:38	2026-08-21 13:38	USO	USO260821C00135000	call	135.0000	2026-08-21	0.6900	0.6800	0.7800	135.6134	13735.00	9380.00	4355.00	198	15	12986	5620	2.31067615658363	0.319225904745392	0.335420102116043	false	false	false	true
d2d4e8e9-8ae4-486b-a74d-1d9957f92c88	2026-08-21 10:37	2026-08-21 10:37	2026-08-21 10:37	USO	USO260828C00150000	call	150.0000	2026-08-28	0.4400	0.3600	0.4400	134.5946	21956.00	20988.00	0.00	500	22	1059	3625	0.292137931034483	0.56839753821692	0.56839753821692	true	false	false	true
c7a46af1-cf0a-4be5-a5e9-4f64393fa410	2026-08-20 15:28	2026-08-20 15:28	2026-08-20 15:28	USO	USO261218P00130000	put	130.0000	2026-12-18	10.6400	10.3500	10.7000	134.7100	12768.00	12768.00	0.00	12	5	151	2711	0.0556990040575433	0.454848442654977	0.452119392745546	false	false	false	true
2e050313-43e1-4ce8-a1f2-0c37aced5658	2026-08-20 11:21	2026-08-20 11:21	2026-08-20 11:21	USO	USO260918C00145000	call	145.0000	2026-09-18	3.5300	3.5000	3.6000	134.2150	52982.00	0.00	52982.00	150	9	2630	4928	0.533685064935065	0.486984609866509	0.486984609866509	false	false	false	true
ed3601c5-22f4-48b8-8bb0-5587f9d0a556	2026-08-20 11:10	2026-08-20 11:10	2026-08-20 11:10	USO	USO260828P00130000	put	130.0000	2026-08-28	2.0100	1.7000	2.1100	133.5000	12460.00	11455.00	1005.00	62	17	378	738	0.51219512195122	0.453149732999919	0.453149732999919	true	false	false	true
a7265fff-c048-49d3-8043-561693a71c53	2026-08-20 09:55	2026-08-20 09:55	2026-08-20 09:55	USO	USO260826C00150000	call	150.0000	2026-08-26	0.3400	0.2200	0.4000	134.3200	16988.00	16988.00	0.00	500	17	535	6220	0.0860128617363344	0.587034181475061	0.58564049508012	true	false	false	true
1bf0cd53-dd5b-4632-93ab-578acaa6712c	2026-08-20 09:55	2026-08-20 09:55	2026-08-20 09:55	USO	USO261016P00100000	put	100.0000	2026-10-16	0.4700	0.4500	0.5000	134.2750	23550.00	21150.00	2400.00	500	6	1128	31993	0.0352577126246366	0.470919507088537	0.468874134512494	false	false	false	true
f582c61e-b209-4d81-8ccb-453c2b4ac09e	2026-08-20 09:53	2026-08-20 09:53	2026-08-20 09:53	USO	USO260918C00150000	call	150.0000	2026-09-18	2.6000	2.5000	2.6000	134.2382	129835.00	115535.00	0.00	500	24	1130	10453	0.108102936955898	0.504894259130374	0.504894259130374	true	false	false	true
8d105e09-d84f-4b7d-905d-660c7efd82cb	2026-08-20 09:52	2026-08-20 09:52	2026-08-20 09:52	USO	USO260918P00117000	put	117.0000	2026-09-18	0.9800	0.7700	1.1600	134.2526	98276.00	92440.00	5836.00	1002	72	1010	1214	0.831960461285008	0.440584835264346	0.439231405644363	true	false	false	true
8adadb19-49a1-45ab-b8b7-9c39b0f57055	2026-08-20 09:30	2026-08-20 09:30	2026-08-20 09:30	USO	USO260821C00137000	call	137.0000	2026-08-21	0.9600	0.9300	1.1500	134.7300	12181.00	190.00	10361.00	127	30	130	1029	0.126336248785228	0.661369436804059	0.653447580014243	true	false	false	true
9620906d-da42-4d36-af90-65d836456f53	2026-08-19 15:18	2026-08-19 15:17	2026-08-19 15:17	USO	USO270617C00179000	call	179.0000	2027-06-17	6.9500	6.0000	8.2500	131.0400	14600.00	7700.00	6900.00	21	5	22	0	0	0.401980481022673	0.401980481022673	false	false	false	true
bdc1d9a0-417b-491f-9c0e-c2f34e1ab224	2026-08-19 12:12	2026-08-19 12:12	2026-08-19 12:12	USO	USO281215P00150000	put	150.0000	2028-12-15	34.0100	33.4000	36.0500	132.7274	17006.00	6800.00	10206.00	5	5	13	1100	0.0118181818181818	0.401579039764551	0.401194232122432	false	false	false	true
018fb21c-8a1b-4404-93e8-c35c4d15f03e	2026-08-19 10:21	2026-08-19 10:21	2026-08-19 10:21	USO	USO260918C00140000	call	140.0000	2026-09-18	3.7600	3.7500	3.9500	131.6450	22536.00	0.00	22536.00	60	5	134	6111	0.0219276714122075	0.453851945242697	0.453851945242697	false	false	false	true
6a40e068-a99d-462a-93d1-265514f03f49	2026-08-18 15:55	2026-08-18 15:55	2026-08-18 15:55	USO	USO260826C00150000	call	150.0000	2026-08-26	0.2500	0.2200	0.2900	130.0000	12520.00	12245.00	275.00	501	6	2639	2810	0.93914590747331	0.56533685768219	0.56533685768219	false	false	false	true
02f4f658-d252-428d-a54d-da9b3e8a775a	2026-08-18 14:07	2026-08-18 14:07	2026-08-18 14:07	USO	USO261218C00135000	call	135.0000	2026-12-18	11.9500	11.7500	12.0500	130.6800	80085.00	68125.00	11960.00	67	11	1134	4913	0.230816201913291	0.434723184160216	0.434391012434198	true	false	false	true
eb3fbdfd-28e3-44f1-9ea1-c8223a992544	2026-08-18 13:59	2026-08-18 13:59	2026-08-18 13:59	USO	USO261218P00130000	put	130.0000	2026-12-18	12.2500	12.2000	12.2750	130.5838	48990.00	36740.00	0.00	40	8	565	1884	0.299893842887473	0.448880679578738	0.448880679578738	true	false	false	true
cef3e341-e905-451f-bfb4-ee8791e9605c	2026-08-18 12:13	2026-08-18 12:13	2026-08-18 12:13	USO	USO261016P00109000	put	109.0000	2026-10-16	1.5100	1.3500	1.5200	131.0800	15519.00	15369.00	150.00	103	12	117	388	0.301546391752577	0.44020663921777	0.441143709449939	true	false	false	true
0708707b-7854-4454-8aa1-96cdb1124a06	2026-08-18 12:07	2026-08-18 12:06	2026-08-18 12:06	USO	USO260828P00125000	put	125.0000	2026-08-28	1.3100	1.1600	1.3300	131.2500	13635.00	12839.00	131.00	104	5	347	324	1.07098765432099	0.434343854582724	0.431328716803197	true	false	false	true
a01e6a04-afaf-492f-bcdb-dd07b0edf6aa	2026-08-18 10:41	2026-08-18 10:41	2026-08-18 10:41	USO	USO261218C00140000	call	140.0000	2026-12-18	9.9300	9.9000	10.5500	130.1400	11915.00	995.00	10920.00	12	6	20	10289	0.00194382350082613	0.439808451231122	0.440422779671891	true	false	false	true
75c13365-df1f-48a0-9985-b00e2f3cedc8	2026-08-18 10:41	2026-08-18 10:41	2026-08-18 10:41	USO	USO261218C00138000	call	138.0000	2026-12-18	10.5400	10.3500	11.2500	130.1801	45310.00	3120.00	40090.00	43	14	43	107	0.401869158878505	0.43501290948596	0.430486984268138	true	false	false	true
19b959ec-ee19-45d8-98bf-5e1297a45aab	2026-08-18 09:58	2026-08-18 09:58	2026-08-18 09:58	USO	USO260826C00150000	call	150.0000	2026-08-26	0.4500	0.1900	0.4500	131.3600	22452.00	22272.00	0.00	500	30	500	2810	0.177935943060498	0.624995901799874	0.624995901799874	true	false	false	true
14c5ef6d-744a-42cd-80ff-80826748d919	2026-08-17 13:23	2026-08-17 13:23	2026-08-17 13:23	USO	USO260925C00138000	call	138.0000	2026-09-25	5.0000	4.1000	5.1500	128.8000	49970.00	48970.00	1000.00	100	24	100	0	0	0.498509859842828	0.498509859842828	false	false	false	true
01d4be38-1ec2-4abe-b827-e403d59e0c21	2026-08-17 13:21	2026-08-17 13:21	2026-08-17 13:21	USO	USO261218P00100000	put	100.0000	2026-12-18	2.0800	2.0700	2.2400	128.6638	26389.00	12898.00	13491.00	127	20	143	8300	0.0172289156626506	0.432371026732215	0.431695056820855	false	false	false	true