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

512b8c36-cf3f-43c4-ad86-07b9c8e23d0a	2026-09-04 10:49	2026-09-04 10:49	2026-09-04 10:49	USO	USO261016C00155000	call	155.0000	2026-10-16	3.9500	3.7000	4.0000	141.0100	39478.00	39478.00	0.00	100	13	862	1782	0.483726150392817	0.455804909420319	0.455804909420319	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-04T15:01:23.801406Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c11b8111-0ffa-4f83-adf7-52ecb1a20281	2026-09-04 09:45	2026-09-04 09:45	2026-09-04 09:45	USO	USO260911P00135000	put	135.0000	2026-09-11	1.4400	1.4000	1.4500	138.7600	14416.00	14416.00	0.00	100	5	231	1236	0.186893203883495	0.395863245211797	0.39435173118047	true	false	false	true
d70096df-9a07-41a4-90a1-612b10e8f07b	2026-09-04 09:40	2026-09-04 09:40	2026-09-04 09:40	USO	USO261023P00132000	put	132.0000	2026-10-23	5.1500	4.0000	5.2500	138.5000	34504.00	33994.00	510.00	67	17	67	0	0	0.420732640506002	0.424377327417111	true	false	false	true
c6746b1b-d90e-4a63-b6a8-a4692f1fe551	2026-09-04 09:39	2026-09-04 09:39	2026-09-04 09:39	USO	USO260925P00136000	put	136.0000	2026-09-25	3.8000	3.3000	3.8000	138.8050	40260.00	40260.00	0.00	106	22	106	126	0.841269841269841	0.396509819684066	0.396509819684066	true	false	false	true
f3ce30f1-48df-40fd-9532-bc79cec5c753	2026-09-03 14:09	2026-09-03 14:09	2026-09-03 14:09	USO	USO280121C00187000	call	187.0000	2028-01-21	14.2600	14.1500	14.7500	141.2301	71308.00	0.00	71308.00	50	11	50	25	2	0.393644700739776	0.393644700739776	false	false	false	true
e6d476d7-3c61-433d-acde-45ff4ee117b6	2026-09-03 13:39	2026-09-03 13:38	2026-09-03 13:38	USO	USO280121P00142000	put	142.0000	2028-01-21	23.5100	22.9000	24.8000	141.8300	11757.00	4702.00	7055.00	5	5	59	19	3.10526315789474	0.415886332122595	0.415726924460661	false	false	false	true
43d3a088-8d09-4592-9a62-2a5706bdb712	2026-09-03 12:56	2026-09-03 12:56	2026-09-03 12:56	USO	USO280317C00300000	call	300.0000	2028-03-17	4.8800	4.8000	5.5000	141.6750	12200.00	0.00	12200.00	25	5	51	257	0.198443579766537	0.434522391081342	0.43210919665262	false	false	false	true
250ee265-fcc3-4113-9d4e-f8143dd3e520	2026-09-03 11:43	2026-09-03 11:43	2026-09-03 11:43	USO	USO260911C00142000	call	142.0000	2026-09-11	3.3500	3.2500	4.0000	141.8700	35179.00	0.00	35179.00	105	5	143	1167	0.122536418166238	0.401777360615901	0.401777360615901	false	false	false	true
5d24878b-568b-4058-bbe5-b586e449d004	2026-09-03 11:41	2026-09-03 11:41	2026-09-03 11:41	USO	USO261218C00150000	call	150.0000	2026-12-18	11.2100	11.0000	11.4500	141.9900	17936.00	2246.00	15690.00	16	9	212	5180	0.0409266409266409	0.456422095586827	0.456422095586827	false	false	false	true
9f0ce3c4-a436-479a-9f04-aae148e255b4	2026-09-03 11:12	2026-09-03 11:12	2026-09-03 11:12	USO	USO261218P00140000	put	140.0000	2026-12-18	11.7400	11.6500	12.0500	143.2100	23478.00	0.00	23478.00	20	5	452	1595	0.283385579937304	0.459909958060576	0.462932324660736	false	false	false	true
fb8c87de-dbc5-483e-bc4f-bae9ee4a7258	2026-09-03 10:58	2026-09-03 10:58	2026-09-03 10:58	USO	USO260918C00140000	call	140.0000	2026-09-18	6.4700	6.4500	6.7000	142.9000	19412.00	0.00	19412.00	30	5	775	6953	0.111462677980728	0.416539850220113	0.416539850220113	false	false	false	true
402d388b-b52d-41e2-8f54-e9d5d6943656	2026-09-03 10:56	2026-09-03 10:56	2026-09-03 10:56	USO	USO260904C00137000	call	137.0000	2026-09-04	6.0000	5.6000	6.0000	142.6950	368357.00	368357.00	0.00	614	23	668	403	1.6575682382134	0.666630967316154	0.666630967316154	false	false	false	true
22febfd9-1c0e-48dd-be38-3a7ff79ebc0b	2026-09-03 10:34	2026-09-03 10:34	2026-09-03 10:34	USO	USO261218P00120000	put	120.0000	2026-12-18	4.0000	4.0000	4.2500	143.1950	24009.00	0.00	24009.00	60	11	1026	3082	0.332900713822193	0.451913170413653	0.451913170413653	false	false	false	true
a540145e-19ba-4abe-8523-309932fc2e53	2026-09-02 15:54	2026-09-02 15:54	2026-09-02 15:54	USO	USO281215C00169000	call	169.0000	2028-12-15	25.3600	25.2500	26.6000	141.1650	27900.00	17770.00	10130.00	11	7	19	24	0.791666666666667	0.35257493679972	0.351392909225592	true	false	false	true
b638e147-d546-4afb-b4f2-84404c59e2c7	2026-09-02 15:44	2026-09-02 15:44	2026-09-02 15:44	USO	USO270115C00155000	call	155.0000	2027-01-15	11.2500	10.8000	11.2500	141.4250	52853.00	52853.00	0.00	47	8	92	248	0.370967741935484	0.457912923442792	0.457912923442792	true	false	false	true
6287ff7d-8bea-4fa1-8231-a55d07dab871	2026-09-02 15:26	2026-09-02 15:26	2026-09-02 15:26	USO	USO260902C00132000	call	132.0000	2026-09-02	9.3700	9.3500	9.6500	141.3900	18744.00	0.00	18744.00	20	8	86	1616	0.0532178217821782	6.25560971629206	6.25560971629206	false	false	false	true
4e726fd9-cb1a-4a87-9750-a8eb5082e766	2026-09-02 14:30	2026-09-02 14:30	2026-09-02 14:30	USO	USO280616C00225000	call	225.0000	2028-06-16	10.6000	9.7500	10.9000	141.3899	56195.00	55135.00	1060.00	53	10	518	73	7.0958904109589	0.375651833616468	0.373375630862932	false	false	false	true
b1c49c35-5545-4232-b69e-53f65ecc9171	2026-09-02 14:27	2026-09-02 14:27	2026-09-02 14:27	USO	USO280616C00225000	call	225.0000	2028-06-16	10.8000	9.7500	11.0000	141.6334	166305.00	165245.00	1060.00	154	7	463	73	6.34246575342466	0.376047036270276	0.375292175407153	false	false	false	true
af5edaa6-bcef-4151-b331-801a962df12f	2026-09-02 14:00	2026-09-02 14:00	2026-09-02 14:00	USO	USO270917C00182000	call	182.0000	2027-09-17	12.5900	12.5500	13.2000	141.4300	57935.00	1260.00	52895.00	46	14	100	15	6.66666666666667	0.403463609674769	0.402556056576965	false	false	false	true
39e5cd68-a5d5-49f7-8073-487c734800dc	2026-09-02 11:59	2026-09-02 11:59	2026-09-02 11:59	USO	USO281215C00166000	call	166.0000	2028-12-15	25.9000	25.9000	27.4000	140.8900	69936.00	0.00	69936.00	27	5	166	64	2.59375	0.349339915017793	0.349339915017793	false	false	false	true
1afa5755-4dde-4a3d-87d8-3c49dfb9f788	2026-09-02 11:58	2026-09-02 11:58	2026-09-02 11:58	USO	USO280616C00162000	call	162.0000	2028-06-16	23.4500	20.5000	23.5000	141.0300	136004.00	136004.00	0.00	58	19	58	15	3.86666666666667	0.359236891102982	0.359236891102982	false	false	false	true
53098c54-aaa5-42bc-a9a3-c66923d79678	2026-09-02 11:30	2026-09-02 11:30	2026-09-02 11:30	USO	USO270416C00130000	call	130.0000	2027-04-16	24.9200	24.3500	24.9500	140.9700	161954.00	161954.00	0.00	65	6	65	1	65	0.402363256139606	0.401596567031879	true	false	false	true
158cd372-b7fa-4311-a952-32d8fd7cf42d	2026-09-02 10:11	2026-09-02 10:10	2026-09-02 10:10	USO	USO261016C00155000	call	155.0000	2026-10-16	4.2200	4.1000	4.3500	139.4200	42250.00	21000.00	21250.00	100	9	223	2451	0.0909832721338229	0.490951254201824	0.487410631289511	false	false	false	true
23c2a10a-1806-4372-a370-e42e123b97e9	2026-09-02 09:53	2026-09-02 09:53	2026-09-02 09:53	USO	USO261120C00140000	call	140.0000	2026-11-20	11.9000	10.1500	11.9500	139.3600	38070.00	19105.00	18965.00	32	8	33	0	0	0.453160270500005	0.451212313672023	true	false	false	true
e522a495-9288-47d5-8e9a-f6d43e842336	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	USO	USO260916P00147000	put	147.0000	2026-09-16	9.6300	9.5500	10.0000	139.3000	19265.00	0.00	19265.00	20	5	20	0	0	0.457527119077952	0.446858690700109	true	false	false	true
cad27b98-8426-4276-90bd-9d0a4ebcb1df	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	USO	USO260916P00145000	put	145.0000	2026-09-16	8.2100	8.2000	8.6000	139.2400	13130.00	0.00	13130.00	16	5	16	0	0	0.450357880696582	0.445376238095337	true	false	false	true
5751e2fc-ba65-4de6-8a0a-d1dc9ab55007	2026-09-01 15:14	2026-09-01 15:13	2026-09-01 15:13	USO	USO261016P00120000	put	120.0000	2026-10-16	1.6100	1.6000	1.6500	140.5600	122544.00	0.00	122544.00	762	11	4724	19074	0.247666981230995	0.45059874354043	0.449658469124077	false	false	false	true
31277651-50f0-4828-b307-82c4f26754c2	2026-09-01 14:57	2026-09-01 14:57	2026-09-01 14:57	USO	USO261218P00130000	put	130.0000	2026-12-18	7.6900	7.5000	8.2000	140.7434	25385.00	0.00	25385.00	33	12	474	3421	0.138555977784274	0.454551438401971	0.452703147107002	true	false	false	true
ef360225-fca6-4580-a892-6a4e4a17299b	2026-09-01 14:47	2026-09-01 14:47	2026-09-01 14:47	USO	USO261016C00153000	call	153.0000	2026-10-16	5.3000	4.9500	5.4500	140.7000	42428.00	42428.00	0.00	80	6	100	184	0.543478260869565	0.490819489483076	0.490819489483076	false	false	false	true
7b81fcfd-fd4c-4d63-9fb7-9b5fb9a4c7ba	2026-09-01 14:32	2026-09-01 14:32	2026-09-01 14:32	USO	USO280121C00230000	call	230.0000	2028-01-21	7.3000	7.0500	7.3250	140.5200	27008.00	27008.00	0.00	37	25	299	435	0.68735632183908	0.389194462594565	0.389101630376038	false	false	false	true
b4ce693a-9e92-4a48-bbec-dd447554aa99	2026-09-01 14:16	2026-09-01 14:16	2026-09-01 14:16	USO	USO260904C00155000	call	155.0000	2026-09-04	0.1500	0.0700	0.1500	139.9050	14925.00	14925.00	0.00	1000	29	1261	11485	0.109795385285155	0.653208541634204	0.653208541634204	true	false	false	true
048ecf08-6322-4905-b2fb-9126a16116b2	2026-09-01 14:01	2026-09-01 14:01	2026-09-01 14:01	USO	USO270319P00130000	put	130.0000	2027-03-19	11.9800	11.5000	12.0500	139.4600	100670.00	100670.00	0.00	84	11	117	768	0.15234375	0.449355412968736	0.446666271475979	true	false	false	true
75242a2a-9f6f-43ac-acca-f3a2d2a85d46	2026-09-01 13:37	2026-09-01 13:36	2026-09-01 13:36	USO	USO280317P00150000	put	150.0000	2028-03-17	29.0600	29.0500	29.3500	139.8300	316715.00	0.00	316715.00	109	29	672	172	3.90697674418605	0.420775730237148	0.420775730237148	false	false	false	true
9f24ffd5-d8d7-4c64-9252-8f4863d5fedb	2026-09-01 13:24	2026-09-01 13:24	2026-09-01 13:24	USO	USO260904C00143000	call	143.0000	2026-09-04	1.1700	0.8100	1.2100	139.2750	31762.00	29431.00	2331.00	271	38	401	132	3.03787878787879	0.520060024592397	0.497058586853742	false	false	false	true
4bf5c173-174a-4c9c-9dcf-df4e8462d796	2026-09-01 13:00	2026-09-01 13:00	2026-09-01 13:00	USO	USO261009P00150000	put	150.0000	2026-10-09	14.9800	14.9500	15.3000	139.4300	19470.00	0.00	19470.00	13	13	16	0	0	0.488996710943109	0.490977703414357	true	false	false	true
26a3a0d7-fea1-482d-8c8f-e30b56741270	2026-09-01 12:47	2026-09-01 12:47	2026-09-01 12:47	USO	USO260909C00145000	call	145.0000	2026-09-09	1.5000	1.3200	1.6900	138.8299	60973.00	53993.00	6980.00	407	8	2503	160	15.64375	0.451179279463953	0.436433710911309	true	false	false	true
acf8f6e6-bef4-4d72-91d7-aecec166853a	2026-09-01 12:44	2026-09-01 12:44	2026-09-01 12:44	USO	USO260918P00120000	put	120.0000	2026-09-18	0.4500	0.4000	0.4500	139.0846	13497.00	13497.00	0.00	300	17	780	5547	0.140616549486209	0.480972788223899	0.480972788223899	true	false	false	true
ad8a6d99-c540-4c53-acae-4e6b044cb530	2026-09-01 12:44	2026-09-01 12:44	2026-09-01 12:44	USO	USO261016P00120000	put	120.0000	2026-10-16	1.8000	1.7500	1.8700	139.1150	14388.00	10434.00	3954.00	80	20	765	19074	0.0401069518716578	0.449388577660185	0.448500976329133	true	false	false	true
94d5b6dc-c476-4a72-9ded-3c558ed4b8b7	2026-09-01 12:27	2026-09-01 12:26	2026-09-01 12:26	USO	USO260904C00135000	call	135.0000	2026-09-04	5.5000	5.2000	5.5000	139.4400	44525.00	44525.00	0.00	81	5	1283	5308	0.241710625470987	0.540981547146881	0.540981547146881	false	false	false	true
da0bb8c9-b996-4280-b82b-bcba144e2834	2026-09-01 11:22	2026-09-01 11:22	2026-09-01 11:22	USO	USO261016C00145000	call	145.0000	2026-10-16	5.7500	5.4500	5.7500	137.1100	431186.00	431186.00	0.00	750	45	838	9463	0.0885554263975483	0.45156422337413	0.45156422337413	true	false	false	true
82ff7a0e-4cd2-4f4f-b2dc-f6c6b80d9cf8	2026-09-01 09:41	2026-09-01 09:41	2026-09-01 09:41	USO	USO260902C00139000	call	139.0000	2026-09-02	0.8100	0.8100	0.9200	137.5100	15440.00	0.00	15440.00	190	5	499	193	2.58549222797927	0.513500534315733	0.494701937053265	true	false	false	true
8899f77f-28ee-4f56-9544-1818e73c5368	2026-09-01 09:40	2026-09-01 09:40	2026-09-01 09:40	USO	USO260918C00150000	call	150.0000	2026-09-18	1.6000	1.5100	1.6500	137.4000	46716.00	45759.00	797.00	292	20	785	9706	0.0808778075417268	0.469253847703763	0.469253847703763	true	false	false	true
d04f57fb-1bf9-4b97-a4db-6aa8e1bb9a91	2026-08-31 14:10	2026-08-31 14:10	2026-08-31 14:10	USO	USO260918C00130000	call	130.0000	2026-09-18	6.6100	6.4000	6.7000	133.0000	66081.00	66081.00	0.00	100	6	528	4100	0.128780487804878	0.413978051242271	0.404133602291944	false	false	false	true
56804575-e5c5-4232-b3d5-6f4acb039f1f	2026-08-31 11:05	2026-08-31 11:05	2026-08-31 11:05	USO	USO260918C00128000	call	128.0000	2026-09-18	7.4900	7.3000	7.6000	132.5846	74878.00	34200.00	40678.00	100	5	229	444	0.515765765765766	0.416934172306535	0.397100788273102	false	false	false	true
92980a3e-1581-41ab-b5b5-2c4ba9f0e1f5	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	USO	USO260918P00120000	put	120.0000	2026-09-18	0.7700	0.7300	0.8300	133.3201	11508.00	0.00	8232.00	150	5	570	5409	0.105379922351636	0.428017532343094	0.428017532343094	false	false	false	true
68f9085d-f629-47c5-beff-a3aa1792716c	2026-08-28 11:15	2026-08-28 11:15	2026-08-28 11:15	USO	USO261016C00145000	call	145.0000	2026-10-16	3.6100	3.4500	3.7500	129.2400	14440.00	8680.00	0.00	40	5	121	9435	0.0128245892951775	0.464049756161068	0.464049756161068	false	false	false	true
56f90aa4-9b96-4762-b8fa-765b66f33abc	2026-08-28 11:15	2026-08-28 11:15	2026-08-28 11:15	USO	USO261016C00140000	call	140.0000	2026-10-16	4.7000	4.5000	4.8500	129.2400	46984.00	46984.00	0.00	100	5	215	5378	0.0399776868724433	0.451709138267504	0.451709138267504	false	false	false	true
2332a4e5-3381-4407-a946-200d748fdb54	2026-08-27 15:18	2026-08-27 15:18	2026-08-27 15:18	USO	USO261016C00145000	call	145.0000	2026-10-16	4.3000	4.1000	4.3000	130.0000	322433.00	322433.00	0.00	750	61	805	8936	0.0900850492390331	0.476230090828401	0.475864048785064	true	false	false	true
bf625452-337f-41b6-8353-57e29258ae5d	2026-08-27 15:04	2026-08-27 15:04	2026-08-27 15:04	USO	USO261218C00160000	call	160.0000	2026-12-18	5.2400	4.6500	5.6500	130.2450	15732.00	15732.00	0.00	30	8	33	1113	0.0296495956873315	0.482184277068227	0.482184277068227	false	false	false	true
a2012a52-4cf8-4d7a-afce-826c0101a879	2026-08-27 13:59	2026-08-27 13:59	2026-08-27 13:59	USO	USO260904C00126000	call	126.0000	2026-09-04	6.0000	5.9500	6.3500	130.5100	18601.00	600.00	18001.00	31	15	45	120	0.375	0.420772622719629	0.419210009607493	true	false	false	true