0xtoshi19234_cluster1_lz
    Updated 2024-06-07
    With Cluster as (
    SELECT * FROM (VALUES
    ('0x09611908de174194a531092b0e0dcc1f307dc204'),
    ('0xb8c1a3598f2447fb89013b4d01567d6373b1545e'),
    ('0xce20764b48a33f2fddeedd9c670f1d925a31e47a'),
    ('0xadc3a523ad0d5d340fd55b4f8d89ecdb3e871ea2'),
    ('0x0ae65f8973fe15ee76ba5977d3bd4615a08a5ddb'),
    ('0xbdb03fe18f034d9ebdbf1f160e7beaa1b2be7953'),
    ('0x43a410d8a3e59a80f0300904790639a657357beb'),
    ('0x02e35e5db74b08cc0b69990c58927b0db0a208e6'),
    ('0xe20c229070c2ccd8ff845e1ee7afe5b78ad64456'),
    ('0xced4e9791b9999f21ae5c7156301573f879a21b8'),
    ('0x31ddd74ca05a300d2ffe68b19e37579b04a03611'),
    ('0xcfc12dd7afa7380161a0fb34cd64c96f3e28199a'),
    ('0x65e707ae32eeefac312256f4237b74bcc18c8302'),
    ('0x55f1bf84f573468ffbda48645e8b9b535d7115dd'),
    ('0x557e16af067e7539a960fe62c0e29df7e77d8b6e'),
    ('0x0bbf81b564dca9de2f381149a8864b6aac7210d4'),
    ('0x0ca91400105580f63efc8e167d164e95a24f80b9'),
    ('0x1f6c175c2204ea5c045384d7b36b20dbff560d39'),
    ('0x07ed35c52bc54346b543e21726e7811e2a16d40b'),
    ('0x673bb749aa7ddb196b962b59e4db8050d6745650'),
    ('0xd5519507201ea97e792004bdcae25ca51b8b6f2e'),
    ('0x5805fc204da8ef17adcac3626e534d3fa641eb71')
    ) 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
    ORDER BY 2 ASC


    QueryRunArchived: QueryRun has been archived