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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×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

e597f741-0c5a-4276-9393-8ad5345881b2	2026-09-14 11:52	2026-09-14 11:52	2026-09-14 11:52	PBF	PBF261016C00077500	call	77.5000	2026-10-16	4.9900	4.0000	5.2000	73.1300	150290.00	121290.00	29000.00	301	43	811	88	9.21590909090909	0.76358570209576	0.773682882929501	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	8344993395.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-14T16:02:31.142849Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
50aa4044-0051-4937-ac51-21091b20aa88	2026-09-14 11:39	2026-09-14 11:39	2026-09-14 11:39	CCJ	CCJ260918C00098000	call	98.0000	2026-09-18	0.6500	0.5300	0.6600	93.3500	18067.00	17287.00	780.00	277	20	589	62	9.5	0.560771574017594	0.564273274355304	true	false	false	true
086d6fc4-39bb-4b4b-b580-df4358a7e054	2026-09-14 11:32	2026-09-14 11:32	2026-09-14 11:32	VLO	VLO261218P00390000	put	390.0000	2026-12-18	41.1000	40.2000	41.2000	384.0950	98650.00	98650.00	0.00	24	9	57	352	0.161931818181818	0.51503577397786	0.516323395067622	false	false	false	true
a87d33a7-fb11-4f89-a6b4-3af613ed4fa1	2026-09-14 11:10	2026-09-14 11:10	2026-09-14 11:10	XOM	XOM261016C00175000	call	175.0000	2026-10-16	2.6500	2.5500	2.8900	166.0600	375359.00	107444.00	253340.00	1415	44	1578	10067	0.156749776497467	0.293587978346317	0.295336142239812	true	false	false	true
ee8d3427-0854-4248-aa69-000b9b42730c	2026-09-14 10:49	2026-09-14 10:49	2026-09-14 10:49	GLNG	GLNG280121P00050000	put	50.0000	2028-01-21	5.7700	3.5000	8.4000	51.8000	28830.00	0.00	28830.00	50	5	50	501	0.0998003992015968	0.348880953338047	0.350717413507308	false	false	false	true
dbe1b7d3-1d59-41fa-97fc-b12aaf3b5eb6	2026-09-14 10:21	2026-09-14 10:21	2026-09-14 10:21	SM	SM261016C00040000	call	40.0000	2026-10-16	2.3700	2.3500	2.4500	39.0000	11843.00	0.00	11843.00	50	6	66	523	0.126195028680688	0.498285519438011	0.504673132323419	false	false	false	true
bc6f1106-fb7c-4f25-b844-9c2cad1768ff	2026-09-11 15:55	2026-09-11 15:55	2026-09-11 15:55	STNG	STNG261016C00087500	call	87.5000	2026-10-16	2.5900	2.4500	2.7500	84.2225	25940.00	12006.00	11334.00	100	10	166	331	0.501510574018127	0.365228658672047	0.365228658672047	false	false	false	true
516b66f0-eaa6-45ab-9439-bd617fc42a44	2026-09-11 15:23	2026-09-11 15:23	2026-09-11 15:23	PBF	PBF261218P00065000	put	65.0000	2026-12-18	4.7300	4.6000	5.6000	78.3600	23658.00	0.00	18508.00	50	13	50	59	0.847457627118644	0.689990921223194	0.733929931984189	false	false	false	true
ef00e63e-eb59-4287-b04d-c28fe5f2276b	2026-09-11 14:41	2026-09-11 14:41	2026-09-11 14:41	VLO	VLO261218C00400000	call	400.0000	2026-12-18	38.4500	37.1000	38.5000	391.8000	99970.00	96130.00	3840.00	26	15	49	353	0.138810198300283	0.496251561930109	0.49749139335123	true	false	false	true
aae5a7e3-4a36-4802-a74f-c633a7ea2430	2026-09-11 13:58	2026-09-11 13:58	2026-09-11 13:58	LEU	LEU261016P00150000	put	150.0000	2026-10-16	10.3900	10.2000	10.4000	155.3100	11431.00	11431.00	0.00	11	5	207	2046	0.101173020527859	0.694298552117462	0.694298552117462	false	false	false	true
89cf1cba-b174-4d97-a256-ff7856c5a12a	2026-09-11 13:54	2026-09-11 13:54	2026-09-11 13:54	HAL	HAL261218C00037000	call	37.0000	2026-12-18	2.2400	2.1900	2.2400	35.6899	10965.00	8512.00	2453.00	49	10	62	1278	0.0485133020344288	0.358302680653416	0.359992471167276	true	false	false	true
5675a232-634b-4972-b91e-f7b64adac263	2026-09-11 13:09	2026-09-11 13:09	2026-09-11 13:09	OBE	OBE270115C00012500	call	12.5000	2027-01-15	2.2000	2.1000	2.2000	12.4700	36075.00	36075.00	0.00	164	11	700	4191	0.167024576473395	0.735661524482937	0.737090153711876	false	false	false	true
ce59b079-d299-47a9-a2db-cf7a3e3458db	2026-09-11 13:07	2026-09-11 13:06	2026-09-11 13:06	DHT	DHT261016C00024000	call	24.0000	2026-10-16	0.6000	0.6000	0.6500	22.0950	25145.00	0.00	25145.00	419	38	5090	668	7.61976047904192	0.462357178770607	0.462357178770607	true	false	false	true
74f31c44-6393-4964-b61a-361b1e9441a1	2026-09-11 12:34	2026-09-11 12:34	2026-09-11 12:34	GLNG	GLNG270115C00065000	call	65.0000	2027-01-15	0.8500	0.8500	1.1500	52.6650	15221.00	0.00	15221.00	179	35	189	7167	0.0263708664713269	0.322141380396428	0.322141380396428	true	false	false	true
4d4ac4f6-db07-4653-946c-9246d8719574	2026-09-11 12:20	2026-09-11 12:20	2026-09-11 12:20	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	7.4500	7.2500	7.7500	97.1100	312919.00	750.00	312169.00	420	48	423	6	70.5	0.49624977925332	0.499196941541934	false	false	false	true
f754d5ab-053c-40a4-8eb5-f8fb4d798815	2026-09-11 11:40	2026-09-11 11:39	2026-09-11 11:39	CLMT	CLMT270115C00070000	call	70.0000	2027-01-15	5.5500	5.4000	5.8000	58.1150	22192.00	0.00	22192.00	40	6	76	57	1.33333333333333	0.684073398899	0.684073398899	false	false	false	true
bcc75830-55a6-4776-99b8-45ca71d18783	2026-09-11 10:42	2026-09-11 10:42	2026-09-11 10:42	CCJ	CCJ261016C00115000	call	115.0000	2026-10-16	1.1600	1.0100	1.3300	96.8800	15027.00	0.00	7656.00	129	6	136	827	0.164449818621524	0.501075740789011	0.501075740789011	false	false	false	true
ff882971-931c-477a-a08b-04d316326bc4	2026-09-11 09:39	2026-09-11 09:39	2026-09-11 09:39	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.0000	1.0000	1.0600	60.6300	114316.00	0.00	114316.00	1143	49	3180	14102	0.225499929088073	0.327267423598397	0.331499670176248	false	false	false	true
ab0edfec-5f5f-4820-aaeb-ad800f818b39	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	MPC	MPC270319C00400000	call	400.0000	2027-03-19	53.9700	52.8000	55.7000	395.6650	183500.00	118770.00	5380.00	34	34	55	118	0.466101694915254	0.467548024226945	0.467275742257901	false	false	false	true
39f1e317-4257-4463-ab5e-29f93ee61545	2026-09-10 15:51	2026-09-10 15:51	2026-09-10 15:51	RRC	RRC261218C00045000	call	45.0000	2026-12-18	1.9500	1.9500	2.0500	42.0700	71178.00	0.00	71178.00	365	42	11551	390	29.6179487179487	0.33552124712432	0.33552124712432	false	false	false	true
b15fe373-05e1-4c7e-83d9-15dea2b52006	2026-09-10 15:08	2026-09-10 15:08	2026-09-10 15:08	VLO	VLO270617P00430000	put	430.0000	2027-06-17	82.8500	81.0000	82.9000	390.8200	132560.00	132560.00	0.00	16	6	26	0	0	0.494828623958493	0.495562723457251	true	false	false	true
b2069d81-0ad4-404e-b050-941408a0ca04	2026-09-10 15:07	2026-09-10 15:07	2026-09-10 15:07	VLO	VLO261218P00410000	put	410.0000	2026-12-18	49.4300	48.8000	49.5000	390.8450	98870.00	69230.00	29640.00	20	5	38	0	0	0.505049936596624	0.505049936596624	true	false	false	true
c2ab3910-d862-4b5d-9c7e-76b1c320754d	2026-09-10 14:33	2026-09-10 14:33	2026-09-10 14:33	YPF	YPF270115P00050000	put	50.0000	2027-01-15	2.2100	2.1500	2.6000	56.4800	44200.00	0.00	33200.00	200	7	251	899	0.279199110122358	0.397448331604749	0.415541177322965	false	false	false	true
71cbb815-821d-42b5-bff7-97c6dc6031ef	2026-09-10 13:36	2026-09-10 13:36	2026-09-10 13:36	VLO	VLO270617P00440000	put	440.0000	2027-06-17	89.4800	87.8000	89.5000	390.5300	259480.00	250540.00	8940.00	29	17	30	0	0	0.495891864469081	0.496624793975657	false	false	false	true
0efb70a0-b45b-4449-bd26-ba91abf68ca0	2026-09-10 13:36	2026-09-10 13:36	2026-09-10 13:36	PBR	PBR261218C00019000	call	19.0000	2026-12-18	3.4000	3.3000	3.5000	21.4300	61242.00	0.00	61242.00	180	15	181	813	0.222632226322263	0.428110674308695	0.430968846907697	true	false	false	true
c7a8e446-96f4-4d72-a40b-eda0861358a1	2026-09-10 13:05	2026-09-10 13:05	2026-09-10 13:05	MPC	MPC261218C00420000	call	420.0000	2026-12-18	33.3000	33.3000	34.4000	399.4800	376314.00	0.00	376314.00	113	23	119	128	0.9296875	0.482898491535668	0.482898491535668	false	false	false	true
3794b075-8e1e-4ab7-a7ef-cfd8217e102d	2026-09-10 12:09	2026-09-10 12:09	2026-09-10 12:09	YPF	YPF261016C00060000	call	60.0000	2026-10-16	1.6900	1.5500	1.7000	56.7650	16922.00	16922.00	0.00	100	7	195	1681	0.11600237953599	0.403190987044862	0.404682199818029	false	false	false	true
118e9198-5e07-469a-94f2-204acab6121b	2026-09-10 12:09	2026-09-10 12:09	2026-09-10 12:09	VIST	VIST260918C00080000	call	80.0000	2026-09-18	1.9100	0.9500	2.2000	79.4700	30410.00	30410.00	0.00	159	6	186	2092	0.0889101338432122	0.452735516926362	0.455472086350298	false	false	false	true
a137e742-99d4-4206-beca-b847c35223e8	2026-09-10 12:00	2026-09-10 12:00	2026-09-10 12:00	OBE	OBE270115C00015000	call	15.0000	2027-01-15	1.5500	1.3500	1.5500	12.9650	15455.00	14105.00	1350.00	100	7	384	3025	0.126942148760331	0.710097780484398	0.726567119748785	true	false	false	true
c81faa17-670e-407f-9b34-9209339bcc9e	2026-09-10 11:50	2026-09-10 11:50	2026-09-10 11:50	LEU	LEU270115P00140000	put	140.0000	2027-01-15	15.2700	13.6000	15.8000	168.9720	30533.00	16781.00	13752.00	20	9	21	61	0.344262295081967	0.78569170483467	0.786634480398653	false	false	false	true
8c27628f-5c21-4b6c-b5d0-71d600b4a447	2026-09-10 11:40	2026-09-10 11:39	2026-09-10 11:39	EXE	EXE270617C00120000	call	120.0000	2027-06-17	4.2600	3.4000	4.4000	96.1000	852983.00	852983.00	0.00	2000	5	2000	2549	0.784621420164771	0.310794370018978	0.310794370018978	false	false	false	true
69bf58ad-ad63-480f-a907-a04d948118a4	2026-09-10 10:23	2026-09-10 10:23	2026-09-10 10:23	KNTK	KNTK270319C00060000	call	60.0000	2027-03-19	1.9500	1.7500	2.8500	54.7350	73715.00	3510.00	41930.00	378	50	1186	70	16.9428571428571	0.220433721005106	0.220433721005106	true	false	false	true
359e93f0-4672-4ace-bb29-b41c165fadea	2026-09-10 09:39	2026-09-10 09:39	2026-09-10 09:39	VLO	VLO261016P00350000	put	350.0000	2026-10-16	7.7700	7.6000	8.9000	388.9000	77700.00	0.00	77700.00	100	7	253	630	0.401587301587302	0.477269325024155	0.489828884385471	false	false	false	true
d646f320-18c8-472b-b7ad-06364765b688	2026-09-10 09:38	2026-09-10 09:38	2026-09-10 09:38	CVX	CVX261023C00185000	call	185.0000	2026-10-23	31.5300	30.8500	33.4000	214.9050	94578.00	0.00	94578.00	30	5	30	30	1	0.31714098232249	0.318144089818932	false	false	false	true
9036cc60-ac21-4a37-83f4-cfc234748bb7	2026-09-09 15:36	2026-09-09 15:36	2026-09-09 15:36	PBR	PBR261120C00023000	call	23.0000	2026-11-20	1.0100	1.0000	1.1100	20.8802	50435.00	0.00	50435.00	500	23	512	2904	0.176308539944904	0.467959513528127	0.470806547029378	false	false	false	true
eb802032-946f-4a74-9f72-8a375c25979c	2026-09-09 15:23	2026-09-09 15:23	2026-09-09 15:23	SLB	SLB260918C00055000	call	55.0000	2026-09-18	2.9200	2.9000	3.0500	57.5300	146080.00	0.00	146080.00	500	7	9044	13334	0.678266086695665	0.345794980671855	0.353850557235315	false	false	false	true
1e688c88-4799-40d6-8371-ea27bb0f3ad9	2026-09-09 15:02	2026-09-09 15:02	2026-09-09 15:02	SEI	SEI260918P00062500	put	62.5000	2026-09-18	1.0000	1.0000	1.4000	68.5300	23235.00	0.00	23235.00	232	11	436	37	11.7837837837838	0.769399365215936	0.769399365215936	false	false	false	true
c2dc6f39-a684-426d-9dd7-19fee16adb8f	2026-09-09 14:33	2026-09-09 14:33	2026-09-09 14:33	PBF	PBF260918C00080000	call	80.0000	2026-09-18	2.3000	2.1000	2.4000	76.2600	204940.00	140080.00	64860.00	891	10	1820	12480	0.145833333333333	0.78941706406407	0.78941706406407	false	false	false	true
32bcfd59-8c70-424b-a4ae-9dbea318c954	2026-09-09 14:21	2026-09-09 14:21	2026-09-09 14:21	SU	SU270115P00070000	put	70.0000	2027-01-15	5.6800	5.4000	5.7000	68.7100	73855.00	73855.00	0.00	130	13	800	2069	0.386660222329628	0.336830400944406	0.341155707426248	true	false	false	true
f8f5f4f6-d382-4e27-9fb4-250f1dce740c	2026-09-09 14:20	2026-09-09 14:20	2026-09-09 14:20	SU	SU270115P00070000	put	70.0000	2027-01-15	5.5800	5.3000	5.6000	68.7900	69795.00	69795.00	0.00	125	5	250	2069	0.120831319478009	0.335438630591353	0.335438630591353	false	false	false	true
468f0e61-92e0-4cdf-a6f7-27f267d4bb5f	2026-09-09 14:08	2026-09-09 14:08	2026-09-09 14:08	BKR	BKR261016P00065000	put	65.0000	2026-10-16	3.0000	2.9500	3.0000	64.2900	58488.00	58488.00	0.00	195	28	604	887	0.680947012401353	0.33606990270208	0.337901362595161	false	false	false	true
a0b51530-5cf7-457b-836c-201512ef06fc	2026-09-09 13:22	2026-09-09 13:22	2026-09-09 13:22	VLO	VLO270617P00390000	put	390.0000	2027-06-17	59.9200	59.8000	60.6000	386.0000	131820.00	0.00	131820.00	22	13	43	214	0.200934579439252	0.474172859790953	0.474172859790953	true	false	false	true
e99e3fba-d786-4061-8db7-6d485d895bbf	2026-09-09 12:12	2026-09-09 12:12	2026-09-09 12:12	PTEN	PTEN270219C00017000	call	17.0000	2027-02-19	0.7500	0.7000	0.8000	12.8850	11064.00	0.00	10464.00	148	10	345	47	7.34042553191489	0.53794274272137	0.548010039994427	true	false	false	true
8d68394f-2dd5-4d9e-9b2f-b7fc5228fc29	2026-09-09 11:49	2026-09-09 11:48	2026-09-09 11:48	CVX	CVX270115P00190000	put	190.0000	2027-01-15	4.4500	4.4000	4.5500	212.9750	340433.00	4450.00	335983.00	765	53	793	1394	0.568866571018651	0.287680863254492	0.288078642066208	false	false	false	true
5ea45aab-233c-4cbc-a3c9-0086c113068d	2026-09-09 11:24	2026-09-09 11:24	2026-09-09 11:24	TH	TH261016P00017000	put	17.0000	2026-10-16	0.4500	0.4500	0.5500	19.0000	33756.00	0.00	33756.00	750	39	4077	164	24.859756097561	0.528137417253579	0.533090024370612	false	false	false	true
828a7956-5bc2-430c-8409-6a168d16247e	2026-09-09 11:17	2026-09-09 11:17	2026-09-09 11:17	UUUU	UUUU261016C00016000	call	16.0000	2026-10-16	0.7000	0.6900	0.7500	14.3350	61048.00	2130.00	45526.00	868	31	1044	2340	0.446153846153846	0.696718176812168	0.705732416375998	false	false	false	true
4f4d723e-289b-43e7-936a-8027133dcb3a	2026-09-09 11:15	2026-09-09 11:15	2026-09-09 11:15	TH	TH261016P00017000	put	17.0000	2026-10-16	0.4500	0.4000	0.5500	19.0900	39034.00	540.00	38494.00	867	53	3211	164	19.5792682926829	0.544124466561224	0.544124466561224	false	false	false	true
9662faec-157c-4cc4-945f-2e620978094e	2026-09-09 11:12	2026-09-09 11:11	2026-09-09 11:11	CCJ	CCJ260918P00098000	put	98.0000	2026-09-18	2.3600	2.2500	2.4800	99.4000	11818.00	4266.00	7552.00	50	5	50	110	0.454545454545455	0.493336497697552	0.493336497697552	false	false	false	true
3b501fb9-2f79-42d5-9dfa-84f75d2191bb	2026-09-09 11:11	2026-09-09 11:11	2026-09-09 11:11	CCJ	CCJ260918C00107000	call	107.0000	2026-09-18	0.8700	0.7600	1.0500	99.5400	41900.00	911.00	40109.00	481	43	485	526	0.922053231939164	0.510808082616293	0.52513921995246	true	false	false	true
6c9b22b6-98c7-407f-86d9-d7df41b91d71	2026-09-09 10:48	2026-09-09 10:48	2026-09-09 10:48	CVX	CVX260918P00210000	put	210.0000	2026-09-18	2.2300	2.1500	2.3800	213.0100	72256.00	226.00	72030.00	324	40	344	1160	0.296551724137931	0.271932816094385	0.274913134889896	true	false	false	true