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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = unknown×ticker = OXY×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

638b0bcf-b226-4653-8d90-7ac7569b2fbd	2026-09-16 15:58	2026-09-16 15:58	2026-09-16 15:58	OXY	OXY281215P00052500	put	52.5000	2028-12-15	6.6500	5.8000	7.9000	59.0000	77140.00	3325.00	73815.00	116	15	116	60	1.93333333333333	0.373819154143174	0.373819154143174	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	59338474343.00	2026-11-09	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
5292c21a-9f7a-46a5-9ccb-15a683bbda56	2026-09-15 15:20	2026-09-15 15:20	2026-09-15 15:20	OXY	OXY260918C00063000	call	63.0000	2026-09-18	1.1000	1.0800	1.1400	63.3500	55550.00	110.00	55440.00	505	20	1347	9861	0.136598722239124	0.395170741946995	0.395170741946995	false	false	false	true
517391ce-33c5-4711-baf6-297ec6479b59	2026-09-15 14:05	2026-09-15 14:05	2026-09-15 14:05	OXY	OXY270617C00067500	call	67.5000	2027-06-17	6.5000	6.2500	6.6500	63.6200	65000.00	65000.00	0.00	100	5	321	9392	0.0341780238500852	0.328841507572089	0.328841507572089	false	false	false	true
ccdf437b-e34a-419c-906f-308eecf26263	2026-09-15 14:05	2026-09-15 14:05	2026-09-15 14:05	OXY	OXY261016C00065000	call	65.0000	2026-10-16	2.0100	2.0100	2.0400	63.6300	70350.00	0.00	70350.00	350	22	8088	10488	0.77116704805492	0.340708543213822	0.340708543213822	false	false	false	true
33909e53-7b87-44e0-9209-fc0ab35a2374	2026-09-15 13:31	2026-09-15 13:31	2026-09-15 13:31	OXY	OXY261016C00065000	call	65.0000	2026-10-16	2.0000	2.0000	2.0200	63.5250	159800.00	0.00	159800.00	799	5	7175	10488	0.684115179252479	0.345732582613868	0.345732582613868	false	false	false	true
de609c47-cdf9-4194-a12f-3d2ff08ff7f7	2026-09-15 13:22	2026-09-15 13:22	2026-09-15 13:22	OXY	OXY261218C00065000	call	65.0000	2026-12-18	3.9000	3.7500	3.9500	63.4550	113100.00	111930.00	0.00	290	13	360	6021	0.0597907324364723	0.333956870557668	0.333761321112461	true	false	false	true
b37a01d5-6e35-447e-8e48-ef5aa4448e9a	2026-09-15 13:22	2026-09-15 13:22	2026-09-15 13:22	OXY	OXY261120C00067500	call	67.5000	2026-11-20	2.3400	2.2300	2.3400	63.4500	50310.00	50310.00	0.00	215	10	246	1943	0.126608337622234	0.349075057588757	0.349075057588757	false	false	false	true
af5b446e-9306-4920-978f-864d81094a5e	2026-09-15 13:22	2026-09-15 13:22	2026-09-15 13:22	OXY	OXY261218C00070000	call	70.0000	2026-12-18	2.2300	2.1200	2.3100	63.4550	280756.00	277858.00	2898.00	1259	34	1360	4463	0.304727761595339	0.339709304402188	0.338715233260614	false	false	false	true
5f311c23-2aff-4a99-87ac-4cc0f39be8ff	2026-09-15 13:22	2026-09-15 13:22	2026-09-15 13:22	OXY	OXY261016C00062500	call	62.5000	2026-10-16	3.1000	3.0000	3.2500	63.4500	238060.00	235270.00	310.00	768	49	1086	5217	0.208165612420932	0.338609013946454	0.338609013946454	false	false	false	true
41489d05-4062-4250-a959-44f25b2a758d	2026-09-15 13:21	2026-09-15 13:20	2026-09-15 13:20	OXY	OXY261120C00065000	call	65.0000	2026-11-20	3.1000	3.0500	3.3000	63.3000	1520440.00	117490.00	186200.00	4897	45	5255	3195	1.64475743348983	0.341916645446523	0.339480782469135	true	false	false	true
bab47170-7ce1-4b0a-a7bc-9ada5e5a6304	2026-09-15 13:19	2026-09-15 13:19	2026-09-15 13:19	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.8000	1.7700	1.8000	63.3100	741240.00	741240.00	0.00	4118	9	6037	10488	0.575610221205187	0.331947009734306	0.331065698083806	false	false	false	true
a4c37e9a-d712-4fe0-8ac8-c7b9966430be	2026-09-15 13:19	2026-09-15 13:19	2026-09-15 13:19	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.8000	1.7900	1.8600	63.2900	104130.00	3075.00	95829.00	578	37	1788	10488	0.170480549199085	0.332827441874148	0.332240584487935	true	false	false	true
d6fb9b65-b617-4b52-8466-28296f2c6ac4	2026-09-15 13:17	2026-09-15 13:17	2026-09-15 13:17	OXY	OXY260925C00065000	call	65.0000	2026-09-25	0.7500	0.7400	0.8200	63.2450	377356.00	299327.00	54779.00	5021	56	5349	536	9.9794776119403	0.342098458634375	0.339900378599664	true	false	false	true
b3153bad-5fc0-46dc-af35-1defbf1a4a7d	2026-09-15 13:15	2026-09-15 13:15	2026-09-15 13:15	OXY	OXY270115C00065000	call	65.0000	2027-01-15	4.3400	4.2500	4.5000	63.2050	1445690.00	194795.00	1250895.00	3333	88	8462	53299	0.158764704778701	0.32071449676725	0.322877160370498	true	false	false	true
5720c230-573f-4daa-a0d2-dfc7debe0771	2026-09-15 13:14	2026-09-15 13:14	2026-09-15 13:14	OXY	OXY270115C00065000	call	65.0000	2027-01-15	4.3500	4.3500	4.5000	63.2700	153990.00	0.00	153990.00	354	9	5129	53299	0.0962306985121672	0.324039544749928	0.324039544749928	true	false	false	true
e19e654a-d513-4de3-8da5-ab35594b9554	2026-09-15 13:14	2026-09-15 13:14	2026-09-15 13:14	OXY	OXY270115C00065000	call	65.0000	2027-01-15	4.4000	4.3500	4.5000	63.3700	1054116.00	170280.00	883836.00	2395	54	4713	53299	0.0884256740276553	0.324627896470193	0.323961805151782	true	false	false	true
6ffcabdb-fd95-451d-893a-2733f29242a3	2026-09-15 13:13	2026-09-15 13:13	2026-09-15 13:13	OXY	OXY270115C00065000	call	65.0000	2027-01-15	4.5000	4.4500	4.6000	63.4550	548568.00	450.00	548118.00	1219	35	2317	53299	0.0434717349293608	0.327079222060642	0.327809858694251	true	false	false	true
6c76cae3-79df-4323-a234-454929799aa8	2026-09-15 10:55	2026-09-15 10:55	2026-09-15 10:55	OXY	OXY280121P00067500	put	67.5000	2028-01-21	11.2200	11.0500	11.3000	62.0000	50470.00	50470.00	0.00	45	5	295	208	1.41826923076923	0.377269250726482	0.376919435361466	false	false	false	true	false
f7c7ea80-0663-434e-9633-dd054e0effe9	2026-09-15 10:54	2026-09-15 10:53	2026-09-15 10:53	OXY	OXY280121P00067500	put	67.5000	2028-01-21	11.3000	11.2500	11.3500	62.0000	58760.00	3390.00	24860.00	52	7	201	208	0.966346153846154	0.381118246409364	0.381118246409364	true	false	false	true
d81cd892-155d-4c52-a15f-f1b501da814d	2026-09-15 10:53	2026-09-15 10:53	2026-09-15 10:53	OXY	OXY280121P00067500	put	67.5000	2028-01-21	11.2800	11.0500	11.3000	62.0000	57529.00	57529.00	0.00	51	5	149	208	0.716346153846154	0.378431228103713	0.378431228103713	false	false	false	true	false
83212206-22d9-4960-9547-a90d75f9cc27	2026-09-15 10:34	2026-09-15 10:34	2026-09-15 10:34	OXY	OXY261120P00060000	put	60.0000	2026-11-20	2.1700	2.0900	2.1700	62.9500	123907.00	123907.00	0.00	571	26	579	1365	0.424175824175824	0.348449557206701	0.348449557206701	false	false	false	true
dd1d7eea-b34e-4782-a031-8bf670b37094	2026-09-15 09:36	2026-09-15 09:35	2026-09-15 09:35	OXY	OXY261120C00055000	call	55.0000	2026-11-20	9.2000	8.5000	9.2000	62.8647	63480.00	63480.00	0.00	69	7	112	1971	0.0568239472349061	0.369778315428555	0.369778315428555	false	false	false	true
cc0874ac-0212-4179-bd5a-22de1795cc38	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	OXY	OXY260918C00052500	call	52.5000	2026-09-18	9.0500	9.0500	9.7500	61.6850	1107772.00	0.00	1107772.00	1224	28	1239	2228	0.556104129263914	1.3801558422877	1.04533897391381	false	false	false	true
c37bdd7d-ae4a-4d76-9fe4-5baec3069a97	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	OXY	OXY260918C00055000	call	55.0000	2026-09-18	6.5500	6.5500	7.3000	61.6850	239732.00	0.00	239732.00	366	11	389	125	3.112	1.12222917352481	0.853752862759582	false	false	false	true	false
aac0ef8e-bf42-4273-99aa-8e8557eee0cb	2026-09-14 14:30	2026-09-14 14:30	2026-09-14 14:30	OXY	OXY261016P00062500	put	62.5000	2026-10-16	2.5700	2.4700	2.5700	62.0700	53456.00	53456.00	0.00	208	13	922	458	2.01310043668122	0.335686596336276	0.335686596336276	false	false	false	true	false
2dc7b7af-e402-4b2c-9c2b-1b392fe51705	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	OXY	OXY260918C00057500	call	57.5000	2026-09-18	4.6000	4.6000	5.2000	62.0600	77754.00	0.00	77754.00	169	13	199	3891	0.0511436648676433	0.866125077732529	0.353097840421528	false	false	false	true
88ed4896-4bbf-4203-9565-c3b54dc1efbc	2026-09-14 11:49	2026-09-14 11:49	2026-09-14 11:49	OXY	OXY261016P00062500	put	62.5000	2026-10-16	2.4100	2.3500	2.4100	62.3750	106522.00	106522.00	0.00	442	13	505	458	1.10262008733624	0.333994191171804	0.333994191171804	false	false	false	true	false
5253573b-ff59-4e23-8012-fba6cea8c8c0	2026-09-14 09:30	2026-09-14 09:30	2026-09-14 09:30	OXY	OXY261016C00062500	call	62.5000	2026-10-16	2.4900	2.4900	2.7700	62.5600	62318.00	0.00	45318.00	250	9	251	6067	0.0413713532223504	0.318371626229467	0.318371626229467	false	false	false	true
e2f06682-f7fb-411f-842b-29ba22961ec1	2026-09-11 10:10	2026-09-11 10:10	2026-09-11 10:10	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.1500	1.1300	1.2000	61.0700	111205.00	9545.00	101660.00	967	40	5179	14102	0.367252871933059	0.334368849435451	0.3334527835215	false	false	false	true
ff882971-931c-477a-a08b-04d316326bc4	2026-09-11 09:39	2026-09-11 09:39	2026-09-11 09:39	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.0000	1.0000	1.0600	60.6300	114316.00	0.00	114316.00	1143	49	3180	14102	0.225499929088073	0.327267423598397	0.331499670176248	false	false	false	true
97a94a38-d85f-4b34-adc1-7cad89d0f1f6	2026-09-10 15:37	2026-09-10 15:37	2026-09-10 15:37	OXY	OXY270115C00065000	call	65.0000	2027-01-15	3.5000	3.4000	3.5000	61.0500	69960.00	69960.00	0.00	200	19	329	53221	0.00618177035380771	0.331254112336771	0.331563818770777	false	false	false	true
d0a66fda-5987-4da1-8436-84fd48f2e8f9	2026-09-10 15:36	2026-09-10 15:36	2026-09-10 15:36	OXY	OXY261120C00062500	call	62.5000	2026-11-20	3.3000	3.2000	3.3500	61.0200	221616.00	221616.00	0.00	672	28	691	3116	0.221758664955071	0.350501484936516	0.350728702683328	false	false	false	true
7b5737ad-4263-4235-9dec-1c553b0f9994	2026-09-10 15:29	2026-09-10 15:29	2026-09-10 15:29	OXY	OXY281215C00065000	call	65.0000	2028-12-15	12.1500	11.7500	12.2000	60.9050	119070.00	57105.00	61965.00	98	25	1010	490	2.06122448979592	0.310624461394271	0.310624461394271	false	false	false	true
01a37aa7-6393-42fb-acf1-2750226530b8	2026-09-10 15:29	2026-09-10 15:29	2026-09-10 15:29	OXY	OXY281215C00065000	call	65.0000	2028-12-15	12.1000	11.7500	12.1500	60.8900	778030.00	778030.00	0.00	643	28	884	490	1.80408163265306	0.309635806202035	0.309457713107683	false	false	false	true
1a29dd00-18a1-421f-8421-486879d8e859	2026-09-10 15:29	2026-09-10 15:29	2026-09-10 15:29	OXY	OXY281215C00065000	call	65.0000	2028-12-15	12.0500	11.7500	12.1000	60.8800	210875.00	209670.00	1205.00	175	6	241	490	0.491836734693878	0.308646788824407	0.308201915920904	false	false	false	true
33288555-1dd3-45d1-8d0e-b10410e47d3c	2026-09-10 12:05	2026-09-10 12:05	2026-09-10 12:05	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.2000	1.1900	1.2000	61.1500	216000.00	216000.00	0.00	1800	7	14089	9644	1.46090833678971	0.332317408144684	0.332317408144684	false	false	false	true
7c6b4bb0-0e47-44e0-a8b7-6c7e86f42056	2026-09-10 10:25	2026-09-10 10:25	2026-09-10 10:25	OXY	OXY261009P00060000	put	60.0000	2026-10-09	2.0000	1.8700	2.0700	60.3650	74200.00	73600.00	600.00	371	39	371	1	371	0.337275508196703	0.334973641721417	false	false	false	true	false
429b4072-6576-475c-af93-b0ec09c6e506	2026-09-10 10:04	2026-09-10 10:04	2026-09-10 10:04	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.2000	1.2000	1.2200	60.9150	54000.00	0.00	54000.00	450	5	7279	9644	0.754769805060141	0.343019257003141	0.343019257003141	false	false	false	true
d25ca428-1de1-4700-a969-da253edae5e1	2026-09-10 10:02	2026-09-10 10:02	2026-09-10 10:02	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.2000	1.1000	1.2000	60.8900	54000.00	54000.00	0.00	450	26	6368	9644	0.660306926586479	0.344153458673978	0.344153458673978	false	false	false	true
73938a83-0850-4e23-a33d-3e4fb3ee1ca3	2026-09-10 10:01	2026-09-10 10:01	2026-09-10 10:01	OXY	OXY261218C00060000	call	60.0000	2026-12-18	4.8500	4.8500	5.0000	60.8000	108155.00	0.00	102820.00	223	7	274	4448	0.0616007194244604	0.32997484200306	0.32997484200306	true	false	false	true
f7881de7-7778-4377-823e-d47e521d23b5	2026-09-10 10:01	2026-09-10 10:01	2026-09-10 10:01	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.1600	1.1500	1.2400	60.9300	205668.00	179452.00	26216.00	1773	29	5918	9644	0.613645790128577	0.334538525557108	0.336342971024656	true	false	false	true
de9fd3fa-1b16-4cff-aa8a-1a06944b9411	2026-09-09 11:39	2026-09-09 11:39	2026-09-09 11:39	OXY	OXY270115P00060000	put	60.0000	2027-01-15	3.8000	3.8000	3.9000	61.6600	132250.00	0.00	132250.00	348	34	358	12268	0.0291816106944897	0.344664570077286	0.344664570077286	false	false	false	true
39ea5564-2f38-4730-a42e-9b9a11423bb2	2026-09-08 10:59	2026-09-08 10:59	2026-09-08 10:59	OXY	OXY261120C00067500	call	67.5000	2026-11-20	1.5700	1.5200	1.5700	61.0600	117122.00	117122.00	0.00	746	25	799	1721	0.464264962231261	0.335090835343802	0.335090835343802	false	false	false	true
b1ec5498-821e-498f-b432-a51d6624aa1d	2026-09-08 09:35	2026-09-08 09:35	2026-09-08 09:35	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.2600	1.0500	1.2600	61.5800	121337.00	121337.00	0.00	963	53	976	9364	0.104228961982059	0.311561145373537	0.311561145373537	true	false	false	true
ad53670e-3811-4e93-9b8c-b5ac296fb2ce	2026-09-04 15:36	2026-09-04 15:36	2026-09-04 15:36	OXY	OXY261002P00059000	put	59.0000	2026-10-02	1.5400	1.4700	1.5400	60.0800	79618.00	79618.00	0.00	517	47	551	24	22.9583333333333	0.320782604845996	0.320782604845996	false	false	false	true	false
3c6ac9a5-4574-4177-a50a-4ec8f827e33d	2026-09-03 13:58	2026-09-03 13:58	2026-09-03 13:58	OXY	OXY270115C00060000	call	60.0000	2027-01-15	5.1000	5.1000	5.3000	60.7300	51000.00	0.00	51000.00	100	5	1322	29683	0.0445372772293906	0.293763474294923	0.293763474294923	false	false	false	true
19e240f9-31a2-4ea5-97ef-8caf7ac0f9b3	2026-09-03 13:57	2026-09-03 13:57	2026-09-03 13:57	OXY	OXY270115C00060000	call	60.0000	2027-01-15	5.1500	5.1500	5.3000	60.7300	103000.00	0.00	103000.00	200	16	1222	29683	0.0411683455176364	0.296851545735743	0.297268271402167	false	false	false	true
b9630f0f-601f-43e0-bb18-05d05b1322fa	2026-09-03 13:57	2026-09-03 13:57	2026-09-03 13:57	OXY	OXY270115C00060000	call	60.0000	2027-01-15	5.1500	5.1500	5.3000	60.7400	82400.00	0.00	82400.00	160	20	1022	29683	0.034430482094128	0.296851545735743	0.296851545735743	false	false	false	true
88c574fa-a396-40ee-b983-2583dc3713b9	2026-09-03 13:56	2026-09-03 13:56	2026-09-03 13:56	OXY	OXY270115C00060000	call	60.0000	2027-01-15	5.1500	5.1500	5.3500	60.7400	103027.00	0.00	103027.00	200	13	862	29683	0.0290401913553212	0.297836479803201	0.296851545735743	false	false	false	true
c6774837-2a5c-465f-b788-7df86d7f1df8	2026-09-03 12:16	2026-09-03 12:16	2026-09-03 12:16	OXY	OXY260918C00061000	call	61.0000	2026-09-18	1.3400	1.3400	1.4100	60.9050	60970.00	0.00	60970.00	455	29	558	679	0.82179675994109	0.271987587676792	0.271987587676792	true	false	false	true	false