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 = RepeatedHits×option_symbol = USO261016P00145000×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

5224e517-b549-432d-9372-8d5d9d120e27	2026-08-24 10:00	2026-08-24 10:00	2026-08-24 10:00	USO	USO261016P00145000	put	145.0000	2026-10-16	17.2500	16.6500	17.4500	132.7086	37950.00	37950.00	0.00	22	11	22	552	0.0398550724637681	0.500829450799591	0.500829450799591	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	Financial Services	1228364647.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bfb77d45-11d0-46b2-8be8-070a1bd267d7	2026-09-01 15:20	2026-09-01 15:20	2026-09-01 15:20	USO	USO261016P00145000	put	145.0000	2026-10-16	11.4500	11.4500	11.8000	140.6199	532430.00	0.00	532430.00	465	22	486	557	0.872531418312388	0.476231775826661	0.476231775826661	true	false	false	true
3b728be8-156a-4534-b4c0-a1ef62d76723	2026-09-09 09:48	2026-09-09 09:48	2026-09-09 09:48	USO	USO261016P00145000	put	145.0000	2026-10-16	6.8000	6.7000	6.8000	148.4100	54400.00	54400.00	0.00	80	17	138	1202	0.114808652246256	0.465357596969284	0.465357596969284	false	false	false	true
ba158f21-f8e1-4325-97ae-0ab6d2033f8a	2026-09-09 09:48	2026-09-09 09:48	2026-09-09 09:48	USO	USO261016P00145000	put	145.0000	2026-10-16	6.8000	6.6500	6.8000	148.5024	53720.00	53720.00	0.00	79	6	217	1202	0.180532445923461	0.467372625829044	0.467372625829044	false	false	false	true
01eae251-92b5-42ed-9fa9-2dd353ed14a5	2026-09-09 13:31	2026-09-09 13:31	2026-09-09 13:31	USO	USO261016P00145000	put	145.0000	2026-10-16	6.7000	6.7000	6.8500	148.6500	50250.00	0.00	50250.00	75	5	1602	1202	1.33277870216306	0.465087995436398	0.465087995436398	false	false	false	true
312977ad-d1e7-4fd2-a563-52b4394a74e9	2026-09-09 13:57	2026-09-09 13:56	2026-09-09 13:56	USO	USO261016P00145000	put	145.0000	2026-10-16	6.6500	6.5500	6.8500	148.8800	19285.00	0.00	15295.00	29	6	1635	1202	1.36023294509151	0.467296813253692	0.467296813253692	false	false	false	true
bf227eac-6abd-411f-b79d-62e352c13ad3	2026-09-10 09:37	2026-09-10 09:37	2026-09-10 09:37	USO	USO261016P00145000	put	145.0000	2026-10-16	5.1500	5.1000	5.2000	154.2800	67980.00	62830.00	5150.00	132	8	289	2336	0.123715753424658	0.49495796703099	0.49495796703099	false	false	false	true
98f4fbe2-1ec5-493b-bce2-a4fb32395dd5	2026-09-10 11:58	2026-09-10 11:58	2026-09-10 11:58	USO	USO261016P00145000	put	145.0000	2026-10-16	4.9400	4.9000	5.1500	156.6150	14810.00	5500.00	9310.00	30	7	1072	2336	0.458904109589041	0.520988277885314	0.520988277885314	false	false	false	true
626f871b-ee53-4b45-82b6-38cc226e5bb3	2026-09-10 12:06	2026-09-10 12:06	2026-09-10 12:06	USO	USO261016P00145000	put	145.0000	2026-10-16	5.0000	4.9500	5.1000	156.5101	27000.00	19000.00	8000.00	54	5	1185	2336	0.507277397260274	0.525209201833945	0.525209201833945	false	false	false	true
4237434e-d439-4fa5-867d-10ac1682fa62	2026-09-10 14:31	2026-09-10 14:31	2026-09-10 14:31	USO	USO261016P00145000	put	145.0000	2026-10-16	4.9000	4.7000	4.9500	157.5900	21070.00	15190.00	5880.00	43	9	1592	2336	0.681506849315068	0.53736658243372	0.53736658243372	false	false	false	true
9ed9e71b-55f9-4522-aa29-f350d3315027	2026-09-10 15:20	2026-09-10 15:19	2026-09-10 15:19	USO	USO261016P00145000	put	145.0000	2026-10-16	4.7000	4.7000	4.9000	158.0200	49350.00	0.00	49350.00	105	22	1795	2336	0.768407534246575	0.532268945482637	0.532268945482637	false	false	false	true
73a10a71-a488-482d-84c4-e13ddbd5de44	2026-09-11 09:31	2026-09-11 09:31	2026-09-11 09:31	USO	USO261016P00145000	put	145.0000	2026-10-16	6.0000	6.0000	6.2500	152.0000	21000.00	0.00	21000.00	35	14	93	2686	0.0346239761727476	0.517832983286274	0.517832983286274	true	false	false	true
8e211a0a-2e55-482e-8258-5c50caf2dcac	2026-09-14 15:44	2026-09-14 15:44	2026-09-14 15:44	USO	USO261016P00145000	put	145.0000	2026-10-16	4.8500	4.8500	5.0500	156.0000	23280.00	0.00	23280.00	48	10	932	2514	0.370723945902943	0.539422817384675	0.539422817384675	false	false	false	true
42fd754c-5fab-4165-bfff-a4e7eb264a9b	2026-09-16 12:00	2026-09-16 12:00	2026-09-16 12:00	USO	USO261016P00145000	put	145.0000	2026-10-16	4.4000	4.2000	4.5000	156.3000	44000.00	1760.00	42240.00	100	6	782	3751	0.208477739269528	0.529672871817781	0.529672871817781	false	false	false	true
d6b3af4d-f030-462e-8eb1-54c4da5353ff	2026-09-17 09:42	2026-09-17 09:42	2026-09-17 09:42	USO	USO261016P00145000	put	145.0000	2026-10-16	4.5000	4.5000	4.7500	154.7450	15750.00	0.00	15750.00	35	9	104	4269	0.024361677207777	0.515369289508902	0.515369289508902	true	false	false	true
3cfec69f-4f97-4fd0-9098-01eaa03eb6ae	2026-09-17 10:12	2026-09-17 10:12	2026-09-17 10:12	USO	USO261016P00145000	put	145.0000	2026-10-16	4.4000	4.3500	4.5000	154.0500	417560.00	0.00	417560.00	949	13	1053	4269	0.246661981728742	0.495032366219199	0.495032366219199	true	false	false	true
9ab7027a-8b06-4f96-92e3-bf01e3ec5755	2026-09-18 15:13	2026-09-18 15:13	2026-09-18 15:13	USO	USO261016P00145000	put	145.0000	2026-10-16	4.1000	4.0500	4.2000	153.6100	28288.00	820.00	27468.00	69	6	4386	4790	0.915657620041754	0.4742771068218	0.473599719937682	false	false	false	true
e2b0f22e-f400-4a43-b64c-4abecfce4649	2026-09-21 09:34	2026-09-21 09:34	2026-09-21 09:34	USO	USO261016P00145000	put	145.0000	2026-10-16	4.8900	4.7500	5.0500	149.5900	73368.00	72878.00	490.00	150	15	254	8039	0.0315959696479662	0.463657457964626	0.463657457964626	true	false	false	true
1e900fd1-46bc-4d94-8f12-9d85ca0d5822	2026-09-21 09:34	2026-09-21 09:34	2026-09-21 09:34	USO	USO261016P00145000	put	145.0000	2026-10-16	4.9000	4.7000	5.0500	149.5500	73010.00	71540.00	0.00	149	14	403	8039	0.0501306132603558	0.463657457964626	0.462661016471221	false	false	false	true
f5f67edd-dd1c-4c1b-8f86-a69ed852075b	2026-09-21 09:55	2026-09-21 09:55	2026-09-21 09:55	USO	USO261016P00145000	put	145.0000	2026-10-16	5.2500	5.1000	5.3000	149.2900	24675.00	24150.00	525.00	47	13	551	8039	0.0685408632914542	0.479794289577459	0.479794289577459	false	false	false	true
91f86684-9a56-47da-b367-02bf6ddad759	2026-09-21 10:10	2026-09-21 10:10	2026-09-21 10:10	USO	USO261016P00145000	put	145.0000	2026-10-16	5.4500	5.4500	5.5500	148.0000	52320.00	0.00	52320.00	96	16	686	8039	0.0853339967657669	0.483023939213362	0.483023939213362	true	false	false	true
021beb6f-8d1a-4709-94ea-816963bdbadd	2026-09-21 11:11	2026-09-21 11:11	2026-09-21 11:11	USO	USO261016P00145000	put	145.0000	2026-10-16	5.5500	5.4000	5.5500	148.0000	31635.00	31635.00	0.00	57	12	972	8039	0.120910561015052	0.477213577947126	0.477213577947126	true	false	false	true
4708ff4d-f5ec-4707-b922-9bf109ded6cc	2026-09-21 11:53	2026-09-21 11:52	2026-09-21 11:52	USO	USO261016P00145000	put	145.0000	2026-10-16	5.7000	5.7000	5.8500	148.0500	10830.00	0.00	10830.00	19	9	1827	8039	0.227267073019032	0.477681563659281	0.477681563659281	true	false	false	true
9bee162c-6bfa-42ba-bac5-a5e35811db1c	2026-09-22 09:39	2026-09-22 09:39	2026-09-22 09:39	USO	USO261016P00145000	put	145.0000	2026-10-16	6.7500	6.6000	6.8000	145.5300	45900.00	45225.00	675.00	68	18	246	7246	0.0339497653878002	0.485078147920972	0.485078147920972	true	false	false	true
8ec5e68b-42df-4ab9-a8e8-c51a928f8526	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	USO	USO261016P00145000	put	145.0000	2026-10-16	6.8000	6.7000	6.8500	145.6000	147560.00	137360.00	0.00	217	18	629	7246	0.0868065139387248	0.49060820408491	0.49060820408491	false	false	false	true
17972593-7f97-4db9-8794-a936d984544f	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	USO	USO261016P00145000	put	145.0000	2026-10-16	6.8000	6.7500	6.9000	145.5400	27200.00	9520.00	17680.00	40	5	722	7246	0.0996411813414298	0.488765615240258	0.488765615240258	false	false	false	true
076adbe8-dd0e-41cc-b391-77c1e15d4034	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	USO	USO261016P00145000	put	145.0000	2026-10-16	6.8000	6.7500	6.9000	145.5300	129200.00	35360.00	93840.00	190	13	913	7246	0.126000552028705	0.488457991018003	0.488457991018003	false	false	false	true
7f15ff96-f76b-45e3-8d1d-19b3ce03e1c9	2026-09-22 15:02	2026-09-22 15:02	2026-09-22 15:02	USO	USO261016P00145000	put	145.0000	2026-10-16	6.9000	6.8500	7.1000	145.6299	20010.00	0.00	20010.00	29	5	3571	7246	0.492823626828595	0.498283853532419	0.498283853532419	true	false	false	true
338145ff-5855-44c3-95c2-12aee93c326d	2026-09-23 09:35	2026-09-23 09:35	2026-09-23 09:35	USO	USO261016P00145000	put	145.0000	2026-10-16	6.2000	6.1500	6.2750	146.7700	11160.00	6200.00	4960.00	18	6	24	5344	0.00449101796407186	0.494867022964776	0.494867022964776	true	false	false	true
fd17169f-e771-45be-b1d9-413d9df487b2	2026-09-23 13:56	2026-09-23 13:56	2026-09-23 13:56	USO	USO261016P00145000	put	145.0000	2026-10-16	6.1000	6.0500	6.1000	147.3200	46360.00	46360.00	0.00	76	22	375	5344	0.0701721556886228	0.504046018959204	0.504046018959204	false	false	false	true
2464e385-1f6a-43a7-bcbc-9fc55601b948	2026-09-23 13:56	2026-09-23 13:56	2026-09-23 13:56	USO	USO261016P00145000	put	145.0000	2026-10-16	6.1000	6.0500	6.1000	147.3200	20740.00	15860.00	0.00	34	5	428	5344	0.0800898203592814	0.504046018959204	0.504046018959204	false	false	false	true
6236baf4-8142-41aa-b172-7ea0489dd5f1	2026-09-23 13:56	2026-09-23 13:56	2026-09-23 13:56	USO	USO261016P00145000	put	145.0000	2026-10-16	6.1000	6.0500	6.1000	147.3200	37210.00	610.00	0.00	61	13	489	5344	0.0915044910179641	0.504046018959204	0.504046018959204	false	false	false	true
81e642c2-0870-46a9-9f8e-cd26dd876a7b	2026-09-23 13:57	2026-09-23 13:56	2026-09-23 13:56	USO	USO261016P00145000	put	145.0000	2026-10-16	6.1000	6.0500	6.1000	147.3200	15860.00	2440.00	0.00	26	7	527	5344	0.0986152694610778	0.504046018959204	0.504046018959204	false	false	false	true
52f4d949-8d96-4f87-95df-5bf4c22d720f	2026-09-23 13:57	2026-09-23 13:56	2026-09-23 13:56	USO	USO261016P00145000	put	145.0000	2026-10-16	6.1000	6.0500	6.1000	147.3200	17080.00	5490.00	0.00	28	6	555	5344	0.103854790419162	0.504046018959204	0.504046018959204	false	false	false	true
00a39dff-bb45-4f8f-9647-640f15ecfea9	2026-09-24 12:24	2026-09-24 12:23	2026-09-24 12:23	USO	USO261016P00145000	put	145.0000	2026-10-16	4.3200	4.3000	4.4000	151.9300	21600.00	0.00	21600.00	50	7	2511	5227	0.480390281232064	0.509685825740094	0.509685825740094	false	false	false	true
3b5fdcde-b0ff-46ca-8897-11cdc0ea42f0	2026-09-24 12:51	2026-09-24 12:51	2026-09-24 12:51	USO	USO261016P00145000	put	145.0000	2026-10-16	4.8000	4.6500	4.8000	150.9100	16800.00	16800.00	0.00	35	7	2763	5227	0.52860149225177	0.519864086778373	0.519864086778373	true	false	false	true
15bb4682-32e7-46b0-9e20-345f68cc930a	2026-09-25 09:31	2026-09-25 09:31	2026-09-25 09:31	USO	USO261016P00145000	put	145.0000	2026-10-16	5.0000	5.0000	5.3000	149.8600	74000.00	0.00	74000.00	148	21	171	4705	0.0363443145589798	0.51878412639838	0.51878412639838	true	false	false	true
6748aed9-04e5-4fc5-adf6-2802e73e57f2	2026-09-25 12:07	2026-09-25 12:07	2026-09-25 12:07	USO	USO261016P00145000	put	145.0000	2026-10-16	6.0500	5.6000	6.5000	147.4299	23595.00	22990.00	605.00	39	10	370	4705	0.0786397449521785	0.52624483457338	0.52624483457338	true	false	false	true
e22cefa2-0dee-4380-8e26-262059b5d5fb	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	USO	USO261016P00145000	put	145.0000	2026-10-16	4.6500	4.5500	4.7000	150.4900	14880.00	465.00	14415.00	32	14	201	4786	0.0419974926870038	0.547172773006691	0.54887461008755	true	false	false	true
3b391ee3-3718-4457-ba50-df220df677c0	2026-09-29 09:36	2026-09-29 09:36	2026-09-29 09:36	USO	USO261016P00145000	put	145.0000	2026-10-16	6.4500	6.3500	6.4500	145.4800	14835.00	14835.00	0.00	23	6	62	4774	0.012987012987013	0.546197782687534	0.546197782687534	false	false	false	true
e7707498-dd87-48b8-a888-a29b5b5f72a5	2026-09-29 09:43	2026-09-29 09:43	2026-09-29 09:43	USO	USO261016P00145000	put	145.0000	2026-10-16	6.3000	6.2500	6.5000	146.0200	44100.00	630.00	39060.00	70	14	274	4774	0.0573942186845413	0.55378240389619	0.55378240389619	false	false	false	true
d0faa487-b9b9-47f1-92c4-fa1f96bd5f37	2026-09-29 09:43	2026-09-29 09:43	2026-09-29 09:43	USO	USO261016P00145000	put	145.0000	2026-10-16	6.3000	6.2500	6.5500	146.0200	42210.00	630.00	41580.00	67	22	204	4774	0.0427314620863008	0.55378240389619	0.55378240389619	true	false	false	true
daf7a065-c515-4dc9-a6d2-a388c05b43b2	2026-09-29 09:51	2026-09-29 09:51	2026-09-29 09:51	USO	USO261016P00145000	put	145.0000	2026-10-16	6.1000	6.0500	6.2000	146.2800	315980.00	83570.00	212890.00	518	33	803	4774	0.168202764976959	0.547340473431337	0.546986780261019	false	false	false	true
a5ce77b4-5024-438b-b0c8-7c4c24f31d96	2026-09-29 14:26	2026-09-29 14:25	2026-09-29 14:25	USO	USO261016P00145000	put	145.0000	2026-10-16	6.8000	6.7000	6.9000	144.0000	23120.00	17680.00	5440.00	34	13	906	4774	0.189777963971512	0.525918833807677	0.525918833807677	true	false	false	true
52f12568-92a1-435b-9cd6-330b5d298b8e	2026-09-29 14:29	2026-09-29 14:29	2026-09-29 14:29	USO	USO261016P00145000	put	145.0000	2026-10-16	6.9900	6.9500	7.1500	143.0000	47530.00	43330.00	4200.00	68	18	1014	4774	0.212400502723083	0.52325461802659	0.52325461802659	true	false	false	true
8a2aa9c7-90f1-42d0-bcdc-31e0098cabd2	2026-10-01 15:12	2026-10-01 15:12	2026-10-01 15:12	USO	USO261016P00145000	put	145.0000	2026-10-16	3.7500	3.6500	3.8000	149.6100	93750.00	93750.00	0.00	250	13	2668	4929	0.541286264962467	0.492382339171128	0.492382339171128	true	false	false	true
68be1950-c2be-4814-a6fa-face138ae9bc	2026-10-02 09:57	2026-10-02 09:57	2026-10-02 09:57	USO	USO261016P00145000	put	145.0000	2026-10-16	5.5500	5.3500	5.6000	144.4800	20535.00	20535.00	0.00	37	6	1121	6541	0.171380522855832	0.478187915417089	0.478187915417089	false	false	false	true
c7358417-6c73-4854-9c55-aa3d8846ac29	2026-10-02 13:22	2026-10-02 13:22	2026-10-02 13:22	USO	USO261016P00145000	put	145.0000	2026-10-16	4.3000	4.1500	4.3500	147.2200	10750.00	10750.00	0.00	25	9	2979	6541	0.45543494878459	0.476687551033157	0.476687551033157	true	false	false	true