intellidegentEthereum Transactions
    Updated 2023-03-06
    SELECT
    'Ethereum' as Blockchain,
    date_trunc('month',block_timestamp) as Month,
    count(distinct tx_hash) as Transactions,
    count(distinct to_address) as Addresses,
    Transactions / Addresses as TxPerAddress
    FROM ethereum.core.fact_transactions
    WHERE date_trunc('month',block_timestamp) >= '2021-01-01'
    AND date_trunc('month',block_timestamp) < '2023-03-01'
    GROUP BY Month
    Run a query to Download Data