-- What contracts are users spending the most gas on to use?
-- How has this changed over the past week? Past month?
select
tx_receiver as contract,
sum(gas_used)/pow(10,12) as gas_used
from near.core.fact_transactions where block_timestamp>=CURRENT_DATE- INTERVAL '1 MONTH'
group by 1
order by 2 desc
limit 10