lagandispenser10 contracts based on most gas payed by user 7 days
    Updated 2022-07-24
    select tx_receiver as contract,
    sum(gas_used) / power(10, 12) as gas_used, sum(transaction_fee) / power(10, 24) as transaction_fee from flipside_prod_db.mdao_near.transactions
    where block_timestamp >= CURRENT_DATE - 7
    group by 1
    order by 2 desc
    limit 10
    Run a query to Download Data