MahrooUntitled Query
Updated 2022-12-21Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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