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: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	expirydate

d9b809f8-683e-4bf6-b1ab-2429efcfec88	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	DINO	DINO261218C00095000	call	95.0000	2026-12-18	16.7000	16.7000	19.1000	105.6300	502670.00	0.00	502670.00	301	10	301	447	0.67337807606264	0.511987159397715	0.511987159397715	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	18869977733.00	2026-10-28	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T16:47:02.093743Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
c32bef40-d047-457f-81ac-d6357502caf2	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	MPC	MPC261016C00340000	call	340.0000	2026-10-16	51.9000	51.9000	54.4000	388.8200	228360.00	0.00	228360.00	44	10	175	172	1.01744186046512	0.448734672280319	0.448734672280319	false	false	false	true
5737cbe1-46ce-4603-907a-849e8e2a295a	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	VLO	VLO270319C00410000	call	410.0000	2027-03-19	41.3000	41.3000	44.6000	376.1500	1061410.00	0.00	1061410.00	257	24	266	215	1.23720930232558	0.485885685846576	0.493764013298648	true	false	false	true
526281f6-7f75-47d7-8d00-fd4070df02c4	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	VLO	VLO261016P00415000	put	415.0000	2026-10-16	44.9500	42.0000	45.0000	377.8200	139340.00	116940.00	22400.00	31	7	31	0	0	0.567153463423592	0.564039925979162	true	false	false	true
f692b4aa-e6ad-42b1-bae9-2efdbefbadba	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	PSX	PSX261120C00220000	call	220.0000	2026-11-20	41.7000	40.9000	41.8000	255.8700	154290.00	154290.00	0.00	37	10	38	449	0.0846325167037862	0.428160705941791	0.449315929206658	true	false	false	true
7469747a-0843-4822-aaf5-a49a7ec458de	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	MPC	MPC261016P00430000	put	430.0000	2026-10-16	46.5000	43.8000	47.2000	389.2400	55800.00	46500.00	4660.00	12	7	17	254	0.0669291338582677	0.511942521055483	0.515194367691546	true	false	false	true
d6629307-5a1c-4492-b9f2-6db46ae913df	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	PSX	PSX261016P00270000	put	270.0000	2026-10-16	18.9800	18.8000	19.3000	257.0600	58850.00	3820.00	55030.00	31	7	56	154	0.363636363636364	0.454920450933191	0.44249769709977	false	false	false	true
d35b4647-d495-4c2b-9e42-4790a8ff6e99	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	MPC	MPC261016C00350000	call	350.0000	2026-10-16	45.4400	44.8000	45.7000	389.4800	254480.00	195220.00	22700.00	56	10	56	224	0.25	0.50886206624542	0.506122231376071	false	false	false	true
b70c5f96-b4bb-47bf-af89-9761f7fcef92	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	PSX	PSX260925C00245000	call	245.0000	2026-09-25	12.3000	12.0000	12.3000	256.6900	100860.00	100860.00	0.00	82	13	82	18	4.55555555555556	0.529341559727517	0.529341559727517	false	false	false	true
8b6474e2-b2c2-453d-ba6c-f2c559aa736c	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	MPC	MPC261016C00340000	call	340.0000	2026-10-16	53.8000	53.1000	53.8000	389.4800	581040.00	581040.00	0.00	108	6	117	172	0.680232558139535	0.517786467102924	0.517786467102924	false	false	false	true
473ff9fa-124b-44ee-88d1-b74e45d3aba2	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	DINO	DINO261016P00120000	put	120.0000	2026-10-16	15.8000	15.6000	16.2000	105.8200	18960.00	1580.00	17380.00	12	7	15	136	0.110294117647059	0.593815306415126	0.593815306415126	false	false	false	true
46e50ba3-b8d0-4dc7-b2a8-7afdef05dc0f	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	DINO	DINO261120C00095000	call	95.0000	2026-11-20	16.0000	15.7000	16.8000	105.8200	124808.00	25600.00	99208.00	78	13	80	24	3.33333333333333	0.567015535439884	0.577959061810412	false	false	false	true
225ad487-8858-4cc1-a59d-ce50fdc02c3f	2026-09-23 12:38	2026-09-23 12:37	2026-09-23 12:37	DINO	DINO270115C00120000	call	120.0000	2027-01-15	8.7000	8.7000	9.1000	106.4600	16530.00	0.00	16530.00	19	6	20	173	0.115606936416185	0.555829077824587	0.555829077824587	false	false	false	true
e5cbc2eb-a9ff-4e3b-81ad-b909981485ac	2026-09-23 12:29	2026-09-23 12:29	2026-09-23 12:29	HAL	HAL270115P00033000	put	33.0000	2027-01-15	2.3600	2.1700	2.3800	33.3650	26668.00	1416.00	25252.00	113	7	113	217	0.52073732718894	0.373776842221853	0.373776842221853	false	false	false	true
414a9afa-8693-4900-b33e-3cc21917eb58	2026-09-23 12:16	2026-09-23 12:16	2026-09-23 12:16	BP	BP261016P00045000	put	45.0000	2026-10-16	1.6500	1.6400	1.7000	44.3700	30195.00	0.00	30030.00	183	25	214	8902	0.0240395416760279	0.307900351516616	0.307900351516616	false	false	false	true
5326fb65-f706-4437-bbed-6abe0c58e43f	2026-09-23 12:08	2026-09-23 12:08	2026-09-23 12:08	VLO	VLO261002C00402500	call	402.5000	2026-10-02	4.9000	4.9000	5.7000	380.6950	94080.00	0.00	94080.00	192	31	210	36	5.83333333333333	0.5248668365864	0.525206400094311	false	false	false	true
94ef04f9-fd70-408e-894e-63d6a0b68a82	2026-09-23 12:04	2026-09-23 12:04	2026-09-23 12:04	VLO	VLO260925P00370000	put	370.0000	2026-09-25	3.2200	3.0000	3.7000	381.1300	31880.00	10020.00	21860.00	99	9	201	1346	0.149331352154532	0.669409522514213	0.677498962879839	false	false	false	true
4c03f1a6-29cf-4fc6-a0bc-65d060f18a24	2026-09-23 11:51	2026-09-23 11:51	2026-09-23 11:51	PSX	PSX270115P00250000	put	250.0000	2027-01-15	20.7000	20.4000	20.8500	256.0000	161460.00	161460.00	0.00	78	6	232	821	0.28258221680877	0.451294242192889	0.451294242192889	false	false	false	true
06c31efc-4c81-469f-a389-b52f0d2c3c58	2026-09-23 11:47	2026-09-23 11:47	2026-09-23 11:47	PSX	PSX270617P00210000	put	210.0000	2027-06-17	15.1000	15.1000	15.6000	256.0000	31710.00	0.00	31710.00	21	6	662	163	4.06134969325153	0.456450621446367	0.456450621446367	false	false	false	true
485f7126-1b4c-44b4-8b09-30467cdd5b9e	2026-09-23 11:47	2026-09-23 11:47	2026-09-23 11:47	PSX	PSX270617P00210000	put	210.0000	2027-06-17	15.1000	15.1000	15.6000	256.0000	57380.00	0.00	57380.00	38	14	641	163	3.93251533742331	0.45661893621204	0.45661893621204	false	false	false	true
6eadb880-841a-47e2-9986-b1ae21cd2770	2026-09-23 11:47	2026-09-23 11:47	2026-09-23 11:47	PSX	PSX270617P00210000	put	210.0000	2027-06-17	15.1000	15.1000	15.6000	255.0000	221970.00	0.00	221970.00	147	33	549	163	3.3680981595092	0.455591173804955	0.455591173804955	false	false	false	true
18ee4c96-39f2-4a59-a9bf-c15a353c6af0	2026-09-23 11:47	2026-09-23 11:47	2026-09-23 11:47	PSX	PSX270319C00310000	call	310.0000	2027-03-19	14.9000	14.3000	14.9000	255.0000	10430.00	10430.00	0.00	7	5	12	25	0.48	0.433642833103241	0.433642833103241	false	false	false	true
8117df17-8096-4ff9-9f56-3d329429fb28	2026-09-23 11:21	2026-09-23 11:21	2026-09-23 11:21	VLO	VLO261002P00370000	put	370.0000	2026-10-02	9.9600	8.9000	10.4000	375.9179	43830.00	17000.00	26830.00	44	10	98	184	0.532608695652174	0.552475731187647	0.548107159532465	true	false	false	true
159f322f-c6d0-4c4a-a07b-13d7a4ea9d15	2026-09-23 11:16	2026-09-23 11:16	2026-09-23 11:16	MPC	MPC270115C00520000	call	520.0000	2027-01-15	11.3000	10.2000	12.5000	389.5150	33900.00	19210.00	3390.00	30	9	30	102	0.294117647058824	0.511159569885631	0.511159569885631	false	false	false	true
28bb1d8c-eab7-4003-b3c5-614526c4af31	2026-09-23 11:13	2026-09-23 11:13	2026-09-23 11:13	VLO	VLO270617C00500000	call	500.0000	2027-06-17	30.1000	29.4000	30.1000	375.2450	60200.00	60200.00	0.00	20	5	20	34	0.588235294117647	0.495843296976813	0.495843296976813	false	false	false	true
8a8c00d0-9609-4547-98ea-b114e9cb02e2	2026-09-23 11:03	2026-09-23 11:03	2026-09-23 11:03	VLO	VLO260925P00357500	put	357.5000	2026-09-25	2.0000	1.6500	2.0000	374.2700	12000.00	12000.00	0.00	60	26	90	1335	0.0674157303370786	0.707942452668096	0.707942452668096	true	false	false	true
a43f21bd-66a7-4f20-bb5a-c2269d9bb08b	2026-09-23 10:40	2026-09-23 10:40	2026-09-23 10:40	HAL	HAL270917C00040000	call	40.0000	2027-09-17	2.7100	2.6700	2.7150	33.0200	39837.00	39837.00	0.00	147	5	187	183	1.02185792349727	0.349727416049746	0.349885468516848	false	false	false	true
2db15a70-1ff4-4aa8-987e-09027b27b479	2026-09-23 10:10	2026-09-23 10:10	2026-09-23 10:10	VLO	VLO260925C00382500	call	382.5000	2026-09-25	7.8200	6.5000	9.4000	381.9799	11735.00	0.00	11735.00	15	9	17	22	0.772727272727273	0.705027817691883	0.705027817691883	false	false	false	true
9aeea962-2f74-42cb-8982-db90315d9e07	2026-09-23 09:54	2026-09-23 09:51	2026-09-23 09:54	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.4000	0.0000	0.0000	33.0450	819477.00	816759.00	1908.00	5860	42	10121	605	16.7289256198347	0	0	true	true	false	true
f52c003a-70cf-4b01-afc8-c8f24b91a6be	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3800	1.3800	1.4500	33.0300	10764.00	0.00	10764.00	78	16	4631	605	7.65454545454545	0.39735782840825	0.39735782840825	false	false	false	true
7696f339-b92a-4cbd-83b9-e6469320ab4c	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3800	1.3800	1.4000	33.0250	255319.00	2641.00	252678.00	1850	38	4263	605	7.04628099173554	0.39735782840825	0.397753157393514	true	false	false	true
009e9f13-4903-4a11-87e0-4b0ec320c766	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3800	1.2700	1.4300	33.0300	154899.00	125159.00	17182.00	1125	121	2413	605	3.98842975206612	0.402883795799836	0.39735782840825	true	false	false	true
67e8e415-aebd-4765-a0a1-7a976b18bee6	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	MPC	MPC261016P00340000	put	340.0000	2026-10-16	2.8500	2.8500	2.9000	396.0200	22515.00	0.00	22515.00	79	13	98	3023	0.0324181276877274	0.525546287927828	0.525546287927828	false	false	false	true
ef6edc63-b6b9-418c-a493-c40e057f2098	2026-09-23 09:52	2026-09-23 09:52	2026-09-23 09:52	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3500	1.3500	1.4500	33.0400	10260.00	0.00	10260.00	76	16	1113	605	1.8396694214876	0.390679853705984	0.390679853705984	false	false	false	true
685e7466-1b28-49a9-b31b-f32b876476df	2026-09-23 09:52	2026-09-23 09:52	2026-09-23 09:52	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3500	1.3500	1.3800	33.0300	14040.00	0.00	14040.00	104	24	1011	605	1.67107438016529	0.391467389947004	0.391467389947004	true	false	false	true
d87301bc-f8a6-4227-851b-364a4da6ce05	2026-09-23 09:52	2026-09-23 09:51	2026-09-23 09:51	VLO	VLO261002P00377500	put	377.5000	2026-10-02	9.6400	8.8000	10.2000	386.0000	28920.00	2890.00	26030.00	30	8	52	21	2.47619047619048	0.568181390303519	0.568181390303519	true	false	false	true
395afb45-affe-45fa-bc25-fa34d6d051a3	2026-09-23 09:51	2026-09-23 09:51	2026-09-23 09:51	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3500	1.3500	1.4400	33.0300	73170.00	0.00	5400.00	542	119	544	605	0.899173553719008	0.394220709769058	0.391467389947004	true	false	false	true
528f5a2b-f0ec-43e7-8d0d-195e6983dbbe	2026-09-23 09:50	2026-09-23 09:50	2026-09-23 09:50	HAL	HAL261218C00037000	call	37.0000	2026-12-18	1.0500	0.9700	1.0700	33.0100	130935.00	130935.00	0.00	1247	6	1247	1407	0.886282871357498	0.363891342798842	0.363891342798842	false	false	false	true
9616d7a3-d744-4388-82a1-d386faac3f93	2026-09-22 15:57	2026-09-22 15:56	2026-09-22 15:56	VLO	VLO261016P00380000	put	380.0000	2026-10-16	22.0000	20.7000	22.0000	376.8000	13200.00	13200.00	0.00	6	6	865	796	1.08668341708543	0.540419858525296	0.540419858525296	false	false	false	true
aaf97a7f-0129-48de-8965-deb7143f1990	2026-09-22 15:56	2026-09-22 15:56	2026-09-22 15:56	VLO	VLO261016C00380000	call	380.0000	2026-10-16	20.0000	20.0000	20.1000	377.2500	34000.00	0.00	34000.00	17	11	81	204	0.397058823529412	0.539932418353774	0.539932418353774	false	false	false	true
8b078431-b22c-4bed-8df6-501306415db7	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	VLO	VLO261002P00360000	put	360.0000	2026-10-02	6.4000	5.8000	6.4000	376.6800	17920.00	17920.00	0.00	28	5	1733	584	2.96746575342466	0.544042259768013	0.544042259768013	true	false	false	true
67394fd5-165b-4887-a345-9e03e2900c98	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	VLO	VLO261002P00360000	put	360.0000	2026-10-02	6.3000	5.8000	6.3000	376.6800	21420.00	21420.00	0.00	34	6	1767	584	3.02568493150685	0.539333910478075	0.539333910478075	true	false	false	true
29b73ec6-3450-4adb-aa76-0a6b27453955	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	VLO	VLO260925P00375000	put	375.0000	2026-09-25	7.3000	6.7000	7.4000	376.8600	17520.00	17520.00	0.00	24	6	1786	1308	1.36544342507645	0.607177641031568	0.607177641031568	false	false	false	true
f9c5a848-697c-48ac-ad58-5d0075e74d4e	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	VLO	VLO260925P00375000	put	375.0000	2026-09-25	7.3000	6.6000	7.3000	377.0000	20440.00	20440.00	0.00	28	8	1762	1308	1.34709480122324	0.611832840340821	0.611832840340821	false	false	false	true
4d769b07-3346-4234-8a59-0a5dc1c8fd79	2026-09-22 15:51	2026-09-22 15:51	2026-09-22 15:51	VLO	VLO261016P00380000	put	380.0000	2026-10-16	22.1000	20.9000	22.1000	376.8000	33150.00	30940.00	0.00	15	6	852	796	1.07035175879397	0.54301512486764	0.54301512486764	false	false	false	true
987fb677-df1f-49aa-898c-185f0d90afd7	2026-09-22 15:49	2026-09-22 15:49	2026-09-22 15:49	PSX	PSX261120P00260000	put	260.0000	2026-11-20	19.5000	19.5000	20.1000	257.4300	21450.00	0.00	21450.00	11	5	79	256	0.30859375	0.461766638859179	0.461766638859179	false	false	false	true
caa6a7cf-2a05-4fb8-9d90-df03a175bc7d	2026-09-22 15:48	2026-09-22 15:48	2026-09-22 15:48	VLO	VLO261016P00380000	put	380.0000	2026-10-16	21.8000	21.4000	21.8000	377.6200	13080.00	6540.00	0.00	6	6	822	796	1.03266331658291	0.545565376408013	0.545565376408013	false	false	false	true
dd7b88df-bb8b-4ad4-8e0b-03ffd2877e34	2026-09-22 15:48	2026-09-22 15:48	2026-09-22 15:48	VLO	VLO261016P00380000	put	380.0000	2026-10-16	21.6000	21.3000	21.6000	377.5550	21600.00	6480.00	0.00	10	10	816	796	1.0251256281407	0.539569322505196	0.539569322505196	false	false	false	true
8871ac3e-9087-4c1a-99c5-03b75643a865	2026-09-22 15:47	2026-09-22 15:47	2026-09-22 15:47	VLO	VLO261016P00300000	put	300.0000	2026-10-16	1.2800	0.8500	1.7000	377.9800	211200.00	128700.00	82500.00	1650	2	5200	2658	1.95635816403311	0.580844262841976	0.580844262841976	false	true	false	true
10950924-cde1-4d7f-a15a-dc0a81b632b5	2026-09-22 15:47	2026-09-22 15:40	2026-09-22 15:47	VLO	VLO261016P00300000	put	300.0000	2026-10-16	1.3000	0.0000	0.0000	377.9800	275901.00	137020.00	87661.00	2148	39	5200	2658	1.95635816403311	0	0	true	true	false	true