select
date_trunc('week', block_timestamp) as time,
sum(amount) as volume,
sum(case when from_address != '0x0000000000000000000000000000000000000000' and to_address != '0x0000000000000000000000000000000000000000' then amount else 0 end) as volume_without_mint_burn
from flipside_prod_db.ethereum_core.ez_token_transfers
where contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f'
group by 1