iboo-jbj2MVStablecoin Popularity
Updated 2022-02-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with USDC1 AS( SELECT date_trunc(day,block_timestamp) as dat, count(tx_id) as USDC
from solana.transactions where (PRE_MINT= 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or post_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
and block_timestamp >= '2022-01-01' and succeeded = 'TRUE' group by 1
),
USDT1 AS( SELECT date_trunc(day,block_timestamp) as dat, count(tx_id) as USDT
from solana.transactions where (PRE_MINT= 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' or post_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
and block_timestamp >= '2022-01-01' and succeeded = 'TRUE' group by 1
),
UST1 as( SELECT date_trunc(day,block_timestamp) as dat, count(tx_id) as UST
from solana.transactions where(PRE_MINT= '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' or post_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i')
and block_timestamp >= '2022-01-01' and succeeded = 'TRUE' group by 1
)
select UST1.dat as day,
USDC,
USDT,
UST
from UST1 JOIN USDT1 ON UST1.dat = USDT1.dat JOIN USDC1 ON UST1.dat = USDC1.dat GROUP by 1,2,3,4
Run a query to Download Data