crypto_gostredundant-beige
Updated 2024-11-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH period_data AS (
SELECT
tx_hash,
origin_from_address,
amount_in_usd,
CAST(block_timestamp AS DATE) AS transaction_date
FROM
blast.defi.ez_dex_swaps
WHERE
platform = 'ambient'
AND block_timestamp >= DATEADD(day, -30, CURRENT_DATE)
)
SELECT
COUNT(DISTINCT tx_hash) / COUNT(DISTINCT transaction_date) AS daily_average_swaps,
SUM(amount_in_usd) / COUNT(DISTINCT transaction_date) AS daily_volume_usd,
COUNT(DISTINCT origin_from_address) / COUNT(DISTINCT transaction_date) AS daily_average_swappers,
AVG(amount_in_usd) AS average_amount_usd
FROM
period_data;
QueryRunArchived: QueryRun has been archived