flipside

    Total DR3AM Users by category
    freemartianTotal DR3AM Users by category
    Updated 2025-03-05
    WITH first_dist AS(
    SELECT block_timestamp, tx_hash, to_address AS user, amount AS first_amount_received,
    FROM base.core.ez_token_transfers
    WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
    AND tx_hash = '0xe930bba69e4c165a44197088b25f890b37de23c182f992c0834fa8843407c9f0'
    AND to_address not in ('0x0ebcee3165654d9c52dd6d438423be76f2df1b0e','0xb8745dec73f81ea366d7cc672438053c0e97de51')
    ORDER BY event_index ASC
    ),

    token_in_out AS(
    SELECT
    to_address AS user,
    SUM(amount) AS amount,
    FROM base.core.ez_token_transfers
    WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
    GROUP BY 1
    UNION ALL
    SELECT
    from_address AS user,
    SUM(-amount) AS amount,
    FROM base.core.ez_token_transfers
    WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
    GROUP BY 1
    ),
    current_user_amount AS(
    SELECT
    user,
    sum(amount) AS current_balance
    FROM token_in_out
    GROUP BY 1
    ),

    stake AS(
    -- stake
    SELECT
    block_timestamp, tx_hash, decoded_log:from AS user, decoded_log:value/pow(10,18) AS amount, 'Stake' AS label
    Last run: 21 days agoAuto-refreshes every 1 hour
    CATEGORY
    USERS
    SUM_BALANCE
    1
    		Between 10k and 50k $FDR3AM73516789222.7305751
    2
    		Between 50k and 100k $FDR3AM23717008151.3729639
    3
    		Between 1k and 10k $FDR3AM8603628626.11209399
    4
    		More Than 1M $FDR3AM112938474582.41345
    5
    		less than 1k $FDR3AM26823171176.153790564
    6
    		Between 500k and 1M $FDR3AM7351986104.0224178
    7
    		Between 100k and 500k $FDR3AM32271942137.1947106
    7
    360B
    935s