NavidCopy of Copy of Untitled Query
Updated 2022-10-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
date(block_timestamp) as day,
'Near' as network,
sum(TRANSACTION_FEE) as "Daily Fee Value",
sum("Daily Fee Value") over (order by day asc) as "Cumulative Fee Value",
avg("Daily Fee Value") over (order by day asc rows between 14 preceding and current row) as "Moving Average"
from
near.core.fact_transfers
where day > CURRENT_DATE-90
group by
day
union all
select
date(block_timestamp) as day,
'Solana' as network,
sum(TRANSACTION_FEE) as "Daily Fee Value",
sum("Daily Fee Value") over (order by day asc) as "Cumulative Fee Value",
avg("Daily Fee Value") over (order by day asc rows between 14 preceding and current row) as "Moving Average"
from
near.core.fact_transfers
where day > CURRENT_DATE-90
group by
day
Run a query to Download Data