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=lower('0x3c8B650257cFb5f272f799F5e2b4e65093a11a05')
    group by 1
    Run a query to Download Data