rajsNear Swapped For
    Updated 2022-11-03
    with prices as
    (
    SELECT
    date_trunc('{{Granularity}}', timestamp) as date,
    symbol,
    avg(price_usd) as price
    from near.core.fact_prices
    -- where symbol = 'wNEAR'
    group by 1,2
    )

    SELECT
    -- date_trunc('day', block_timestamp) as date,
    -- token_in as swapped_from,
    sum(amount_in) as swapped_from_amount,
    -- token_out as swapped_to,
    sum(amount_out) as swapped_to_amount,
    count(distinct trader) as no_of_swappers,
    count(distinct tx_hash) as no_of_swaps,
    sum(coalesce(p.price * amount_in, p.price * amount_out)) as usd_amount
    from near.core.ez_dex_swaps s
    left join prices p
    on date_trunc('{{Granularity}}', s.block_timestamp) = p.date
    and s.token_in = p.symbol
    where token_in = 'wNEAR'
    and block_timestamp >= CURRENT_DATE - interval '{{Period}} days'
    -- group by 1,2,4
    -- order by 1,3 desc


    Run a query to Download Data