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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×sector = Technology×ticker = APPF×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

f18bcc47-885d-43bb-9a48-0345dd645105	2026-10-02 15:15	2026-10-02 15:15	2026-10-02 15:15	APPF	APPF261016P00200000	put	200.0000	2026-10-16	5.7000	5.2000	6.0000	202.5400	33060.00	6840.00	26220.00	58	5	230	4	57.5	0.4477830434706	0.4477830434706	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	4889012880.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T19:15:21.750665Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
b9eab2c7-3e92-464d-b920-24d082a6caab	2026-10-02 15:14	2026-10-02 15:14	2026-10-02 15:14	APPF	APPF261016P00200000	put	200.0000	2026-10-16	5.5000	5.5000	6.0000	202.7800	54450.00	0.00	54450.00	99	7	172	4	43	0.441305653395886	0.441305653395886	false	false	false	true
fc5dfb53-37c4-4955-a0d4-2ec3686e6866	2026-10-02 15:14	2026-10-02 15:14	2026-10-02 15:14	APPF	APPF261016P00200000	put	200.0000	2026-10-16	5.3000	5.3000	5.7000	202.8950	38690.00	0.00	38690.00	73	5	73	4	18.25	0.431416821759231	0.431416821759231	false	false	false	true
93605107-8905-4758-b0ef-ae9915418be5	2026-09-29 11:02	2026-09-29 11:02	2026-09-29 11:02	APPF	APPF270115P00220000	put	220.0000	2027-01-15	34.6000	34.3000	36.0000	195.8000	103800.00	6920.00	96880.00	30	9	30	1	30	0.499270616488384	0.499270616488384	false	false	false	true
ccba65cc-c27b-49e3-bb00-936226596a8c	2026-09-22 12:19	2026-09-22 12:19	2026-09-22 12:19	APPF	APPF261120P00210000	put	210.0000	2026-11-20	19.6000	19.6000	20.6000	204.5100	68600.00	0.00	68600.00	35	13	35	0	0	0.528363835011762	0.528363835011762	false	false	false	true
a1a09f9f-d7d6-4b37-b5ff-708cff86684a	2026-09-21 15:08	2026-09-21 15:08	2026-09-21 15:08	APPF	APPF270115C00220000	call	220.0000	2027-01-15	20.6000	20.6000	22.2000	211.5950	57690.00	0.00	57690.00	28	11	28	45	0.622222222222222	0.483407992074994	0.483407992074994	false	false	false	true
ec1cd364-2690-4eda-af44-ab5f2aaffa36	2026-09-21 14:21	2026-09-21 14:21	2026-09-21 14:21	APPF	APPF270115P00210000	put	210.0000	2027-01-15	21.2000	21.2000	22.1000	211.3550	82680.00	0.00	82680.00	39	14	39	1	39	0.495045029225007	0.495045029225007	false	false	false	true
161365cf-020d-4434-9d5c-5cd3e7731b8c	2026-09-21 12:44	2026-09-21 12:44	2026-09-21 12:44	APPF	APPF261120C00230000	call	230.0000	2026-11-20	12.6000	12.6000	13.3000	212.2500	47880.00	0.00	47880.00	38	12	44	1	44	0.552681589252074	0.552681589252074	false	false	false	true
5b78ce27-a539-41fc-a365-1296e80fb967	2026-09-18 11:10	2026-09-18 11:10	2026-09-18 11:10	APPF	APPF270115C00210000	call	210.0000	2027-01-15	29.2000	29.2000	30.9000	215.9500	189800.00	0.00	189800.00	65	19	65	12	5.41666666666667	0.511043889322055	0.511043889322055	false	false	false	true
a44e6282-2afd-4299-b232-6561dd49dea8	2026-09-08 15:09	2026-09-08 15:09	2026-09-08 15:09	APPF	APPF270115P00190000	put	190.0000	2027-01-15	16.3000	16.3000	18.4000	205.1550	88020.00	0.00	88020.00	54	19	54	1	54	0.521674725630096	0.521674725630096	false	false	false	true
05f9d97f-f962-4281-8abf-0ca0a8c79b56	2026-09-01 12:30	2026-09-01 12:30	2026-09-01 12:30	APPF	APPF261016C00240000	call	240.0000	2026-10-16	10.7000	10.7000	11.6000	228.8800	58850.00	0.00	58850.00	55	19	55	57	0.964912280701754	0.4636003103473	0.4636003103473	false	false	false	true
196e3832-fabb-4f70-a308-9b2d3eb98a9d	2026-08-24 11:49	2026-08-24 11:49	2026-08-24 11:49	APPF	APPF261016C00220000	call	220.0000	2026-10-16	19.0000	19.0000	20.2000	224.3550	100700.00	0.00	100700.00	53	17	53	68	0.779411764705882	0.47759409702224	0.47759409702224	false	false	false	true
442102a3-0920-434d-bcce-bd949f3ae1fa	2026-08-19 10:42	2026-08-19 10:42	2026-08-19 10:42	APPF	APPF261016P00185000	put	185.0000	2026-10-16	5.0000	5.0000	5.6000	214.2100	16500.00	0.00	16500.00	33	13	33	61	0.540983606557377	0.498621263893751	0.498621263893751	false	false	false	true