crypto_gosttransaction
    Updated 2024-12-12
    SELECT
    COUNT(tx_hash) AS total_transactions,
    AVG(value) AS avg_transaction_value_eth
    FROM
    BLAST.core.fact_transactions
    WHERE
    block_timestamp >= DATEADD(DAY, -30, CURRENT_DATE)


    Last run: 2 months ago
    TOTAL_TRANSACTIONS
    AVG_TRANSACTION_VALUE_ETH
    1
    154732150.01155266037
    1
    26B
    3s