0xtoshi20185_cluster1_lz
    Updated 2024-06-07
    With Cluster as (
    SELECT * FROM (VALUES
    ('0xf5f4fea81dc3f3108008ae5a8500d8de8019b9ed'),
    ('0x36b793ed18676841d7ebd3a1e922737ec254f058'),
    ('0xc8cc27d401a6e77a5a0083e60f2bd10920d1e659'),
    ('0x8f1ec1fd71d55d27902378bbaf188c525a62934b'),
    ('0x9fab8ca99e70fbcd9aa0b0ff674e415e5408c51d'),
    ('0x8728e662d1e309af43ca071f564a58bcf3b662d4'),
    ('0xeb898157edb52da3890ba879bf222992638161a6'),
    ('0xe28fa84e4e3766004e2b0bd2120605cf21730703'),
    ('0xddb57b18bb59d46138d56cb5b237a5f71e143d76'),
    ('0x0c196d20197ed2f16bb40fc74002fb8b0c82ebc9'),
    ('0x53da7c790f411038866eb0e1b8abf4a3ee24478e'),
    ('0xcfddc3c211ef45f4dd866c77e9433e40cbcef40d'),
    ('0xc659ece192c9f14d41fbd1dd862c8afceb3e755e'),
    ('0x292e5c6afc37ac3663aef19df933102a5c3e26a0'),
    ('0x115f3ed2fe3475b38c55bd3d88e022372aaf9f77'),
    ('0x776be974aea3db4d9eae715c52fc3a2d8d1f94d5'),
    ('0x9952e722e1d1bdc6b86a224cdc364f3008f723c7'),
    ('0xf9c54997fb98cd790c971cecb31fc39608705df4'),
    ('0xad2e89fdd43c94144316215e00e8ebbbcb7e62e5'),
    ('0xb938b54731dc48c207a5663048cead9e02831f27'),
    ('0x5f8ee4be1b2ad5dbee2713139977eb57c38645ae'),
    ('0x35de1997cb6bbe220c277e383a2c54efaa1e207c'),
    ('0x18efe73ac5f8a4d9e8b62f9c012a1408bbcade6e'),
    ('0xba6a49bc1e5bc95f79ee965a405c4e63dbcf30b6'),
    ('0x19b9b10fa2c267620551adfabcbd7de2485edb2c'),
    ('0x80ac1a53ed84c37e9607d820a8d4b42d0f08a2f8'),
    ('0xec3386ce6072847a8c440e3106c3b7c735974f5a')
    ) 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