BLOCKCHAIN,

sum(TRANSACTION_COUNT_SUCCESS) as success_transaction,

sum(success_transaction) over (partition by BLOCKCHAIN order by daily asc) as cumulative

from crosschain.stats.ez_core_metrics_hourly

where block_timestamp_hour::date >= current_date - 31

and blockchain in ('polygon','near','sei','blast','arbitrum','bsc','avalanche','optimism','axelar','aptos','ethereum','base','kaia','solana','flow')

group by 1,2

select trunc(block_timestamp,'day') as daily,

'Thorchain' as blockchain,

count(*) as success_transaction,

sum(success_transaction) over (partition by BLOCKCHAIN order by daily asc) as cumulative

from thorchain.core.fact_transfers

where block_timestamp::date >= current_date - 31

group by 1,2

select trunc(block_timestamp,'day') as daily,

'Kaia' as blockchain,

count(DISTINCT tx_hash) as success_transaction,

sum(success_transaction) over (partition by BLOCKCHAIN order by daily asc) as cumulative

from kaia.core.fact_transactions

where block_timestamp::date >= current_date - 31

and tx_succeeded = 'TRUE'

group by 1,2