freshgeekavax swaps Q2 2024
Updated 2024-07-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
›
⌄
WITH Q2_2024_Swaps AS (
SELECT
BLOCK_TIMESTAMP,
ORIGIN_FROM_ADDRESS,
ORIGIN_TO_ADDRESS,
AMOUNT_IN_USD,
AMOUNT_OUT_USD
FROM
avalanche.defi.ez_dex_swaps
WHERE
BLOCK_TIMESTAMP >= '2024-04-01 00:00:00'
AND BLOCK_TIMESTAMP < '2024-07-01 00:00:00'
),
New_Users AS (
SELECT
ORIGIN_FROM_ADDRESS
FROM
avalanche.defi.ez_dex_swaps
WHERE
BLOCK_TIMESTAMP < '2024-04-01 00:00:00'
GROUP BY
ORIGIN_FROM_ADDRESS
)
SELECT
COUNT(*) AS total_transactions,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS total_users,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) - COUNT(DISTINCT CASE WHEN ORIGIN_FROM_ADDRESS IN (SELECT ORIGIN_FROM_ADDRESS FROM New_Users) THEN ORIGIN_FROM_ADDRESS END) AS new_users,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS active_users,
SUM(AMOUNT_IN_USD + AMOUNT_OUT_USD) AS total_transaction_volume
FROM
Q2_2024_Swaps;
QueryRunArchived: QueryRun has been archived