carlesmontalaUSDC DECLINING ON SOLANA? 1
    Updated 2022-10-07
    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