SandeshNew addresses ref finance
    Updated 2022-11-17
    WITH active_addresses AS (
    SELECT block_timestamp, TX_SIGNER as address
    FROM near.core.fact_transactions
    WHERE 1=1
    and tx_receiver = ('v2.ref-finance.near')
    AND tx_status = 'Success'
    UNION ALL
    SELECT block_timestamp, TX_RECEIVER as address
    FROM near.core.fact_transactions
    WHERE 1=1
    and tx_receiver = ('v2.ref-finance.near')
    AND tx_status = 'Success'
    )
    SELECT date, count (distinct address)
    FROM (
    SELECT min(block_timestamp::date) AS date, address
    FROM active_addresses
    GROUP BY address
    )
    WHERE date > CURRENT_DATE - interval ' 1 month'
    GROUP BY date
    ORDER BY date desc

    Run a query to Download Data