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 trunc(block_timestamp,'day') as day,

sum(gas_burned) as "Burnt Gas",

sum(dev_revenue) as "Revenue"

from t1

group by 1

order by 1 asc