Query editor
-- frxUSDWITH raw AS (SELECT"from" AS address,-value / 1e18 AS amountFROM erc20_ethereum.evt_transferWHERE contract_address = 0x4def5abcfba7babe04472ee4835f459daf4bd45fUNION ALLSELECT"to" AS address,value / 1e18 AS amountFROM erc20_ethereum.evt_transferWHERE contract_address = 0x4def5abcfba7babe04472ee4835f459daf4bd45f),holder_balances AS (SELECTaddress,SUM(amount) AS balanceFROM rawWHERE address <> 0x0000000000000000000000000000000000000000GROUP BY address),supply AS (SELECT SUM(balance) AS total_supplyFROM holder_balances)SELECTROW_NUMBER() OVER (ORDER BY hb.balance DESC) AS rank,concat('<a href="https://etherscan.io/address/', CAST(hb.address AS VARCHAR), '" target="_blank">', CAST(hb.address AS VARCHAR), '</a>') AS address,hb.balance,hb.balance / s.total_supply AS percentage_of_total_supplyFROM holder_balances hbCROSS JOIN supply sWHERE hb.balance > 0ORDER BY rank;