0xtoshi22292_lz
    Updated 2024-06-07

    With Cluster as (
    SELECT * FROM (VALUES
    ('0x14dafb5e74ca175f70db28235ad9a56bb15c3b82'),
    ('0x0087727fdc2209e27f632c390c6f03b8110e2183'),
    ('0x14cb910bd50ed9fce3a913f806569e3f0ed1b756'),
    ('0x29a77da61013bc3100e518af4eeba88d7d7341af'),
    ('0x158ac037ff33bc1df6878bc605a6cad1f378886a'),
    ('0x1f3da08ceae0f576a46be6857814cc56ae1ad2e5'),
    ('0x319bacaecd4b0daad5d6b2ccd3d693610a2f35e8'),
    ('0x17177177e35cb7b41f1fa35c516b4a0790faf3a6'),
    ('0x45a8209ab0e224e72bbd3dbd6fed69e39a14d128'),
    ('0x3af00711e67b59df07d6e09e3a35449d8f018ed2'),
    ('0x3ac98827ea81e9997e032caffc4b11badc29efcc'),
    ('0x5b1586a2530208b6a9ecd69deb2786a3d23683d7'),
    ('0x55c1d1103675fe5d997ab442c7b2d73af631ba4d'),
    ('0x4e7134346bdbee357e2e908bb8af1f8c513913e6'),
    ('0x45ba56852ac596640355e9090db2594375f66180'),
    ('0x67907b2c56cca687f95a3bcf270bd1ba1111b566'),
    ('0x80ca4448af6958e5d099df87cb235f4d18d2e011'),
    ('0x711f8e79aa6b26a1630ed7db6883a1f61abd839b'),
    ('0x69c5997833809b77b2812bc94e36dd9af823aa22'),
    ('0x61d1427bde2b012f6ae29c94ff984119ebe53434'),
    ('0xdabff04875bf9b9394c5ac1ca092e2341836b42a'),
    ('0x90e8a79b1a84398988be39ced94a31ca3a2936b5'),
    ('0xe04ba2c6cc7c37ff4a7c75714af999cd490fed56'),
    ('0x8aeb280b3e4fbce93148beae79f1a86d50a2e5a0'),
    ('0xe676399abe195b36322a3e50412ddd04fc53a382'),
    ('0xeb4c0db62d1013fded992847ac14d3dc309c28b9'),
    ('0xf8786bbb5f642d43e8cec794641851dd3f47fda2'),
    ('0xefb3d87346ac7804131809cae090545f31b044b6')
    ) 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
    QueryRunArchived: QueryRun has been archived