Sbhn_NP2023-08-14 10:07 AM
Updated 2024-04-18
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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