flipside

    S2 Q9
    mucryptoS2 Q9
    Updated 2023-01-23
    -- select
    -- count (tx_hash)
    -- from ethereum.core.fact_transactions
    -- WHERE block_timestamp::DATE between '2022-10-01' and '2022-10-31'
    -- limit 10;

    select
    count(tx_hash) as n_rows,
    count(distinct tx_hash) as unique_tx
    from ethereum.core.fact_transactions
    where DATE_TRUNC('month',block_timestamp) = '2022-10-01'
    Run a query to Download Data