0xtoshi2024-06-15 10:53 AM
Updated 2024-06-15
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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