jackguyvelo activty
Updated 2023-04-13
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
›
⌄
WITH q4_2022 AS (
SELECT
SUM(CASE WHEN NOT AMOUNT_IN_USD IS NULL THEN AMOUNT_IN_USD
WHEN NOT AMOUNT_OUT_USD IS NULL THEN AMOUNT_OUT_USD
ELSE 0 END) AS swap_volume_q4,
SUM(LP_FEE_USD) AS fee_usd_q4,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS users_q4,
COUNT(DISTINCT tx_hash) AS swaps_q4
FROM optimism.velodrome.ez_swaps
WHERE block_timestamp BETWEEN '2022-10-01' AND '2022-12-31'
),
q1_2023 AS (
SELECT
SUM(CASE WHEN NOT AMOUNT_IN_USD IS NULL THEN AMOUNT_IN_USD
WHEN NOT AMOUNT_OUT_USD IS NULL THEN AMOUNT_OUT_USD
ELSE 0 END) AS swap_volume_q1,
SUM(LP_FEE_USD) AS fee_usd_q1,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS users_q1,
COUNT(DISTINCT tx_hash) AS swaps_q1
FROM optimism.velodrome.ez_swaps
WHERE block_timestamp BETWEEN '2023-01-01' AND '2023-03-31'
)
SELECT
((q1.swap_volume_q1 - q4.swap_volume_q4) / q4.swap_volume_q4) * 100 AS swap_volume_percent_change,
((q1.fee_usd_q1 - q4.fee_usd_q4) / q4.fee_usd_q4) * 100 AS fee_usd_percent_change,
((q1.users_q1 - q4.users_q4) / q4.users_q4) * 100 AS users_percent_change,
((q1.swaps_q1 - q4.swaps_q4) / q4.swaps_q4) * 100 AS swaps_percent_change
FROM q4_2022 q4, q1_2023 q1;
Run a query to Download Data