greyswanaverage swaps
Updated 2024-02-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
--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