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 rows

Sources in this table

uw_flow_alerts728,802 rows

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

8ad24f95-6c69-4450-8864-01749c4c3e18	2026-09-08 15:50	2026-09-08 15:50	2026-09-08 15:50	USO	USO260909C00146000	call	146.0000	2026-09-09	1.4300	1.2400	1.4500	145.8350	69008.00	68868.00	140.00	484	11	7151	114	62.7280701754386	0.483698429450971	0.483698429450971	true	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-09T13:30:57.501605Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
0a7d26ff-70db-4cff-a486-bbed046d7454	2026-09-08 15:50	2026-09-08 15:50	2026-09-08 15:50	USO	USO270416P00101000	put	101.0000	2027-04-16	3.0800	2.9000	4.8500	145.7900	19680.00	9615.00	10065.00	64	7	64	0	0	0.466399579176562	0.466399579176562	false	false	false	true
24923612-709c-471a-af27-4a871d0f4a33	2026-09-08 14:49	2026-09-08 14:48	2026-09-08 14:48	USO	USO260923C00150000	call	150.0000	2026-09-23	3.3000	2.7500	3.5000	145.6700	16490.00	16490.00	0.00	50	15	81	0	0	0.421645606035483	0.426059203118467	true	false	false	true
00867e77-be48-42ee-a072-6c7d82be8323	2026-09-08 14:49	2026-09-08 14:48	2026-09-08 14:48	USO	USO261002C00155000	call	155.0000	2026-10-02	3.4400	2.5900	3.4500	145.6700	13775.00	12755.00	1020.00	40	15	89	486	0.183127572016461	0.454795766135581	0.454795766135581	true	false	false	true
7eae5fe6-b17c-4916-9845-3880c7f8136f	2026-09-08 14:48	2026-09-08 14:48	2026-09-08 14:48	USO	USO260909C00147000	call	147.0000	2026-09-09	0.7400	0.6900	0.7400	145.3700	11540.00	11467.00	73.00	156	14	1348	288	4.68055555555556	0.455651945801965	0.459296193525927	true	false	false	true
f495ac15-ff96-43de-8f50-db7c52d80850	2026-09-08 14:34	2026-09-08 14:34	2026-09-08 14:34	USO	USO260911C00137000	call	137.0000	2026-09-11	7.7000	6.9000	8.5000	144.3862	128653.00	47740.00	49343.00	167	10	173	357	0.484593837535014	0.4531885111442	0.466358483970303	false	false	false	true
7b9888b8-0122-44d1-ab04-5f6ceb3f496d	2026-09-08 13:51	2026-09-08 13:51	2026-09-08 13:51	USO	USO261218C00130000	call	130.0000	2026-12-18	21.1600	20.7000	21.2000	143.5900	82515.00	82515.00	0.00	39	20	48	1475	0.0325423728813559	0.428419492348429	0.430408540860533	false	false	false	true
6cc26632-7005-453a-8b8b-8d92415a2d0f	2026-09-08 13:49	2026-09-08 13:49	2026-09-08 13:49	USO	USO280616P00140000	put	140.0000	2028-06-16	24.1000	23.2000	24.2000	143.5600	12050.00	7225.00	4825.00	5	5	78	365	0.213698630136986	0.42707404930263	0.428535143659507	true	false	false	true
aca40d66-e7af-45be-b2f9-690b142e708d	2026-09-08 13:34	2026-09-08 13:34	2026-09-08 13:34	USO	USO261120C00170000	call	170.0000	2026-11-20	4.5500	4.4500	4.7500	143.3100	10468.00	0.00	10468.00	23	5	33	18	1.83333333333333	0.492281859119032	0.492281859119032	false	false	false	true
768f7bad-7341-4855-9af9-acd4eb552d98	2026-09-08 11:33	2026-09-08 11:33	2026-09-08 11:33	USO	USO261023P00120000	put	120.0000	2026-10-23	1.2500	1.1800	1.3300	144.2600	18711.00	0.00	18711.00	150	7	211	26	8.11538461538461	0.455389924279233	0.455389924279233	false	false	false	true
b9a63c0e-7426-4fc0-9bb7-bd4c4d0ca3dc	2026-09-08 10:33	2026-09-08 10:33	2026-09-08 10:33	USO	USO261002C00143000	call	143.0000	2026-10-02	7.4600	7.2500	7.5000	144.8500	10445.00	8210.00	1490.00	14	10	14	70	0.2	0.427661436892955	0.431100112608512	true	false	false	true
8bdb9b59-6fb6-471d-872e-74700836d693	2026-09-08 10:07	2026-09-08 10:07	2026-09-08 10:07	USO	USO261016P00119000	put	119.0000	2026-10-16	0.8300	0.7500	0.8300	144.9201	12430.00	12430.00	0.00	150	13	210	1776	0.118243243243243	0.465101573520576	0.466556723620872	false	false	false	true
1c98eddc-e8e8-42f6-87f1-5b751b0ff31b	2026-09-08 09:44	2026-09-08 09:44	2026-09-08 09:44	USO	USO261218P00130000	put	130.0000	2026-12-18	6.1900	6.1500	6.3500	145.0900	83561.00	0.00	76061.00	135	26	545	4051	0.134534682794372	0.445337033644694	0.449345737977612	false	false	false	true
24c8535f-f686-42ff-8191-b1c823e21c14	2026-09-08 09:30	2026-09-08 09:30	2026-09-08 09:30	USO	USO260909P00144000	put	144.0000	2026-09-09	1.3200	1.1200	2.3200	144.6629	14514.00	1476.00	13038.00	110	20	111	31	3.58064516129032	0.533289040999772	0.650493305953124	false	false	false	true
79b9471e-3e80-4cad-af5a-ba0a38d5da0d	2026-09-04 15:58	2026-09-04 15:58	2026-09-04 15:58	USO	USO261120C00149000	call	149.0000	2026-11-20	8.9200	7.7000	9.5000	142.0350	17848.00	17848.00	0.00	20	6	28	2	14	0.436421335461328	0.436421335461328	false	false	false	true
747bd744-2114-4a91-929e-f214a9902123	2026-09-04 14:36	2026-09-04 14:36	2026-09-04 14:36	USO	USO281215P00129000	put	129.0000	2028-12-15	20.5900	20.1000	20.8000	142.2300	109148.00	109148.00	0.00	53	5	53	142	0.373239436619718	0.413623826603446	0.416038114137979	false	false	false	true
0337ef85-5538-4d9e-8068-e28e56d3ba77	2026-09-04 13:19	2026-09-04 13:18	2026-09-04 13:18	USO	USO261218P00120000	put	120.0000	2026-12-18	4.0500	3.9500	4.0500	141.0800	41309.00	41309.00	0.00	102	7	648	4142	0.156446161274747	0.437268191104044	0.437746000563038	false	false	false	true
8156e064-215c-42d3-8254-6984f1450c33	2026-09-04 12:54	2026-09-04 12:54	2026-09-04 12:54	USO	USO260925C00147000	call	147.0000	2026-09-25	3.3800	3.0000	3.4000	141.4500	23969.00	23969.00	0.00	71	6	75	8	9.375	0.4063850783095	0.4063850783095	false	false	false	true
971cbbeb-2750-46e7-9679-f74f4c121727	2026-09-04 12:45	2026-09-04 12:44	2026-09-04 12:44	USO	USO261023P00148000	put	148.0000	2026-10-23	12.7000	12.7000	13.2500	141.1400	43186.00	0.00	41911.00	34	16	34	0	0	0.443907436743626	0.443907436743626	true	false	false	true
4a313d3a-d450-4489-8aa2-c9b323e3b104	2026-09-04 12:13	2026-09-04 12:13	2026-09-04 12:13	USO	USO270319C00120000	call	120.0000	2027-03-19	29.4600	29.1500	29.5000	141.1550	58920.00	20650.00	38270.00	20	5	20	524	0.0381679389312977	0.388281659253644	0.389936286594205	false	false	false	true
1307493b-2b81-4330-85d6-65ad6650f7c4	2026-09-04 11:04	2026-09-04 11:04	2026-09-04 11:04	USO	USO260904C00140000	call	140.0000	2026-09-04	1.0100	0.9500	1.2500	140.5800	20350.00	5200.00	15150.00	202	9	1167	1797	0.649415692821369	0.503704548806307	0.51170300479893	false	false	false	true
94ca4fbe-5e03-45b7-8105-e0d7fb3f87d2	2026-09-04 10:41	2026-09-04 10:40	2026-09-04 10:40	USO	USO260925C00155000	call	155.0000	2026-09-25	1.4800	1.1500	1.5400	140.4400	10506.00	10506.00	0.00	71	6	73	441	0.165532879818594	0.434393082420207	0.434393082420207	false	false	false	true
51973428-b0f8-4a95-8f38-f8845733d70e	2026-09-04 09:52	2026-09-04 09:52	2026-09-04 09:52	USO	USO280121C00240000	call	240.0000	2028-01-21	6.3400	4.3500	6.6000	138.3666	46944.00	46944.00	0.00	74	8	74	448	0.165178571428571	0.40170250247759	0.407410881394643	true	false	false	true
348db6cb-6e0a-4675-907b-7a74d25ec41d	2026-09-04 09:31	2026-09-04 09:31	2026-09-04 09:31	USO	USO260909P00140000	put	140.0000	2026-09-09	2.5000	2.5000	2.7100	139.9850	29752.00	251.00	29251.00	119	9	120	292	0.410958904109589	0.387048326977192	0.388579029300182	true	false	false	true
6fbf7aa4-3530-4344-9eb1-8a4ef864d676	2026-09-03 15:13	2026-09-03 15:13	2026-09-03 15:13	USO	USO261016C00185000	call	185.0000	2026-10-16	1.0200	1.0200	1.2300	141.9100	172582.00	2389.00	170090.00	1688	67	1996	590	3.38305084745763	0.532399439686974	0.533992882728327	true	false	false	true
7396860c-442e-4e1e-a546-5e20ac4e4d20	2026-09-03 11:42	2026-09-03 11:42	2026-09-03 11:42	USO	USO270319P00100000	put	100.0000	2027-03-19	2.5600	2.5100	2.7000	141.8500	17153.00	1834.00	15319.00	67	6	69	2600	0.0265384615384615	0.448686031491387	0.452501787023541	true	false	false	true
3e8a64da-5c34-4a71-9c80-4bcdf0255d96	2026-09-03 10:23	2026-09-03 10:23	2026-09-03 10:23	USO	USO261016P00120000	put	120.0000	2026-10-16	1.1600	1.1600	1.2500	143.0300	35580.00	1995.00	33585.00	306	46	518	22130	0.0234071396294623	0.443981303695238	0.445104435784171	true	false	false	true
2b66c2be-c5f1-4e6e-b89d-58afd13d2fe2	2026-09-03 09:31	2026-09-03 09:31	2026-09-03 09:31	USO	USO261218P00120000	put	120.0000	2026-12-18	4.3200	4.2000	4.3500	142.3299	48365.00	48365.00	0.00	112	24	312	3082	0.101232965606749	0.457876247781606	0.460234547710128	true	false	false	true
376c7e94-b906-4ea8-a886-ee8111251217	2026-09-02 15:18	2026-09-02 15:18	2026-09-02 15:18	USO	USO270319C00133000	call	133.0000	2027-03-19	22.5100	22.2500	22.5500	141.2850	45020.00	42770.00	2250.00	20	6	35	109	0.321100917431193	0.409443200729457	0.410762109395755	false	false	false	true
d342787a-9bf1-4b8e-97a4-1cf929f79686	2026-09-02 14:49	2026-09-02 14:49	2026-09-02 14:49	USO	USO280121C00185000	call	185.0000	2028-01-21	14.4900	14.4500	15.0000	141.0400	111542.00	7250.00	104292.00	77	6	91	2692	0.0338038632986627	0.381745562101275	0.382367422810715	false	false	false	true
4844803f-c50a-49b9-820c-626e41b2a5a0	2026-09-02 14:18	2026-09-02 14:18	2026-09-02 14:18	USO	USO261009C00165000	call	165.0000	2026-10-09	2.3300	2.3000	2.7300	141.6050	26834.00	11147.00	5061.00	115	10	125	58	2.1551724137931	0.501686424985138	0.506465347488187	true	false	false	true
8b06a2c8-9348-4817-9f2d-434a75dab7df	2026-09-02 14:14	2026-09-02 14:13	2026-09-02 14:13	USO	USO280616C00295000	call	295.0000	2028-06-16	6.0100	6.0000	7.4000	142.0200	50496.00	3025.00	47471.00	84	5	84	361	0.232686980609418	0.409418783442222	0.409619760016273	false	false	false	true
4cb6b3c9-c894-41b7-858e-76c30f10c0fe	2026-09-02 13:48	2026-09-02 13:48	2026-09-02 13:48	USO	USO270917C00142000	call	142.0000	2027-09-17	24.3200	23.0000	24.3500	141.4500	29179.00	29179.00	0.00	12	7	12	10	1.2	0.378594894578211	0.380594258769755	true	false	false	true
df174d54-6044-42ea-9290-e92c7fe7921e	2026-09-02 11:58	2026-09-02 11:58	2026-09-02 11:58	USO	USO280317P00150000	put	150.0000	2028-03-17	29.2100	28.9500	29.2500	141.0300	26290.00	26290.00	0.00	9	9	406	495	0.82020202020202	0.43052424176487	0.431268735613213	false	false	false	true
e2e3916d-de49-431a-9c1d-c9bc63a2dbb7	2026-09-02 11:58	2026-09-02 11:58	2026-09-02 11:58	USO	USO281215C00166000	call	166.0000	2028-12-15	25.8100	25.7500	27.5000	141.0300	113570.00	7770.00	105800.00	44	5	44	64	0.6875	0.347106799323002	0.348294154678663	false	false	false	true
3b5869ee-84d8-41e9-afa9-5144338a30ee	2026-09-02 11:56	2026-09-02 11:55	2026-09-02 11:55	USO	USO270617C00193000	call	193.0000	2027-06-17	8.2200	7.9000	8.2500	141.2150	40285.00	40285.00	0.00	49	9	49	33	1.48484848484848	0.42742844342236	0.42742844342236	false	false	false	true
85395b8b-f4db-41e4-a7d0-061cb4abc1d6	2026-09-02 10:58	2026-09-02 10:58	2026-09-02 10:58	USO	USO270617C00179000	call	179.0000	2027-06-17	10.3100	9.9500	10.3500	140.6800	17535.00	16505.00	1030.00	17	6	17	12	1.41666666666667	0.417736086680755	0.41835521980821	false	false	false	true
1cdb3840-9c12-40c2-bc81-736d4ef1504a	2026-09-02 10:01	2026-09-02 10:00	2026-09-02 10:00	USO	USO261016C00140000	call	140.0000	2026-10-16	8.1600	8.1500	8.3500	138.6010	122358.00	0.00	122358.00	150	11	305	5920	0.0515202702702703	0.442880944112207	0.442880944112207	false	false	false	true
55df0571-362a-43a7-91af-ea585cbd3239	2026-09-02 09:31	2026-09-02 09:30	2026-09-02 09:30	USO	USO260902P00139000	put	139.0000	2026-09-02	0.7000	0.6500	0.8000	139.5650	17083.00	3162.00	13921.00	244	65	299	396	0.755050505050505	0.637616423643989	0.633524550431907	true	false	false	true
2fdb1722-99cc-4227-9c5d-86d6875d171e	2026-09-01 15:51	2026-09-01 15:50	2026-09-01 15:50	USO	USO261016C00150000	call	150.0000	2026-10-16	6.1400	6.0000	6.1500	140.8450	30689.00	30689.00	0.00	50	5	1234	6347	0.194422561840239	0.481778305146571	0.481778305146571	false	false	false	true
5b2161d5-efb2-4186-8ad9-c50b2c223be7	2026-09-01 15:38	2026-09-01 15:38	2026-09-01 15:38	USO	USO260918P00135000	put	135.0000	2026-09-18	2.5700	2.5700	2.7000	140.8500	183579.00	259.00	182802.00	714	26	1866	820	2.27560975609756	0.425116119338142	0.426063736817249	true	false	false	true
490b2d95-dfa1-40ae-a62a-8d62c4f13437	2026-09-01 14:43	2026-09-01 14:43	2026-09-01 14:43	USO	USO261218C00140000	call	140.0000	2026-12-18	14.7700	14.3500	14.9500	140.6050	14770.00	14770.00	0.00	10	6	514	10431	0.0492761959543668	0.450854756182222	0.450854756182222	false	false	false	true
431322c6-d531-4415-b818-d48d2b892103	2026-09-01 14:31	2026-09-01 14:31	2026-09-01 14:31	USO	USO281215P00140000	put	140.0000	2028-12-15	26.0400	25.5500	26.2000	140.5500	31245.00	26035.00	5210.00	12	8	76	394	0.192893401015228	0.408701996204656	0.410682294645517	false	false	false	true
ff9432d5-3a81-4707-9f92-18595cc3bfda	2026-09-01 14:12	2026-09-01 14:12	2026-09-01 14:12	USO	USO260925C00140000	call	140.0000	2026-09-25	6.2500	6.2500	6.7500	139.8300	313140.00	635.00	630.00	501	9	1059	1246	0.84991974317817	0.4309702899358	0.437977101036363	true	false	false	true
434d2612-d5d1-4ffe-ae7f-c450f3798214	2026-09-01 13:48	2026-09-01 13:48	2026-09-01 13:48	USO	USO281215P00136000	put	136.0000	2028-12-15	24.3500	21.5000	24.4500	139.9913	311640.00	306795.00	4845.00	128	15	128	3	42.6666666666667	0.410238757118173	0.412267611012568	true	false	false	true
8d82afc9-960f-402d-9535-6ddc8da71bde	2026-09-01 13:42	2026-09-01 13:41	2026-09-01 13:41	USO	USO261218C00180000	call	180.0000	2026-12-18	4.9000	4.1000	4.9000	140.0800	14201.00	14201.00	0.00	29	6	115	729	0.157750342935528	0.517685766480995	0.517685766480995	false	false	false	true
b9e7f167-3a31-440d-9161-1f872cec5ae9	2026-09-01 12:44	2026-09-01 12:44	2026-09-01 12:44	USO	USO280317P00150000	put	150.0000	2028-03-17	29.1700	28.9500	29.2500	139.1150	87500.00	72925.00	14575.00	30	5	185	172	1.07558139534884	0.417235092794666	0.417235092794666	false	false	false	true
e502a6b8-f314-4629-92fd-dd9c8ee0c97c	2026-09-01 12:10	2026-09-01 12:10	2026-09-01 12:10	USO	USO260918C00140000	call	140.0000	2026-09-18	4.0900	3.8000	4.2000	137.6600	23330.00	16810.00	6520.00	57	8	751	6242	0.120314001922461	0.420988118331469	0.425236902326305	false	false	false	true
1c19d547-399c-4c45-bdc8-f16f57eca6f7	2026-09-01 12:10	2026-09-01 12:10	2026-09-01 12:10	USO	USO260925C00135000	call	135.0000	2026-09-25	7.5000	7.1000	7.5000	137.7500	20990.00	20990.00	0.00	28	5	51	691	0.0738060781476122	0.414991019320706	0.41822214939204	true	false	false	true
f41bd379-1d65-4e14-858c-072b8144d717	2026-09-01 10:48	2026-09-01 10:48	2026-09-01 10:48	USO	USO280616P00095000	put	95.0000	2028-06-16	7.5600	7.2500	7.6500	136.2350	29480.00	29480.00	0.00	39	7	39	1090	0.0357798165137615	0.421435092562324	0.423839585250199	false	false	false	true