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×source = uw_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

38d9e87a-f74e-4ddf-a0c3-67c81ce0fb7a	2026-09-24 15:23	2026-09-24 15:23	2026-09-24 15:23	OXY	OXY261002P00057000	put	57.0000	2026-10-02	0.6800	0.6700	0.7300	58.1200	82280.00	0.00	82280.00	1210	11	2510	1368	1.83479532163743	0.3453269737297	0.3453269737297	true	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-24T19:29:28.297700Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
eae3092a-5da9-4cc8-8b58-6d13b77c531a	2026-09-24 15:22	2026-09-24 15:22	2026-09-24 15:22	OXY	OXY260925C00059000	call	59.0000	2026-09-25	0.1700	0.1300	0.1900	58.0800	12410.00	12223.00	187.00	730	8	3161	10519	0.300503850175872	0.408567009122999	0.408567009122999	true	false	false	true
f20faaba-e425-4542-8d6b-43f74ef0532a	2026-09-24 14:35	2026-09-24 14:35	2026-09-24 14:35	OXY	OXY261120C00060000	call	60.0000	2026-11-20	2.4600	2.4300	2.4900	57.8650	21156.00	5166.00	0.00	86	6	1382	10918	0.126579959699579	0.352490032705023	0.352490032705023	false	false	false	true
05680c0c-f554-4706-8330-ec239b13a995	2026-09-24 12:32	2026-09-24 12:32	2026-09-24 12:32	OXY	OXY261120C00050000	call	50.0000	2026-11-20	8.7100	8.4500	9.4000	57.8800	21765.00	0.00	21765.00	25	7	25	429	0.0582750582750583	0.28721280172457	0.380567241869729	false	false	false	true
4e39e46e-5c9c-4711-88bb-0bfd788e8ca3	2026-09-24 12:24	2026-09-24 12:24	2026-09-24 12:24	OXY	OXY261002P00057000	put	57.0000	2026-10-02	0.7700	0.7300	0.7900	57.8400	14630.00	12936.00	1694.00	190	12	1258	1368	0.919590643274854	0.342553136716205	0.342553136716205	true	false	false	true
6bd71bd2-8e7e-4f56-88aa-f9fcb110c5e2	2026-09-24 11:44	2026-09-24 11:44	2026-09-24 11:44	OXY	OXY261002C00058000	call	58.0000	2026-10-02	1.6000	1.5300	1.6000	58.6700	15999.00	15999.00	0.00	100	6	264	221	1.19457013574661	0.350091315137224	0.347102085880077	false	false	false	true
b7ecc9a6-6c22-4b41-8e03-6f2c93c6657a	2026-09-24 11:29	2026-09-24 11:29	2026-09-24 11:29	OXY	OXY261120C00060000	call	60.0000	2026-11-20	2.7500	2.6500	2.7800	58.5200	133925.00	129800.00	3850.00	487	44	909	10918	0.0832570067777981	0.352135547214271	0.351363036817676	true	false	false	true
5477cff8-15fb-4b08-871b-8b1b019bc248	2026-09-24 10:24	2026-09-24 10:24	2026-09-24 10:24	OXY	OXY261009C00060000	call	60.0000	2026-10-09	1.0000	0.9000	1.0000	58.4600	10400.00	10400.00	0.00	104	8	231	278	0.830935251798561	0.338513889859154	0.338513889859154	false	false	false	true
2b0d8ff8-1a6b-41c6-a8ea-268cf2bbf5f4	2026-09-23 14:45	2026-09-23 14:45	2026-09-23 14:45	OXY	OXY261009P00054000	put	54.0000	2026-10-09	0.4400	0.4300	0.4700	57.4000	55880.00	660.00	55220.00	1270	20	1286	191	6.73298429319372	0.349229831574779	0.349229831574779	false	false	false	true
aff7121f-dc38-4fd9-90cd-010102b63ef4	2026-09-23 13:33	2026-09-23 13:33	2026-09-23 13:33	OXY	OXY261120P00055000	put	55.0000	2026-11-20	1.8900	1.8900	1.9300	57.5550	11345.00	0.00	11345.00	60	7	66	3466	0.0190421234852856	0.351518325126622	0.352721907592676	false	false	false	true
e54be3ee-1142-4333-9a48-b76b939e9c0c	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	OXY	OXY261030P00060000	put	60.0000	2026-10-30	3.9000	3.7000	3.9000	57.3400	99060.00	99060.00	0.00	254	29	349	23	15.1739130434783	0.338021952152236	0.338021952152236	false	false	false	true
cfc394ad-382f-45f9-8b8b-6f217e3b49dd	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	OXY	OXY261009P00059000	put	59.0000	2026-10-09	2.3500	2.1900	2.3500	57.6300	71431.00	69325.00	2106.00	304	9	312	124	2.51612903225806	0.347317102200392	0.334696072524633	true	false	false	true
bb4372e6-dc10-40f1-83c4-4fcfbdd00544	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	OXY	OXY261002P00058000	put	58.0000	2026-10-02	1.3800	1.2700	1.3800	57.7110	10350.00	10350.00	0.00	75	6	104	86	1.2093023255814	0.347993215855464	0.347993215855464	false	false	false	true
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
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
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