0xtoshi2024-06-15 09:41 AM
    Updated 2024-06-15
    WITH EarlyUser as (
    SELECT SENDER_WALLET, MIN(SOURCE_TIMESTAMP_UTC) as IntialTransactionDate, SOURCE_TRANSACTION_HASH
    FROM external.layerzero.fact_transactions_snapshot
    WHERE SOURCE_TIMESTAMP_UTC BETWEEN '2022-04-15 00:00:00.000' AND '2023-04-15 00:00:00.000'
    GROUP BY 1,3
    ORDER BY IntialTransactionDate ASC
    )

    SELECT * FROM EarlyUser
    WHERE SENDER_WALLET = LOWER('0x411e6e48670ebd1397c95f71af72318fc65b0a89')

    QueryRunArchived: QueryRun has been archived