Query editor
WITH btc_received AS (SELECTaddress,SUM(value) AS valueFROM bitcoin.outputswhere address is not nullGROUP BY 1),labels as (select address, exchange as label from query_2613158union allselect * from query_2614243),btc_sent AS (SELECTaddress, SUM(-value) AS valueFROM bitcoin.inputswhere address is not nullGROUP BY 1),current_supply as (select sum(mint_reward) as cir_supplyfrom bitcoin.blocks),current_price as (select price from prices.usd_latestwhere contract_address is null and symbol = 'BTC'),current_balance as (select a.address,array_Agg(distinct label) as labels, sum(value) as amountfrom (select * from btc_receivedunion allselect * from btc_sent)aleft join labels bon a.address=b.addressgroup by 1order by 3 desclimit 100)selectrank() over (order by amount desc) as ranking,CONCAT('<a href="https://bitinfocharts.com/bitcoin/address/', address, '" target="_blank">',address, '</a>') as address,labels,amount,amount * price as value,amount/cir_supply as percentage_coinsfrom current_balance,current_price,current_supplyorder by 4 desc