All - STPS

Updated 2024-10-22

-- forked from h4wk / All - Average Daily TPS Per chain @ https://flipsidecrypto.xyz/h4wk/q/0AgtGJikWsFz/all---average-daily-tps-per-chain

-- forked from 0xHaM-d / Parallel - Average Daily TPS Per chain @ https://flipsidecrypto.xyz/0xHaM-d/q/fhJ4akUNu2jj/parallel---average-daily-tps-per-chain

-- forked from EVM - Average Daily TPS Per chain @ https://flipsidecrypto.xyz/edit/queries/b4a0088e-50c3-4b8c-a1a7-d35e6ed251a2

-- forked from https://flipsidecrypto.xyz/hess/q/zhRwUPgM_nD1/average-daily-tps-per-chain

with

parallel as (

select date(block_timestamp) as date,

'Aptos' as chain,

count(DISTINCT TX_HASH) as total_tx,

count(distinct sender) as total_user,

total_tx/86400 as tps

from aptos.core.fact_transactions

where block_timestamp::date >= '2023-08-15'

and SUCCESS = 'true'

group by 1,2

-- UNION ALL

-- select date(block_timestamp) as date,

-- 'Sei' as chain,

-- count(DISTINCT tx_id) as total_tx,

-- count(distinct tx_from) as total_user,

-- total_tx/86400 as tps

-- from sei.core.fact_transactions

-- where block_timestamp::date >= '2023-08-15'

-- and TX_SUCCEEDED = 'true'

-- group by 1,2

-- UNION ALL

-- select date(block_timestamp) as date,

-- 'Solana' as chain,

-- count(DISTINCT tx_id) as total_tx,

-- count(distinct signers[0]) as total_users,

-- total_tx/86400 as tps

-- from solana.core.fact_transactions

QueryRunArchived: QueryRun has been archived