nsa2000dex3
Updated 2022-12-22
9
1
2
3
4
5
6
7
›
⌄
--credit to Abbas_ra21
SELECT
date_trunc('Month',BLOCK_TIMESTAMP) AS MONTH,
sum(block_header_json['base_fee_per_gas']*gas_used/1e18) AS "ETH Burned Amount",
Sum("ETH Burned Amount") Over(ORDER BY MONTH) AS "cumulative Amount"
FROM ethereum.core.fact_blocks
WHERE BLOCK_TIMESTAMP::date > '2022-01-01' group by 1