select BLOCK_HOUR::date as date,UNDERLYING_SYMBOL,avg(SUPPLY_USD)as supply_amount

from ethereum.compound.ez_market_stats

where date=current_date-1

group by 1,2)

select sum(supply_amount) as Currently_supply_amount

from tab1