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