SELECT

HOUR :: date as PRICE_TIME,

TOKEN_ADDRESS,

AVG(PRICE) as usd_price

FROM

ethereum.price.ez_hourly_token_prices

WHERE

TOKEN_ADDRESS ilike '%0x467719aD09025FcC6cF6F8311755809d45a5E5f3%'--AXL

OR TOKEN_ADDRESS ilike '%0x6B175474E89094C44Da98b954EedeAC495271d0F%'--DAI

OR TOKEN_ADDRESS ilike '%0x853d955aCEf822Db058eb8505911ED77F175b99e%'--FRAX

OR TOKEN_ADDRESS ilike '%0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48%'--USDC

OR TOKEN_ADDRESS ilike '%0xdAC17F958D2ee523a2206206994597C13D831ec7%'--USDT

OR TOKEN_ADDRESS ilike '%0xd20523b39faf1d6e9023a4d6085f87b7b0de7926%' --OATH

OR TOKEN_ADDRESS ilike '%0xbbc2ae13b23d715c30720f079fcd9b4a74093505%' --ERN

OR TOKEN_ADDRESS ilike '%0x96543ef8d2c75c26387c1a319ae69c0bee6f3fe7%' --KUJI

OR TOKEN_ADDRESS ilike '%0xd20523b39faf1d6e9023a4d6085f87b7b0de7926%' --OATH

OR TOKEN_ADDRESS ilike '%0x2260fac5e5542a773aa44fbcfedf7c193bc2c599%' --WBTC

OR TOKEN_ADDRESS ilike '%0xff56cc6b1e6ded347aa0b7676c85ab0b3d08b0fa%' --ORBS

OR TOKEN_ADDRESS ilike '%0x9469d013805bffb7d3debe5e7839237e535ec483%' --RING

OR TOKEN_ADDRESS ilike '%0x7d8daff6d70cead12c6f077048552cf89130a2b1%' --ARX

OR TOKEN_ADDRESS ilike '%0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2%' --WETH

OR TOKEN_ADDRESS ilike '%0xde5ed76e7c05ec5e4572cfc88d1acea165109e44%' --DEUS

OR TOKEN_ADDRESS ilike '%0x8d6cebd76f18e1558d4db88138e2defb3909fad6%' --MAI

OR TOKEN_ADDRESS ilike '%0x98504c8afa7c74c87a0641a7bb0f7968d4e8f471%' --LQDR

OR TOKEN_ADDRESS ilike '%0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0%' --wstETH

OR TOKEN_ADDRESS ilike '%0xdefa4e8a7bcba345f687a2f1456f5edd9ce97202%' --KNC

OR TOKEN_ADDRESS ilike '%0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0%' --wstETH

OR TOKEN_ADDRESS ilike '%0x824e35f7a75324f99300afac75ecf7354e17ea26%' --TIA

GROUP BY

1,

2

UNION ALL