flipside

    near outlets of increasing trading volume 2
    adriaparcerisasnear outlets of increasing trading volume 2
    Updated 2025-06-02
    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
    WHERE block_timestamp >= CURRENT_DATE - INTERVAL '{{period}} DAYS'
    ),

    pricing_data AS (
    SELECT
    trunc(hour, 'day') AS price_date,
    token_address,
    AVG(price) AS avg_price
    FROM near.price.ez_prices_hourly
    GROUP BY 1, 2
    ),

    enriched_data AS (
    SELECT
    b.*,
    COALESCE(b.amount_in_usd, b.amount_in * p_in.avg_price) AS final_amount_in_usd,
    COALESCE(b.amount_out_usd, b.amount_out * p_out.avg_price) AS final_amount_out_usd
    FROM base_data b
    LEFT JOIN pricing_data p_in
    ON b.trade_date = p_in.price_date
    AND b.token_in_contract = p_in.token_address
    Last run: 18 days ago
    TRADE_DATE
    CATEGORY
    TOTAL_SWAPS
    UNIQUE_TRADERS
    TOTAL_VOLUME_USD
    AVG_TRADE_VOLUME
    MAX_TRADE_VOLUME
    MEDIAN_TRADE_VOLUME
    1
    		2025-06-08 00:00:00.000Bot1415649732755.04406163248.4338055432998.44907996813.613029536
    2
    		2025-06-08 00:00:00.000Stablecoin707335214115.901931837186.34978410115818.7257368436.05012
    3
    		2025-06-08 00:00:00.000Regular User151049091485.32041604660.7069146765428.6671580078.784
    4
    		2025-06-08 00:00:00.000Meme Cooking5544844108.32863783991.321591383166.4033309114.421887479
    5
    		2025-06-07 00:00:00.000Bot1451451777332.69876279447.9598160644859.90604976815.615223725
    6
    		2025-06-07 00:00:00.000Stablecoin793426344398.208824027275.518567059177082.0932440565.050267024
    7
    		2025-06-07 00:00:00.000Regular User1528546116340.89931034576.48974313615132.5164412256.09724894
    8
    		2025-06-07 00:00:00.000Meme Cooking5805044342.77269180890.127586772164.030484201113.917641969
    9
    		2025-06-06 00:00:00.000Bot15815511175931.2739581761.9530727553989.83629316621.547389864
    10
    		2025-06-06 00:00:00.000Stablecoin721332342486.525170534272.89762961845100.6897826166.723655
    11
    		2025-06-06 00:00:00.000Regular User1198447173839.71511612145.10827639157258.2622422226.492535784
    12
    		2025-06-06 00:00:00.000Meme Cooking5844642412.43947056286.379713789175.561963065111.113175876
    13
    		2025-06-05 00:00:00.000Bot20258501997331.1806115672.7386714965020.69984997526.65899164
    14
    		2025-06-05 00:00:00.000Stablecoin1018296767267.548852593423.43683711521802.04158011825.011943832
    15
    		2025-06-05 00:00:00.000Regular User1525486174395.684092166116.80889758422486.28482677510.085799572
    16
    		2025-06-05 00:00:00.000Meme Cooking6005944621.60053156186.981677449193.602059295112.496719381
    17
    		2025-06-04 00:00:00.000Bot16511481275733.204025761.1188235533710.80460261621.664236
    18
    		2025-06-04 00:00:00.000Stablecoin953441480569.365254281282.18987977431807.6613116525.99483479
    19
    		2025-06-04 00:00:00.000Regular User1565548248494.297749683157.17539389640623.4650264397.663741725
    20
    		2025-06-04 00:00:00.000Meme Cooking5647147489.82596359997.9171669351292.177890206115.810033252
    ...
    360
    37KB
    764s