barbodTransferred USDC transacion count
    Updated 2022-12-10
    select
    date_trunc(day, BLOCK_TIMESTAMP)::date as date,
    LABEL_TYPE,
    sum(amount) as toal_amount,
    sum(toal_amount) over (partition by LABEL_TYPE order by date rows between unbounded preceding and current row ) as cum_toal_amount,
    count(tx_id) as transaction_count,
    sum(transaction_count) over (partition by LABEL_TYPE order by date rows between unbounded preceding and
    current row ) as cum_transaction_count
    from solana.core.fact_transfers t,solana.core.dim_labels l
    where t.TX_TO = l.address
    and mint in (--'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'-- usdt,
    'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --usdc
    )
    -- and LABEL_TYPE = 'cex'
    AND BLOCK_TIMESTAMP::date >= '2022-10-01'
    group by 1,2
    order by 1

    Run a query to Download Data