block_timestamp::string as block_timestamp

, amount as amount_bal

, token_price as bal_usd

, amount_usd

from ethereum.core.ez_token_transfers

where to_address = '0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c'

and symbol = 'BAL'

and block_timestamp > '2022-01-01'

union all

select

'total' as block_day

, sum(amount) as amount_bal

, sum(amount_usd) / sum(amount) as bal_usd

, sum(amount_usd) as amount_usd

from ethereum.core.ez_token_transfers

where to_address = '0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c'

and symbol = 'BAL'

and block_timestamp > '2022-01-01'

order by block_timestamp