flipside

    Try Quests to earn AVAXTry Quests to earn AVAX
    Share

    Avalanche Small-not-Micro Coin Trade Counts

    As Avalanche Foundation considers investment directly into culture/meme tokens. I wondered how many tokens are approaching some kind of "meme" status. Here, I emphasized the growth of tokens trading 100 - 1,000 times per day. The < 100 trades/day category was massive, as numerous tokens launch every day. 100 trades felt like a good minimum, while the over 1,000 category seemed small enough to consider as having "made it" in some sense. This Small, but not Micro, set of tokens (tokens trading 100-249 or 250-999 times per day) has skyrocketed on Avalanche over the last 3 months.

    Loading...

    Dropping the < 100 trades per category as that was too dominant to see the trend in the rest of the chart. Note: only goes up to yesterday to let each day finish before including.

    with small_tokens AS (
select date_trunc('day', block_timestamp) as day_, 
token_out, symbol_out, 
count(tx_hash) as num_trades,
case when num_trades &lt; 100 then 'under-100' 
     when num_trades &lt; 250 then '100-249'
     when num_trades &lt; 1000 then '250-999'
     when num_trades &lt; 2000 then '1,000-1,999'
     when num_trades &lt; 10000 then '2,000-9,999'
     else '10,000+' end as num_trade_category
from avalanche.defi.ez_dex_swaps
-- &gt; is greater than, dumb markdown display issue
where block_timestamp &gt;= '2023-10-01' AND
-- &lt; is less than, another dumb markdown display issue 
block_timestamp &lt; date_trunc('day', current_date)
group by day_, token_out, symbol_out
)

select day_, 
num_trade_category, 
count(1) as n_tokens_in_category
from small_tokens
where num_trade_category != 'under-100'
group by day_, num_trade_category