Updated 2022-06-01
    with tb1 as (
    with seconds_tps as (
    SELECT
    date_trunc('second',block_timestamp) seconds,
    count(tx_id) tps
    from Solana.fact_transactions
    where block_timestamp >= '2022-01-01'
    group by 1)

    select
    'Solana' as Blockchain,
    date_trunc('week', seconds) "week",
    max(tps) max_tps
    from seconds_tps
    group by 1,2),

    tb2 as (
    with seconds_tps as (
    SELECT
    date_trunc('second',block_timestamp) seconds,
    count(tx_hash) tps
    from ethereum_core.fact_transactions
    where block_timestamp >= '2022-01-01'
    group by 1)

    select
    'Ethereum' as Blockchain,
    date_trunc('week', seconds) "week",
    max(tps) max_tps
    from seconds_tps
    group by 1,2)



    select * from tb1
    Run a query to Download Data