sarathdecline_usdcc1
Updated 2022-10-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH USDC_OUTFLOW AS (
SELECT
sum(amount) AS OUTFLOW
FROM
solana.core.fact_transfers t,
solana.core.dim_labels d
WHERE t.TX_TO = d.ADDRESS
AND mint ='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
),
USDC_INFLOW AS (
SELECT
sum(amount) AS INFLOW
FROM
solana.core.fact_transfers t,
solana.core.dim_labels d
WHERE t.TX_FROM = d.ADDRESS
AND mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
)
SELECT
INFLOW - OUTFLOW AS USDC_MARKETCAP
FROM USDC_INFLOW, USDC_OUTFLOW
Run a query to Download Data