mz0111neth 4
Updated 2023-03-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
distinct tx_signer as user,
block_timestamp:: DATE as day,
count(distinct TX_HASH) as TXS
from near.core.fact_transactions a
where TX_SIGNER in ( SELECT
tx_signer as neth_wallet
FROM near.core.fact_transactions
WHERE tx_receiver = 'nethmap.near'
AND block_timestamp > '2022-12-01'
GROUP BY 1
)
group by 1 , 2
Run a query to Download Data