elsinacomparing USDC, USDT, and UST based on swap from and to counts
Updated 2022-03-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with fromcount as(
Select address_name, count(*) as swapcountfrom
From solana.swaps, solana.labels
Where block_timestamp::date >= '2021-12-01' and swap_program = 'jupiter aggregator v2' And succeeded = 'True' And (swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_from_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
or swap_from_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' ) and swap_from_mint = address
Group by 1),
tocount as(
Select address_name, count(*) as swapcountto
From solana.swaps, solana.labels
Where block_timestamp::date >= '2021-12-01' and swap_program = 'jupiter aggregator v2' And succeeded = 'True' And (swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
or swap_to_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' ) and swap_to_mint = address
Group by 1)
select fromcount.address_name, swapcountfrom, swapcountto
from fromcount, tocount
where fromcount.address_name = tocount.address_name
Run a query to Download Data