Updated 2022-09-10
    SELECT to_char(miner) as miners,
    avg(tx_count) as avg_txn_count,
    count(DISTINCT block_number) as n_blocks
    FROM ethereum.core.fact_blocks
    WHERE date_trunc('day',block_timestamp) BETWEEN CURRENT_DATE-{{past_days}} AND CURRENT_DATE-1
    GROUP by miner
    ORDER by avg_txn_count DESC
    Run a query to Download Data