crypto_gostother-apricot
    Updated 2024-10-11
    SELECT
    COUNT(DISTINCT tx_id) AS txns,
    COUNT(DISTINCT signers[0]) AS users
    FROM
    solana.core.fact_events
    WHERE
    program_id = 'RainEraPU5yDoJmTrHdYynK9739GkEfDsE4ffqce2BR'
    AND block_timestamp >= CURRENT_DATE - INTERVAL '60 days';


    QueryRunArchived: QueryRun has been archived