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