m3jiCumulatives Per Program
Updated 2025-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
SWAP_PROGRAM,
COUNT(
DISTINCT CONCAT(SWAP_TO_SYMBOL, '-', SWAP_FROM_SYMBOL)
) as pools,
sum(
case
when SWAP_FROM_AMOUNT_USD is null then swap_to_amount_usd
else swap_from_amount_usd
end
) as swap_volume,
count(DISTINCT swapper) as swappers,
count(DISTINCT tx_id) as swaps,
from
solana.defi.ez_dex_swaps
WHERE
SWAP_PROGRAM ILIKE '%meteora%'
AND block_timestamp BETWEEN '2025-01-01'
AND current_date
GROUP BY 1;
QueryRunArchived: QueryRun has been archived