0xtoshi19234_cluster1_lz
Updated 2024-06-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
With Cluster as (
SELECT * FROM (VALUES
('0x09611908de174194a531092b0e0dcc1f307dc204'),
('0xb8c1a3598f2447fb89013b4d01567d6373b1545e'),
('0xce20764b48a33f2fddeedd9c670f1d925a31e47a'),
('0xadc3a523ad0d5d340fd55b4f8d89ecdb3e871ea2'),
('0x0ae65f8973fe15ee76ba5977d3bd4615a08a5ddb'),
('0xbdb03fe18f034d9ebdbf1f160e7beaa1b2be7953'),
('0x43a410d8a3e59a80f0300904790639a657357beb'),
('0x02e35e5db74b08cc0b69990c58927b0db0a208e6'),
('0xe20c229070c2ccd8ff845e1ee7afe5b78ad64456'),
('0xced4e9791b9999f21ae5c7156301573f879a21b8'),
('0x31ddd74ca05a300d2ffe68b19e37579b04a03611'),
('0xcfc12dd7afa7380161a0fb34cd64c96f3e28199a'),
('0x65e707ae32eeefac312256f4237b74bcc18c8302'),
('0x55f1bf84f573468ffbda48645e8b9b535d7115dd'),
('0x557e16af067e7539a960fe62c0e29df7e77d8b6e'),
('0x0bbf81b564dca9de2f381149a8864b6aac7210d4'),
('0x0ca91400105580f63efc8e167d164e95a24f80b9'),
('0x1f6c175c2204ea5c045384d7b36b20dbff560d39'),
('0x07ed35c52bc54346b543e21726e7811e2a16d40b'),
('0x673bb749aa7ddb196b962b59e4db8050d6745650'),
('0xd5519507201ea97e792004bdcae25ca51b8b6f2e'),
('0x5805fc204da8ef17adcac3626e534d3fa641eb71')
) t(address) )
SELECT SENDER_WALLET,
DATE_TRUNC('week', SOURCE_TIMESTAMP_UTC) as txdate,
ZEROIFNULL(COUNT(SOURCE_TRANSACTION_HASH)) as numOfTX
FROM external.layerzero.fact_transactions_snapshot
WHERE SENDER_WALLET IN (SELECT address FROM Cluster)
GROUP BY 1,2
ORDER BY 2 ASC
QueryRunArchived: QueryRun has been archived