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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

8f2d60da-3e3a-4157-bf50-bf8b0ee1c5cf	2026-09-25 10:37	2026-09-25 10:37	2026-09-25 10:37	OXY	OXY270521C00060000	call	60.0000	2027-05-21	5.4900	5.2500	5.5000	57.0400	46649.00	46649.00	0.00	85	6	100	105	0.952380952380952	0.327863316832607	0.327863316832607	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	56839380915.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T14:37:32.022295Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
93a6eddd-3644-4d9c-8010-08ff81e5fb30	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	OXY	OXY261120C00057500	call	57.5000	2026-11-20	3.4900	3.4500	3.5000	57.7110	24785.00	20300.00	4485.00	71	8	108	2320	0.046551724137931	0.345202789582032	0.345202789582032	false	false	false	true
51606dda-7de2-45a8-b5ca-dfba90835933	2026-09-22 12:44	2026-09-22 12:44	2026-09-22 12:44	OXY	OXY261120C00057500	call	57.5000	2026-11-20	3.2000	3.1500	3.2000	57.1150	18866.00	18866.00	0.00	59	11	188	2106	0.0892687559354226	0.34877032808241	0.349864564904085	false	false	false	true
6bd69d7c-50dd-4f15-ae55-074812fb371e	2026-09-21 13:57	2026-09-21 13:57	2026-09-21 13:57	OXY	OXY281215C00070000	call	70.0000	2028-12-15	8.3500	8.3000	8.8000	57.3800	225455.00	0.00	225455.00	270	45	293	757	0.387054161162483	0.306712360766753	0.306712360766753	false	false	false	true
7b5abed1-d1bc-4f35-9e03-206fbc062763	2026-09-21 13:15	2026-09-21 13:15	2026-09-21 13:15	OXY	OXY270115C00060000	call	60.0000	2027-01-15	3.2500	3.2500	3.3500	57.1450	73206.00	0.00	73206.00	225	29	744	33759	0.0220385674931129	0.321227640300633	0.322792186369701	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
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
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
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
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
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
ca03ade0-d6a7-421e-8524-723bc11bb65b	2026-09-03 11:41	2026-09-03 11:41	2026-09-03 11:41	OXY	OXY261120C00060000	call	60.0000	2026-11-20	4.2600	4.2500	4.4000	61.0150	85200.00	0.00	85200.00	200	9	627	10394	0.0603232634212045	0.30867072392943	0.313431617550693	false	false	false	true
e0e7b9a3-f520-43d5-b4dc-c38c077100ac	2026-09-02 10:37	2026-09-02 10:37	2026-09-02 10:37	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.0800	1.0700	1.1300	60.4800	830552.00	16633.00	813919.00	7690	24	20815	21401	0.972618101957852	0.308564039205968	0.308962250304035	false	false	false	true
5a75c7b2-d3a0-427d-825c-43cdfac4f8a8	2026-09-01 11:38	2026-09-01 11:38	2026-09-01 11:38	OXY	OXY270115C00065000	call	65.0000	2027-01-15	3.1000	3.1000	3.4500	60.5400	841058.00	0.00	841058.00	2713	64	2732	42315	0.0645633935956517	0.308713979023073	0.308713979023073	false	false	false	true
fc9c619d-c8ca-46ca-8b82-477d22d1eb54	2026-08-27 14:10	2026-08-27 14:10	2026-08-27 14:10	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.0200	0.9500	1.0200	59.3650	75602.00	75501.00	0.00	743	38	6071	11212	0.541473421334285	0.320079458137272	0.32149842812498	false	false	false	true
2bded4ef-fd14-4abb-b64f-6acbd9dfe24f	2026-08-27 13:05	2026-08-27 13:04	2026-08-27 13:04	OXY	OXY261016C00065000	call	65.0000	2026-10-16	0.9300	0.8800	0.9400	59.0100	278440.00	278349.00	0.00	2994	6	5175	11212	0.461559043881555	0.31819502712921	0.321156790292579	false	false	false	true
4e7b96c1-6ba5-4831-98fe-0bdd3d51c196	2026-08-20 09:50	2026-08-20 09:50	2026-08-20 09:50	OXY	OXY261218C00060000	call	60.0000	2026-12-18	5.9500	5.6000	5.9500	61.9800	95198.00	95198.00	0.00	160	5	545	4498	0.121164962205425	0.319694480549716	0.319694480549716	false	false	false	true
5fd81cf3-35a4-43c4-801c-38c60cbe871e	2026-08-20 09:47	2026-08-20 09:47	2026-08-20 09:47	OXY	OXY261016C00060000	call	60.0000	2026-10-16	4.1000	4.0500	4.3500	61.8400	78303.00	41000.00	37303.00	191	15	443	5482	0.0808099233856257	0.292939290252519	0.303127799689539	false	false	false	true