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 = RepeatedHitsDescendingFill×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

8bee71da-4516-4ffc-ae63-7a9ea9aa85cd	2026-09-16 15:58	2026-09-16 15:58	2026-09-16 15:58	USO	USO280317P00150000	put	150.0000	2028-03-17	26.2100	25.9500	27.5000	156.0000	28830.00	2620.00	26210.00	11	7	16	828	0.0193236714975845	0.473665722646613	0.472930585922976	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	Financial Services	1228364647.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
2a056d3b-e2ad-4f60-899a-f7007a50786b	2026-09-16 15:52	2026-09-16 15:52	2026-09-16 15:52	USO	USO260918C00156000	call	156.0000	2026-09-18	2.5300	2.3000	2.6000	155.0000	28128.00	25422.00	2706.00	111	14	746	1424	0.523876404494382	0.567451774169141	0.537046454548506	true	false	false	true
2ab8a14d-45b1-4589-bc0d-c4996a654413	2026-09-16 14:50	2026-09-16 14:50	2026-09-16 14:50	USO	USO280616C00205000	call	205.0000	2028-06-16	21.8000	21.8000	23.7000	156.5350	174402.00	0.00	174402.00	80	5	220	93	2.36559139784946	0.397065445151352	0.397065445151352	false	false	false	true
1661757f-1ba0-43b8-ac52-066414985149	2026-09-16 14:50	2026-09-16 14:50	2026-09-16 14:50	USO	USO280121C00305000	call	305.0000	2028-01-21	6.0700	4.0500	6.2000	156.5350	10315.00	7890.00	2425.00	17	7	17	25	0.68	0.438873583977384	0.437808341571085	false	false	false	true
18a6bed0-9a39-4e65-a21b-a267417535ac	2026-09-16 14:36	2026-09-16 14:35	2026-09-16 14:35	USO	USO261002C00175000	call	175.0000	2026-10-02	2.0200	1.5900	2.0300	157.1744	42796.00	40793.00	2003.00	212	29	223	231	0.965367965367965	0.568260502949286	0.569333749233373	true	false	false	true
98c81034-6d8f-43d8-a586-e35cda98972b	2026-09-16 13:57	2026-09-16 13:57	2026-09-16 13:57	USO	USO270319P00100000	put	100.0000	2027-03-19	2.4300	2.2800	2.4400	156.0000	48640.00	11218.00	37422.00	200	10	1602	5218	0.307014181678804	0.537040686004628	0.533290871947103	false	false	false	true
b79b187a-a551-4d4c-8603-66c73f554a26	2026-09-16 12:14	2026-09-16 12:13	2026-09-16 12:13	USO	USO270319C00230000	call	230.0000	2027-03-19	6.4100	6.4000	7.4500	156.7199	80707.00	0.00	80707.00	126	18	162	1673	0.0968320382546324	0.535319942798473	0.534182363520757	true	false	false	true
95830d08-41d7-4dc9-8467-e73784453c4b	2026-09-16 11:47	2026-09-16 11:47	2026-09-16 11:47	USO	USO261218C00175000	call	175.0000	2026-12-18	11.1100	10.3500	11.1500	156.9900	549993.00	506898.00	43095.00	495	54	539	1945	0.277120822622108	0.546390915128309	0.544771333766388	true	false	false	true
a168278c-d1e8-438b-8431-179eab2ba48e	2026-09-16 11:33	2026-09-16 11:32	2026-09-16 11:32	USO	USO260916C00157500	call	157.5000	2026-09-16	0.4100	0.3900	0.4800	156.4154	10048.00	4332.00	5002.00	244	30	696	64	10.875	0.603950031268039	0.597031329662815	true	false	false	true
9a8ffde5-af40-402e-b06b-d0767570a1da	2026-09-16 11:29	2026-09-16 11:29	2026-09-16 11:29	USO	USO280121C00220000	call	220.0000	2028-01-21	14.5500	12.5500	14.5500	155.9701	123640.00	123640.00	0.00	85	6	85	167	0.508982035928144	0.41192099186706	0.41192099186706	true	false	false	true
354730eb-3641-4701-982c-a196702f9a90	2026-09-16 11:04	2026-09-16 11:04	2026-09-16 11:04	USO	USO260923C00157500	call	157.5000	2026-09-23	3.8100	3.8000	5.9000	156.1710	12575.00	0.00	12575.00	33	5	33	20	1.65	0.507951978925312	0.507951978925312	false	false	false	true
17ee7424-b403-4c6d-a448-f71faaaadc4b	2026-09-16 10:38	2026-09-16 10:37	2026-09-16 10:37	USO	USO261030P00153000	put	153.0000	2026-10-30	8.9500	8.1500	8.9500	158.0000	85907.00	85017.00	890.00	96	7	160	19	8.42105263157895	0.540604007492393	0.538220197755426	true	false	false	true
d4a01a78-36ad-4586-9832-d6ea95b115b5	2026-09-16 10:04	2026-09-16 10:04	2026-09-16 10:04	USO	USO260925C00166000	call	166.0000	2026-09-25	2.8800	2.6400	2.9500	159.0200	105116.00	96191.00	5469.00	365	44	387	598	0.647157190635452	0.555191055821356	0.555191055821356	true	false	false	true
092bdc30-6255-4d3b-b2d5-f2d29cdfa42d	2026-09-16 10:03	2026-09-16 10:03	2026-09-16 10:03	USO	USO261016C00155000	call	155.0000	2026-10-16	11.8000	11.2000	11.8000	158.7700	94373.00	94373.00	0.00	80	12	86	2737	0.031421264157837	0.533945611814222	0.531556609624869	true	false	false	true
bdf64ca9-5fe0-471c-bc63-f9353a3c9a94	2026-09-16 10:02	2026-09-16 10:02	2026-09-16 10:02	USO	USO290119C00280000	call	280.0000	2029-01-19	14.1700	14.0000	15.6000	158.4299	79336.00	0.00	79336.00	56	8	56	0	0	0.384338332520226	0.384338332520226	false	false	false	true
a0829bf5-3748-4c76-9210-db97e11f46ef	2026-09-16 09:59	2026-09-16 09:59	2026-09-16 09:59	USO	USO261009P00150000	put	150.0000	2026-10-09	4.5400	4.3500	4.8500	158.3800	68042.00	0.00	68042.00	150	17	163	461	0.353579175704989	0.534594479056334	0.534594479056334	false	false	false	true
93388a98-3655-4766-aab8-439e9d783c74	2026-09-16 09:53	2026-09-16 09:53	2026-09-16 09:53	USO	USO260930C00163000	call	163.0000	2026-09-30	4.7500	4.7500	5.8000	158.3300	19962.00	0.00	19962.00	42	6	42	44	0.954545454545455	0.537814679007689	0.537814679007689	false	false	false	true
a684e122-0007-491f-9960-19d835e2758d	2026-09-16 09:43	2026-09-16 09:43	2026-09-16 09:43	USO	USO270115P00122000	put	122.0000	2027-01-15	4.0700	3.8000	4.4500	158.5036	10577.00	0.00	10577.00	26	6	26	497	0.0523138832997988	0.525253323598413	0.525253323598413	false	false	false	true
fb3cb420-a61f-4570-ad8b-4f90a3a77898	2026-09-16 09:39	2026-09-16 09:38	2026-09-16 09:38	USO	USO260925P00151000	put	151.0000	2026-09-25	2.2000	2.0300	2.2900	158.6800	17184.00	8642.00	8542.00	78	10	97	134	0.723880597014925	0.539450858228391	0.540684551006621	true	false	false	true
5ea03142-b3f0-4908-9e9a-d4ae468ca011	2026-09-16 09:39	2026-09-16 09:38	2026-09-16 09:38	USO	USO260925P00152000	put	152.0000	2026-09-25	2.4900	2.1500	2.5800	158.6800	23862.00	12009.00	11853.00	96	10	96	368	0.260869565217391	0.537946048647586	0.53912435856858	true	false	false	true
a0f06760-32f1-47d2-a03e-2ec9150bcca1	2026-09-16 09:38	2026-09-16 09:38	2026-09-16 09:38	USO	USO260923C00185000	call	185.0000	2026-09-23	0.3500	0.0700	0.3500	158.7900	34950.00	33225.00	850.00	1000	16	1000	561	1.7825311942959	0.675199950831666	0.675199950831666	true	false	false	true
2a75adcb-f164-4f7d-9412-a4a9ba5c4691	2026-09-16 09:34	2026-09-16 09:34	2026-09-16 09:34	USO	USO260916P00159000	put	159.0000	2026-09-16	1.1200	1.0200	1.1300	158.9900	15097.00	13773.00	428.00	135	36	178	732	0.243169398907104	0.650526467481735	0.650526467481735	true	false	false	true
638d15fe-4155-432e-9911-a1d21c117e55	2026-09-16 09:34	2026-09-16 09:34	2026-09-16 09:34	USO	USO260925P00150000	put	150.0000	2026-09-25	1.8300	1.7800	2.0300	159.0000	25967.00	727.00	25240.00	142	13	163	3585	0.0454672245467225	0.535551659718906	0.52889844721064	false	false	false	true
30242a61-38a5-429a-88fc-5eea9ee44e17	2026-09-16 09:32	2026-09-16 09:32	2026-09-16 09:32	USO	USO261016C00170000	call	170.0000	2026-10-16	6.1500	6.1000	6.6000	159.1150	93545.00	1865.00	91680.00	152	27	170	3952	0.0430161943319838	0.563573161508178	0.560690461826375	true	false	false	true
a4ca5936-04c0-41fe-b1a9-64ca179a6a7e	2026-09-15 15:02	2026-09-15 15:02	2026-09-15 15:02	USO	USO270319C00225000	call	225.0000	2027-03-19	8.0000	8.0000	8.3500	161.4600	68040.00	0.00	68040.00	85	10	105	539	0.194805194805195	0.527206541289692	0.525869496152422	true	false	false	true
9d2e010c-b17a-4a9a-b5cc-4de131576180	2026-09-15 14:40	2026-09-15 14:40	2026-09-15 14:40	USO	USO261120C00155000	call	155.0000	2026-11-20	18.9900	18.3000	19.0000	162.2400	474650.00	474650.00	0.00	250	11	1027	1918	0.535453597497393	0.539893815580625	0.53912229693909	true	false	false	true
b8c99b78-f236-4db1-8168-ecbbcdecf1e6	2026-09-15 14:18	2026-09-15 14:18	2026-09-15 14:18	USO	USO270319C00230000	call	230.0000	2027-03-19	7.5100	7.5000	8.0000	161.9650	117156.00	2265.00	114891.00	156	12	258	1655	0.155891238670695	0.531154023755949	0.53005766375757	true	false	false	true
031d600b-b12a-432e-bf46-58f07f823c8b	2026-09-15 14:09	2026-09-15 14:08	2026-09-15 14:08	USO	USO261030P00160000	put	160.0000	2026-10-30	11.2800	11.0500	11.3500	162.3100	28199.00	28199.00	0.00	25	5	401	105	3.81904761904762	0.571381614320852	0.566448981874889	false	false	false	true
bb04173c-77d9-471d-a664-ea5549b48573	2026-09-15 13:55	2026-09-15 13:55	2026-09-15 13:55	USO	USO290119P00020000	put	20.0000	2029-01-19	0.5600	0.5500	3.4500	163.0600	23138.00	0.00	23138.00	413	11	458	0	0	0.768988655097322	0.74719833717574	false	false	false	true
885ad3d4-6e0d-44b8-9dae-97f2449db4b0	2026-09-15 13:55	2026-09-15 13:55	2026-09-15 13:55	USO	USO280616C00185000	call	185.0000	2028-06-16	31.0000	31.0000	31.9000	163.0540	120918.00	0.00	120918.00	39	5	103	568	0.181338028169014	0.397452324849596	0.397452324849596	false	false	false	true
c91896cf-de53-421d-9f29-35617589e4be	2026-09-15 13:43	2026-09-15 13:43	2026-09-15 13:43	USO	USO280317P00167000	put	167.0000	2028-03-17	32.9100	32.8000	34.5000	162.8750	250093.00	0.00	250093.00	76	8	76	0	0	0.473767559235412	0.473364763339061	false	false	false	true
4b2084a4-7b2b-4c52-a022-c9789d170ba3	2026-09-15 13:38	2026-09-15 13:38	2026-09-15 13:38	USO	USO260923C00166000	call	166.0000	2026-09-23	4.4500	4.4500	4.7000	162.7600	18691.00	0.00	18691.00	42	22	196	150	1.30666666666667	0.606032229784793	0.604977633263706	true	false	false	true
b49d94dc-124e-48cf-a033-51c1e2de3e8b	2026-09-15 12:48	2026-09-15 12:48	2026-09-15 12:48	USO	USO270617C00170000	call	170.0000	2027-06-17	23.6300	22.1000	23.9000	162.1848	61446.00	35475.00	23606.00	26	13	36	347	0.103746397694524	0.44092268605638	0.440021753386582	true	false	false	true
dee0398d-eb52-4430-9dfc-09edcc82dd2c	2026-09-15 11:32	2026-09-15 11:32	2026-09-15 11:32	USO	USO261120P00160000	put	160.0000	2026-11-20	14.1800	14.1500	14.5000	160.4600	15600.00	0.00	5665.00	11	11	238	318	0.748427672955975	0.555474753242737	0.553613789113028	false	false	false	true
971bc1b2-4e3d-451c-bb51-ebc10283f5d6	2026-09-15 11:20	2026-09-15 11:19	2026-09-15 11:19	USO	USO261120P00150000	put	150.0000	2026-11-20	9.2300	9.1500	9.3000	160.4800	138387.00	138387.00	0.00	150	6	509	1364	0.37316715542522	0.545787001049586	0.545787001049586	false	false	false	true
3f543a53-0a44-4c38-9660-0a24bad961d7	2026-09-15 10:51	2026-09-15 10:51	2026-09-15 10:51	USO	USO260923C00162000	call	162.0000	2026-09-23	5.0000	4.6000	5.0000	160.7300	18985.00	17500.00	1485.00	38	25	191	206	0.927184466019418	0.586005821048925	0.582433699639661	true	false	false	true
096b7356-7a1e-4481-b470-5651d91fa869	2026-09-15 10:51	2026-09-15 10:51	2026-09-15 10:51	USO	USO260916C00160000	call	160.0000	2026-09-16	2.6900	2.5300	2.7000	160.6200	11046.00	9713.00	1333.00	41	13	2655	2690	0.986988847583643	0.704380734678305	0.701375288318113	true	false	false	true
03342c19-43bc-4216-8988-f49c32a49446	2026-09-15 10:51	2026-09-15 10:51	2026-09-15 10:51	USO	USO260925C00159000	call	159.0000	2026-09-25	7.0900	6.4500	7.1000	160.6200	18445.00	17740.00	705.00	26	16	136	32	4.25	0.584547531359074	0.579769062029118	true	false	false	true
6acff978-0b45-411b-b0dd-ab50c1824548	2026-09-15 10:23	2026-09-15 10:23	2026-09-15 10:23	USO	USO261030C00220000	call	220.0000	2026-10-30	1.7400	1.5000	1.7400	159.5200	18760.00	18092.00	668.00	108	18	109	328	0.332317073170732	0.664355628303945	0.656635694709022	false	false	false	true
cf9815e3-884d-4ec4-8828-0c7120dbd87e	2026-09-15 10:09	2026-09-15 10:09	2026-09-15 10:09	USO	USO260918C00158000	call	158.0000	2026-09-18	4.1000	3.7500	4.1000	159.1600	12702.00	12702.00	0.00	31	16	88	1086	0.0810313075506446	0.603563990014133	0.603563990014133	true	false	false	true
11a57c0d-a3af-4f26-aa27-dceb93d2dc2e	2026-09-15 09:43	2026-09-15 09:43	2026-09-15 09:43	USO	USO260918C00157000	call	157.0000	2026-09-18	4.8500	4.4500	4.9000	159.2700	51875.00	50905.00	970.00	107	20	117	1636	0.0715158924205379	0.624417736781758	0.624417736781758	true	false	false	true
f57e0736-396e-4102-a33e-58c2a5859ad2	2026-09-15 09:32	2026-09-15 09:32	2026-09-15 09:32	USO	USO260916C00160000	call	160.0000	2026-09-16	1.8900	1.8700	2.0000	159.2600	22068.00	2702.00	19366.00	117	9	225	2690	0.0836431226765799	0.688055505210277	0.688055505210277	true	false	false	true
051f6f8b-ce41-452f-a018-b2d06908e14e	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	USO	USO260923C00162000	call	162.0000	2026-09-23	2.9800	2.6100	2.9900	155.5200	38142.00	36355.00	297.00	128	19	164	16	10.25	0.561690087635378	0.560574462922526	true	false	false	true
8c846b81-2bc6-4f75-bc4d-b78e2545e0fa	2026-09-14 15:00	2026-09-14 15:00	2026-09-14 15:00	USO	USO260925C00156000	call	156.0000	2026-09-25	5.8000	5.4000	5.8000	155.5500	73069.00	73069.00	0.00	126	29	155	101	1.53465346534653	0.553208090067534	0.550359227879521	true	false	false	true
dae4b5fb-eee0-4996-ada3-93fd215e71ed	2026-09-14 14:58	2026-09-14 14:58	2026-09-14 14:58	USO	USO260925C00157000	call	157.0000	2026-09-25	5.2500	5.1000	5.3000	155.3700	41471.00	40946.00	525.00	79	35	104	89	1.1685393258427	0.550071726972175	0.550071726972175	true	false	false	true
cca68137-4704-48b7-b765-d155bb95d610	2026-09-14 14:58	2026-09-14 14:58	2026-09-14 14:58	USO	USO260923C00157000	call	157.0000	2026-09-23	4.5400	4.1000	4.6000	155.3700	15445.00	14990.00	0.00	34	14	114	457	0.24945295404814	0.537612137672651	0.537612137672651	true	false	false	true
98ea54d6-3986-4962-af3b-247e850f2aa0	2026-09-14 14:24	2026-09-14 14:24	2026-09-14 14:24	USO	USO280616C00315000	call	315.0000	2028-06-16	6.5700	6.1500	6.6000	156.3100	36815.00	34235.00	2580.00	56	7	61	109	0.559633027522936	0.400011118834149	0.397268935807441	false	false	false	true
9935e477-529e-4d8a-b09c-92fbdd3b72a8	2026-09-14 13:36	2026-09-14 13:36	2026-09-14 13:36	USO	USO260923P00148000	put	148.0000	2026-09-23	2.2700	2.0500	2.3400	156.0250	16149.00	15925.00	224.00	71	5	82	123	0.666666666666667	0.568877559761703	0.568877559761703	true	false	false	true
f1b2e9e1-df82-4f8a-8bb0-4be037bf49ad	2026-09-14 13:05	2026-09-14 13:05	2026-09-14 13:05	USO	USO260916P00154000	put	154.0000	2026-09-16	1.9500	1.7700	1.9900	156.3200	24975.00	12584.00	12391.00	128	10	4958	330	15.0242424242424	0.655080148557914	0.64819806723696	true	false	false	true
5bd9e5bd-7cf8-455f-ae1e-dfa04d6fef37	2026-09-14 13:00	2026-09-14 13:00	2026-09-14 13:00	USO	USO261120P00159000	put	159.0000	2026-11-20	15.5100	15.5000	15.8500	156.0750	10859.00	0.00	10859.00	7	5	15	0	0	0.547103799667468	0.547103799667468	false	false	false	true