adriaparcerisasnear memedotcooking 4
    Updated 6 days ago
    WITH base_data AS (
    SELECT
    trunc(block_timestamp, 'day') AS trade_date,
    tx_hash,
    trader,
    token_in_contract,
    symbol_in,
    token_out_contract,
    symbol_out,
    amount_in,
    amount_out,
    amount_in_usd,
    amount_out_usd,
    pool_id
    FROM near.defi.ez_dex_swaps
    ),

    pricing_data AS (
    SELECT
    trunc(b.block_timestamp, 'day') AS price_date,
    b.token_in_contract,
    b.token_out_contract,
    -- Price of token_in in terms of wNEAR (amount_out / amount_in when wNEAR is output)
    AVG(CASE
    WHEN b.symbol_out = 'wNEAR' AND b.amount_in > 0 AND b.amount_out > 0
    THEN b.amount_out / b.amount_in
    ELSE NULL
    END) AS price_in_terms_of_wnear,
    -- Price of token_out in terms of wNEAR (amount_in / amount_out when wNEAR is input)
    AVG(CASE
    WHEN b.symbol_in = 'wNEAR' AND b.amount_in > 0 AND b.amount_out > 0
    THEN b.amount_in / b.amount_out
    ELSE NULL
    END) AS price_out_in_terms_of_wnear
    FROM near.defi.ez_dex_swaps b
    Last run: 6 days ago
    TOKEN_NAME
    SWAPS
    ACTIVE_TRADERS
    VOLUME_USD
    AVG_TRADE_VOLUME
    MAX_TRADE_VOLUME
    MEDIAN_TRADE_VOLUME
    1
    purge-558.meme-cooking.near852771023416274464.2112986190.84236325551877.77407239541.544571253
    2
    abg-966.meme-cooking.near9169316316075841.5617162466.262872437053.56358687824.899687578
    3
    chill-129.meme-cooking.near22448501775174.10787556791.07580564933048.27600065998.46234937
    4
    gnear-229.meme-cooking.near2164711411208629.3654623855.8335734967522.9957902734.181154357
    5
    pumpkg-332.meme-cooking.near3685550967372.822182258262.5163696566899.62927778556.395543197
    6
    duct-1078.meme-cooking.near64191029654884.948392279102.0228927244346.16815720516.025139228
    7
    jlu-1018.meme-cooking.near20273668573150.61926436128.2716233052617.4365386147.672438016
    8
    adhd-1076.meme-cooking.near2244475397484.994755465177.1323506043660.06111555450.041861266
    9
    img_8327-1591.meme-cooking.near18251364366625.54533475920.0879702672379.8110174610.716779496
    10
    hijack-252.meme-cooking.near2453494308146.050484722125.6200776544488.24402395628.297728223
    11
    4illia-222.meme-cooking.near2362546267256.577082366113.1484238283978.39111474821.812714858
    12
    mcn-992.meme-cooking.near1796377257027.709655382143.1111969132025.46503272938.161123161
    13
    gnuff-283.meme-cooking.near2192359240920.357200124109.908922081648.42566348844.543973809
    14
    bullish-1254.meme-cooking.near152331869234848.68617537915.4171001231544.0788365693.347428927
    15
    cooked-612.meme-cooking.near966248205678.346168868212.9175426184189.23223384261.39450969
    16
    mwalc-1122.meme-cooking.near978246171247.988057223175.1001922882573.2484161734.580417141
    17
    xwiftrx-728.meme-cooking.near1488296160877.818066033108.1168132161293.40674327239.243524106
    18
    noear-324.meme-cooking.near5475694160553.54157797229.324847777687.2276424615.125562965
    19
    shit-565.meme-cooking.near5035828138024.58355071327.413025531720.5719276887.44963753
    20
    wow-1207.meme-cooking.near1108264136733.368325379123.4055670812637.94927841337.28242841
    ...
    187
    17KB
    965s