Burnt Fees | Revenue | |
---|---|---|
1 | 622759.721390053 | 186827.916417016 |
Flipside TeamTotal Fees
Updated 2024-11-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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
1
37B
223s