CartanGroupPolygon Retrospective | Unique Active Users by SPECIFIC label copy
    SELECT
    DATE_TRUNC('{{period}}',block_timestamp) as date,
    COUNT(DISTINCT TX_HASH) as number_transactions,
    COUNT(DISTINCT from_address) as unique_active_users,
    number_transactions/unique_active_users as txns_per_user,
    SUM(TX_FEE) as transaction_fees,
    AVG(gas_price) as avg_gas_price,
    transaction_fees/unique_active_users as fees_per_user,
    transaction_fees/number_transactions as fees_per_txn,
    CASE
    WHEN to_address = '0x2ab0e9e4ee70fff1fb9d67031e44f6410170d00e' THEN 'mXEN (XEN Crypto)'
    WHEN to_address = '0x55dfa13f7e409560ea7d774f82bdcb90c2222222' THEN 'MATIC Disperser Wallet'
    WHEN to_address = '0xf267a44c2d07009b3fabca7a6f4acc5c584d7f50' THEN 'XEN + Duckies Wallet'
    WHEN to_address = '0xffb9f1907f827709b0ed09b37956cd3c7462abdb' THEN 'DUCKIES (Yellow Duckies)'
    WHEN to_address = '0x161201cc373f2df382fb6e74ba09244eecee2b1d' THEN 'Exit wallet fund funnel'
    WHEN to_address = '0xe6f1d4eef6ea4cf5ae53eb13549ef52849d5dca3' THEN 'Benji Bananas'
    when to_address = '0xf231be40d73a9e73d859955344a4ff74f448df34' then 'Zapper.Fi: Quickswap Zap In'
    when to_address = '0xDef1C0ded9bec7F1a1670819833240f027b25EfF' then '0x: Exchange Proxy'
    when to_address = '0x8DfDea6A4818d2AA7463edB9A8841cB0c04255aF' then 'Zapper.Fi: Aave Zap In'
    ELSE 'Normal Activity'
    END AS label
    FROM polygon.core.fact_transactions as transactions
    WHERE block_timestamp::date < CURRENT_DATE -- today's date is never complete. Please stop showing it, people :)
    GROUP BY date, label
    ORDER BY date DESC


    Run a query to Download Data