flipside

    Daily Numbers
    MasiDaily Numbers
    Updated 2025-03-27
    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: 15 days ago
    DAILY
    Swappers
    Swaps
    Avg Swap Per User
    Volume
    Avg Volume Per User
    Average Volume
    Median Volume
    Max Volume
    Token (IN)
    Token (OUT)
    Pools
    AVG_7_DAY_MOVING_VOLUME
    AVG_7_DAY_MOVING_USER_COUNT
    1
    		2025-01-01 00:00:00.0003156118533.7557032252247713.639733841142085838959234422522473156
    2
    		2025-01-02 00:00:00.0002326109254.69690525981471117.002149613139369545412411245824251972741
    3
    		2025-01-03 00:00:00.0002075110355.31807225881461247.299277108138377999011912242624795132519
    4
    		2025-01-04 00:00:00.000185486434.6618121361543734.381337648993119447948629722000212353
    5
    		2025-01-05 00:00:00.0002903117014.0306581979046681.7244230111072313230411610335821558262463
    6
    		2025-01-06 00:00:00.0002833146245.16201960457752134.0540063542583630611613412141428041512525
    7
    		2025-01-07 00:00:00.0003780160224.23862453653621419.407936508216504073941079936431700382704
    8
    		2025-01-08 00:00:00.0003981213885.37251946969781179.8487817131465350985959634233609062864
    9
    		2025-01-09 00:00:00.0001754146378.34492640326832299.13511972617482115558818226335834602688
    10
    		2025-01-10 00:00:00.0002035132196.49582327270481340.07272727313560116236777925235995732652
    11
    		2025-01-11 00:00:00.0002641108154.095041138514431.092010602731377998908430034183692723
    12
    		2025-01-12 00:00:00.0005771151532.6257151025201177.6470282454731067910610043933763263212
    13
    		2025-01-13 00:00:00.0005880256514.36241563160411074.1566326531494114999010710752339184503584
    14
    		2025-01-14 00:00:00.00034266575001.678048245334871.5971516962917956113012868234693977514
    15
    		2025-01-15 00:00:00.0008713250912.879723261636374.341329049861013687310410246932064318130
    16
    		2025-01-16 00:00:00.0001960125166.38571421606241102.35918367311134170325989833828893877878
    17
    		2025-01-17 00:00:00.0002712160465.91666767884382503.11135693225139428477989831932338567997
    18
    		2025-01-18 00:00:00.0002411176097.30360870433532921.3409373724744420225929627737733948044
    19
    		2025-01-19 00:00:00.0002736259479.48355374942992739.14437134516872352541009732745678688056
    20
    		2025-01-20 00:00:00.0003985334058.38268589515932246.32195734159735854010210337455586677833
    86
    9KB
    99s