date_trunc('day', hour) as date,

token_address,

symbol,

avg(price) as price

from ethereum.token_prices_hourly

where token_address in ('0x0d438f3b5175bebc262bf23753c1e53d03432bde','0x26607ac599266b21d13c7acf7942c7701a8b699c','0x9fac54b1ddac9968df67b31f217c63c4c118656d','0xb2b9335791346e94245dcd316a9c9ed486e6dd7f',

'0x80fb784b7ed66730e8b1dbd9820afd29931aab03','0xb4bebd34f6daafd808f73de0d10235a92fbb6c3d','0x861f4d83dde243b92fa2f3cc648d7553318222e9','0xfa2562da1bba7b954f26c74725df51fb62646313',

'0x9ba60ba98413a60db4c651d4afe5c937bbd8044b','0x2994529c0652d127b7842094103715ec5299bbed','0x5dbcf33d8c2e976c6b560249878e6f1491bca25c','0x629c759d1e83efbf63d84eb3868b564d9521c129',

'0x9ca85572e6a3ebf24dedd195623f188735a5179f','0xcc7e70a958917cce67b4b87a8c30e6297451ae98','0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2','0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f',

'0x84e13785b5a27879921d6f685f041421c7f482da','0x2a38b9b0201ca39b17b460ed2f11e4929559071e','0x4b5bfd52124784745c1071dcb244c6688d2533d3','0x8ee57c05741aa9db947a744e713c15d4d19d8822',

'0xf3505383b740af8c241f1cf6659619a9c38d0281','0xd6ea40597be05c201845c0bfd2e96a60bacde267','0x3b96d491f067912d18563d56858ba7d6ec67a6fa','0x6ede7f19df5df6ef23bd5b9cedb651580bdf56ca',

'0x5fa5b62c8af877cb37031e0a3b2f34a78e3c56a6','0xc4daf3b5e2a9e93861c3fbdd25f1e943b8d87417','0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e','0x1ceb5cb57c4d4e2b2433641b95dd330a33185a44',

'0x1f9840a85d5af5bf1d1762f925bdaddc4201f984','0x2ba592f78db6436527729929aaf6c908497cb200','0x38e4adb44ef08f22f5b5b76a8f0c2d0dcbe7dca1','0x429881672b9ae42b8eba0e26cd9c73711b891ca5',

'0x6b3595068778dd592e39a122f4f5a5cf09c90fe2','0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9','0x8ab7404063ec4dbcfd4598215992dc3f8ec853d7','0xc00e94cb662c3520282e6f5717214004a7f26888')

and hour >= '2020-11-30T00:00:00Z'

group by 1, 2, 3