0xtoshi19615_layerzerograph
    Updated 2024-06-08
    With Cluster as (
    SELECT * FROM (VALUES
    ('0x34d5fc2063476d727fd2884b221426aeb0bb0022'),
    ('0x4b202293b10a058ac343b56542db74957e2fd932'),
    ('0x85e52888aaf58eaa756a9e37aeec1612eb0b0c8e'),
    ('0xa73409ea79eb5d41c27b6dce5f43f204d4490fd9'),
    ('0x881271dcee392eca0d2d1981e6605a68b6656831'),
    ('0xccff7079e2ec34b96a03179a57be736d2f0bbe06'),
    ('0x6961a934e26a3f242b7508c8fefc1816071809e2'),
    ('0x6cce840a40e5f58bcc770854c06494e3217bb8d8'),
    ('0xbbec5fbb93bb77d5b6bb25f12d5d754b09f6eb3f'),
    ('0x6534f60a680b288a9d21706b71eb9ad23147f0c9'),
    ('0xab7641d556e206bd07999bff9aa1b7fe8673f1fa'),
    ('0xcca1320c7c5591fa6b19c03b2aa46ede2c058005'),
    ('0x5b618ac12b9793613d6bfc884da3d1d811a90656'),
    ('0xae100dda3a48c208555967762e3909f045947398'),
    ('0xc81ad655a8ba547c21f51affa7bba5eaeb710e4a'),
    ('0x4f93ee60fc882daca613568eb6db9f7625bac6bf'),
    ('0x81263659a65462a129e0a0a90132698b3682cb39'),
    ('0xc6ce5e7a377cd2ec97656f639e5a723900926970'),
    ('0x91f000a3738df5580e0dd0649d63dffd14f5d3d8'),
    ('0xf19ee4a7f847467e4a8fcdc061f328690be84633'),
    ('0xfff06745385c448ccdd95144e8c15de06f393cc5'),
    ('0x1d7fc2169be969787cb000f7e2177159a2c72d25'),
    ('0x2552266675d0e1e0d1fa1b8f11fd5570791d8bfc'),
    ('0x327cef607846c7a28c910b72877ac4bcc57ede65')
    ) 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