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×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

24e1a404-8c17-4262-9778-b5156562014c	2026-09-28 10:34	2026-09-28 10:34	2026-09-28 10:34	BP	BP280121P00035000	put	35.0000	2028-01-21	2.0700	2.0600	2.1800	44.9300	12211.00	1242.00	10969.00	59	6	59	1663	0.0354780517137703	0.363398407759556	0.363398407759556	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ADR	Energy	122081147706.00	2026-10-30	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T14:35:37.335936Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
e00944dd-5990-44df-aee8-d928a3ff47fd	2026-09-28 10:33	2026-09-28 10:33	2026-09-28 10:33	OKE	OKE270115P00082500	put	82.5000	2027-01-15	2.8500	2.7000	2.8500	88.5801	11970.00	11970.00	0.00	42	10	43	249	0.172690763052209	0.309446666077751	0.309446666077751	false	false	false
31060148-28c0-4bf9-8ebe-112ff004c252	2026-09-28 10:31	2026-09-28 10:31	2026-09-28 10:31	FANG	FANG270319P00160000	put	160.0000	2027-03-19	7.1000	7.0000	7.2000	187.2200	13490.00	0.00	10650.00	19	6	25	55	0.454545454545455	0.394317943106949	0.394317943106949	false	false	false
618bbc41-2d9a-4578-a530-4eb8355ab3c3	2026-09-28 10:30	2026-09-28 10:30	2026-09-28 10:30	TTE	TTE270219C00095000	call	95.0000	2027-02-19	3.8000	3.3000	3.8000	91.0000	28120.00	28120.00	0.00	74	16	74	100	0.74	0.202382671240274	0.202382671240274	false	false	false	true
e9cf6317-5f6f-43cb-9f25-403557ead1bc	2026-09-28 10:28	2026-09-28 10:28	2026-09-28 10:28	SU	SU261120P00065000	put	65.0000	2026-11-20	1.8000	1.8000	1.9000	69.0000	10080.00	0.00	10080.00	56	8	56	1070	0.0523364485981308	0.352537040033825	0.352537040033825	false	false	false
5d33eda6-43ec-43ac-9aa0-221603de2886	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	CCJ	CCJ261030C00088000	call	88.0000	2026-10-30	4.7000	4.1500	4.7000	87.0000	20210.00	20210.00	0.00	43	10	44	2	22	0.48065239447411	0.48065239447411	false	false	false	true
f04c334c-0752-40e0-8925-b005b6507230	2026-09-28 10:23	2026-09-28 10:23	2026-09-28 10:23	EQT	EQT261030P00047000	put	47.0000	2026-10-30	0.6900	0.4700	0.7000	50.0000	17199.00	11097.00	6102.00	251	5	251	27	9.2962962962963	0.326090710250234	0.326090710250234	true	false	false
1de8cfb6-0a65-4088-9b5b-6508b8deb5c1	2026-09-28 10:23	2026-09-28 10:22	2026-09-28 10:22	WMB	WMB270115P00065000	put	65.0000	2027-01-15	2.5500	2.4500	2.5500	68.0000	69077.00	69077.00	0.00	271	41	272	6075	0.0447736625514403	0.308835413065711	0.308835413065711	false	false	false
9bd9e9df-a347-4d8f-b462-404c11a5edfb	2026-09-28 10:21	2026-09-28 10:20	2026-09-28 10:20	EXE	EXE261120C00085000	call	85.0000	2026-11-20	4.7400	4.5000	5.7000	85.9300	47385.00	0.00	47385.00	100	5	100	660	0.151515151515152	0.310946969582358	0.310946969582358	false	false	false
f8dc377e-cd65-4892-856a-d6d6d813c8ca	2026-09-28 10:18	2026-09-28 10:17	2026-09-28 10:17	KMI	KMI280121P00025000	put	25.0000	2028-01-21	1.2500	1.2500	1.3100	30.6190	11250.00	0.00	11250.00	90	8	157	3305	0.0475037821482602	0.310836920790726	0.310836920790726	false	false	false
dbc8de30-24e4-4840-bbb6-c7a2b121ee86	2026-09-28 10:17	2026-09-28 10:17	2026-09-28 10:17	CVX	CVX261002P00207500	put	207.5000	2026-10-02	2.6900	2.5900	2.7800	207.2300	20735.00	13760.00	6975.00	77	9	165	302	0.54635761589404	0.304822812867122	0.307229806376982	true	false	false
08eb4722-5985-4e4e-8a56-7412212bb876	2026-09-28 10:11	2026-09-28 10:11	2026-09-28 10:11	CLMT	CLMT270319C00060000	call	60.0000	2027-03-19	7.6900	7.3000	8.0000	53.1400	31514.00	26934.00	4580.00	41	11	47	1620	0.0290123456790123	0.672424872341991	0.672424872341991	false	false	false
ec0f5cde-312c-40d4-8bfc-89361873b5d8	2026-09-28 10:11	2026-09-28 10:11	2026-09-28 10:11	PBR	PBR261030P00020000	put	20.0000	2026-10-30	1.0300	0.7300	1.0900	20.6300	33762.00	2153.00	30895.00	328	22	328	5696	0.0575842696629214	0.561172069003928	0.565453640204217	false	false	false
c11177cf-cfdb-4451-a35c-6120be42d5de	2026-09-28 10:11	2026-09-28 10:11	2026-09-28 10:11	CVX	CVX261218C00220000	call	220.0000	2026-12-18	5.7500	5.7000	5.8000	207.5850	25290.00	575.00	24715.00	44	6	57	4601	0.0123886111714845	0.252631974431221	0.252631974431221	false	false	false
18bf5e61-d307-44dd-bedd-fe4bfbb977b5	2026-09-28 10:09	2026-09-28 10:09	2026-09-28 10:09	AMTX	AMTX261120C00002500	call	2.5000	2026-11-20	0.2500	0.1000	0.2500	1.9400	25000.00	25000.00	0.00	1000	11	3913	20	195.65	1.4321787422672	1.4321787422672	false	false	false
67f76f76-e30a-4d17-9ea6-856516c035fa	2026-09-28 10:08	2026-09-28 10:08	2026-09-28 10:08	RIG	RIG261218C00006000	call	6.0000	2026-12-18	0.3000	0.3000	0.3200	5.3700	14940.00	0.00	14940.00	498	14	583	3226	0.180719156850589	0.508656020064949	0.508656020064949	false	false	false
0d8e2b1f-0105-4e7e-9dba-7881cfeeb9bf	2026-09-28 10:07	2026-09-28 10:07	2026-09-28 10:07	DINO	DINO261218C00120000	call	120.0000	2026-12-18	6.6000	6.6000	7.0000	106.8100	34320.00	0.00	34320.00	52	24	52	252	0.206349206349206	0.551544847819822	0.551544847819822	false	false	false
e17321c1-ccea-4d19-a745-69c28522efaa	2026-09-28 10:04	2026-09-28 10:04	2026-09-28 10:04	AMTX	AMTX280121C00005000	call	5.0000	2028-01-21	0.6000	0.2500	0.6000	1.9400	33780.00	33780.00	0.00	563	11	2500	2629	0.950931913275009	1.22821537614346	1.22821537614346	false	false	false
70fb00d1-ee19-43aa-b1d4-aa471eabb6e2	2026-09-28 10:04	2026-09-28 10:04	2026-09-28 10:04	AMTX	AMTX280121C00005000	call	5.0000	2028-01-21	0.6000	0.2500	0.6000	1.9300	26084.00	26084.00	0.00	437	49	1937	2629	0.736782046405477	1.24030014971582	1.23423491414047	false	false	false
d2a6c2d1-6571-4225-a5de-8f7023ef07f1	2026-09-28 10:01	2026-09-28 10:01	2026-09-28 10:01	AMTX	AMTX261120C00002500	call	2.5000	2026-11-20	0.2000	0.1500	0.2000	1.8900	10060.00	10060.00	0.00	503	14	2910	20	145.5	1.32764435249624	1.32764435249624	false	false	false
93348400-6df9-496b-982d-489f48ff1455	2026-09-28 10:01	2026-09-28 10:01	2026-09-28 10:01	AMTX	AMTX261120C00002500	call	2.5000	2026-11-20	0.2000	0.1500	0.2000	1.8550	29940.00	29940.00	0.00	1497	30	2407	20	120.35	1.37708560017846	1.37708560017846	false	false	false
087fcb75-ca9e-4ef5-85f5-5a4766c37928	2026-09-28 09:59	2026-09-28 09:59	2026-09-28 09:59	EQT	EQT261120P00047500	put	47.5000	2026-11-20	1.2100	1.2100	1.2700	50.1900	11859.00	0.00	11859.00	98	27	99	625	0.1584	0.32617029738139	0.327697816691847	false	false	false	true
c5b36fa3-579d-440a-83b1-1e342de19599	2026-09-28 09:58	2026-09-28 09:58	2026-09-28 09:58	PBR	PBR261009P00019500	put	19.5000	2026-10-09	0.4000	0.3800	0.4200	20.0000	32960.00	0.00	31960.00	824	10	825	1213	0.680131904369332	0.60404843529262	0.60404843529262	false	false	false
a8e1b192-3f12-4dc6-9113-d41ce7ece719	2026-09-28 09:52	2026-09-28 09:52	2026-09-28 09:52	VLO	VLO261016P00365000	put	365.0000	2026-10-16	8.5000	8.4000	9.3000	390.0000	68820.00	0.00	68820.00	81	22	123	360	0.341666666666667	0.56177495444725	0.558270132615229	false	false	false
6b42b33a-1e05-42cd-8de3-44e4205e0de7	2026-09-28 09:51	2026-09-28 09:51	2026-09-28 09:51	AMTX	AMTX280121C00005000	call	5.0000	2028-01-21	0.5500	0.2500	0.5500	1.8250	41250.00	41250.00	0.00	750	5	1500	2629	0.570559147965006	1.24025559910492	1.24025559910492	false	false	false
29f7a22f-0c50-41dc-96f4-f7e6bafdc4bc	2026-09-28 09:50	2026-09-28 09:50	2026-09-28 09:50	SLB	SLB261120C00065000	call	65.0000	2026-11-20	0.3200	0.2300	0.3900	51.3200	27009.00	1152.00	25857.00	844	20	844	5242	0.161007249141549	0.423318245269836	0.423318245269836	false	false	false
070fe788-abcf-4007-bf8b-26369403bb61	2026-09-28 09:50	2026-09-28 09:50	2026-09-28 09:50	AMTX	AMTX280121C00005000	call	5.0000	2028-01-21	0.5000	0.2500	0.5000	1.8000	21694.00	21694.00	0.00	434	10	750	2629	0.285279573982503	1.12502760033779	1.1952198743129	false	false	false
dcf271e5-4237-419e-b09d-247fe5df4e35	2026-09-28 09:49	2026-09-28 09:49	2026-09-28 09:49	CCJ	CCJ261016C00090000	call	90.0000	2026-10-16	2.0000	2.0000	2.1400	86.3900	10000.00	0.00	10000.00	50	8	153	450	0.34	0.441871548834097	0.441871548834097	false	false	false	true
e8b11113-c4bb-4d5e-8e24-eb40bc25b5a1	2026-09-28 09:48	2026-09-28 09:48	2026-09-28 09:48	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	2.2000	2.1800	2.3200	86.3500	37400.00	2860.00	34540.00	170	22	417	5067	0.0822972172883363	0.485235055976419	0.485235055976419	false	false	false
b06ffa10-67fc-4568-bad3-b2abe1430a41	2026-09-28 09:48	2026-09-28 09:48	2026-09-28 09:48	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	2.2700	2.2000	2.2700	86.3500	23815.00	22695.00	1120.00	105	28	247	5067	0.0487467929741464	0.491876178542991	0.489036189732649	false	false	false
001480aa-e968-43e4-8a99-edae0e99104f	2026-09-28 09:48	2026-09-28 09:48	2026-09-28 09:48	ET	ET261030C00020000	call	20.0000	2026-10-30	0.6000	0.5100	0.7800	20.1850	69691.00	1860.00	67831.00	1161	20	1161	608	1.90953947368421	0.189940519392174	0.193866656411477	true	false	false
f1001ccd-8fa0-4418-82f1-0f9a158bad2e	2026-09-28 09:47	2026-09-28 09:47	2026-09-28 09:47	CLMT	CLMT261120C00050000	call	50.0000	2026-11-20	7.4100	7.0000	7.9000	53.7600	20740.00	0.00	20740.00	28	5	28	3295	0.00849772382397572	0.65357037521967	0.654918311508522	false	false	false
b9324483-6cf9-45b6-b891-c91d2ec9311c	2026-09-28 09:46	2026-09-28 09:46	2026-09-28 09:46	ET	ET261016C00021000	call	21.0000	2026-10-16	0.1000	0.0900	0.1000	20.1650	10940.00	10940.00	0.00	1094	31	1158	38589	0.0300085516597994	0.202338322619057	0.202338322619057	false	false	false
5e86a8f8-fbe7-4c07-882b-e2496140e34b	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	VLO	VLO261009P00370000	put	370.0000	2026-10-09	7.0000	6.3000	7.3000	391.7700	28000.00	22400.00	5600.00	40	5	140	164	0.853658536585366	0.594713392801097	0.594713392801097	false	false	false
73236f33-be35-4fbc-8a76-91c907a144eb	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	PBR	PBR261030C00022000	call	22.0000	2026-10-30	0.8600	0.8400	0.9400	20.6100	11258.00	0.00	11258.00	131	14	1964	1046	1.87762906309751	0.565985489404627	0.557424649238456	false	false	false
a6895948-6e52-42aa-91bd-9e2566e4197f	2026-09-28 09:44	2026-09-28 09:44	2026-09-28 09:44	CCJ	CCJ280121C00125000	call	125.0000	2028-01-21	9.0500	8.9000	9.0500	86.0581	54300.00	12670.00	0.00	60	9	60	438	0.136986301369863	0.462595961454221	0.462595961454221	false	false	false
1862768c-25f0-44c3-9db2-4be005c07d41	2026-09-28 09:42	2026-09-28 09:42	2026-09-28 09:42	PBR	PBR261030C00022000	call	22.0000	2026-10-30	0.8600	0.8000	1.0000	20.5850	11094.00	0.00	11094.00	129	10	1760	1046	1.68260038240918	0.570133704335331	0.570133704335331	false	false	false
96181df6-a6da-434b-b9c8-a53fbc97cca7	2026-09-28 09:42	2026-09-28 09:42	2026-09-28 09:42	PBR	PBR261030C00022000	call	22.0000	2026-10-30	0.8600	0.8600	1.0000	20.5900	32078.00	0.00	32078.00	373	18	1631	1046	1.55927342256214	0.569304566782129	0.569304566782129	false	false	false
0cab7816-9ca9-4915-b288-82c9ea7db5ff	2026-09-28 09:40	2026-09-28 09:40	2026-09-28 09:40	PBR	PBR261030C00022000	call	22.0000	2026-10-30	0.8500	0.8500	1.0400	20.5612	37741.00	0.00	37741.00	444	29	1258	1046	1.20267686424474	0.569779126658565	0.569779126658565	true	false	false
8bb74c9f-1279-4fd5-af6f-fd451e34defa	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	GLND	GLND261016C00005000	call	5.0000	2026-10-16	0.9000	0.9000	0.9500	5.0000	10530.00	0.00	10530.00	117	5	5270	2743	1.92125410134889	1.25089023720348	1.26496239280463	false	false	false
c4ff8ab1-15ef-40d9-83de-c5b30dc093ca	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	BP	BP280121C00045000	call	45.0000	2028-01-21	5.6500	5.5000	5.7000	44.0000	48025.00	48025.00	0.00	85	8	223	2235	0.0997762863534676	0.233472721312872	0.233472721312872	false	false	false
8b4b4372-a8ad-4431-bb9b-7bdc2868fad6	2026-09-25 15:53	2026-09-25 15:53	2026-09-25 15:53	NFG	NFG270115P00075000	put	75.0000	2027-01-15	3.0000	1.5500	3.8000	78.9900	300000.00	300000.00	0.00	1000	1	1000	254	3.93700787401575	0.302631984925227	0.302631984925227	false	true	true
4dc4fcc6-0bad-40bb-88a1-0357d983fadd	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	MPC	MPC261016P00390000	put	390.0000	2026-10-16	16.0700	15.6000	16.7000	392.9450	12855.00	0.00	12855.00	8	5	118	1113	0.106019766397125	0.478818689945329	0.480162085456673	false	false	false
dbe2ac8d-6b42-4369-bd3a-0fda511baf4e	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	VLO	VLO261016P00370000	put	370.0000	2026-10-16	12.0000	11.6000	12.5000	386.8000	239999.00	83999.00	130800.00	200	24	1252	919	1.36235038084875	0.541631882255094	0.541631882255094	true	false	false
e62bc4fa-edea-4fab-b6f2-b1ecf367e64e	2026-09-25 15:49	2026-09-25 15:49	2026-09-25 15:49	CVX	CVX261218C00210000	call	210.0000	2026-12-18	8.2000	7.9000	8.3500	204.0000	228783.00	26240.00	200903.00	279	50	362	4462	0.0811295383236217	0.250501329936435	0.250501329936435	false	false	false
7dab34d3-7763-4aaa-9f2f-3bf889077fd9	2026-09-25 15:49	2026-09-25 15:49	2026-09-25 15:49	CVX	CVX261218C00220000	call	220.0000	2026-12-18	4.8000	4.8000	4.9500	204.0000	106572.00	0.00	106572.00	222	29	274	4792	0.0571786310517529	0.251229438148844	0.251229438148844	false	false	false
ba05dee3-3234-44c3-ab1c-3ba8133134b7	2026-09-25 15:49	2026-09-25 15:48	2026-09-25 15:48	ET	ET280121C00022000	call	22.0000	2028-01-21	0.9400	0.9100	0.9500	20.0000	47000.00	7520.00	39480.00	500	5	2794	27919	0.100075217593753	0.123141441971458	0.123141441971458	false	false	false
408f576d-a960-4e5d-8e2a-715e5f4eff33	2026-09-25 15:47	2026-09-25 15:47	2026-09-25 15:47	HAL	HAL261218C00040000	call	40.0000	2026-12-18	0.4500	0.4200	0.4500	32.0000	17370.00	17370.00	0.00	386	43	564	10123	0.0557147090783365	0.367758850403221	0.367758850403221	false	false	false
33f06c37-1f99-4dbd-a590-33beb003945b	2026-09-25 15:47	2026-09-25 15:47	2026-09-25 15:47	ET	ET280121C00022000	call	22.0000	2028-01-21	0.9400	0.9100	0.9500	20.0000	47000.00	6580.00	40420.00	500	6	1294	27919	0.0463483649127834	0.122383019376502	0.122383019376502	false	false	false
66e929e3-56e4-4b13-9c47-bec8067a1a6e	2026-09-25 15:45	2026-09-25 15:45	2026-09-25 15:45	OXY	OXY261120P00055000	put	55.0000	2026-11-20	2.0500	2.0100	2.1200	56.0000	15990.00	10865.00	5125.00	78	6	91	3498	0.0260148656375071	0.350899632718615	0.351328677239388	false	false	false