0xHaM-dUntitled Query
Updated 2022-09-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- 15,537,351 The merg block number
SELECT
BLOCK_TIMESTAMP::date as date,
case
when BLOCK_NUMBER < 15537351 then 'Before Merg'
when BLOCK_NUMBER >= 15537351 then 'After Merg'
end as period,
sum(TX_COUNT) as tx_cnt,
count(DISTINCT miner) as miners
FROM ethereum.core.fact_blocks
WHERE miner in (SELECT miner from ethereum.core.fact_blocks WHERE BLOCK_TIMESTAMP::date < '2022-09-15')
AND date >= '2022-08-01'
AND NETWORK = 'mainnet'
group by 1,2
order by 1
Run a query to Download Data