near-toll-audit / pipeline/sql/11_top_holders.sql · raw
-- Largest balances on the latest day (liquid + staked + unstaking, including any linked lockup). In NEAR.WITH last_day AS (SELECT MAX(epoch_date) AS d FROM `bigquery-public-data.crypto_near_mainnet_us.ft_balances_daily` WHERE epoch_date >= '2026-10-01')SELECT b.epoch_date, b.account_id, b.liquid, b.staked, b.unstaked_not_liquid, b.lockup_liquid, b.lockup_staked,       b.liquid + b.staked + b.unstaked_not_liquid + b.lockup_liquid + b.lockup_staked + b.lockup_unstaked_not_liquid AS totalFROM `bigquery-public-data.crypto_near_mainnet_us.ft_balances_daily` b, last_dayWHERE b.epoch_date = last_day.dORDER BY total DESCLIMIT 300