Sbhn_NPneth 2
Updated 2023-03-02Copy Reference Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT date_trunc('day',block_timestamp) as date,
count(DISTINCT tx_signer)as wallets,
sum(wallets) over (order by date) as cum_wallets
FROM near.core.fact_transactions
WHERE tx_receiver = 'nethmap.near'
and tx_signer != 'nethmap.near' and tx_status='Success'
AND block_timestamp >= '2022-12-19'
group by 1
Run a query to Download Data