SELECT sum(amount) AS outflow_amount

FROM solana.core.fact_transfers t

,solana.core.dim_labels l

WHERE t.TX_TO = l.address

AND mint ='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')

, inflow AS (

SELECT sum(amount) AS inflow_amount

FROM solana.core.fact_transfers t

,solana.core.dim_labels l

WHERE t.TX_FROM = l.address

and mint='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')

SELECT

inflow_amount,

outflow_amount,

inflow_amount - outflow_amount AS "market cap"

FROM inflow,outflow