0xtoshi22138_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
('0x1f9dba195bb560d495909b7fcc176530e370750c'),
('0x070edb963d3040a94d04ffe50edbf0fe7a9e74dd'),
('0x14a9cb8c4275f47b5787c2b5e61045b68917fbcc'),
('0x2b6643726bab31b9eb8539992c2ce19b59bfc667'),
('0x25e6e337c926817beb5bb0d1c9e71ccb5b825dbc'),
('0x332ad7e960b1c94ad1fbd28c1a5d22b0676b4819'),
('0x4a9b109fe6926043e252f8cfaa3437f1bdcd5e64'),
('0x33dcf4123d645e1aebed00744b59ae1f79a7fa6d'),
('0x595b786088cd11df4fbf98297d99fb1349d65736'),
('0x581fd1cd575c2c43cefca850e051523c28b29999'),
('0x55cbfdfe4f98b759944aee681ce63febc03bd4fa'),
('0x68607080d632fa1258f417fdd6fbfad8713c49a1'),
('0x67dc4b9e7b8da25802637b2768fde4d499f221d1'),
('0xab1c4b18692ed87e3e1ff4dca781880230d10dcd'),
('0xc382a8a489ff188e780d8317ff195d0ccb9ed19c'),
('0xbe6873dec2a046bcd506c07acc1ec6182e08855a'),
('0xc1cd86656293c393263b820e537bb754e87eca68'),
('0xbc53a743af1df1a4f8e050debd50576990c1029d'),
('0xc9da284afb7c66cf834bb7e7698ea5a0223be256'),
('0xc667ca387de9d28ef46698520132b79bcaf4b02e'),
('0xc3d869bc4e43f858544b7ab2abd468974cc1fe84'),
('0xc71de3fc1e832046d44ebd1562c121242750f938'),
('0xddfc4f28e3f0af3b538917ede09585612cacbbc9'),
('0xcdb069a67b91c70477e51645d8f0c5f039612ae0'),
('0xf5f167f6c3a2bc496642a62350f351d09aaf8740'),
('0xf24e8a301b0e009ea8adf8f0a324b1fcb16add04')
) 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