kiacryptoMonthly average number of transactions per minutes
    Updated 2022-12-10
    with flow_tpm as (
    select
    date_trunc('minutes', block_timestamp) as minutes,
    count(distinct tx_id) as tx_per_min
    from flow.core.fact_transactions
    where block_timestamp >= '2022-01-01'
    group by 1
    ),
    bsc_tpm as (
    select
    date_trunc('minutes', block_timestamp) as minutes,
    count(distinct tx_hash) as tx_per_min
    from bsc.core.fact_transactions
    where block_timestamp >= '2022-01-01'
    group by 1
    ),
    eth_tpm as (
    select
    date_trunc('minutes', block_timestamp) as minutes,
    count(distinct tx_hash) as tx_per_min
    from Ethereum.core.fact_transactions
    where block_timestamp >= '2022-01-01'
    group by 1
    ),
    avax_tpm as (
    select
    date_trunc('minutes', block_timestamp) as minutes,
    count(distinct tx_hash) as tx_per_min
    from avalanche.core.fact_transactions
    where block_timestamp >= '2022-01-01'
    group by 1
    ),
    algo_tpm as (
    select
    date_trunc('minutes', block_timestamp) as minutes,
    count(distinct tx_id) as tx_per_min
    Run a query to Download Data