Query editor
SELECTaddress,ROUND(SUM(net_amount) / POWER(10, 6), 1) AS balance,ROUND((SUM(net_amount) / POWER(10, 6)) * 100 / 475203574.91, 1) AS pct_supplyFROM (SELECTto_owner AS address,amount AS net_amountFROM tokens_solana.transfersWHERE token_mint_address = 'MERt85fc5boKw3BW1eYdxonEuJNvXbiMbs6hvheau5K'AND block_time < CAST('2023-02-28 23:59:59' AS TIMESTAMP)UNION ALLSELECTfrom_owner AS address,-amount AS net_amountFROM tokens_solana.transfersWHERE token_mint_address = 'MERt85fc5boKw3BW1eYdxonEuJNvXbiMbs6hvheau5K'AND block_time < CAST('2023-02-28 23:59:59' AS TIMESTAMP)) AS all_flowsGROUP BY addressHAVING SUM(net_amount) > 0ORDER BY SUM(net_amount) DESCLIMIT 20;