mattkstewSolana Fees 1
Updated 2022-02-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
fee_ as Daily_Total_Fees,
day_,
SUM (fee_) OVER (ORDER BY day_) as Running_Fee_Total
from ( select
sum(fee/1000000000) as fee_,
date_trunc('day', block_timestamp) as day_
from solana.transactions
where block_timestamp > current_date - 36
group by 2
order by 2 )
order by day_
-- 1B 1,000,000,000
Run a query to Download Data