freemartianDaily Deposits & Withdrawal
    Updated 2024-09-02
    with
    temps AS (
    SELECT
    block_timestamp::date AS temp_day,
    symbol AS temp_symbol
    FROM ethereum.core.ez_token_transfers
    WHERE block_timestamp::date >= '2024-06-11'
    AND symbol IN ('WBTC','tBTC','LsETH','wBETH','ETHx','wstETH','osETH','sfrxETH','sUSDe','ENA','swETH','rETH','ETHFI','cbETH','FXS','mETH')
    GROUP BY 1,2
    ORDER BY 1 ASC
    ),
    deposits AS(
    SELECT
    block_timestamp::date AS deposit_day,
    symbol AS deposit_token,
    count(tx_hash) AS deposit_transactions,
    count(DISTINCT origin_from_address) AS depositors,
    SUM(amount) AS deposit_amount,
    SUM(amount_usd) AS deposit_amount_usd,
    FROM ethereum.core.ez_token_transfers
    WHERE
    to_address IN (
    '0xc329400492c6ff2438472d4651ad17389fcb843a',
    '0xb26ff591f44b04e78de18f43b46f8b70c6676984',
    '0x422f5accc812c396600010f224b320a743695f85',
    '0x03bf48b8a1b37fbead1ecabcf15b98b924ffa5ac',
    '0x475d3eb031d250070b63fa145f0fcfc5d97c304a',
    '0x38b86004842d3fa4596f0b7a0b53de90745ab654',
    '0x5198cb44d7b2e993ebdda9cad3b9a0eaa32769d2',
    '0xbdea8e677f9f7c294a4556005c640ee505be6925',
    '0xe39b5f5638a209c1a6b6cdffe5d37f7ac99fcc84',
    '0x19d0d8e6294b7a04a2733fe433444704b791939a',
    '0x971e5b5d4baa5607863f3748febf287c7bf82618',
    '0x0c969cec0729487d264716e55f232b404299032c',
    '0xb09a50acfff7d12b7d18adef3d1027bc149bad1c',
    '0x52cb8a621610cc3ccf498a1981a8ae7ad6b8ab2a',
    Auto-refreshes every 1 hour
    QueryRunArchived: QueryRun has been archived