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:endpoint = /api/option-trades/flow-alerts×option_symbol = CAT270115P00800000×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

77c2bd5c-e9d8-4af0-80d0-f35c73029a9b	2026-09-17 10:12	2026-09-17 10:12	2026-09-17 10:12	CAT	CAT270115P00800000	put	800.0000	2027-01-15	68.5500	67.9000	69.6000	798.7200	322200.00	253600.00	68600.00	47	7	70	508	0.137795275590551	0.405169087989818	0.403708956637889	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Industrials	367082576109.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
c2276ed5-89ae-4bbb-a441-55e1a137e229	2026-09-30 12:41	2026-09-30 12:41	2026-09-30 12:41	CAT	CAT270115P00800000	put	800.0000	2027-01-15	54.8000	54.8000	57.0000	816.0000	32880.00	0.00	32880.00	6	6	12	516	0.0232558139534884	0.387423658473005	0.387423658473005	false	false	false
ff8f8605-cf7e-4ec8-925f-b5079c0804db	2026-09-30 13:26	2026-09-30 13:26	2026-09-30 13:26	CAT	CAT270115P00800000	put	800.0000	2027-01-15	54.3800	54.3500	56.2000	816.0000	266440.00	136000.00	130440.00	49	14	61	516	0.118217054263566	0.385679499117435	0.385972945050046	false	false	false