mehdimarjanTotal USDC Market Cap
Updated 2022-10-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH "Out" AS (
SELECT sum(amount) AS "Amount Out"
FROM solana.core.fact_transfers t
INNER JOIN solana.core.dim_labels l
ON tx_to = address
WHERE mint ='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC Address
AND block_timestamp::date < CURRENT_DATE
),
"In" AS (
SELECT SUM(amount) AS "Amount In"
FROM solana.core.fact_transfers t
INNER JOIN solana.core.dim_labels l
ON tx_from = address
WHERE mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC Address
)
SELECT "Amount In" - "Amount Out" AS "Market Cap"
FROM "In", "Out"
Run a query to Download Data