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

6ec2740b-4d29-44d5-a477-d7339fb742cf	2026-09-25 09:32	2026-09-25 09:32	2026-09-25 09:32	USO	USO261016C00154000	call	154.0000	2026-10-16	5.6000	5.6000	5.9000	149.8899	12880.00	0.00	12880.00	23	7	24	215	0.111627906976744	0.504706907790846	0.504706907790846	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-25T13:33:47.828400Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
4af3c99f-68f3-488e-853c-71b8f5119c5e	2026-09-25 09:32	2026-09-25 09:32	2026-09-25 09:32	USO	USO261009C00153000	call	153.0000	2026-10-09	4.6900	4.6500	4.9000	149.8899	30510.00	0.00	30510.00	65	10	65	492	0.132113821138211	0.510120135891083	0.505807909874339	true	false	false	true
74d1b2b2-6556-4558-817d-34babf405afb	2026-09-25 09:32	2026-09-25 09:32	2026-09-25 09:32	USO	USO261002P00148000	put	148.0000	2026-10-02	3.4000	3.3500	3.6000	150.0000	34014.00	0.00	29594.00	100	22	116	573	0.202443280977312	0.531910076209023	0.531910076209023	true	false	false	true
e588af70-1b4d-4e0c-8e1e-79163697cd7c	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO261016P00149000	put	149.0000	2026-10-16	6.8500	6.8500	7.2000	149.8600	41785.00	0.00	41785.00	61	10	61	326	0.187116564417178	0.520983057331384	0.520983057331384	false	false	false	true
dc297fd3-3340-44e9-939d-49f7edd0ca9b	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO261016P00143000	put	143.0000	2026-10-16	4.2500	4.0500	4.5500	149.8600	31440.00	1265.00	30175.00	74	11	76	789	0.0963244613434728	0.52111660159708	0.51337104697302	true	false	false	true
aa847c19-a323-4995-aa13-2debabc606fa	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO261016P00146000	put	146.0000	2026-10-16	5.4500	5.4000	5.7500	149.8600	61590.00	1100.00	60490.00	113	24	115	701	0.164051355206847	0.520800598571746	0.520800598571746	true	false	false	true
15bb4682-32e7-46b0-9e20-345f68cc930a	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO261016P00145000	put	145.0000	2026-10-16	5.0000	5.0000	5.3000	149.8600	74000.00	0.00	74000.00	148	21	171	4705	0.0363443145589798	0.51878412639838	0.51878412639838	true	false	false	true
145029d0-5426-4aa8-aa94-be82eee7026d	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO261016P00150000	put	150.0000	2026-10-16	7.3500	7.3500	7.7000	149.8600	43365.00	0.00	43365.00	59	16	123	4119	0.0298616168973052	0.520374732395014	0.520374732395014	true	false	false	true
119d841a-26a4-40c9-81c0-a6c9d3b821cb	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO261023P00146000	put	146.0000	2026-10-23	6.4500	6.4000	6.8000	149.8600	45155.00	4520.00	36120.00	70	13	70	194	0.360824742268041	0.51697275877	0.51697275877	true	false	false	true
f289913d-7d16-4cee-b0e3-cb46a1bb0bc8	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO260930P00144000	put	144.0000	2026-09-30	1.5600	1.4800	2.1200	149.7700	30069.00	12244.00	17825.00	193	8	223	901	0.247502774694784	0.549046994603195	0.54727721003628	true	false	false	true
d388cf5f-9bc0-4921-9edd-931af3e240eb	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO261002C00152000	call	152.0000	2026-10-02	3.4500	3.4000	3.7000	149.7700	24150.00	0.00	24150.00	70	14	244	205	1.19024390243902	0.531347983941865	0.531347983941865	true	false	false	true
e39e16ab-5a23-4245-8b6e-c2a5692f4472	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO261002C00153000	call	153.0000	2026-10-02	3.0500	3.0000	3.8000	149.7300	37515.00	0.00	37515.00	123	26	124	300	0.413333333333333	0.53042926711703	0.53243893397005	true	false	false	true
d390bd3b-a310-4d64-b38d-2fa31fb1b9e7	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO261002C00152000	call	152.0000	2026-10-02	3.4500	3.4500	3.7000	149.7600	16560.00	0.00	16560.00	48	14	173	205	0.84390243902439	0.531884662102549	0.531884662102549	true	false	false	true
a6e7ef30-eee6-4541-84f4-64bfaa10326d	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO261002C00152000	call	152.0000	2026-10-02	3.4500	3.1500	3.7000	149.7300	43125.00	690.00	42435.00	125	25	125	205	0.609756097560976	0.531347983941865	0.533493293028387	true	false	false	true
0a2ee076-d45b-452b-a60a-2449ff7b0178	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO261002C00153000	call	153.0000	2026-10-02	3.0500	2.9600	3.3000	149.7600	19511.00	0.00	18901.00	64	19	189	300	0.63	0.530931960769634	0.519716614948751	true	false	false	true
253e1f64-e8ea-4588-8088-cf235e3265d2	2026-09-25 09:31	2026-09-25 09:30	2026-09-25 09:30	USO	USO260930P00150000	put	150.0000	2026-09-30	3.8000	3.6000	4.0000	149.8400	11400.00	760.00	10640.00	30	15	45	1399	0.0321658327376698	0.537517968810528	0.537517968810528	true	false	false	true
706c30bc-f853-4a01-9d16-9c12b1f08172	2026-09-25 09:30	2026-09-25 09:30	2026-09-25 09:30	USO	USO260925P00150000	put	150.0000	2026-09-25	1.4300	1.4300	1.7000	149.7700	10296.00	0.00	10296.00	72	13	287	4354	0.0659163987138264	0.826709880065146	0.807512240447365	false	false	false	true
105ec379-0a27-4a82-864b-d2112960ac1d	2026-09-24 15:59	2026-09-24 15:59	2026-09-24 15:59	USO	USO261016P00130000	put	130.0000	2026-10-16	1.0600	1.0600	1.1200	153.0000	13038.00	0.00	13038.00	123	5	3694	11696	0.315834473324213	0.557832051950838	0.557832051950838	true	false	false	true
f105be83-e043-420c-82fa-635e8cfacd57	2026-09-24 15:59	2026-09-24 15:58	2026-09-24 15:58	USO	USO261016P00150000	put	150.0000	2026-10-16	6.2000	6.1000	6.2000	153.0000	248000.00	248000.00	0.00	400	20	1415	3312	0.427234299516908	0.526518575034119	0.526518575034119	true	false	false	true
3a471dbd-eafe-4771-ae4e-9e747d5b1fb8	2026-09-24 15:40	2026-09-24 15:40	2026-09-24 15:40	USO	USO261016P00150000	put	150.0000	2026-10-16	6.2000	6.0500	6.2000	153.0000	12400.00	12400.00	0.00	20	5	1008	3312	0.304347826086957	0.52735219622726	0.52735219622726	false	false	false	true
e71cba85-51e0-4d94-9035-eb71e0a3c064	2026-09-24 15:20	2026-09-24 15:19	2026-09-24 15:19	USO	USO280121P00120000	put	120.0000	2028-01-21	11.9000	11.5500	12.0000	153.0000	11900.00	11900.00	0.00	10	6	3660	3761	0.973145440042542	0.462215487177317	0.462215487177317	false	false	false	true
3a1963a2-c455-4671-a47d-2c86fe7b9bd2	2026-09-24 15:16	2026-09-24 15:16	2026-09-24 15:16	USO	USO270617C00148000	call	148.0000	2027-06-17	26.5000	26.3000	26.8500	153.0000	13250.00	2650.00	10600.00	5	5	18	110	0.163636363636364	0.422105632252524	0.422105632252524	false	false	false	true
7e8feaf7-215b-4939-98bb-83c1fb9e9de6	2026-09-24 15:15	2026-09-24 15:15	2026-09-24 15:15	USO	USO280317P00130000	put	130.0000	2028-03-17	16.6000	15.1000	18.0500	153.0000	49800.00	29880.00	19920.00	30	5	211	910	0.231868131868132	0.458805282979886	0.458805282979886	false	false	false	true
0ccc857a-a2e0-4779-8d89-57c2863f2ca7	2026-09-24 15:15	2026-09-24 15:14	2026-09-24 15:14	USO	USO261016P00151000	put	151.0000	2026-10-16	6.5000	6.3000	6.5000	153.3200	11700.00	11700.00	0.00	18	11	137	449	0.305122494432071	0.522210762895659	0.522210762895659	false	false	false	true
84205a7f-8c18-4f23-8774-3ecc0814f450	2026-09-24 15:12	2026-09-24 15:11	2026-09-24 15:11	USO	USO280121P00121000	put	121.0000	2028-01-21	12.3000	10.3500	12.7000	152.9600	12300.00	2460.00	9840.00	10	5	212	405	0.523456790123457	0.461040029466404	0.461040029466404	false	false	false	true
2a1a9a21-e411-4f4c-b122-ada1fb0d7bca	2026-09-24 15:11	2026-09-24 15:11	2026-09-24 15:11	USO	USO261218C00148000	call	148.0000	2026-12-18	16.9400	16.3500	17.1000	152.8200	20330.00	20330.00	0.00	12	11	86	314	0.273885350318471	0.472765766925831	0.472765766925831	true	false	false	true
824842f5-9f8b-4a82-bb09-7eaf5568a2f9	2026-09-24 15:11	2026-09-24 15:11	2026-09-24 15:11	USO	USO261016C00158000	call	158.0000	2026-10-16	5.6000	5.5500	5.6000	152.7500	13440.00	13440.00	0.00	24	7	135	407	0.331695331695332	0.513185386528732	0.513185386528732	true	false	false	true
366fb3ec-a3fb-4995-8cb8-2ae27a27d8e4	2026-09-24 15:08	2026-09-24 15:08	2026-09-24 15:08	USO	USO261016C00156000	call	156.0000	2026-10-16	6.2500	6.2500	6.4000	152.7412	11875.00	0.00	11875.00	19	8	46	966	0.0476190476190476	0.50394880972067	0.50394880972067	false	false	false	true
660d5202-9a99-4c9e-bda6-52dabcc2a1d4	2026-09-24 15:04	2026-09-24 15:04	2026-09-24 15:04	USO	USO260925C00152000	call	152.0000	2026-09-25	2.4000	2.1100	2.4000	152.8075	15120.00	15120.00	0.00	63	5	5086	716	7.10335195530726	0.616080524937881	0.616080524937881	true	false	false	true
49828a53-f611-4ae5-8591-c3ba05fbec9f	2026-09-24 15:00	2026-09-24 15:00	2026-09-24 15:00	USO	USO261218P00140000	put	140.0000	2026-12-18	8.0500	8.0000	8.1000	152.0250	80500.00	79695.00	0.00	100	19	575	5397	0.106540670743005	0.491709463519883	0.491709463519883	false	false	false	true
1703fafb-76ab-4911-9edf-1d786f044496	2026-09-24 14:57	2026-09-24 14:57	2026-09-24 14:57	USO	USO261030C00170000	call	170.0000	2026-10-30	3.9500	3.8500	4.0500	151.8100	19750.00	8690.00	3950.00	50	6	119	430	0.276744186046512	0.520680782538486	0.520680782538486	false	false	false	true
dac31118-bdeb-4060-8506-eb9e06c14de6	2026-09-24 14:56	2026-09-24 14:56	2026-09-24 14:56	USO	USO280121P00120000	put	120.0000	2028-01-21	12.3000	12.3000	12.5250	151.8858	12300.00	0.00	12300.00	10	5	3035	3761	0.806966232385004	0.463876473774377	0.463876473774377	false	false	false	true
4ff4af45-c7d5-4bb6-8661-852d22caf44c	2026-09-24 14:38	2026-09-24 14:38	2026-09-24 14:38	USO	USO261009C00154000	call	154.0000	2026-10-09	5.4900	5.2500	5.5000	151.7500	18120.00	18120.00	0.00	33	7	165	158	1.04430379746835	0.522347151789938	0.522347151789938	true	false	false	true
894676bd-b305-439b-bae5-05ced21e969e	2026-09-24 14:35	2026-09-24 14:35	2026-09-24 14:35	USO	USO261120C00160000	call	160.0000	2026-11-20	9.1000	8.9000	9.2000	152.2200	13645.00	12740.00	905.00	15	10	342	1865	0.183378016085791	0.497490486287928	0.497490486287928	true	false	false	true
cd889484-d965-42b8-b4e4-0a65f1a1baa8	2026-09-24 14:33	2026-09-24 14:33	2026-09-24 14:33	USO	USO260930P00150000	put	150.0000	2026-09-30	3.0500	2.9700	3.0500	152.2046	11895.00	11895.00	0.00	39	9	1216	518	2.34749034749035	0.530633599406968	0.530633599406968	false	false	false	true
de0c94f1-d3c2-4794-b5ee-20196d9d25c6	2026-09-24 14:30	2026-09-24 14:29	2026-09-24 14:29	USO	USO260925C00153000	call	153.0000	2026-09-25	1.5500	1.5000	1.5500	152.2800	33325.00	33325.00	0.00	215	5	4399	2348	1.87350936967632	0.590120591701884	0.590120591701884	true	false	false	true
387df98e-0c3e-4153-9134-b03c451ed669	2026-09-24 14:28	2026-09-24 14:28	2026-09-24 14:28	USO	USO280121P00120000	put	120.0000	2028-01-21	12.0800	12.0000	13.1000	152.1426	12080.00	9664.00	2416.00	10	5	1821	3761	0.484179739431002	0.460480051072021	0.460480051072021	false	false	false	true
51854df3-1d7b-4b96-823c-0e4e1ab6e7ff	2026-09-24 14:18	2026-09-24 14:17	2026-09-24 14:17	USO	USO261120P00149000	put	149.0000	2026-11-20	9.8000	9.6000	9.8000	152.3900	98000.00	98000.00	0.00	100	13	321	225	1.42666666666667	0.500972090039249	0.500972090039249	false	false	false	true
892b6fb6-fe32-4236-b02c-8dc5dd783854	2026-09-24 14:17	2026-09-24 14:17	2026-09-24 14:17	USO	USO261016C00169000	call	169.0000	2026-10-16	2.4300	2.3500	2.4300	152.1200	21627.00	21627.00	0.00	89	7	95	299	0.317725752508361	0.519888838815219	0.519888838815219	false	false	false	true
1f0fbad7-9c9c-4145-b279-3abb1951b010	2026-09-24 14:17	2026-09-24 14:17	2026-09-24 14:17	USO	USO261120P00149000	put	149.0000	2026-11-20	10.1500	9.8500	10.1500	152.0865	101500.00	101500.00	0.00	100	9	217	225	0.964444444444444	0.510704633777264	0.510704633777264	false	false	false	true
f36002e4-376d-4bce-823e-b92e181ea62f	2026-09-24 14:17	2026-09-24 14:17	2026-09-24 14:17	USO	USO261023P00144500	put	144.5000	2026-10-23	5.0500	5.0500	5.1500	152.0400	13130.00	0.00	13130.00	26	9	129	58	2.22413793103448	0.508366197137759	0.508366197137759	true	false	false	true
8300ec1b-342f-4836-8a71-4613529ca1b5	2026-09-24 14:17	2026-09-24 14:17	2026-09-24 14:17	USO	USO261023P00139500	put	139.5000	2026-10-23	3.4500	3.4000	3.5500	152.0400	11040.00	0.00	11040.00	32	7	60	164	0.365853658536585	0.513494597608841	0.513494597608841	true	false	false	true
84cde2eb-2062-435c-b479-2de328afacc5	2026-09-24 14:16	2026-09-24 14:16	2026-09-24 14:16	USO	USO260925P00150000	put	150.0000	2026-09-25	1.1900	1.1300	1.1900	151.8400	23800.00	23800.00	0.00	200	26	8886	2608	3.40720858895706	0.628790066095563	0.628790066095563	true	false	false	true
34560145-b00a-4396-865c-5b12e3b04f87	2026-09-24 14:15	2026-09-24 14:14	2026-09-24 14:14	USO	USO280121P00120000	put	120.0000	2028-01-21	12.1000	12.0000	12.5000	152.0618	13310.00	10890.00	2420.00	11	5	1690	3761	0.449348577505982	0.460554074442456	0.460554074442456	false	false	false	true
be0c66b0-2c6e-4ebb-adb4-cc0ec9abb511	2026-09-24 13:52	2026-09-24 13:52	2026-09-24 13:52	USO	USO261009P00159000	put	159.0000	2026-10-09	9.4500	9.4000	9.7000	153.0000	12288.00	945.00	10398.00	13	10	22	103	0.213592233009709	0.519094514568957	0.519094514568957	true	false	false	true
efd4b4fa-17cd-4165-adf5-d2ff9ee0d500	2026-09-24 13:46	2026-09-24 13:46	2026-09-24 13:46	USO	USO280121P00121000	put	121.0000	2028-01-21	12.1500	10.3500	12.1500	153.0000	13365.00	13365.00	0.00	11	5	22	405	0.054320987654321	0.46128014354164	0.46128014354164	false	false	false	true
be9840c5-6d5e-4894-9b06-6a4fd84188b7	2026-09-24 13:44	2026-09-24 13:44	2026-09-24 13:44	USO	USO261009P00149000	put	149.0000	2026-10-09	4.2500	4.1000	4.2500	153.0000	12325.00	12325.00	0.00	29	10	52	119	0.436974789915966	0.525646386241611	0.525646386241611	true	false	false	true
9fa59a07-cf66-43b6-a9d0-1e08327deef4	2026-09-24 13:44	2026-09-24 13:44	2026-09-24 13:44	USO	USO260925C00155000	call	155.0000	2026-09-25	1.2900	1.2500	1.2900	153.0000	19350.00	19350.00	0.00	150	7	9010	1536	5.86588541666667	0.596084410199401	0.596084410199401	false	false	false	true
7f3dbcfe-5b7f-4402-941d-d951dbc82f52	2026-09-24 13:38	2026-09-24 13:38	2026-09-24 13:38	USO	USO260925C00155000	call	155.0000	2026-09-25	1.1600	1.1100	1.1600	153.1700	58000.00	58000.00	0.00	500	7	8673	1536	5.646484375	0.600754082639004	0.600754082639004	false	false	false	true
d7da09cb-607f-428c-afcd-1bc7f0a8c848	2026-09-24 13:29	2026-09-24 13:29	2026-09-24 13:29	USO	USO261023P00150000	put	150.0000	2026-10-23	7.3000	7.1500	7.3000	152.6800	22630.00	22630.00	0.00	31	7	87	130	0.669230769230769	0.517639116192431	0.517639116192431	false	false	false	true