drone-mostafaUntitled Query
    Updated 2022-07-23
    with Top_gas as ( select sum(gas_used) / Power(10, 12) as gas_used, TX_RECEIVER as Contract from flipside_prod_db.mdao_near.transactions group by Contract order by gas_used DESC limit 10 )

    select date_trunc('day', block_timestamp) as daily, sum(gas_used) / Power(10, 12) as gas_used , TX_RECEIVER as Contract

    from flipside_prod_db.mdao_near.transactions where tx_receiver in (select Contract from Top_gas) and block_timestamp > current_date - 7 group by daily , Contract
    Run a query to Download Data