0xtoshi2024-06-06 04:57 AM
Updated 2024-06-06
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
('0x4692b3f52ffe2c6bc8ecda0b72c9d7e3b7488748'),
('0x4623f784affe22a40d5e7aa5fbb771598118dec0'),
('0x4d211395d94767b8c42c760030a494ede5c1d519'),
('0xfc3603640f03980c3142d1d79c31ab194278f711'),
('0x1acb54d9032c95c399a7c25749c9b7eebc7a3956'),
('0xf29b583d1f83f8e88ca67d4951e959826f5450ff'),
('0x3e448f24abd62b74d967779542701b1f4ab3e06a'),
('0xa8381d486a4aa25dca0202d665e7fc5dc23878d6'),
('0x7ac7331c5654d28dfdf1fca36b437f25f0577e6d'),
('0x9e3567f0609d20e2723b9694ebf81c56eb040850'),
('0x0b0691cae58d6a9aa409cb7b413d3bc71072ca4d'),
('0x035d73c17974579a2ee816297a44c2718b7c83b4'),
('0x48422036a126731b6449a542b8ee50aa62e61ebb'),
('0x28901f9fcd4b6e434163ea87f8e94cd62b8139c8'),
('0x01d8ed4eb27599678930e1b555d8377ad7fc8205'),
('0xec6b77ee5a87e4bc68349f607042d3947a6276d1'),
('0x575362c788c68acdb2ee2a3152fd3ebeea6e4237'),
('0x52de4bc89f1720206cf474dea93c5eaff20abdba'),
('0x9cc5b33c92c77d987fc14e627bbc994b1bed41f6'),
('0xaebc6be9ea7f4ca5571975b53ac942bb25661c89'),
('0x05bf86a746be0997470b70d1c1b1b35b184bc23c'),
('0x2bc26bcbe02a79789e0b07a0d67834ddf46f2ef9'),
('0x05ad9e0b644ef2d724fc2aa3ff972f7391a9616f'),
('0xd90f5f072b696d80a5bb319ec2a74fbb9b284295'),
('0x85738941acf9371904b336ecf253dd69668b14fd'),
('0x3ac6d71eca435a6a09a6728a2fe9aa5f35a9b05b')
) 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