cryptodatadiveTop Depositors
    Updated 2025-04-06
    WITH D1 AS (
    SELECT DISTINCT
    contract_name,
    contract_address,
    origin_from_address AS depositor,
    CASE
    WHEN decoded_log:wad IS NOT NULL
    THEN (decoded_log:wad::int)
    ELSE (decoded_log:assets::int)
    END AS deposit_amount,
    tx_hash,
    block_timestamp
    FROM swell.core.ez_decoded_event_logs
    WHERE event_name = 'Deposit'
    ),

    D2 AS (
    SELECT DISTINCT
    contract_name,
    contract_address,
    origin_from_address AS depositor,
    (decoded_log:assets[1]::int) AS deposit_amount,
    tx_hash,
    block_timestamp
    FROM swell.core.ez_decoded_event_logs
    WHERE event_name = 'Deposits'
    ),

    prices AS (
    SELECT
    LOWER(name) AS name,
    LOWER(symbol) AS symbol,
    date_trunc('hour', hour) AS hour,
    price,
    decimals
    FROM ethereum.price.ez_prices_hourly
    Last run: 20 days ago
    DEPOSITOR
    _TOTAL_DEPOSITS_USD
    DEPOSITED_TOKENS
    1
    0x43e9fa7a60f80711c9d3afe4ce1bb3e8c3f7a9b815.78MEVK Vault eWETH-1, Wrapped Ether
    2
    0x0c883bacaf927076c702fd580505275be44fb63e10.72MEVK Vault epzETH-1, EVK Vault eweETH-1
    3
    0x1b648ade1ef219c87987cd60eba069a7faf1621f6.92M
    EVK Vault eWETH-1, EVK Vault eezETH-1, EVK Vault epzETH-1, EVK Vault ers...
    4
    0x29dfdd80d6acc0f9028d8a6fa7d7d448342e25c13.16MEVK Vault eWETH-1, EVK Vault eezETH-1, EVK Vault eweETH-1, Wrapped Ether
    5
    0xa6086e3190c145f1b6b089de98b1866296137a502.76MEVK Vault eWETH-1, EVK Vault eezETH-1, EVK Vault eweETH-1, Wrapped Ether
    6
    0x5c0642fe68fc72cf03f676b28faf5cf97cc0b2652.22M
    EVK Vault eWETH-1, EVK Vault ersETH-1, EVK Vault eweETH-1, EVK Vault ews...
    7
    0xfc88e456b3a5620e63a449ce429dccf2687cac262.00M
    EVK Vault eWETH-1, EVK Vault ersETH-1, EVK Vault erswETH-1, EVK Vault ew...
    8
    0xe641e37ea4846374c4b9347af6a4979acae79cbc1.77MEVK Vault eWETH-1, Wrapped Ether
    9
    0xacae46375cef811bab8f3d572b2dab327085c6091.61MEVK Vault eWETH-1, EVK Vault eweETH-1, Wrapped Ether
    10
    0x5f2e4398fbc8fc5a58a785d6e289c52bff5805161.58MWrapped Ether
    10
    1KB
    2s