0xtoshi2024-06-06 04:57 AM
    Updated 2024-06-06

    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