date_trunc('day', hour) as date,

token_address,

avg(price) as price

from flipside_prod_db.ethereum_core.fact_hourly_token_prices

where token_address in

,'0x009178997aff09a67d4caccfeb897fb79d036214'

,'0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9'

,'0x8ab7404063ec4dbcfd4598215992dc3f8ec853d7'

,'0x27702a26126e0b3702af63ee09ac4d1a084ef628'

,'0xac51066d7bec65dc4589368da368b212745d63e8'

,'0xff20817765cb7f73d4bde2e66e067e58d11095c2'

,'0xd46ba6d942050d489dbd938a2c909a5d5039a161'

,'0x8290333cef9e6d528dd5618fb97a76f268f3edd4'

,'0x18aaa7115705e8be94bffebde57af9bfc265b998'

,'0xbb0e17ef65f82ab018d8edd776e8dd940327b28b'

,'0x0d8775f648430679a709e98d2b0cb6250d2887ef'

,'0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c'

,'0x4fabb145d64652a948d72533023f6e7a623c7c53'

,'0xaaaebe6fe48e54f431b0c390cfaf0b017d09d42d'

,'0x3506424f91fd33084466f402d5d97f05f8e3b4af'

,'0xc00e94cb662c3520282e6f5717214004a7f26888'

,'0x2ba592f78db6436527729929aaf6c908497cb200'

,'0xa0b73e1ff0b80914ab6fe0444e65848c4c34450b'

,'0xd533a949740bb3306d119cc777fa900ba034cd52'

,'0x4e3fbd56cd56c3e72c1403e103b45db9da5b9d2b'

,'0x6b175474e89094c44da98b954eedeac495271d0f'

,'0x92d6c1e31e14520e676a687f0a93788b716beff5'

,'0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3'

,'0xf629cbd94d3791c9250152bd8dfbdf380e2a3b9c'

,'0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'

,'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'