NakedCollector2024-03-15 11:39 AM
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
35
36
›
⌄
WITH NewTokens AS (
SELECT
c.ADDRESS,
c.NAME,
c.SYMBOL,
DATE(c.CREATED_BLOCK_TIMESTAMP) AS CREATED_BLOCK_DATE,
DATEDIFF(
day,
DATE(c.CREATED_BLOCK_TIMESTAMP),
CURRENT_DATE
) AS age_days
FROM
crosschain.core.dim_contracts c
WHERE
c.CREATED_BLOCK_TIMESTAMP > CURRENT_DATE - INTERVAL '{{param_JgGe}} DAYS'
AND c.SYMBOL IS NOT NULL
GROUP BY
c.ADDRESS,
c.NAME,
c.SYMBOL,
DATE(c.CREATED_BLOCK_TIMESTAMP)
),
TokenActivity AS (
SELECT
s.TOKEN_OUT,
SUM(s.AMOUNT_OUT_USD) AS volume_out_usd,
COUNT(DISTINCT s.TX_HASH) AS tx_count
FROM
crosschain.defi.ez_dex_swaps s
WHERE
s.BLOCK_TIMESTAMP > CURRENT_DATE - INTERVAL '{{param_JgGe}} DAYS'
GROUP BY
s.TOKEN_OUT
HAVING
SUM(s.AMOUNT_OUT_USD) > 10000
)
Run a query to Download Data