alitaslimiTransactions Timely
    Updated 2022-10-19
    WITH
    optimism AS (
    SELECT
    DATE_TRUNC({{interval}}, block_timestamp) AS interval,
    COUNT(DISTINCT tx_hash) AS txn,
    (txn / 86400) AS tps,
    COUNT(DISTINCT from_address) AS users,
    SUM(tx_fee) AS fees,
    SUM(gas_used) AS gas
    FROM
    optimism.core.fact_transactions
    WHERE
    block_timestamp::date BETWEEN (CURRENT_DATE - {{range}}) AND (CURRENT_DATE - 1)
    AND status = 'SUCCESS'
    GROUP BY
    interval
    ),
    arbitrum AS (
    SELECT
    DATE_TRUNC({{interval}}, block_timestamp) AS interval,
    COUNT(DISTINCT tx_hash) AS txn,
    (txn / 86400) AS tps,
    COUNT(DISTINCT from_address) AS users,
    SUM(tx_fee) AS fees,
    SUM(gas_used) AS gas
    FROM
    arbitrum.core.fact_transactions
    WHERE
    block_timestamp::date BETWEEN (CURRENT_DATE - {{range}}) AND (CURRENT_DATE - 1)
    AND status = 'SUCCESS'
    GROUP BY
    interval
    ),
    polygon AS (
    SELECT
    DATE_TRUNC({{interval}}, block_timestamp) AS interval,
    Run a query to Download Data