MLDZMNstr1
    Updated 2023-06-14

    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