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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×er_time = premarket×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

05959505-038b-4818-9fec-5a86a5228561	2026-10-01 15:39	2026-10-01 15:39	2026-10-01 15:39	VLO	VLO261016P00365000	put	365.0000	2026-10-16	2.9500	2.8000	2.9500	405.9950	10030.00	10030.00	0.00	34	5	708	488	1.45081967213115	0.505356662666508	0.505356662666508	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	117606850720.00	2026-10-22	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T19:42:36.719976Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
7d148a52-1b7f-40d8-87f5-17a54e7ca65e	2026-10-01 15:38	2026-10-01 15:38	2026-10-01 15:38	HAL	HAL261218C00033000	call	33.0000	2026-12-18	1.7700	1.6900	1.7700	31.9000	141600.00	141600.00	0.00	800	5	851	1912	0.445083682008368	0.361106310399263	0.361106310399263	false	false	false
b47bd81f-607b-477b-931a-4aa16ce65638	2026-10-01 15:33	2026-10-01 15:33	2026-10-01 15:33	VLO	VLO261009P00390000	put	390.0000	2026-10-09	5.2000	5.2000	5.5000	406.6750	69680.00	0.00	2600.00	134	61	163	49	3.3265306122449	0.502378055516376	0.502378055516376	false	false	false
7c2f826f-f773-4568-9a9d-f0f6268b9f7d	2026-10-01 15:18	2026-10-01 15:18	2026-10-01 15:18	MPC	MPC261016P00420000	put	420.0000	2026-10-16	17.1000	16.5000	17.2000	418.0000	20520.00	20520.00	0.00	12	6	167	374	0.446524064171123	0.487814525743865	0.487814525743865	false	false	false
fa422a95-404d-47d1-a139-831a72df4976	2026-10-01 15:17	2026-10-01 15:17	2026-10-01 15:17	MPC	MPC261016P00420000	put	420.0000	2026-10-16	16.9000	16.5000	17.0000	418.0000	23660.00	20280.00	3380.00	14	7	107	374	0.286096256684492	0.482771281454351	0.482771281454351	false	false	false
7b5a04af-9b40-43f1-9759-b5a5d8326e32	2026-10-01 15:17	2026-10-01 15:17	2026-10-01 15:17	MPC	MPC261016P00420000	put	420.0000	2026-10-16	16.9000	16.5000	17.0000	418.0000	16900.00	13520.00	3380.00	10	5	93	374	0.248663101604278	0.482771281454351	0.482771281454351	false	false	false
880e2646-1063-424d-aa1e-2e74d1f473f1	2026-10-01 15:07	2026-10-01 15:07	2026-10-01 15:07	MPC	MPC261016P00420000	put	420.0000	2026-10-16	16.9000	16.7000	17.2000	418.0000	20280.00	0.00	20280.00	12	6	75	374	0.200534759358289	0.479786082589499	0.479786082589499	false	false	false
89227d9d-72d0-412d-b1ad-a46b77a61d46	2026-10-01 15:07	2026-10-01 15:07	2026-10-01 15:07	MPC	MPC261016P00420000	put	420.0000	2026-10-16	16.9000	16.6000	17.3000	418.0000	37180.00	3380.00	30420.00	22	11	43	374	0.114973262032086	0.479786082589499	0.479786082589499	false	false	false
ce7c8a73-6d46-4107-901d-557180fd68cc	2026-10-01 14:47	2026-10-01 14:47	2026-10-01 14:47	MPC	MPC261016C00410000	call	410.0000	2026-10-16	20.7000	20.7000	20.9000	417.3000	165600.00	0.00	2070.00	80	39	192	872	0.220183486238532	0.490967732306975	0.490967732306975	false	false	false
05965ea1-75c7-4d8e-a30e-84192e5c5f3c	2026-10-01 14:46	2026-10-01 14:46	2026-10-01 14:46	DINO	DINO261016C00110000	call	110.0000	2026-10-16	6.6000	6.4000	6.6000	112.4400	153780.00	153780.00	0.00	233	35	633	1073	0.589934762348555	0.577166616152291	0.577166616152291	true	false	false
f9680cfb-328b-4bbc-89f8-0c3342df015d	2026-10-01 14:45	2026-10-01 14:45	2026-10-01 14:45	MPC	MPC261016C00410000	call	410.0000	2026-10-16	20.5000	20.5000	20.9000	417.1500	127100.00	0.00	8200.00	62	31	111	872	0.127293577981651	0.487591147845759	0.487591147845759	true	false	false
8ab2e9f4-9cdc-42b6-b530-f96a34a12725	2026-10-01 14:35	2026-10-01 14:34	2026-10-01 14:34	VLO	VLO261218C00420000	call	420.0000	2026-12-18	32.2100	32.2000	33.2000	405.0000	48320.00	3240.00	45080.00	15	6	43	277	0.155234657039711	0.491710732127004	0.491710732127004	false	false	false
77ab3575-0d3e-40dd-993f-261c7a9ad8fe	2026-10-01 14:35	2026-10-01 14:34	2026-10-01 14:34	VLO	VLO261218C00430000	call	430.0000	2026-12-18	28.5100	28.4000	29.3000	405.0000	22810.00	11410.00	11400.00	8	6	51	118	0.432203389830508	0.494030981288618	0.494030981288618	true	false	false
4c175377-8efe-457c-8df8-c59cb282907c	2026-10-01 14:28	2026-10-01 14:28	2026-10-01 14:28	VLO	VLO261016C00400000	call	400.0000	2026-10-16	19.4000	19.4000	20.5000	406.4350	67900.00	0.00	67900.00	35	10	461	606	0.760726072607261	0.478858846501264	0.478858846501264	false	false	false
ffb5ffea-0c4f-44e4-86f7-77b1ae1a50e3	2026-10-01 14:24	2026-10-01 14:23	2026-10-01 14:23	PBF	PBF270115C00100000	call	100.0000	2027-01-15	6.5000	6.4000	6.8000	81.1800	44850.00	9100.00	34450.00	69	15	125	246	0.508130081300813	0.704898326931703	0.704898326931703	false	false	false
ff5b29f8-7e62-4990-bf4e-7eb40e7f8f5b	2026-10-01 14:23	2026-10-01 14:23	2026-10-01 14:23	PBF	PBF270115C00100000	call	100.0000	2027-01-15	6.5000	6.4000	6.8000	81.1800	28600.00	650.00	27950.00	44	16	56	246	0.227642276422764	0.704898326931703	0.704898326931703	false	false	false
7a25566e-3a5b-44f8-8a5b-5cbdee48ccd7	2026-10-01 14:11	2026-10-01 14:11	2026-10-01 14:11	VLO	VLO261218C00390000	call	390.0000	2026-12-18	45.9000	45.6000	45.9000	405.0200	96390.00	96390.00	0.00	21	21	283	4343	0.065162330186507	0.492893531622354	0.492893531622354	false	false	false
d4e9e64d-8a82-4e82-be4d-962ab1f84a29	2026-10-01 14:11	2026-10-01 14:11	2026-10-01 14:11	VLO	VLO261218C00390000	call	390.0000	2026-12-18	46.0000	45.6000	46.0000	405.0200	46000.00	46000.00	0.00	10	5	256	4343	0.0589454294266636	0.494302220582601	0.494302220582601	false	false	false
c2d2798c-ab9e-467e-90ba-21c9cc3601e0	2026-10-01 14:11	2026-10-01 14:10	2026-10-01 14:10	VLO	VLO261218C00390000	call	390.0000	2026-12-18	46.1000	45.6000	46.1000	405.0400	64540.00	64540.00	0.00	14	7	242	4343	0.0557218512548929	0.495534711996689	0.495534711996689	false	false	false
afbe280f-a9ba-4e43-a571-3e7f05482ead	2026-10-01 14:10	2026-10-01 14:10	2026-10-01 14:10	VLO	VLO261218C00390000	call	390.0000	2026-12-18	46.1000	45.9000	46.1000	405.0450	92200.00	92200.00	0.00	20	10	223	4343	0.0513469951646327	0.495490686602797	0.495490686602797	false	false	false
755aef83-1c5e-47a8-8294-eb412b1ed1ae	2026-10-01 14:10	2026-10-01 14:10	2026-10-01 14:10	VLO	VLO261218C00390000	call	390.0000	2026-12-18	46.2000	45.9000	46.2000	404.7500	41580.00	41580.00	0.00	9	6	198	4343	0.0455906055721851	0.499492743338643	0.499492743338643	false	false	false
5ac09bd3-4581-4885-973e-76f110d7920a	2026-10-01 14:10	2026-10-01 14:09	2026-10-01 14:09	VLO	VLO261218C00390000	call	390.0000	2026-12-18	46.3000	45.9000	46.3000	404.7500	50930.00	50930.00	0.00	11	7	181	4343	0.0416762606493207	0.500900557782561	0.500900557782561	false	false	false
ea7db8c7-c1a7-4ef9-aaa7-222a4102205c	2026-10-01 14:09	2026-10-01 14:09	2026-10-01 14:09	VLO	VLO261218C00390000	call	390.0000	2026-12-18	46.3000	45.9000	46.3000	404.7500	78710.00	78710.00	0.00	17	10	170	4343	0.0391434492286438	0.500900557782561	0.500900557782561	false	false	false
f7a73a05-90d9-4845-88e0-9c12d94c4383	2026-10-01 14:09	2026-10-01 14:09	2026-10-01 14:09	VLO	VLO261218C00390000	call	390.0000	2026-12-18	46.4000	45.9000	46.4000	404.5600	55680.00	55680.00	0.00	12	8	147	4343	0.033847570803592	0.503974421071579	0.503974421071579	false	false	false
77b3b4a7-2108-4390-bc3d-f729995076d3	2026-10-01 14:09	2026-10-01 14:08	2026-10-01 14:08	VLO	VLO261218C00390000	call	390.0000	2026-12-18	46.7000	45.0000	46.7000	405.3250	210150.00	210150.00	0.00	45	15	99	4343	0.0227953027860926	0.501474950442925	0.501474950442925	false	false	false
a12501a6-ed6d-4a2d-b877-57e57383bd65	2026-10-01 14:08	2026-10-01 14:08	2026-10-01 14:08	VLO	VLO261218C00390000	call	390.0000	2026-12-18	46.8000	45.0000	46.8000	405.3250	196560.00	196560.00	0.00	42	6	54	4343	0.0124338015196869	0.502883355881682	0.502883355881682	false	false	false
fe6c1c87-5585-4a93-bfd7-ebaa9a391169	2026-10-01 14:05	2026-10-01 14:05	2026-10-01 14:05	TRMD	TRMD261016C00040000	call	40.0000	2026-10-16	0.8500	0.8500	0.9000	38.7100	34000.00	0.00	34000.00	400	8	414	3393	0.122015915119363	0.43294270748062	0.43294270748062	false	false	false
99547732-1ba3-4b14-ba16-bf2fc5b24ff9	2026-10-01 14:04	2026-10-01 14:04	2026-10-01 14:04	VLO	VLO270319P00280000	put	280.0000	2027-03-19	7.9000	7.4000	8.8000	404.9700	53731.00	22890.00	30841.00	68	15	79	42	1.88095238095238	0.51755938911055	0.515488488038756	false	false	false
28bb6c0b-7c15-4292-86c9-06e8c145927a	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	VLO	VLO261023P00400000	put	400.0000	2026-10-23	18.9000	17.9000	18.9000	402.2200	24570.00	24570.00	0.00	13	5	30	14	2.14285714285714	0.521643169201239	0.521643169201239	false	false	false
73e000ed-4bf5-418c-97e4-344d9dcc19d0	2026-10-01 13:27	2026-10-01 13:27	2026-10-01 13:27	BP	BP261120P00046000	put	46.0000	2026-11-20	3.4400	3.4000	3.5500	44.0800	39216.00	0.00	39216.00	114	5	170	252	0.674603174603175	0.381061129525698	0.381061129525698	false	false	false	true
92f42e20-b4d7-4768-84ff-c7caecc8ddf8	2026-10-01 13:07	2026-10-01 13:07	2026-10-01 13:07	SLB	SLB270319P00055000	put	55.0000	2027-03-19	8.6500	8.3000	8.6500	48.0000	10380.00	10380.00	0.00	12	10	33	779	0.0423620025673941	0.39304151595618	0.39304151595618	false	false	false
1b5ca537-0e41-45a8-8e2e-a16cc160c470	2026-10-01 12:40	2026-10-01 12:40	2026-10-01 12:40	HAL	HAL270115P00030000	put	30.0000	2027-01-15	1.5000	1.4500	1.5000	31.9350	37500.00	37500.00	0.00	250	59	259	2729	0.0949065591791865	0.376549828459559	0.376290488788827	false	false	false
d0520dea-5376-4817-b6fe-89903eeb955f	2026-10-01 11:57	2026-10-01 11:57	2026-10-01 11:57	COP	COP261016C00129000	call	129.0000	2026-10-16	2.3300	2.3300	2.4000	127.0100	58949.00	0.00	58949.00	253	27	290	109	2.6605504587156	0.303504540606566	0.303504540606566	false	false	false
110a8208-d8da-444e-8903-52698085c5fa	2026-10-01 11:55	2026-10-01 11:55	2026-10-01 11:55	VLO	VLO261002P00400000	put	400.0000	2026-10-02	3.1000	3.1000	3.5000	404.9400	35960.00	0.00	35960.00	116	30	154	348	0.442528735632184	0.620910879737287	0.620910879737287	false	false	false
3dc04d0a-1f2f-42d4-b259-93c7a14741c1	2026-10-01 11:18	2026-10-01 11:18	2026-10-01 11:18	COP	COP261218P00120000	put	120.0000	2026-12-18	4.2500	4.1500	4.3000	127.0301	64600.00	40375.00	0.00	152	20	168	3600	0.0466666666666667	0.336715473210114	0.336715473210114	false	false	false
0c25861e-93e8-4bd5-8c31-b86fe6d15f9c	2026-10-01 11:18	2026-10-01 11:18	2026-10-01 11:18	COP	COP261218P00115000	put	115.0000	2026-12-18	2.7400	2.6500	2.7600	127.0301	11234.00	11234.00	0.00	41	6	169	1110	0.152252252252252	0.339834788820845	0.339834788820845	false	false	false
6c8324f5-add3-447a-8f24-a2fcb4beb194	2026-10-01 11:18	2026-10-01 11:18	2026-10-01 11:18	VLO	VLO270115P00400000	put	400.0000	2027-01-15	40.4000	39.2000	40.4000	402.5200	238360.00	238360.00	0.00	59	12	61	593	0.102866779089376	0.515292995013135	0.515292995013135	false	false	false
f9312c98-1b05-4155-8cf7-7e547c1da8a3	2026-10-01 11:13	2026-10-01 11:13	2026-10-01 11:13	VLO	VLO261009P00400000	put	400.0000	2026-10-09	10.7000	10.7000	11.0000	403.0450	33170.00	0.00	14980.00	31	6	908	18	50.4444444444444	0.520044340241838	0.520044340241838	false	false	false
03f3ae9d-100c-484d-9109-673b344b181a	2026-10-01 11:12	2026-10-01 11:12	2026-10-01 11:12	VLO	VLO261009C00415000	call	415.0000	2026-10-09	7.4600	6.1000	7.6000	403.5300	10440.00	6690.00	0.00	14	5	21	54	0.388888888888889	0.507595388899703	0.507595388899703	true	false	false
9f6318d4-49c7-4d45-879d-e94bada26ba1	2026-10-01 11:12	2026-10-01 11:11	2026-10-01 11:11	VLO	VLO261009P00400000	put	400.0000	2026-10-09	10.5000	10.5000	10.8000	403.2850	28350.00	0.00	28350.00	27	5	789	18	43.8333333333333	0.516026891255292	0.516026891255292	false	false	false
b678d2bf-7899-4a92-886a-c5fbc1e93417	2026-10-01 11:09	2026-10-01 11:09	2026-10-01 11:09	VLO	VLO261009P00400000	put	400.0000	2026-10-09	10.5000	10.5000	10.8000	402.0000	16800.00	0.00	16800.00	16	5	698	18	38.7777777777778	0.509768844070799	0.510143923357287	false	false	false
385cb1f8-0c34-410f-91d7-686bba2df491	2026-10-01 11:09	2026-10-01 11:09	2026-10-01 11:09	VLO	VLO261009P00400000	put	400.0000	2026-10-09	10.5000	10.0000	10.8000	402.0000	18900.00	4200.00	14700.00	18	5	719	18	39.9444444444444	0.510143923357287	0.510143923357287	false	false	false
e4ad9ddc-9f93-4952-a100-5198e4eb35d5	2026-10-01 11:08	2026-10-01 11:08	2026-10-01 11:08	VLO	VLO261009P00400000	put	400.0000	2026-10-09	10.5000	10.5000	10.8000	402.0000	70350.00	0.00	70350.00	67	8	620	18	34.4444444444444	0.509956407214291	0.509956407214291	false	false	false
71f11169-060a-4d7c-97a9-96c94324d174	2026-10-01 11:07	2026-10-01 11:07	2026-10-01 11:07	COP	COP261218P00115000	put	115.0000	2026-12-18	2.7700	2.6800	2.7700	126.6525	26592.00	26592.00	0.00	96	12	121	1110	0.109009009009009	0.336737421714139	0.336737421714139	false	false	false
c1c7d48d-f2f3-4a67-9acb-e60499c16f65	2026-10-01 10:51	2026-10-01 10:51	2026-10-01 10:51	VLO	VLO270617P00330000	put	330.0000	2027-06-17	27.8500	27.3000	29.5000	402.7775	696250.00	0.00	696250.00	250	2	250	448	0.558035714285714	0.505729355136741	0.505729355136741	false	true	false
2548b42a-b4c3-4b82-abea-70981307351c	2026-10-01 10:49	2026-10-01 10:49	2026-10-01 10:49	COP	COP261218P00125000	put	125.0000	2026-12-18	6.5000	6.4750	6.6500	126.6500	11700.00	0.00	11700.00	18	8	24	639	0.0375586854460094	0.338233121104192	0.338233121104192	true	false	false
05242190-967d-4e56-98f0-40a3011f17e9	2026-10-01 10:49	2026-10-01 10:49	2026-10-01 10:49	COP	COP261016P00123000	put	123.0000	2026-10-16	1.5500	1.5500	1.6300	126.6500	17360.00	0.00	17360.00	112	38	112	87	1.28735632183908	0.30774481720989	0.30774481720989	false	false	false
aec96f1e-8b50-48dc-acf5-638e23e03e94	2026-10-01 10:37	2026-10-01 10:37	2026-10-01 10:37	HAL	HAL261016P00033000	put	33.0000	2026-10-16	1.6000	1.5000	1.7400	31.8100	24000.00	0.00	24000.00	150	5	150	5506	0.0272430076280421	0.352706427186628	0.352706427186628	false	false	false
20859e7b-9be4-4f4c-bff5-1c962848c59a	2026-10-01 10:29	2026-10-01 10:29	2026-10-01 10:29	MPC	MPC270617C00380000	call	380.0000	2027-06-17	85.0000	82.6000	85.0000	411.6250	119000.00	119000.00	0.00	14	8	14	108	0.12962962962963	0.466709395200011	0.466709395200011	false	false	false
f2f48daa-8125-4ae4-bb43-f60cf6def45d	2026-10-01 10:23	2026-10-01 10:23	2026-10-01 10:23	PBF	PBF261016P00075000	put	75.0000	2026-10-16	2.5000	2.4000	2.7000	80.3699	10500.00	2500.00	8000.00	42	5	71	3735	0.0190093708165997	0.757709809294528	0.757709809294528	false	false	false