nsa2000Removing USDC from Solana Blockchain
Updated 2022-10-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select block_timestamp::date as date,
initcap(ifnull(t2.address_name,t3.address_name)) as Destination_Label,
count (distinct tx_id) as TX_Count,
count (distinct tx_from) as Users_Count,
sum (amount) as Volume,
sum (Volume) over (partition by Destination_Label order by date) as Cumulative_Volume
from solana.core.fact_transfers t1 join solana.core.dim_labels t2 on t1.tx_to = t2.address
join crosschain.core.address_labels t3 on t1.tx_to = t3.address
where label != 'solana'
and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and t2.label_type not in ('nft','token')
and t3.label_type not in ('nft','token')
and block_timestamp >= CURRENT_DATE - 93
group by 1,2
Run a query to Download Data