-- forked from 10 contracts based on most gas payed by user 7 days @ https://flipsidecrypto.xyz/edit/queries/76c1045a-fd00-4874-abc0-47e2659e2351
select tx_receiver as contract,
sum(gas_used) / power(10, 12) as gas_used, sum(transaction_fee) / power(10, 24) as transaction_fee from near.core.fact_transactions
where block_timestamp >= '2024-01-01' --CURRENT_DATE - 7
group by 1
order by 2 desc
limit 10