rustygeeGLP Hourly Price #2
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
SELECT HOUR,
MAX(CASE WHEN SYMBOL = 'UNI' THEN PRICE END) AS UNI,
MAX(CASE WHEN SYMBOL = 'WETH' THEN PRICE END) AS WETH,
MAX(CASE WHEN SYMBOL = 'LINK' THEN PRICE END) AS LINK,
MAX(CASE WHEN SYMBOL = 'WBTC' THEN PRICE END) AS WBTC
FROM ETHEREUM.CORE.FACT_HOURLY_TOKEN_PRICES
WHERE TOKEN_ADDRESS = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599'
OR TOKEN_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
OR TOKEN_ADDRESS = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984'
OR TOKEN_ADDRESS = '0x514910771af9ca656af840dff83e8264ecf986ca'
ORDER BY HOUR DESC
LIMIT 3000
--SELECT *
--FROM glpHrTokenPrices
--pivot(PRICE for SYMBOL in ('UNI', 'WETH', 'LINK', 'WBTC'))
Run a query to Download Data