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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = GDX260925P00095000×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	pricenumeric	bidnumeric	asknumeric	underlying_pricenumeric	total_premiumnumeric	total_ask_side_premnumeric	total_bid_side_premnumeric	total_sizebigint	trade_countinteger	volumebigint	open_interestbigint	volume_oi_rationumeric	iv_startnumeric	iv_endnumeric	has_sweepboolean	has_floorboolean	has_multilegboolean	has_singlelegboolean	all_opening_tradesboolean	alert_ruletext	rule_iduuid	expiry_countinteger	issue_typetext	sectortext	marketcapnumeric	next_earnings_datedate	er_timetext	missing_periscopeboolean	sourcetext	endpointtext	request_paramsjsonb	as_ofdate	vintage_tstimestamp with time zone	retrieved_attimestamp with time zone
a6a6f1c5-0cbe-49e9-b9a3-53c78ae9dd21	2026-09-18 15:59	2026-09-18 15:59	2026-09-18 15:59	GDX	GDX260925P00095000	put	95.0000	2026-09-25	1.8000	1.7300	1.8500	95.0000	180000.00	18000.00	162000.00	1000	13	1557	803	1.93897882938979	0.398296126461314	0.398067539057524	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	52.34	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15