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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Energy×ticker = OXY×sorted by created_at ↑×

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

64c818bf-2f88-4403-8970-de0aa1f1d9e2	2026-08-17 12:02	2026-08-17 12:02	2026-08-17 12:02	OXY	OXY261016P00057500	put	57.5000	2026-10-16	2.5000	2.3900	2.5500	58.3600	112750.00	1000.00	111750.00	451	52	485	873	0.555555555555556	0.327686743250706	0.329028487392966	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	61757596780.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ce0b7ddd-17a5-4e84-b89e-b258a786fb68	2026-08-17 13:09	2026-08-17 13:09	2026-08-17 13:09	OXY	OXY261120C00062500	call	62.5000	2026-11-20	2.4700	2.4700	2.5200	58.4350	56069.00	0.00	56069.00	227	30	248	2547	0.0973694542599136	0.323338300055462	0.323338300055462	false	false	false	true
8b3e9293-2f50-49e1-bc6d-916877746dac	2026-08-17 14:09	2026-08-17 14:09	2026-08-17 14:09	OXY	OXY260918C00060000	call	60.0000	2026-09-18	1.7600	1.7200	1.7600	59.0000	88000.00	73920.00	0.00	500	33	1355	12560	0.107882165605096	0.30157093623881	0.30157093623881	false	false	false	true
f38b81b0-0ec3-48c6-a277-20f44bb3e38e	2026-08-17 14:57	2026-08-17 14:56	2026-08-17 14:56	OXY	OXY260918P00057500	put	57.5000	2026-09-18	1.5100	1.4400	1.5200	59.0501	278595.00	278142.00	0.00	1845	78	4148	2103	1.97242035187827	0.333209580903698	0.331286895207696	false	false	false	true
ae47e1c9-d4b9-4426-9586-53bcf820a173	2026-08-18 10:05	2026-08-18 10:05	2026-08-18 10:05	OXY	OXY261218C00060000	call	60.0000	2026-12-18	4.3500	4.2500	4.5000	59.2800	110955.00	42924.00	68031.00	255	6	573	4492	0.127560106856634	0.318522804168153	0.318522804168153	false	false	false	true
b60fc8a7-a5d5-4ab7-a5e6-ca2e7163f885	2026-08-18 13:24	2026-08-18 13:24	2026-08-18 13:24	OXY	OXY260918C00060000	call	60.0000	2026-09-18	1.8800	1.8400	1.9300	59.4000	84600.00	48504.00	36096.00	450	12	1029	12872	0.0799409571162213	0.299754164410518	0.299754164410518	false	false	false	true
c555a6ed-5304-42fd-8d94-ae2983e7c2db	2026-08-19 15:56	2026-08-19 15:56	2026-08-19 15:56	OXY	OXY260918C00060000	call	60.0000	2026-09-18	2.1200	2.0600	2.1400	59.9900	58300.00	39220.00	15688.00	275	39	3239	12494	0.259244437329918	0.296882341239676	0.296494574617654	false	false	false	true
d1b01b7e-dd9f-4eed-b477-23718ee3e40b	2026-08-19 15:57	2026-08-19 15:57	2026-08-19 15:57	OXY	OXY260918P00060000	put	60.0000	2026-09-18	2.2000	2.2000	2.2800	60.0200	66000.00	0.00	66000.00	300	5	1187	4044	0.293521266073195	0.335987227066026	0.335987227066026	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
bf8443f4-d926-4244-ac42-839458fda6a4	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	OXY	OXY261218C00060000	call	60.0000	2026-12-18	6.0000	5.6500	6.0000	61.8200	120000.00	120000.00	0.00	200	13	242	4498	0.0538016896398399	0.332411264651019	0.332411264651019	false	false	false	true
dd664f96-baf3-4835-96d0-a006948d691c	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	OXY	OXY261218C00060000	call	60.0000	2026-12-18	5.9500	5.6500	5.9500	61.8400	83300.00	83300.00	0.00	140	5	385	4498	0.0855935971542908	0.327757724081538	0.327757724081538	false	false	false	true
d745b66a-c040-42d5-8df4-3dc38c80cf47	2026-08-20 09:49	2026-08-20 09:49	2026-08-20 09:49	OXY	OXY261016C00060000	call	60.0000	2026-10-16	4.0500	4.0500	4.3500	61.8700	81000.00	0.00	81000.00	200	5	743	5482	0.135534476468442	0.292229174111549	0.292229174111549	false	false	false	true
07581824-6fda-4924-b2f0-9da234255f98	2026-08-20 09:49	2026-08-20 09:49	2026-08-20 09:49	OXY	OXY261016C00060000	call	60.0000	2026-10-16	4.0500	4.0500	4.3500	61.8400	81000.00	0.00	81000.00	200	8	943	5482	0.172017511856986	0.294355796038662	0.294355796038662	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
ac402828-3322-4bd2-8425-e326e65fa245	2026-08-20 11:10	2026-08-20 11:10	2026-08-20 11:10	OXY	OXY260918C00065000	call	65.0000	2026-09-18	0.9900	0.9500	0.9900	61.7700	83259.00	83259.00	0.00	841	39	975	10582	0.0921375921375921	0.306941875089857	0.306442560241858	false	false	false	true
4e9943bd-387b-4986-a00f-dd3ab83ef697	2026-08-20 12:03	2026-08-20 12:03	2026-08-20 12:03	OXY	OXY261120P00062500	put	62.5000	2026-11-20	4.2500	4.2000	4.2500	62.1200	72250.00	72250.00	0.00	170	16	287	357	0.803921568627451	0.351784798642795	0.351784798642795	false	false	false	true
b10947b1-f8dc-4b80-a290-090b1ba39a2d	2026-08-20 13:31	2026-08-20 13:31	2026-08-20 13:31	OXY	OXY261120C00062500	call	62.5000	2026-11-20	3.9000	3.9000	3.9500	61.6050	170866.00	0.00	170866.00	438	22	681	2815	0.241918294849023	0.327171625902079	0.327171625902079	false	false	false	true
cef08d62-2b44-4770-8ea6-27b304e14ac7	2026-08-21 11:08	2026-08-21 11:08	2026-08-21 11:08	OXY	OXY261120C00072500	call	72.5000	2026-11-20	1.0900	1.0600	1.1500	61.3100	117611.00	109.00	117502.00	1079	42	1091	733	1.48840381991814	0.342335016670225	0.34268582642534	false	false	false	true
b867817e-4024-4799-bc85-0b4ea5bb6d3e	2026-08-21 11:42	2026-08-21 11:41	2026-08-21 11:41	OXY	OXY260821C00055000	call	55.0000	2026-08-21	6.2500	6.2500	6.5000	61.3600	187578.00	0.00	187578.00	300	5	781	5501	0.141974186511543	3.37904543033928	3.37904543033928	false	false	false	true
09a72802-0f2f-41ba-ba71-86223cd1fbe9	2026-08-21 14:01	2026-08-21 14:00	2026-08-21 14:00	OXY	OXY261218P00057500	put	57.5000	2026-12-18	2.7100	2.6700	2.8100	61.3250	98644.00	0.00	98644.00	364	28	369	1239	0.297820823244552	0.345164715395265	0.345164715395265	false	false	false	true
f44be959-1e60-4564-9971-66b49ce214b2	2026-08-24 10:09	2026-08-24 10:09	2026-08-24 10:09	OXY	OXY261016C00060000	call	60.0000	2026-10-16	3.3500	3.3500	3.5000	60.7700	67000.00	0.00	67000.00	200	11	223	4979	0.0447881100622615	0.302225384756815	0.302225384756815	false	false	false	true
978c6062-8554-417f-8267-723ba72b96bc	2026-08-26 09:33	2026-08-26 09:33	2026-08-26 09:33	OXY	OXY260918P00060000	put	60.0000	2026-09-18	2.9400	2.9400	3.3500	58.1080	58800.00	0.00	58800.00	200	6	202	5342	0.0378135529764133	0.328813171586311	0.328813171586311	false	false	false	true
4e4787e3-39c5-4a99-bf39-66fd606a4f47	2026-08-26 10:14	2026-08-26 10:13	2026-08-26 10:13	OXY	OXY260918P00060000	put	60.0000	2026-09-18	2.7600	2.7600	3.0500	58.4350	55200.00	0.00	55200.00	200	7	505	5342	0.0945338824410333	0.332345672845476	0.332345672845476	false	false	false	true
d99a8a0e-f529-4e16-b43f-c028fe6b62f9	2026-08-27 11:07	2026-08-27 11:07	2026-08-27 11:07	OXY	OXY261218C00060000	call	60.0000	2026-12-18	3.6000	3.6000	3.7500	58.3800	72000.00	0.00	72000.00	200	13	432	4922	0.0877691995123933	0.309420531256256	0.309420531256256	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
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
c791488c-7194-4e3a-879b-5d372aca0154	2026-08-27 14:10	2026-08-27 14:10	2026-08-27 14:10	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.0300	0.9200	1.0800	59.3750	384293.00	384293.00	0.00	3731	7	10208	11212	0.910453085979308	0.322552003294354	0.322552003294354	false	false	false	true
0cf6b06b-e288-4bc6-b3de-0588a29f75f3	2026-08-27 14:27	2026-08-27 14:27	2026-08-27 14:27	OXY	OXY260918P00060000	put	60.0000	2026-09-18	2.1600	2.0800	2.2400	59.5000	284679.00	280368.00	3879.00	1318	68	1343	4902	0.273969808241534	0.34119159785485	0.3376849532902	true	false	false	true
fad1955a-55d5-4e3f-90ce-000d6acf3524	2026-08-28 09:55	2026-08-28 09:55	2026-08-28 09:55	OXY	OXY280121C00065000	call	65.0000	2028-01-21	7.7500	7.7500	8.0500	59.0600	135625.00	0.00	135625.00	175	5	320	2431	0.131633072809543	0.312296472200777	0.312296472200777	true	false	false	true
b90719d1-6530-4718-9e6e-2570407c437c	2026-08-31 15:16	2026-08-31 15:16	2026-08-31 15:16	OXY	OXY260918C00062000	call	62.0000	2026-09-18	0.8900	0.8200	0.9200	60.0600	68886.00	59541.00	9345.00	774	24	829	24	34.5416666666667	0.305714264292599	0.304250731973056	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
108aeea8-3e75-4565-8afc-a21ddde6ef15	2026-09-01 12:08	2026-09-01 12:07	2026-09-01 12:07	OXY	OXY260904C00062000	call	62.0000	2026-09-04	0.2000	0.1600	0.2000	60.0900	58680.00	58680.00	0.00	3000	67	3391	1524	2.2250656167979	0.37657436683869	0.36517737073942	true	false	false	true
cdd1215b-7e86-4055-8b42-c4478f674685	2026-09-01 12:22	2026-09-01 12:22	2026-09-01 12:22	OXY	OXY260918C00062000	call	62.0000	2026-09-18	1.0400	0.8500	1.1000	60.5750	87040.00	82264.00	4776.00	837	55	919	726	1.26584022038567	0.309012881771462	0.30593612382285	false	false	false	true
2b8cc768-f65f-4598-91d7-564ab7f41d0c	2026-09-01 12:46	2026-09-01 12:46	2026-09-01 12:46	OXY	OXY261120C00060000	call	60.0000	2026-11-20	4.3800	4.2000	4.4000	60.7500	87550.00	87550.00	0.00	200	14	734	9765	0.0751664106502816	0.333260038671299	0.324882138653676	false	false	false	true
11b1ac79-2d64-4745-980c-0b64dcdf78c4	2026-09-01 12:47	2026-09-01 12:47	2026-09-01 12:47	OXY	OXY261120C00060000	call	60.0000	2026-11-20	4.4000	4.2000	4.4000	60.7700	63794.00	63794.00	0.00	145	8	879	9765	0.0900153609831029	0.331942618558821	0.331942618558821	false	false	false	true
6e19bbdd-5884-4a44-9525-4eace8028d90	2026-09-01 13:18	2026-09-01 13:18	2026-09-01 13:18	OXY	OXY260911P00061000	put	61.0000	2026-09-11	1.4300	1.4300	1.4900	61.0000	102102.00	0.00	102102.00	714	54	742	11	67.4545454545455	0.363037782191304	0.363037782191304	false	false	false	true
855d387a-4bd8-448a-a54f-ccc461456746	2026-09-01 13:55	2026-09-01 13:55	2026-09-01 13:55	OXY	OXY270319C00062500	call	62.5000	2027-03-19	5.6500	5.5000	5.6500	61.1300	56500.00	56500.00	0.00	100	6	100	1529	0.065402223675605	0.318971210635935	0.318971210635935	false	false	false	true
f6bc5cda-af8e-48ab-be15-664b1e88df17	2026-09-01 15:08	2026-09-01 15:08	2026-09-01 15:08	OXY	OXY270115C00065000	call	65.0000	2027-01-15	3.3000	3.2500	3.5000	60.8350	1936771.00	891990.00	1044781.00	5869	64	11044	42315	0.260994919059435	0.312882233818431	0.313911994863288	false	false	false	true
ebe508de-19be-4e93-bcc4-b6405ca3979a	2026-09-02 10:25	2026-09-02 10:25	2026-09-02 10:25	OXY	OXY281215P00042500	put	42.5000	2028-12-15	3.1500	3.1500	3.3500	60.4800	50402.00	0.00	50402.00	160	21	497	296	1.67905405405405	0.37176063444745	0.37176063444745	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
7e81f65a-9ec7-430c-8f02-1c6024d3abbd	2026-09-02 10:53	2026-09-02 10:53	2026-09-02 10:53	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.1700	1.1100	1.1700	60.7300	93600.00	93600.00	0.00	800	6	21615	21401	1.00999953273212	0.311382917648956	0.311382917648956	false	false	false	true
4732997f-57e5-4fc4-8e44-c2dda2cab05c	2026-09-03 11:40	2026-09-03 11:40	2026-09-03 11:40	OXY	OXY261120C00060000	call	60.0000	2026-11-20	4.3000	4.3000	4.4000	61.0450	86000.00	0.00	86000.00	200	13	427	10394	0.0410813931114104	0.31270450096793	0.31270450096793	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
5f4ad962-60b8-4c7c-8f12-302222ebed6c	2026-09-03 11:42	2026-09-03 11:42	2026-09-03 11:42	OXY	OXY270115C00060000	call	60.0000	2027-01-15	5.5500	5.2500	5.5500	60.9900	111000.00	111000.00	0.00	200	9	302	29683	0.0101741737694977	0.314408487887369	0.314408487887369	false	false	false	true
742a2fb7-16ab-4064-96d8-4a14716f18d5	2026-09-03 11:42	2026-09-03 11:42	2026-09-03 11:42	OXY	OXY270115C00060000	call	60.0000	2027-01-15	5.5500	5.2500	5.5500	61.0500	111000.00	111000.00	0.00	200	11	502	29683	0.0169120371930061	0.311870527940743	0.311870527940743	false	false	false	true
1b5d7b82-3145-4112-a0ce-bd730b013604	2026-09-03 11:43	2026-09-03 11:43	2026-09-03 11:43	OXY	OXY270115C00060000	call	60.0000	2027-01-15	5.5500	5.2500	5.5500	61.0000	88800.00	88800.00	0.00	160	6	662	29683	0.0223023279318128	0.31398623318177	0.31398623318177	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
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
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
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