select

date_day as block_day

from crosschain.core.dim_dates

where date_day > '2022-07-18'

and date_day < current_date

select

'IN' as transfers_transfer_type

, from_address as transfers_from_address

, to_address as transfers_to_address

, '0xba100000625a3754423978a60c9317c58a424e3D' as transfers_contract_address

, 'Balancer' as transfers_contract_name

, 18 as transfers_contract_decimals

, 'BAL' as transfers_contract_ticker_symbol

, date_trunc('day', block_timestamp) as block_day

, 'mainnet' as network

, 'aave_v2' as version

, '0x464C71f6c2F760DdA6093dCB91C24c39e5d6e18c' as collector

, sum(amount) as amount

from ethereum.core.ez_token_transfers

where to_address = '0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c'

and symbol = 'BAL'

and block_timestamp > '2022-07-18'

and block_timestamp < current_date

group by 1,2,3,4,5,6,7,8,9,10,11