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


    SELECT * FROM EarlyUser
    QueryRunArchived: QueryRun has been archived