near-toll-audit / pipeline/sql/03_balances_daily.sql · raw
-- Values in ft_balances_daily are already in NEAR, not yocto. The table covers about 30k accounts, not all accounts.-- Network balance sheet per day: liquid, staked, and lockup-contract holdings.SELECT epoch_date,       COUNT(*) AS accounts,       SUM(liquid) AS liquid_near,       SUM(staked) AS staked_near,       SUM(unstaked_not_liquid) AS unstaking_near,       SUM(reward) AS reward_near,       SUM(lockup_liquid) AS lockup_liquid_near,       SUM(lockup_staked) AS lockup_staked_near,       SUM(lockup_unstaked_not_liquid) AS lockup_unstaking_near,       SUM(lockup_reward) AS lockup_reward_nearFROM `bigquery-public-data.crypto_near_mainnet_us.ft_balances_daily`WHERE epoch_date >= '2023-01-01'GROUP BY epoch_date ORDER BY epoch_date