crypto_gosttotal swaps
Updated 2024-11-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
COUNT(*) AS total_swaps,
SUM(CASE
WHEN token_in_contract = 'nearvember-337.meme-cooking.near' THEN amount_in_usd
WHEN token_out_contract = 'nearvember-337.meme-cooking.near' THEN amount_out_usd
ELSE 0
END) AS total_volume_usd,
COUNT(DISTINCT trader) AS total_swappers
FROM
NEAR.defi.ez_dex_swaps
WHERE
token_in_contract = 'nearvember-337.meme-cooking.near'
OR token_out_contract = 'nearvember-337.meme-cooking.near';
QueryRunArchived: QueryRun has been archived