Ramahar4. Stablecoin Popularity
Updated 2022-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with transactions_data as (select *
from solana.transactions
--where dayz >= '2022-01-01' AND succeeded = 'TRUE'
--group by 1
where pre_mint IN ( '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
and post_mint IN ('9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
and succeeded = 'TRUE' and date(block_timestamp) >= '2022-01-01')
--limit 50
SELECT
CASE
when 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' IN (pre_mint, post_mint) then 'USDC token'
when 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' IN (pre_mint, post_mint) then 'USDT token'
when '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' IN (pre_mint, post_mint) then 'UST token'
end as category,
count(tx_id) as no_of_transactions
from transactions_data
group by 1
Run a query to Download Data