zakkisyedUser Metrics Leaderboard
    Updated 2024-05-09
    -- forked from Raw Deposit Data @ https://flipsidecrypto.xyz/edit/queries/68dd6cf3-e5f3-4803-92e0-c572b8a4ba67

    with eth_deposits as (

    select block_timestamp,
    decoded_log:depositor as user,
    'ETH' as asset,
    decoded_log:depositAmount/pow(10,18) as deposit_amt,
    tx_hash
    from ethereum.core.ez_decoded_event_logs
    where contract_address = '0x036676389e48133b63a802f8635ad39e752d375d'
    AND event_name = 'ETHDeposit'
    AND block_timestamp >= '2024-05-08 04:30:00.000'
    ),

    lst_deposits as (

    select block_timestamp,
    decoded_log:depositor as user,
    CASE WHEN decoded_log:asset = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' THEN 'stETH'
    WHEN decoded_log:asset = '0xa35b1b31ce002fbf2058d22f30f95d405200a15b' THEN 'ETHx'
    WHEN decoded_log:asset = '0xac3e018457b222d93114458476f3e3416abbe38f' THEN 'sfrxETH'
    END AS asset,
    decoded_log:depositAmount/pow(10,18) as deposit_amt,
    tx_hash
    from ethereum.core.ez_decoded_event_logs
    where contract_address = '0x036676389e48133b63a802f8635ad39e752d375d'
    AND event_name = 'AssetDeposit'
    AND block_timestamp >= '2024-05-08 04:30:00.000'
    ),
    raw_data as (
    select * from eth_deposits
    UNION ALL
    select * from lst_deposits
    ORDER BY 1 desc
    )
    QueryRunArchived: QueryRun has been archived