SocioCryptominers
Updated 2022-09-10
9
1
2
3
4
5
6
7
›
⌄
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