BLOCKCHAIN,

sum(TRANSACTION_COUNT_SUCCESS) as success_transaction,

success_transaction/84400 as STPS,

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 >= '2024-07-01' and block_timestamp_hour::date < '2024-08-01'

and blockchain in ('polygon','near','sei','blast','arbitrum','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,

success_transaction/84400 as STPS,

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

from thorchain.core.fact_transfers

where block_timestamp::date >= '2024-07-01' and block_timestamp::date < '2024-08-01'

group by 1,2

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

'Kaia' as blockchain,

count(DISTINCT tx_hash) as success_transaction,

success_transaction/84400 as STPS,

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

from kaia.core.fact_transactions

where block_timestamp::date >= '2024-07-01' and block_timestamp::date < '2024-08-01'

and tx_succeeded = 'TRUE'

group by 1,2