NakedCollectorMACRO: Year to Date Price Data (INDEX)
Updated 2024-09-07
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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