0xtoshi2024-06-15 10:53 AM
    Updated 2024-06-15
    WITH FirstTransactions AS (
    SELECT SENDER_WALLET, SOURCE_TIMESTAMP_UTC,
    ROW_NUMBER() OVER (PARTITION BY SENDER_WALLET ORDER BY SOURCE_TIMESTAMP_UTC ASC) as row_num
    FROM external.layerzero.fact_transactions_snapshot
    )
    SELECT DISTINCT SENDER_WALLET, SOURCE_TIMESTAMP_UTC
    FROM FirstTransactions
    WHERE row_num = 1
    AND SOURCE_TIMESTAMP_UTC <= '2023-03-15 23:59:00.000'
    ORDER BY SOURCE_TIMESTAMP_UTC ASC
    QueryRunArchived: QueryRun has been archived