SELECT HOUR, SYMBOL, PRICE

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

--pivot(PRICE for SYMBOL in ('UNI', 'WETH', 'LINK', 'WBTC'))

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 glpHrTokenPrices

WHERE HOUR > DATEADD(day, -157, GETDATE())

GROUP BY HOUR

ORDER BY HOUR ASC