SELECT

date_trunc( 'day' , a.hour ) AS day

, avg( a.price ) AS price_usd

, b.symbol AS token_name

FROM

ethereum.core.fact_hourly_token_prices a

INNER JOIN

ethereum.core.dim_contracts b

ON a.token_address = b.address

WHERE

a.hour >= dateadd( day , -180 , current_date )

AND a.hour::date < current_date

AND b.address IN (

lower('0x5c147e74D63B1D31AA3Fd78Eb229B65161983B2b')

, lower('0x0f5d2fb29fb7d3cfee444a200298f468908cc942')

, lower('0x3845badAde8e6dFF049820680d1F14bD3903a5d0')

)

GROUP BY

1 , 3

ORDER BY

1 DESC , 3 DESC