farid-c9j0VMdaily gas used by 10 most popular contracts over the past week
    Updated 2022-07-26
    with top_10 as (select
    distinct TX_RECEIVER ,
    sum(GAS_USED/1e12) as gas_used
    from
    flipside_prod_db.mdao_near.transactions
    group by 1
    order by 2 desc
    limit 10)
    select
    date(BLOCK_TIMESTAMP) as date,
    TX_RECEIVER ,
    sum(GAS_USED/1e12) as gas_used
    from flipside_prod_db.mdao_near.transactions
    where TX_RECEIVER in (select TX_RECEIVER from top_10 )
    and date >= CURRENT_DATE-7
    group by 1 ,2
    order by 3

    Run a query to Download Data