ElprognerdAge of the NETH addresses
    Updated 2023-05-11
    SELECT
    tx_signer AS "Address",
    MIN(block_timestamp) AS "Creation Date",
    CURRENT_DATE - MIN(block_timestamp)::date AS "Age of Wallet (Day)",
    COUNT(DISTINCT tx_hash) AS "Number of Transactions"
    FROM
    near.core.fact_transactions
    WHERE
    tx_receiver = 'nethmap.near'
    GROUP BY
    tx_signer
    ORDER BY
    "Creation Date" ASC

    Run a query to Download Data