mz0111neth 4
    Updated 2023-03-02
    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