fantaSwaps amount
Updated 2022-04-03
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
›
⌄
with part1 as (select count(*) as count ,block_timestamp::date as date ,swap_program
from
solana.fact_swaps
where
date >= '2022-01-01' and
(swap_program='raydium v4' or swap_program='jupiter aggregator v2' or swap_program='orca' )
and succeeded = 'True'
group by date,swap_program)
, part2 as (select count(distinct swapper) as count ,block_timestamp::date as date ,swap_program
from
solana.fact_swaps
where
date >= '2022-01-01' and
(swap_program='raydium v4' or swap_program='jupiter aggregator v2' or swap_program='orca' )
and succeeded = 'True'
group by date,swap_program)
, part3 as(select top 10 count(*) as count ,label.address_name as name
from solana.fact_swaps as swap inner join solana.dim_labels as label on label.address=swap.swap_to_mint
where
swap.swap_program='raydium v4'
and swap.block_timestamp::date >= '2022-01-01'
and swap.succeeded = 'True'
group by name
order by count(*) DESC)
, part4 as(select top 10 count(*) as count ,label.address_name as name
from solana.fact_swaps as swap inner join solana.dim_labels as label on label.address=swap.swap_from_mint
where
swap.swap_program='raydium v4'
and swap.block_timestamp::date >= '2022-01-01'
and swap.succeeded = 'True'
group by name
order by count(*) DESC)
, part5 as (select count(*) as count ,block_timestamp::date as date,label.address_name as name
from solana.fact_swaps as swap inner join solana.dim_labels as label on label.address=swap.swap_from_mint
where
swap_program='raydium v4'
Run a query to Download Data