lm2number of buy and sell swaps for JTO token on Jupiter
Updated 2024-07-10Copy Reference Fork
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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