MLDZMNCelsius wallet withdrawal
    Updated 2023-05-21
    SELECT
    date_trunc('hour',block_timestamp)as hour,
    count(distinct tx_hash) as "Count of withdraw",
    sum(amount) as "Volume in stETH",
    sum(amount_usd) as "Volume in USD"


    FROM ethereum.core.ez_token_transfers s
    left join crosschain.core.address_labels a on s.to_address=a.address
    WHERE contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
    and block_timestamp>='2023-05-15'
    and from_address not in ('0x0000000000000000000000000000000000000000')
    and ADDRESS_NAME ilike '%celsius wallet%'
    GROUP BY 1
    Run a query to Download Data