zakkisyedUser Distribution based on deposit amount
    Updated 2024-01-22
    WITH blast_deposit_indexer AS (
    SELECT
    block_timestamp,
    tx_hash,
    event_name,
    decoded_log:amount / POWER(10, 18) AS amount,
    decoded_log:shares AS shares,
    decoded_log:user AS user,
    CASE
    WHEN event_name = 'USDDeposited' THEN decoded_log:daiAmount / POWER(10, 18)
    ELSE 0
    END AS dai_amount,
    CASE
    WHEN event_name = 'ETHDeposited' AND ORIGIN_FUNCTION_SIGNATURE = '0x3265aead' THEN 'stETH'
    WHEN event_name = 'ETHDeposited' AND ORIGIN_FUNCTION_SIGNATURE = '0xf6326fb3' THEN 'ETH'
    WHEN event_name = 'USDDeposited' AND ORIGIN_FUNCTION_SIGNATURE = '0x365833e1' THEN 'DAI'
    WHEN event_name = 'USDDeposited' AND ORIGIN_FUNCTION_SIGNATURE = '0xf688bcfb' THEN 'USDC'
    WHEN event_name = 'USDDeposited' AND ORIGIN_FUNCTION_SIGNATURE = '0x0a553dcb' THEN 'USDT'
    WHEN event_name = 'ETHDeposited' THEN 'ETH'
    WHEN event_name = 'USDDeposited' THEN 'DAI'
    END AS token_type
    FROM ethereum.core.ez_decoded_event_logs
    WHERE contract_address = '0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d'
    AND block_timestamp > '2023-11-17'
    AND event_name IN ('USDDeposited', 'ETHDeposited')
    AND tx_status = 'SUCCESS'
    ),
    eth_prices_hourly AS (
    SELECT
    symbol,
    price,
    hour
    FROM ethereum.price.ez_hourly_token_prices
    WHERE hour >= TIMESTAMP '2023-11-17'
    AND symbol = 'stETH'
    AND token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    QueryRunArchived: QueryRun has been archived