MajorM111get number swap for token and filter block
Updated 2024-12-20
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 swaps_last_2_months AS (
SELECT
*
FROM
avalanche.defi.ez_dex_swaps
WHERE
block_timestamp >= DATEADD(MONTH, -2, CURRENT_DATE)
),
swap_stats AS (
SELECT
contract_address,
COUNT(*) AS swap_count,
MIN(block_number) AS first_block,
MAX(block_number) AS last_block,
MAX(block_number) - MIN(block_number) AS block_range
FROM
swaps_last_2_months
GROUP BY
contract_address
HAVING
COUNT(*) BETWEEN 10 AND 50
AND MAX(block_number) - MIN(block_number) < 20000
)
SELECT
ss.contract_address AS contract_address_summary,
ss.swap_count,
ss.first_block,
ss.last_block,
ss.block_range,
s.*
FROM
swaps_last_2_months s
JOIN
swap_stats ss
ON
s.contract_address = ss.contract_address
QueryRunArchived: QueryRun has been archived