select

date(block_timestamp) as date,

sum(amount) as total_usdc_outflow,

sum(total_usdc_outflow) over ( order by date ) as cumulative_outflow

from solana.core.fact_transfers a,solana.core.dim_labels b

where a.TX_TO = b.address

and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

and date >= CURRENT_DATE - 90

group by date

,inflow AS (

select

date(block_timestamp) as date_,

sum(amount) as total_usdc_inflow,

sum(total_usdc_inflow) over ( order by date_ ) as cumulative_inflow

from solana.core.fact_transfers a,solana.core.dim_labels b

where a.TX_FROM = b.address

and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

and date_ >= CURRENT_DATE - 90

group by date_

SELECT date,

total_usdc_inflow - total_usdc_outflow AS marketcap

,cumulative_inflow - cumulative_outflow AS cum_marketcap

FROM inflow INNER JOIN outflow

ON date = date_