flipside

    flow swap **
    Moeflow swap **
    Updated 2023-04-07
    with prices as (select date(TIMESTAMP) date ,TOKEN_CONTRACT ID, SYMBOL,
    avg(PRICE_USD) as price
    from
    flow.core.fact_prices
    where
    TIMESTAMP between '2022-12-01' and CURRENT_DATE -1

    group by 1,2,3

    )

    select
    date_trunc('day', BLOCK_TIMESTAMP)::date AS day,
    SYMBOL,TOKEN_IN_CONTRACT,
    sum(TOKEN_IN_AMOUNT*price) AS Volume,
    avg(TOKEN_IN_AMOUNT*price) AS avg_Volume,
    row_number()over(partition by day order by volume desc) as rank
    from flow.core.ez_swaps s , prices p
    where
    -- TOKEN_OUT_CONTRACT ilike '%FiatToken%'
    -- and
    block_timestamp::date = date
    and TOKEN_IN_CONTRACT= ID
    and BLOCK_TIMESTAMP::date between '2023-02-15' and CURRENT_DATE - 10
    group by 1,2 ,3
    qualify rank <= 3



    Run a query to Download Data