HadisehUSDC Declining on Solana?7
Updated 2022-10-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH outflow AS (
select
sum(amount) as total_usdc_inflow
from solana.core.fact_transfers a,solana.core.dim_labels b
where a.TX_FROM = b.address
and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' )
,
inflow AS (
select
sum(amount) as total_usdc_outflow
from solana.core.fact_transfers a,solana.core.dim_labels b
where a.TX_TO = b.address
and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
SELECT total_usdc_inflow - total_usdc_outflow AS marketcap
FROM inflow,outflow
Run a query to Download Data