Drsimontop 10 miners
Updated 2022-09-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
DATE_TRUNC('YEAR' , BLOCK_TIMESTAMP) AS YEAR ,
CASE WHEN MINER = '0xea674fdde714fd979de3edf0f56aa9716b898ec8' THEN 'ONE'
WHEN MINER = '0x5a0b54d5dc17e0aadc383d2db43b0a0d3e029c4c' THEN 'TOW'
WHEN MINER = '0x829bd824b016326a401d083b33d092293333a830' THEN 'Three'
WHEN MINER = '0x52bc44d5378309ee2abf1539bf71de1b7d7be3b5' THEN 'four'
WHEN MINER = '0x2a65aca4d5fc5b5c859090a6c34d164135398226' THEN 'five'
WHEN MINER = '0xb2930b35844a230f00e51431acae96fe543a0347' THEN 'six'
WHEN MINER = '0x1ad91ee08f21be3de0ba2ba6918e714da6b45836' THEN 'Seven'
WHEN MINER = '0x04668ec2f57cc15c381b461b9fedab5d451c8f7f' THEN 'eight'
WHEN MINER = '0x61c808d82a3ac53231750dadc13c777b59310bd9' THEN 'nine'
WHEN MINER = '0x4bb96091ee9d802ed039c4d1a5f6216f90f81b01' THEN 'ten'
END AS "TOP MINERS" ,
count(TX_COUNT) AS NUM_TX ,
SUM(GAS_USED) AS "GAS USED"
from ethereum.core.fact_blocks
WHERE tx_count > 0
AND "TOP MINERS" IS NOT NULL
GROUP BY 1 , 2
ORDER BY 2 DESC
Run a query to Download Data