0xtoshi22138_lz
    Updated 2024-06-07

    With Cluster as (
    SELECT * FROM (VALUES
    ('0x1f9dba195bb560d495909b7fcc176530e370750c'),
    ('0x070edb963d3040a94d04ffe50edbf0fe7a9e74dd'),
    ('0x14a9cb8c4275f47b5787c2b5e61045b68917fbcc'),
    ('0x2b6643726bab31b9eb8539992c2ce19b59bfc667'),
    ('0x25e6e337c926817beb5bb0d1c9e71ccb5b825dbc'),
    ('0x332ad7e960b1c94ad1fbd28c1a5d22b0676b4819'),
    ('0x4a9b109fe6926043e252f8cfaa3437f1bdcd5e64'),
    ('0x33dcf4123d645e1aebed00744b59ae1f79a7fa6d'),
    ('0x595b786088cd11df4fbf98297d99fb1349d65736'),
    ('0x581fd1cd575c2c43cefca850e051523c28b29999'),
    ('0x55cbfdfe4f98b759944aee681ce63febc03bd4fa'),
    ('0x68607080d632fa1258f417fdd6fbfad8713c49a1'),
    ('0x67dc4b9e7b8da25802637b2768fde4d499f221d1'),
    ('0xab1c4b18692ed87e3e1ff4dca781880230d10dcd'),
    ('0xc382a8a489ff188e780d8317ff195d0ccb9ed19c'),
    ('0xbe6873dec2a046bcd506c07acc1ec6182e08855a'),
    ('0xc1cd86656293c393263b820e537bb754e87eca68'),
    ('0xbc53a743af1df1a4f8e050debd50576990c1029d'),
    ('0xc9da284afb7c66cf834bb7e7698ea5a0223be256'),
    ('0xc667ca387de9d28ef46698520132b79bcaf4b02e'),
    ('0xc3d869bc4e43f858544b7ab2abd468974cc1fe84'),
    ('0xc71de3fc1e832046d44ebd1562c121242750f938'),
    ('0xddfc4f28e3f0af3b538917ede09585612cacbbc9'),
    ('0xcdb069a67b91c70477e51645d8f0c5f039612ae0'),
    ('0xf5f167f6c3a2bc496642a62350f351d09aaf8740'),
    ('0xf24e8a301b0e009ea8adf8f0a324b1fcb16add04')
    ) 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