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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×source = uw_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

20c55617-fdc0-4bc4-8521-6269d4e0e663	2026-09-23 15:46	2026-09-23 15:46	2026-09-23 15:46	USO	USO261030C00166000	call	166.0000	2026-10-30	4.0500	4.0500	5.4000	148.0000	12555.00	0.00	12555.00	31	8	31	79	0.392405063291139	0.514023061639603	0.514023061639603	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	Financial Services	1228364647.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:47:37.737983Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
dfb18074-57ba-4bef-8032-7b565ac3a6b5	2026-09-23 15:39	2026-09-23 15:39	2026-09-23 15:39	USO	USO261218C00135000	call	135.0000	2026-12-18	21.4000	21.4000	21.8000	149.0176	42800.00	0.00	42800.00	20	12	966	1896	0.509493670886076	0.448288024078152	0.448288024078152	false	false	false
150bf753-77f5-4ec1-8bf2-aa1fa5cceeb0	2026-09-23 15:38	2026-09-23 15:38	2026-09-23 15:38	USO	USO261218C00165000	call	165.0000	2026-12-18	8.4600	8.4500	8.6000	149.0250	81245.00	2550.00	78695.00	96	16	2533	4444	0.56998199819982	0.483107507399299	0.481307570756812	false	false	false
0887f756-14d3-4b34-a5ee-d83c33239773	2026-09-23 15:38	2026-09-23 15:38	2026-09-23 15:38	USO	USO261218C00135000	call	135.0000	2026-12-18	21.5500	21.4000	21.8500	149.0250	49565.00	21550.00	28015.00	23	14	816	1896	0.430379746835443	0.454307142770513	0.454307142770513	false	false	false
7f6aca32-3f36-44b0-bf7b-bac412aa9cf0	2026-09-23 15:37	2026-09-23 15:37	2026-09-23 15:37	USO	USO261218C00135000	call	135.0000	2026-12-18	21.4500	21.4500	21.8000	149.0200	66495.00	0.00	66495.00	31	14	751	1896	0.396097046413502	0.450298394162172	0.450298394162172	false	false	false
06bf2c67-b442-4693-aec9-b72930066472	2026-09-23 15:37	2026-09-23 15:37	2026-09-23 15:37	USO	USO261218C00135000	call	135.0000	2026-12-18	21.4500	21.4000	21.8000	149.0200	102970.00	53635.00	49335.00	48	7	708	1896	0.373417721518987	0.450298394162172	0.450298394162172	false	false	false
01e4f2a4-5fed-46ad-a77d-3e2c04e339a0	2026-09-23 15:37	2026-09-23 15:37	2026-09-23 15:37	USO	USO261218C00165000	call	165.0000	2026-12-18	8.5000	8.5000	8.7000	149.0200	28050.00	0.00	28050.00	33	10	1799	4444	0.404815481548155	0.483177970768399	0.483177970768399	false	false	false	true
63247691-fa64-436a-b897-0293e12aea84	2026-09-23 15:37	2026-09-23 15:37	2026-09-23 15:37	USO	USO261218C00135000	call	135.0000	2026-12-18	21.4500	21.3500	21.8000	148.9315	79366.00	2146.00	77220.00	37	21	539	1896	0.284282700421941	0.452974263195949	0.452974263195949	false	false	false
907d2cd8-586b-4986-87a0-7716312384f0	2026-09-23 15:36	2026-09-23 15:36	2026-09-23 15:36	USO	USO261218C00135000	call	135.0000	2026-12-18	21.5500	21.5500	21.6000	148.9800	109905.00	0.00	109905.00	51	19	177	1896	0.0933544303797468	0.455664607834409	0.455664607834409	false	false	false
1fb9b436-05f2-4e5f-bf0d-d100245200cd	2026-09-23 15:17	2026-09-23 15:17	2026-09-23 15:17	USO	USO261120P00126000	put	126.0000	2026-11-20	2.9000	2.9000	2.9800	148.5200	12180.00	0.00	12180.00	42	5	57	875	0.0651428571428571	0.497374081098989	0.497374081098989	false	false	false	true
53fc53f5-b942-401d-88fc-771bf3649fdb	2026-09-23 15:13	2026-09-23 15:13	2026-09-23 15:13	USO	USO280121P00121000	put	121.0000	2028-01-21	12.8500	12.3000	13.7000	148.3150	12850.00	2570.00	10280.00	10	5	10	350	0.0285714285714286	0.45041287314932	0.45041287314932	false	false	false	true
107bcec1-daeb-41f1-afeb-54540b43468a	2026-09-23 15:05	2026-09-23 15:05	2026-09-23 15:05	USO	USO260930C00148000	call	148.0000	2026-09-30	4.4000	4.1500	4.6000	148.2523	11000.00	4400.00	6600.00	25	5	263	104	2.52884615384615	0.51536197686384	0.51536197686384	true	false	false	true
f5cd2a73-e918-4af8-ab69-11440a9e15e8	2026-09-23 14:56	2026-09-23 14:56	2026-09-23 14:56	USO	USO260925P00143000	put	143.0000	2026-09-25	0.7800	0.7600	0.7800	148.3801	10296.00	10296.00	0.00	132	16	750	712	1.05337078651685	0.61674165115561	0.61674165115561	false	false	false	true
cb477757-df89-43ee-b60f-f01f1a40b211	2026-09-23 14:54	2026-09-23 14:54	2026-09-23 14:54	USO	USO280121P00120000	put	120.0000	2028-01-21	12.6000	12.2000	13.5000	148.6200	12600.00	3780.00	8820.00	10	5	313	3633	0.0861546930911093	0.454183191676341	0.454183191676341	false	false	false
89d4c5bd-0944-4f6d-a2c0-52c4d75a26c2	2026-09-23 14:42	2026-09-23 14:42	2026-09-23 14:42	USO	USO261120P00140000	put	140.0000	2026-11-20	7.0000	6.9000	7.0500	149.0600	11900.00	11900.00	0.00	17	5	487	2710	0.17970479704797	0.493757955672628	0.493757955672628	false	false	false	true
c2dec048-09a9-41d2-9099-4e5f04feb478	2026-09-23 14:41	2026-09-23 14:41	2026-09-23 14:41	USO	USO261016C00160000	call	160.0000	2026-10-16	3.7500	3.7500	3.8000	149.1200	70500.00	0.00	70500.00	188	5	816	5118	0.159437280187573	0.512259464062342	0.512259464062342	true	false	false	true
046b3874-9c13-4ef2-8e72-6189a903e628	2026-09-23 14:41	2026-09-23 14:41	2026-09-23 14:41	USO	USO261016C00160000	call	160.0000	2026-10-16	3.7500	3.7500	3.8500	149.1100	79504.00	0.00	79504.00	212	28	628	5118	0.122704181320828	0.512499092522988	0.512499092522988	true	false	false	true
c2078363-bf9a-4582-bb15-dbff7057ccae	2026-09-23 14:36	2026-09-23 14:36	2026-09-23 14:36	USO	USO261009P00139000	put	139.0000	2026-10-09	2.4500	2.4400	4.0500	148.9100	15435.00	0.00	15190.00	63	7	91	361	0.25207756232687	0.521498650316712	0.521498650316712	false	false	false	true
bc1e1920-1387-4b65-a4d9-b599f9c579f0	2026-09-23 14:35	2026-09-23 14:35	2026-09-23 14:35	USO	USO260925C00150000	call	150.0000	2026-09-25	1.9500	1.9400	1.9500	148.8700	87750.00	87750.00	0.00	450	7	9302	4571	2.03500328155765	0.557512462150393	0.557512462150393	false	false	false	true
8cc978b4-afd3-4647-970a-99181eed0179	2026-09-23 14:33	2026-09-23 14:33	2026-09-23 14:33	USO	USO261023P00149000	put	149.0000	2026-10-23	8.4000	8.2500	8.4500	148.8600	19320.00	19320.00	0.00	23	5	26	129	0.201550387596899	0.504477579615267	0.504477579615267	true	false	false	true
b5c015c3-77f8-4f1b-8bcb-862b06d3e150	2026-09-23 14:00	2026-09-23 14:00	2026-09-23 14:00	USO	USO260930P00146000	put	146.0000	2026-09-30	3.4000	3.3000	4.0000	147.5900	23120.00	7480.00	15640.00	68	5	172	549	0.313296903460838	0.517669446071907	0.517669446071907	true	false	false	true
7c7c6763-b0bc-41bd-8c94-e1bd63755dd6	2026-09-23 13:57	2026-09-23 13:57	2026-09-23 13:57	USO	USO261120P00165000	put	165.0000	2026-11-20	22.8500	22.6000	23.0500	147.3300	13710.00	2285.00	11425.00	6	6	12	278	0.0431654676258993	0.521991695868239	0.521991695868239	false	false	false	true
52f4d949-8d96-4f87-95df-5bf4c22d720f	2026-09-23 13:57	2026-09-23 13:56	2026-09-23 13:56	USO	USO261016P00145000	put	145.0000	2026-10-16	6.1000	6.0500	6.1000	147.3200	17080.00	5490.00	0.00	28	6	555	5344	0.103854790419162	0.504046018959204	0.504046018959204	false	false	false	true
81e642c2-0870-46a9-9f8e-cd26dd876a7b	2026-09-23 13:57	2026-09-23 13:56	2026-09-23 13:56	USO	USO261016P00145000	put	145.0000	2026-10-16	6.1000	6.0500	6.1000	147.3200	15860.00	2440.00	0.00	26	7	527	5344	0.0986152694610778	0.504046018959204	0.504046018959204	false	false	false	true
6236baf4-8142-41aa-b172-7ea0489dd5f1	2026-09-23 13:56	2026-09-23 13:56	2026-09-23 13:56	USO	USO261016P00145000	put	145.0000	2026-10-16	6.1000	6.0500	6.1000	147.3200	37210.00	610.00	0.00	61	13	489	5344	0.0915044910179641	0.504046018959204	0.504046018959204	false	false	false	true
2464e385-1f6a-43a7-bcbc-9fc55601b948	2026-09-23 13:56	2026-09-23 13:56	2026-09-23 13:56	USO	USO261016P00145000	put	145.0000	2026-10-16	6.1000	6.0500	6.1000	147.3200	20740.00	15860.00	0.00	34	5	428	5344	0.0800898203592814	0.504046018959204	0.504046018959204	false	false	false	true
fd17169f-e771-45be-b1d9-413d9df487b2	2026-09-23 13:56	2026-09-23 13:56	2026-09-23 13:56	USO	USO261016P00145000	put	145.0000	2026-10-16	6.1000	6.0500	6.1000	147.3200	46360.00	46360.00	0.00	76	22	375	5344	0.0701721556886228	0.504046018959204	0.504046018959204	false	false	false	true
2765ee26-c7ce-425f-bde8-237c21b0c77f	2026-09-23 13:55	2026-09-23 13:55	2026-09-23 13:55	USO	USO261120C00168000	call	168.0000	2026-11-20	5.2500	5.1000	5.4500	147.4600	25737.00	525.00	25212.00	49	11	63	47	1.34042553191489	0.508421907163986	0.508421907163986	true	false	false	true
ceab6793-3d26-4f76-ad87-3d7dc7d07ec9	2026-09-23 13:46	2026-09-23 13:46	2026-09-23 13:46	USO	USO261002C00143000	call	143.0000	2026-10-02	7.7000	7.7000	8.4000	147.0000	16170.00	0.00	16170.00	21	10	26	105	0.247619047619048	0.530341270011803	0.530341270011803	true	false	false	true
f0276d83-ac3d-48d3-adb6-3fbea5cadd4c	2026-09-23 13:37	2026-09-23 13:37	2026-09-23 13:37	USO	USO261016P00140000	put	140.0000	2026-10-16	4.0000	3.9500	4.0000	147.6700	12000.00	12000.00	0.00	30	6	1548	8324	0.185968284478616	0.5094026567245	0.5094026567245	false	false	false	true
c4626961-5b1b-4d21-aaa9-c93d9e23f5ed	2026-09-23 13:31	2026-09-23 13:31	2026-09-23 13:31	USO	USO261120C00156000	call	156.0000	2026-11-20	8.4500	8.4000	8.4500	147.0000	12675.00	12675.00	0.00	15	7	23	96	0.239583333333333	0.49208787263997	0.49208787263997	false	false	false	true
06b0b434-097d-4e7e-8725-1658b4595ffe	2026-09-23 13:31	2026-09-23 13:31	2026-09-23 13:31	USO	USO261120C00157000	call	157.0000	2026-11-20	8.1000	7.9000	8.1500	147.0000	10525.00	5670.00	1615.00	13	11	84	493	0.170385395537525	0.494138034297133	0.492290797994488	true	false	false	true
af0588e2-3c32-4097-9232-6ccbeb9ddae2	2026-09-23 13:16	2026-09-23 13:16	2026-09-23 13:16	USO	USO261016P00140000	put	140.0000	2026-10-16	4.1500	4.1000	4.2000	147.0000	13280.00	11620.00	1660.00	32	6	1477	8324	0.177438731379145	0.508172994445347	0.508172994445347	true	false	false	true
ee1cf41c-3195-4337-81bf-1bcabb145781	2026-09-23 13:16	2026-09-23 13:15	2026-09-23 13:15	USO	USO261218C00250000	call	250.0000	2026-12-18	1.0000	1.0000	1.2900	147.0000	69300.00	0.00	69300.00	693	21	701	1703	0.411626541397534	0.623422830721331	0.623655673955015	false	false	false
698ea59e-5642-4d41-b73d-05846d1a1885	2026-09-23 13:15	2026-09-23 13:15	2026-09-23 13:15	USO	USO261016P00140000	put	140.0000	2026-10-16	4.2000	4.1000	4.2000	147.0000	26880.00	26880.00	0.00	64	7	1445	8324	0.173594425756848	0.50931407089257	0.50931407089257	false	false	false	true
34ba8941-b40b-4d70-9bda-39f54356e5ea	2026-09-23 13:10	2026-09-23 13:10	2026-09-23 13:10	USO	USO260930P00140000	put	140.0000	2026-09-30	1.6500	1.6100	1.6500	147.0900	16500.00	16500.00	0.00	100	5	614	4205	0.146016646848989	0.546418676505468	0.546418676505468	false	false	false	true
94419d08-a05b-48b4-b597-0af43790a62a	2026-09-23 13:05	2026-09-23 13:05	2026-09-23 13:05	USO	USO260925C00150000	call	150.0000	2026-09-25	1.3700	1.3400	1.3700	147.2300	162893.00	162893.00	0.00	1189	8	5677	4571	1.24196018376723	0.5707343203889	0.5707343203889	false	false	false	true
848026db-dd58-4117-b23a-71f088395f0a	2026-09-23 13:04	2026-09-23 13:04	2026-09-23 13:04	USO	USO261016C00170000	call	170.0000	2026-10-16	1.6000	1.5400	1.6000	147.0900	11040.00	11040.00	0.00	69	8	2929	8033	0.364620938628159	0.53783804887272	0.53783804887272	false	false	false	true
ccb67f1e-1fe6-47cc-94f0-82c88ca63c78	2026-09-23 13:01	2026-09-23 13:01	2026-09-23 13:01	USO	USO261002P00147000	put	147.0000	2026-10-02	4.9500	4.8000	5.1000	146.8550	13365.00	12870.00	0.00	27	9	256	258	0.992248062015504	0.538155336425385	0.538155336425385	false	false	false	true
cb9c8e2c-ca52-41b8-8067-9b4e5a24ef95	2026-09-23 12:55	2026-09-23 12:55	2026-09-23 12:55	USO	USO260923C00148000	call	148.0000	2026-09-23	0.3500	0.3400	0.3500	147.1800	37905.00	37905.00	0.00	1083	20	4765	1332	3.57732732732733	0.618182561806369	0.618182561806369	false	false	false
d864d55f-399d-4b27-bf5c-bfce7a852848	2026-09-23 12:53	2026-09-23 12:53	2026-09-23 12:53	USO	USO261007C00151000	call	151.0000	2026-10-07	4.4500	4.3000	6.6500	147.4301	13804.00	9790.00	4014.00	31	5	32	3	10.6666666666667	0.512880727722196	0.512880727722196	false	false	false	true
353c1d38-1b59-47a0-bda5-c8fec44cde9c	2026-09-23 12:52	2026-09-23 12:52	2026-09-23 12:52	USO	USO270319C00181000	call	181.0000	2027-03-19	9.3500	9.3500	11.5500	147.6700	11220.00	0.00	11220.00	12	9	12	123	0.0975609756097561	0.466553217976712	0.466553217976712	false	false	false	true
b0de950e-8d74-433a-acfd-1ce3389f5c6e	2026-09-23 12:52	2026-09-23 12:51	2026-09-23 12:51	USO	USO261120P00140000	put	140.0000	2026-11-20	7.5000	7.2500	7.5000	147.7150	18750.00	18750.00	0.00	25	7	449	2710	0.165682656826568	0.496059499229824	0.496059499229824	false	false	false	true
7af3c58c-a89b-4db4-94e2-813654c5fd35	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	USO	USO261030C00180000	call	180.0000	2026-10-30	1.9200	1.8400	1.9300	147.8300	17088.00	14016.00	3072.00	89	5	175	489	0.357873210633947	0.547464106827423	0.547464106827423	false	false	false
d6df65c3-c878-488a-8216-8f3c4eba891f	2026-09-23 12:51	2026-09-23 12:50	2026-09-23 12:50	USO	USO261120P00147000	put	147.0000	2026-11-20	10.7000	10.4500	10.7000	147.9700	12840.00	12840.00	0.00	12	10	26	124	0.209677419354839	0.49853818851611	0.49853818851611	false	false	false	true
0061e93a-8feb-4dd6-ad5c-2c56b6537891	2026-09-23 12:49	2026-09-23 12:49	2026-09-23 12:49	USO	USO260923P00148000	put	148.0000	2026-09-23	0.6300	0.6000	0.6700	148.0900	44037.00	43974.00	63.00	699	5	2800	1043	2.68456375838926	0.599779943570054	0.599779943570054	false	false	false	true
bc9c1955-5ab3-4669-acaa-cb017d3ec662	2026-09-23 12:41	2026-09-23 12:41	2026-09-23 12:41	USO	USO261002P00142000	put	142.0000	2026-10-02	2.2600	2.2600	2.3200	148.0000	10848.00	0.00	10848.00	48	12	310	5286	0.0586454786227772	0.538686344807293	0.538686344807293	false	false	false	true
9029236a-f96d-4147-9814-5e0281f571b9	2026-09-23 12:17	2026-09-23 12:17	2026-09-23 12:17	USO	USO261016P00130000	put	130.0000	2026-10-16	1.3900	1.3900	1.4300	148.5999	27800.00	0.00	23908.00	200	8	908	11506	0.0789153485138189	0.520430495801488	0.520430495801488	false	false	false	true
ae0fe84a-0445-4170-83c8-360d0a2345b3	2026-09-23 12:16	2026-09-23 12:16	2026-09-23 12:16	USO	USO261016C00151000	call	151.0000	2026-10-16	6.4500	6.4500	6.6500	148.6700	16127.00	0.00	16127.00	25	8	290	14506	0.0199917275610092	0.493126765209342	0.493126765209342	false	false	false
5e500869-5f6b-4c83-9558-4cdc63e4aff9	2026-09-23 12:09	2026-09-23 12:09	2026-09-23 12:09	USO	USO261120P00125000	put	125.0000	2026-11-20	2.6100	2.6000	2.6900	149.0050	11481.00	0.00	11481.00	44	5	1165	915	1.27322404371585	0.497460109614407	0.496751320325949	true	false	false	true