KaskoazulUntitled Query
    Updated 2023-01-20
    WITH users_first_interaction AS (
    SELECT
    tx_signer
    , min(block_timestamp) as first_date
    FROM
    near.core.fact_transactions
    WHERE
    tx_receiver = 'social.near'
    GROUP BY
    tx_signer
    )

    SELECT
    first_date::DATE as fecha
    , COUNT(DISTINCT tx_signer) AS daily_new_users
    , SUM(daily_new_users) OVER (ORDER BY fecha) AS cumulative_new_users
    FROM
    users_first_interaction
    GROUP BY
    fecha
    ORDER BY
    fecha DESC


    -- WITH tx_with_method AS (
    -- SELECT
    -- ft.block_timestamp
    -- , ft.tx_hash
    -- , ft.action_id
    -- --, SPLIT(ft.action_id, '-', 2) AS action_no
    -- , ft.action_name
    -- , ft.method_name
    -- , ft.args
    -- , ft.deposit / POW(10,24) AS deposit_near
    Run a query to Download Data