greyswanaverage swaps
    Updated 2024-02-28
    --average sales
    select
    date_trunc('day', block_timestamp) as day,
    swap_from_mint,
    sum(swap_to_amount) as sale_volume,
    avg(swap_to_amount),
    count(distinct swapper) as users,
    count (tx_id) as number_of_swaps
    from
    solana.defi.fact_swaps
    where
    swap_from_mint in (
    'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263',
    'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN',
    'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm',
    'jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL',
    'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk'
    )
    and swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    and BLOCK_TIMESTAMP >= current_date - 60
    group by
    swap_from_mint,
    date_trunc('day', block_timestamp)
    order by
    date_trunc('day', block_timestamp) desc
    QueryRunArchived: QueryRun has been archived