0xtoshicluster8e
    Updated 2024-06-06
    With Cluster as (
    SELECT * FROM (VALUES
    ('0x5de510263fdc5236c034aa7b23c3a61e053691de'),
    ('0xfa40d296a89d4469f893adf187d685abee336d39'),
    ('0x3c0211973468c63dfee25eb05b0ffa45cc891ea9'),
    ('0x94b8034a4d30cf40d26839ee59cac00f9f0b7e5f'),
    ('0x6792fcd346f9fbc8c99a92980138981af6f53b09'),
    ('0x1aea871fe3ffe8852c7fd4b1d6eae9767d47a4bc'),
    ('0xee2bad7c82e80d75cd2582880342bd329e37e677'),
    ('0x76f463c09774dde3b874a35b003942cb8e27c70b'),
    ('0x044434ea6918fe13262a9ea58a8c882af51ab971'),
    ('0xf4713a2e7ed226bd8902681ea548f2c37f2833c8'),
    ('0xd92e09f09e3d8b9ad6b85dea7cbd190c334f7df1'),
    ('0xb53c36743390b780a72685064a62ce964b9a7eff'),
    ('0x48a2b66f5800be1805ed2e489ad6e5e7f8dc20a3'),
    ('0xd80e912e05c61711466f9bbe8ef656ff0d5ac83a'),
    ('0x019bad383053ca94f6b4c9d9d6e15925e6cbc74d'),
    ('0x850e9d09be7cb0dac96ad5afd28791226867f176'),
    ('0xd2c4bde6b4199b592ffec4548a98d56aaf6c76ae'),
    ('0xc26490cb286914dedf17058b2ef91c20f7188321'),
    ('0x1382a25998e929fd5daa757a96429180ee32dfa2'),
    ('0xa26289fb1f49a20efc5fbe0a35d47702e6c8d6e0'),
    ('0x5d1d4036048b6bc3e59001b3c48f067b2dc5e32b'),
    ('0x8e0c6ef8d94d247471399b2368c789cf65f9ce6b'),
    ('0xbcfd6545dbc9e7f9f0f811eaf7e9b8c17e619fe2'),
    ('0xfc9d1851edc15eb1f6482b39e16b6b5b6d265e9f'),
    ('0x0e83e575764818a7844efc86bec423379dc48d50'),
    ('0xa7b9b2e23b7560f610d9e6e88af7b342755be61b'),
    ('0xc43b8f7f6bc44effffd1257aed4df4986ecab361')
    ) t(address) )
    SELECT FROM_ADDRESS,
    DATE_TRUNC('week', BLOCK_TIMESTAMP) as txdate,
    ZEROIFNULL(COUNT(TX_HASH)) as numOfTX
    FROM ethereum.core.fact_transactions
    WHERE FROM_ADDRESS IN (SELECT address FROM Cluster)
    GROUP BY 1,2
    QueryRunArchived: QueryRun has been archived