0xtoshi22647_lz
    Updated 2024-06-07

    With Cluster as (
    SELECT * FROM (VALUES
    ('0x92591b4a29a85eb838def726cfd22566a152d4ac'),
    ('0x4f6b4e995bb35956a0d8d1e2a40f803cec20d7dc'),
    ('0x616a9bd8eb54a50ca3a4a514c6e7c2b6feeab02f'),
    ('0x7c7f7798344ee020e365ad90388d5af1be87e4c7'),
    ('0xc573d78d19adcb16faa6ec928d3e3a7ebe407b0a'),
    ('0xb131021ae67e3ae95c2a5d14508a8863dbd66320'),
    ('0x12b2ce497bfbf0d969502b78e32d832eb7143bf3'),
    ('0x14d0fa4084dded4ce6914ef8e69ac8e678f7dada'),
    ('0x350bdcef12b6227bb53e42b75d9b5b14d575c6a6'),
    ('0x3bbc1355ad09b08846804c30bcb8939362c5e31c'),
    ('0x20bb0b7d501b3358018f2d24316f15bd2f83da9c'),
    ('0x4ce138d24a859e3da8898387f7f7bc1e080e7c72'),
    ('0x3dc04f67ee5f31444f32d33d340ac950aa5c887a'),
    ('0x4fca8064ce24c44f91af258cc7a104f55504ebd1'),
    ('0x40cd9efe07a3b399321f39ab40569cc093c63512'),
    ('0x56d7b5fc5f942014261408cdabbcc83c3f2b217a'),
    ('0x542b3cb698b64440605d76a2e279f29cfbd85fee'),
    ('0x710e37818b5223366b7f590f5e1a6a976921d6c3'),
    ('0x579122fee6cebd8a8b36c2108ac64f744bef2051'),
    ('0x843171116e7b1a8b32735886644446cecb32f1ab'),
    ('0x96e69b7e083bdc0eda77b1a615da42d99585b495'),
    ('0xb8c7be152479fd079713fb9f235f0e342bc39cb8'),
    ('0x9e93fdf64e2bdf78273ad8da5f3dad382ec49c32'),
    ('0xbedc02c0ec6c7c10d38bfa266ffd2f08e18352ba'),
    ('0xe458b68d9617dce26c9e3337553a2bcbff94a01b'),
    ('0xccf96f702936c9663ad595f8d00fd7b86783f17d')
    ) 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