SalehOPtimitic or Pessimistic?Total
    Updated 2022-10-17
    with lst_arbitrum as (
    select
    count(DISTINCT tx_hash) as tx_count
    ,count(DISTINCT FROM_ADDRESS) as users
    ,sum(TX_FEE) as total_fee
    ,datediff(day,min(block_timestamp),max(block_timestamp)) as "Activity days"
    ,tx_count/"Activity days" as "Daily transaction rate"
    ,users/"Activity days" as "Daily users rate"
    from arbitrum.core.fact_transactions
    where STATUS='SUCCESS'
    )
    ,lst_optimism as (
    select
    count(DISTINCT tx_hash) as tx_count
    ,count(DISTINCT FROM_ADDRESS) as users
    ,sum(TX_FEE) as total_fee
    ,datediff(day,min(block_timestamp),max(block_timestamp)) as "Activity days"
    ,tx_count/"Activity days" as "Daily transaction rate"
    ,users/"Activity days" as "Daily users rate"
    from optimism.core.fact_transactions
    where STATUS='SUCCESS'
    )
    ,lst_polygon as (
    select
    count(DISTINCT tx_hash) as tx_count
    ,count(DISTINCT FROM_ADDRESS) as users
    ,sum(TX_FEE) as total_fee
    ,datediff(day,min(block_timestamp),max(block_timestamp)) as "Activity days"
    ,tx_count/"Activity days" as "Daily transaction rate"
    ,users/"Activity days" as "Daily users rate"
    from polygon.core.fact_transactions
    where STATUS='SUCCESS'
    )
    select 'Arbitrum' as type,* from lst_arbitrum
    union all
    select 'Optimism' as type,* from lst_optimism
    Run a query to Download Data