freemartianWayfinder Deposite
    Updated 2025-01-10
    -- extend deposit: 0xe8b824d4a7b47a24643b9f6737631ac4f491521d5961f8f08ba12ad18341c426 => signature: 0xb1adef79
    -- withdraw deposit: 0xa153cc7a83d8cf449e825323bb6e90e0a7a82745f1f126769405dd2be7afa20a


    WITH prices AS(
    SELECT
    hour::date AS price_day,
    AVG(price) AS price
    FROM ethereum.price.ez_prices_hourly
    WHERE token_address = '0xb23d80f5fefcddaa212212f028021b41ded428cf'
    AND hour::date >= '2024-06-01'
    GROUP BY 1
    )


    SELECT
    block_timestamp,
    tx_hash,
    decoded_log:user AS user,
    decoded_log:amount / pow(10,18) AS amount,
    to_timestamp(decoded_log:createdTimestamp) AS createdTimestamp,
    to_timestamp(decoded_log:endTimestamp) AS endTimestamp,
    DATEDIFF(DAY, createdTimestamp, endTimestamp) AS difference_in_days,
    decoded_log

    FROM ethereum.core.ez_decoded_event_logs
    WHERE contract_address = '0x4a3826bd2e8a31956ad0397a49efde5e0d825238'
    AND event_name = 'DepositCreated'
    AND block_timestamp::date >= '2024-06-01'



    -- AND user = '0x0c335fdaa592aa261e4c345754fc498b28274a0d'

    ORDER BY 1 ASC

    Auto-refreshes every 1 hour
    QueryRunArchived: QueryRun has been archived