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

5a536522-cb83-4ef0-92d6-744e33f520da	2026-09-14 12:57	2026-09-14 12:57	2026-09-14 12:57	USO	USO260925C00150000	call	150.0000	2026-09-25	9.3900	8.9000	9.4000	155.5400	13150.00	12215.00	935.00	14	14	115	998	0.115230460921844	0.582544699176248	0.574104938803211	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	Financial Services	1228364647.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
07471c8d-1061-4969-b17b-ed15cb6c6586	2026-09-14 12:52	2026-09-14 12:52	2026-09-14 12:52	USO	USO260916C00158000	call	158.0000	2026-09-16	2.1500	2.0100	2.3000	156.0100	10960.00	4299.00	6661.00	51	5	1649	266	6.19924812030075	0.653218218990241	0.644292023779347	true	false	false	true
ef436956-3021-406d-bde9-b062ca29bc18	2026-09-14 12:50	2026-09-14 12:50	2026-09-14 12:50	USO	USO261016C00195000	call	195.0000	2026-10-16	2.1700	1.9900	2.2100	156.1900	12596.00	6932.00	5664.00	58	6	84	593	0.141652613827993	0.652700994832202	0.653624587889257	false	false	false	true
ae1c9cb8-24c9-4993-b417-cb06248ea174	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	USO	USO261009P00150000	put	150.0000	2026-10-09	6.0900	5.2500	6.1000	155.9300	46880.00	45680.00	1200.00	77	8	127	157	0.808917197452229	0.559259329532709	0.55271111342173	true	false	false	true
da54cafc-f617-4f90-8750-5713aa4fabb5	2026-09-14 12:47	2026-09-14 12:47	2026-09-14 12:47	USO	USO261023P00145000	put	145.0000	2026-10-23	5.5000	5.0500	5.5500	157.1100	16490.00	15945.00	545.00	30	10	42	124	0.338709677419355	0.544441054581508	0.54157820819971	true	false	false	true
ae2aa1b9-ce26-408b-ad1d-28ad843f6d3f	2026-09-14 12:47	2026-09-14 12:47	2026-09-14 12:47	USO	USO261023P00149000	put	149.0000	2026-10-23	7.0800	6.5000	7.1000	157.1100	13460.00	11345.00	2115.00	19	11	19	89	0.213483146067416	0.549315796254418	0.546661789214442	true	false	false	true
18928106-68e2-4ebf-baf6-c184759724ed	2026-09-14 11:29	2026-09-14 11:29	2026-09-14 11:29	USO	USO270319C00193000	call	193.0000	2027-03-19	11.8300	10.2000	12.0000	159.1400	72170.00	48540.00	8225.00	61	10	62	61	1.01639344262295	0.483705198152448	0.481380235646635	true	false	false	true
7e5985e2-33e7-4387-98ea-0a41deb26421	2026-09-14 11:06	2026-09-14 11:06	2026-09-14 11:06	USO	USO261120P00140000	put	140.0000	2026-11-20	6.2000	6.2000	6.7500	156.6700	59550.00	0.00	59550.00	96	5	368	2323	0.158415841584158	0.527365705729813	0.524589229618349	false	false	false	true
bbeeb3d1-10be-4561-884d-d5b4008d46f3	2026-09-14 10:09	2026-09-14 10:09	2026-09-14 10:09	USO	USO260925P00160000	put	160.0000	2026-09-25	7.1100	6.8000	7.1500	159.4750	35545.00	35545.00	0.00	50	5	122	82	1.48780487804878	0.631713994452471	0.61721858182501	false	false	false	true
abd0bc43-36b3-49f0-aef0-5f604f1d253f	2026-09-14 10:09	2026-09-14 10:09	2026-09-14 10:09	USO	USO260925P00160000	put	160.0000	2026-09-25	7.1800	6.8000	7.2000	159.4400	35903.00	35903.00	0.00	50	21	72	82	0.878048780487805	0.634702770210327	0.617486754930454	false	false	false	true
32f6ffb7-565a-4bd8-bf15-b36b8078e5fb	2026-09-14 09:48	2026-09-14 09:48	2026-09-14 09:48	USO	USO261120P00150000	put	150.0000	2026-11-20	9.3600	9.2000	9.5000	159.5000	46780.00	37430.00	0.00	50	5	76	852	0.0892018779342723	0.534668908473933	0.533469310117005	false	false	false	true
43ef1103-e5ba-4745-8e4c-d141260b86c4	2026-09-14 09:41	2026-09-14 09:41	2026-09-14 09:41	USO	USO260925C00165000	call	165.0000	2026-09-25	4.7000	4.4500	4.7500	159.0000	66250.00	57800.00	4690.00	141	24	157	333	0.471471471471471	0.632943259765347	0.632007791938246	true	false	false	true
a2a624bf-4baf-4501-bcc6-b4b224a7b253	2026-09-11 15:58	2026-09-11 15:58	2026-09-11 15:58	USO	USO261016P00155000	put	155.0000	2026-10-16	10.1500	10.1500	10.4000	154.8700	401005.00	0.00	401005.00	395	7	791	976	0.810450819672131	0.545090738165582	0.545090738165582	false	false	false	true
fa76d8c5-a7b5-428e-a8e5-c8fc23597f69	2026-09-11 15:49	2026-09-11 15:49	2026-09-11 15:49	USO	USO261016P00125000	put	125.0000	2026-10-16	1.0900	1.0900	1.1300	154.8200	28781.00	0.00	28781.00	264	23	1466	11896	0.123234700739744	0.546897210144578	0.545556784943601	false	false	false	true
1f43d5f2-ca9b-45fd-86fb-6a45f1246ae3	2026-09-11 15:49	2026-09-11 15:49	2026-09-11 15:49	USO	USO261016P00125000	put	125.0000	2026-10-16	1.0900	1.0900	1.1300	154.8200	18641.00	111.00	18530.00	171	12	1202	11896	0.101042367182246	0.548232246976184	0.545556784943601	false	false	false	true
345edd2e-f18d-4178-8587-f048eaf4899a	2026-09-11 14:52	2026-09-11 14:52	2026-09-11 14:52	USO	USO260923C00157000	call	157.0000	2026-09-23	5.5900	5.2500	5.6000	154.7200	206995.00	206995.00	0.00	370	21	474	20	23.7	0.584914662658856	0.584914662658856	true	false	false	true
5a741f09-13cc-4910-b1b1-9a2408441b87	2026-09-11 14:45	2026-09-11 14:45	2026-09-11 14:45	USO	USO261002C00159000	call	159.0000	2026-10-02	6.7500	6.2500	6.8000	154.5600	18890.00	16200.00	2690.00	28	12	36	12	3	0.576936968472364	0.576936968472364	true	false	false	true
0e12d8ab-e63d-480b-9afb-c5df75e2e22b	2026-09-11 14:44	2026-09-11 14:44	2026-09-11 14:44	USO	USO261009C00145000	call	145.0000	2026-10-09	14.4900	13.8500	14.5000	154.3500	24635.00	23195.00	1440.00	17	15	119	402	0.296019900497512	0.530601144783409	0.530601144783409	true	false	false	true
7867cc82-c946-4511-b7bc-9bd6249186cf	2026-09-11 14:44	2026-09-11 14:44	2026-09-11 14:44	USO	USO260911C00153000	call	153.0000	2026-09-11	1.4400	1.2600	1.6600	154.3500	10670.00	10378.00	0.00	74	8	3181	601	5.29284525790349	0.727292014150892	0.680215133647813	false	false	false	true
57f91626-2465-4492-bfbb-a43e1e8619cb	2026-09-11 14:22	2026-09-11 14:21	2026-09-11 14:21	USO	USO261016C00170000	call	170.0000	2026-10-16	5.5500	5.3000	5.5500	154.5700	53272.00	53272.00	0.00	96	5	1123	4171	0.269239990409974	0.573636800347404	0.573636800347404	false	false	false	true
d996c4a7-4355-4b1d-836c-cf6a924d676d	2026-09-11 13:23	2026-09-11 13:23	2026-09-11 13:23	USO	USO280616P00140000	put	140.0000	2028-06-16	21.7400	20.7500	21.8000	153.4500	56530.00	54360.00	2170.00	26	14	26	435	0.0597701149425287	0.440643483538159	0.439913054800394	true	false	false	true
c13f8de3-4d1a-4d2d-b231-cff60c815955	2026-09-11 13:11	2026-09-11 13:11	2026-09-11 13:11	USO	USO280317C00175000	call	175.0000	2028-03-17	25.0500	24.9500	25.8000	153.9700	177858.00	5010.00	172848.00	71	6	71	784	0.0905612244897959	0.382268058563192	0.382134994115208	false	false	false	true
bcf0b217-f730-4244-ac68-cace2a5f757d	2026-09-11 11:58	2026-09-11 11:57	2026-09-11 11:57	USO	USO261023C00220000	call	220.0000	2026-10-23	1.2100	0.8600	1.2300	153.7000	37482.00	20135.00	17347.00	311	18	311	11	28.2727272727273	0.691644521300056	0.690375874722498	true	false	false	true
942bb7be-e683-42f5-89e8-31c1d53f0c1a	2026-09-11 11:58	2026-09-11 11:57	2026-09-11 11:57	USO	USO261030C00220000	call	220.0000	2026-10-30	1.6500	1.1800	2.5500	153.7000	52507.00	27364.00	25143.00	318	7	318	0	0	0.691911132239908	0.679792424375529	true	false	false	true
fcc0ffab-4afa-4b10-96c0-529046bbd3db	2026-09-11 10:37	2026-09-11 10:37	2026-09-11 10:37	USO	USO260918P00149000	put	149.0000	2026-09-18	2.6400	2.6400	2.8000	154.2450	43307.00	0.00	43307.00	164	19	276	233	1.18454935622318	0.58138799456042	0.580071414324805	true	false	false	true
fc6321e3-a93d-47ce-8f1d-1427af051e5b	2026-09-11 10:30	2026-09-11 10:30	2026-09-11 10:30	USO	USO261023C00142500	call	142.5000	2026-10-23	17.4800	15.2000	17.5000	154.1350	10490.00	8745.00	1745.00	6	6	6	6	1	0.510129639259701	0.507313211426875	true	false	false	true
1ced001a-585f-482e-bfab-5e17f362293b	2026-09-11 10:14	2026-09-11 10:14	2026-09-11 10:14	USO	USO261120P00146000	put	146.0000	2026-11-20	9.1000	8.9000	9.3000	154.0200	221090.00	220180.00	910.00	243	19	250	20	12.5	0.505453022504969	0.505453022504969	true	false	false	true
d317f31e-a6eb-43d1-b168-4c76424f9e07	2026-09-11 10:07	2026-09-11 10:07	2026-09-11 10:07	USO	USO280121P00120000	put	120.0000	2028-01-21	11.5500	11.1500	12.0000	153.1900	79700.00	77388.00	2312.00	69	7	136	3043	0.0446927374301676	0.446309943263299	0.446108946846913	false	false	false	true
b2dfa51a-0fa1-4d9a-94d0-23986644c6bd	2026-09-11 09:39	2026-09-11 09:39	2026-09-11 09:39	USO	USO261016C00132000	call	132.0000	2026-10-16	22.1300	22.1000	24.2500	152.8600	276645.00	174985.00	101660.00	125	8	125	608	0.205592105263158	0.378852889564832	0.378852889564832	false	false	false	true
8f1949b1-fd95-43ee-bd61-9b4f47e6a3ee	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO260918P00147000	put	147.0000	2026-09-18	2.3200	2.3100	2.8400	152.5278	17604.00	726.00	16878.00	76	19	223	525	0.424761904761905	0.56314225352671	0.567218454712885	true	false	false	true
7ca2bca5-c01e-4acd-9817-7d78c51e47e9	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO260918P00147000	put	147.0000	2026-09-18	2.3300	2.2900	2.7900	152.5600	111992.00	56174.00	55818.00	480	15	703	525	1.33904761904762	0.560780701251727	0.561735718230081	true	false	false	true
4133864f-9a13-47a6-a305-d3df2c342203	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO261016P00150000	put	150.0000	2026-10-16	8.5400	8.5000	8.6500	152.6000	60631.00	9455.00	51176.00	71	19	323	2964	0.108974358974359	0.542507437838374	0.539796442068134	true	false	false	true
53b95dd1-77ce-40fa-8dd9-9dbb9d888c5b	2026-09-10 15:46	2026-09-10 15:46	2026-09-10 15:46	USO	USO260916P00154000	put	154.0000	2026-09-16	2.7600	2.4600	2.9300	158.5000	60776.00	52040.00	8736.00	220	31	324	0	0	0.612027763420645	0.602609578452916	true	false	false	true
f1f21606-5c3f-4dac-a248-96bbd2e2179d	2026-09-10 15:46	2026-09-10 15:46	2026-09-10 15:46	USO	USO260923C00155000	call	155.0000	2026-09-23	8.8000	8.1500	8.8000	158.4996	132811.00	132811.00	0.00	151	26	188	19	9.89473684210526	0.577200372599336	0.575638575144285	true	false	false	true
3d807895-d0bd-4d2a-9e6f-025a9ab66640	2026-09-10 15:46	2026-09-10 15:46	2026-09-10 15:46	USO	USO260923C00154000	call	154.0000	2026-09-23	9.2900	9.0000	9.3000	158.4600	44612.00	44612.00	0.00	48	10	53	12	4.41666666666667	0.571129191192327	0.571129191192327	true	false	false	true
5d44259d-761e-421b-952e-91a41f13c9c0	2026-09-10 15:20	2026-09-10 15:19	2026-09-10 15:19	USO	USO261016P00148000	put	148.0000	2026-10-16	5.8900	5.8500	6.2000	158.0200	37102.00	0.00	37102.00	63	7	390	747	0.522088353413655	0.542649534848801	0.542649534848801	false	false	false	true
4e20a267-c009-4aec-9f95-ded352928d07	2026-09-10 15:16	2026-09-10 15:16	2026-09-10 15:16	USO	USO261016C00150000	call	150.0000	2026-10-16	14.9500	14.4500	14.9500	157.7050	170420.00	167440.00	2980.00	114	18	1177	5904	0.199356368563686	0.535095757918274	0.535095757918274	true	false	false	true
5b964a82-b912-4c3e-9709-d358ec708bcd	2026-09-10 15:04	2026-09-10 15:04	2026-09-10 15:04	USO	USO260918C00156000	call	156.0000	2026-09-18	6.4000	5.9000	6.4000	157.6850	28795.00	28795.00	0.00	45	14	1151	1346	0.855126300148588	0.588155382836213	0.588155382836213	true	false	false	true
e889e450-102c-4968-916b-82adad941378	2026-09-10 14:28	2026-09-10 14:28	2026-09-10 14:28	USO	USO260918C00166000	call	166.0000	2026-09-18	2.9900	2.9900	3.3500	157.9100	66141.00	605.00	65536.00	221	38	312	0	0	0.646613335266171	0.646613335266171	true	false	false	true
afbb2c61-cef3-4106-b4ba-0be365bf3cc4	2026-09-10 14:17	2026-09-10 14:16	2026-09-10 14:16	USO	USO260916P00155000	put	155.0000	2026-09-16	2.9900	2.8500	3.1000	158.6600	15253.00	7774.00	7479.00	51	7	449	0	0	0.578573629639008	0.577258676815437	false	false	false	true
5cfbd2b6-10c4-45b7-b742-68237e775cb9	2026-09-10 14:15	2026-09-10 14:15	2026-09-10 14:15	USO	USO260916P00170000	put	170.0000	2026-09-16	12.9300	12.8500	13.8000	158.7600	31025.00	14245.00	16780.00	24	9	40	0	0	0.684292138774485	0.684292138774485	true	false	false	true
9a3bd8e4-e0f6-4c2f-bfa5-25a30a45a03e	2026-09-10 14:10	2026-09-10 14:10	2026-09-10 14:10	USO	USO260923C00165000	call	165.0000	2026-09-23	4.7000	4.0500	4.7000	158.5000	20200.00	19735.00	465.00	43	16	220	0	0	0.611165110916309	0.605787373269983	true	false	false	true
28377bf0-f834-4573-b435-0176a65d8cc6	2026-09-10 14:07	2026-09-10 14:07	2026-09-10 14:07	USO	USO261023P00175000	put	175.0000	2026-10-23	23.2500	23.1500	23.7000	157.8000	102315.00	0.00	102315.00	44	5	76	0	0	0.594434067308914	0.593935887945184	true	false	false	true
c8b96004-6a9f-42ba-be8a-dfb557fcfc25	2026-09-10 13:52	2026-09-10 13:52	2026-09-10 13:52	USO	USO261002C00165000	call	165.0000	2026-10-02	6.0000	5.9500	6.3000	156.9400	21610.00	1210.00	20400.00	36	10	626	147	4.25850340136054	0.597278154195483	0.593918951202632	true	false	false	true
6fb4f0e9-f34a-4d69-9be0-113f5c944fbe	2026-09-10 13:30	2026-09-10 13:30	2026-09-10 13:30	USO	USO261016C00156000	call	156.0000	2026-10-16	11.6300	11.5000	11.7000	157.2100	13950.00	5825.00	8125.00	12	6	227	270	0.840740740740741	0.548031396116946	0.545462855089518	true	false	false	true
7333267f-cb10-44c6-b9b3-bba6b82edf3f	2026-09-10 12:23	2026-09-10 12:23	2026-09-10 12:23	USO	USO261016C00164000	call	164.0000	2026-10-16	8.5100	8.4500	8.8500	156.7401	27220.00	1710.00	25510.00	32	12	229	101	2.26732673267327	0.577441304197189	0.574870728023211	true	false	false	true
66557282-100e-40c1-ba8d-0803885d494e	2026-09-10 12:13	2026-09-10 12:13	2026-09-10 12:13	USO	USO261023C00195000	call	195.0000	2026-10-23	3.3900	2.8900	3.4000	156.9800	13230.00	12225.00	1005.00	39	9	54	5	10.8	0.640952454979249	0.637589149736559	true	false	false	true
2e8df547-1a91-4a50-a008-257fa3aea186	2026-09-10 12:13	2026-09-10 12:13	2026-09-10 12:13	USO	USO261023C00190000	call	190.0000	2026-10-23	3.9500	3.4500	3.9500	156.9800	39075.00	37905.00	1170.00	99	16	170	1	170	0.627410406182196	0.624303358771978	true	false	false	true
caea9352-7e8b-498f-abc2-9a34ee5e5560	2026-09-10 12:12	2026-09-10 12:12	2026-09-10 12:12	USO	USO260911C00160000	call	160.0000	2026-09-11	1.4600	1.4600	1.4900	156.8600	268803.00	147.00	268656.00	1841	29	8754	4551	1.92353328938695	0.832773363474937	0.829422529623315	false	false	false	true
47d8d95e-0d4e-42a0-a9ef-8bd783171fa2	2026-09-10 12:09	2026-09-10 12:09	2026-09-10 12:09	USO	USO261218C00150000	call	150.0000	2026-12-18	20.1400	19.9000	20.4500	156.5732	354508.00	44330.00	310178.00	176	17	884	5070	0.174358974358974	0.497160053541652	0.497160053541652	false	false	false	true