nsa2000Top 5 destination of the Removed USDC from Solana
    Updated 2022-10-07
    select tx_from,
    initcap(ifnull(t2.address_name,t3.address_name)) as Origin_Label,
    count (distinct tx_id) as TX_Count,
    sum (amount) as Volume
    from solana.core.fact_transfers t1 full outer join solana.core.dim_labels t2 on t1.tx_from = t2.address
    full outer join crosschain.core.address_labels t3 on t1.tx_from = t3.address
    where label != 'solana'
    and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    and t2.label_type not in ('nft','token')
    and t3.label_type not in ('nft','token')
    and block_timestamp >= CURRENT_DATE - 93
    group by 1,2
    order by volume desc
    limit 5
    Run a query to Download Data