with top_10 as (select
distinct TX_RECEIVER ,
sum(GAS_USED/1e12) as gas_used
from
flipside_prod_db.mdao_near.transactions
group by 1
order by 2 desc
limit 10)
select
date(BLOCK_TIMESTAMP) as date,
TX_RECEIVER ,
sum(GAS_USED/1e12) as gas_used
from flipside_prod_db.mdao_near.transactions
where TX_RECEIVER in (select TX_RECEIVER from top_10 )
and date >= CURRENT_DATE-7
group by 1 ,2
order by 3