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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 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 = 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

4ec0fba3-0476-497d-aaae-8286a67db818	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	OXY	OXY261002P00057000	put	57.0000	2026-10-02	0.9100	0.8300	0.9100	57.7110	17654.00	17654.00	0.00	194	7	213	1214	0.175453047775947	0.349876790014241	0.349876790014241	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	57339199601.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T16:47:02.093743Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
33ee7f67-fca3-4c2b-8f14-fdd014b91e2e	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	OXY	OXY261016P00059000	put	59.0000	2026-10-16	2.6100	2.4800	2.6100	57.7110	119538.00	119538.00	0.00	458	19	472	0	0	0.340594452024208	0.340594452024208	false	false	false	true
26187898-b6d6-4cf1-8413-c925546339a2	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	OXY	OXY261016P00060000	put	60.0000	2026-10-16	3.2500	3.2000	3.2500	57.7110	34770.00	34450.00	320.00	107	5	147	1856	0.0792025862068965	0.340104058778011	0.340104058778011	false	false	false	true
75eaf77a-f227-4255-8e74-3dbe914cfabc	2026-09-23 11:54	2026-09-23 11:53	2026-09-23 11:53	OXY	OXY261120C00065000	call	65.0000	2026-11-20	1.0900	1.0500	1.1000	57.0000	11990.00	5014.00	6976.00	110	5	172	7219	0.0238260146834742	0.35573524116588	0.35573524116588	false	false	false	true
83772b1d-db34-4d01-be44-9402a8e6c892	2026-09-23 11:35	2026-09-23 11:35	2026-09-23 11:35	OXY	OXY270521C00060000	call	60.0000	2027-05-21	5.9500	5.6500	6.0000	57.8650	29750.00	29750.00	0.00	50	5	50	0	0	0.328560106736368	0.328560106736368	false	false	false	true
b6b7db38-f44d-4137-ac43-724f1bb1f211	2026-09-23 10:39	2026-09-23 10:39	2026-09-23 10:39	OXY	OXY261218C00070000	call	70.0000	2026-12-18	0.7100	0.7100	0.7900	57.4400	76325.00	0.00	76325.00	1075	23	1096	6040	0.181456953642384	0.347756184797506	0.347756184797506	false	false	false	true
2529540e-3ffc-47ff-9040-4eff7b2078cf	2026-09-23 10:15	2026-09-23 10:15	2026-09-23 10:15	OXY	OXY261016C00060000	call	60.0000	2026-10-16	1.0700	1.0700	1.0800	57.6999	22898.00	0.00	11449.00	214	5	319	6623	0.0481654839196739	0.333188498681042	0.333188498681042	false	false	false	true
3d8ad9ed-cd92-405a-95fe-e6ddf77c33a8	2026-09-23 10:13	2026-09-23 10:12	2026-09-23 10:12	OXY	OXY290119C00070000	call	70.0000	2029-01-19	8.8500	8.0500	9.0500	57.5700	10620.00	7080.00	3540.00	12	8	12	96	0.125	0.310298290251434	0.310298290251434	false	false	false	true
965289bc-57a1-4a9a-8870-0524377fc6e9	2026-09-23 09:43	2026-09-23 09:43	2026-09-23 09:43	OXY	OXY260925P00056000	put	56.0000	2026-09-25	0.3400	0.3400	0.4100	56.0000	13465.00	35.00	13430.00	396	49	400	1094	0.36563071297989	0.41629778380927	0.423109801824	false	false	false	true
516c18a7-e4dd-45b2-a8be-8022fd73249c	2026-09-23 09:43	2026-09-23 09:43	2026-09-23 09:43	OXY	OXY260925P00057000	put	57.0000	2026-09-25	0.7500	0.7500	0.9200	56.0000	12750.00	0.00	12750.00	170	17	174	1259	0.138204924543288	0.410209548097516	0.410209548097516	false	false	false	true
7635a1f6-39da-445f-9f9e-5e8d536eca11	2026-09-22 15:23	2026-09-22 15:23	2026-09-22 15:23	OXY	OXY261023P00053000	put	53.0000	2026-10-23	0.7500	0.6800	0.7600	56.6050	11100.00	11100.00	0.00	148	10	264	145	1.82068965517241	0.335051351829786	0.335051351829786	false	false	false	true
50b037bc-8ff7-43ed-b70f-6892ddc76a77	2026-09-22 13:57	2026-09-22 13:57	2026-09-22 13:57	OXY	OXY260925P00056000	put	56.0000	2026-09-25	0.5500	0.4500	0.5900	56.5300	39655.00	39600.00	55.00	721	36	966	351	2.75213675213675	0.39035158584207	0.39035158584207	false	false	false	true
b714795f-1d60-4178-a6d0-d73b6ad8ac73	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	OXY	OXY261009C00056000	call	56.0000	2026-10-09	2.1300	2.1000	2.1300	56.8600	35145.00	35145.00	0.00	165	5	167	12	13.9166666666667	0.330228716031986	0.330228716031986	true	false	false	true
376f96ed-6695-47d9-ba03-089c7cb27b19	2026-09-22 13:12	2026-09-22 13:12	2026-09-22 13:12	OXY	OXY261016P00056000	put	56.0000	2026-10-16	1.3300	1.3300	1.3800	57.0999	13832.00	0.00	13832.00	104	9	239	5	47.8	0.326847562456551	0.326847562456551	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
04d3f912-1e08-4433-9223-9770d436e2c9	2026-09-22 12:00	2026-09-22 12:00	2026-09-22 12:00	OXY	OXY290119C00070000	call	70.0000	2029-01-19	8.6500	8.4000	8.7000	57.2718	81310.00	71795.00	9515.00	94	5	94	5	18.8	0.308045019161176	0.308045019161176	false	false	false	true
2793d539-32b5-4544-8cc9-df8509bf2d07	2026-09-22 10:37	2026-09-22 10:37	2026-09-22 10:37	OXY	OXY261120C00057500	call	57.5000	2026-11-20	3.0500	3.0500	3.2000	56.8450	11285.00	0.00	11285.00	37	10	45	2106	0.0213675213675214	0.348842856648014	0.348842856648014	false	false	false	true
1eee67bf-8407-4e21-b92c-85ef184dbc8f	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	OXY	OXY270319C00062500	call	62.5000	2027-03-19	3.3000	3.1500	3.4000	56.4950	17160.00	5280.00	1320.00	52	52	53	1745	0.0303724928366762	0.325930579545283	0.325930579545283	false	false	false	true
d9f6636e-76a9-4e45-90d5-2e884969e6f9	2026-09-21 15:40	2026-09-21 15:40	2026-09-21 15:40	OXY	OXY270115P00055000	put	55.0000	2027-01-15	2.9700	2.8600	2.9700	57.2900	28809.00	28809.00	0.00	97	9	271	5542	0.0488993143269578	0.344629752945687	0.344629752945687	false	false	false	true
adec875b-a3c4-405b-a683-6f79b7dfbd46	2026-09-21 13:57	2026-09-21 13:57	2026-09-21 13:57	OXY	OXY281215P00060000	put	60.0000	2028-12-15	10.7000	10.6500	10.9000	57.3800	208650.00	1070.00	207580.00	195	15	303	147	2.06122448979592	0.376778153671698	0.376778153671698	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
5bf5e5b5-8c82-4624-be04-d9be10fd3a5e	2026-09-21 13:45	2026-09-21 13:45	2026-09-21 13:45	OXY	OXY280121P00050000	put	50.0000	2028-01-21	4.5000	4.4500	4.6000	57.0000	10800.00	1350.00	450.00	24	18	245	1046	0.234225621414914	0.367831898298185	0.367831898298185	false	false	false	true
449538bb-d926-4166-98d5-eabcd014e0e1	2026-09-21 13:37	2026-09-21 13:36	2026-09-21 13:36	OXY	OXY280121P00050000	put	50.0000	2028-01-21	4.5500	4.5000	4.5500	57.0000	10010.00	10010.00	0.00	22	18	197	1046	0.188336520076482	0.368979231014639	0.368979231014639	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
dc5626dc-4fcf-4bfc-adfb-c4edb375c754	2026-09-21 12:31	2026-09-21 12:31	2026-09-21 12:31	OXY	OXY260925C00061000	call	61.0000	2026-09-25	0.0700	0.0500	0.0600	57.0000	69782.00	69782.00	0.00	10000	38	18936	9556	1.98158225198828	0.395979215463384	0.409483456147059	true	true	false	true
fd2959cd-b564-4da4-87c9-4e1d4ea1ccc1	2026-09-21 12:22	2026-09-21 12:22	2026-09-21 12:22	OXY	OXY261218C00057500	call	57.5000	2026-12-18	3.8000	3.7000	3.8000	57.0600	21660.00	21660.00	0.00	57	21	104	2224	0.0467625899280576	0.334597827593617	0.334839790585615	true	false	false	true
f53dca3d-5b4c-499e-bc48-92830ef653b7	2026-09-21 12:22	2026-09-21 12:22	2026-09-21 12:22	OXY	OXY261218C00060000	call	60.0000	2026-12-18	2.7400	2.6700	2.7400	57.0650	70891.00	50416.00	20475.00	259	40	358	4441	0.0806124746678676	0.333130855001792	0.333130855001792	true	false	false	true
e68c8766-82d6-4123-9d48-ddde3e194c44	2026-09-21 12:22	2026-09-21 12:22	2026-09-21 12:22	OXY	OXY261218P00055000	put	55.0000	2026-12-18	2.6900	2.5900	2.7000	57.0600	25306.00	25041.00	265.00	94	15	102	3404	0.0299647473560517	0.354297815947659	0.349530184210331	true	false	false	true
8d97d2ab-fc19-40df-a82c-9df802e72873	2026-09-21 12:22	2026-09-21 12:22	2026-09-21 12:22	OXY	OXY261218C00062500	call	62.5000	2026-12-18	1.9500	1.8900	1.9500	57.0600	19890.00	19890.00	0.00	102	19	115	2888	0.039819944598338	0.334703074886574	0.334868850490902	false	false	false	true
9b651576-654b-4f24-bc13-4cc5fd8a33b2	2026-09-21 12:04	2026-09-21 12:04	2026-09-21 12:04	OXY	OXY290119P00055000	put	55.0000	2029-01-19	8.4500	7.9500	8.4500	57.2550	95485.00	95485.00	0.00	113	10	113	0	0	0.377179080531147	0.377179080531147	false	false	false	true
83ab7be8-da7d-4e78-9282-dfa8bd025857	2026-09-21 10:14	2026-09-21 10:14	2026-09-21 10:14	OXY	OXY261218C00075000	call	75.0000	2026-12-18	0.3600	0.3500	0.4200	57.2250	16561.00	37.00	16524.00	460	48	494	2852	0.173211781206171	0.360609089660784	0.362913872134451	false	false	false	true
70b09cf1-c7c2-4905-a978-12e0888a5d71	2026-09-18 15:30	2026-09-18 15:30	2026-09-18 15:30	OXY	OXY261120C00070000	call	70.0000	2026-11-20	0.6000	0.6000	0.6400	58.9250	71880.00	0.00	71880.00	1198	34	1553	3935	0.394663278271919	0.351096493754935	0.351096493754935	false	false	false	true
342c3763-a57f-43f6-9102-e992c6814505	2026-09-18 14:32	2026-09-18 14:32	2026-09-18 14:32	OXY	OXY261016C00057500	call	57.5000	2026-10-16	3.0000	2.9200	3.1000	59.0050	105000.00	36900.00	68100.00	350	14	409	1486	0.275235531628533	0.319341750336322	0.319341750336322	true	false	false	true
f9d6d566-ed8b-4791-a079-c7aa9ac8cdf3	2026-09-18 11:39	2026-09-18 11:39	2026-09-18 11:39	OXY	OXY270115C00057500	call	57.5000	2027-01-15	5.5500	5.5500	5.6500	59.1450	147075.00	0.00	147075.00	265	25	266	2243	0.118591172536781	0.320256446133196	0.320501062468121	false	false	false	true
8afd68b7-8280-4524-baa2-969bc24a3e1d	2026-09-18 11:03	2026-09-18 11:03	2026-09-18 11:03	OXY	OXY270115P00052500	put	52.5000	2027-01-15	1.6500	1.6500	1.7200	59.1300	65670.00	0.00	65670.00	398	7	409	3227	0.126743105051131	0.347644787262877	0.347644787262877	false	false	false	true
a9851e1a-f0b1-47f3-ad56-bfe7d308c278	2026-09-17 11:14	2026-09-17 11:14	2026-09-17 11:14	OXY	OXY261218C00062500	call	62.5000	2026-12-18	2.7000	2.6900	2.7800	58.7450	163889.00	270.00	163619.00	607	21	685	3111	0.22018643522983	0.336469604527963	0.335778937911197	false	false	false	true
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
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
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