adambalanear
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
date_trunc('day', block_timestamp) AS daily
, COUNT ( tx_signer) AS active_wallet
, COUNT ( DISTINCT tx_signer) AS distinct_active_wallet
from flipside_prod_db.mdao_near.transactions
WHERE block_timestamp >= '2022-01-01 00:00:01.000'
AND block_timestamp <= '2022-05-30 23:59:59.000'
GROUP BY daily