Query editor
-- =====================================================================-- QUERY: cirBTC Ethereum — Top Holders-- PURPOSE: Address-level current balance, holder type label, % share of-- total supply, and balance change over the selected window.-- DEPENDS ON: query 7775922 (Base Labeled Transfers)-- =====================================================================with all_time as (select * from query_7775922),balance_rows as (select "to" as addr, to_label as label, to_label_type as label_type, amount as delta,is_mint, false as is_burnfrom all_timeunion allselect "from" as addr, from_label as label, from_label_type as label_type, -amount as delta,false as is_mint, is_burnfrom all_time),balances_with_supply as (selectaddr,-- Most-recent label per address (labels are static today, but this-- avoids ambiguity if an address's classification ever changes)arbitrary(label) as label,arbitrary(label_type) as label_type,sum(delta) as balance,sum(sum(case when is_mint then delta else 0 end)) over () as total_mints,sum(sum(case when is_burn then -delta else 0 end)) over () as total_burnsfrom balance_rowsgroup by addr),window_transfers as (select * from query_7775922where evt_block_time >= now() - (case '{{time_window}}'when '24h' then interval '1' daywhen '7d' then interval '7' daywhen '30d' then interval '30' dayend)),window_change_rows as (select "to" as addr, amount as delta from window_transfersunion allselect "from" as addr, -amount as delta from window_transfers),window_change as (select addr, sum(delta) as balance_changefrom window_change_rowsgroup by 1)selectb.addr,