chillSwap Count
Updated 2022-06-05
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 swap_count as (select count(1) as cnt,date(block_timestamp) as dt,
CASE
WHEN dt='2022-05-01' or dt='2022-06-01' then 'Outages date'
else 'other date' end as highlight
from solana.fact_swaps
where dt>='2022-04-20'
group by dt,highlight)
,swap_count_orca as (select count(1) as cnt,date(block_timestamp) as dt,
CASE
WHEN dt='2022-05-01' or dt='2022-06-01' then 'Outages date'
else 'other date' end as highlight
from solana.fact_swaps
where dt>='2022-04-20'
and swap_program='orca'
group by dt,highlight,swap_program)
,swap_count_raydium as (select count(1) as cnt,date(block_timestamp) as dt,
CASE
WHEN dt='2022-05-01' or dt='2022-06-01' then 'Outages date'
else 'other date' end as highlight
from solana.fact_swaps
where dt>='2022-04-20'
and swap_program='raydium v4'
group by dt,highlight,swap_program)
,swap_count_jupiter as (select count(1) as cnt,date(block_timestamp) as dt,
CASE
WHEN dt='2022-05-01' or dt='2022-06-01' then 'Outages date'
else 'other date' end as highlight
from solana.fact_swaps
where dt>='2022-04-20'
and swap_program='jupiter aggregator v2'
group by dt,highlight,swap_program)
, swap_from_stablecoin as (select count(1) as cnt,date(block_timestamp) as dt,
CASE
WHEN dt='2022-05-01' or dt='2022-06-01' then 'Outages date'
else 'other date' end as highlight
from solana.fact_swaps
Run a query to Download Data