Ali3NSwaps TO Memecoins Over Time (Avalanche Memecoins Mania)
Updated 2025-01-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select date_trunc ({{Time_Interval}},block_timestamp) as date,
symbol_out,
count (distinct tx_hash) as Swaps,
count (distinct origin_from_address) as Traders,
sum (amount_out_usd) as USD_Volume,
avg (amount_out_usd) as Average_USD_Volume,
sum (USD_Volume) over (order by date asc) as Total_Volume
from avalanche.defi.ez_dex_swaps
where (token_out in ('0x420fca0121dc28039145009570975747295f2329' -- COQ
,'0x184ff13b3ebcb25be44e860163a5d8391dd568c1' -- KIMBO
,'0x5ac04b69bde6f67c0bd5d6ba6fd5d816548b066a' -- TECH
,'0xe8385cecb013561b69beb63ff59f4d10734881f3' -- GEC
,'0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5' -- NOCHILL
)
or token_out ilike '{{Memecoin_Contract_Address}}')
and block_Timestamp >= current_date - {{Last_X_Days}}
group by 1,2
order by 1 desc
QueryRunArchived: QueryRun has been archived