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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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×sector = Energy×

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

7ffea8c0-2bec-47ea-850a-f79bc0d47a87	2026-09-28 12:17	2026-09-28 12:16	2026-09-28 12:16	OXY	OXY281215C00095000	call	95.0000	2028-12-15	3.6000	3.5500	3.9000	56.5675	10811.00	730.00	9001.00	30	11	30	615	0.0487804878048781	0.323941047013726	0.324062270585764	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	56079656513.00	2026-11-09	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T16:17:21.728276Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
06341d66-1fb5-410c-aa71-b52b19621d2c	2026-09-28 12:17	2026-09-28 12:16	2026-09-28 12:16	TPL	TPL261016C00370000	call	370.0000	2026-10-16	3.7000	3.7000	4.1000	339.5850	13690.00	0.00	13690.00	37	11	69	128	0.5390625	0.43762540881376	0.43762540881376	false	false	false
7d25ebb0-172f-43f3-87e4-f762b38802cd	2026-09-28 12:14	2026-09-28 12:14	2026-09-28 12:14	PR	PR270115C00022000	call	22.0000	2027-01-15	1.6500	1.6000	1.6500	21.4850	14977.00	14977.00	0.00	91	7	150	1356	0.110619469026549	0.372633910514323	0.375245589734976	false	false	false
d548fdf7-0ba4-45b9-b6a6-c9e7ffcc5407	2026-09-28 12:10	2026-09-28 12:09	2026-09-28 12:09	FANG	FANG270319C00185000	call	185.0000	2027-03-19	20.5000	20.5000	22.2000	186.8500	16400.00	0.00	16400.00	8	5	21	31	0.67741935483871	0.349344961126406	0.349344961126406	false	false	false
9cdafc94-4885-4199-a157-1c2b39ee6523	2026-09-28 12:09	2026-09-28 12:09	2026-09-28 12:09	KMI	KMI261218C00034000	call	34.0000	2026-12-18	0.3900	0.3700	0.3900	30.7300	23517.00	23517.00	0.00	603	28	892	2479	0.35982250907624	0.231076431111454	0.231076431111454	true	false	false
45f1ecfe-9387-4225-b0b3-4bc804cc813a	2026-09-28 12:09	2026-09-28 12:08	2026-09-28 12:08	SLB	SLB280121C00067500	call	67.5000	2028-01-21	4.4000	4.0500	4.4000	51.3700	12760.00	12760.00	0.00	29	5	187	380	0.492105263157895	0.353338680278015	0.353338680278015	false	false	false
5e385d7c-d25b-4036-9a03-bc30bb3b4d8e	2026-09-28 12:08	2026-09-28 12:08	2026-09-28 12:08	XOM	XOM261023C00160000	call	160.0000	2026-10-23	6.7000	6.6750	7.1000	162.6585	13400.00	0.00	13400.00	20	5	58	96	0.604166666666667	0.297175735995859	0.297175735995859	false	false	false
63662f76-3bab-4b91-9776-2b3215074186	2026-09-28 12:07	2026-09-28 12:07	2026-09-28 12:07	GLNG	GLNG261120P00050000	put	50.0000	2026-11-20	2.8000	2.7000	2.9500	49.2700	140000.00	0.00	140000.00	500	7	501	1241	0.403706688154714	0.343409096339396	0.343409096339396	false	true	false
bb831ad7-3af8-4d85-b7e6-2a1d36c19298	2026-09-28 12:03	2026-09-28 12:03	2026-09-28 12:03	CVX	CVX261002C00190000	call	190.0000	2026-10-02	17.2000	16.7500	18.5500	207.1630	51600.00	0.00	51600.00	30	10	30	8	3.75	0.803457959413001	0.803457959413001	false	false	false
558f5c37-0843-4697-b8ca-1372c1f9a288	2026-09-28 12:01	2026-09-28 12:01	2026-09-28 12:01	CCJ	CCJ270917P00075000	put	75.0000	2027-09-17	7.7000	7.5750	7.8500	86.9300	10780.00	0.00	10780.00	14	6	29	33	0.878787878787879	0.453559241831024	0.453559241831024	false	false	false
85dec834-2abb-42a8-a6af-d60371d08b8b	2026-09-28 11:58	2026-09-28 11:58	2026-09-28 11:58	XOM	XOM261009P00160000	put	160.0000	2026-10-09	2.0000	1.9700	2.1000	162.9700	14000.00	6800.00	7200.00	70	5	139	603	0.230514096185738	0.299494782622115	0.299494782622115	true	false	false
45418166-27a9-4d16-9b0f-25feb154bb8d	2026-09-28 11:55	2026-09-28 11:55	2026-09-28 11:55	PBR	PBR261016C00021000	call	21.0000	2026-10-16	0.9100	0.8600	0.9100	20.8050	56056.00	56056.00	0.00	616	25	733	12713	0.057657515928577	0.532595590587347	0.532595590587347	false	false	false
24bc13c7-f013-4d0d-9429-cb85ca764c8a	2026-09-28 11:55	2026-09-28 11:55	2026-09-28 11:55	PSX	PSX261218C00300000	call	300.0000	2026-12-18	7.2000	7.2000	8.0000	254.9250	21600.00	0.00	21600.00	30	7	33	191	0.172774869109948	0.430000442796112	0.430000442796112	false	false	false
030d2ab5-8c14-4b0e-89cd-d1eaf2ab989f	2026-09-28 11:54	2026-09-28 11:54	2026-09-28 11:54	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	2.0200	2.0000	2.1000	86.7100	39388.00	403.00	38985.00	195	6	1754	5067	0.346161436747582	0.459429849054049	0.459429849054049	false	false	false
1c19a5b0-d755-4eb6-98b3-37b26da3edb1	2026-09-28 11:51	2026-09-28 11:51	2026-09-28 11:51	CCJ	CCJ270917P00075000	put	75.0000	2027-09-17	7.6500	6.7500	7.9500	86.8100	10710.00	3060.00	2295.00	14	6	14	33	0.424242424242424	0.450629504897208	0.450629504897208	false	false	false
ff9bb6ad-34f4-428b-a54d-77fbace59508	2026-09-28 11:49	2026-09-28 11:49	2026-09-28 11:49	XOM	XOM261023C00165000	call	165.0000	2026-10-23	4.3500	4.3000	4.3500	163.2051	20870.00	20870.00	0.00	48	17	59	433	0.136258660508083	0.291771786310238	0.291771786310238	false	false	false
ff05045c-f590-42e6-9a50-a401c1b57320	2026-09-28 11:49	2026-09-28 11:49	2026-09-28 11:49	XOM	XOM261023C00167500	call	167.5000	2026-10-23	3.3000	3.2000	3.3000	163.2051	48496.00	45526.00	0.00	147	28	152	127	1.19685039370079	0.289140166708515	0.289140166708515	true	false	false
0ae2b824-a900-4aca-b280-fa4cb0eaa47b	2026-09-28 11:49	2026-09-28 11:49	2026-09-28 11:49	XOM	XOM261023C00170000	call	170.0000	2026-10-23	2.4600	2.3800	2.4700	163.2192	35670.00	18277.00	17393.00	145	36	179	522	0.342911877394636	0.288543107030235	0.285628851110889	true	false	false
d7570a2b-7da6-48a4-9dc1-496bdfda10e8	2026-09-28 11:46	2026-09-28 11:46	2026-09-28 11:46	DINO	DINO270115P00105000	put	105.0000	2027-01-15	11.4000	11.4000	11.9000	106.6150	34200.00	0.00	34200.00	30	8	30	47	0.638297872340426	0.561828334907024	0.561828334907024	false	false	false
c268ff3b-3e7d-433f-a1e8-1a4857876cee	2026-09-28 11:46	2026-09-28 11:46	2026-09-28 11:46	DINO	DINO270115P00110000	put	110.0000	2027-01-15	14.2000	14.2000	14.7000	106.6150	15620.00	0.00	15620.00	11	7	11	324	0.0339506172839506	0.564472169759626	0.564472169759626	false	false	false
70b56970-3964-4603-bbce-3c5052daedbe	2026-09-28 11:40	2026-09-28 11:40	2026-09-28 11:40	OXY	OXY261002C00058000	call	58.0000	2026-10-02	0.4900	0.4500	0.5000	56.9999	49033.00	49033.00	0.00	1000	33	2783	9654	0.288274290449555	0.376259706657753	0.376976226866432	true	false	false
4285fd34-1acc-4b7d-9046-30931e1213f2	2026-09-28 11:40	2026-09-28 11:40	2026-09-28 11:40	OXY	OXY261002C00058000	call	58.0000	2026-10-02	0.4900	0.4500	0.5000	56.9550	48700.00	48700.00	0.00	1000	7	1783	9654	0.184690283820178	0.379347445480192	0.379347445480192	false	false	false
fc35f31d-f3b6-465c-b735-52ef069a3388	2026-09-28 11:39	2026-09-28 11:39	2026-09-28 11:39	DVN	DVN270115P00042500	put	42.5000	2027-01-15	1.5600	1.5100	1.6100	47.3500	14196.00	13260.00	936.00	91	5	167	2139	0.0780738662926601	0.374910731913801	0.374910731913801	false	false	false
e1cc6364-0e84-4a1b-bd22-460b8bcb85c4	2026-09-28 11:39	2026-09-28 11:38	2026-09-28 11:38	VLO	VLO261016P00370000	put	370.0000	2026-10-16	9.8000	9.8000	10.5000	390.1500	36260.00	0.00	36260.00	37	12	547	1638	0.333943833943834	0.547060325730345	0.547060325730345	false	false	false
fb7217bb-d9e6-4c34-a140-e2f0def80234	2026-09-28 11:38	2026-09-28 11:38	2026-09-28 11:38	VLO	VLO261016P00370000	put	370.0000	2026-10-16	10.0000	10.0000	10.7000	390.1500	140060.00	0.00	140060.00	140	17	485	1638	0.296092796092796	0.554157304250972	0.553654597752054	true	false	false
956ea2c1-2937-4ca1-965d-e7a128568283	2026-09-28 11:38	2026-09-28 11:38	2026-09-28 11:38	CLMT	CLMT261016P00055000	put	55.0000	2026-10-16	3.8700	3.8000	4.4000	52.9500	19360.00	0.00	19360.00	50	6	151	1596	0.0946115288220551	0.587362954554585	0.587362954554585	false	false	false
59995683-58bf-4116-83f1-16d42bdd0a53	2026-09-28 11:37	2026-09-28 11:37	2026-09-28 11:37	MPC	MPC261218C00440000	call	440.0000	2026-12-18	20.4000	19.9000	20.4000	391.6800	44880.00	44880.00	0.00	22	5	33	86	0.383720930232558	0.497137560004114	0.497137560004114	false	false	false
97fea8b5-2960-4dc3-adbc-80f757568aec	2026-09-28 11:35	2026-09-28 11:35	2026-09-28 11:35	CLMT	CLMT270521P00055000	put	55.0000	2027-05-21	11.3000	10.6000	11.8000	52.8300	28250.00	4520.00	23730.00	25	5	25	25	1	0.65408456405178	0.65408456405178	false	false	false
c61cd255-40a8-42f1-8599-5eca5a29c04f	2026-09-28 11:34	2026-09-28 11:34	2026-09-28 11:34	EQT	EQT261120C00055000	call	55.0000	2026-11-20	0.9700	0.9100	0.9700	50.0175	19316.00	19316.00	0.00	200	24	203	710	0.285915492957746	0.336776926782471	0.335173002942974	true	false	false
d6c4ddac-f6fa-4e36-b632-901c7f2b026b	2026-09-28 11:33	2026-09-28 11:33	2026-09-28 11:33	OXY	OXY270115C00080000	call	80.0000	2027-01-15	0.2900	0.2900	0.3400	56.9900	19285.00	0.00	19285.00	665	41	700	15520	0.0451030927835052	0.366370235684202	0.366370235684202	false	false	false
9059ea8f-9f2c-4e93-96b4-49be065849bc	2026-09-28 11:25	2026-09-28 11:25	2026-09-28 11:25	CVX	CVX261009P00205000	put	205.0000	2026-10-09	2.6500	2.5000	2.7100	208.0000	14290.00	7232.00	7058.00	54	6	279	119	2.34453781512605	0.290152328253922	0.28352378898739	true	false	false
2ae742e3-38ea-4966-b282-5062fea1712e	2026-09-28 11:25	2026-09-28 11:25	2026-09-28 11:25	CVX	CVX261009P00202500	put	202.5000	2026-10-09	1.8700	1.6900	1.9400	208.0000	11948.00	6092.00	5856.00	64	8	99	54	1.83333333333333	0.296720986244633	0.287682321555168	true	false	false
e3abffe9-7e0c-4968-9ef0-759543f368bf	2026-09-28 11:22	2026-09-28 11:22	2026-09-28 11:22	XOM	XOM261218P00140000	put	140.0000	2026-12-18	1.8000	1.8000	1.8300	163.0000	78840.00	0.00	78840.00	438	23	966	3810	0.253543307086614	0.331268955716181	0.331268955716181	false	false	false
46595cda-56f6-44e7-9988-5360811b3499	2026-09-28 11:22	2026-09-28 11:22	2026-09-28 11:22	XOM	XOM261218P00140000	put	140.0000	2026-12-18	1.8000	1.8000	1.8300	163.0000	10440.00	0.00	10440.00	58	10	528	3810	0.138582677165354	0.331268955716181	0.331268955716181	false	false	false
9f008622-7ea9-4986-b684-e580475b937e	2026-09-28 11:19	2026-09-28 11:19	2026-09-28 11:19	CVX	CVX261016P00210000	put	210.0000	2026-10-16	5.6800	5.5000	5.8500	208.0000	10224.00	6270.00	3954.00	18	6	23	2162	0.0106382978723404	0.261122440382538	0.264393315890849	false	false	false
25a90428-770b-4ff4-ac01-ad0f649a68da	2026-09-28 11:19	2026-09-28 11:19	2026-09-28 11:19	PBR	PBR261030C00021500	call	21.5000	2026-10-30	1.1500	1.1500	1.1700	20.0000	46345.00	0.00	46345.00	403	21	413	1747	0.236405266170578	0.562598141747001	0.562598141747001	false	false	false
9002ad3c-66a2-4e1b-a6b6-31ffef2c0def	2026-09-28 11:16	2026-09-28 11:15	2026-09-28 11:15	PBR	PBR270115P00022000	put	22.0000	2027-01-15	2.7000	2.7000	2.7800	20.0000	24030.00	0.00	24030.00	89	5	269	4389	0.0612895876053771	0.483503449916607	0.483503449916607	false	false	false
0f3592cb-33cf-4e2c-8743-d3c80773eaab	2026-09-28 11:15	2026-09-28 11:15	2026-09-28 11:15	XOM	XOM261009C00175000	call	175.0000	2026-10-09	0.4100	0.4100	0.4700	163.0000	61828.00	0.00	61828.00	1508	53	1589	748	2.12433155080214	0.306422180234488	0.306422180234488	false	false	false
2172febc-e720-4e0a-ab68-53368743f290	2026-09-28 11:08	2026-09-28 11:08	2026-09-28 11:08	VLO	VLO261016P00370000	put	370.0000	2026-10-16	9.2000	9.0000	9.2000	393.0450	80960.00	80960.00	0.00	88	5	286	1638	0.174603174603175	0.555472592529424	0.555472592529424	false	false	false
d51d290d-326a-4552-b9bc-1667555cf0ca	2026-09-28 11:08	2026-09-28 11:08	2026-09-28 11:08	CLMT	CLMT261016P00055000	put	55.0000	2026-10-16	3.7100	3.7000	4.1000	53.1300	18560.00	0.00	0.00	50	16	51	1596	0.0319548872180451	0.577439766037402	0.577439766037402	false	false	false
11169104-e244-4918-80db-6428027c3111	2026-09-28 11:06	2026-09-28 11:06	2026-09-28 11:06	CVX	CVX261218P00185000	put	185.0000	2026-12-18	2.9200	2.8700	2.9200	207.9200	27448.00	27448.00	0.00	94	27	101	1381	0.0731354091238233	0.30477831415643	0.30477831415643	false	false	false
87286b5d-e44f-475a-9523-d0ce658fff4b	2026-09-28 11:05	2026-09-28 11:05	2026-09-28 11:05	XOM	XOM261218P00140000	put	140.0000	2026-12-18	1.8000	1.8000	1.8900	163.1800	10980.00	0.00	10980.00	61	15	324	3810	0.0850393700787402	0.331228862025256	0.331228862025256	false	false	false
f98ef3d8-5bb0-4a02-9172-7ba91e2c334a	2026-09-28 11:05	2026-09-28 11:04	2026-09-28 11:04	CVX	CVX261009P00205000	put	205.0000	2026-10-09	2.6800	2.6100	2.9000	207.8200	37768.00	13738.00	24030.00	141	8	172	119	1.4453781512605	0.280709527433157	0.281390369322433	false	false	false
83774062-18f8-4b66-a437-81aee32b3adc	2026-09-28 11:04	2026-09-28 11:03	2026-09-28 11:03	MPC	MPC261016C00420000	call	420.0000	2026-10-16	8.7000	7.5000	8.7000	394.9300	11307.00	11307.00	0.00	13	5	26	707	0.0367751060820368	0.508554809533592	0.508554809533592	false	false	false
af1272ab-2ad1-4c6c-935f-df7256a5660c	2026-09-28 11:03	2026-09-28 11:03	2026-09-28 11:03	VLO	VLO261002C00380000	call	380.0000	2026-10-02	16.1900	14.2000	16.2000	389.4800	17813.00	17813.00	0.00	11	11	17	104	0.163461538461538	0.660981503142186	0.66563591675183	false	false	false
b7bc5db1-1ab0-4d07-9ed3-fa34a5992f92	2026-09-28 10:57	2026-09-28 10:57	2026-09-28 10:57	DINO	DINO270115C00135000	call	135.0000	2027-01-15	4.7000	4.7000	5.0000	106.3550	34310.00	0.00	34310.00	73	27	73	115	0.634782608695652	0.552146716365469	0.552146716365469	false	false	false
4fb06d8a-4de2-4b8f-9c50-0a58fe0e077f	2026-09-28 10:55	2026-09-28 10:54	2026-09-28 10:54	CVX	CVX261002C00210000	call	210.0000	2026-10-02	1.5800	1.5500	1.6900	207.5900	12137.00	0.00	12137.00	77	5	418	3689	0.113309840065058	0.295303266488807	0.295303266488807	false	false	false
26d3e13f-3dd4-40b4-a7eb-5a07b4150a59	2026-09-28 10:54	2026-09-28 10:54	2026-09-28 10:54	EPD	EPD261218C00038000	call	38.0000	2026-12-18	0.5700	0.5600	0.6500	36.6750	11331.00	0.00	11331.00	200	8	211	698	0.302292263610315	0.138699952332592	0.140250238930427	false	false	false
16a5572b-d963-439d-bf63-0ea35f2600d1	2026-09-28 10:54	2026-09-28 10:54	2026-09-28 10:54	XOM	XOM261023P00165000	put	165.0000	2026-10-23	5.8000	5.5500	6.1500	163.0700	30740.00	10440.00	20300.00	53	8	75	106	0.707547169811321	0.294098842405994	0.294098842405994	false	false	false
fe5ed557-9ee4-4e0e-b791-df495451905a	2026-09-28 10:52	2026-09-28 10:52	2026-09-28 10:52	OXY	OXY270617P00052500	put	52.5000	2027-06-17	3.8500	3.6500	4.0500	56.8800	19238.00	0.00	4608.00	50	5	50	1273	0.0392772977219167	0.354750434763361	0.354750434763361	false	false	false