Updated 2022-09-02
    select
    date(block_timestamp)as date ,ORIGIN_FUNCTION_SIGNATURE , count(distinct TX_HASH ) as tx ,EVENT_NAME ,TX_STATUS

    from optimism.core.fact_event_logs


    where CONTRACT_ADDRESS=lower('0x3c8B650257cFb5f272f799F5e2b4e65093a11a05')
    group by 1 ,2,4,5
    Run a query to Download Data