alessio9567USDC total market cap over time - monthly
Updated 2023-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH
outflow AS (
SELECT
date_trunc('month', block_timestamp)::date as outflow_date,
sum(amount) as outflow_amount,
sum(outflow_amount) OVER (
ORDER BY
outflow_date
) AS cum_outflow_amount
FROM
solana.core.fact_transfers t
JOIN solana.core.dim_labels l ON t.tx_to = l.address
WHERE
mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC token address
GROUP BY
1
),
inflow AS (
SELECT
date_trunc('month', block_timestamp)::date as inflow_date,
sum(amount) as inflow_amount,
sum(inflow_amount) OVER (
ORDER BY
inflow_date
) AS cum_inflow_amount
FROM
solana.core.fact_transfers t
JOIN solana.core.dim_labels l ON t.tx_from = l.address
WHERE
mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC token address
GROUP BY
1
)
SELECT
inflow_amount,