fantaorca rate
Updated 2022-03-16
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 tbl1 as (select count(*) as jupiter ,swap_to_mint from solana.swaps
where swap_from_mint='So11111111111111111111111111111111111111112'
and block_timestamp::date >= '2022-01-01' and succeeded=1
and swap_program='jupiter aggregator v2'
group by swap_to_mint
order by jupiter DESC
limit 5)
, tbl2 as (select count(*) as orca ,swap_to_mint from solana.swaps
where swap_from_mint='So11111111111111111111111111111111111111112'
and block_timestamp::date >= '2022-01-01' and succeeded=1
and swap_program='orca'
group by swap_to_mint
order by orca DESC
limit 5)
,tbl3 as (select sum(swap_to_amount) as jupiter,block_timestamp::date as jupiterdate from solana.swaps
where swap_from_mint='So11111111111111111111111111111111111111112'
and jupiterdate >= '2022-01-01' and succeeded=1
and swap_program='jupiter aggregator v2'
group by jupiterdate)
,tbl4 as (select sum(swap_to_amount) as orca,block_timestamp::date as orcadate from solana.swaps
where swap_from_mint='So11111111111111111111111111111111111111112'
and orcadate >= '2022-01-01' and succeeded=1
and swap_program='orca'
group by orcadate)
, tbl5 as (select count(*) as jupiter,block_timestamp::date as jupiterdate from solana.swaps
where swap_from_mint='So11111111111111111111111111111111111111112'
and jupiterdate >= '2022-01-01'
and swap_program='jupiter aggregator v2'
group by jupiterdate)
,tbl6 as(select count(*) as jupiter ,block_timestamp::date as jupiterdate from solana.swaps
where swap_from_mint='So11111111111111111111111111111111111111112'
Run a query to Download Data