0xtoshi21930_ethereum
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
('0x23432ecf78a1759985daf1b987e3af34855b59d5'),
('0x0e43c88dc92ed379c106c4bc450dffb5bf90b5d3'),
('0x2aee41c6405b996f129069eae8341638ff5f943a'),
('0x411e29f2a1612cb2e8808d86ed5e1de855afa459'),
('0x3c4a8797381c84fe5b71980b4d1d24ea6153855a'),
('0x55ca28c045148561bb945e99a4e689d461aa45b2'),
('0x4584b18269c893ac754a1ec3fca166b52a898faa'),
('0x4c42ba2ed5dacbaa850e42675db3a437b02cb0a0'),
('0x8397fdcb9986673ed59b341a7f75e861b28c2230'),
('0x984d157e0165e8e367d4dff6872a5183e81fc48f'),
('0xbecad4c454ff786e567c6f48269f77d1ccf9c651'),
('0xae48692d9de7229f694144bdd9065a5c757e0320'),
('0xbb2bb3653e79f9c9b6877bae078f0c94294b93ab'),
('0xbf4ead3d28e80135fb252abb7747588cf7eb89ef'),
('0xc93fbfacea52164cad861b7660f32ad843e6248b'),
('0xe69c3d02dd6b5ec020e44897413d5c56567e657b'),
('0xf8abbd9a8b3c9c65feacac987efe5840b9ef79eb'),
('0x16566ee6d21f1dbe4d2c1a686c1c9382446b1525'),
('0x3e1581f29c335db342e2aeddd4d7c767bc008732'),
('0x3166800245120a1914ad955709c881403bc4295c'),
('0x47347af9bfd05d45b9438ea26cf5a00be15c0965'),
('0x7f8e49ecb45ec8a94bf4c36aefb34c27f4669b16'),
('0x7f62831a33333d242a463283e943b1295f40b35d'),
('0x681d05ba3b9fa339b49e30c68dc46b5c566667e7'),
('0x80f988a2bafa22b0f72f7df5083043552052df14'),
('0xcc551d7869fe7eb91b5816c4df6f19f0ea2dac7d'),
('0xcee775b8de5514ad9beb206d31b86b04addd2bc9'),
('0xcc8f11b5c2923a0b049324ae487f4e869ededbfb'),
('0xe2c9f28e69df44abaa705464b13b8ef11b60d064')
) t(address) )
SELECT FROM_ADDRESS,
DATE_TRUNC('week', BLOCK_TIMESTAMP) as txdate,
ZEROIFNULL(COUNT(TX_HASH)) as numOfTX
FROM ethereum.core.fact_transactions
QueryRunArchived: QueryRun has been archived