mucryptoDaily ETH rewards by Flashbots
    Updated 2023-04-27
    with flash_blocks as (select block_number
    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
    )
    Run a query to Download Data