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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

293c839b-a4b4-49b4-a921-2bde4f019f1a	2026-09-23 13:44	2026-09-23 13:44	2026-09-23 13:44	DK	DK261016C00075000	call	75.0000	2026-10-16	3.6000	3.6000	3.7000	71.0000	21960.00	0.00	21960.00	61	20	113	1625	0.0695384615384615	0.690260195885876	0.690260195885876	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	4424636893.00	2026-11-06	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T17:45:14.864344Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
6e83c412-c422-4a5f-87b5-f80d8576f096	2026-09-23 13:44	2026-09-23 13:44	2026-09-23 13:44	DK	DK261016C00075000	call	75.0000	2026-10-16	3.5000	3.5000	3.8000	71.0000	10850.00	0.00	10850.00	31	10	33	1625	0.0203076923076923	0.677321613191933	0.677321613191933	false	false	false	true
fe57006a-3489-412b-a2c5-aa1bcd721a4b	2026-09-23 13:43	2026-09-23 13:43	2026-09-23 13:43	VLO	VLO261016C00420000	call	420.0000	2026-10-16	5.6900	4.5000	5.8000	373.0000	21640.00	1710.00	19930.00	38	12	119	418	0.284688995215311	0.535670143037709	0.53198600246493	true	false	false	true
f4a7fbf8-dcf0-4ef8-8eb3-aa49ac06af30	2026-09-23 13:42	2026-09-23 13:42	2026-09-23 13:42	CLMT	CLMT261120P00045000	put	45.0000	2026-11-20	2.2500	2.1000	2.3500	52.0000	13725.00	9900.00	3825.00	61	22	99	200	0.495	0.686291694590228	0.681947819390073	false	false	false	true
ad512ed5-a12c-4d91-ada0-5c6d74358d5b	2026-09-23 13:40	2026-09-23 13:40	2026-09-23 13:40	VLO	VLO260925C00330000	call	330.0000	2026-09-25	40.8000	37.5000	40.8000	368.0000	110159.00	110159.00	0.00	27	5	28	35	0.8	1.29371830826965	1.2918112231306	true	false	false	true
10aa532d-d4e1-4e79-82e1-81064cd7ebe6	2026-09-23 13:40	2026-09-23 13:40	2026-09-23 13:40	DINO	DINO261016C00105000	call	105.0000	2026-10-16	6.3000	5.8000	6.3000	104.0000	41578.00	41578.00	0.00	66	20	88	280	0.314285714285714	0.599310416780466	0.599310416780466	true	false	false	true
3b1bc322-fa83-464e-b538-7e435e30d7ca	2026-09-23 13:38	2026-09-23 13:38	2026-09-23 13:38	DHT	DHT261218P00020000	put	20.0000	2026-12-18	1.6000	1.5000	1.7000	21.3450	53760.00	160.00	52000.00	336	23	436	650	0.670769230769231	0.576406495628872	0.576406495628872	false	false	false	true
2351554b-a6c7-4de5-8d38-fc6e66f6533f	2026-09-23 13:38	2026-09-23 13:38	2026-09-23 13:38	EQT	EQT261120C00052500	call	52.5000	2026-11-20	2.3700	2.3700	2.4300	51.5000	19671.00	0.00	19671.00	83	19	348	731	0.476060191518468	0.326532952952962	0.32623560497825	false	false	false	true
21684882-de89-4dd1-8fb0-a72703759e09	2026-09-23 13:38	2026-09-23 13:37	2026-09-23 13:37	DHT	DHT261218P00020000	put	20.0000	2026-12-18	1.6000	1.4500	1.7000	21.3450	16000.00	1600.00	7040.00	100	50	100	650	0.153846153846154	0.576406495628872	0.576406495628872	false	false	false	true
7bfdc2ae-3adc-4b93-9f17-fad89cf46c82	2026-09-23 13:36	2026-09-23 13:36	2026-09-23 13:36	UUUU	UUUU261016C00011500	call	11.5000	2026-10-16	0.8100	0.8000	0.8400	11.6050	12069.00	0.00	12069.00	149	15	311	1	311	0.642178186399174	0.642178186399174	false	false	false	true
0035e351-13ef-487d-82fd-ed1b6715d72b	2026-09-23 13:34	2026-09-23 13:34	2026-09-23 13:34	PSX	PSX261120P00260000	put	260.0000	2026-11-20	21.5000	21.5000	23.1000	253.5550	40850.00	0.00	40850.00	19	8	25	207	0.120772946859903	0.468120325127588	0.468120325127588	false	false	false	true
aff7121f-dc38-4fd9-90cd-010102b63ef4	2026-09-23 13:33	2026-09-23 13:33	2026-09-23 13:33	OXY	OXY261120P00055000	put	55.0000	2026-11-20	1.8900	1.8900	1.9300	57.5550	11345.00	0.00	11345.00	60	7	66	3466	0.0190421234852856	0.351518325126622	0.352721907592676	false	false	false	true
87838139-6a86-48d8-9776-e3d8978996c3	2026-09-23 13:33	2026-09-23 13:33	2026-09-23 13:33	VLO	VLO261016P00350000	put	350.0000	2026-10-16	11.1000	9.9000	11.1000	368.2200	51060.00	51060.00	0.00	46	15	358	1466	0.244201909959072	0.533721695345137	0.533721695345137	false	false	false	true
1c53d671-536e-42e6-a45b-7b5e6bc8b8ae	2026-09-23 13:33	2026-09-23 13:33	2026-09-23 13:33	VLO	VLO261016P00330000	put	330.0000	2026-10-16	5.5000	4.7000	5.5000	368.2200	23100.00	23100.00	0.00	42	20	319	1453	0.219545767377839	0.54397614575536	0.54397614575536	false	false	false	true
7e8a40ec-9345-4438-8042-045166eb2480	2026-09-23 13:26	2026-09-23 13:26	2026-09-23 13:26	PSX	PSX270115P00240000	put	240.0000	2027-01-15	18.0500	17.9000	18.4000	252.0000	23465.00	14440.00	9025.00	13	5	19	98	0.193877551020408	0.458749376348848	0.458749376348848	false	false	false	true
73a757e5-463e-4f18-9529-76457ffb4ac4	2026-09-23 13:19	2026-09-23 13:19	2026-09-23 13:19	CLMT	CLMT261016C00050000	call	50.0000	2026-10-16	4.8000	4.8000	5.1000	52.0000	17280.00	0.00	17280.00	36	7	76	162	0.469135802469136	0.581492687626985	0.581492687626985	false	false	false	true
eb562fa3-bd98-42c9-b0cd-afae89395217	2026-09-23 13:18	2026-09-23 13:18	2026-09-23 13:18	CVX	CVX261016C00205000	call	205.0000	2026-10-16	6.0000	6.0000	6.2000	205.0000	28200.00	0.00	28200.00	47	8	200	324	0.617283950617284	0.270113573860044	0.270113573860044	true	false	false	true
8533e985-0f8b-40b7-be99-48b80fb23a1e	2026-09-23 13:15	2026-09-23 13:15	2026-09-23 13:15	VLO	VLO260925P00370000	put	370.0000	2026-09-25	7.5000	6.4000	7.9000	369.0000	45750.00	45750.00	0.00	61	6	655	1346	0.486627043090639	0.678162579519597	0.678162579519597	false	false	false	true
5b8f2473-6074-4524-99c7-33119b0346fa	2026-09-23 13:15	2026-09-23 13:15	2026-09-23 13:15	VLO	VLO261016C00420000	call	420.0000	2026-10-16	4.9000	4.9000	5.5000	369.0000	12250.00	0.00	12250.00	25	10	75	418	0.179425837320574	0.533923066757064	0.533923066757064	false	false	false	true
cb214a50-158a-4eb8-8394-5a5098512ff2	2026-09-23 13:13	2026-09-23 13:13	2026-09-23 13:13	VLO	VLO270115P00330000	put	330.0000	2027-01-15	20.9000	20.2000	21.6000	369.0000	39710.00	6270.00	33440.00	19	5	37	566	0.0653710247349823	0.505193576694907	0.505193576694907	false	false	false	true
3ca05ab9-0dc9-46a7-8c1e-c162fb637778	2026-09-23 13:12	2026-09-23 13:12	2026-09-23 13:12	VLO	VLO261218P00340000	put	340.0000	2026-12-18	21.1000	20.5000	21.8000	369.0000	42200.00	6330.00	35870.00	20	6	55	699	0.0786838340486409	0.516060807010738	0.516060807010738	false	false	false	true
3cf824c9-de73-416a-8baf-a4fe87578f20	2026-09-23 13:11	2026-09-23 13:11	2026-09-23 13:11	PSX	PSX261002C00252500	call	252.5000	2026-10-02	7.7000	6.5000	8.2000	252.5550	84700.00	61600.00	23100.00	110	8	141	1	141	0.477477895590926	0.477477895590926	true	false	false	true
e4f9fd17-1fca-498e-a1e8-d439d0294194	2026-09-23 13:08	2026-09-23 13:08	2026-09-23 13:08	CVX	CVX261002C00205000	call	205.0000	2026-10-02	4.0500	4.0000	4.4500	205.5600	92340.00	405.00	91935.00	228	17	378	439	0.861047835990888	0.283490319439402	0.28454952560713	false	false	false	true
28295b20-3de5-4efa-a5fb-4df4b5bd9d62	2026-09-23 13:08	2026-09-23 13:08	2026-09-23 13:08	CVX	CVX261002P00205000	put	205.0000	2026-10-02	3.3000	3.3000	3.5500	205.5450	15180.00	0.00	15180.00	46	18	298	334	0.892215568862275	0.284838521728803	0.284838521728803	true	false	false	true
17e35cf7-f763-4617-9b0c-fa00d20a2dc3	2026-09-23 13:03	2026-09-23 13:03	2026-09-23 13:03	VLO	VLO260925P00370000	put	370.0000	2026-09-25	7.6000	6.5000	7.6000	369.9300	18240.00	18240.00	0.00	24	5	525	1346	0.390044576523031	0.69625585360092	0.69625585360092	true	false	false	true
d8859cd9-2a6a-4956-8f67-af40761dbfce	2026-09-23 13:01	2026-09-23 13:00	2026-09-23 13:00	VLO	VLO261023C00400000	call	400.0000	2026-10-23	11.5000	11.5000	11.7000	366.0607	72450.00	0.00	72450.00	63	5	199	33	6.03030303030303	0.559503855245514	0.559503855245514	false	false	false	true
563ea784-8eda-4e9a-89bc-c03fb015d471	2026-09-23 13:00	2026-09-23 13:00	2026-09-23 13:00	VLO	VLO261023C00400000	call	400.0000	2026-10-23	11.6000	11.0000	11.7000	366.0700	68440.00	1160.00	67280.00	59	8	136	33	4.12121212121212	0.562067508324442	0.562067508324442	false	false	false	true
11dd7148-10ca-4265-8598-7241be869a43	2026-09-23 13:00	2026-09-23 13:00	2026-09-23 13:00	VLO	VLO281215C00330000	call	330.0000	2028-12-15	123.0000	121.0000	125.3000	369.3300	1685090.00	651900.00	664190.00	137	8	339	864	0.392361111111111	0.420015229080398	0.420816125409111	true	false	false	true
52eb2ba1-3524-4e5e-9525-959298b283c0	2026-09-23 12:58	2026-09-23 12:58	2026-09-23 12:58	PBR	PBR270115C00024000	call	24.0000	2027-01-15	0.9900	0.9200	1.0100	21.0200	67122.00	67023.00	99.00	678	46	678	511	1.32681017612524	0.413269438791599	0.413269438791599	false	false	false	true
430f7a38-6241-4df1-8151-989df9701aa7	2026-09-23 12:58	2026-09-23 12:58	2026-09-23 12:58	VLO	VLO260925P00355000	put	355.0000	2026-09-25	3.7000	3.2000	3.7000	367.4650	17760.00	7030.00	0.00	48	6	312	675	0.462222222222222	0.801489059201958	0.801489059201958	true	false	false	true
97d72cc0-5ef6-449f-b68e-2099ed0d8f0e	2026-09-23 12:58	2026-09-23 12:58	2026-09-23 12:58	VLO	VLO260925P00355000	put	355.0000	2026-09-25	3.8000	3.2000	3.8000	367.3200	11020.00	2660.00	0.00	29	5	230	675	0.340740740740741	0.808223648785425	0.808223648785425	true	false	false	true
45012f42-a11a-4a2d-b375-241b3853ba53	2026-09-23 12:58	2026-09-23 12:58	2026-09-23 12:58	VLO	VLO260925P00355000	put	355.0000	2026-09-25	3.6000	3.6000	3.8000	367.3200	12240.00	0.00	12240.00	34	6	264	675	0.391111111111111	0.785996475406294	0.785996475406294	true	false	false	true
0b654a6e-3553-4e54-a230-789d63c4c0f7	2026-09-23 12:58	2026-09-23 12:58	2026-09-23 12:58	VLO	VLO260925P00355000	put	355.0000	2026-09-25	3.6000	3.0000	4.4000	367.3200	17640.00	11520.00	3960.00	49	11	175	675	0.259259259259259	0.785996475406294	0.785996475406294	true	false	false	true
c96b2f5f-e4c7-4a67-afc3-ed8766d84b38	2026-09-23 12:57	2026-09-23 12:57	2026-09-23 12:57	CLMT	CLMT270319C00060000	call	60.0000	2027-03-19	7.7000	7.7000	8.0000	52.8100	23870.00	0.00	23870.00	31	7	83	1245	0.0666666666666667	0.678597178196658	0.678597178196658	false	false	false	true
8ebf8650-6866-480d-8374-648b2d4d05f7	2026-09-23 12:57	2026-09-23 12:57	2026-09-23 12:57	VLO	VLO260925P00355000	put	355.0000	2026-09-25	3.4000	3.4000	4.6000	368.1700	19040.00	0.00	19040.00	56	7	96	675	0.142222222222222	0.788531158575965	0.788531158575965	false	false	false	true
feceac18-b019-4702-be4d-3c39199a6871	2026-09-23 12:56	2026-09-23 12:56	2026-09-23 12:56	COP	COP270319C00140000	call	140.0000	2027-03-19	7.3000	7.1500	7.3000	127.8900	10950.00	10950.00	0.00	15	7	41	514	0.0797665369649805	0.308435040175622	0.308435040175622	false	false	false	true
968605ce-17fe-4f81-991f-22c98e094b2c	2026-09-23 12:56	2026-09-23 12:56	2026-09-23 12:56	VLO	VLO261120P00370000	put	370.0000	2026-11-20	32.5000	32.5000	32.8000	365.5200	91000.00	0.00	91000.00	28	5	63	41	1.53658536585366	0.54050752428113	0.54050752428113	true	false	false	true
7137d30c-181d-49c8-a18a-09aee1029644	2026-09-23 12:54	2026-09-23 12:54	2026-09-23 12:54	VLO	VLO261016P00380000	put	380.0000	2026-10-16	25.2000	24.1000	25.2000	369.3450	15120.00	12600.00	0.00	6	6	212	582	0.36426116838488	0.533414755869481	0.533414755869481	false	false	false	true
8e9719b3-b51c-4089-93f8-bb087507e737	2026-09-23 12:53	2026-09-23 12:53	2026-09-23 12:53	VLO	VLO261016P00380000	put	380.0000	2026-10-16	25.0000	23.0000	26.2000	370.0000	22500.00	20000.00	2500.00	9	9	203	582	0.348797250859107	0.554779079197029	0.537728199555106	false	false	false	true
5f25c9e4-d4c0-4fc4-9a60-f056104f002f	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	SHEL	SHEL260925C00096000	call	96.0000	2026-09-25	0.3500	0.2000	0.5000	94.3600	14000.00	7000.00	7000.00	400	10	428	103	4.15533980582524	0.337164794488226	0.337164794488226	false	false	false	true
a7a105c7-4661-4425-9b46-512387ef92df	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	VLO	VLO261016P00380000	put	380.0000	2026-10-16	28.0000	25.5000	28.4000	365.9600	145600.00	145600.00	0.00	52	5	188	582	0.323024054982818	0.557365380894366	0.558158789890914	false	false	false	true
e54be3ee-1142-4333-9a48-b76b939e9c0c	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	OXY	OXY261030P00060000	put	60.0000	2026-10-30	3.9000	3.7000	3.9000	57.3400	99060.00	99060.00	0.00	254	29	349	23	15.1739130434783	0.338021952152236	0.338021952152236	false	false	false	true
bfe921b5-9127-4206-9430-a2a92e54681c	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	CLMT	CLMT261016P00048000	put	48.0000	2026-10-16	1.2500	1.0500	1.2500	52.8750	22000.00	22000.00	0.00	176	29	176	5	35.2	0.622460746632314	0.622460746632314	false	false	false	true
f54fd19f-30bf-4ba0-9fdc-4aa2f54a9ec9	2026-09-23 12:50	2026-09-23 12:50	2026-09-23 12:50	XOM	XOM260925P00160000	put	160.0000	2026-09-25	1.5700	1.3700	1.6300	160.3100	18997.00	18997.00	0.00	121	5	1235	1395	0.885304659498208	0.367308218319726	0.367308218319726	false	false	false	true
ef36ba7f-69d8-4041-be31-3b345ab7c767	2026-09-23 12:50	2026-09-23 12:49	2026-09-23 12:49	EQNR	EQNR261120P00045000	put	45.0000	2026-11-20	4.1000	3.9000	4.1000	42.6350	278389.00	278389.00	0.00	679	9	695	59	11.7796610169492	0.425053597408478	0.425053597408478	false	false	false	true
756d3425-e5ff-4d65-9ae1-2a0c8630c2f0	2026-09-23 12:50	2026-09-23 12:49	2026-09-23 12:49	EQNR	EQNR261120P00046000	put	46.0000	2026-11-20	4.8000	4.6000	4.8000	42.6350	222240.00	222240.00	0.00	463	6	482	0	0	0.43095521390021	0.43095521390021	false	false	false	true
c11e52b7-f3b8-45bf-8895-8ab9f19591f2	2026-09-23 12:49	2026-09-23 12:49	2026-09-23 12:49	PBF	PBF261016P00060000	put	60.0000	2026-10-16	1.5500	1.4500	1.6000	69.3100	64480.00	9920.00	54560.00	416	14	473	1021	0.463271302644466	0.758992710686959	0.758992710686959	false	false	false	true
c5f6d5e1-848f-4e83-99d2-81381c821d20	2026-09-23 12:49	2026-09-23 12:49	2026-09-23 12:49	OKE	OKE261016P00090000	put	90.0000	2026-10-16	1.8000	1.7000	1.8000	91.5750	10980.00	10980.00	0.00	61	22	167	2245	0.0743875278396437	0.28655631742682	0.28655631742682	false	false	false	true
64301f96-bb50-4ab3-9fa7-e2d9a7bcfd88	2026-09-23 12:47	2026-09-23 12:47	2026-09-23 12:47	MPC	MPC261016P00390000	put	390.0000	2026-10-16	20.4900	20.2000	21.0000	388.3100	47120.00	41000.00	6120.00	23	12	99	1061	0.0933081998114986	0.517801347507712	0.517801347507712	false	false	false	true
50f23dcf-05b8-4070-a19c-e6ec979617e3	2026-09-23 12:47	2026-09-23 12:47	2026-09-23 12:47	APA	APA261016P00042500	put	42.5000	2026-10-16	1.2300	1.1600	1.2300	43.9200	14514.00	14514.00	0.00	118	5	176	1312	0.134146341463415	0.439000402783732	0.439000402783732	false	false	false	true