headitmanager4opavax
Updated 2023-04-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with binance_to_Avalanche as (select count(distinct TX_HASH) as transfer_count,count(distinct FROM_ADDRESS) as users , sum(RAW_AMOUNT/pow(10,decimals)) as volume , trunc(block_timestamp, 'MONTH') as days
from avalanche.core.fact_token_transfers inner join avalanche.core.dim_labels
on FROM_ADDRESS=address
inner join avalanche.core.dim_contracts
on contract_address=avalanche.core.dim_contracts.address
where address_name like '%binance%' and RAW_AMOUNT/pow(10,decimals)< 999999999
group by days )
, Avalanche_to_binance as (select count(distinct TX_HASH) as transfer_count,count(distinct TO_ADDRESS) as users, sum(RAW_AMOUNT/pow(10,decimals)) as volume , trunc(block_timestamp, 'MONTH') as days
from avalanche.core.fact_token_transfers inner join avalanche.core.dim_labels
on TO_ADDRESS=address
inner join avalanche.core.dim_contracts
on contract_address=avalanche.core.dim_contracts.address
where address_name like '%binance%' and RAW_AMOUNT/pow(10,decimals)< 999999999
group by days)
select 'Binance TO Avalanche' , * from binance_to_Avalanche
UNION
select 'Avalanche TO Binance' , * from Avalanche_to_binance
Run a query to Download Data