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: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	expirydate

8225b221-f5f5-49aa-bdef-14b490d64226	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	USO	USO261016C00157000	call	157.0000	2026-10-16	5.3000	5.1000	5.4000	151.6695	21200.00	21200.00	0.00	40	12	41	331	0.123867069486405	0.498345380550786	0.498345380550786	true	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-24T13:38:54.076483Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
4cd6a52c-f7eb-45ea-8a43-68c000446e59	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	USO	USO261016C00153000	call	153.0000	2026-10-16	6.9000	6.7000	6.9000	151.6695	25530.00	25530.00	0.00	37	10	38	482	0.0788381742738589	0.494964231487722	0.494964231487722	true	false	false	true
09560a3f-45a6-411a-aa4d-c6050bc8ccef	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	USO	USO261016C00154000	call	154.0000	2026-10-16	6.4500	6.2500	6.4500	151.6500	16125.00	16125.00	0.00	25	5	25	190	0.131578947368421	0.49515244883094	0.49515244883094	false	false	false	true
baa79cba-9c70-406c-bcd4-2edf934e9267	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	USO	USO261009C00158000	call	158.0000	2026-10-09	3.6500	3.5500	3.8000	151.5000	29200.00	5110.00	24090.00	80	26	116	181	0.640883977900553	0.502783240834683	0.502783240834683	false	false	false	true
127f9209-ee48-4d5f-87cb-64735bfcc655	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	USO	USO261023C00155000	call	155.0000	2026-10-23	7.1000	6.8000	7.3000	151.5000	18460.00	17750.00	710.00	26	12	26	302	0.0860927152317881	0.497288507649461	0.495624004350249	true	false	false	true
e0c0d6a5-51b4-4f72-9a86-34e2f4e2a893	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	USO	USO261023C00158000	call	158.0000	2026-10-23	6.0000	4.7000	6.1500	151.5000	26395.00	25800.00	595.00	44	18	44	56	0.785714285714286	0.499503571245079	0.499603961891139	true	false	false	true
b13ff2dd-1482-4e0f-95f4-8197edb8bfce	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	USO	USO261023C00157000	call	157.0000	2026-10-23	6.3500	6.0500	6.5000	151.5000	10795.00	10160.00	0.00	17	10	17	103	0.16504854368932	0.498197157303889	0.498300870167186	false	false	false	true
9b56ecfa-926e-4940-8370-302f51f35afc	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	USO	USO261009C00158000	call	158.0000	2026-10-09	3.7000	3.5000	3.7000	151.4400	12950.00	12950.00	0.00	35	7	35	181	0.193370165745856	0.509012645429731	0.509012645429731	true	false	false	true
704ce737-ff92-48b4-95d0-36bcc239a66d	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	USO	USO261009C00159000	call	159.0000	2026-10-09	3.4000	3.2000	3.4000	151.4400	12580.00	12580.00	0.00	37	7	37	317	0.116719242902208	0.510438515540091	0.510438515540091	true	false	false	true
41bfe322-b083-481d-82eb-7ba2d65a1ab6	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	USO	USO261009C00153000	call	153.0000	2026-10-09	5.5500	5.3500	5.6000	151.4400	37185.00	36630.00	0.00	67	15	167	302	0.552980132450331	0.50285108707429	0.50285108707429	true	false	false	true
a7cabb20-81fc-461b-883e-e7d0e4288722	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	USO	USO261009C00153000	call	153.0000	2026-10-09	5.4500	5.4500	5.7000	151.4600	37060.00	0.00	37060.00	68	20	85	302	0.281456953642384	0.493887283450224	0.493887283450224	false	false	false	true
3be1ef78-20b6-48b5-9031-2fa990518ed5	2026-09-24 09:33	2026-09-24 09:33	2026-09-24 09:33	USO	USO261120P00147000	put	147.0000	2026-11-20	9.0000	9.0000	9.3000	151.5100	14400.00	0.00	14400.00	16	5	19	134	0.141791044776119	0.490412863330771	0.491936024476012	false	false	false	true
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
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	true
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	true
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	true
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	true
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	true
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	true
081bd653-7140-425f-a68c-6804f6dbf285	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.4000	8.7500	148.9315	129215.00	3415.00	125800.00	152	18	1261	4444	0.283753375337534	0.486225758653892	0.484424999236917	false	false	false	true
eaa5ba6e-4177-4763-89d8-8ad9343a2850	2026-09-23 15:36	2026-09-23 15:36	2026-09-23 15:36	USO	USO261218C00135000	call	135.0000	2026-12-18	21.5300	21.2000	21.8000	148.9600	55980.00	53830.00	2150.00	26	5	240	1896	0.126582278481013	0.456266904857216	0.454191494671286	false	false	false	true
3322d1c3-a2e6-4e6d-810d-b00a240e2b51	2026-09-23 15:36	2026-09-23 15:36	2026-09-23 15:36	USO	USO261218C00165000	call	165.0000	2026-12-18	8.5200	8.4500	8.7500	148.9600	63930.00	30780.00	31450.00	75	25	722	4444	0.162466246624662	0.484023449413257	0.485823671239388	false	false	false	true
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	true
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	true
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
a52cc8b0-d3c6-4c3f-b667-c28050d4e7dc	2026-09-23 13:48	2026-09-23 13:48	2026-09-23 13:48	USO	USO260925P00145000	put	145.0000	2026-09-25	1.4400	1.4100	1.4600	147.7300	28833.00	28833.00	0.00	200	9	1803	3007	0.599600931160625	0.601862732657693	0.599330067755823	false	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	true