OneDataAnalystOP - ETH Depositors
    Updated 2022-06-17
    WITH t1 AS ( -- ALL ETH DOPSITS
    SELECT Count(ETH_FROM_ADDRESS) AS dep_count1
    FROM ethereum.core.ez_eth_transfers
    WHERE (ETH_TO_ADDRESS = lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1') OR
    ETH_TO_ADDRESS = lower('0x52ec2F3d7C5977A8E558C8D9C6000B615098E8fC'))
    AND block_timestamp::date >= CURRENT_DATE - 60
    AND block_timestamp::date < CURRENT_DATE),


    t2 AS ( --Distinct Deposits
    SELECT Count(DISTINCT ETH_FROM_ADDRESS) AS dep_count2
    FROM ethereum.core.ez_eth_transfers
    WHERE (ETH_TO_ADDRESS = lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1') OR
    ETH_TO_ADDRESS = lower('0x52ec2F3d7C5977A8E558C8D9C6000B615098E8fC'))
    AND block_timestamp::date >= CURRENT_DATE - 60
    AND block_timestamp::date < CURRENT_DATE),

    t11 AS (
    SELECT DISTINCT ETH_FROM_ADDRESS AS Wallets, Date_trunc('day', block_timestamp) AS dt
    FROM ethereum.core.ez_eth_transfers
    WHERE (ETH_TO_ADDRESS = lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1') OR
    ETH_TO_ADDRESS = lower('0x52ec2F3d7C5977A8E558C8D9C6000B615098E8fC'))
    AND Dt >= CURRENT_DATE - 60
    AND Dt < CURRENT_DATE),

    t22 AS ( --Daily Distinct Wallets
    Select count(wallets) AS dep_count3
    FROM t11 ),


    t33 AS (
    SELECT SUM(Amount) AS ETH_Deposit
    FROM ethereum.core.ez_eth_transfers
    WHERE (ETH_TO_ADDRESS = lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1') OR
    ETH_TO_ADDRESS = lower('0x52ec2F3d7C5977A8E558C8D9C6000B615098E8fC'))
    AND block_timestamp::date >= CURRENT_DATE - 60
    Run a query to Download Data