check_skedPolygon x Avalanche TXs and TPS
    Updated 2023-07-07
    SELECT
    matic.dt AS matic_dt,
    matic.matic_TXS,
    matic.matic_TPS,
    matic_successful.matic_successful_txs AS matic_successful_txs,
    matic_successful.matic_successful_txs * 100.0 / matic.matic_TXS AS matic_successful_percent,
    avax.dt AS avax_dt,
    avax.avax_TXS,
    avax.avax_TPS,
    avax_successful.avax_successful_txs AS avax_successful_txs,
    avax_successful.avax_successful_txs * 100.0 / avax.avax_TXS AS avax_successful_percent
    FROM
    (
    SELECT
    date_trunc('day', block_timestamp) AS dt,
    COUNT(DISTINCT TX_HASH) AS matic_TXS,
    COUNT(DISTINCT TX_HASH) / 86400.0 AS matic_TPS
    FROM
    polygon.core.fact_transactions
    WHERE
    dt >= CURRENT_DATE - INTERVAL '400 DAY'
    GROUP BY
    dt
    ) matic
    JOIN (
    SELECT
    date_trunc('day', block_timestamp) AS dt,
    COUNT(DISTINCT TX_HASH) AS avax_TXS,
    COUNT(DISTINCT TX_HASH) / 86400.0 AS avax_TPS
    FROM
    avalanche.core.fact_transactions
    WHERE
    dt >= CURRENT_DATE - INTERVAL '400 DAY'
    GROUP BY
    dt
    ) avax ON matic.dt = avax.dt
    Run a query to Download Data