Abolfazl_771025total usdt marketcap
Updated 2022-10-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with usdt_in as (select
sum(amount) as "volume of usdt(in)"
from solana.core.fact_transfers a , solana.core.dim_labels b
where a.tx_from = b.address and mint ='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
),usdt_out as (select
sum(amount) as "volume of usdt(out)"
from solana.core.fact_transfers a,solana.core.dim_labels b
where a.tx_to = b.address
and mint='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
)
select
"volume of usdt(in)" - "volume of usdt(out)" as marketcap
from usdt_in,usdt_out
Run a query to Download Data