uniswap meme 5

Updated 2023-06-14

--**User Participation**: Who are the participants actively engaging with Memecoins on Uniswap?

-- How are the whales behaving, do they have a big impact on the market?

--**Pair Creation**: Has the introduction of Memecoins led to an increase or decrease in the number of pairs created on Uniswap?

-- Are there any notable trends or preferences in terms of the Memecoin pairs being created?

--**Impact “normal” pairs**: Did the rise of Memecoins have any discernible effect on the activity and liquidity of "normal" pairs on Uniswap?

--Are there any correlations or shifts in trading behaviour?

with

users as (

select distinct trader,

sum(amount_out_usd) as volume_moved,

count(distinct tx_hash) as total_swaps,

count(distinct trunc(block_timestamp,'day')) as active_days,

avg(amount_out_usd) as avg_volume_moved,

total_swaps/active_days as swaps_per_day

from crosschain.core.ez_dex_swaps where platform ilike '%uniswap%'

and block_timestamp>=current_date-INTERVAL'3 MONTHS'

and trader in (SELECT

distinct trader

from crosschain.core.ez_dex_swaps where platform ilike '%uniswap%'

and block_timestamp>=current_date-INTERVAL'3 MONTHS' and amount_out_usd is not null and amount_out_usd<1e6

and (symbol_in in ('TRAD','PEPE','DOGE','SHIB','FLOKI','BONE','ELON','AIDOGE','TSUKA','LEASH','VOLT','KISHU','MONA','TAMA','QOM','LADYS','PIT','SAMO','DC','AKITA','VINU','HOGE','BAN','PAW','DOBO','CUMMIES','SOV','DINGO','PAPI')

or symbol_out in ('TRAD','PEPE','DOGE','SHIB','FLOKI','BONE','ELON','AIDOGE','TSUKA','LEASH','VOLT','KISHU','MONA','TAMA','QOM','LADYS','PIT','SAMO','DC','AKITA','VINU','HOGE','BAN','PAW','DOBO','CUMMIES','SOV','DINGO','PAPI'))

)

and amount_out_usd is not null and amount_out_usd<1e6

group by 1

)

SELECT

case when swaps_per_day>=100 then 'Bots'

when swaps_per_day<100 and (avg_volume_moved>=100000 or volume_moved>=1e6) and active_days<30 then 'Low-Active Whale'

when swaps_per_day<100 and (avg_volume_moved>=100000 or volume_moved>=1e6) and active_days>=30 then 'High-Active Whale'

when swaps_per_day<100 and (avg_volume_moved<100000 or volume_moved<1e6) and active_days between 5 and 30 then 'Low-Active Regular User'

when swaps_per_day<100 and (avg_volume_moved<100000 or volume_moved<1e6) and active_days>=30 then 'High-Active Regular User'

when swaps_per_day<100 and (avg_volume_moved<100000 or volume_moved<1e6) and active_days<5 then 'Passenger User'

end as type,

Run a query to Download Data

flipside

flipside