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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

8f6b0fb0-a5dc-4d8a-ad62-b060d2e8bc13	2026-09-10 12:48	2026-09-10 12:48	2026-09-10 12:48	USO	USO261009C00160000	call	160.0000	2026-10-09	8.2200	8.2000	8.9000	156.0000	46050.00	6650.00	39400.00	56	20	77	536	0.14365671641791	0.550172349999444	0.555873336834327	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,"older_than":"2026-09-10T17:02:16.286608Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
3c459b31-4247-447f-80e1-2fcde49e17bc	2026-09-10 12:45	2026-09-10 12:45	2026-09-10 12:45	USO	USO261009C00158000	call	158.0000	2026-10-09	9.1100	9.0500	9.8000	156.0000	87415.00	910.00	83765.00	96	30	103	0	0	0.549746381607135	0.549746381607135	true	false	false	true
811ec839-2837-49d3-9fe1-728975cf1acb	2026-09-10 12:44	2026-09-10 12:43	2026-09-10 12:43	USO	USO260916P00157500	put	157.5000	2026-09-16	4.9500	4.8500	5.2500	156.0000	231388.00	3465.00	227923.00	467	28	467	0	0	0.567151166615325	0.567151166615325	true	false	false	true
18661da9-32c8-468c-b836-34e2221977e3	2026-09-10 12:43	2026-09-10 12:43	2026-09-10 12:43	USO	USO261016C00162000	call	162.0000	2026-10-16	8.8500	8.8000	9.4500	156.0000	283287.00	15050.00	268237.00	320	27	395	274	1.44160583941606	0.555224351546721	0.555224351546721	true	false	false	true
68f251db-28e7-4585-a9f0-d38b5a072eba	2026-09-10 12:32	2026-09-10 12:31	2026-09-10 12:31	USO	USO260923C00167500	call	167.5000	2026-09-23	3.2100	3.2000	4.3500	156.6801	17635.00	0.00	17635.00	55	18	55	0	0	0.599784623721993	0.599784623721993	true	false	false	true
aa96c0b3-8eec-4006-9930-5bdae0576b74	2026-09-10 12:29	2026-09-10 12:29	2026-09-10 12:29	USO	USO261009P00161000	put	161.0000	2026-10-09	12.1000	12.1000	12.6000	156.8495	168214.00	1225.00	166989.00	139	26	139	0	0	0.570069837391531	0.57859055280803	true	false	false	true
9d00e256-3587-42b5-9084-7ee80d5a4411	2026-09-10 12:27	2026-09-10 12:27	2026-09-10 12:27	USO	USO261016P00156000	put	156.0000	2026-10-16	10.2200	10.0000	10.3000	156.6600	14315.00	7175.00	7140.00	14	5	93	71	1.30985915492958	0.554469651959745	0.556762006378113	true	false	false	true
4daf802b-0f7f-4537-82e5-441b21f11ea1	2026-09-10 12:27	2026-09-10 12:27	2026-09-10 12:27	USO	USO261016P00149000	put	149.0000	2026-10-16	6.6700	6.6000	6.8000	156.6600	30675.00	11390.00	16625.00	46	12	253	169	1.49704142011834	0.537089951476557	0.53686058332034	true	false	false	true
42e81d94-86a5-44b1-94c2-beec020aa2b0	2026-09-10 12:27	2026-09-10 12:27	2026-09-10 12:27	USO	USO261120C00180000	call	180.0000	2026-11-20	7.7900	7.6000	7.8500	156.6721	36625.00	36625.00	0.00	47	7	364	265	1.37358490566038	0.559801606301469	0.563739734643373	true	false	false	true
cc50fe77-c1b4-43fe-bd70-8ca6bb7f5b57	2026-09-10 12:27	2026-09-10 12:27	2026-09-10 12:27	USO	USO261009C00163000	call	163.0000	2026-10-09	7.5600	7.4000	8.1500	156.6000	27975.00	3795.00	18120.00	37	9	44	0	0	0.570626309575051	0.574003289391915	true	false	false	true
3088fda6-4f4c-4aa3-a056-bf6c7a74f94f	2026-09-10 12:27	2026-09-10 12:27	2026-09-10 12:27	USO	USO260925P00155000	put	155.0000	2026-09-25	6.2100	6.1750	6.5500	156.6000	138997.00	1875.00	137122.00	224	24	480	2	240	0.562822574758988	0.566821684582894	true	false	false	true
39ac5d28-1b11-4885-9110-6c00850796e5	2026-09-10 12:27	2026-09-10 12:27	2026-09-10 12:27	USO	USO260911C00165000	call	165.0000	2026-09-11	0.5000	0.5000	0.5400	156.6054	25039.00	0.00	25039.00	500	8	5262	5579	0.943179781322818	0.892748453248681	0.898277353617912	false	false	false	true
af30fbcf-11d5-4e9a-a134-2d203483455a	2026-09-10 12:26	2026-09-10 12:26	2026-09-10 12:26	USO	USO260923C00170000	call	170.0000	2026-09-23	2.7900	2.7600	3.2000	156.6200	49714.00	18124.00	31590.00	178	30	220	0	0	0.619571548817069	0.622672655083304	true	false	false	true
3a97af3c-b391-42fc-b81a-a8ce41321577	2026-09-10 12:26	2026-09-10 12:26	2026-09-10 12:26	USO	USO260923C00165000	call	165.0000	2026-09-23	3.9000	3.9000	4.4000	156.6662	58510.00	395.00	58115.00	150	20	152	0	0	0.599165585821257	0.603735924050363	true	false	false	true
240a7d69-78ed-46cd-bae5-f1036ec7207b	2026-09-10 12:26	2026-09-10 12:26	2026-09-10 12:26	USO	USO260923C00160000	call	160.0000	2026-09-23	5.4100	5.3500	6.0000	156.6662	23790.00	1635.00	20520.00	44	13	102	0	0	0.575024913203943	0.575024913203943	true	false	false	true
64aae890-e57e-4356-8924-0bf28e1a9715	2026-09-10 12:26	2026-09-10 12:26	2026-09-10 12:26	USO	USO261016C00165000	call	165.0000	2026-10-16	8.0500	8.0500	8.4500	156.7400	78910.00	1625.00	77285.00	98	21	1199	1747	0.686319404693761	0.570574193320026	0.573159388236062	true	false	false	true
1d9cd224-9cf6-46ca-beef-5cf0431d75dd	2026-09-10 12:25	2026-09-10 12:24	2026-09-10 12:24	USO	USO260916P00155000	put	155.0000	2026-09-16	3.7100	3.6500	4.0500	156.7693	15568.00	2615.00	12583.00	42	16	80	0	0	0.573808980102968	0.573808980102968	true	false	false	true
7e000a85-9891-40b2-9690-2e092bd4db6b	2026-09-10 12:21	2026-09-10 12:21	2026-09-10 12:21	USO	USO260911C00160000	call	160.0000	2026-09-11	1.5100	1.5100	1.6400	157.0400	24171.00	1672.00	22499.00	160	9	9165	4551	2.01384311140409	0.825859669652413	0.825859669652413	false	false	false	true
323af639-a8d4-4c4c-8b56-b05a46c4ce82	2026-09-10 12:14	2026-09-10 12:14	2026-09-10 12:14	USO	USO260923C00195000	call	195.0000	2026-09-23	0.7600	0.2100	0.8000	157.0655	26511.00	13550.00	12961.00	348	8	475	0	0	0.739327323366718	0.77024727174187	true	false	false	true
d70440dd-bb2a-421b-9446-4c3a4f40420b	2026-09-10 11:55	2026-09-10 11:55	2026-09-10 11:55	USO	USO260918C00155000	call	155.0000	2026-09-18	6.1300	6.0000	6.2000	156.6049	19626.00	19626.00	0.00	32	5	3205	3308	0.968863361547763	0.567354430931858	0.567354430931858	false	false	false	true
5df8095a-5f12-45a6-b54d-44cca147e795	2026-09-10 11:12	2026-09-10 11:12	2026-09-10 11:12	USO	USO261218C00140000	call	140.0000	2026-12-18	23.7200	23.0000	24.0000	154.6550	118606.00	118606.00	0.00	50	6	73	3922	0.0186129525752167	0.466930661448145	0.466930661448145	false	false	false	true
65ee05cd-87b2-42ce-b108-a257e82b3141	2026-09-10 11:10	2026-09-10 11:10	2026-09-10 11:10	USO	USO280121P00155000	put	155.0000	2028-01-21	26.5100	25.8500	26.8000	154.6900	45067.00	45067.00	0.00	17	7	17	273	0.0622710622710623	0.429161404491263	0.429161404491263	false	false	false	true
bcc93f15-ad8f-443f-94ad-205cc112affd	2026-09-10 10:43	2026-09-10 10:42	2026-09-10 10:42	USO	USO260918P00145000	put	145.0000	2026-09-18	1.2500	1.2400	1.3500	154.0600	71822.00	0.00	71822.00	576	46	2998	1847	1.62317271250677	0.496811914055212	0.498417705434881	true	false	false	true
97ebc82a-1e9e-4d99-aa88-3ee2cbce2f03	2026-09-10 10:02	2026-09-10 10:02	2026-09-10 10:02	USO	USO261030C00156000	call	156.0000	2026-10-30	10.4800	8.6000	11.9500	153.6500	23045.00	3120.00	19925.00	22	6	42	0	0	0.484876183791273	0.493697583827705	false	false	false	true
d1ba96a1-d033-4b8f-8176-fc6a461d454c	2026-09-10 09:54	2026-09-10 09:53	2026-09-10 09:53	USO	USO261218C00152000	call	152.0000	2026-12-18	16.5000	16.5000	17.2500	153.5900	66003.00	0.00	66003.00	40	8	95	328	0.289634146341463	0.470445374862092	0.470445374862092	false	false	false	true
fd8af0a7-f10a-49ad-9088-b7548cef1520	2026-09-10 09:38	2026-09-10 09:38	2026-09-10 09:38	USO	USO270115C00140000	call	140.0000	2027-01-15	24.7700	24.3500	25.2000	154.0048	123870.00	0.00	123870.00	50	5	56	2475	0.0226262626262626	0.456889448564265	0.456889448564265	false	false	false	true
6a158306-f1f1-49eb-8053-6bd9599f5049	2026-09-10 09:37	2026-09-10 09:37	2026-09-10 09:37	USO	USO261120P00150000	put	150.0000	2026-11-20	10.8900	10.6500	10.9500	154.1205	108934.00	108934.00	0.00	100	7	118	249	0.473895582329317	0.501901343503212	0.501901343503212	false	false	false	true
e55005ae-d450-4e52-a6e3-ffe9282c8739	2026-09-10 09:31	2026-09-10 09:31	2026-09-10 09:31	USO	USO260911P00154000	put	154.0000	2026-09-11	2.0000	1.9900	2.2500	154.2900	31445.00	3434.00	28011.00	157	33	166	43	3.86046511627907	0.661995360070608	0.674093288107701	true	false	false	true
dd0cc1df-aa12-43ed-819b-c291e6190c57	2026-09-10 09:30	2026-09-10 09:30	2026-09-10 09:30	USO	USO260911C00155000	call	155.0000	2026-09-11	2.1100	1.8500	2.2400	154.7800	10980.00	4680.00	6300.00	52	5	60	6460	0.00928792569659443	0.603045353013038	0.686604345541829	false	false	false	true
e19bbfa7-fec8-4cd0-975e-6cc167788695	2026-09-09 15:08	2026-09-09 15:07	2026-09-09 15:07	USO	USO260918C00160000	call	160.0000	2026-09-18	1.2400	1.2400	1.3000	149.6307	12432.00	0.00	12432.00	100	6	2304	9726	0.236890808143122	0.48280243339944	0.484310564747252	false	false	false	true
da456c2b-f1d6-4116-bcba-8e938e80dc6d	2026-09-09 13:45	2026-09-09 13:45	2026-09-09 13:45	USO	USO270115C00300000	call	300.0000	2027-01-15	1.0500	1.0100	1.1200	148.6050	105401.00	212.00	105189.00	1000	15	1142	1259	0.907069102462272	0.637501101496014	0.637501101496014	true	false	false	true
993cf3ee-4a86-436f-8776-ad2c2aa1c7e9	2026-09-09 13:23	2026-09-09 13:23	2026-09-09 13:23	USO	USO270617P00100000	put	100.0000	2027-06-17	3.9000	3.6500	3.9000	148.0050	38986.00	38986.00	0.00	100	6	572	1292	0.442724458204334	0.471459717558202	0.472283434856976	false	false	false	true
c14cf601-7874-453e-8d34-ed932adc6a89	2026-09-09 13:18	2026-09-09 13:18	2026-09-09 13:18	USO	USO270917P00099000	put	99.0000	2027-09-17	5.0800	4.6000	5.2000	147.8100	12180.00	11170.00	1010.00	24	6	34	2	17	0.465957246855039	0.467640704714988	false	false	false	true
e51cbaa9-4388-480e-9d5b-1a64df608b58	2026-09-09 13:01	2026-09-09 13:01	2026-09-09 13:01	USO	USO260911C00145000	call	145.0000	2026-09-11	4.0600	3.9500	4.3500	148.0000	64225.00	46980.00	17245.00	158	8	445	3177	0.140069247717973	0.456630708900695	0.470951294436921	false	false	false	true
befbedce-6da7-494f-b3da-371c52e38ea5	2026-09-09 12:24	2026-09-09 12:23	2026-09-09 12:23	USO	USO261016C00159000	call	159.0000	2026-10-16	5.7500	5.7500	5.8000	149.1000	15530.00	0.00	15530.00	27	15	32	37	0.864864864864865	0.496795458112934	0.496795458112934	true	false	false	true
51d02431-deb9-401b-a997-546538665a5a	2026-09-09 11:30	2026-09-09 11:30	2026-09-09 11:30	USO	USO260911C00149000	call	149.0000	2026-09-11	2.5500	2.5500	2.7000	149.3300	15068.00	0.00	15068.00	59	7	562	538	1.04460966542751	0.536996091612018	0.539271127917356	false	false	false	true
bb539ede-1fcb-4785-ac1f-a87f9ad3ac82	2026-09-09 11:20	2026-09-09 11:20	2026-09-09 11:20	USO	USO261120C00200000	call	200.0000	2026-11-20	2.8000	2.6100	2.8100	149.5800	11486.00	11206.00	280.00	41	5	222	19	11.6842105263158	0.565289653372498	0.56566534518746	true	false	false	true
a1e67961-625b-407a-9112-9e329e0f9d11	2026-09-09 10:47	2026-09-09 10:46	2026-09-09 10:46	USO	USO261023P00130000	put	130.0000	2026-10-23	2.2200	2.1700	2.3600	149.0512	336084.00	80375.00	255709.00	1511	13	1527	63	24.2380952380952	0.454433600116576	0.455990484199996	false	false	false	true
aab9f5f4-addc-476c-8795-322793ccdfec	2026-09-09 10:44	2026-09-09 10:43	2026-09-09 10:43	USO	USO270115P00140000	put	140.0000	2027-01-15	10.9000	10.6500	11.0000	148.9950	16357.00	16357.00	0.00	15	5	109	2125	0.0512941176470588	0.466862832380304	0.466862832380304	false	false	false	true
4332e899-d14a-483c-a00f-38498842419f	2026-09-09 10:21	2026-09-09 10:20	2026-09-09 10:20	USO	USO270115P00130000	put	130.0000	2027-01-15	6.6900	6.6000	6.9500	149.0800	20056.00	0.00	20056.00	30	5	74	2469	0.0299716484406642	0.452613595897949	0.456591180418187	false	false	false	true
1ffc7e94-c9d3-4446-b085-4b30ee6f84ef	2026-09-09 09:38	2026-09-09 09:38	2026-09-09 09:38	USO	USO260918C00150000	call	150.0000	2026-09-18	3.8900	3.7000	3.9500	148.9800	62695.00	60355.00	0.00	161	23	1233	10471	0.117753796199026	0.461959269986149	0.462196510454651	true	false	false	true
16e2d545-771e-4d40-ad65-7d6004a6178e	2026-09-09 09:38	2026-09-09 09:38	2026-09-09 09:38	USO	USO260918C00146000	call	146.0000	2026-09-18	5.9400	5.6500	5.9500	148.9800	10095.00	9505.00	590.00	17	7	23	2258	0.0101860053144376	0.45728939752541	0.455879894635223	true	false	false	true
7f6e8458-d197-4a37-b158-d09cf1e140cb	2026-09-09 09:36	2026-09-09 09:36	2026-09-09 09:36	USO	USO261016C00155000	call	155.0000	2026-10-16	6.5600	6.5500	6.7000	148.7100	26220.00	0.00	19670.00	40	6	66	3143	0.0209990454979319	0.473679181522016	0.473679181522016	false	false	false	true
76c9e334-719d-4ab6-9afa-078d2902a2e9	2026-09-09 09:34	2026-09-09 09:33	2026-09-09 09:33	USO	USO270917P00100000	put	100.0000	2027-09-17	5.0200	4.9000	6.5000	148.6000	110408.00	75000.00	35408.00	220	5	220	440	0.5	0.459793567890937	0.461793788774028	false	false	false	true
5a9e0c78-2531-4d73-ba34-42042a336030	2026-09-09 09:32	2026-09-09 09:32	2026-09-09 09:32	USO	USO270319P00130000	put	130.0000	2027-03-19	9.1000	8.0000	9.2500	148.6900	67333.00	4543.00	62790.00	74	6	122	1245	0.0979919678714859	0.449919824815435	0.450492573257953	false	false	false	true
7cbc4f51-d832-445c-a9c1-54ecd97d6c6d	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	USO	USO260909P00149000	put	149.0000	2026-09-09	1.1900	1.0800	1.3100	148.7700	21173.00	10734.00	10439.00	178	14	320	4	80	0.662447310416413	0.663744756593986	true	false	false	true
2fb607e0-1e48-4800-8118-1549f899b405	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	USO	USO260909P00150000	put	150.0000	2026-09-09	1.8300	1.7300	1.9600	148.8324	24867.00	5315.00	19552.00	136	23	138	14	9.85714285714286	0.705874827878796	0.705874827878796	true	false	false	true
ead67b6b-b530-4458-bd47-d36ab6e2a0e0	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	USO	USO260909C00148000	call	148.0000	2026-09-09	1.5800	1.1200	1.8000	148.8462	24189.00	2382.00	21807.00	153	42	187	673	0.277860326894502	0.684190557496832	0.684190557496832	true	false	false	true
c0e6391a-0acb-476b-a5ad-04016f879cbf	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	USO	USO260909C00150000	call	150.0000	2026-09-09	0.6400	0.6400	0.8000	148.8462	10758.00	66.00	10692.00	168	20	731	4164	0.175552353506244	0.691517495642802	0.698209998569312	true	false	false	true
bfa32c3f-239f-4015-8d68-e811c591a690	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	USO	USO260911C00146000	call	146.0000	2026-09-11	3.4600	3.4000	4.4000	148.7800	10720.00	0.00	10720.00	31	6	37	2684	0.0137853949329359	0.372702913279075	0.509486228784031	false	false	false	true