Query editor
WITH Top_ten AS (SELECT address, SUM(Qty) AS HoldingsFROM (SELECT "from" AS address, -SUM(value / POWER(10, 18)) AS Qty, evt_block_timeFROM erc20_ethereum.evt_TransferWHERE contract_address IN (0x9D39A5DE30e57443BfF2A8307A4256c8797A3497)AND evt_block_time BETWEEN TIMESTAMP '2024-09-02 00:00:00' AND TIMESTAMP '2025-03-23 23:59:59'GROUP BY 1, 3UNION ALLSELECT "to" AS address, SUM(value / POWER(10, 18)) AS Qty, evt_block_timeFROM erc20_ethereum.evt_TransferWHERE contract_address IN (0x9D39A5DE30e57443BfF2A8307A4256c8797A3497)AND evt_block_time BETWEEN TIMESTAMP '2024-09-02 00:00:00' AND TIMESTAMP '2025-03-23 23:59:59'GROUP BY 1, 3)GROUP BY 1HAVING SUM(Qty) > 0),labels AS (SELECT address, nameFROM labels.addressesWHERE blockchain = 'ethereum'AND category IN ('institution', 'social'))SELECT CONCAT('<a href="https://etherscan.io/address/',CAST(t.address AS VARCHAR),'" target="_blank">',CAST(t.address AS VARCHAR),'</a>') AS "address_🔗",t.address,l.name,HoldingsFROM Top_ten AS tLEFT JOIN labels AS l ON t.address = l.addressORDER BY Holdings DESC