lm2number of buy and sell swaps for JTO token on Jupiter
    Updated 2024-07-10
    -- example query: number of buy and sell swaps for JTO token on Jupiter
    with sells as (
    select
    block_timestamp :: date dt,
    sum(swap_from_amount) sum_sells,
    count(distinct(swapper)) as unique_sellers
    from
    solana.defi.fact_swaps_jupiter_summary
    where
    swap_from_mint = 'jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL'
    and block_timestamp :: date = '2024-07-01'
    group by
    1
    ),
    buys as (
    select
    block_timestamp :: date dt,
    sum(swap_to_amount) sum_buys,
    count(distinct(swapper)) as unique_buyers
    from
    solana.defi.fact_swaps_jupiter_summary
    where
    swap_to_mint = 'jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL'
    and block_timestamp :: date = '2024-07-01'
    group by
    1
    )
    select
    a.dt,
    a.sum_sells,
    a.unique_sellers,
    b.sum_buys,
    b.unique_buyers
    from
    sells a
    left join buys b on a.dt = b.dt;
    QueryRunArchived: QueryRun has been archived