cryptodatadiveWithdrawal Volume Per Asset
    Updated 2025-04-06
    WITH Withdraw_CTE AS (
    SELECT
    contract_name,
    contract_address,
    origin_from_address AS withdrawer,
    (decoded_log:assets::int) AS withdrawal_amount,
    tx_hash,
    date_trunc('day', block_timestamp) AS withdrawal_date
    FROM swell.core.ez_decoded_event_logs
    WHERE event_name = 'Withdraw'
    ),

    Withdrawal_CTE AS (
    SELECT
    contract_name,
    contract_address,
    origin_from_address AS withdrawer,
    (decoded_log:wad::int) AS withdrawal_amount,
    tx_hash,
    date_trunc('day', block_timestamp) AS withdrawal_date
    FROM swell.core.ez_decoded_event_logs
    WHERE event_name = 'Withdrawal'
    ),

    prices AS (
    SELECT
    LOWER(symbol) AS symbol,
    date_trunc('day', hour) AS price_date,
    price,
    decimals,
    ROW_NUMBER() OVER (PARTITION BY LOWER(symbol), date_trunc('day', hour) ORDER BY hour DESC) AS rn
    FROM ethereum.price.ez_prices_hourly
    WHERE LOWER(symbol) IN ('swell', 'weth', 'usde', 'ena')
    ),

    filtered_prices AS (
    Last run: 21 days ago
    CONTRACT_NAME
    TOTAL_WITHDRAWAL_TRANSACTIONS
    TOTAL_WITHDRAWALS_USD
    1
    EVK Vault eWETH-139414248292.0135335
    2
    EVK Vault eweETH-112911994197.1740786
    3
    Wrapped Ether1435610597371.3697604
    4
    EVK Vault eezETH-1743543043.6798312
    5
    EVK Vault epzETH-1332797679.2970735
    6
    EVK Vault eswETH-126546052.805657292
    7
    EVK Vault ewstETH-167496754.289864118
    8
    EVK Vault ersETH-151490466.865845089
    9
    EVK Vault erswETH-146312814.515118876
    10
    tsWeethRsETH830998.123737646
    11
    tsRSwellSwell1114480.093416477
    12
    tsRswethWeeth29205.226203634
    13
    tsPzethEzeth63705.767280876
    14
    tsEnaUsde8465.682742166
    15
    EVK Vault eWETH-2180.5227
    16
    tsSwellETH60.03233670771
    16
    621B
    4s