flipside

    Top 15 Pairs by Volume
    MasiTop 15 Pairs by Volume
    Updated 2024-10-06
    with tb1 as ( select trunc(hour,'day') as day,
    'aurora' as token_address,
    avg(price) as avg_price
    from near.price.ez_prices_hourly
    where symbol = 'ETH'
    group by 1,2
    UNION
    select trunc(hour,'day') as day,
    '3.contract.portalbridge.near' as token_address,
    1 as avg_price
    from near.price.ez_prices_hourly
    where symbol = 'ETH'
    UNION
    Select trunc(TO_TIMESTAMP(value[0]::string),'day') as day,
    'usmeme.tg' as token_address,
    avg(value[1]) as avg_price
    from (
    SELECT livequery.live.udf_api(
    'https://api.coingecko.com/api/v3/coins/usmeme/market_chart?vs_currency=usd') as resp
    )
    ,LATERAL FLATTEN (input => resp:data:prices)
    group by all
    UNION
    Select trunc(TO_TIMESTAMP(value[0]::string),'day') as day,
    'token.jumbo_exchange.near' as token_address,
    avg(value[1]) as avg_price
    from (
    SELECT livequery.live.udf_api(
    'https://api.coingecko.com/api/v3/coins/jumbo-exchange/market_chart?vs_currency=usd') as resp
    )
    ,LATERAL FLATTEN (input => resp:data:prices)
    group by all
    UNION
    Select trunc(TO_TIMESTAMP(value[0]::string),'day') as day,
    'celo.token.a11bd.near' as token_address,
    avg(value[1]) as avg_price
    Last run: 2 months ago
    PAIR
    SWAPS
    TRADERS
    Avg Swaps Per User
    Total Volume (USD)
    Avg Volume Per User
    Avg Swap Volume (USD)
    Max Volume (USD)
    Median Volume (USD)
    1
    		USDC->USDt2648281909013.872603157561871.609098253.633923996588.668642854428487.8478.307645308
    2
    		USDt->USDC2689671529217.588739152435586.0215069968.322392199560.044036304420307.591306078473.449164
    3
    		wNEAR->USDC87790205024.28202148558302.17706752368.466597262547.19745523127635.25829384235.296
    4
    		USDC->wNEAR98615226984.34465646830009.74620472063.177801842470.303590759111980.094778502201.904273844
    5
    		wNEAR->USDT.e3554401016534.96704435551962.03438243497.48765709699.5331913949071.27714145270.284449124
    6
    		wNEAR->USDt293805341448.60487931607623.9623661925.715322234106.6697173689071.27714145267.64
    7
    		USDT.e->wNEAR3323001053231.55146230159982.56599182863.65197170490.1988879637999.42465.705044074
    8
    		10540632518941.84616329713449.70445771179.62006052126.56955407951877.7740723952.92616332
    9
    		USDt->wNEAR278611429316.48973926034659.9676186606.43031766492.5370809577446.24675311154.006514
    10
    		USDC->FRAX103225105098.30952423240102.015984322133.430491414224.66794934399998.890099162.640027215
    11
    		FRAX->USDC120314152787.87498423140202.6879161514.609417981191.80248568599628.8152.508992598
    12
    		STNEAR->wNEAR1079315426.99935115124225.96062499808.188041911297.4372446281919539.004097326.21270995
    13
    		wNEAR->STNEAR845612027.03494214708794.81143712236.9341193321673.355496182603024.532701683.657370434
    14
    		wNEAR->FRAX52283153763.40029911602535.3362058754.587365778221.79915001118142.554282903121.432466824
    15
    		FRAX->wNEAR35448104933.79218311049999.237612310533.841027276310.9522522976731.626606377221.758496245
    15
    2KB
    163s