Flipside TeamTotal Fees
    Updated 2024-11-14
    with t1 as (
    select
    block_timestamp,
    tx_hash,
    tx_receiver as contract_address,
    tx_signer as sender,
    TRANSACTION_FEE/pow(10,24) as tx_fee,
    tx:receipt[0].outcome.gas_burnt::NUMBER/pow(10,16) as gas_burned,
    gas_burned*0.3 as dev_revenue,
    tx_fee*0.3 as revenue_fees
    from near.core.fact_transactions
    where block_timestamp >= current_date - 365
    )

    select
    sum(gas_burned) as "Burnt Fees",
    sum(dev_revenue) as "Revenue"
    from t1


    Last run: 3 months ago
    Burnt Fees
    Revenue
    1
    622759.721390053186827.916417016
    1
    37B
    223s