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:endpoint = /api/option-trades/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	expiry

db08911e-25b8-4509-86f6-0d922f773fae	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	USO	USO261002P00145000	put	145.0000	2026-10-02	1.8800	1.8200	1.9600	150.2560	44368.00	32712.00	11656.00	236	11	3823	4146	0.922093584177521	0.647217558414691	0.647217558414691	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-28T16:25:44.498264Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
f3bdffb4-c4b7-4be7-acfa-f43219a01a41	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	USO	USO261002P00145000	put	145.0000	2026-10-02	1.8800	1.8700	1.9600	150.4872	30644.00	8084.00	22560.00	163	17	3286	4146	0.792571152918476	0.659513155042028	0.659513155042028	false	false	false	true
8241e9c8-b41e-4b3b-921e-bb251641f9c4	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	USO	USO261002P00145000	put	145.0000	2026-10-02	1.8800	1.8500	1.8800	150.4872	13348.00	13348.00	0.00	71	6	3357	4146	0.809696092619392	0.659513155042028	0.659513155042028	false	false	false	true
6f872d7f-809d-448d-98ff-b7fdab4c47c1	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	USO	USO261002P00145000	put	145.0000	2026-10-02	1.8800	1.8200	1.8800	150.3500	16356.00	16356.00	0.00	87	6	3508	4146	0.846116739025567	0.652230920445306	0.652230920445306	false	false	false	true
3bad1840-d655-492b-bb12-6bea3dd22a02	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	USO	USO261030C00153000	call	153.0000	2026-10-30	8.1000	8.1000	8.5000	150.3500	21870.00	0.00	21870.00	27	12	64	605	0.105785123966942	0.509669481531871	0.509669481531871	false	false	false	true
e22cefa2-0dee-4380-8e26-262059b5d5fb	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	USO	USO261016P00145000	put	145.0000	2026-10-16	4.6500	4.5500	4.7000	150.4900	14880.00	465.00	14415.00	32	14	201	4786	0.0419974926870038	0.547172773006691	0.54887461008755	true	false	false	true
1f02b457-f63f-4164-886d-e421c482d651	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	USO	USO261030P00144000	put	144.0000	2026-10-30	6.2000	6.0500	6.4000	150.3865	10540.00	0.00	10540.00	17	6	17	50	0.34	0.531733579030454	0.533581868092859	false	false	false	true
add64d1e-2d84-4838-b9bf-ff1ad94fcfb9	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	USO	USO261030P00149500	put	149.5000	2026-10-30	8.7000	8.7000	8.9000	150.2766	11310.00	0.00	11310.00	13	6	15	55	0.272727272727273	0.529492632653055	0.529492632653055	false	false	false	true
ab858645-4883-4ce5-9d80-1ac28946cd15	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	USO	USO261030P00149000	put	149.0000	2026-10-30	8.4500	8.4500	8.6500	150.2766	11830.00	0.00	11830.00	14	6	20	146	0.136986301369863	0.529566903383307	0.529566903383307	false	false	false	true
5d655e3b-0512-4d24-bf51-c7231b0e0e00	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	USO	USO261030P00150000	put	150.0000	2026-10-30	8.9500	8.9500	9.1500	150.2766	11635.00	0.00	11635.00	13	6	167	616	0.271103896103896	0.529178476688714	0.529178476688714	false	false	false	true
f35dd7f9-6757-46f0-a98b-8a23d2004450	2026-09-28 12:23	2026-09-28 12:22	2026-09-28 12:22	USO	USO261016P00139000	put	139.0000	2026-10-16	2.8200	2.8200	2.9900	150.2766	10152.00	0.00	10152.00	36	14	218	3108	0.0701415701415701	0.56018253657397	0.56018253657397	false	false	false	true
47fb71b5-41c2-4b03-9416-326ea6ff444b	2026-09-28 12:23	2026-09-28 12:22	2026-09-28 12:22	USO	USO261007C00152000	call	152.0000	2026-10-07	4.5200	4.5000	6.4000	150.2766	35681.00	0.00	35681.00	79	7	125	6	20.8333333333333	0.558004300789684	0.558004300789684	false	false	false	true
c3c9fd22-023a-43ed-ae45-0438bd565a4a	2026-09-28 12:22	2026-09-28 12:21	2026-09-28 12:21	USO	USO261106P00140000	put	140.0000	2026-11-06	5.5000	5.3000	5.9500	150.3100	15400.00	550.00	14850.00	28	9	38	31	1.2258064516129	0.532182647193184	0.532182647193184	false	false	false	true
b2e5dafc-f700-43cf-a782-36748ac616f7	2026-09-28 12:21	2026-09-28 12:21	2026-09-28 12:21	USO	USO261023C00162000	call	162.0000	2026-10-23	4.0000	3.7500	4.0500	150.3100	11200.00	10800.00	0.00	28	14	80	175	0.457142857142857	0.520224818938397	0.520224818938397	false	false	false	true
27bf7093-9dab-45a5-8e6f-fb757ea656ec	2026-09-28 12:21	2026-09-28 12:21	2026-09-28 12:21	USO	USO261120P00142000	put	142.0000	2026-11-20	7.5500	7.5500	7.8000	150.3400	20385.00	0.00	20385.00	27	13	38	146	0.26027397260274	0.523453216302448	0.523453216302448	true	false	false	true
f0db1c1f-137e-4464-a3ce-95057f6f01f8	2026-09-28 12:21	2026-09-28 12:21	2026-09-28 12:21	USO	USO261120P00134000	put	134.0000	2026-11-20	4.7000	4.7000	4.9500	150.3400	14570.00	0.00	14570.00	31	8	33	81	0.407407407407407	0.523955781074846	0.523955781074846	false	false	false	true
ff42ce14-ef76-4568-862c-64082714cb47	2026-09-28 12:21	2026-09-28 12:21	2026-09-28 12:21	USO	USO260930P00155000	put	155.0000	2026-09-30	6.0000	5.2500	6.3500	150.1250	12000.00	12000.00	0.00	20	8	75	76	0.986842105263158	0.660246562157658	0.660246562157658	false	false	false	true
7ddbd8c0-9ce7-403b-91bd-5fbf524c2756	2026-09-28 12:21	2026-09-28 12:21	2026-09-28 12:21	USO	USO261106C00163000	call	163.0000	2026-11-06	5.6500	5.3000	5.6500	150.0700	67235.00	67235.00	0.00	119	8	126	0	0	0.524226037540354	0.524226037540354	false	false	false	true
be4eba35-0d40-422c-81d5-cfc28c70fe73	2026-09-28 12:20	2026-09-28 12:20	2026-09-28 12:20	USO	USO261120C00173000	call	173.0000	2026-11-20	4.8500	4.7000	4.9000	150.4700	61110.00	60625.00	485.00	126	7	160	124	1.29032258064516	0.525153863521041	0.525153863521041	false	false	false	true
dc1290cb-e06d-4a6b-91b7-b05244f476ca	2026-09-28 12:20	2026-09-28 12:20	2026-09-28 12:20	USO	USO260930P00150000	put	150.0000	2026-09-30	2.5500	2.4700	2.5500	150.8134	25500.00	25500.00	0.00	100	8	1351	1197	1.12865497076023	0.66521140840735	0.66521140840735	true	false	false	true
2c1c516e-8edc-4e08-9d7c-5f6694436def	2026-09-28 12:20	2026-09-28 12:20	2026-09-28 12:20	USO	USO260930P00150000	put	150.0000	2026-09-30	2.4000	2.3200	2.4400	150.9700	33594.00	15360.00	18234.00	140	22	1135	1197	0.948203842940685	0.646803371845537	0.646803371845537	true	false	false	true
902bf032-270f-4308-926b-1b5f737f8200	2026-09-28 12:19	2026-09-28 12:19	2026-09-28 12:19	USO	USO261002C00152000	call	152.0000	2026-10-02	3.6300	3.4000	4.6500	151.3050	27192.00	0.00	27192.00	75	10	564	464	1.21551724137931	0.62485665421066	0.62485665421066	false	false	false	true
5ef5920b-8789-4eba-ae88-623d5925f544	2026-09-28 12:18	2026-09-28 12:18	2026-09-28 12:18	USO	USO260930C00153000	call	153.0000	2026-09-30	1.9700	1.9700	2.0300	151.2500	11820.00	0.00	11820.00	60	11	1138	746	1.5254691689008	0.610727433395718	0.610727433395718	false	false	false	true
4afd0667-1127-4ef8-a1ba-33ebbb66927a	2026-09-28 12:11	2026-09-28 12:10	2026-09-28 12:10	USO	USO261016C00170000	call	170.0000	2026-10-16	1.7500	1.6700	1.7600	151.8600	13125.00	12075.00	0.00	75	6	298	8333	0.0357614304572183	0.529511730642261	0.529511730642261	false	false	false	true
5d2ab978-d403-4e42-ba1b-a67041bc1a45	2026-09-28 12:04	2026-09-28 12:04	2026-09-28 12:04	USO	USO261002P00135000	put	135.0000	2026-10-02	0.2700	0.2500	0.2800	152.8200	15714.00	15660.00	0.00	582	13	2781	5723	0.485933950725144	0.749163103109427	0.749163103109427	false	false	false	true
3b6373aa-e945-4cf6-925f-01bf7e64916e	2026-09-28 11:55	2026-09-28 11:55	2026-09-28 11:55	USO	USO261016P00130000	put	130.0000	2026-10-16	0.8600	0.8200	0.8600	153.2599	13330.00	13330.00	0.00	155	26	904	11215	0.080606330806955	0.58417190127154	0.58417190127154	true	false	false	true
70988564-9a4a-42c8-830c-c1cb4b6cc722	2026-09-28 11:55	2026-09-28 11:54	2026-09-28 11:54	USO	USO261106C00164000	call	164.0000	2026-11-06	6.4500	6.4500	6.6500	153.4600	10965.00	0.00	10965.00	17	6	17	0	0	0.51608399957722	0.51608399957722	true	false	false	true
07e17ad5-5626-4725-b956-b20175867031	2026-09-28 11:42	2026-09-28 11:42	2026-09-28 11:42	USO	USO261106P00151000	put	151.0000	2026-11-06	8.9500	8.7000	9.1500	153.5800	18795.00	17900.00	895.00	21	10	30	29	1.03448275862069	0.530464373380577	0.530464373380577	true	false	false	true
fd74a468-bc22-458c-9b20-df05f336db8c	2026-09-28 11:39	2026-09-28 11:39	2026-09-28 11:39	USO	USO261120P00140000	put	140.0000	2026-11-20	5.7000	5.5500	5.7500	153.8800	18810.00	5130.00	13680.00	33	5	712	4059	0.175412663217541	0.522272336650979	0.522513061790159	false	false	false	true
765920df-7338-4b10-b9c3-a708a3fbcd66	2026-09-28 11:39	2026-09-28 11:39	2026-09-28 11:39	USO	USO261120P00140000	put	140.0000	2026-11-20	5.7000	5.6500	5.8000	153.8200	16530.00	0.00	12540.00	29	5	679	4059	0.167282581916728	0.521672965550138	0.521672965550138	false	false	false	true
01da1186-9ef0-4050-90c5-4c668e2d3c5e	2026-09-28 11:36	2026-09-28 11:35	2026-09-28 11:35	USO	USO261002P00145000	put	145.0000	2026-10-02	1.1800	1.1400	1.1800	153.5300	21594.00	21594.00	0.00	183	7	2539	4146	0.612397491558128	0.663062906121665	0.663062906121665	false	false	false	true
fdd9c7c4-516b-4d35-9030-f6ae2c819092	2026-09-28 11:26	2026-09-28 11:26	2026-09-28 11:26	USO	USO261002P00135000	put	135.0000	2026-10-02	0.2600	0.2500	0.2600	153.2300	13000.00	13000.00	0.00	500	26	1707	5723	0.29827013803949	0.755650518788669	0.755650518788669	true	false	false	true
72530d39-deab-4c19-8d48-c98d595936c1	2026-09-28 11:25	2026-09-28 11:25	2026-09-28 11:25	USO	USO261009P00130000	put	130.0000	2026-10-09	0.4500	0.4200	0.4500	153.0000	18605.00	18605.00	0.00	414	6	720	814	0.884520884520885	0.640622727003046	0.640622727003046	false	false	false	true
800cf09e-e02e-41cb-b37e-47cde01447b8	2026-09-28 11:22	2026-09-28 11:22	2026-09-28 11:22	USO	USO260930C00150000	call	150.0000	2026-09-30	4.8900	4.6500	5.3500	153.0000	24440.00	0.00	24440.00	50	5	255	953	0.267576075550892	0.648743847133223	0.648743847133223	false	false	false	true
fb52af3c-78d1-4900-98a1-f3b52ec3a9f1	2026-09-28 11:16	2026-09-28 11:16	2026-09-28 11:16	USO	USO261002P00138000	put	138.0000	2026-10-02	0.4200	0.3600	0.4200	153.0000	16761.00	11301.00	0.00	400	10	428	915	0.46775956284153	0.731934248463759	0.731934248463759	false	false	false	true
e9c82167-32eb-4fe0-bac9-ab776c98d38f	2026-09-28 11:12	2026-09-28 11:12	2026-09-28 11:12	USO	USO261120C00160000	call	160.0000	2026-11-20	9.4000	9.4000	9.6000	153.4900	19740.00	0.00	19740.00	21	7	67	1950	0.0343589743589744	0.504534037092662	0.504534037092662	false	false	false	true
248cb163-365e-4b9c-8850-2dd9b405553e	2026-09-28 11:04	2026-09-28 11:04	2026-09-28 11:04	USO	USO270115P00140000	put	140.0000	2027-01-15	9.0500	8.7500	9.0500	153.8500	36200.00	36200.00	0.00	40	12	69	2923	0.023605884365378	0.493344796658118	0.493344796658118	false	false	false	true
052b18f2-8c08-4177-a090-912a9fedcc39	2026-09-28 11:02	2026-09-28 11:02	2026-09-28 11:02	USO	USO261016C00150000	call	150.0000	2026-10-16	9.2900	9.2500	9.5000	153.7000	35286.00	0.00	35286.00	38	5	136	6295	0.021604447974583	0.529560314700996	0.529560314700996	false	false	false	true
7916fae7-327d-406c-ad65-4a12b3d20bb4	2026-09-28 11:00	2026-09-28 11:00	2026-09-28 11:00	USO	USO261002P00145000	put	145.0000	2026-10-02	1.1600	1.1200	1.1600	153.7900	10545.00	9280.00	1265.00	91	17	2012	4146	0.485287023637241	0.669851845255594	0.66755449285389	true	false	false	true
1490f76a-711d-4682-b446-5b6f06772772	2026-09-28 11:00	2026-09-28 11:00	2026-09-28 11:00	USO	USO261002P00145000	put	145.0000	2026-10-02	1.1700	1.1200	1.2400	153.7900	13749.00	4176.00	5946.00	118	11	2130	4146	0.513748191027496	0.669851845255594	0.672143586963228	true	false	false	true
887f5be4-4ebd-4634-928e-fd193784a36d	2026-09-28 11:00	2026-09-28 11:00	2026-09-28 11:00	USO	USO261002C00155000	call	155.0000	2026-10-02	3.4000	3.4000	3.4500	153.8500	13260.00	0.00	13260.00	39	6	662	2980	0.222147651006711	0.607588472685751	0.607588472685751	false	false	false	true
2669adc3-9cb5-4d92-a4fd-fd4b22d73b5c	2026-09-28 10:57	2026-09-28 10:57	2026-09-28 10:57	USO	USO270115P00120000	put	120.0000	2027-01-15	3.4000	3.3500	3.4500	153.9395	25160.00	24820.00	340.00	74	13	191	6166	0.0309763217645151	0.50519368750487	0.50519368750487	false	false	false	true
300f2107-f244-4b4d-99ae-19a97d6c8ec1	2026-09-28 10:57	2026-09-28 10:57	2026-09-28 10:57	USO	USO270115P00120000	put	120.0000	2027-01-15	3.4000	3.2500	3.5000	153.8550	34340.00	32640.00	1700.00	101	19	117	6166	0.0189750243269543	0.504563672648562	0.504563672648562	false	false	false	true
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
119e4a33-a94b-459b-a8bf-01302b5c7d3c	2026-09-28 10:52	2026-09-28 10:52	2026-09-28 10:52	USO	USO270319P00110000	put	110.0000	2027-03-19	3.5800	3.1000	3.8500	152.8900	35788.00	35788.00	0.00	100	8	125	3635	0.0343878954607978	0.503912428074414	0.503912428074414	false	false	false	true
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
9546c62a-7d03-4534-8141-bfb937180532	2026-09-28 10:48	2026-09-28 10:48	2026-09-28 10:48	USO	USO261002P00145000	put	145.0000	2026-10-02	1.3700	1.2800	1.3700	152.0000	53933.00	53933.00	0.00	395	6	1714	4146	0.413410516160154	0.67536058320162	0.67536058320162	false	false	false	true