select

date_trunc({{partition}}, block_timestamp::date) as date

,count(DISTINCT tx_hash) as tx_count

,count(DISTINCT FROM_ADDRESS) as users

,sum(TX_FEE) as total_fee

,sum(tx_count) over(order by date) as growth_tx_count

,sum(users) over(order by date) as growth_users

-- ,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"

-- ,(tx_count/"Activity days")/86400 as TPS

,count (case when status != 'SUCCESS' then 1 end) as Failed_count

,count (case when status = 'SUCCESS' then 1 end) as Success_count

,(Success_count / (Success_count + Failed_count)) * 100 as Success_Rate

from arbitrum.core.fact_transactions

-- where STATUS='SUCCESS'

where block_timestamp::date>=CURRENT_DATE-{{from}}

group by 1

order by 1

,lst_optimism as (

select

date_trunc({{partition}}, block_timestamp::date) as date

,count(DISTINCT tx_hash) as tx_count

,count(DISTINCT FROM_ADDRESS) as users

,sum(TX_FEE) as total_fee

,sum(tx_count) over(order by date) as growth_tx_count

,sum(users) over(order by date) as growth_users

-- ,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"

-- ,(tx_count/"Activity days")/86400 as TPS

,count (case when status != 'SUCCESS' then 1 end) as Failed_count

,count (case when status = 'SUCCESS' then 1 end) as Success_count

,(Success_count / (Success_count + Failed_count)) * 100 as Success_Rate