berg1 copy
Updated 2024-09-29
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 uniswap AS (
SELECT
ORIGIN_FROM_ADDRESS AS UserAddress,
TX_HASH,
BLOCK_TIMESTAMP,
COALESCE(AMOUNT_IN_USD,AMOUNT_OUT_USD) AS AmountUsd,
CASE WHEN BLOCK_TIMESTAMP>='2023-10-17' THEN 'After' ELSE 'Before' END AS TimePeriod
FROM
bsc.defi.ez_dex_swaps
JOIN
bsc.core.fact_transactions USING (TX_HASH)
WHERE
AmountUsd BETWEEN 0 AND 100000000
AND TO_ADDRESS = LOWER('0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad')
AND YEAR(BLOCK_TIMESTAMP)>=2023
)
SELECT
TimePeriod,
COUNT(DISTINCT TX_HASH) AS Txns,
COUNT(DISTINCT UserAddress) AS Users,
SUM(AmountUsd) AS VolumeUsd,
AVG(AmountUsd) AS AverageAmountUsd
FROM
uniswap
GROUP BY TimePeriod
QueryRunArchived: QueryRun has been archived