mrwildcatpyth base totals
    Updated 2024-09-24
    -- forked from pyth bsc totals @ https://flipsidecrypto.xyz/edit/queries/980eb3e6-0d16-47b5-b895-80e13ff926f8

    -- forked from 2024-06-29 12:47 AM arb totals @ https://flipsidecrypto.xyz/edit/queries/2e295d89-fa87-4e82-9864-d7a52681b561

    SELECT
    COUNT(DISTINCT from_address) as unique_contracts,
    COUNT(DISTINCT tx_hash) as total_transactions,
    SUM(gas_used) as total_gas_used,
    SUM(value) as total_value_transferred
    FROM base.core.fact_traces
    WHERE to_address = LOWER('0x8250f4aF4B972684F7b336503E2D6dFeDeB1487a')
    AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '6 months'



    Last run: 4 days ago
    UNIQUE_CONTRACTS
    TOTAL_TRANSACTIONS
    TOTAL_GAS_USED
    TOTAL_VALUE_TRANSFERRED
    1
    20612891822511661220460.0009000000025
    1
    44B
    526s