from ethereum.core.fact_blocks

where block_timestamp >= '2022-09-01'

and block_number >= '15537940'

and miner in ('0xb64a30399f7f6b0c154c2e7af0a3ec7b0a5b131a', --old address

'0xdafea492d9c6733ae3d56b7ed1adb60692c98bc5' --new address

)),

flash_transactions as (select

block_number,

sum(tx_fee) as block_tx_fees

from ethereum.core.fact_transactions

where block_timestamp >= '2022-09-01'

and block_number >= '15537940'

and block_number in (select block_number from flash_blocks)

group by 1

),

fee_burnt as (select

block_number,

block_header_json:base_fee_per_gas * gas_used / 1e18 as block_fee_burn

from ethereum.core.fact_blocks

where block_timestamp >= '2022-09-01'

and block_number >= '15537940'

and block_number in (select block_number from flash_blocks)

),

net_fees as (select

t.block_number,

block_tx_fees,

block_fee_burn,

block_tx_fees - block_fee_burn as net_fees,

sum(net_fees) over (order by t.block_number asc) as cm_fees

from flash_transactions t

inner join fee_burnt b on t.block_number = b.block_number