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

19ea5b9c-59b4-47cd-9dff-cca73209e790	2026-09-11 14:21	2026-09-11 14:21	2026-09-11 14:21	USO	USO260911C00155000	call	155.0000	2026-09-11	0.4500	0.4200	0.5100	154.6200	10424.00	9004.00	500.00	230	34	10446	6291	1.66046733428708	0.734476918991736	0.746651274184834	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	Financial Services	1228364647.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
3f381ef1-0ae3-4a37-9b2e-6fd0fb018e3a	2026-09-11 14:21	2026-09-11 14:21	2026-09-11 14:21	USO	USO261016C00151000	call	151.0000	2026-10-16	12.0300	11.1000	12.1500	154.5986	81795.00	79375.00	2420.00	68	7	140	12151	0.011521685457987	0.523369557124341	0.524506140398935	false	false	false	true
5aa6f48f-1b22-45ae-9478-dc350559a3d1	2026-09-11 14:17	2026-09-11 14:17	2026-09-11 14:17	USO	USO280616C00175000	call	175.0000	2028-06-16	27.4700	27.4500	28.4500	153.9600	134625.00	13825.00	120800.00	49	8	63	479	0.131524008350731	0.375583497663966	0.378064567428339	false	false	false	true
c1d7553e-4ef3-4d78-aede-7fb86ef97b72	2026-09-11 13:52	2026-09-11 13:52	2026-09-11 13:52	USO	USO260918C00150000	call	150.0000	2026-09-18	6.7600	6.7500	7.1000	153.8000	33810.00	0.00	33810.00	50	9	449	10157	0.0442059663286403	0.539834437901582	0.539834437901582	false	false	false	true
dc7cbe2a-4ae6-45b4-91b8-89c37e5deb30	2026-09-11 13:11	2026-09-11 13:11	2026-09-11 13:11	USO	USO280616C00175000	call	175.0000	2028-06-16	27.4900	27.3000	28.4000	153.9700	35735.00	2750.00	32985.00	13	5	14	479	0.0292275574112735	0.375513894088475	0.376134045612604	false	false	false	true
55f68a88-8172-417d-b16d-a3eeed81bc77	2026-09-11 13:07	2026-09-11 13:07	2026-09-11 13:07	USO	USO260918P00151000	put	151.0000	2026-09-18	3.5000	3.3000	3.5000	154.0300	26215.00	26215.00	0.00	75	5	258	156	1.65384615384615	0.577257287232792	0.58339732957026	false	false	false	true
5d4ba207-8118-4c55-843d-d1b8fdfed2f9	2026-09-11 11:47	2026-09-11 11:47	2026-09-11 11:47	USO	USO261023P00163000	put	163.0000	2026-10-23	16.7500	16.7500	17.2000	153.4200	164189.00	0.00	164189.00	98	31	110	0	0	0.553628589611041	0.554057124781315	true	false	false	true
4905e6ee-ede8-4828-9bb0-6b92a8283ee5	2026-09-11 11:29	2026-09-11 11:29	2026-09-11 11:29	USO	USO261120P00145000	put	145.0000	2026-11-20	8.9400	8.7000	9.0000	153.0100	17880.00	7200.00	10680.00	20	5	90	865	0.104046242774566	0.500531077761623	0.504566258801011	false	false	false	true
e48dc68a-f9b8-4d1e-8ef5-1b5c2aeccda3	2026-09-11 11:29	2026-09-11 11:29	2026-09-11 11:29	USO	USO260925C00168000	call	168.0000	2026-09-25	2.5900	2.5600	2.9000	152.7900	19695.00	1044.00	18392.00	76	24	81	59	1.3728813559322	0.630389283605841	0.635639502394422	true	false	false	true
fc447e3e-28c9-43b9-b6e3-6f61e6b47745	2026-09-11 11:10	2026-09-11 11:10	2026-09-11 11:10	USO	USO261030C00159000	call	159.0000	2026-10-30	9.9000	9.9000	10.3000	154.0100	75276.00	0.00	74286.00	76	18	76	77	0.987012987012987	0.520386045355971	0.520386045355971	true	false	false	true
a2386e45-7cb4-4832-9280-36d510cdd9c1	2026-09-11 10:58	2026-09-11 10:58	2026-09-11 10:58	USO	USO280121P00080000	put	80.0000	2028-01-21	3.5200	3.4500	4.1500	153.6395	30611.00	1800.00	28811.00	87	6	92	423	0.217494089834515	0.508853418972107	0.508853418972107	false	false	false	true
91411219-22cc-43cc-aca1-9c3ff84f9d93	2026-09-11 10:44	2026-09-11 10:44	2026-09-11 10:44	USO	USO280121C00155000	call	155.0000	2028-01-21	30.7700	30.4000	31.5500	153.8650	21537.00	0.00	21537.00	7	5	45	553	0.081374321880651	0.382771034094705	0.383215693245502	false	false	false	true
b48c944a-0d8c-46fb-8e9b-e203c06e4ed5	2026-09-11 10:13	2026-09-11 10:13	2026-09-11 10:13	USO	USO260918P00154000	put	154.0000	2026-09-18	5.0500	5.0000	5.1500	153.9500	32820.00	29795.00	3025.00	65	17	415	1295	0.32046332046332	0.591995373881135	0.597880344022588	true	false	false	true
437b78ac-f324-4723-80dc-1001e9813b8a	2026-09-11 10:06	2026-09-11 10:05	2026-09-11 10:05	USO	USO260925C00157000	call	157.0000	2026-09-25	5.3400	4.9000	5.3500	153.2300	11205.00	9095.00	2110.00	21	8	22	66	0.333333333333333	0.573398072908271	0.563647668325161	true	false	false	true
f03fe6d5-414f-4eb9-9fc6-89fe17091cae	2026-09-11 09:47	2026-09-11 09:47	2026-09-11 09:47	USO	USO280317P00151000	put	151.0000	2028-03-17	26.1600	24.9500	26.9500	152.0000	133440.00	102000.00	31440.00	51	6	61	19	3.21052631578947	0.445443495009456	0.446900203435587	false	false	false	true
fb706859-ba5e-4350-baa0-48ee3caeadc4	2026-09-11 09:46	2026-09-11 09:46	2026-09-11 09:46	USO	USO261009C00170000	call	170.0000	2026-10-09	4.0500	4.0500	4.5000	152.7900	43350.00	415.00	42935.00	107	11	115	682	0.168621700879765	0.580847235826553	0.587776356720024	true	false	false	true
e639c114-f7e2-40cd-8628-15e715886c56	2026-09-11 09:43	2026-09-11 09:43	2026-09-11 09:43	USO	USO260916P00153000	put	153.0000	2026-09-16	3.8500	3.7000	3.9500	153.1300	319549.00	384.00	319165.00	830	11	1004	185	5.42702702702703	0.552230940596007	0.55363155510819	true	false	false	true
a268449a-36a9-4b82-a99e-eff56db05816	2026-09-11 09:40	2026-09-11 09:40	2026-09-11 09:40	USO	USO260918P00145000	put	145.0000	2026-09-18	1.5500	1.5500	1.6600	152.9500	235872.00	0.00	235872.00	1521	51	3208	5066	0.633241215949467	0.543652096521818	0.543652096521818	true	false	false	true
f7506b63-2ffe-473c-afa6-76188132808c	2026-09-11 09:40	2026-09-11 09:40	2026-09-11 09:40	USO	USO260918P00145000	put	145.0000	2026-09-18	1.5800	1.5800	1.6600	152.9350	237104.00	0.00	237104.00	1500	33	1687	5066	0.333004342676668	0.54783547523774	0.54783547523774	false	false	false	true
996a34e0-321d-40cd-9471-2702da42db01	2026-09-11 09:39	2026-09-11 09:39	2026-09-11 09:39	USO	USO261023P00156000	put	156.0000	2026-10-23	12.5100	12.5000	13.0500	152.8900	32535.00	0.00	32535.00	26	8	27	4	6.75	0.540937478003167	0.540937478003167	true	false	false	true
9c761826-6936-4ad5-9c93-2984e17c0ef2	2026-09-11 09:31	2026-09-11 09:31	2026-09-11 09:31	USO	USO261016P00160000	put	160.0000	2026-10-16	14.4600	14.4000	14.7000	152.0000	11569.00	0.00	11569.00	8	5	133	193	0.689119170984456	0.563400149438061	0.566079995035168	false	false	false	true
da6477ca-d5ba-4d9e-adc8-466f747c67d1	2026-09-11 09:31	2026-09-11 09:31	2026-09-11 09:31	USO	USO260918C00157000	call	157.0000	2026-09-18	3.0000	3.0000	3.4500	152.0000	17425.00	0.00	17425.00	58	21	63	1423	0.0442726633872101	0.570887930830897	0.570887930830897	true	false	false	true
1f9594c4-0700-4b36-90b1-c02558d4a4dc	2026-09-11 09:31	2026-09-11 09:31	2026-09-11 09:31	USO	USO260918C00158000	call	158.0000	2026-09-18	2.7600	2.6800	3.3500	152.0000	17407.00	1945.00	15462.00	63	20	74	292	0.253424657534247	0.582972857221209	0.582138201915963	true	false	false	true
a8c2760b-696d-48d7-94f5-d3591c970263	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO260918C00160000	call	160.0000	2026-09-18	2.3600	2.3300	2.6100	152.0000	212861.00	48038.00	164823.00	902	19	927	10182	0.0910430170889805	0.604543694705395	0.602774852492217	true	false	false	true
2314310b-3b92-47b4-bf5c-aee662b2bb2c	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO261120P00160000	put	160.0000	2026-11-20	17.8500	17.8500	18.5000	152.0000	103535.00	0.00	103535.00	58	17	71	147	0.482993197278912	0.534074561398686	0.534074561398686	true	false	false	true
07d32830-46f2-4403-9662-c8aa1871c20c	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO260916P00146000	put	146.0000	2026-09-16	1.4000	1.0600	1.6500	152.0000	26877.00	11048.00	15829.00	192	7	293	1508	0.194297082228117	0.542179796743424	0.549928343531858	true	false	false	true
cfb807f0-b1c7-4845-a2b4-b5b78f376685	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO261016C00160000	call	160.0000	2026-10-16	7.5200	7.3000	8.3500	152.0000	12025.00	2270.00	9755.00	16	8	103	4764	0.0216204869857263	0.548997114451649	0.551689443764206	true	false	false	true
9e63c329-0ecd-4170-9191-721130a8584f	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO260918P00146000	put	146.0000	2026-09-18	2.0400	1.8700	2.5100	152.0000	117537.00	55043.00	62494.00	576	18	578	1142	0.506129597197898	0.559434090899454	0.559048427330177	true	false	false	true
99f6b1d8-84cd-4205-b5ac-2fe186af5dba	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO260916P00147000	put	147.0000	2026-09-16	1.6400	1.3800	1.8500	152.0000	38731.00	19654.00	19077.00	236	10	240	212	1.13207547169811	0.540630417428277	0.542338025122039	true	false	false	true
15bac044-fd9a-46a1-8c49-6ce5e599aeb3	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO261016P00160000	put	160.0000	2026-10-16	14.6100	14.6000	15.0000	152.5278	160675.00	7350.00	147465.00	110	20	118	193	0.61139896373057	0.562765624319353	0.568144206437756	true	false	false	true
0cee30be-87ed-4905-8ab2-b276171c2535	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO260918P00148000	put	148.0000	2026-09-18	2.6900	2.4600	3.1000	152.0000	137331.00	69474.00	67857.00	510	18	510	963	0.529595015576324	0.559191865984001	0.556145158865093	true	false	false	true
01988798-aeb7-4b0c-9c5a-2a008dabe614	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO261016C00159000	call	159.0000	2026-10-16	7.8700	7.7500	8.8000	152.0000	14160.00	7095.00	7065.00	18	5	18	90	0.2	0.547844389106566	0.547844389106566	true	false	false	true
ca9a2f97-1d91-430e-8163-bcb857eb728b	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	USO	USO261016P00161000	put	161.0000	2026-10-16	15.4000	15.1500	16.6000	152.5500	63135.00	1540.00	61595.00	41	8	41	1	41	0.569568570151658	0.572272530160638	true	false	false	true
0cc6575f-b984-45fa-aef1-d6213377d0cf	2026-09-10 15:45	2026-09-10 15:45	2026-09-10 15:45	USO	USO260918C00144000	call	144.0000	2026-09-18	15.3400	15.2500	15.6000	158.4205	30680.00	12280.00	18400.00	20	9	156	311	0.501607717041801	0.548799796770743	0.570840846300277	false	false	false	true
2b8a9195-e8ff-4c8f-8954-9c81e969bc4f	2026-09-10 15:36	2026-09-10 15:36	2026-09-10 15:36	USO	USO261016C00150000	call	150.0000	2026-10-16	15.3000	15.2500	15.6500	158.3750	120905.00	4615.00	116290.00	79	27	1276	5904	0.216124661246612	0.529923444659176	0.532690025836372	true	false	false	true
d50813bd-0114-48a7-8e44-cf9335ed3bd9	2026-09-10 15:18	2026-09-10 15:18	2026-09-10 15:18	USO	USO261016C00145000	call	145.0000	2026-10-16	18.0400	18.0000	18.3500	158.0600	45100.00	0.00	45100.00	25	5	618	3745	0.16502002670227	0.513148297220313	0.516243675016034	false	false	false	true
f090c8d6-6467-4d28-92eb-fe4cea177cfc	2026-09-10 15:16	2026-09-10 15:16	2026-09-10 15:16	USO	USO260925C00158000	call	158.0000	2026-09-25	7.5400	7.4500	7.5500	157.8000	30930.00	27930.00	3000.00	41	5	158	0	0	0.586339967254699	0.586339967254699	false	false	false	true
8e7efedd-f4aa-457f-be85-163916ed7414	2026-09-10 15:16	2026-09-10 15:16	2026-09-10 15:16	USO	USO260925C00155000	call	155.0000	2026-09-25	8.9400	8.4000	8.9500	157.8000	44705.00	42925.00	1780.00	50	9	419	472	0.88771186440678	0.576251665890603	0.580269636997413	true	false	false	true
c53bfff4-f462-4d1e-b877-392901b1a613	2026-09-10 15:07	2026-09-10 15:07	2026-09-10 15:07	USO	USO261120C00170000	call	170.0000	2026-11-20	10.2200	10.0500	10.7500	157.5200	40890.00	0.00	40890.00	40	5	502	488	1.02868852459016	0.52334220421936	0.527375906100082	false	false	false	true
1f9ad287-a637-4f0f-be65-c92b3c2ac278	2026-09-10 14:49	2026-09-10 14:49	2026-09-10 14:49	USO	USO260916C00165000	call	165.0000	2026-09-16	2.2100	2.1800	2.3200	157.4350	48836.00	1326.00	47510.00	221	12	3550	0	0	0.616916645342175	0.618357424742412	true	false	false	true
bd075948-749e-40ba-9b27-ee372b142cd4	2026-09-10 14:31	2026-09-10 14:31	2026-09-10 14:31	USO	USO261023C00185000	call	185.0000	2026-10-23	4.7000	4.6000	5.3500	157.5000	17400.00	8470.00	8930.00	37	9	52	3	17.3333333333333	0.611066374086866	0.611066374086866	true	false	false	true
821cc5c2-5abd-43da-b7b6-562863bd01f0	2026-09-10 14:31	2026-09-10 14:31	2026-09-10 14:31	USO	USO261016C00180000	call	180.0000	2026-10-16	4.8000	4.8000	5.1000	157.5116	41773.00	485.00	41288.00	87	15	578	1731	0.333911034084344	0.611539971904466	0.614532141683935	true	false	false	true
2785e5c6-cedb-4ab3-96fc-5b2d8cb89508	2026-09-10 14:31	2026-09-10 14:31	2026-09-10 14:31	USO	USO261023C00180000	call	180.0000	2026-10-23	5.5400	4.7500	6.2500	157.5000	34885.00	17285.00	17600.00	63	8	324	44	7.36363636363636	0.596265913501091	0.599114173667931	true	false	false	true
89c30b15-1e52-4105-9155-6cfba5f39e25	2026-09-10 14:31	2026-09-10 14:30	2026-09-10 14:30	USO	USO260911C00155000	call	155.0000	2026-09-11	3.7000	3.7000	3.9500	157.6400	74064.00	0.00	32994.00	200	20	4827	6460	0.747213622291022	0.646959197572278	0.646959197572278	false	false	false	true
e96d1fba-5085-4dcb-83f8-3afbbb3bfcc9	2026-09-10 14:23	2026-09-10 14:23	2026-09-10 14:23	USO	USO260918P00165000	put	165.0000	2026-09-18	9.9500	9.9000	10.7000	158.3300	19905.00	4995.00	14910.00	20	7	116	34	3.41176470588235	0.637792731151982	0.643537350355311	true	false	false	true
ea1baee6-2482-4255-989c-c18501644e2d	2026-09-10 14:22	2026-09-10 14:22	2026-09-10 14:22	USO	USO261016P00140000	put	140.0000	2026-10-16	3.2000	3.2000	3.3000	158.5300	54100.00	0.00	54100.00	169	34	2136	4235	0.504368358913813	0.535140732058413	0.535140732058413	true	false	false	true
f5030f93-e21d-4300-919a-41b87d3826e9	2026-09-10 14:09	2026-09-10 14:09	2026-09-10 14:09	USO	USO261016C00156000	call	156.0000	2026-10-16	12.3000	12.2500	12.3000	158.1100	46730.00	44280.00	2450.00	38	12	313	270	1.15925925925926	0.552615034210527	0.555183347921277	true	false	false	true
0a32de1a-5456-44e7-a17b-cc60a7ca681f	2026-09-10 14:07	2026-09-10 14:07	2026-09-10 14:07	USO	USO261023P00175000	put	175.0000	2026-10-23	23.3100	23.2500	24.5000	157.7700	62930.00	9340.00	53590.00	27	13	27	0	0	0.59545630611968	0.597946196997466	true	false	false	true
7429c088-f741-4012-b2b8-48981b4f7b98	2026-09-10 13:52	2026-09-10 13:52	2026-09-10 13:52	USO	USO261002C00162000	call	162.0000	2026-10-02	6.9500	6.9000	7.3000	156.9400	54235.00	3475.00	41005.00	78	23	189	0	0	0.584018199149132	0.584018199149132	true	false	false	true
9c0554c7-a353-4e0f-8b18-2781b9804482	2026-09-10 13:26	2026-09-10 13:25	2026-09-10 13:25	USO	USO261218C00135000	call	135.0000	2026-12-18	28.9500	28.9500	29.3000	157.1050	848245.00	0.00	848245.00	293	30	2190	3606	0.607321131447587	0.47049593295842	0.47049593295842	false	false	false	true