Ali3NMarket Share of Meme vs Other Coins Swaps in DEXs 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
24
25
26
27
28
29
30
31
32
33
34
35
›
⌄
-- forked from Swaps TO Meme vs Non-Meme Coins Over Time (Avalanche Memecoins Mania) @ https://flipsidecrypto.xyz/edit/queries/139d936b-a80c-4444-ba35-7a664b12239d
select date_trunc ({{Time_Interval}},block_timestamp) as date,
case when (token_out in ('0x420fca0121dc28039145009570975747295f2329' -- COQ
,'0x184ff13b3ebcb25be44e860163a5d8391dd568c1' -- KIMBO
,'0x5ac04b69bde6f67c0bd5d6ba6fd5d816548b066a' -- TECH
,'0xe8385cecb013561b69beb63ff59f4d10734881f3' -- GEC
,'0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5' -- NOCHILL
)
or token_out ilike '{{Memecoin_Contract_Address}}'
or token_in in ('0x420fca0121dc28039145009570975747295f2329' -- COQ
,'0x184ff13b3ebcb25be44e860163a5d8391dd568c1' -- KIMBO
,'0x5ac04b69bde6f67c0bd5d6ba6fd5d816548b066a' -- TECH
,'0xe8385cecb013561b69beb63ff59f4d10734881f3' -- GEC
,'0xacfb898cff266e53278cc0124fc2c7c94c8cb9a5' -- NOCHILL
)
or token_in ilike '{{Memecoin_Contract_Address}}') then 'Meme Coins' else 'Other Coins' end as token_type,
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 block_Timestamp >= current_date - {{Last_X_Days}}
group by 1,2
order by 1 desc
QueryRunArchived: QueryRun has been archived