headitmanagerCopy of 17opsol
Updated 2022-12-11
9
1
2
3
4
5
6
7
8
9
›
⌄
with coinbase_wallets as (select distinct address from solana.core.dim_labels where address_name like '%coinbase%')
select sum(amount) as volume, address_name from solana.core.fact_transfers
inner join solana.core.dim_labels
on address=mint
where tx_from in (select address from coinbase_wallets)
group by address_name
order by volume DESC
limit 10
Run a query to Download Data