CryptoIcicleSolana-Foundation-2.Tracking USDC & USDT on Solana - Exchange
Updated 2022-06-17
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
›
⌄
-- Tracking USDC & USDT on Solana
-- Payout 5.2 SOL
-- Grand Prize 15.5 SOL
-- Level Advanced
-- Q2. What's the current market share for USDC and USDT on Solana relative to other stablecoins in the ecosystem
-- (look into USDC, USDT, UXD, USDH, PAI, NIRV, UST, DAI, FRAX)?
-- Create a visualization showing the amount of transaction volume for USDC vs. USDT etc. do display popularity within Solana.
-- For USDC and USDT specifically, breakdown the transaction activity by contract and exchange flows
-- (i.e. which dapps and addresses hold the majority of USDC and USDT and what do cumulative flows to and from exchanges look like over time)?
-- Reference these older dashboards by ltirrell and adriaparcerisas as examples:
-- https://app.flipsidecrypto.com/dashboard/stablecoin-popularity-UOlg-v
-- https://app.flipsidecrypto.com/dashboard/solana-stables-EJCpX0
with
sol_labels as (
select 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' as token_address, 'USDC' as token union
select 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' as token_address, 'USDT' as token
),
from_cex as (
select
block_timestamp,
'inflow' as direction,
label,
token,
amount
from solana.core.fact_transfers t
join sol_labels l on t.mint = l.token_address
join solana.core.dim_labels l2 on l2.label_type = 'cex' and l2.address = tx_from
),
to_cex as (
select
block_timestamp,
'outflow' as direction,
label,
Run a query to Download Data