lagandispenserTop 50 Gas contracts and number of transactions over since 2022
    Updated 2022-07-24
    with contracts as (select tx_receiver as contract, sum(gas_used) / power(10, 12) as gas
    from flipside_prod_db.mdao_near.transactions group by 1 order by 2 desc limit 50)

    select
    block_timestamp::date as date, tx_receiver as contract, sum(gas_used) / power(10, 12) as gas,
    count(distinct txn_hash) as number_of_txs,
    count(distinct tx_signer) as number_of_users
    from flipside_prod_db.mdao_near.transactions where date >= '2022-01-01'
    and tx_receiver in (select distinct contract from contracts)
    group by 1,2
    Run a query to Download Data