sum (transaction_fee) / 1e24 as transaction_fees,

sum (gas_used) / 1e12 as transaction_Gass

from flipside_prod_db.mdao_near.transactions where block_timestamp >= CURRENT_DATE - 7

group by 1 order by 3 desc limit 10)

select block_timestamp::date as date, tx_receiver as Contract,

sum (transaction_fee) / 1e24 as transaction_fees,

sum (gas_used) / 1e12 as transaction_Gass,

sum (transaction_Gass) over (partition by Contract order by date) as Cumulative_TX_Gass

from flipside_prod_db.mdao_near.transactions where tx_receiver in (select Contract from tab) and block_timestamp >= CURRENT_DATE - 7

group by 1,2 order by 1