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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 rowsrestricted — hover for the licence

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

6f784203-dde8-4d43-a24f-cf0a23aab388	2026-09-21 10:27	2026-09-21 10:27	2026-09-21 10:27	USO	USO261002P00150000	put	150.0000	2026-10-02	6.2400	6.2000	6.4000	147.7000	18726.00	5706.00	13020.00	30	6	365	1032	0.353682170542636	0.492193385289746	0.505980687133001	false	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-21T14:29:33.809340Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
e2e4862b-7b91-4f3d-b233-1a0736c7536f	2026-09-21 10:26	2026-09-21 10:26	2026-09-21 10:26	USO	USO260925P00136000	put	136.0000	2026-09-25	0.5100	0.4800	0.5100	147.8500	28705.00	28705.00	0.00	564	54	755	1625	0.464615384615385	0.648487943624778	0.652104700020437	true	false	false	true
ac39c5d5-9935-4050-94cd-ac8034c35b89	2026-09-21 10:21	2026-09-21 10:21	2026-09-21 10:21	USO	USO261218C00165000	call	165.0000	2026-12-18	8.3800	8.3500	8.9500	147.8800	15925.00	4200.00	11725.00	19	11	144	2242	0.064228367528992	0.487793336168506	0.487793336168506	true	false	false	true
617e92d7-d6ad-41d4-9c41-f83239c20fad	2026-09-21 10:18	2026-09-21 10:18	2026-09-21 10:18	USO	USO270617P00140000	put	140.0000	2027-06-17	16.8000	16.8000	17.3000	148.1700	203309.00	0.00	203309.00	121	32	177	699	0.253218884120172	0.468173514458308	0.468173514458308	false	false	false	true
acd3d682-a67e-4f90-8383-bd39a7f29000	2026-09-21 10:11	2026-09-21 10:11	2026-09-21 10:11	USO	USO261009C00145000	call	145.0000	2026-10-09	8.2100	8.2000	8.5500	148.0000	47600.00	4115.00	43485.00	58	20	150	519	0.289017341040462	0.478260020182355	0.478260020182355	false	false	false	true
4acdb1bb-4568-4480-a34a-e12b0877d3ed	2026-09-21 10:10	2026-09-21 10:10	2026-09-21 10:10	USO	USO261002C00156000	call	156.0000	2026-10-02	2.4700	2.2300	2.5200	148.0000	17772.00	15557.00	2215.00	72	6	111	599	0.185308848080134	0.500087139956685	0.501184289882052	true	false	false	true
53950417-9be6-4b8a-b802-c57feecf9b3f	2026-09-21 10:07	2026-09-21 10:07	2026-09-21 10:07	USO	USO270617P00130000	put	130.0000	2027-06-17	12.5100	12.3500	13.0000	148.8400	166341.00	1250.00	165091.00	133	36	151	6063	0.024905162460828	0.474973590686284	0.474973590686284	false	false	false	true
9c271773-5390-4019-afbd-e5b69254f7f9	2026-09-21 10:02	2026-09-21 10:02	2026-09-21 10:02	USO	USO261002P00142000	put	142.0000	2026-10-02	2.3800	2.3800	2.4600	148.9400	15245.00	1437.00	13808.00	64	17	276	254	1.08661417322835	0.514405227631935	0.515560234039783	true	false	false	true
9e53f92e-47f5-41a6-8207-20de0b3eea35	2026-09-21 10:01	2026-09-21 10:01	2026-09-21 10:01	USO	USO260930P00144000	put	144.0000	2026-09-30	2.6200	2.6200	2.7200	148.7050	11269.00	263.00	11006.00	43	13	95	26	3.65384615384615	0.507226798783403	0.507226798783403	true	false	false	true
f1c024df-40ff-4dd6-bb0e-147ac4eba331	2026-09-18 15:44	2026-09-18 15:44	2026-09-18 15:44	USO	USO260925P00135000	put	135.0000	2026-09-25	0.3000	0.2400	0.3000	153.7300	11914.00	11914.00	0.00	400	9	639	3796	0.168335089567966	0.597272425901372	0.60161579570478	false	false	false	true
8afbecfd-725f-4ead-9b6b-435fbd96ed2a	2026-09-18 15:39	2026-09-18 15:39	2026-09-18 15:39	USO	USO261218P00130000	put	130.0000	2026-12-18	4.7600	4.6500	4.8500	153.7050	12378.00	0.00	12378.00	26	5	315	4627	0.0680786686838124	0.489117866822868	0.494731541964411	false	false	false	true
e9da472a-f3dc-42b7-be2d-dc83219e4924	2026-09-18 15:37	2026-09-18 15:37	2026-09-18 15:37	USO	USO261016C00151000	call	151.0000	2026-10-16	9.2400	9.2000	9.5500	153.7750	10167.00	935.00	9232.00	11	10	140	14061	0.00995661759476566	0.446458514672404	0.453782484191465	true	false	false	true
69b7f404-cc8e-462b-822f-12838134099c	2026-09-18 15:19	2026-09-18 15:19	2026-09-18 15:19	USO	USO261030P00165000	put	165.0000	2026-10-30	16.9000	16.3500	17.3000	153.5450	253528.00	118300.00	135228.00	150	18	178	223	0.798206278026906	0.499556483308175	0.499556483308175	false	false	false	true
36b8adbf-6a76-46e6-ba2a-bc74db0c4994	2026-09-18 14:35	2026-09-18 14:35	2026-09-18 14:35	USO	USO261023C00180000	call	180.0000	2026-10-23	2.3700	2.3500	2.5200	153.8900	13282.00	6440.00	6842.00	56	21	390	441	0.884353741496599	0.511337639767894	0.515463331233894	true	false	false	true
72b7f091-ce3e-45db-9c7e-18f969bfeb3a	2026-09-18 14:30	2026-09-18 14:30	2026-09-18 14:30	USO	USO261023C00162000	call	162.0000	2026-10-23	6.1100	6.0500	6.2500	154.4100	31151.00	3690.00	26851.00	51	20	69	110	0.627272727272727	0.47015586120439	0.47015586120439	true	false	false	true
6b027a10-2650-48e7-9328-69f4f0aa6bf7	2026-09-18 14:22	2026-09-18 14:22	2026-09-18 14:22	USO	USO261016C00165000	call	165.0000	2026-10-16	4.2500	4.1500	4.2500	154.1701	47169.00	47169.00	0.00	111	14	780	4120	0.189320388349515	0.477848328551998	0.479132268838447	false	false	false	true
23df0fdf-d004-48d8-8728-4717ed6d6529	2026-09-18 14:22	2026-09-18 14:22	2026-09-18 14:22	USO	USO261016C00165000	call	165.0000	2026-10-16	4.2400	4.1500	4.2500	154.1701	58943.00	58943.00	0.00	139	6	669	4120	0.162378640776699	0.477848328551998	0.479132268838447	false	false	false	true
c90d08e6-53f8-4954-a514-1f724f399444	2026-09-18 14:12	2026-09-18 14:12	2026-09-18 14:12	USO	USO270115C00260000	call	260.0000	2027-01-15	2.0600	2.0200	2.3900	154.4110	27464.00	13728.00	13736.00	133	5	133	101	1.31683168316832	0.598952407048299	0.600962760744509	false	false	false	true
d9f192ab-ceb5-4a07-a959-0294ef964640	2026-09-18 13:39	2026-09-18 13:39	2026-09-18 13:39	USO	USO261002P00148000	put	148.0000	2026-10-02	2.8700	2.8700	3.2000	154.0714	19808.00	0.00	19808.00	69	12	676	188	3.59574468085106	0.462353298732263	0.462353298732263	true	false	false	true
9416b2e1-3ca2-4c87-811d-fa792fcf0edb	2026-09-18 13:39	2026-09-18 13:39	2026-09-18 13:39	USO	USO261002P00146000	put	146.0000	2026-10-02	2.2900	2.2700	2.5100	154.0714	17635.00	230.00	17405.00	77	18	388	381	1.01837270341207	0.466792833964696	0.467819179049722	true	false	false	true
9eb0f322-ab2e-435c-82a1-e0ffdf5c7799	2026-09-18 13:23	2026-09-18 13:23	2026-09-18 13:23	USO	USO261002P00145000	put	145.0000	2026-10-02	2.1500	2.1200	2.3500	153.8307	19999.00	218.00	19781.00	93	17	641	4370	0.146681922196796	0.47509727546157	0.478277907539524	false	false	false	true
5b829ea3-bc1c-4eaa-98bd-a832d9e075ee	2026-09-18 13:16	2026-09-18 13:16	2026-09-18 13:16	USO	USO261002C00162000	call	162.0000	2026-10-02	2.5700	2.4900	2.5800	154.0700	13882.00	13882.00	0.00	54	10	377	166	2.2710843373494	0.45348002962933	0.454422749652274	true	false	false	true
35b20231-cd9e-4954-940e-863e2611c3bb	2026-09-18 13:13	2026-09-18 13:13	2026-09-18 13:13	USO	USO261016P00164000	put	164.0000	2026-10-16	13.9600	13.2500	14.0000	154.1450	20945.00	20945.00	0.00	15	6	25	90	0.277777777777778	0.482668297648297	0.485814572496563	true	false	false	true
f8cf1b1d-db8d-4f28-93c3-5310138067f1	2026-09-18 12:29	2026-09-18 12:29	2026-09-18 12:29	USO	USO261023C00159000	call	159.0000	2026-10-23	7.6600	7.6000	7.8000	155.0600	11486.00	0.00	10716.00	15	11	47	44	1.06818181818182	0.476360191789668	0.476360191789668	false	false	false	true
da1390c1-7826-469b-917d-0c9a64d7adf3	2026-09-18 12:21	2026-09-18 12:21	2026-09-18 12:21	USO	USO261002P00146000	put	146.0000	2026-10-02	1.9100	1.7600	1.9200	155.0000	14715.00	14715.00	0.00	77	17	290	381	0.761154855643045	0.461499137941547	0.462593616728967	true	false	false	true
c54e2288-63a0-4d33-ae79-40bdb0386a7a	2026-09-18 11:57	2026-09-18 11:56	2026-09-18 11:56	USO	USO261009P00141000	put	141.0000	2026-10-09	1.7900	1.7800	1.8900	155.7690	23139.00	3801.00	19338.00	129	37	248	77	3.22077922077922	0.483405025910816	0.485482427666786	true	false	false	true
9517c7f7-abcf-4e9e-b346-d4cd0d1c5f5e	2026-09-18 11:55	2026-09-18 11:55	2026-09-18 11:55	USO	USO261023C00160000	call	160.0000	2026-10-23	7.7600	7.7000	7.9500	155.9900	13188.00	1560.00	10853.00	17	15	54	837	0.0645161290322581	0.48016940697113	0.482770292311599	true	false	false	true
6dc0f05c-9a13-465e-b0e1-33c0bcd3f80b	2026-09-18 11:48	2026-09-18 11:48	2026-09-18 11:48	USO	USO261002C00170000	call	170.0000	2026-10-02	1.6800	1.6700	1.9500	156.0397	14285.00	2018.00	11593.00	85	23	400	1109	0.360685302073941	0.495241910904386	0.495241910904386	true	false	false	true
2d9befc9-2aa7-47ee-9f30-b75cd3f0a402	2026-09-18 11:48	2026-09-18 11:48	2026-09-18 11:48	USO	USO261002C00168000	call	168.0000	2026-10-02	2.0000	1.9900	2.1300	156.0397	14008.00	604.00	13002.00	70	18	593	28	21.1785714285714	0.48767404226369	0.48767404226369	true	false	false	true
08019bca-3124-4039-be0b-99912e9cecd7	2026-09-18 11:27	2026-09-18 11:27	2026-09-18 11:27	USO	USO270115P00130000	put	130.0000	2027-01-15	5.9400	5.7000	6.1000	155.8700	59384.00	59384.00	0.00	100	6	197	2913	0.0676278750429111	0.501554397067364	0.501554397067364	false	false	false	true
2020b4c4-74ff-40de-9a4c-ccaec9d9a8dc	2026-09-18 10:57	2026-09-18 10:57	2026-09-18 10:57	USO	USO261120P00163000	put	163.0000	2026-11-20	16.6700	15.6500	16.7500	155.9000	20000.00	18335.00	1665.00	12	7	14	74	0.189189189189189	0.512543833699067	0.514483452170531	true	false	false	true
86aeda07-d9e5-42c3-bec0-224914dc1ebf	2026-09-18 10:43	2026-09-18 10:43	2026-09-18 10:43	USO	USO261002C00165000	call	165.0000	2026-10-02	2.9600	2.8500	2.9800	157.1150	21868.00	21868.00	0.00	74	6	376	1264	0.29746835443038	0.478368125776336	0.479273261158519	false	false	false	true
33f9a782-0ff3-4c59-8fc2-a15f049a6814	2026-09-18 10:43	2026-09-18 10:43	2026-09-18 10:43	USO	USO261002C00173000	call	173.0000	2026-10-02	1.4400	1.3700	1.4550	157.1150	13282.00	13282.00	0.00	92	6	108	0	0	0.501628707051581	0.504100955228583	false	false	false	true
b977327e-4a91-41d7-99eb-5281fadd980d	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.9400	3.1000	157.2550	76878.00	76878.00	0.00	248	6	533	941	0.566418703506908	0.794695329033614	0.812826853295067	false	false	false	true
1c79aec8-09c9-458b-91fd-cdcfb932f7fa	2026-09-18 10:05	2026-09-18 10:05	2026-09-18 10:05	USO	USO261016P00141000	put	141.0000	2026-10-16	2.5300	2.5200	2.6300	156.8100	30878.00	1782.00	29096.00	122	20	122	241	0.506224066390041	0.501292767367851	0.502125426259286	true	false	false	true
7280a543-a7ba-406c-be84-3ff08a7f05a0	2026-09-18 10:00	2026-09-18 10:00	2026-09-18 10:00	USO	USO261016C00160000	call	160.0000	2026-10-16	7.4500	7.3000	7.5000	157.1000	17877.00	17132.00	745.00	24	8	103	4588	0.0224498692240628	0.490477206611732	0.492207112847429	false	false	false	true
5ef5ee36-8767-4e39-b504-57acbdb90931	2026-09-18 09:56	2026-09-18 09:55	2026-09-18 09:56	USO	USO261016P00140000	put	140.0000	2026-10-16	2.1900	2.1800	2.2300	157.0656	11600.00	0.00	11600.00	53	5	1395	7867	0.177322994788356	0.494576092076054	0.495463782248019	false	false	false	true
2501a6fe-118e-425a-92ba-d369efb0e061	2026-09-18 09:39	2026-09-18 09:39	2026-09-18 09:39	USO	USO260925C00160000	call	160.0000	2026-09-25	2.5200	2.4200	2.5200	156.8601	27944.00	27944.00	0.00	111	18	263	2463	0.106780349167682	0.437981000340045	0.439182204364865	true	false	false	true
3057da77-2a08-4262-93dc-c55a86208450	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	USO	USO260918C00156000	call	156.0000	2026-09-18	1.6800	1.6800	1.9100	156.8400	59991.00	1188.00	58803.00	357	50	378	1897	0.199261992619926	0.713012932500597	0.713012932500597	true	false	false	true
4566fc3e-f0b1-4f59-9b7f-4d89fcd74456	2026-09-17 15:56	2026-09-17 15:56	2026-09-17 15:56	USO	USO261009C00160000	call	160.0000	2026-10-09	5.4700	5.4500	5.6000	155.0000	53081.00	0.00	53081.00	97	6	268	562	0.476868327402135	0.479629912819232	0.479629912819232	true	false	false	true
8431822b-c1c1-40b0-9258-0f82255bb83c	2026-09-17 15:25	2026-09-17 15:24	2026-09-17 15:24	USO	USO261009C00164000	call	164.0000	2026-10-09	4.2600	4.1000	4.3000	155.0400	33665.00	33665.00	0.00	79	11	226	0	0	0.500079911413919	0.503612500379465	true	false	false	true
315c0446-4f75-4428-9763-6c6141586213	2026-09-17 15:08	2026-09-17 15:08	2026-09-17 15:08	USO	USO260925C00154000	call	154.0000	2026-09-25	5.1600	5.1500	6.1000	155.4300	109419.00	0.00	109419.00	212	22	448	187	2.39572192513369	0.47351414436084	0.473425634991413	true	false	false	true
3f38e05f-f8d4-4647-9906-ab99bc1dfbdb	2026-09-17 15:03	2026-09-17 15:03	2026-09-17 15:03	USO	USO261016P00160000	put	160.0000	2026-10-16	11.0300	10.9500	11.0500	155.8000	55150.00	55150.00	0.00	50	6	389	1051	0.370123691722169	0.50989652441742	0.51276218664729	false	false	false	true
da9e0a71-f61c-43e4-9afe-e1cc6bdec1a8	2026-09-17 14:53	2026-09-17 14:53	2026-09-17 14:53	USO	USO270917C00210000	call	210.0000	2027-09-17	13.6100	13.0000	14.4000	156.0700	311702.00	0.00	311702.00	229	22	568	186	3.05376344086022	0.44098196664474	0.44098196664474	false	false	false	true
cdca5fc5-e9c2-4408-90d4-d006b93a223d	2026-09-17 14:49	2026-09-17 14:49	2026-09-17 14:49	USO	USO261002P00144000	put	144.0000	2026-10-02	1.6800	1.6300	1.6900	156.1400	14614.00	14448.00	166.00	87	14	240	533	0.450281425891182	0.486322115865189	0.488664960129767	false	false	false	true
ee3b3e33-05fb-41f5-8545-8e63875dbfc2	2026-09-17 14:48	2026-09-17 14:48	2026-09-17 14:48	USO	USO261016C00160000	call	160.0000	2026-10-16	7.2500	7.2000	7.4500	156.1350	158073.00	0.00	158073.00	218	28	858	4713	0.182049649904519	0.497959921807174	0.497959921807174	true	false	false	true
be8ce415-70c5-443f-986a-a38a153271ee	2026-09-17 14:47	2026-09-17 14:47	2026-09-17 14:47	USO	USO261023P00135000	put	135.0000	2026-10-23	2.2100	2.2000	2.3000	156.0639	38238.00	667.00	36908.00	173	29	234	296	0.790540540540541	0.510920087870108	0.510920087870108	true	false	false	true
97b3b204-59d2-459e-9aa8-4718b906443a	2026-09-17 14:47	2026-09-17 14:47	2026-09-17 14:47	USO	USO261023P00137000	put	137.0000	2026-10-23	2.6100	2.6000	2.7100	156.0639	12269.00	2089.00	10180.00	47	18	50	59	0.847457627118644	0.509301813502995	0.510081983593369	true	false	false	true
91ad2ca9-acee-40c1-a330-5d9fe7d4ebad	2026-09-17 14:42	2026-09-17 14:42	2026-09-17 14:42	USO	USO270917C00210000	call	210.0000	2027-09-17	13.6600	13.6500	14.4000	156.0700	336093.00	0.00	336093.00	246	17	339	186	1.82258064516129	0.441836000663839	0.441836000663839	false	false	false	true
363ef4e2-7962-4d86-b51f-6f0b985bd633	2026-09-17 14:06	2026-09-17 14:06	2026-09-17 14:06	USO	USO280616C00190000	call	190.0000	2028-06-16	25.3000	24.9500	26.2500	156.1700	83505.00	2540.00	78430.00	33	11	67	1289	0.051978277734678	0.392365487614831	0.393580578148764	false	false	false	true