Analyst Lab Number of Users & Transactions copy
Updated 2025-01-18Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
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