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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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

322d11ac-3f2c-40c2-8a22-486c4fa22d49	2026-09-28 13:11	2026-09-28 13:11	2026-09-28 13:11	USO	USO261016P00145000	put	145.0000	2026-10-16	5.5800	5.4000	5.7500	148.2300	17300.00	5600.00	8340.00	31	15	272	4786	0.0568324279147514	0.55735183697666	0.557037977077666	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-28T17:11:57.740479Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
6f4c2730-e107-4a28-9493-3001a0716be8	2026-09-28 13:11	2026-09-28 13:11	2026-09-28 13:11	USO	USO261120C00150000	call	150.0000	2026-11-20	11.0200	11.0000	12.3000	148.4200	20945.00	9945.00	11000.00	19	7	136	4985	0.0272818455366098	0.499240776640577	0.504049674867629	true	false	false	true
83c992df-a8eb-44cc-b05d-c4c3e04a24bf	2026-09-28 13:08	2026-09-28 13:08	2026-09-28 13:08	USO	USO261106P00144000	put	144.0000	2026-11-06	7.1500	7.1000	7.4000	150.2500	12160.00	0.00	11440.00	17	6	55	0	0	0.535144226903973	0.535144226903973	true	false	false	true
045d1fe2-ed41-4412-8934-be9a0bd3b653	2026-09-28 13:02	2026-09-28 13:02	2026-09-28 13:02	USO	USO270115C00150000	call	150.0000	2027-01-15	16.1700	15.8500	16.2000	149.8850	456092.00	452872.00	3220.00	282	7	510	5083	0.100334448160535	0.471733959567986	0.4676937378592	true	false	false	true
46a2af6e-728a-4664-9709-94736a97c06f	2026-09-28 12:57	2026-09-28 12:57	2026-09-28 12:57	USO	USO261009C00165000	call	165.0000	2026-10-09	1.2800	1.2800	1.3400	149.6439	15872.00	0.00	15872.00	124	18	317	763	0.415465268676278	0.558537591529386	0.558537591529386	true	false	false	true
fdcdd0a5-8aef-4c53-8fa1-f5fae0b77869	2026-09-28 12:56	2026-09-28 12:56	2026-09-28 12:56	USO	USO270115C00150000	call	150.0000	2027-01-15	15.8800	15.5500	16.1500	149.5900	117502.00	117502.00	0.00	74	13	227	5083	0.0446586661420421	0.466374474934694	0.466374474934694	false	false	false	true
989cf8f6-442f-446f-95be-8b80ad2e6483	2026-09-28 12:51	2026-09-28 12:51	2026-09-28 12:51	USO	USO261030P00148000	put	148.0000	2026-10-30	8.1000	7.3500	8.2500	149.9350	10530.00	10530.00	0.00	13	9	43	267	0.161048689138577	0.529282245211313	0.529282245211313	true	false	false	true
21cc7d90-ce03-4a37-a32c-209546157383	2026-09-28 12:44	2026-09-28 12:44	2026-09-28 12:44	USO	USO261007C00152000	call	152.0000	2026-10-07	4.4000	4.3000	4.4000	149.0000	44000.00	44000.00	0.00	100	9	229	6	38.1666666666667	0.565812922295843	0.565812922295843	false	false	false	true
9cfb20c1-dd6c-442a-8cb1-1ba9c7bad3c9	2026-09-28 12:42	2026-09-28 12:42	2026-09-28 12:42	USO	USO261002P00145000	put	145.0000	2026-10-02	2.1900	2.0700	2.2000	149.0000	14015.00	14015.00	0.00	64	25	5997	4146	1.44645441389291	0.671309454888369	0.671309454888369	true	false	false	true
bfc61418-0fd5-4046-ad41-63f81e61ac88	2026-09-28 12:41	2026-09-28 12:41	2026-09-28 12:41	USO	USO261002P00145000	put	145.0000	2026-10-02	2.2000	2.1800	2.2200	149.0000	17380.00	16060.00	0.00	79	6	5908	4146	1.42498794018331	0.6642788367548	0.6642788367548	false	false	false	true
bd392023-71bb-428b-b9b6-4e3ffae9fe0e	2026-09-28 12:41	2026-09-28 12:41	2026-09-28 12:41	USO	USO261002P00145000	put	145.0000	2026-10-02	2.2100	2.1700	2.2800	149.0000	27816.00	14119.00	12157.00	126	8	5601	4146	1.35094066570188	0.669668020532563	0.669668020532563	false	false	false	true
3e626d11-a946-47d1-9738-adf8df006c8b	2026-09-28 12:41	2026-09-28 12:40	2026-09-28 12:40	USO	USO261009C00152000	call	152.0000	2026-10-09	4.6700	4.5500	4.7000	149.0000	18695.00	18695.00	0.00	40	7	188	349	0.538681948424069	0.557475925316357	0.552612120860395	false	false	false	true
9be19bf2-10e0-410a-baf7-a416abde6a5c	2026-09-28 12:39	2026-09-28 12:38	2026-09-28 12:38	USO	USO261120P00120000	put	120.0000	2026-11-20	1.8200	1.7200	1.8900	149.6203	17836.00	728.00	17108.00	98	6	246	3726	0.0660225442834139	0.535139145060845	0.535139145060845	false	false	false	true
03972d9c-90b8-44fb-b34d-0056843b8031	2026-09-28 12:38	2026-09-28 12:38	2026-09-28 12:38	USO	USO261030P00146000	put	146.0000	2026-10-30	7.3500	7.3000	8.7500	149.4673	15435.00	1470.00	13965.00	21	12	50	83	0.602409638554217	0.529521459936658	0.529521459936658	true	false	false	true
5de2d0f9-abea-4a2e-b1e5-33c1d70005c8	2026-09-28 12:36	2026-09-28 12:36	2026-09-28 12:36	USO	USO261016C00141000	call	141.0000	2026-10-16	12.2800	12.0500	12.8000	149.3900	30700.00	6100.00	24600.00	25	6	49	443	0.110609480812641	0.556368830730534	0.54758365849263	true	false	false	true
1c358041-7c03-4215-8b0e-ffe4ddc79262	2026-09-28 12:36	2026-09-28 12:36	2026-09-28 12:36	USO	USO261016P00138000	put	138.0000	2026-10-16	2.8700	2.8700	3.0500	149.4250	10332.00	0.00	10332.00	36	15	146	408	0.357843137254902	0.57234373994802	0.57234373994802	false	false	false	true
97019b37-d0e8-4bd0-83df-80aeed06005c	2026-09-28 12:34	2026-09-28 12:34	2026-09-28 12:34	USO	USO261106P00146500	put	146.5000	2026-11-06	8.5000	6.7000	8.7000	149.2692	11050.00	10200.00	850.00	13	9	15	1	15	0.526625479865478	0.526625479865478	true	false	false	true
a12980a2-7840-4d81-94c7-935422ed0176	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	USO	USO261007C00150000	call	150.0000	2026-10-07	5.0500	4.5000	5.0500	149.0900	10100.00	10100.00	0.00	20	7	123	91	1.35164835164835	0.579238011104156	0.579238011104156	true	false	false	true
1a2a016f-2339-4331-bbb9-fc2217a9875c	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	USO	USO261106C00175000	call	175.0000	2026-11-06	3.1000	2.8700	3.8000	149.4094	19220.00	620.00	18600.00	62	20	72	1	72	0.546077961722246	0.546077961722246	true	false	false	true
082378cb-6457-493b-a5ad-4507990e8786	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	USO	USO261002P00145000	put	145.0000	2026-10-02	2.2600	2.1800	2.3900	149.4650	56376.00	0.00	56376.00	250	5	5457	4146	1.31620839363242	0.672991706828829	0.672991706828829	false	false	false	true
2669892a-f79f-4cce-ba42-6baec2388da2	2026-09-28 12:32	2026-09-28 12:32	2026-09-28 12:32	USO	USO261023P00150000	put	150.0000	2026-10-23	8.6500	8.2500	8.6500	148.8600	13840.00	13840.00	0.00	16	10	166	142	1.16901408450704	0.532020156503201	0.532020156503201	false	false	false	true
a3aadcf8-4592-47b6-8f81-d22c2e8e932f	2026-09-28 12:31	2026-09-28 12:31	2026-09-28 12:31	USO	USO260930C00151000	call	151.0000	2026-09-30	2.0600	1.9200	2.0500	148.9050	12350.00	11942.00	408.00	60	10	563	404	1.39356435643564	0.671228079299466	0.670292425142188	false	false	false	true
e3ad72a4-ccd9-4479-8d26-545fa1e55b6b	2026-09-28 12:31	2026-09-28 12:31	2026-09-28 12:31	USO	USO261023P00140000	put	140.0000	2026-10-23	4.3900	4.3000	5.0000	149.0000	10985.00	1745.00	9240.00	25	16	124	764	0.162303664921466	0.549874621485871	0.546181686605338	true	false	false	true
7833b3e7-1952-427d-a59c-b4930a8e12dd	2026-09-28 12:31	2026-09-28 12:31	2026-09-28 12:31	USO	USO261106P00144000	put	144.0000	2026-11-06	7.5600	7.5000	8.6000	149.0000	11335.00	5295.00	6040.00	15	5	36	0	0	0.531777631664163	0.531777631664163	true	false	false	true
36f89438-0fdc-4604-9669-dc3019a9174d	2026-09-28 12:31	2026-09-28 12:31	2026-09-28 12:31	USO	USO261002P00145000	put	145.0000	2026-10-02	2.5000	2.3700	2.6100	148.0000	68000.00	25250.00	42500.00	272	12	5186	4146	1.25084418716836	0.677199266190684	0.677199266190684	true	false	false	true
ad2bb0b1-78ce-4ce8-b954-d6b4c08d0812	2026-09-28 12:31	2026-09-28 12:30	2026-09-28 12:30	USO	USO261009C00156000	call	156.0000	2026-10-09	2.8700	2.0400	2.9900	148.0000	13210.00	11494.00	1716.00	46	10	53	301	0.176079734219269	0.548533799385645	0.545311510977415	false	false	false	true
0cb9c5b6-9097-470e-9862-a060f1b9e084	2026-09-28 12:31	2026-09-28 12:30	2026-09-28 12:30	USO	USO270115P00155000	put	155.0000	2027-01-15	18.6000	17.3000	19.3000	148.0000	50220.00	27900.00	22320.00	27	5	83	1100	0.0754545454545455	0.497972644411324	0.497972644411324	false	false	false	true
919526bf-66e5-4321-b18f-9c4cce735b2f	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	USO	USO261120P00160000	put	160.0000	2026-11-20	18.5300	17.1500	18.5500	148.0000	61135.00	31535.00	29600.00	33	12	49	437	0.112128146453089	0.529411852367374	0.527119336118747	true	false	false	true
57429c53-a0f3-4828-b63f-c0e9c620fb7d	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	USO	USO261120P00161000	put	161.0000	2026-11-20	19.2200	17.0000	19.2500	148.0000	67285.00	67285.00	0.00	35	5	35	205	0.170731707317073	0.530511054346325	0.530511054346325	false	false	false	true
f982945e-9ca2-4a72-ad88-d67e5d724f20	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	USO	USO261120P00147000	put	147.0000	2026-11-20	10.6500	10.4000	10.6500	148.0000	23430.00	23430.00	0.00	22	7	33	125	0.264	0.521144240305302	0.521144240305302	false	false	false	true
4e7df651-eb57-4ebf-a1b7-ed796d5e17cd	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	USO	USO261106P00149500	put	149.5000	2026-11-06	10.5100	8.5500	10.6500	148.0000	18910.00	18910.00	0.00	18	10	24	1	24	0.528085432823494	0.534876968779964	true	false	false	true
d99fc43d-5b11-413a-9737-5fe4d8b281af	2026-09-28 12:30	2026-09-28 12:29	2026-09-28 12:29	USO	USO261120P00139000	put	139.0000	2026-11-20	6.9500	6.9500	8.7000	148.0000	27105.00	0.00	27105.00	39	14	40	53	0.754716981132076	0.52303467551462	0.52303467551462	true	false	false	true
a77d3f09-3df7-4fc2-ba6c-301250a4a348	2026-09-28 12:30	2026-09-28 12:29	2026-09-28 12:29	USO	USO261120P00141000	put	141.0000	2026-11-20	7.7500	7.7500	8.0000	148.0000	12400.00	0.00	12400.00	16	7	19	163	0.116564417177914	0.522248821543103	0.522248821543103	true	false	false	true
5d28549e-15ae-4442-ab60-78350bb69438	2026-09-28 12:29	2026-09-28 12:29	2026-09-28 12:29	USO	USO261120P00100000	put	100.0000	2026-11-20	0.3600	0.3000	0.3600	148.0000	29520.00	29520.00	0.00	820	12	3238	2423	1.33635988444078	0.576590536293975	0.576590536293975	false	false	false	true
234e8f31-064d-461d-bc1d-3208e61d425a	2026-09-28 12:28	2026-09-28 12:28	2026-09-28 12:28	USO	USO261030P00149500	put	149.5000	2026-10-30	9.5500	9.3000	9.6500	148.2862	36290.00	16235.00	20055.00	38	5	53	55	0.963636363636364	0.525383966135737	0.525383966135737	false	false	false	true
b7ce46c6-8388-43b6-8ac9-d7db671b9e7b	2026-09-28 12:28	2026-09-28 12:28	2026-09-28 12:28	USO	USO260930P00147000	put	147.0000	2026-09-30	2.5300	2.4500	2.5700	148.3350	13662.00	13409.00	253.00	54	10	564	811	0.695437731196054	0.72639509151167	0.72639509151167	true	false	false	true
c359d0a9-e85c-498c-b014-79624bbd27d1	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	USO	USO261009P00136000	put	136.0000	2026-10-09	1.6900	1.6900	1.9600	148.6200	13351.00	0.00	13351.00	79	12	89	497	0.17907444668008	0.615119018253307	0.615119018253307	false	false	false	true
f7b3aca7-8071-42a5-b2f5-a275076e7065	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	USO	USO261218P00120000	put	120.0000	2026-12-18	3.0000	2.5000	3.2000	148.0250	13199.00	4499.00	8700.00	44	7	244	5010	0.0487025948103792	0.503109552817617	0.503063601946697	false	false	false	true
a61435fe-0741-4cb0-8745-b7636b0d72fc	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	USO	USO261002C00150000	call	150.0000	2026-10-02	3.3000	3.1000	3.3500	148.4156	22440.00	16830.00	3960.00	68	8	625	2346	0.266410912190963	0.644332142989277	0.644332142989277	false	false	false	true
fe7cde82-7053-4a63-9f16-ddfac5452ddf	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	USO	USO261023P00150000	put	150.0000	2026-10-23	8.9500	8.7000	8.9500	148.4600	10740.00	9845.00	0.00	12	5	143	142	1.00704225352113	0.53841190694085	0.538730248146671	false	false	false	true
ac6789e2-fba7-4a18-a56f-5e00bb5538da	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	USO	USO261009C00154000	call	154.0000	2026-10-09	3.6000	3.3000	3.6000	148.8900	443880.00	443880.00	0.00	1233	17	1239	143	8.66433566433567	0.546702896047349	0.546702896047349	false	false	false	true
9b18b8a1-904f-4d09-b9c7-ea03a2374ae4	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	USO	USO261002P00160000	put	160.0000	2026-10-02	11.4700	10.1000	11.5500	149.3000	25229.00	18449.00	6780.00	22	9	77	310	0.248387096774194	0.684451167242698	0.599528462469987	false	false	false	true
8606b2dd-4cd3-4bbe-914c-30430633281a	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	USO	USO261007C00153000	call	153.0000	2026-10-07	3.6000	3.6000	4.8000	149.3000	11160.00	0.00	11160.00	31	5	147	109	1.34862385321101	0.543664043358392	0.547715667675508	false	false	false	true
2cf500a4-e270-45b5-9ddf-e69f3f3c4ec1	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	USO	USO261009P00146000	put	146.0000	2026-10-09	4.2000	4.0000	4.3500	149.4528	14292.00	3792.00	10500.00	34	10	43	279	0.154121863799283	0.571071590135127	0.571071590135127	false	false	false	true
a2d51732-f34a-4954-9875-1e3d08c18f43	2026-09-28 12:25	2026-09-28 12:25	2026-09-28 12:25	USO	USO261120C00169000	call	169.0000	2026-11-20	5.2500	4.9500	5.2500	149.3600	69275.00	69275.00	0.00	132	20	141	197	0.715736040609137	0.515362827869776	0.515362827869776	false	false	false	true
64c032c8-0974-4dfc-8e23-c0292af718c7	2026-09-28 12:25	2026-09-28 12:25	2026-09-28 12:25	USO	USO261120P00122000	put	122.0000	2026-11-20	2.1200	2.1200	2.3400	149.5450	16960.00	0.00	16960.00	80	23	81	39	2.07692307692308	0.53177158743473	0.53177158743473	false	false	false	true
0cee8339-afa0-4d8d-90ba-8a3c5464430e	2026-09-28 12:25	2026-09-28 12:25	2026-09-28 12:25	USO	USO270115P00100000	put	100.0000	2027-01-15	1.1500	1.1500	1.2400	149.4600	11388.00	0.00	11388.00	99	30	305	14739	0.0206933984666531	0.525415166853397	0.526495930525997	true	false	false	true
34852d2a-e79d-4e2b-a626-91dcae8db86d	2026-09-28 12:24	2026-09-28 12:24	2026-09-28 12:24	USO	USO261030C00162000	call	162.0000	2026-10-30	4.6500	4.3000	4.6500	149.5941	11625.00	11625.00	0.00	25	9	45	517	0.0870406189555126	0.512397886544797	0.512397886544797	true	false	false	true
81ea745c-e208-4003-924f-ff430ab9b5dc	2026-09-28 12:24	2026-09-28 12:24	2026-09-28 12:24	USO	USO261016C00160000	call	160.0000	2026-10-16	3.3000	3.1500	3.3000	150.0405	14850.00	14850.00	0.00	45	18	396	6250	0.06336	0.518254180206563	0.518254180206563	true	false	false	true
6035bc5d-d20e-43c4-ad65-493ccb0834f9	2026-09-28 12:24	2026-09-28 12:24	2026-09-28 12:24	USO	USO261016C00161000	call	161.0000	2026-10-16	3.0500	3.0000	3.1500	150.0405	12504.00	12199.00	305.00	41	13	44	297	0.148148148148148	0.519577860938602	0.519577860938602	true	false	false	true