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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = VIST×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

3575bbfb-7a69-4c50-9a3c-3ffba9594f89	2026-08-17 10:05	2026-08-17 10:05	2026-08-17 10:05	VIST	VIST270319P00070000	put	70.0000	2027-03-19	8.2000	7.7000	8.2000	71.5200	12300.00	820.00	0.00	15	15	20	7	2.85714285714286	0.455690558586994	0.455690558586994	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Energy	7969540306.00	2026-10-28	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
9aeeec40-74ad-4e94-8bce-5e51a5f08c96	2026-08-17 10:38	2026-08-17 10:38	2026-08-17 10:38	VIST	VIST261120C00080000	call	80.0000	2026-11-20	4.1000	3.9000	4.1000	72.1500	24600.00	24600.00	0.00	60	6	302	1152	0.262152777777778	0.460537216404401	0.460537216404401	false	false	false	true
cf245e2b-d367-44b4-9867-b1c72ed56eaf	2026-08-17 11:12	2026-08-17 11:12	2026-08-17 11:12	VIST	VIST261120C00080000	call	80.0000	2026-11-20	4.0000	3.7000	4.0000	71.7350	20800.00	20800.00	0.00	52	7	803	1152	0.697048611111111	0.464832691439088	0.464832691439088	false	false	false	true
c2411d43-ca31-450b-a73b-3d060585c21f	2026-08-19 12:52	2026-08-19 12:52	2026-08-19 12:52	VIST	VIST270319C00070000	call	70.0000	2027-03-19	10.0000	10.0000	10.7000	69.7150	12000.00	0.00	12000.00	12	9	45	34	1.32352941176471	0.446335565286826	0.446335565286826	false	false	false	true
05d5a82e-935d-48ab-a2fe-90b41b649ef5	2026-08-21 12:00	2026-08-21 12:00	2026-08-21 12:00	VIST	VIST261218C00085000	call	85.0000	2026-12-18	2.9000	2.5000	3.3000	69.7600	46690.00	39150.00	7540.00	161	5	617	1395	0.442293906810036	0.464608127024215	0.464608127024215	false	false	false	true
6d68a584-e6f8-4300-a488-00a3b707d9c7	2026-08-24 13:37	2026-08-24 13:37	2026-08-24 13:37	VIST	VIST270319C00075000	call	75.0000	2027-03-19	8.4000	8.0000	8.4000	70.3500	16800.00	16800.00	0.00	20	5	39	122	0.319672131147541	0.456759915958627	0.456759915958627	false	false	false	true
01c890a5-fae4-4716-b601-80398eb3e065	2026-08-25 11:08	2026-08-25 11:08	2026-08-25 11:08	VIST	VIST260918P00070000	put	70.0000	2026-09-18	4.0000	3.7000	4.8000	68.2300	245200.00	20400.00	224800.00	613	22	865	120	7.20833333333333	0.444609997595006	0.444609997595006	true	false	false	true
e20cde19-1e1d-4134-9708-0ef3fffb2127	2026-08-25 11:12	2026-08-25 11:12	2026-08-25 11:12	VIST	VIST260918P00070000	put	70.0000	2026-09-18	4.0000	3.9000	4.0000	68.0500	22000.00	22000.00	0.00	55	5	966	120	8.05	0.429843881605361	0.429843881605361	false	false	false	true
a5f11fcf-fd4a-4175-af1e-8a34b1c31e0a	2026-08-25 11:43	2026-08-25 11:43	2026-08-25 11:43	VIST	VIST260918P00070000	put	70.0000	2026-09-18	4.0000	3.9000	4.0000	67.9950	40000.00	40000.00	0.00	100	11	1612	120	13.4333333333333	0.425238262414011	0.425238262414011	true	false	false	true
4e1bab60-7ed0-480a-b5cd-dd1402037a56	2026-09-02 10:43	2026-09-02 10:43	2026-09-02 10:43	VIST	VIST261120C00080000	call	80.0000	2026-11-20	5.1500	4.7000	5.2000	75.6450	51500.00	25235.00	0.00	100	9	102	3811	0.0267646287063763	0.476164446516657	0.476164446516657	false	false	false	true
2f1405e4-3530-4690-bba9-f252a437c377	2026-09-08 12:58	2026-09-08 12:58	2026-09-08 12:58	VIST	VIST261120C00080000	call	80.0000	2026-11-20	4.5000	4.5000	4.7000	75.0900	22500.00	0.00	22500.00	50	12	53	3807	0.0139217231415813	0.466650056497736	0.466650056497736	false	false	false	true
e5c729a6-2e64-4fc5-aa26-07c4a1963f9c	2026-09-08 13:42	2026-09-08 13:42	2026-09-08 13:42	VIST	VIST261120C00080000	call	80.0000	2026-11-20	4.9000	4.4000	5.1000	75.7150	24500.00	2940.00	18620.00	50	6	127	3807	0.0333596007354873	0.475800216917043	0.475800216917043	false	false	false	true
7a4a43d3-ae2b-4edc-babe-39f39cae2df6	2026-09-17 13:34	2026-09-17 13:33	2026-09-17 13:33	VIST	VIST261016P00075000	put	75.0000	2026-10-16	4.2000	4.1000	4.6000	73.6400	187740.00	30660.00	154560.00	447	21	464	68	6.82352941176471	0.428766046992042	0.432913925552551	false	false	false	true
26d68832-31f3-4758-a5b5-e01c9cc113ca	2026-09-17 13:34	2026-09-17 13:34	2026-09-17 13:34	VIST	VIST261016P00075000	put	75.0000	2026-10-16	4.2000	4.1000	4.6000	73.4575	29400.00	3360.00	26040.00	70	24	534	68	7.85294117647059	0.421177767742883	0.421177767742883	false	false	false	true
b693eeff-3109-429f-a359-416d3d89adb2	2026-09-17 13:34	2026-09-17 13:34	2026-09-17 13:34	VIST	VIST261016P00075000	put	75.0000	2026-10-16	4.1000	4.0000	4.6000	73.4575	170562.00	410.00	170152.00	416	32	950	68	13.9705882352941	0.409020138270547	0.409020138270547	false	false	false	true
5588e03e-90a3-4741-94e0-b60121d65376	2026-09-17 13:34	2026-09-17 13:34	2026-09-17 13:34	VIST	VIST261016P00075000	put	75.0000	2026-10-16	4.1000	4.1000	4.5000	73.4750	58630.00	0.00	58630.00	143	6	1093	68	16.0735294117647	0.410163638402453	0.410163638402453	false	false	false	true