NakedCollectoradvisory-violet
    Updated 2024-08-19
    WITH date_range AS (
    SELECT DATEADD(week, -12, DATE_TRUNC('week', CURRENT_DATE())) AS start_date,
    DATE_TRUNC('week', CURRENT_DATE()) AS end_date
    ),
    weekly_token_activity AS (
    WITH tokens AS (
    SELECT contract_address, symbol FROM (
    SELECT '0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599' AS contract_address, 'WBTC' AS symbol
    UNION ALL SELECT '0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2', 'WETH'
    UNION ALL SELECT '0x582d872a1b094fc48f5de31d3b73f2d9be47def1', 'TON'
    UNION ALL SELECT '0x85f17cf997934a597031b2e18a9ab6ebd4b9f6a4', 'NEAR'
    UNION ALL SELECT '0x2c89bbc92bd86f8075d1decc58c7f4e0107f286b', 'AVAX'
    UNION ALL SELECT '0x4e15361fd6b4bb609fa63c81a2be19d873717870', 'FTM'
    UNION ALL SELECT '0xb8c77482e45f1f44de1745f52c74426c631bdd52', 'BNB'
    UNION ALL SELECT '0xe28b3b32b6c345a34ff64674606124dd5aceca30', 'INJ'
    UNION ALL SELECT '0x514910771af9ca656af840dff83e8264ecf986ca', 'LINK'
    UNION ALL SELECT '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984', 'UNI'
    UNION ALL SELECT '0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2', 'MKR'
    UNION ALL SELECT '0x5a98fcbea516cf06857215779fd812ca3bef1b32', 'LDO'
    UNION ALL SELECT '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9', 'AAVE'
    UNION ALL SELECT '0x808507121b80c02388fad14726482e061b8da827', 'PENDLE'
    UNION ALL SELECT '0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f', 'SNX'
    UNION ALL SELECT '0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0', 'FXS'
    UNION ALL SELECT '0xd533a949740bb3306d119cc777fa900ba034cd52', 'CRV'
    UNION ALL SELECT '0xb50721bcf8d664c30412cfbc6cf7a15145234ad1', 'ARB'
    UNION ALL SELECT '0x4200000000000000000000000000000000000042', 'OP'
    UNION ALL SELECT '0xca14007eff0db1f8135f4c25b34de49ab0d42766', 'STRK'
    UNION ALL SELECT '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0', 'MATIC'
    UNION ALL SELECT '0x3c3a81e81dc49a522a592e7622a7e711c06bf354', 'MNT'
    UNION ALL SELECT '0xf57e7e7c23978c3caec3c3548e3d615c346e79ff', 'IMX'
    UNION ALL SELECT '0x95cef13441be50d20ca4558cc0a27b601ac544e5', 'MANTA'
    UNION ALL SELECT '0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad', 'BLAST'
    UNION ALL SELECT '0xdfc7c877a950e49d2610114102175a06c2e3167a', 'MODE'
    UNION ALL SELECT '0x6810e776880c02933d47db1b9fc05908e5386b96', 'GNO'
    UNION ALL SELECT '0x5c147e74d63b1d31aa3fd78eb229b65161983b2b', 'FLOW'
    UNION ALL SELECT '0x5a7d6b2f92c77fad6ccabd7ee0624e64907eaf3e', 'ZK'
    QueryRunArchived: QueryRun has been archived