0xtoshi21930_ethereum
    Updated 2024-06-07
    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