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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/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

5bf89741-5ae5-4b42-8155-5a41442d9800	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.0900	153.0000	29370.00	749.00	28514.00	277	49	3571	11696	0.30531805745554	0.557832051950838	0.559338502488517	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	Financial Services	1228364647.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
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
e960dc5c-4f96-4ce6-9993-f1befd0af5a8	2026-09-24 15:21	2026-09-24 15:21	2026-09-24 15:21	USO	USO260925C00155000	call	155.0000	2026-09-25	1.0500	1.1500	1.1900	153.0000	52280.00	0.00	52280.00	500	7	11068	1536	7.20572916666667	0.551511357034111	0.554808255150912	true	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
080f2e10-8f12-4975-a988-2e46dda715e3	2026-09-24 15:14	2026-09-24 15:14	2026-09-24 15:14	USO	USO280121P00120000	put	120.0000	2028-01-21	11.8800	11.5500	12.3000	153.2735	11884.00	8318.00	3566.00	10	6	3620	3761	0.962509970752459	0.461220225384015	0.46101684117381	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
8a6e71f7-45c6-46d0-b1b9-1760dba55d88	2026-09-24 14:53	2026-09-24 14:53	2026-09-24 14:53	USO	USO280121P00120000	put	120.0000	2028-01-21	12.1600	11.8500	12.6000	151.8195	20675.00	14580.00	6095.00	17	10	2569	3761	0.683063015155544	0.461380303246622	0.460571182981219	true	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
53da9eba-a894-44e6-b86e-08ae2270e71d	2026-09-24 14:26	2026-09-24 14:26	2026-09-24 14:26	USO	USO261009C00154000	call	154.0000	2026-10-09	5.3500	5.0500	5.3500	151.7201	12294.00	11764.00	530.00	23	9	130	158	0.822784810126582	0.511240734053541	0.511240734053541	true	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
51eceb01-9337-4cf1-93a7-2db4baaa704b	2026-09-24 14:17	2026-09-24 14:17	2026-09-24 14:17	USO	USO261120P00151000	put	151.0000	2026-11-20	10.8100	10.8000	10.9500	152.3900	15132.00	0.00	15132.00	14	5	146	71	2.05633802816901	0.500953148269492	0.501685761341946	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
4139afac-9ead-4ac7-84dd-f49220410d6b	2026-09-24 14:16	2026-09-24 14:16	2026-09-24 14:16	USO	USO261120P00149000	put	149.0000	2026-11-20	10.1500	9.8500	10.1500	151.8400	101466.00	101466.00	0.00	100	39	117	225	0.52	0.506384115901843	0.505526928733937	false	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
c13272bf-8913-4d3c-bdf5-4274ed05a083	2026-09-24 14:05	2026-09-24 14:04	2026-09-24 14:04	USO	USO280121P00121000	put	121.0000	2028-01-21	12.0800	11.8500	13.6500	153.0000	123265.00	1240.00	122025.00	102	10	134	405	0.330864197530864	0.460960438731127	0.452915127261866	false	false	false	true
a9a9f290-1d05-4362-9fb9-9d7e9a6c1d56	2026-09-24 14:05	2026-09-24 14:04	2026-09-24 14:04	USO	USO280121P00120000	put	120.0000	2028-01-21	11.9200	11.5500	14.5000	153.0000	41704.00	4745.00	25059.00	35	9	1626	3761	0.432331826641851	0.461071577047979	0.461274885957164	true	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
997babc5-a8a2-4436-96a2-cd4e165d176a	2026-09-24 13:38	2026-09-24 13:38	2026-09-24 13:38	USO	USO270115P00151000	put	151.0000	2027-01-15	14.2600	13.1500	15.2500	153.1750	14262.00	5700.00	8562.00	10	5	36	289	0.124567474048443	0.486662342737465	0.486057319608462	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
992352c7-c6fe-4c81-8ac9-18fb283efe88	2026-09-24 13:29	2026-09-24 13:29	2026-09-24 13:29	USO	USO261016P00146000	put	146.0000	2026-10-16	4.6500	4.5500	4.6500	152.6800	22320.00	22320.00	0.00	48	10	107	674	0.158753709198813	0.524585321059481	0.524585321059481	true	false	false	true
704c746f-0269-4a98-82cb-fdcc7acad200	2026-09-24 13:22	2026-09-24 13:22	2026-09-24 13:22	USO	USO261120C00173000	call	173.0000	2026-11-20	5.5500	5.5500	5.7500	152.1599	55500.00	0.00	55500.00	100	12	125	25	5	0.515329966282596	0.515329966282596	false	false	false	true
5d57a08d-ea41-45b8-becd-b796271d167a	2026-09-24 13:22	2026-09-24 13:22	2026-09-24 13:22	USO	USO261023C00162000	call	162.0000	2026-10-23	5.1000	4.9000	5.2000	152.1900	11730.00	2550.00	9180.00	23	5	33	111	0.297297297297297	0.510580990259077	0.510580990259077	true	false	false	true
4a57a84c-2b8c-4901-af0b-8206b30ab2e4	2026-09-24 13:19	2026-09-24 13:19	2026-09-24 13:19	USO	USO260925P00150000	put	150.0000	2026-09-25	1.1900	1.1700	1.2600	151.9300	10353.00	1547.00	8806.00	87	6	8091	2608	3.1023773006135	0.639409990620087	0.639409990620087	false	false	false	true
e7433b2e-463e-4cd1-b138-9b192a198ff3	2026-09-24 13:10	2026-09-24 13:10	2026-09-24 13:10	USO	USO270115P00140000	put	140.0000	2027-01-15	9.5000	9.2000	9.9000	151.9300	38000.00	0.00	38000.00	40	6	80	2872	0.0278551532033426	0.48077288942663	0.48077288942663	false	false	false	true
6ef2f0d3-f77e-40b0-b959-298ab262a55e	2026-09-24 13:09	2026-09-24 13:09	2026-09-24 13:09	USO	USO260930P00135000	put	135.0000	2026-09-30	0.3800	0.3300	0.3800	151.6500	11400.00	7030.00	0.00	300	7	470	8275	0.056797583081571	0.629754179714384	0.629754179714384	false	false	false	true
4fe4448a-6453-42d3-b200-43ca37d0e0dc	2026-09-24 13:09	2026-09-24 13:08	2026-09-24 13:08	USO	USO261120C00150000	call	150.0000	2026-11-20	12.8500	12.6500	12.8500	151.7000	12850.00	12850.00	0.00	10	9	239	4676	0.0511120615911035	0.487130502225334	0.484687989621221	true	false	false	true