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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×ticker = JEF×

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

a5680d8e-9f8f-43de-8eff-5e4fbfc83f50	2026-10-01 15:20	2026-10-01 15:20	2026-10-01 15:20	JEF	JEF261218P00047500	put	47.5000	2026-12-18	4.7900	4.3000	5.2000	45.0000	10531.00	10531.00	0.00	22	6	479	851	0.562867215041128	0.442719178506663	0.445130601722758	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Financial Services	8766856723.00	2027-01-06	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T19:25:04.657704Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
5d9c6e35-6844-4193-920a-81a3dc7cc3cd	2026-10-01 15:20	2026-10-01 15:20	2026-10-01 15:20	JEF	JEF261218P00047500	put	47.5000	2026-12-18	4.7800	4.3000	5.2000	45.0000	11005.00	11005.00	0.00	23	5	457	851	0.537015276145711	0.442719178506663	0.442719178506663	false	false	false	true
44e6b496-3459-4707-951d-79afc1ab6ce2	2026-10-01 15:19	2026-10-01 15:19	2026-10-01 15:19	JEF	JEF261218P00047500	put	47.5000	2026-12-18	4.7800	4.3000	5.2000	45.0000	13392.00	13392.00	0.00	28	5	434	851	0.509988249118684	0.441743160319599	0.441743160319599	false	false	false	true
b14a8a71-f138-4dda-91b1-72e3c1583b43	2026-10-01 15:19	2026-10-01 15:19	2026-10-01 15:19	JEF	JEF261218P00047500	put	47.5000	2026-12-18	4.7800	4.3000	5.2000	45.0000	19100.00	19100.00	0.00	40	6	373	851	0.438307873090482	0.440307365883392	0.440307365883392	false	false	false	true
f1e8c5cb-a1eb-4cf6-81a0-2ff754b6ff82	2026-10-01 15:18	2026-10-01 15:18	2026-10-01 15:18	JEF	JEF261218P00047500	put	47.5000	2026-12-18	4.6400	4.2000	5.2000	45.0000	26469.00	0.00	26469.00	57	6	114	851	0.133960047003525	0.436602458299812	0.436602458299812	false	false	false	true
048ebf47-d726-4816-a9cf-9f70a5fc9201	2026-09-04 11:40	2026-09-04 11:40	2026-09-04 11:40	JEF	JEF270115P00045000	put	45.0000	2027-01-15	1.2000	1.2000	1.5500	55.7600	47052.00	0.00	47052.00	392	32	675	713	0.946704067321178	0.413057457544024	0.413057457544024	false	false	false	true
d025f745-fe9f-4390-84ed-0652bdb35129	2026-08-20 15:18	2026-08-20 15:18	2026-08-20 15:18	JEF	JEF260918P00052500	put	52.5000	2026-09-18	2.2000	1.9000	2.2500	52.0200	19780.00	19780.00	0.00	90	9	216	439	0.492027334851936	0.343427840389252	0.343427840389252	false	false	false	true