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