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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 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

dfd210f3-ad2b-4474-a972-3cee3b08f16b	2026-09-23 14:03	2026-09-23 14:02	2026-09-23 14:02	FRO	FRO261120P00045000	put	45.0000	2026-11-20	2.5500	2.4500	2.6000	47.3400	20399.00	19889.00	0.00	80	23	136	2	68	0.50906261478408	0.50906261478408	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	10587944601.00	2026-11-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T18:04:42.135923Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
8d74c5e1-b54d-4f9b-a0ac-6324ac637079	2026-09-23 14:02	2026-09-23 14:02	2026-09-23 14:02	XOM	XOM261218P00155000	put	155.0000	2026-12-18	6.2000	6.2000	6.2500	161.3200	16740.00	0.00	16740.00	27	6	315	2844	0.110759493670886	0.315736353387513	0.315736353387513	false	false	false	true
25e257cf-2d04-4eaf-9cc2-b170c01437f5	2026-09-23 14:02	2026-09-23 14:02	2026-09-23 14:02	CVX	CVX270115C00200000	call	200.0000	2027-01-15	16.0000	15.6500	16.0500	205.8938	19200.00	16000.00	3200.00	12	7	143	6554	0.0218187366493744	0.249795414985843	0.249795414985843	false	false	false	true
9ef36ea0-07fc-47dd-b976-1c62cf633f4d	2026-09-23 14:01	2026-09-23 14:01	2026-09-23 14:01	XOM	XOM261009C00165000	call	165.0000	2026-10-09	2.5200	2.4300	2.5400	161.2900	10085.00	10085.00	0.00	40	6	691	371	1.86253369272237	0.295462307816611	0.291566970326128	false	false	false	true
ef197903-1259-4a58-b710-073f7a452a31	2026-09-23 13:59	2026-09-23 13:59	2026-09-23 13:59	XOM	XOM261218P00155000	put	155.0000	2026-12-18	6.2500	6.2500	6.4000	161.2109	16250.00	0.00	16250.00	26	5	238	2844	0.0836849507735584	0.316165119170629	0.316165119170629	false	false	false	true
886b6da9-c365-4e77-b216-29cf643b107d	2026-09-23 13:54	2026-09-23 13:54	2026-09-23 13:54	XOM	XOM261023C00170000	call	170.0000	2026-10-23	2.2300	2.1000	2.2400	161.1600	113060.00	109270.00	3790.00	507	53	542	87	6.22988505747126	0.285230817178675	0.285230817178675	false	false	false	true
f0068488-e020-43a0-ba2e-6c96f19da0a4	2026-09-23 13:53	2026-09-23 13:53	2026-09-23 13:53	CVX	CVX261218P00200000	put	200.0000	2026-12-18	8.0500	7.9000	8.0500	205.8550	309120.00	309120.00	0.00	384	49	415	2900	0.143103448275862	0.295246416307165	0.295246416307165	false	false	false	true
31c1f23e-ebde-4c37-b249-d1e73fb5e623	2026-09-23 13:53	2026-09-23 13:53	2026-09-23 13:53	CVX	CVX261218P00195000	put	195.0000	2026-12-18	6.1500	6.0000	6.1500	205.8550	129765.00	129765.00	0.00	211	25	259	873	0.296678121420389	0.295789750907794	0.295789750907794	false	false	false	true
2323adb3-ea54-4854-b98c-87357e9c2d0b	2026-09-23 13:52	2026-09-23 13:52	2026-09-23 13:52	CLMT	CLMT270319C00050000	call	50.0000	2027-03-19	11.3000	11.0000	12.0000	52.4800	33900.00	0.00	19210.00	30	5	55	585	0.094017094017094	0.676713336131273	0.676713336131273	false	false	false	true
bca47052-e627-42b9-95eb-22801a636e15	2026-09-23 13:50	2026-09-23 13:50	2026-09-23 13:50	VLO	VLO260925P00375000	put	375.0000	2026-09-25	12.6000	10.6000	12.6000	367.0500	28980.00	28980.00	0.00	23	5	201	1093	0.183897529734675	0.736028332026071	0.736028332026071	false	false	false	true
09d2f12a-1c43-4462-b4a6-cb00dd96e139	2026-09-23 13:50	2026-09-23 13:50	2026-09-23 13:50	VLO	VLO260925P00375000	put	375.0000	2026-09-25	12.5000	10.0000	12.5000	367.0500	33750.00	33750.00	0.00	27	5	178	1093	0.162854528819762	0.726167670574571	0.726167670574571	false	false	false	true
960d5018-63d7-4cd6-9b9d-c49c832d46ae	2026-09-23 13:48	2026-09-23 13:48	2026-09-23 13:48	SHEL	SHEL270617P00097500	put	97.5000	2027-06-17	8.5000	8.5000	8.8000	95.0000	42500.00	0.00	42500.00	50	6	166	155	1.07096774193548	0.276641938910314	0.276641938910314	false	false	false	true
67b00618-7ed6-4527-9914-5d661d70e4f5	2026-09-23 13:47	2026-09-23 13:47	2026-09-23 13:47	PBF	PBF261218P00067500	put	67.5000	2026-12-18	8.4000	7.9000	8.4000	70.0000	70560.00	70560.00	0.00	84	18	85	61	1.39344262295082	0.753452866100439	0.753452866100439	false	false	false	true
38396193-f4bf-4646-bf8d-cd9c698d70a4	2026-09-23 13:45	2026-09-23 13:45	2026-09-23 13:45	XOM	XOM261218C00165000	call	165.0000	2026-12-18	7.7500	7.7500	7.9500	161.0000	10850.00	0.00	10850.00	14	14	169	6733	0.0251002524877469	0.278800410114062	0.278800410114062	true	false	false	true
6a6c7891-f753-431a-979d-69b3a91ca9e0	2026-09-23 13:45	2026-09-23 13:44	2026-09-23 13:44	DK	DK261016C00075000	call	75.0000	2026-10-16	3.7000	3.7000	3.8000	71.0000	32930.00	0.00	22200.00	89	24	202	1625	0.124307692307692	0.701935884756912	0.701935884756912	false	false	false	true
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
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