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