cheeyoung-kekUSDC sol 4
Updated 2022-10-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc('week', block_timestamp) as date,
address_name,
sum(amount) as "total outflow",
sum("total outflow") over ( order by date ) as cum_outflow
from solana.core.fact_transfers a
join solana.core.dim_labels b
on a.TX_TO = b.address
where MINT in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
and label_type = 'cex'
and date >= '2022-01-01'
group by 1,2
order by 1 desc
Run a query to Download Data