with inputs as (select sum(AMOUNT) as involume , date_trunc('week', BLOCK_TIMESTAMP) as weeks from solana.core.fact_transfers
where date_trunc('day', BLOCK_TIMESTAMP) > current_date - interval '70 days' and MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and TX_FROM='5tzFkiKscXHK5ZXCGbXZxdw7gTjjD1mBwuoFbhUvuAi9'
group by weeks)
, outputs as (select sum(AMOUNT) as outvolume , date_trunc('week', BLOCK_TIMESTAMP) as weeks from solana.core.fact_transfers
where date_trunc('day', BLOCK_TIMESTAMP) > current_date - interval '70 days' and MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and TX_TO='5tzFkiKscXHK5ZXCGbXZxdw7gTjjD1mBwuoFbhUvuAi9'
group by weeks)
select involume-outvolume as total ,inputs.weeks from inputs inner join outputs on inputs.weeks=outputs.weeks