carlesmontalaUSDC DECLINING ON SOLANA? 1
Updated 2022-10-07
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
USDC_outflow as (select sum(amount) as USDC_outflow_amount from solana.core.fact_transfers t,solana.core.dim_labels l
where
t.TX_TO = l.address and mint ='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'), --USDC
USDT_outflow as (select sum(amount) as USDT_outflow_amount from solana.core.fact_transfers t,solana.core.dim_labels l
where
t.TX_TO = l.address and mint ='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'), --USDT
UST_outflow as (select sum(amount) as UST_outflow_amount from solana.core.fact_transfers t,solana.core.dim_labels l
where
t.TX_TO = l.address and mint ='9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i'), --UST
USDH_outflow as (select sum(amount) as USDH_outflow_amount from solana.core.fact_transfers t,solana.core.dim_labels l
where
t.TX_TO = l.address and mint ='USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'), --USDH
DAI_outflow as (select sum(amount) as DAI_outflow_amount from solana.core.fact_transfers t,solana.core.dim_labels l
where
t.TX_TO = l.address and mint ='Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS'), --DAI
USDC_inflow as (select sum(amount) as USDC_inflow_amount from solana.core.fact_transfers t,solana.core.dim_labels l
where
t.TX_FROM = l.address and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'), --USDC
USDT_inflow as (select sum(amount) as USDT_inflow_amount from solana.core.fact_transfers t,solana.core.dim_labels l
where
t.TX_FROM = l.address and mint='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'), --USDT
UST_inflow as (select sum(amount) as UST_inflow_amount from solana.core.fact_transfers t,solana.core.dim_labels l
where
t.TX_FROM = l.address and mint='9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i'), --UST
USDH_inflow as (select sum(amount) as USDH_inflow_amount from solana.core.fact_transfers t,solana.core.dim_labels l
where
t.TX_FROM = l.address and mint='USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'), --USDH
DAI_inflow as (select sum(amount) as DAI_inflow_amount from solana.core.fact_transfers t,solana.core.dim_labels l
where
t.TX_FROM = l.address and mint='Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS') --DAI
select 'USDC' as stablecoins ,USDC_inflow_amount - USDC_outflow_amount as stablecoins_marketcap from USDC_inflow,USDC_outflow
UNION
select
'USDT' as stablecoins ,USDT_inflow_amount - USDT_outflow_amount as stablecoins_marketcap from USDT_inflow,USDT_outflow
UNION
Run a query to Download Data