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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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

7a9e00b0-681f-45e3-a9bf-aa09dade5e53	2026-09-28 14:04	2026-09-28 14:04	2026-09-28 14:04	USO	USO261009P00150000	put	150.0000	2026-10-09	6.2500	6.0500	6.3000	148.0000	30000.00	26250.00	0.00	48	11	101	416	0.242788461538462	0.560924520263127	0.560924520263127	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	Financial Services	1228364647.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T18:10:39.755253Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
361c4d89-d121-441e-8028-2988165ab135	2026-09-28 14:03	2026-09-28 14:02	2026-09-28 14:02	USO	USO261023C00153000	call	153.0000	2026-10-23	6.5000	6.5000	6.9000	149.0000	17550.00	0.00	17550.00	27	12	44	208	0.211538461538462	0.516036962463773	0.516036962463773	true	false	false	true
27dc9157-509f-434e-a000-db0cfa5f9437	2026-09-28 14:02	2026-09-28 14:02	2026-09-28 14:02	USO	USO261030C00160000	call	160.0000	2026-10-30	5.2000	5.1000	5.4000	149.0000	10920.00	0.00	10920.00	21	9	139	686	0.202623906705539	0.518401663561164	0.518401663561164	true	false	false	true
dfd26f5f-fc60-40d8-9b05-e9d6d02be8d2	2026-09-28 14:00	2026-09-28 14:00	2026-09-28 14:00	USO	USO261023C00156000	call	156.0000	2026-10-23	5.5500	4.7000	5.5500	149.0000	11100.00	11100.00	0.00	20	12	30	125	0.24	0.519152140896106	0.519152140896106	true	false	false	true
4e6e446d-ccff-4ede-9154-7205e454e1cc	2026-09-28 13:58	2026-09-28 13:58	2026-09-28 13:58	USO	USO261023P00141500	put	141.5000	2026-10-23	4.8000	4.7000	5.1000	149.2000	10080.00	960.00	9120.00	21	7	135	156	0.865384615384615	0.542965251916688	0.542965251916688	false	false	false	true
7cec2edc-1212-4779-9c28-242ffbce00b1	2026-09-28 13:57	2026-09-28 13:56	2026-09-28 13:56	USO	USO261030P00141000	put	141.0000	2026-10-30	5.3500	4.4000	5.3500	149.1100	20865.00	20865.00	0.00	39	8	62	204	0.303921568627451	0.527754993968037	0.527754993968037	false	false	false	true
1d9e163a-0f41-4751-9100-fce8e00ab983	2026-09-28 13:57	2026-09-28 13:56	2026-09-28 13:56	USO	USO261023P00140500	put	140.5000	2026-10-23	4.4000	4.2000	4.4500	149.1100	14960.00	13200.00	0.00	34	13	100	293	0.341296928327645	0.538294450233503	0.538294450233503	true	false	false	true
d99b0674-29a5-461a-acaa-d002149f3468	2026-09-28 13:51	2026-09-28 13:51	2026-09-28 13:51	USO	USO261023C00150000	call	150.0000	2026-10-23	7.5000	7.5000	7.8000	148.7060	14250.00	0.00	14250.00	19	11	68	274	0.248175182481752	0.509754475693826	0.509754475693826	false	false	false	true
be4605c8-0387-4502-abdb-cde1852fac96	2026-09-28 13:48	2026-09-28 13:48	2026-09-28 13:48	USO	USO261023P00144500	put	144.5000	2026-10-23	5.9000	5.7000	5.9000	149.1100	15340.00	15340.00	0.00	26	14	62	152	0.407894736842105	0.533660492532381	0.533660492532381	true	false	false	true
ce061991-4c51-4f45-a144-c513bc898e8e	2026-09-28 13:48	2026-09-28 13:48	2026-09-28 13:48	USO	USO261002C00150000	call	150.0000	2026-10-02	3.7000	3.5000	3.7000	149.1500	65117.00	65117.00	0.00	176	20	1386	2346	0.59079283887468	0.653388633037473	0.653388633037473	true	false	false	true
a960ed49-f71c-409b-b988-bd48af894b32	2026-09-28 13:48	2026-09-28 13:48	2026-09-28 13:48	USO	USO261030C00161000	call	161.0000	2026-10-30	4.9500	4.7500	5.4000	149.3900	22770.00	495.00	22275.00	46	20	74	665	0.111278195488722	0.517488479302518	0.517488479302518	true	false	false	true
6c580fd5-7f07-49ca-a92b-b72e4a9bf4ed	2026-09-28 13:46	2026-09-28 13:45	2026-09-28 13:45	USO	USO261023P00144500	put	144.5000	2026-10-23	5.9500	5.9500	6.5000	149.2000	10710.00	0.00	10710.00	18	7	36	152	0.236842105263158	0.539319948984706	0.539319948984706	false	false	false	true
83b8a512-d636-4ca1-a74c-e7a51fddac70	2026-09-28 13:45	2026-09-28 13:45	2026-09-28 13:45	USO	USO261007C00152000	call	152.0000	2026-10-07	3.9500	3.9500	4.2500	149.0000	15800.00	0.00	15800.00	40	16	306	6	51	0.557520505544468	0.557520505544468	true	false	false	true
9807732b-6684-47a8-be53-a58310278f94	2026-09-28 13:41	2026-09-28 13:41	2026-09-28 13:41	USO	USO261016C00130000	call	130.0000	2026-10-16	20.4000	20.4000	20.5750	149.0300	102000.00	0.00	102000.00	50	5	88	4405	0.0199772985244041	0.553886370926981	0.553886370926981	false	false	false	true
2f2bb144-a884-43e0-a677-1218b578eeae	2026-09-28 13:37	2026-09-28 13:37	2026-09-28 13:37	USO	USO261009P00146000	put	146.0000	2026-10-09	4.4000	3.8000	4.4500	149.0000	11440.00	2200.00	9240.00	26	5	104	279	0.372759856630824	0.574267168267117	0.574267168267117	false	false	false	true
8edeb0a8-2fc3-4651-b382-324116b38e46	2026-09-28 13:34	2026-09-28 13:34	2026-09-28 13:34	USO	USO261023C00175000	call	175.0000	2026-10-23	1.7000	1.7000	1.7800	149.0000	10370.00	0.00	10370.00	61	18	73	508	0.143700787401575	0.559861764901244	0.559861764901244	false	false	false	true
a4be1216-67e2-452d-b730-89c06cf59085	2026-09-28 13:30	2026-09-28 13:30	2026-09-28 13:30	USO	USO261009P00147000	put	147.0000	2026-10-09	4.7400	4.1500	4.7500	149.3300	35096.00	35096.00	0.00	74	14	164	386	0.424870466321244	0.577527178351615	0.577527178351615	false	false	false	true
1aac324e-6014-4f64-9a33-fa7ca28c3702	2026-09-28 13:28	2026-09-28 13:28	2026-09-28 13:28	USO	USO261030P00138000	put	138.0000	2026-10-30	4.3500	4.2000	4.4000	149.1800	16965.00	16095.00	0.00	39	15	41	194	0.211340206185567	0.53322500348373	0.53322500348373	false	false	false	true
185d4a95-ccf7-478d-b59e-295834bd43fc	2026-09-28 13:28	2026-09-28 13:28	2026-09-28 13:28	USO	USO280121P00121000	put	121.0000	2028-01-21	13.0000	11.3000	13.0000	149.2899	13000.00	13000.00	0.00	10	6	11	608	0.0180921052631579	0.460570680880835	0.460570680880835	false	false	false	true
58233aff-f42f-41ba-a2ef-f3ea0affb9ce	2026-09-28 13:27	2026-09-28 13:27	2026-09-28 13:27	USO	USO261007P00150000	put	150.0000	2026-10-07	5.6000	5.6000	6.5000	149.3900	15126.00	0.00	15126.00	27	16	100	56	1.78571428571429	0.571158555883892	0.572749449924151	true	false	false	true
a9249987-ab47-4293-84d4-709edae71bf5	2026-09-28 13:26	2026-09-28 13:26	2026-09-28 13:26	USO	USO261007P00148000	put	148.0000	2026-10-07	4.8000	4.7500	5.2000	148.9889	11520.00	0.00	9120.00	24	8	70	10	7	0.575489593491461	0.575489593491461	true	false	false	true
289cd498-51ed-46be-b3ec-71ae7b05ba06	2026-09-28 13:25	2026-09-28 13:25	2026-09-28 13:25	USO	USO261002P00155000	put	155.0000	2026-10-02	8.0000	7.7500	8.8000	148.7500	16800.00	0.00	16800.00	21	5	46	1125	0.0408888888888889	0.663565213366887	0.663565213366887	true	false	false	true
ef66bf2a-e22f-48fe-b725-cf2c9f8ffa1a	2026-09-28 13:21	2026-09-28 13:21	2026-09-28 13:21	USO	USO261023C00185000	call	185.0000	2026-10-23	0.9000	0.9000	2.0400	148.3300	11250.00	0.00	11250.00	125	27	163	320	0.509375	0.588638487481246	0.588638487481246	false	false	false	true
f3db6ec1-f9fa-48b8-8327-1a1476620969	2026-09-28 13:21	2026-09-28 13:21	2026-09-28 13:21	USO	USO261030P00142000	put	142.0000	2026-10-30	6.0500	5.8500	6.0500	148.4900	13310.00	13310.00	0.00	22	14	58	432	0.134259259259259	0.533808086380526	0.533808086380526	true	false	false	true
b2ee9c1b-1db2-4619-a8bb-cd1fd8a4705f	2026-09-28 13:21	2026-09-28 13:21	2026-09-28 13:21	USO	USO261030P00143000	put	143.0000	2026-10-30	6.4500	6.2500	6.4500	148.4900	12255.00	12255.00	0.00	19	5	62	245	0.253061224489796	0.532760722598028	0.532760722598028	true	false	false	true
c0a65fed-73a1-443b-9eb0-4c55a3bdf49e	2026-09-28 13:21	2026-09-28 13:21	2026-09-28 13:21	USO	USO261007P00141000	put	141.0000	2026-10-07	2.4400	2.2300	2.4400	148.5400	20740.00	20740.00	0.00	85	16	143	28	5.10714285714286	0.60041777710104	0.60041777710104	true	false	false	true
b70f4724-33b5-4b13-a167-6edc44585bea	2026-09-28 13:18	2026-09-28 13:18	2026-09-28 13:18	USO	USO261023P00147000	put	147.0000	2026-10-23	7.5500	7.2500	7.5500	148.0900	21895.00	21895.00	0.00	29	10	73	128	0.5703125	0.538461187737747	0.538461187737747	false	false	false	true
901c1e12-eca6-40dd-b11b-2a38dc595b3b	2026-09-28 13:18	2026-09-28 13:18	2026-09-28 13:18	USO	USO261007P00145000	put	145.0000	2026-10-07	3.9000	2.9900	3.9000	148.2300	21436.00	21436.00	0.00	55	12	1744	65	26.8307692307692	0.590739566414817	0.590739566414817	true	false	false	true
407d1adc-a9c1-4f0e-858b-ca93c38166a3	2026-09-28 13:15	2026-09-28 13:15	2026-09-28 13:15	USO	USO261016P00130000	put	130.0000	2026-10-16	1.5600	1.2200	1.5600	147.3700	23088.00	23088.00	0.00	148	35	1529	11215	0.136335265269728	0.586272602730081	0.586272602730081	false	false	false	true
62a29088-2e5a-408d-bf6b-c9616cef9a43	2026-09-28 13:15	2026-09-28 13:15	2026-09-28 13:15	USO	USO261030C00151000	call	151.0000	2026-10-30	7.7000	6.2500	7.7000	147.4196	20790.00	20790.00	0.00	27	10	48	33	1.45454545454545	0.519675730046472	0.519675730046472	false	false	false	true
21c26e73-131d-4a34-9f9f-d00226498a02	2026-09-28 13:15	2026-09-28 13:15	2026-09-28 13:15	USO	USO261030C00152500	call	152.5000	2026-10-30	7.1000	5.9500	7.1000	147.4196	19880.00	19880.00	0.00	28	10	33	115	0.28695652173913	0.519958097278474	0.519958097278474	true	false	false	true
b9df6a31-c85f-4d56-864f-41c29d0aa8e6	2026-09-28 13:15	2026-09-28 13:14	2026-09-28 13:14	USO	USO261009P00142000	put	142.0000	2026-10-09	3.5600	2.9500	3.6500	147.2960	11050.00	10695.00	355.00	31	23	127	208	0.610576923076923	0.588082380517107	0.593436155065176	true	false	false	true
45ce0fb0-52d0-4417-b2e3-c8cb31b5b162	2026-09-28 13:15	2026-09-28 13:14	2026-09-28 13:14	USO	USO261009P00139000	put	139.0000	2026-10-09	2.6800	2.3300	2.7300	146.9800	19853.00	14225.00	5628.00	74	7	81	410	0.197560975609756	0.595484759363204	0.599017354428233	true	false	false	true
4d68af0f-fe29-45dc-a4fb-3e02bcd89c13	2026-09-28 13:14	2026-09-28 13:14	2026-09-28 13:14	USO	USO260930C00150000	call	150.0000	2026-09-30	2.2000	2.0000	2.2000	147.5850	11000.00	11000.00	0.00	50	7	784	953	0.822665267576075	0.740543479340568	0.740543479340568	false	false	false	true
753f323d-610e-4745-a844-a39557aa42e9	2026-09-28 13:14	2026-09-28 13:14	2026-09-28 13:14	USO	USO261120P00139000	put	139.0000	2026-11-20	7.1000	6.5000	7.1000	147.7600	12780.00	12780.00	0.00	18	6	58	53	1.09433962264151	0.519001681227784	0.519001681227784	false	false	false	true
3842f605-1386-43e1-b979-18ae946dff12	2026-09-28 13:14	2026-09-28 13:14	2026-09-28 13:14	USO	USO261120C00180000	call	180.0000	2026-11-20	3.1500	3.1500	3.5000	147.4300	10710.00	0.00	10710.00	34	11	58	1916	0.0302713987473904	0.542857908567846	0.542857908567846	false	false	false	true
39c40903-f5ec-4ad6-8edb-6563629188e1	2026-09-28 13:12	2026-09-28 13:12	2026-09-28 13:12	USO	USO261120P00149000	put	149.0000	2026-11-20	12.1000	11.8000	12.1000	147.5748	36300.00	36300.00	0.00	30	10	31	603	0.0514096185737977	0.527658548246122	0.527658548246122	false	false	false	true
2cdf6081-ef0e-46a8-8b67-d29cf73c981d	2026-09-28 13:12	2026-09-28 13:12	2026-09-28 13:12	USO	USO261120C00171000	call	171.0000	2026-11-20	4.4000	4.1000	4.4000	147.5748	24200.00	24200.00	0.00	55	8	85	67	1.26865671641791	0.5213115115906	0.5213115115906	false	false	false	true
d2b943b3-3e52-4f1b-94a1-e26c0d18f403	2026-09-28 13:12	2026-09-28 13:12	2026-09-28 13:12	USO	USO261007C00159000	call	159.0000	2026-10-07	1.4100	1.2900	1.4500	147.4910	17625.00	10715.00	142.00	125	7	147	45	3.26666666666667	0.544053157590171	0.54834603569347	false	false	false	true
7ba72f37-f03e-4cd3-8e56-5df75358c7f2	2026-09-28 13:12	2026-09-28 13:12	2026-09-28 13:12	USO	USO261030P00145000	put	145.0000	2026-10-30	7.8000	7.8000	8.9500	147.5200	20280.00	0.00	20280.00	26	11	116	224	0.517857142857143	0.536749535194527	0.536749535194527	true	false	false	true
c405ae08-4ba4-4c26-8350-20c540b81b8a	2026-09-28 13:12	2026-09-28 13:12	2026-09-28 13:12	USO	USO261120P00141000	put	141.0000	2026-11-20	8.1500	8.1500	8.4000	147.4400	14673.00	0.00	14673.00	18	6	37	163	0.226993865030675	0.523867843156903	0.523867843156903	false	false	false	true
5448f408-7144-4fc5-bf16-b813f0f35948	2026-09-28 13:12	2026-09-28 13:12	2026-09-28 13:12	USO	USO261016P00134000	put	134.0000	2026-10-16	2.3500	2.3100	2.9400	147.4400	11280.00	235.00	11045.00	48	20	94	1130	0.0831858407079646	0.581215696057906	0.581215696057906	false	false	false	true
c544257a-2280-4d3f-abbe-fb43b278fe3b	2026-09-28 13:12	2026-09-28 13:12	2026-09-28 13:12	USO	USO261120P00131000	put	131.0000	2026-11-20	4.6000	4.4000	4.9000	147.0700	27600.00	18860.00	8740.00	60	5	78	242	0.322314049586777	0.525575468563979	0.525575468563979	false	false	false	true
822f8073-94ad-454a-8a58-ab955ee0c1ed	2026-09-28 13:11	2026-09-28 13:11	2026-09-28 13:11	USO	USO270115P00130000	put	130.0000	2027-01-15	7.0000	6.2000	7.4500	147.6800	10500.00	2800.00	7700.00	15	5	41	2924	0.0140218878248974	0.490558290041476	0.490558290041476	false	false	false	true
83c992df-a8eb-44cc-b05d-c4c3e04a24bf	2026-09-28 13:08	2026-09-28 13:08	2026-09-28 13:08	USO	USO261106P00144000	put	144.0000	2026-11-06	7.1500	7.1000	7.4000	150.2500	12160.00	0.00	11440.00	17	6	55	0	0	0.535144226903973	0.535144226903973	true	false	false	true
46a2af6e-728a-4664-9709-94736a97c06f	2026-09-28 12:57	2026-09-28 12:57	2026-09-28 12:57	USO	USO261009C00165000	call	165.0000	2026-10-09	1.2800	1.2800	1.3400	149.6439	15872.00	0.00	15872.00	124	18	317	763	0.415465268676278	0.558537591529386	0.558537591529386	true	false	false	true
989cf8f6-442f-446f-95be-8b80ad2e6483	2026-09-28 12:51	2026-09-28 12:51	2026-09-28 12:51	USO	USO261030P00148000	put	148.0000	2026-10-30	8.1000	7.3500	8.2500	149.9350	10530.00	10530.00	0.00	13	9	43	267	0.161048689138577	0.529282245211313	0.529282245211313	true	false	false	true
21cc7d90-ce03-4a37-a32c-209546157383	2026-09-28 12:44	2026-09-28 12:44	2026-09-28 12:44	USO	USO261007C00152000	call	152.0000	2026-10-07	4.4000	4.3000	4.4000	149.0000	44000.00	44000.00	0.00	100	9	229	6	38.1666666666667	0.565812922295843	0.565812922295843	false	false	false	true
9cfb20c1-dd6c-442a-8cb1-1ba9c7bad3c9	2026-09-28 12:42	2026-09-28 12:42	2026-09-28 12:42	USO	USO261002P00145000	put	145.0000	2026-10-02	2.1900	2.0700	2.2000	149.0000	14015.00	14015.00	0.00	64	25	5997	4146	1.44645441389291	0.671309454888369	0.671309454888369	true	false	false	true
bfc61418-0fd5-4046-ad41-63f81e61ac88	2026-09-28 12:41	2026-09-28 12:41	2026-09-28 12:41	USO	USO261002P00145000	put	145.0000	2026-10-02	2.2000	2.1800	2.2200	149.0000	17380.00	16060.00	0.00	79	6	5908	4146	1.42498794018331	0.6642788367548	0.6642788367548	false	false	false	true