MoDeFi#sol - Tracking USDC & USDT on Solana 5
    Updated 2022-06-16
    with stable_transfers_to_cex as
    (select BLOCK_TIMESTAMP::date as date, b.ADDRESS_NAME as token_name, TX_TO, amount, c.ADDRESS_NAME as cex_name
    from solana.core.fact_transfers a
    left join solana.core.dim_labels b
    on b.ADDRESS=MINT
    left join solana.core.dim_labels c
    on c.ADDRESS=tx_FROM
    where c.LABEL_TYPE='cex' and MINT in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'))


    select token_name, cex_name, count(*) as TRANSFER_count, count(distinct TX_TO) as users_count, sum(amount) as total_amount
    from stable_transfers_to_cex
    group by token_name, cex_name
    Run a query to Download Data