NakedCollectorMACRO: Year to Date Price Data (INDEX)
    Updated 2024-09-07
    -- forked from MACRO: Year to Date Price Data @ https://flipsidecrypto.xyz/studio/queries/e8a4a9a9-59cf-4569-8c8e-981a53e67a56

    WITH token_addresses AS (
    -- Benchmarks
    SELECT '0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599' AS address, 'WBTC' AS symbol, 'Benchmarks' AS category
    UNION ALL SELECT '0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2', 'WETH', 'Benchmarks'
    UNION ALL SELECT 'So11111111111111111111111111111111111111112', 'SOL', 'Benchmarks'
    -- Layer 1s
    -- UNION ALL SELECT '0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2', 'WETH', 'Layer 1s'

    --UNION ALL SELECT 'So11111111111111111111111111111111111111112', 'SOL', 'Layer 1s'
    UNION ALL SELECT '0x582d872a1b094fc48f5de31d3b73f2d9be47def1', 'TON', 'Layer 1s'
    UNION ALL SELECT '0x85f17cf997934a597031b2e18a9ab6ebd4b9f6a4', 'NEAR', 'Layer 1s'
    UNION ALL SELECT '0x2c89bbc92bd86f8075d1decc58c7f4e0107f286b', 'AVAX', 'Layer 1s'
    UNION ALL SELECT 'ibc/71F11BC0AF8E526B80E44172EBA9D3F0A8E03950BB882325435691EBC9450B1D', 'SEI', 'Layer 1s'
    UNION ALL SELECT '0x4e15361fd6b4bb609fa63c81a2be19d873717870', 'FTM', 'Layer 1s'
    UNION ALL SELECT '0xb8c77482e45f1f44de1745f52c74426c631bdd52', 'BNB', 'Layer 1s'
    UNION ALL SELECT '0x1::aptos_coin::AptosCoin', 'APT', 'Layer 1s'
    UNION ALL SELECT 'uatom', 'ATOM', 'Layer 1s'
    UNION ALL SELECT '0x2::sui::SUI', 'SUI', 'Layer 1s'
    UNION ALL SELECT '0xe28b3b32b6c345a34ff64674606124dd5aceca30', 'INJ', 'Layer 1s'
    -- UNION ALL SELECT '0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599', 'WBTC', 'Layer 1s'

    -- ETH DeFi
    UNION ALL SELECT '0x514910771af9ca656af840dff83e8264ecf986ca', 'LINK', 'ETH DeFi'
    UNION ALL SELECT '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984', 'UNI', 'ETH DeFi'
    UNION ALL SELECT '0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2', 'MKR', 'ETH DeFi'
    UNION ALL SELECT '0x5a98fcbea516cf06857215779fd812ca3bef1b32', 'LDO', 'ETH DeFi'
    UNION ALL SELECT '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9', 'AAVE', 'ETH DeFi'
    UNION ALL SELECT '0x808507121b80c02388fad14726482e061b8da827', 'PENDLE', 'ETH DeFi'
    UNION ALL SELECT '0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f', 'SNX', 'ETH DeFi'
    UNION ALL SELECT '0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0', 'FXS', 'ETH DeFi'
    UNION ALL SELECT '0xd533a949740bb3306d119cc777fa900ba034cd52', 'CRV', 'ETH DeFi'
    QueryRunArchived: QueryRun has been archived