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

19e916a3-2f3d-4457-9883-7f68a213df23	2026-09-18 11:59	2026-09-18 11:59	2026-09-18 11:59	USO	USO260918P00156000	put	156.0000	2026-09-18	0.9600	0.9200	0.9600	155.8000	19163.00	11616.00	3515.00	200	5	1687	1663	1.01443174984967	0.645140248308366	0.637587299025083	false	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-09-18T16:02:16.049420Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
1cba5b4d-f511-4604-b3d2-f4f526ae3875	2026-09-18 11:57	2026-09-18 11:57	2026-09-18 11:57	USO	USO261016C00151000	call	151.0000	2026-10-16	10.6600	10.6500	11.3500	155.7729	10656.00	0.00	10656.00	10	9	88	14061	0.00625844534528127	0.45981529002416	0.458587394534678	true	false	false	true
910de701-92d8-4f8e-adfb-3ee5b87ec25a	2026-09-18 11:48	2026-09-18 11:48	2026-09-18 11:48	USO	USO261002C00165000	call	165.0000	2026-10-02	2.6000	2.5200	2.7800	156.0397	19743.00	1290.00	18453.00	76	21	598	1264	0.473101265822785	0.476784622823272	0.474890530061293	true	false	false	true
b7330fd8-d55f-46d9-a818-2100f082bc5a	2026-09-18 11:41	2026-09-18 11:41	2026-09-18 11:41	USO	USO261002C00165000	call	165.0000	2026-10-02	2.4700	2.4500	2.5700	156.1000	10141.00	248.00	9893.00	41	16	521	1264	0.412183544303797	0.463705261510977	0.463705261510977	true	false	false	true
f2670f28-3f4f-4fe4-b98c-ca07010e7780	2026-09-18 11:33	2026-09-18 11:33	2026-09-18 11:33	USO	USO261023P00157000	put	157.0000	2026-10-23	9.6900	9.6500	9.7000	156.3505	42642.00	31040.00	11602.00	44	22	58	31	1.87096774193548	0.501740324864986	0.501740324864986	true	false	false	true
e09ada99-5ddb-42ab-ad93-7c21d875759a	2026-09-18 11:05	2026-09-18 11:05	2026-09-18 11:05	USO	USO261016P00140000	put	140.0000	2026-10-16	2.4300	2.4300	2.4500	155.7100	52991.00	0.00	48843.00	218	14	2111	7867	0.268336087453921	0.495422366681254	0.494576350931473	true	false	false	true
fd809895-356e-4ea7-ac82-194180786c40	2026-09-18 10:50	2026-09-18 10:49	2026-09-18 10:49	USO	USO281215C00240000	call	240.0000	2028-12-15	18.1100	16.0000	18.9500	156.1580	25352.00	25352.00	0.00	14	6	57	54	1.05555555555556	0.380391268951906	0.380056388050489	false	false	false	true
9dd53f80-a7d1-4f44-84b5-9273f9ced812	2026-09-18 10:34	2026-09-18 10:34	2026-09-18 10:34	USO	USO260930C00167000	call	167.0000	2026-09-30	2.0300	2.0100	2.1700	157.0800	23949.00	813.00	22934.00	118	29	155	147	1.05442176870748	0.475788061918728	0.477752729249813	true	false	false	true
f1a22c5f-46a5-40a8-a764-dcd49f5b8690	2026-09-18 10:28	2026-09-18 10:27	2026-09-18 10:27	USO	USO260918P00160000	put	160.0000	2026-09-18	3.1000	2.9000	3.1000	157.2600	51714.00	36214.00	0.00	167	8	250	941	0.26567481402763	0.816384477719791	0.798337029558732	false	false	false	true
81ec7315-0ed1-4e1c-818e-2f53d1e12ac7	2026-09-18 10:19	2026-09-18 10:19	2026-09-18 10:19	USO	USO261016P00130000	put	130.0000	2026-10-16	0.8800	0.8500	0.8800	157.5350	21586.00	18920.00	2666.00	246	16	552	8625	0.064	0.52768884217653	0.524574874070472	false	false	false	true
25ac366f-875b-468f-8237-61eb0980dfe8	2026-09-18 10:19	2026-09-18 10:19	2026-09-18 10:19	USO	USO260918P00158000	put	158.0000	2026-09-18	1.3500	1.2900	1.4300	157.4800	36295.00	7810.00	23625.00	269	25	537	498	1.07831325301205	0.66920527614216	0.66920527614216	true	false	false	true
6c0cde93-1ce0-4c2f-964a-641808eaa030	2026-09-18 10:15	2026-09-18 10:14	2026-09-18 10:14	USO	USO261120P00150000	put	150.0000	2026-11-20	9.0000	8.9000	9.3000	157.1400	171903.00	170100.00	1803.00	191	5	218	2211	0.0985979194934419	0.502214643356732	0.500985018581322	false	false	false	true
ca080a08-6d88-4e6f-80f5-05a961caaf5f	2026-09-18 10:00	2026-09-18 10:00	2026-09-18 10:00	USO	USO261009P00155000	put	155.0000	2026-10-09	6.1500	5.9000	6.1500	157.1885	28883.00	28883.00	0.00	47	16	47	91	0.516483516483517	0.493008180140931	0.493008180140931	true	false	false	true
623a2c66-6111-4b37-9a24-4427a32a0fd0	2026-09-18 09:53	2026-09-18 09:53	2026-09-18 09:53	USO	USO261016C00149000	call	149.0000	2026-10-16	13.0900	12.8500	13.1500	157.2700	10472.00	10472.00	0.00	8	8	14	672	0.0208333333333333	0.473524883725175	0.473524883725175	true	false	false	true
1de1db83-574c-44b4-8cef-9abb928b2784	2026-09-18 09:50	2026-09-18 09:50	2026-09-18 09:50	USO	USO261218P00155000	put	155.0000	2026-12-18	13.9400	13.6500	14.7500	157.3400	19510.00	2780.00	16730.00	14	5	14	326	0.0429447852760736	0.513736548588049	0.512099321855436	true	false	false	true
4ff26247-913a-4816-adfd-3fc6a981fb1f	2026-09-18 09:39	2026-09-18 09:39	2026-09-18 09:39	USO	USO261002C00168000	call	168.0000	2026-10-02	2.0400	1.9300	2.0600	156.8700	68650.00	48756.00	19894.00	337	8	341	28	12.1785714285714	0.470784847811802	0.470784847811802	true	false	false	true
81d8ba0e-82bc-45d9-ae16-43da1ea372ce	2026-09-18 09:32	2026-09-18 09:32	2026-09-18 09:32	USO	USO260925C00185000	call	185.0000	2026-09-25	0.2200	0.1900	0.2200	157.0400	21648.00	17196.00	4452.00	1000	23	1000	4160	0.240384615384615	0.65416356638444	0.65416356638444	true	false	false	true
9657da07-a913-4504-9b4a-4beb802912d1	2026-09-18 09:31	2026-09-18 09:31	2026-09-18 09:31	USO	USO260918P00155000	put	155.0000	2026-09-18	0.4000	0.3800	0.4700	156.9950	11361.00	40.00	11321.00	284	13	343	3444	0.0995934959349594	0.674621228053633	0.667060214202759	false	false	false	true
9c3dce3b-96ba-497c-a311-3ba1b08f6e9e	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	USO	USO260918C00156000	call	156.0000	2026-09-18	1.7400	1.7200	1.9400	157.0400	20004.00	0.00	19656.00	115	33	637	1897	0.335793357933579	0.672501745795942	0.659903701841211	true	false	false	true
88db28cb-bc46-4175-a4a1-f17ecc7c3b6f	2026-09-17 15:24	2026-09-17 15:24	2026-09-17 15:24	USO	USO261002C00165000	call	165.0000	2026-10-02	2.7700	2.5500	2.8000	155.1200	51269.00	40035.00	11234.00	185	11	395	1177	0.335598980458794	0.502604131434367	0.501682046649591	true	false	false	true
f28d1e79-1a9a-4f39-92e8-45ec22e84da5	2026-09-17 15:24	2026-09-17 15:24	2026-09-17 15:24	USO	USO261009P00147000	put	147.0000	2026-10-09	3.8000	3.7500	3.9500	155.1500	25850.00	0.00	25080.00	68	10	117	151	0.774834437086093	0.49635064997774	0.492574379868978	true	false	false	true
c3d43232-d5a6-4fe0-a6fc-559bd4b16dea	2026-09-17 15:24	2026-09-17 15:24	2026-09-17 15:24	USO	USO261002P00141000	put	141.0000	2026-10-02	1.3700	1.3600	1.5300	155.1908	17853.00	417.00	17436.00	130	19	166	223	0.744394618834081	0.505330238757345	0.504010823067165	true	false	false	true
2e3a7067-526c-4ae2-9895-7bff047451f2	2026-09-17 15:24	2026-09-17 15:24	2026-09-17 15:24	USO	USO261002P00146000	put	146.0000	2026-10-02	2.4200	2.4100	2.6500	155.1908	55030.00	2464.00	52566.00	227	21	377	127	2.96850393700787	0.49362589859432	0.49362589859432	true	false	false	true
cf12f301-8513-4053-9d80-53ce774ea973	2026-09-17 14:48	2026-09-17 14:48	2026-09-17 14:48	USO	USO261016C00163000	call	163.0000	2026-10-16	6.2000	6.2000	6.4000	156.1350	14890.00	1250.00	13640.00	24	7	73	275	0.265454545454545	0.507056708916281	0.504146289934152	true	false	false	true
be14f8a4-8298-4467-a4d5-c912f3d75593	2026-09-17 14:48	2026-09-17 14:48	2026-09-17 14:48	USO	USO261016C00162000	call	162.0000	2026-10-16	6.5600	6.5000	6.7000	156.1350	30158.00	0.00	28848.00	46	11	61	662	0.0921450151057402	0.503596793980032	0.50301925721953	false	false	false	true
782a9864-5e23-4cc8-ac6b-2c97e119c863	2026-09-17 14:43	2026-09-17 14:43	2026-09-17 14:43	USO	USO261002P00144000	put	144.0000	2026-10-02	1.8000	1.6700	1.8100	156.0390	25377.00	25020.00	357.00	141	13	152	533	0.285178236397749	0.500307547900617	0.500307547900617	true	false	false	true
5e7df640-b507-46e1-a9aa-ffc31ff86a97	2026-09-17 14:42	2026-09-17 14:42	2026-09-17 14:42	USO	USO280121C00245000	call	245.0000	2028-01-21	10.0500	9.5000	10.1000	156.0700	178884.00	177879.00	1005.00	178	41	251	1343	0.186895011169025	0.404538139808986	0.404538139808986	false	false	false	true
4ad42b69-a7c3-4c41-ae65-a5294234c124	2026-09-17 14:22	2026-09-17 14:22	2026-09-17 14:22	USO	USO280317C00210000	call	210.0000	2028-03-17	16.8900	16.0000	17.3500	156.5000	27023.00	23648.00	3375.00	16	10	22	355	0.0619718309859155	0.386769983004058	0.386097502753854	true	false	false	true
f2d86d64-ba19-42db-ae7e-02d78c27286a	2026-09-17 14:16	2026-09-17 14:16	2026-09-17 14:16	USO	USO261218P00110000	put	110.0000	2026-12-18	1.2700	1.2400	1.2800	155.9600	21389.00	14605.00	0.00	168	6	335	8571	0.0390852875977132	0.517955759602684	0.516947285052312	false	false	false	true
029eb921-c3b3-4a2b-925d-a304aa341a1b	2026-09-17 13:54	2026-09-17 13:54	2026-09-17 13:54	USO	USO260930P00150000	put	150.0000	2026-09-30	3.0000	2.9900	3.2000	156.4700	19173.00	0.00	19173.00	64	7	204	416	0.490384615384615	0.497428861468085	0.496461022164717	false	false	false	true
bb19670c-7b1a-40ae-ab1d-18b6835bb807	2026-09-17 13:42	2026-09-17 13:42	2026-09-17 13:42	USO	USO261016P00140000	put	140.0000	2026-10-16	2.7000	2.6000	2.8000	156.2431	71256.00	3216.00	68040.00	264	6	1386	7131	0.194362641985696	0.51706356788302	0.515431685169791	true	false	false	true
727f38bb-32ad-45b8-b774-e59e5aecf197	2026-09-17 12:34	2026-09-17 12:33	2026-09-17 12:33	USO	USO260925C00160000	call	160.0000	2026-09-25	3.0000	2.7500	3.1000	155.8650	80979.00	35386.00	23093.00	270	17	673	2410	0.279253112033195	0.516983770643191	0.507674822206606	true	false	false	true
4b520746-a366-4320-bc38-f2896f2d94de	2026-09-17 12:34	2026-09-17 12:33	2026-09-17 12:33	USO	USO261218C00180000	call	180.0000	2026-12-18	8.7000	8.0000	8.7500	155.6500	34787.00	33922.00	865.00	40	16	135	1393	0.0969131371141421	0.532040443359219	0.532040443359219	true	false	false	true
9f797772-414d-4ba2-854b-af0fb64e57d6	2026-09-17 12:31	2026-09-17 12:31	2026-09-17 12:31	USO	USO261023C00162000	call	162.0000	2026-10-23	7.3500	6.5500	7.3500	155.3800	40415.00	38215.00	730.00	55	20	67	98	0.683673469387755	0.507342859458208	0.507342859458208	true	false	false	true
31869312-9bf1-4ea6-9ef9-12a2d2dcfb64	2026-09-17 12:31	2026-09-17 12:31	2026-09-17 12:31	USO	USO261009C00164000	call	164.0000	2026-10-09	4.5000	3.8000	4.5500	155.3800	61192.00	60742.00	450.00	136	14	142	0	0	0.509092271215307	0.509092271215307	true	false	false	true
c3a15075-f4ad-46d5-8f1b-134cb949e66e	2026-09-17 12:04	2026-09-17 12:03	2026-09-17 12:03	USO	USO261030P00155000	put	155.0000	2026-10-30	10.7000	10.3000	10.9500	154.3450	389474.00	383060.00	6414.00	364	15	384	169	2.27218934911243	0.50911415164958	0.508639046707857	true	false	false	true
9bfdd96c-3fd5-4cac-b89c-6c34b74c8a42	2026-09-17 11:36	2026-09-17 11:36	2026-09-17 11:36	USO	USO261016C00165000	call	165.0000	2026-10-16	5.0000	4.8500	5.0000	154.8050	149922.00	149922.00	0.00	300	16	602	3462	0.173887926054304	0.503307726787843	0.503307726787843	false	false	false	true
b340e190-37b0-4bff-af10-277cc1f3169d	2026-09-17 11:35	2026-09-17 11:35	2026-09-17 11:35	USO	USO260918P00154000	put	154.0000	2026-09-18	1.4900	1.4900	1.6400	154.7500	18031.00	0.00	18031.00	121	6	623	947	0.657866948257656	0.576502560280287	0.573357357402867	false	false	false	true
21c0d29c-70cc-4d02-921f-3e392ea63713	2026-09-17 11:26	2026-09-17 11:26	2026-09-17 11:26	USO	USO261218C00200000	call	200.0000	2026-12-18	4.8500	4.8500	5.1000	154.6500	40760.00	0.00	40760.00	84	5	227	3047	0.0744995077125041	0.552614749730182	0.552614749730182	false	false	false	true
d469e9e3-f334-4fd6-9f95-4762ac795fcd	2026-09-17 11:07	2026-09-17 11:07	2026-09-17 11:07	USO	USO260925P00152000	put	152.0000	2026-09-25	2.9200	2.6500	2.9200	154.8400	29163.00	29163.00	0.00	100	23	113	499	0.226452905811623	0.468376550861902	0.467227656701314	false	false	false	true
09193fe9-9897-46b3-9115-fb0c6b0595ad	2026-09-17 10:58	2026-09-17 10:58	2026-09-17 10:58	USO	USO270115C00175000	call	175.0000	2027-01-15	11.2900	10.8000	11.5000	155.2099	50814.00	50814.00	0.00	45	9	74	638	0.115987460815047	0.507181210221279	0.499673421725494	false	false	false	true
8f135967-f688-4f47-bda1-cc378f9c8813	2026-09-17 10:29	2026-09-17 10:28	2026-09-17 10:28	USO	USO280616C00315000	call	315.0000	2028-06-16	6.4000	6.0500	6.6000	154.0750	40317.00	33277.00	7040.00	63	10	320	207	1.54589371980676	0.404131849627193	0.403944559061323	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
71de4958-ddc8-4755-9ff0-e412068e3d00	2026-09-17 09:56	2026-09-17 09:56	2026-09-17 09:56	USO	USO270416C00215000	call	215.0000	2027-04-16	8.0800	8.0500	8.8000	153.9600	15348.00	0.00	15348.00	19	5	20	15	1.33333333333333	0.503429903489071	0.502136225481435	true	false	false	true
deb338f1-c322-43cc-99ac-c320e4ad0f7f	2026-09-17 09:50	2026-09-17 09:50	2026-09-17 09:50	USO	USO261023C00153000	call	153.0000	2026-10-23	10.5600	10.5500	11.5500	154.0400	102451.00	0.00	102451.00	97	12	97	74	1.31081081081081	0.508526136126486	0.508526136126486	false	false	false	true
a44a83f3-663e-4eea-8e87-15a3f66eef73	2026-09-17 09:49	2026-09-17 09:49	2026-09-17 09:49	USO	USO261120C00170000	call	170.0000	2026-11-20	8.2500	8.1500	8.7500	154.2400	21447.00	0.00	21447.00	26	8	76	1795	0.0423398328690808	0.534964135032742	0.534964135032742	false	false	false	true
2047379a-44b4-4f86-ab4a-e7001673a7c3	2026-09-17 09:46	2026-09-17 09:46	2026-09-17 09:46	USO	USO260925C00166000	call	166.0000	2026-09-25	1.3700	1.3700	1.5500	154.3400	24528.00	278.00	24250.00	179	19	179	309	0.579288025889968	0.55668812562768	0.55358023434194	true	false	false	true
e14303d9-79c9-40b0-90d4-c0372f627513	2026-09-17 09:43	2026-09-17 09:43	2026-09-17 09:43	USO	USO261120C00157000	call	157.0000	2026-11-20	12.7400	12.3500	12.9500	154.6400	124817.00	124817.00	0.00	98	8	101	339	0.297935103244838	0.523635269184705	0.514708560958504	false	false	false	true
91b3360f-7a6a-4bc2-8b28-8fd4f0d18b43	2026-09-17 09:38	2026-09-17 09:38	2026-09-17 09:38	USO	USO261218P00135000	put	135.0000	2026-12-18	6.4600	6.4500	6.7500	154.2600	195735.00	0.00	195735.00	303	5	606	2978	0.203492276695769	0.50603650782706	0.50603650782706	false	false	false	true
b49fd1bf-0764-47f1-b0bc-52bb45431de2	2026-09-17 09:30	2026-09-17 09:30	2026-09-17 09:30	USO	USO261218P00150000	put	150.0000	2026-12-18	13.2700	13.0750	13.4000	154.1900	59695.00	25175.00	34520.00	45	7	192	1980	0.096969696969697	0.53217707089368	0.528812605215416	true	false	false	true