flipside

    Near Wallet age
    dannyamahNear Wallet age
    Updated 2025-05-12
    WITH first_tx AS (
    SELECT
    MIN(block_timestamp) AS first_tx_date
    FROM near.core.fact_transactions
    WHERE tx_signer = '{{wallet}}'
    )

    SELECT
    DATEDIFF('day', first_tx_date, CURRENT_DATE) AS wallet_age_days
    FROM first_tx;

    Last run: about 1 month ago
    WALLET_AGE_DAYS
    1
    		1026
    1
    8B
    3s