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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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

5bc579e8-4d1b-4873-b510-381ebf953d4a	2026-09-28 10:54	2026-09-28 10:54	2026-09-28 10:54	USO	USO261016P00137000	put	137.0000	2026-10-16	1.8000	1.7500	1.8700	153.1900	32580.00	14580.00	18000.00	181	6	305	2280	0.133771929824561	0.564865451572474	0.564865451572474	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-28T14:55:24.203019Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
6b4fdec8-ed5c-46f7-9d2a-59cc092ea3f6	2026-09-28 10:50	2026-09-28 10:50	2026-09-28 10:50	USO	USO261023P00152000	put	152.0000	2026-10-23	7.7000	7.5000	7.7500	153.1700	20785.00	20020.00	765.00	27	20	109	112	0.973214285714286	0.532914029420158	0.532914029420158	true	false	false	true
8fb95f62-0b0d-486a-929f-045cd26e4ec5	2026-09-28 10:50	2026-09-28 10:50	2026-09-28 10:50	USO	USO261016P00152000	put	152.0000	2026-10-16	6.5500	6.4000	6.5500	153.1600	15065.00	15065.00	0.00	23	6	39	161	0.242236024844721	0.537775706438962	0.537775706438962	false	false	false	true
de0786e6-166e-48ae-90ca-cd04d25b4e0b	2026-09-28 10:50	2026-09-28 10:50	2026-09-28 10:50	USO	USO261023P00153000	put	153.0000	2026-10-23	8.1500	8.0000	8.2000	153.1899	21190.00	19560.00	0.00	26	9	26	93	0.279569892473118	0.529974785312287	0.529974785312287	false	false	false	true
4daac983-b7ac-42e2-8a21-a2fa79ea2f77	2026-09-28 10:49	2026-09-28 10:49	2026-09-28 10:49	USO	USO261120P00150000	put	150.0000	2026-11-20	10.0000	9.7000	10.0500	153.0000	218996.00	214996.00	4000.00	219	26	338	1818	0.185918591859186	0.521414190587663	0.521414190587663	true	false	false	true
3d9daa88-6de8-4196-b440-a7cff39d5ffd	2026-09-28 10:47	2026-09-28 10:47	2026-09-28 10:47	USO	USO261002C00154000	call	154.0000	2026-10-02	3.4000	3.3500	3.5000	152.9200	15649.00	0.00	4769.00	46	5	383	2244	0.170677361853832	0.606413940280422	0.606413940280422	false	false	false	true
b86dd51b-3579-4874-9648-cd9117f76af8	2026-09-28 10:46	2026-09-28 10:46	2026-09-28 10:46	USO	USO261030P00152500	put	152.5000	2026-10-30	9.0500	8.9500	9.2000	152.0000	84165.00	69685.00	13575.00	93	9	93	15	6.2	0.522681029153177	0.522681029153177	false	false	false	true
ac5da471-bc01-48da-ac76-06571a1b9894	2026-09-28 10:42	2026-09-28 10:42	2026-09-28 10:42	USO	USO261002C00154000	call	154.0000	2026-10-02	3.1000	3.1000	3.2000	152.1400	19840.00	0.00	19840.00	64	6	300	2244	0.133689839572193	0.615187153007182	0.615187153007182	false	false	false	true
f28ac935-280a-48ef-ad9e-adc656b27269	2026-09-28 10:33	2026-09-28 10:33	2026-09-28 10:33	USO	USO261120C00158000	call	158.0000	2026-11-20	9.4000	9.1000	9.4500	151.7800	13160.00	12220.00	940.00	14	7	25	809	0.030902348578492	0.50541334561781	0.50541334561781	true	false	false	true
1672e4c5-fb3b-4a7f-8f50-1eb91fed6bd4	2026-09-28 10:23	2026-09-28 10:22	2026-09-28 10:22	USO	USO261016P00120000	put	120.0000	2026-10-16	0.3200	0.3200	0.3600	151.0000	19200.00	0.00	19200.00	600	6	809	16756	0.0482812126999284	0.610209118656625	0.610209118656625	false	false	false	true
7f2391db-a128-4777-8a11-f0d6e0d77509	2026-09-28 10:08	2026-09-28 10:08	2026-09-28 10:08	USO	USO261023P00129500	put	129.5000	2026-10-23	1.4300	1.3000	1.4400	151.3550	12298.00	12298.00	0.00	86	5	86	171	0.502923976608187	0.557331100792903	0.557331100792903	false	false	false	true
14ef4dd2-4540-49b4-881d-dfe7ee6ff8b2	2026-09-28 10:01	2026-09-28 10:01	2026-09-28 10:01	USO	USO261120P00140000	put	140.0000	2026-11-20	6.5000	6.2500	6.5500	150.8900	32500.00	18200.00	1300.00	50	19	66	4059	0.016260162601626	0.519299205686956	0.519299205686956	false	false	false	true
869f900c-3bcd-4cff-9c59-1b3c646a7ae4	2026-09-28 09:54	2026-09-28 09:54	2026-09-28 09:54	USO	USO261002P00145000	put	145.0000	2026-10-02	1.7000	1.6400	1.7000	151.4000	29410.00	29410.00	0.00	173	27	1147	4146	0.276652194886638	0.672011069863848	0.672011069863848	false	false	false	true
0fb21d15-5595-4faf-a895-bc4a77fab38f	2026-09-28 09:54	2026-09-28 09:54	2026-09-28 09:54	USO	USO261016P00150000	put	150.0000	2026-10-16	6.3500	6.2000	6.3500	151.4000	20955.00	20955.00	0.00	33	7	106	4242	0.024988213107025	0.537691775658521	0.537691775658521	false	false	false	true
e02ece02-f48e-4c4b-b8ea-5a0a9f28f83e	2026-09-28 09:54	2026-09-28 09:54	2026-09-28 09:54	USO	USO261002P00145000	put	145.0000	2026-10-02	1.7000	1.7000	1.7100	151.4000	14450.00	0.00	5100.00	85	7	882	4146	0.21273516642547	0.672011069863848	0.672011069863848	true	false	false	true
f538d695-1f8f-46af-b214-a5134720f53b	2026-09-28 09:53	2026-09-28 09:53	2026-09-28 09:53	USO	USO261002P00145000	put	145.0000	2026-10-02	1.7000	1.6600	1.7000	151.0000	11220.00	11220.00	0.00	66	18	713	4146	0.171972986010613	0.670252680383545	0.670252680383545	false	false	false	true
f56a1153-dd33-4574-9031-15a40d9b2814	2026-09-28 09:53	2026-09-28 09:53	2026-09-28 09:53	USO	USO261002P00145000	put	145.0000	2026-10-02	1.7000	1.6500	1.7200	151.0000	14620.00	3910.00	10710.00	86	5	522	4146	0.125904486251809	0.666477029463423	0.666477029463423	true	false	false	true
3c950fb6-d4fb-463f-8360-e8a6d500465a	2026-09-28 09:53	2026-09-28 09:53	2026-09-28 09:53	USO	USO261002P00145000	put	145.0000	2026-10-02	1.7000	1.7000	1.7200	151.0000	19040.00	0.00	15810.00	112	5	436	4146	0.105161601543657	0.666477029463423	0.666477029463423	true	false	false	true
724e97b3-cfed-45c9-abe2-670bebff72d0	2026-09-28 09:50	2026-09-28 09:50	2026-09-28 09:50	USO	USO261023P00148000	put	148.0000	2026-10-23	6.4500	6.2500	6.5000	151.6300	17415.00	17415.00	0.00	27	8	34	346	0.0982658959537572	0.532700506441324	0.532700506441324	false	false	false	true
d6e46581-61cc-47dc-b54b-dc36cb05af2a	2026-09-28 09:48	2026-09-28 09:48	2026-09-28 09:48	USO	USO261002C00155000	call	155.0000	2026-10-02	2.4500	2.4500	2.5600	151.6950	10290.00	0.00	10290.00	42	10	162	2980	0.0543624161073826	0.602029024097244	0.602029024097244	false	false	false	true
420f82df-1398-4d64-a546-32cb5c5428d7	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	USO	USO261016C00166000	call	166.0000	2026-10-16	2.5300	2.4800	2.6200	151.9000	14927.00	11132.00	3795.00	59	10	59	130	0.453846153846154	0.532718609006118	0.532718609006118	false	false	false	true
9d3a14e2-ceb2-44d6-9081-1d646d3f86cf	2026-09-28 09:40	2026-09-28 09:40	2026-09-28 09:40	USO	USO261016P00141000	put	141.0000	2026-10-16	3.0000	3.0000	3.1000	151.6900	15000.00	0.00	15000.00	50	5	56	462	0.121212121212121	0.555979747385966	0.555979747385966	true	false	false	true
6ac0363c-6f05-4f4d-90e3-704584e1ab4a	2026-09-28 09:39	2026-09-28 09:39	2026-09-28 09:39	USO	USO261023P00152000	put	152.0000	2026-10-23	8.3500	8.2000	8.4500	151.7750	27546.00	26711.00	835.00	33	14	37	112	0.330357142857143	0.533837057430458	0.533837057430458	false	false	false	true
705f0863-4090-487b-b84c-fa7919b3a623	2026-09-28 09:34	2026-09-28 09:34	2026-09-28 09:34	USO	USO261016P00150000	put	150.0000	2026-10-16	6.2500	6.1500	6.2500	151.8900	14994.00	14994.00	0.00	24	5	49	4242	0.0115511551155116	0.546179726311029	0.546179726311029	false	false	false	true
5ae1c51a-fb18-4266-b5d3-3ab729fb72a7	2026-09-28 09:32	2026-09-28 09:32	2026-09-28 09:32	USO	USO260930P00150000	put	150.0000	2026-09-30	2.2600	2.1600	2.4200	151.5100	15820.00	452.00	15368.00	70	11	171	1197	0.142857142857143	0.666815749948572	0.666815749948572	true	false	false	true
8d644b5b-0dda-4965-9c2c-c7714aba3b40	2026-09-28 09:32	2026-09-28 09:32	2026-09-28 09:32	USO	USO261009C00148000	call	148.0000	2026-10-09	7.7500	7.7500	8.1500	151.5300	48825.00	0.00	48825.00	63	17	65	236	0.275423728813559	0.550500050436689	0.550500050436689	true	false	false	true
ec959b23-e5ca-437e-afdc-e93a2862c70d	2026-09-28 09:32	2026-09-28 09:32	2026-09-28 09:32	USO	USO261007C00150000	call	150.0000	2026-10-07	6.0500	5.8500	6.9500	151.5300	50825.00	25415.00	25410.00	84	6	84	91	0.923076923076923	0.547522920817074	0.547522920817074	true	false	false	true
39edc805-40dc-4c46-83f5-d82f83753c01	2026-09-28 09:32	2026-09-28 09:32	2026-09-28 09:32	USO	USO261016C00148000	call	148.0000	2026-10-16	9.0500	8.9000	10.4000	151.5300	48875.00	910.00	47965.00	54	11	54	851	0.063454759106933	0.526269755515766	0.526269755515766	true	false	false	true
89fec454-6676-4e0d-b5c1-7b924c322cb6	2026-09-28 09:31	2026-09-28 09:31	2026-09-28 09:31	USO	USO261016C00155000	call	155.0000	2026-10-16	5.8000	5.5500	6.1000	151.8200	18560.00	580.00	17980.00	32	18	72	2979	0.0241691842900302	0.526490816879424	0.526490816879424	true	false	false	true
5177af2d-45bb-49c2-8233-69c5c9bee320	2026-09-28 09:31	2026-09-28 09:31	2026-09-28 09:31	USO	USO261007C00154000	call	154.0000	2026-10-07	4.2300	4.0500	5.3000	151.7155	19020.00	7980.00	11040.00	45	12	45	97	0.463917525773196	0.548384615726028	0.532484262850742	false	false	false	true
3623475b-7936-4359-947a-716e16ac61d1	2026-09-28 09:31	2026-09-28 09:31	2026-09-28 09:31	USO	USO261007P00145000	put	145.0000	2026-10-07	2.6300	2.6300	3.6500	151.8601	48392.00	0.00	48392.00	184	27	636	65	9.78461538461539	0.584408193655106	0.584408193655106	true	false	false	true
b9831298-9b3b-4c56-b888-e9a7cba4bfd2	2026-09-28 09:31	2026-09-28 09:31	2026-09-28 09:31	USO	USO261009P00149000	put	149.0000	2026-10-09	4.7000	4.7000	5.3500	151.8400	102930.00	0.00	102930.00	219	12	220	132	1.66666666666667	0.584795561866073	0.585386941557414	false	false	false	true
2dea71c5-b1ee-48ca-b47e-304a81af9d73	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	USO	USO261016P00149000	put	149.0000	2026-10-16	7.8500	7.8000	7.8500	148.0000	54950.00	51025.00	0.00	70	13	185	326	0.567484662576687	0.54125438709404	0.54125438709404	true	false	false	true
d5b0cabb-9be7-401d-8f64-d47f08ba780d	2026-09-25 15:55	2026-09-25 15:55	2026-09-25 15:55	USO	USO261016C00140000	call	140.0000	2026-10-16	12.5500	12.4500	12.7000	148.4200	47690.00	1255.00	46435.00	38	6	235	5388	0.043615441722346	0.535075290107578	0.535075290107578	true	false	false	true
33d760c6-0a4b-4264-b3fa-a9f7a6b95c0f	2026-09-25 15:37	2026-09-25 15:37	2026-09-25 15:37	USO	USO260930C00159000	call	159.0000	2026-09-30	0.6600	0.6500	0.6600	148.0000	42900.00	42900.00	0.00	650	7	745	541	1.37707948243993	0.513396802438108	0.513396802438108	true	false	false	true
93c9a6b8-b0bb-4dfd-873c-af081db5a30a	2026-09-25 15:33	2026-09-25 15:33	2026-09-25 15:33	USO	USO261016P00150000	put	150.0000	2026-10-16	8.0500	7.9500	8.0500	149.0050	12880.00	12880.00	0.00	16	7	600	4119	0.145666423889294	0.540702745925297	0.540702745925297	true	false	false	true
af191b27-934c-47eb-bdbc-b655fd99de3f	2026-09-25 15:30	2026-09-25 15:30	2026-09-25 15:30	USO	USO280121P00121000	put	121.0000	2028-01-21	12.9000	11.5500	12.9000	148.9700	12900.00	12900.00	0.00	10	7	25	561	0.0445632798573975	0.456846597408609	0.456846597408609	true	false	false	true
466c45b5-6dc8-4344-b901-35e9082138d2	2026-09-25 15:28	2026-09-25 15:28	2026-09-25 15:28	USO	USO261023P00148000	put	148.0000	2026-10-23	8.0500	7.9000	8.1500	149.0600	23345.00	23345.00	0.00	29	7	157	311	0.504823151125402	0.536696274094041	0.536696274094041	false	false	false	true
8d3e85d4-20f3-4f73-aac1-0f67b9271346	2026-09-25 15:16	2026-09-25 15:16	2026-09-25 15:16	USO	USO260930P00128000	put	128.0000	2026-09-30	0.1400	0.0800	0.1400	149.1800	14000.00	14000.00	0.00	1000	9	3688	384	9.60416666666667	0.706075038572014	0.706075038572014	true	false	false	true
a228b19c-cfb5-48f5-83b8-7c7b7bbb0768	2026-09-25 15:16	2026-09-25 15:16	2026-09-25 15:16	USO	USO260925C00147000	call	147.0000	2026-09-25	2.0500	1.3000	2.0500	149.0201	24600.00	24600.00	0.00	120	6	846	746	1.13404825737265	0.939034186644863	0.939034186644863	false	false	false	true
87468b1b-8903-40cc-b7e6-74c366e4c708	2026-09-25 15:09	2026-09-25 15:08	2026-09-25 15:08	USO	USO261002C00155000	call	155.0000	2026-10-02	2.1500	2.1000	2.1500	148.0000	10750.00	10750.00	0.00	50	16	2562	1155	2.21818181818182	0.546759471401305	0.546759471401305	false	false	false	true
e2e6172b-c8a3-49a4-bcfc-c4ca163430c2	2026-09-25 15:01	2026-09-25 15:01	2026-09-25 15:01	USO	USO261120P00120000	put	120.0000	2026-11-20	2.0000	2.0000	2.0300	148.0000	20000.00	0.00	20000.00	100	7	430	3588	0.11984392419175	0.526778339575985	0.526778339575985	false	false	false	true
591aa0e6-f1a7-443e-ac5e-47963cf0effd	2026-09-25 14:57	2026-09-25 14:57	2026-09-25 14:57	USO	USO261120C00150000	call	150.0000	2026-11-20	11.2000	11.0000	11.4500	148.0000	22400.00	3360.00	19040.00	20	5	1007	4633	0.217353766458019	0.499821701567504	0.498678369637995	false	false	false	true
662b0363-6c0c-47d7-b5c3-25520ffa8d7a	2026-09-25 14:39	2026-09-25 14:39	2026-09-25 14:39	USO	USO260925C00150000	call	150.0000	2026-09-25	0.0600	0.0500	0.0600	148.4290	10488.00	10488.00	0.00	1748	42	7021	4563	1.53868069252685	0.669157051970127	0.669157051970127	false	false	false	true
d8a64cfe-de65-4e4a-ae32-2af6558a1427	2026-09-25 14:37	2026-09-25 14:37	2026-09-25 14:37	USO	USO261030P00139000	put	139.0000	2026-10-30	5.2500	5.2500	5.4500	148.2500	22050.00	0.00	22050.00	42	12	82	202	0.405940594059406	0.528559892040633	0.528559892040633	false	false	false	true
0c359c04-1e65-4f0a-9414-09da15361835	2026-09-25 14:35	2026-09-25 14:35	2026-09-25 14:35	USO	USO260930P00140000	put	140.0000	2026-09-30	1.0900	1.0300	1.1400	148.1950	16350.00	11772.00	0.00	150	5	1950	5296	0.368202416918429	0.581658068150406	0.581658068150406	true	false	false	true
48e24b31-c409-419f-91fe-4bd9ff256bd7	2026-09-25 14:29	2026-09-25 14:29	2026-09-25 14:29	USO	USO260930P00141000	put	141.0000	2026-09-30	1.2000	1.1700	1.2500	148.5850	21098.00	0.00	18480.00	176	19	1653	2572	0.642690513219285	0.575439267429506	0.575439267429506	true	false	false	true
fcee7021-8acd-4411-a2ab-c3b75b206fd0	2026-09-25 14:27	2026-09-25 14:27	2026-09-25 14:27	USO	USO261120C00150000	call	150.0000	2026-11-20	11.3000	11.2500	11.3000	148.5800	58760.00	58760.00	0.00	52	5	861	4633	0.185840707964602	0.496578599238722	0.496578599238722	false	false	false	true
c3447ea8-61e6-4f8b-9cbf-641886280451	2026-09-25 14:27	2026-09-25 14:27	2026-09-25 14:27	USO	USO261120C00150000	call	150.0000	2026-11-20	11.2500	11.2500	11.6000	148.5800	76500.00	0.00	76500.00	68	6	929	4633	0.200518022879344	0.494417974177791	0.494417974177791	false	false	false	true
a30a1270-7bd1-4079-abd3-ef64f520bfba	2026-09-25 14:27	2026-09-25 14:27	2026-09-25 14:27	USO	USO261120C00150000	call	150.0000	2026-11-20	11.3000	11.2500	11.7000	148.5800	183060.00	51980.00	126560.00	162	12	292	4633	0.0630261169868336	0.496578599238722	0.496578599238722	false	false	false	true