0xtoshi20185_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
('0xf5f4fea81dc3f3108008ae5a8500d8de8019b9ed'),
('0x36b793ed18676841d7ebd3a1e922737ec254f058'),
('0xc8cc27d401a6e77a5a0083e60f2bd10920d1e659'),
('0x8f1ec1fd71d55d27902378bbaf188c525a62934b'),
('0x9fab8ca99e70fbcd9aa0b0ff674e415e5408c51d'),
('0x8728e662d1e309af43ca071f564a58bcf3b662d4'),
('0xeb898157edb52da3890ba879bf222992638161a6'),
('0xe28fa84e4e3766004e2b0bd2120605cf21730703'),
('0xddb57b18bb59d46138d56cb5b237a5f71e143d76'),
('0x0c196d20197ed2f16bb40fc74002fb8b0c82ebc9'),
('0x53da7c790f411038866eb0e1b8abf4a3ee24478e'),
('0xcfddc3c211ef45f4dd866c77e9433e40cbcef40d'),
('0xc659ece192c9f14d41fbd1dd862c8afceb3e755e'),
('0x292e5c6afc37ac3663aef19df933102a5c3e26a0'),
('0x115f3ed2fe3475b38c55bd3d88e022372aaf9f77'),
('0x776be974aea3db4d9eae715c52fc3a2d8d1f94d5'),
('0x9952e722e1d1bdc6b86a224cdc364f3008f723c7'),
('0xf9c54997fb98cd790c971cecb31fc39608705df4'),
('0xad2e89fdd43c94144316215e00e8ebbbcb7e62e5'),
('0xb938b54731dc48c207a5663048cead9e02831f27'),
('0x5f8ee4be1b2ad5dbee2713139977eb57c38645ae'),
('0x35de1997cb6bbe220c277e383a2c54efaa1e207c'),
('0x18efe73ac5f8a4d9e8b62f9c012a1408bbcade6e'),
('0xba6a49bc1e5bc95f79ee965a405c4e63dbcf30b6'),
('0x19b9b10fa2c267620551adfabcbd7de2485edb2c'),
('0x80ac1a53ed84c37e9607d820a8d4b42d0f08a2f8'),
('0xec3386ce6072847a8c440e3106c3b7c735974f5a')
) 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
QueryRunArchived: QueryRun has been archived