Analyst Lab Number of Users & Transactions copy
    Updated 2025-01-18

    SELECT
    DATE_TRUNC('Week', BLOCK_TIMESTAMP::DATE) AS Week,
    SUM(COALESCE(SWAP_FROM_AMOUNT_USD, 0)) AS total_volume_from_usd,
    COUNT(DISTINCT SWAPPER) AS "Number of Users",
    COUNT(DISTINCT TX_ID) As Transactions
    FROM solana.defi.ez_dex_swaps
    WHERE PROGRAM_ID = '675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8'
    AND BLOCK_TIMESTAMP::DATE BETWEEN '2024-12-01' AND '2025-01-01'
    GROUP BY Week



    -- Total trading volume trend month-by-month - First truncate our data
    -- Use the swap and transfer tables
    -- Share of LPs (liquidity pools) on Raydium - For LPs - Limit to only December 2024, use others' queries as a guide
    -- No. Of new users month-by-month
    -- Total no. Of transactions month-by-month
    -- Most traded tokens on Raydium
    -- Average transaction value - Total transaction volume divided by total number of transactions.


    QueryRunArchived: QueryRun has been archived