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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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

81179b0a-fb61-48b9-9546-f122f373b74c	2026-09-24 13:04	2026-09-24 13:04	2026-09-24 13:04	USO	USO261120C00210000	call	210.0000	2026-11-20	1.5000	1.2400	1.7000	151.6800	12000.00	12000.00	0.00	80	6	91	443	0.205417607223476	0.578447939134632	0.578447939134632	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-24T17:08:54.073871Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
1403ce99-fd34-42fa-932d-bc7780b49c08	2026-09-24 13:02	2026-09-24 13:02	2026-09-24 13:02	USO	USO261002P00161000	put	161.0000	2026-10-02	11.2000	10.0000	12.4500	151.3850	22400.00	4480.00	17920.00	20	6	20	52	0.384615384615385	0.556701471664183	0.556701471664183	false	false	false	true
ff2b3395-5f42-4215-be3f-5452d2a627ed	2026-09-24 12:59	2026-09-24 12:59	2026-09-24 12:59	USO	USO261030C00158000	call	158.0000	2026-10-30	7.1500	7.1500	7.3000	151.0000	14300.00	0.00	14300.00	20	5	56	324	0.172839506172839	0.501622250675168	0.501622250675168	false	false	false	true
c06f5c94-fee9-4ce3-a7cd-3faea5797e0b	2026-09-24 12:58	2026-09-24 12:57	2026-09-24 12:57	USO	USO260925P00149000	put	149.0000	2026-09-25	1.0300	0.9700	1.0500	151.0000	11947.00	11845.00	102.00	116	24	2330	551	4.22867513611615	0.685706586352609	0.689366846331604	true	false	false	true
9ce2b75d-ac13-497b-bd56-6fe3bd656108	2026-09-24 12:57	2026-09-24 12:57	2026-09-24 12:57	USO	USO260925P00149000	put	149.0000	2026-09-25	1.0200	0.9800	1.0200	151.0000	10200.00	10200.00	0.00	100	5	2183	551	3.96188747731397	0.687845495255187	0.687845495255187	false	false	false	true
938b8c9a-ba3f-4ac7-97c3-1519b486f063	2026-09-24 12:56	2026-09-24 12:56	2026-09-24 12:56	USO	USO261009C00162000	call	162.0000	2026-10-09	2.8200	2.8200	2.9100	151.0000	18330.00	0.00	18330.00	65	13	70	212	0.330188679245283	0.521360124663934	0.521360124663934	false	false	false	true
120fa5a4-0bcb-4449-ba96-aa7cb1521b6a	2026-09-24 12:56	2026-09-24 12:56	2026-09-24 12:56	USO	USO261009C00167000	call	167.0000	2026-10-09	1.8300	1.8200	2.8600	151.0000	17202.00	0.00	16287.00	94	16	104	410	0.253658536585366	0.530836093525053	0.530836093525053	false	false	false	true
56223855-6024-4131-b228-65cf9736eee0	2026-09-24 12:52	2026-09-24 12:52	2026-09-24 12:52	USO	USO261002P00150000	put	150.0000	2026-10-02	4.1500	4.1500	4.3500	151.0000	12462.00	0.00	12462.00	30	7	1805	921	1.95982627578719	0.52868483579859	0.52868483579859	false	false	false	true
173de4a9-2026-44f3-b06f-7c1f345e3acf	2026-09-24 12:52	2026-09-24 12:52	2026-09-24 12:52	USO	USO261009C00152500	call	152.5000	2026-10-09	5.6500	5.5000	5.7000	150.0000	14125.00	14125.00	0.00	25	6	60	56	1.07142857142857	0.515132342732016	0.515132342732016	true	false	false	true
3b5fdcde-b0ff-46ca-8897-11cdc0ea42f0	2026-09-24 12:51	2026-09-24 12:51	2026-09-24 12:51	USO	USO261016P00145000	put	145.0000	2026-10-16	4.8000	4.6500	4.8000	150.9100	16800.00	16800.00	0.00	35	7	2763	5227	0.52860149225177	0.519864086778373	0.519864086778373	true	false	false	true
1751a29c-4f57-45bb-b221-792432877cd1	2026-09-24 12:50	2026-09-24 12:50	2026-09-24 12:50	USO	USO280121P00120000	put	120.0000	2028-01-21	12.2000	11.7500	13.0500	151.0090	18300.00	8540.00	9760.00	15	6	1472	3761	0.391385269875033	0.458231217369348	0.458231217369348	false	false	false	true
e0eb5a07-d7a5-4ab9-be11-d7af8dd3fb25	2026-09-24 12:46	2026-09-24 12:46	2026-09-24 12:46	USO	USO280121P00120000	put	120.0000	2028-01-21	12.1200	11.0000	13.7000	150.6350	13329.00	7269.00	6060.00	11	6	1343	3761	0.357085881414517	0.455058068427248	0.455462081120806	false	false	false	true
80c8302f-3f1a-46b5-bba6-2b7d53b469c6	2026-09-24 12:46	2026-09-24 12:46	2026-09-24 12:46	USO	USO270416P00165000	put	165.0000	2027-04-16	27.4500	27.2500	29.2000	150.5100	54900.00	0.00	54900.00	20	7	20	37	0.540540540540541	0.468819426013816	0.491097176497135	false	false	false	true
dec9545e-3365-41ae-a42f-567a24cf52b4	2026-09-24 12:45	2026-09-24 12:45	2026-09-24 12:45	USO	USO260925C00152000	call	152.0000	2026-09-25	1.6000	1.5000	1.6400	151.0400	13280.00	5120.00	8160.00	83	10	2473	716	3.45391061452514	0.643884918737862	0.643884918737862	true	false	false	true
cd3ec7cb-4442-4a47-b2e1-380d642c1492	2026-09-24 12:45	2026-09-24 12:45	2026-09-24 12:45	USO	USO261016C00161000	call	161.0000	2026-10-16	4.0500	3.8500	4.0500	151.0100	16188.00	16188.00	0.00	40	8	145	241	0.601659751037344	0.521168860348033	0.521168860348033	false	false	false	true
b0775c3e-82e5-4678-a52c-38aec34e3787	2026-09-24 12:44	2026-09-24 12:44	2026-09-24 12:44	USO	USO280121P00120000	put	120.0000	2028-01-21	12.2300	11.7500	13.9000	150.6800	12230.00	4892.00	7338.00	10	5	1302	3761	0.346184525392183	0.457466908274047	0.457466908274047	false	false	false	true
f00f7962-f05a-4e61-8ce9-fc5c9731123a	2026-09-24 12:44	2026-09-24 12:44	2026-09-24 12:44	USO	USO261002P00155000	put	155.0000	2026-10-02	7.2400	7.2000	7.4000	150.5900	14470.00	0.00	9360.00	20	5	514	1105	0.465158371040724	0.527922671773146	0.539736643473109	false	false	false	true
3247a08e-0df5-4668-905e-5dff35300aed	2026-09-24 12:43	2026-09-24 12:43	2026-09-24 12:43	USO	USO260925C00152000	call	152.0000	2026-09-25	1.3600	1.3400	1.3600	150.3522	11152.00	11152.00	0.00	82	9	2255	716	3.14944134078212	0.657179838976071	0.657179838976071	false	false	false	true
98cb5bb8-bae6-4c23-ae2c-350e0031ddd7	2026-09-24 12:42	2026-09-24 12:42	2026-09-24 12:42	USO	USO261009C00145000	call	145.0000	2026-10-09	9.3700	8.9000	9.4000	150.3600	14055.00	13120.00	935.00	15	8	22	529	0.0415879017013233	0.515652874680985	0.520132285070331	true	false	false	true
e2aa8fa2-4af9-4e5c-8eae-aef8ff84307c	2026-09-24 12:42	2026-09-24 12:42	2026-09-24 12:42	USO	USO261016P00151000	put	151.0000	2026-10-16	7.8000	7.7000	7.9000	150.1719	12480.00	10920.00	0.00	16	9	84	449	0.187082405345212	0.513881088070754	0.513881088070754	false	false	false	true
a768bd65-9c2f-4862-b6b8-a76806b7cc54	2026-09-24 12:41	2026-09-24 12:41	2026-09-24 12:41	USO	USO261016C00155000	call	155.0000	2026-10-16	5.5000	5.5000	5.6500	150.1600	22000.00	0.00	22000.00	40	12	443	3051	0.145198295640774	0.504426645424108	0.504426645424108	false	false	false	true
ecb58f6c-5cff-4519-a14a-6a90177559c4	2026-09-24 12:40	2026-09-24 12:40	2026-09-24 12:40	USO	USO260925P00150000	put	150.0000	2026-09-25	1.9200	1.8600	1.9200	150.5000	17080.00	17080.00	0.00	89	6	6418	2608	2.46088957055215	0.691214710319885	0.688012234523588	false	false	false	true
9c3a211d-d091-471c-8fb4-69bfa0010e7c	2026-09-24 12:39	2026-09-24 12:39	2026-09-24 12:39	USO	USO261016P00146000	put	146.0000	2026-10-16	5.2000	5.2000	5.3500	150.8050	18720.00	0.00	18720.00	36	9	48	674	0.0712166172106825	0.516829534326552	0.516829534326552	false	false	false	true
671b9544-643c-49a1-9791-5cc108b2c371	2026-09-24 12:38	2026-09-24 12:38	2026-09-24 12:38	USO	USO261218P00150000	put	150.0000	2026-12-18	13.1000	12.7000	13.2500	150.7600	505660.00	427060.00	78600.00	386	16	558	1547	0.360698125404008	0.493373014092153	0.493373014092153	true	false	false	true
389512b2-0231-4797-9158-409731136052	2026-09-24 12:37	2026-09-24 12:37	2026-09-24 12:37	USO	USO261009C00152000	call	152.0000	2026-10-09	5.7500	5.4500	5.8000	150.4950	13216.00	13216.00	0.00	23	7	38	328	0.115853658536585	0.520477261429383	0.520477261429383	true	false	false	true
3174ee9d-e21d-4725-a7c9-fe418fd2554e	2026-09-24 12:37	2026-09-24 12:36	2026-09-24 12:36	USO	USO261120P00140000	put	140.0000	2026-11-20	6.7000	6.4500	6.7000	150.5101	246560.00	246560.00	0.00	368	19	498	2057	0.242100145843461	0.505475743670203	0.505475743670203	false	false	false	true
4a5051af-1c7f-4e20-aa75-8b1af61c9933	2026-09-24 12:36	2026-09-24 12:36	2026-09-24 12:36	USO	USO280121P00120000	put	120.0000	2028-01-21	12.1200	11.0000	14.4500	150.4814	13334.00	6062.00	7272.00	11	6	1202	3761	0.319595852166977	0.454416671418804	0.454416671418804	false	false	false	true
0de7d7b2-600e-458c-9604-44eb1e74f1e9	2026-09-24 12:35	2026-09-24 12:35	2026-09-24 12:35	USO	USO260925P00151000	put	151.0000	2026-09-25	2.1300	2.1200	2.2100	151.0500	43007.00	18618.00	24389.00	202	25	2376	378	6.28571428571429	0.692320170889768	0.689148307714625	true	false	false	true
291130e0-4947-432f-93ba-fbec86e671cc	2026-09-24 12:34	2026-09-24 12:34	2026-09-24 12:34	USO	USO261120P00160000	put	160.0000	2026-11-20	17.0000	17.0000	17.2500	150.8700	45900.00	0.00	45900.00	27	7	47	428	0.10981308411215	0.514026958932497	0.514026958932497	true	false	false	true
bcaad5d7-01f8-43eb-89a2-bbf77dfa0370	2026-09-24 12:34	2026-09-24 12:34	2026-09-24 12:34	USO	USO261002C00155000	call	155.0000	2026-10-02	3.0500	3.0500	3.1500	150.7750	20435.00	0.00	20435.00	67	11	840	859	0.977881257275902	0.534339365421074	0.534339365421074	true	false	false	true
a07327fe-3b21-4d4c-85b2-bb15f4bfa914	2026-09-24 12:33	2026-09-24 12:33	2026-09-24 12:33	USO	USO261009P00140000	put	140.0000	2026-10-09	2.1800	1.7700	2.2700	150.8700	10461.00	7627.00	2834.00	48	6	579	663	0.873303167420814	0.528312398921615	0.529411711695465	true	false	false	true
be4ef40f-3dd0-4c22-aeb9-790a4dba7ed6	2026-09-24 12:33	2026-09-24 12:33	2026-09-24 12:33	USO	USO270115P00125000	put	125.0000	2027-01-15	4.9500	4.2500	5.0000	150.8775	18810.00	17820.00	990.00	38	11	186	2285	0.0814004376367615	0.490180125614438	0.490180125614438	false	false	false	true
1cb54e14-97fb-4a75-b69c-ef20f5d818d4	2026-09-24 12:33	2026-09-24 12:33	2026-09-24 12:33	USO	USO261218P00140000	put	140.0000	2026-12-18	8.2900	7.8500	8.5000	150.9200	18245.00	11605.00	6640.00	22	14	438	5397	0.0811561978877154	0.488076992318133	0.488076992318133	true	false	false	true
d8c1947a-c9d9-4163-aab0-07904f030a76	2026-09-24 12:31	2026-09-24 12:31	2026-09-24 12:31	USO	USO261002P00145000	put	145.0000	2026-10-02	2.4400	2.3900	2.4400	151.1800	12200.00	12200.00	0.00	50	12	597	3800	0.157105263157895	0.568695054266486	0.568695054266486	false	false	false	true
05c7676c-e355-4957-9f2e-288b9e5d0395	2026-09-24 12:31	2026-09-24 12:31	2026-09-24 12:31	USO	USO261002P00140000	put	140.0000	2026-10-02	1.2800	1.2200	1.2800	151.2550	12926.00	12800.00	126.00	101	31	1439	3457	0.4162568701186	0.588894661499757	0.585402115765091	false	false	false	true
5a55ea54-1cf0-456c-8e96-874794e9ead5	2026-09-24 12:31	2026-09-24 12:31	2026-09-24 12:31	USO	USO261009C00156000	call	156.0000	2026-10-09	4.4500	4.3500	4.4500	151.2100	10680.00	10680.00	0.00	24	5	309	106	2.91509433962264	0.521197253206061	0.521197253206061	false	false	false	true
fccde542-9abf-4ba1-ac3c-f972094d639e	2026-09-24 12:30	2026-09-24 12:30	2026-09-24 12:30	USO	USO261002P00150000	put	150.0000	2026-10-02	4.3000	4.2000	4.3500	151.1801	19780.00	17630.00	0.00	46	11	1347	921	1.46254071661238	0.55445757910455	0.55445757910455	false	false	false	true
24ecf181-8697-466d-a805-a50b27616e3c	2026-09-24 12:30	2026-09-24 12:30	2026-09-24 12:30	USO	USO261009C00157000	call	157.0000	2026-10-09	4.1500	3.7500	4.1500	151.2901	27390.00	26975.00	0.00	66	15	257	369	0.696476964769648	0.523472711242621	0.523472711242621	false	false	false	true
4e49ca03-242d-425a-bde7-46a61c1efe22	2026-09-24 12:30	2026-09-24 12:30	2026-09-24 12:30	USO	USO261002C00158000	call	158.0000	2026-10-02	2.3800	2.3200	2.3800	151.2350	12376.00	12376.00	0.00	52	14	334	329	1.01519756838906	0.549306390780327	0.549306390780327	false	false	false	true
ebddd057-c26f-4284-b962-8809dc778999	2026-09-24 12:30	2026-09-24 12:30	2026-09-24 12:30	USO	USO261009P00153000	put	153.0000	2026-10-09	7.2900	6.7000	7.3000	151.2184	12389.00	12389.00	0.00	17	6	376	280	1.34285714285714	0.529556277015821	0.527101209135104	false	false	false	true
9c0d9767-9b61-457c-8789-ec741cf356a5	2026-09-24 12:30	2026-09-24 12:30	2026-09-24 12:30	USO	USO261007P00152000	put	152.0000	2026-10-07	6.2500	5.7000	6.6000	151.2900	55595.00	54975.00	620.00	89	34	273	0	0	0.526081707452238	0.526081707452238	true	false	false	true	false
5f39bace-b6d7-4ff1-b956-7bdb13754410	2026-09-24 12:29	2026-09-24 12:29	2026-09-24 12:29	USO	USO261009P00152000	put	152.0000	2026-10-09	6.5700	5.9500	6.6000	151.4500	66354.00	66354.00	0.00	101	5	169	157	1.07643312101911	0.524539919206807	0.526196653091637	true	false	false	true
f12f851b-0140-4417-bc67-7d1f595d3231	2026-09-24 12:29	2026-09-24 12:29	2026-09-24 12:29	USO	USO261007P00150000	put	150.0000	2026-10-07	5.1000	3.2000	5.2000	151.5450	16305.00	15805.00	500.00	32	8	43	0	0	0.519209732263525	0.528097945145159	true	false	false	true	false
e6bad7eb-5c94-4b4e-b7ae-d57e182b0f83	2026-09-24 12:29	2026-09-24 12:29	2026-09-24 12:29	USO	USO261009P00150000	put	150.0000	2026-10-09	5.5500	4.6500	5.7000	151.5450	19417.00	17757.00	1105.00	35	15	114	361	0.315789473684211	0.52600765879207	0.521872114611226	true	false	false	true
3ff9c22c-4dc7-4f8f-a5c5-7508b30dc629	2026-09-24 12:29	2026-09-24 12:28	2026-09-24 12:28	USO	USO270115P00128000	put	128.0000	2027-01-15	5.6000	5.0000	5.6000	151.5700	29680.00	29680.00	0.00	53	8	55	451	0.121951219512195	0.487879893134391	0.487879893134391	false	false	false	true
99f12228-6f97-4af1-9d3b-36d48bdaf4a9	2026-09-24 12:28	2026-09-24 12:28	2026-09-24 12:28	USO	USO260925C00152000	call	152.0000	2026-09-25	2.0300	2.0000	2.0400	151.6750	10556.00	10556.00	0.00	52	9	1570	716	2.1927374301676	0.687868158146708	0.687868158146708	true	false	false	true
0bd41210-1447-47f0-8956-9a03a9f2bc27	2026-09-24 12:27	2026-09-24 12:27	2026-09-24 12:27	USO	USO261009P00153000	put	153.0000	2026-10-09	6.7000	6.6500	7.0500	152.1641	14076.00	0.00	14076.00	21	6	351	280	1.25357142857143	0.519562458335397	0.519562458335397	true	false	false	true
1b4583b4-9bb7-4a70-82df-883c947298e2	2026-09-24 12:26	2026-09-24 12:26	2026-09-24 12:26	USO	USO260925P00152000	put	152.0000	2026-09-25	2.2100	2.1200	2.2100	151.9300	22077.00	22077.00	0.00	100	5	1574	518	3.03861003861004	0.6880725797532	0.684920426007135	false	false	false	true
f8037019-f229-45c2-93e3-f75141b6757c	2026-09-24 12:26	2026-09-24 12:26	2026-09-24 12:26	USO	USO261009P00153000	put	153.0000	2026-10-09	6.8500	6.4000	6.9000	151.9750	49304.00	24654.00	2730.00	72	20	330	280	1.17857142857143	0.524137320590635	0.524137320590635	true	false	false	true
f6b2c5c7-5fc7-49b3-a552-52f2fc32436a	2026-09-24 12:26	2026-09-24 12:26	2026-09-24 12:26	USO	USO261120C00157000	call	157.0000	2026-11-20	10.2500	10.0500	10.4000	152.4100	13325.00	9225.00	4100.00	13	5	28	502	0.0557768924302789	0.492699891160853	0.492699891160853	false	false	false	true