Sbhn_NP2023-08-14 10:07 AM
    Updated 2024-04-18
    select date_trunc('month',block_timestamp) as date,
    initcap(address_name) as section,
    count(DISTINCT tx_hash) as txs,
    count(DISTINCT tx_signer) as users,
    sum(transaction_fee/pow(10,24)) as fees
    from near.core.fact_transactions
    join near.core.dim_address_labels on tx_receiver=address
    where project_name = 'sweat'
    and date >= '2022-09-01'
    and tx_status = 'Success'
    group by 1,2
    having date is not null
    QueryRunArchived: QueryRun has been archived