Query editor
WITH fdusd_txs AS (SELECT'ethereum' AS blockchain,evt_block_time AS block_time,"from" AS address,CAST(value AS DOUBLE) AS amountFROM erc20_ethereum.evt_transfer AS tWHEREevt_block_number > 17144262AND evt_block_time > TIMESTAMP '2023-04-28 11:15:10.000 UTC'AND contract_address = 0xc5f0f7b66764F6ec8C8Dff7BA683102295E16409 -- $FDUSDUNION ALL-- BNB ChainSELECT'bnb' AS blockchain,evt_block_time AS block_time,"from" AS address,CAST(value AS DOUBLE) AS amountFROM erc20_bnb.evt_transfer AS tWHEREevt_block_number > 27850219AND evt_block_time > TIMESTAMP '2023-05-02 05:56:32 UTC'AND contract_address = 0xc5f0f7b66764F6ec8C8Dff7BA683102295E16409 -- $FDUSD),tx_distribution_raw AS (SELECTv2.blockchain,v2.address,SUM(COALESCE(v1.amount / 1e18, 0)) AS amountFROM fdusd_txs AS v1LEFT JOIN ( SELECT DISTINCT blockchain, address FROM fdusd_txs ) AS v2ON v1.blockchain = v2.blockchainAND v1.address = v2.addressWHERE v2.address != 0x0000000000000000000000000000000000000000GROUP BY 1, 2),tx_distribution_raw_2 AS (SELECTblockchain,address,SUM(amount) OVER (PARTITION BY blockchain, address) AS amountFROM tx_distribution_raw),tx_distribution AS (SELECTblockchain,CASEWHEN amount <= 100 THEN '<= 100'WHEN amount > 100 AND amount <= 1e4 THEN '(100, 10,000]'WHEN amount > 1e4 AND amount <= 1e7 THEN '(10,000, 10,000,000]'WHEN amount > 1e7 THEN '> 10,000,000'END AS bins,COUNT(address) AS frequency,SUM(amount) AS volumeFROM tx_distribution_raw_2GROUP BY 1, 2)