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.

728,802 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts728,802 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

07a61ef8-dc43-41c0-95e6-7355cb00bb07	2026-09-15 14:20	2026-09-15 14:20	2026-09-15 14:20	USO	USO280616P00143000	put	143.0000	2028-06-16	22.3400	21.5500	22.3500	161.8500	78197.00	78197.00	0.00	35	5	70	62	1.12903225806452	0.4645794831285	0.4645794831285	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	Financial Services	1228364647.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"}	2026-09-15	2026-09-15 21:15	2026-09-15 21:15
0a8b328a-9232-435e-9160-782912d7689d	2026-09-15 14:09	2026-09-15 14:08	2026-09-15 14:08	USO	USO281215C00300000	call	300.0000	2028-12-15	12.6500	12.3500	13.3500	162.3100	30362.00	2530.00	27832.00	24	8	80	1454	0.0550206327372765	0.389961169247086	0.390082783493778	false	false	false	true
d783dea7-505d-4ded-92dc-4147392cd4a2	2026-09-15 13:45	2026-09-15 13:45	2026-09-15 13:45	USO	USO270416C00315000	call	315.0000	2027-04-16	3.0200	2.0200	3.1000	162.9526	16000.00	16000.00	0.00	53	6	53	0	0	0.561365735589602	0.567552879327035	false	false	false	true
667b8b92-8f63-47ad-8746-15f7190134e1	2026-09-15 13:34	2026-09-15 13:34	2026-09-15 13:34	USO	USO261120C00230000	call	230.0000	2026-11-20	3.1900	2.9100	3.2000	163.0900	23895.00	23895.00	0.00	75	8	79	85	0.929411764705882	0.669532369926684	0.669532369926684	false	false	false	true
9ceccafd-e753-463a-a472-146d714dc105	2026-09-15 12:48	2026-09-15 12:48	2026-09-15 12:48	USO	USO260925C00170000	call	170.0000	2026-09-25	3.6500	3.6500	3.7000	162.0000	36153.00	0.00	36153.00	99	36	625	1065	0.586854460093897	0.620270763838255	0.620270763838255	false	false	false	true
73b7a771-cbd1-474c-bcc2-e6014b1da7fa	2026-09-15 12:28	2026-09-15 12:27	2026-09-15 12:27	USO	USO260918P00150000	put	150.0000	2026-09-18	0.4900	0.4700	0.5000	161.0000	74092.00	72748.00	0.00	1500	36	2469	6631	0.37234202985975	0.645534402147586	0.65304807004329	true	false	false	true
6f360d1e-7d25-4823-ad6e-2d997a5f3e35	2026-09-15 12:27	2026-09-15 12:27	2026-09-15 12:27	USO	USO260925C00166000	call	166.0000	2026-09-25	4.3600	4.3000	4.5000	161.0000	74914.00	8700.00	65334.00	172	24	332	185	1.79459459459459	0.588986246555578	0.588986246555578	true	false	false	true
d79fcee0-f8d2-484e-83cd-1181ff9b97ee	2026-09-15 12:27	2026-09-15 12:27	2026-09-15 12:27	USO	USO260925C00165000	call	165.0000	2026-09-25	4.7000	4.6500	4.9500	161.0000	71957.00	945.00	70542.00	153	26	363	343	1.05830903790087	0.586024909791969	0.586024909791969	true	false	false	true
7dd73344-018a-44d1-9761-2ce44f26d662	2026-09-15 12:18	2026-09-15 12:18	2026-09-15 12:18	USO	USO261009C00170000	call	170.0000	2026-10-09	6.4000	5.8500	6.4000	161.4301	23662.00	23662.00	0.00	37	5	79	377	0.209549071618037	0.587207718610635	0.587207718610635	false	false	false	true
4f580147-4317-4adb-820e-fafd71929048	2026-09-15 12:16	2026-09-15 12:15	2026-09-15 12:15	USO	USO261030C00165000	call	165.0000	2026-10-30	11.2300	11.0000	11.4500	161.3300	17975.00	10125.00	7850.00	16	8	30	309	0.0970873786407767	0.552320191361464	0.554532756866326	false	false	false	true
58b44175-71f1-4b61-a112-351529e0315b	2026-09-15 12:09	2026-09-15 12:09	2026-09-15 12:09	USO	USO260918C00175000	call	175.0000	2026-09-18	0.5700	0.5300	0.5700	161.0700	11379.00	11379.00	0.00	200	12	588	7815	0.0752399232245681	0.728695159189712	0.732283935209574	false	false	false	true
f1a30774-4b3b-45ef-89ae-400e9c0f8b55	2026-09-15 12:07	2026-09-15 12:07	2026-09-15 12:07	USO	USO260916C00170000	call	170.0000	2026-09-16	0.3500	0.3200	0.3600	161.0200	10499.00	10465.00	34.00	300	10	2335	5234	0.446121513183034	0.813336333322568	0.819798770076807	true	false	false	true
3bf7d566-0153-40a7-a3a7-eb3bc8da917b	2026-09-15 12:06	2026-09-15 12:06	2026-09-15 12:06	USO	USO261023C00161000	call	161.0000	2026-10-23	11.6700	11.1500	11.9000	160.9169	11669.00	11669.00	0.00	10	5	114	125	0.912	0.550146325178134	0.550146325178134	false	false	false	true
02f6f24d-fd10-4b04-a312-755cb269b150	2026-09-15 11:40	2026-09-15 11:40	2026-09-15 11:40	USO	USO261023C00180000	call	180.0000	2026-10-23	5.5100	5.4000	5.9000	160.1700	62837.00	1105.00	61732.00	114	22	116	375	0.309333333333333	0.589562032237712	0.589562032237712	true	false	false	true
c8ea697b-a360-44e2-82d8-67dc4a1f180a	2026-09-15 10:51	2026-09-15 10:51	2026-09-15 10:51	USO	USO260918C00162500	call	162.5000	2026-09-18	2.9400	2.7900	3.1500	160.7200	12047.00	10310.00	1737.00	41	14	94	105	0.895238095238095	0.633152230122726	0.641859167662657	true	false	false	true
0f8118bb-50f7-408d-b2e0-43b9a2a19588	2026-09-15 10:51	2026-09-15 10:51	2026-09-15 10:51	USO	USO260916C00160000	call	160.0000	2026-09-16	2.5000	2.3100	2.7000	160.4750	22020.00	16368.00	5652.00	88	13	2303	2690	0.856133828996283	0.713721093428872	0.677104110738798	true	false	false	true
e6b9a007-3af4-4e38-bf13-aebcaee4c7d5	2026-09-15 09:59	2026-09-15 09:59	2026-09-15 09:59	USO	USO261002P00153000	put	153.0000	2026-10-02	4.7600	4.7000	5.2000	158.9500	13324.00	2865.00	10459.00	28	11	32	36	0.888888888888889	0.553554807901901	0.55997022101017	true	false	false	true
ebf060e0-0813-43a4-a1f1-008d7b1a52b5	2026-09-15 09:37	2026-09-15 09:37	2026-09-15 09:37	USO	USO261016C00150000	call	150.0000	2026-10-16	14.6700	14.6000	15.4500	158.8530	10266.00	0.00	10266.00	7	6	15	5644	0.00265768958185684	0.511861239057001	0.525819668339237	false	false	false	true
07cedd37-c76e-40d2-b301-cfd0cc7729b2	2026-09-15 09:30	2026-09-15 09:30	2026-09-15 09:30	USO	USO260925P00165000	put	165.0000	2026-09-25	9.8000	9.8000	11.0500	158.8400	76474.00	0.00	76474.00	78	14	78	28	2.78571428571429	0.596114372235743	0.596114372235743	true	false	false	true
be581cfe-6085-4f78-85f0-8d5bc69c8983	2026-09-14 15:47	2026-09-14 15:47	2026-09-14 15:47	USO	USO260918P00155000	put	155.0000	2026-09-18	3.0700	3.0000	3.1000	156.0000	13514.00	13514.00	0.00	44	5	3869	1033	3.74540174249758	0.582436458555511	0.582436458555511	false	false	false	true
552c847f-36a1-41ec-9f0c-b160e5acff84	2026-09-14 15:22	2026-09-14 15:22	2026-09-14 15:22	USO	USO270115P00134000	put	134.0000	2027-01-15	7.3100	7.2500	7.8000	155.6900	29952.00	1470.00	28482.00	41	11	54	22	2.45454545454545	0.496686971113348	0.49847362420245	false	false	false	true
09cb7280-8752-43ae-840b-bb272f0ab51e	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	USO	USO261016C00155000	call	155.0000	2026-10-16	10.4000	10.3000	10.4500	155.5200	24950.00	10400.00	2070.00	24	8	658	2930	0.22457337883959	0.536193754651258	0.538936129670165	false	false	false	true
e6646e8d-fe01-453f-9919-385ba00ff7bb	2026-09-14 13:00	2026-09-14 13:00	2026-09-14 13:00	USO	USO261016C00180000	call	180.0000	2026-10-16	3.8300	3.6500	3.8500	155.9700	18394.00	18394.00	0.00	48	6	782	2233	0.350201522615316	0.61248092723389	0.61248092723389	false	false	false	true
8515a8f7-f7d4-4514-9a78-521873c3eee3	2026-09-14 12:17	2026-09-14 12:16	2026-09-14 12:16	USO	USO261218C00175000	call	175.0000	2026-12-18	10.9500	10.8500	11.3000	157.2050	283611.00	49275.00	233241.00	259	18	484	1966	0.24618514750763	0.531138369336833	0.531458584532356	true	false	false	true
2023fe54-a727-4731-8a56-b88b4150761d	2026-09-14 12:15	2026-09-14 12:15	2026-09-14 12:15	USO	USO260918P00157500	put	157.5000	2026-09-18	4.2500	4.0000	4.5000	157.1800	139404.00	0.00	135579.00	328	8	451	0	0	0.627651892378854	0.629175330654146	false	false	false	true
8c9bc27f-7f24-4847-bfa2-95de81850386	2026-09-14 12:10	2026-09-14 12:10	2026-09-14 12:10	USO	USO261009C00170000	call	170.0000	2026-10-09	5.2000	5.1500	5.7500	157.2103	13010.00	1045.00	11965.00	25	9	32	345	0.0927536231884058	0.599010051378713	0.602312349595246	true	false	false	true
884333c7-ae5c-4ad8-ab01-3ec2fdb553aa	2026-09-14 12:06	2026-09-14 12:06	2026-09-14 12:06	USO	USO260925P00155000	put	155.0000	2026-09-25	5.0600	4.9000	5.1500	157.4800	15177.00	15177.00	0.00	30	5	2781	514	5.41050583657588	0.582106852992761	0.582106852992761	false	false	false	true
aa330b6b-f0b1-405f-bc3c-f9883e07ad59	2026-09-14 11:52	2026-09-14 11:52	2026-09-14 11:52	USO	USO260918P00150000	put	150.0000	2026-09-18	1.1700	1.1700	1.3700	158.0000	234868.00	861.00	234007.00	2007	55	8550	2773	3.08330328164443	0.616689420816335	0.629583288864855	true	false	false	true
07a15bb8-3086-4126-945c-ec7867755d8c	2026-09-14 11:36	2026-09-14 11:35	2026-09-14 11:35	USO	USO261016P00155000	put	155.0000	2026-10-16	9.0000	8.7000	9.0000	157.7200	40497.00	40497.00	0.00	45	8	258	780	0.330769230769231	0.571495342842226	0.573140931320863	false	false	false	true
6bc4c74c-fb0d-48c5-81ab-2bee914eb38e	2026-09-14 11:22	2026-09-14 11:22	2026-09-14 11:22	USO	USO270416C00185000	call	185.0000	2027-04-16	14.5900	12.2500	14.7000	158.9750	135649.00	112449.00	23200.00	93	6	93	16	5.8125	0.460417625506065	0.459580199040235	false	false	false	true
fcff6643-8480-4043-8d56-dfe5ee578806	2026-09-14 11:08	2026-09-14 11:08	2026-09-14 11:08	USO	USO260916P00151000	put	151.0000	2026-09-16	0.6200	0.6100	0.7400	157.7900	17385.00	1139.00	16246.00	280	25	577	116	4.97413793103448	0.61554883126396	0.61554883126396	true	false	false	true
abc87e69-eb8b-4b47-8e26-0653352866e4	2026-09-14 10:55	2026-09-14 10:55	2026-09-14 10:55	USO	USO280616P00129000	put	129.0000	2028-06-16	16.2400	14.0000	16.3500	159.1200	136375.00	136375.00	0.00	84	9	84	93	0.903225806451613	0.450825200012523	0.453091013106058	true	false	false	true
55168261-3b66-4f78-9a43-d483744d2a1b	2026-09-14 10:51	2026-09-14 10:51	2026-09-14 10:51	USO	USO261016C00142000	call	142.0000	2026-10-16	20.7300	20.6500	21.5500	159.0400	70498.00	0.00	70498.00	34	5	34	411	0.0827250608272506	0.529737187522385	0.538663017871719	false	false	false	true
b6339be2-74ea-48de-b080-8f6fe7f2ec38	2026-09-14 10:42	2026-09-14 10:41	2026-09-14 10:41	USO	USO261016C00155000	call	155.0000	2026-10-16	13.1900	12.8000	13.2500	159.5800	92355.00	89720.00	2635.00	70	9	296	2930	0.101023890784983	0.560576716640022	0.563334893490548	false	false	false	true
48d47105-02c3-4a13-a5aa-9189c4106231	2026-09-14 10:33	2026-09-14 10:33	2026-09-14 10:33	USO	USO260925C00167500	call	167.5000	2026-09-25	3.9000	3.8500	4.2000	159.3203	104931.00	785.00	100636.00	269	40	1048	28	37.4285714285714	0.636831595195323	0.641711631263106	true	false	false	true
b7d02414-cd68-4b96-82ee-1deb701a0937	2026-09-14 10:33	2026-09-14 10:33	2026-09-14 10:33	USO	USO261009C00165000	call	165.0000	2026-10-09	7.7100	7.6500	8.3000	159.4100	54712.00	3085.00	50857.00	71	24	88	443	0.198645598194131	0.595752920907841	0.595752920907841	true	false	false	true
95b0b8c2-0e11-4341-be03-9164ae1ff35e	2026-09-14 09:54	2026-09-14 09:54	2026-09-14 09:54	USO	USO260918C00159000	call	159.0000	2026-09-18	4.6500	4.4500	4.8000	159.7602	89727.00	86007.00	3720.00	193	8	241	812	0.29679802955665	0.631642264590166	0.634658548944479	true	false	false	true
5ed01b1c-ca20-435b-9888-cefb56bfede7	2026-09-14 09:54	2026-09-14 09:53	2026-09-14 09:53	USO	USO261016C00150000	call	150.0000	2026-10-16	15.7800	15.7000	16.2500	159.7100	15776.00	0.00	15776.00	10	6	118	5558	0.0212306585102555	0.533809155837377	0.545191753552903	false	false	false	true
c92ef030-5e59-437a-ac14-8af79d3236a5	2026-09-14 09:35	2026-09-14 09:35	2026-09-14 09:35	USO	USO260925P00162000	put	162.0000	2026-09-25	8.2600	8.1000	8.4500	159.1885	12390.00	4140.00	8250.00	15	9	36	4	9	0.617524107225087	0.617524107225087	true	false	false	true
12425fe2-1999-4d04-ad3c-b150f59c0a89	2026-09-14 09:32	2026-09-14 09:31	2026-09-14 09:31	USO	USO261016C00175000	call	175.0000	2026-10-16	6.0900	6.0500	6.3500	159.3500	17055.00	0.00	17055.00	28	17	29	1718	0.0168800931315483	0.615656341974891	0.618536117859264	true	false	false	true
cef287a2-b712-46d1-8f78-853f0360de06	2026-09-14 09:32	2026-09-14 09:31	2026-09-14 09:31	USO	USO261016C00180000	call	180.0000	2026-10-16	5.0600	5.0500	5.4000	159.3400	20735.00	0.00	20735.00	41	15	49	2233	0.0219435736677116	0.63198869732671	0.632169926533887	true	false	false	true
ae574ac5-c8f3-4433-8eeb-6fac0878d322	2026-09-14 09:31	2026-09-14 09:31	2026-09-14 09:31	USO	USO260925C00169000	call	169.0000	2026-09-25	3.8500	3.7250	4.3500	159.4010	255650.00	390.00	255260.00	664	12	664	654	1.01529051987768	0.673537522143412	0.678504323558511	true	false	false	true
21066351-51bc-4bf2-95b7-22ebb89a08a1	2026-09-14 09:31	2026-09-14 09:31	2026-09-14 09:31	USO	USO260923C00163000	call	163.0000	2026-09-23	5.0000	4.8500	5.5000	159.3900	218531.00	520.00	218011.00	437	26	447	141	3.17021276595745	0.652491287784592	0.652491287784592	true	false	false	true
984753b6-d01c-4f2b-a4b0-57a32d0bdb48	2026-09-11 15:58	2026-09-11 15:58	2026-09-11 15:58	USO	USO260918C00150000	call	150.0000	2026-09-18	7.7200	7.6500	7.7500	154.8500	57098.00	3865.00	53233.00	74	5	598	10157	0.0588756522595255	0.566028692143673	0.575089935067127	false	false	false	true
415325c6-6e30-40ee-8c40-38567bfc7ebd	2026-09-11 15:46	2026-09-11 15:46	2026-09-11 15:46	USO	USO260918C00147000	call	147.0000	2026-09-18	9.6300	9.6000	9.8500	154.7192	146332.00	0.00	146332.00	152	11	211	542	0.38929889298893	0.561989955476016	0.569473831007273	false	false	false	true
f6677944-037b-4aca-9424-c80e9794d6bc	2026-09-11 15:26	2026-09-11 15:26	2026-09-11 15:26	USO	USO260911C00153000	call	153.0000	2026-09-11	1.7600	1.7200	1.9900	154.8100	44080.00	19536.00	13632.00	250	5	3856	601	6.41597337770383	0.981059849011587	1.56934158763778	false	false	false	true
bd908ced-65ad-4b5d-913e-1d78d2066944	2026-09-11 14:48	2026-09-11 14:48	2026-09-11 14:48	USO	USO261009C00153000	call	153.0000	2026-10-09	10.4000	10.1000	10.4000	154.6484	86310.00	86310.00	0.00	83	18	138	26	5.30769230769231	0.546065125187719	0.549031902547931	true	false	false	true
6361cac5-76dc-416f-8131-d4e32215edeb	2026-09-11 14:45	2026-09-11 14:45	2026-09-11 14:45	USO	USO261002C00154000	call	154.0000	2026-10-02	8.7800	8.2000	8.8500	154.5600	13177.00	5280.00	6137.00	15	10	43	98	0.438775510204082	0.562525498293334	0.565927076328076	true	false	false	true
be9bec74-a100-4c19-aee9-60b71c7648f5	2026-09-11 14:27	2026-09-11 14:27	2026-09-11 14:27	USO	USO270115C00150000	call	150.0000	2027-01-15	19.7500	19.7000	20.0000	154.4400	86910.00	3960.00	82950.00	44	9	605	5125	0.118048780487805	0.460785942775583	0.459343280962141	true	false	false	true
6105c6a5-10a3-48b8-ac56-4338da152556	2026-09-11 14:27	2026-09-11 14:27	2026-09-11 14:27	USO	USO270115C00150000	call	150.0000	2027-01-15	19.7800	19.7000	20.4000	154.4400	71199.00	25760.00	43459.00	36	18	560	5125	0.109268292682927	0.460785942775583	0.462228572239492	true	false	false	true