headitmanagerCopy of 8opsol
Updated 2022-12-11
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with tops as (select count(distinct tx_id) as transfer_count, 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 transfer_count DESC
limit 10)
select count(distinct tx_id) as transfer_count, 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