MahrooUntitled Query
    Updated 2022-12-21
    with outflow as (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 ='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'),

    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='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')

    select inflow_amount - outflow_amount as market_cap
    from inflow,outflow
    Run a query to Download Data