crypto_gostdaily swaps
Updated 2024-11-19
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
›
⌄
WITH daily_stats AS (
SELECT
DATE_TRUNC('DAY', block_timestamp) AS swap_date,
COUNT(*) AS daily_swap_transactions,
COUNT(DISTINCT trader) AS daily_unique_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'
GROUP BY
DATE_TRUNC('DAY', block_timestamp)
),
daily_averages AS (
SELECT
AVG(daily_swap_transactions) AS avg_daily_swap_transactions,
AVG(daily_unique_swappers) AS avg_daily_unique_swappers
FROM
daily_stats
)
SELECT
swap_date,
daily_swap_transactions,
daily_unique_swappers,
avg_daily_swap_transactions,
avg_daily_unique_swappers
FROM
daily_stats
CROSS JOIN
daily_averages
ORDER BY
swap_date;
QueryRunArchived: QueryRun has been archived