headitmanagerCopy of 3opsol
Updated 2022-12-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with coinbase_to_solana as (select count(distinct tx_id) as transfer_count,count(distinct tx_from) as users , sum(amount) as volume , trunc(block_timestamp, 'DAY') as days
from solana.core.fact_transfers inner join solana.core.dim_labels
on tx_from=address
where address_name like '%coinbase%'
group by days)
, solana_to_coinbase as (select count(distinct tx_id) as transfer_count,count(distinct tx_to) as users, sum(amount) as volume, trunc(block_timestamp, 'DAY') as days
from solana.core.fact_transfers inner join solana.core.dim_labels
on tx_to=address
where address_name like '%coinbase%'
group by days)
select 'Coinbase TO Solana' , * from coinbase_to_solana
UNION
select 'Solana TO Coinbase' , * from solana_to_coinbase
Run a query to Download Data