Updated 2022-09-02
    select
    date(block_timestamp)as date ,sum(GAS_PRICE) as total_gas , avg(GAS_PRICE) as avg_gas , count(distinct tx_hash) as txs

    from optimism.core.fact_transactions

    where TO_ADDRESS='0x9c7305eb78a432ced5c4d14cac27e8ed569a2e26'
    group by 1
    Run a query to Download Data