PromotedPawnPolygon block Performance vs. L1s - Solana_Dynamic
    Updated 2022-07-27
    with polygon as (
    select
    block_timestamp,
    trunc(block_timestamp, 'Day') as days,
    count(distinct tx_hash) as number_tx,
    timestampdiff('Seconds', lag(block_timestamp) over (order by block_timestamp), block_timestamp) as time_diff
    from polygon.core.fact_transactions
    group by 1, 2
    order by 1, 2
    ),

    solana as (
    select
    block_timestamp,
    trunc(block_timestamp, 'Day') as days,
    count(distinct tx_id) as number_tx,
    timestampdiff('Seconds', lag(block_timestamp) over (order by block_timestamp), block_timestamp) as time_diff
    from solana.core.fact_transactions
    group by 1, 2
    order by 1, 2
    )

    select
    p.days,
    sum(p.number_tx) as number_tx_POL,
    sum(s.number_tx) as number_tx_SOL,
    avg(p.time_diff) as block_time_diff_POL,
    avg(s.time_diff) as block_time_diff_SOL
    from polygon p
    join solana s on p.days = s.days

    where p.days < CURRENT_DATE -1
    group by 1
    order by 1
    Run a query to Download Data