MLDZMNstr1
Updated 2023-06-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
BLOCK_TIMESTAMP::date as date,
count(distinct tx_hash) as no_txn,
count(distinct from_address) as no_users,
sum(TX_FEE) as total_fee,
avg(TX_FEE) as avg_fee,
median(TX_FEE) as median,
sum(no_txn) over (order by date) as total_txn,
sum(no_users) over (order by date) as total_users
from avalanche.core.fact_transactions s
left join avalanche.core.dim_labels a on s.TO_ADDRESS=a.ADDRESS
where BLOCK_TIMESTAMP>=current_date-{{Period}}
and PROJECT_NAME is not null
and STATUS = 'SUCCESS'
and PROJECT_NAME in ('stargate finance')
group by 1
Run a query to Download Data