SELECT

date_trunc( 'day' , a.block_timestamp ) AS date

, a.symbol

, a.token_name

, median( a.current_bal ) AS balance

, median( a.current_bal_usd ) AS balance_usd

FROM

ethereum.core.ez_balance_deltas a

WHERE

a.user_address IN ( '0x6bfad42cfc4efc96f529d786d643ff4a8b89fa52' , '0x23ddd3e3692d1861ed57ede224608875809e127f' )

AND a.block_timestamp > '2021-12-01'

AND a.block_timestamp < current_date

AND a.symbol IS NOT NULL

GROUP BY

1 , 2 , 3

ORDER BY

1 , 2

,

current_price AS

SELECT

a.symbol AS symbol_1

, avg( a.price ) AS usd