nsa2000Removing USDC from Solana Blockchain
    Updated 2022-10-07
    select block_timestamp::date as date,
    initcap(ifnull(t2.address_name,t3.address_name)) as Destination_Label,
    count (distinct tx_id) as TX_Count,
    count (distinct tx_from) as Users_Count,
    sum (amount) as Volume,
    sum (Volume) over (partition by Destination_Label order by date) as Cumulative_Volume
    from solana.core.fact_transfers t1 join solana.core.dim_labels t2 on t1.tx_to = t2.address
    join crosschain.core.address_labels t3 on t1.tx_to = 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
    Run a query to Download Data