ML67ava
Updated 2023-04-16Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with cex_address_table as
(
select address,project_name from avalanche.core.dim_labels
where label_type='cex'
)
, token_transfers_Cex_to_Avalanche_table as
(
select count(distinct FROM_ADDRESS) as users , sum(AMOUNT_USD) as volume_usd , project_name , trunc(block_timestamp, 'week') as date_time
from avalanche.core.ez_token_transfers
inner join cex_address_table
on address=FROM_ADDRESS
group by project_name , date_time
)
, token_transfers_Avalanche_to_Cex_table as
(
select count(distinct FROM_ADDRESS) as users , sum(AMOUNT_USD) as volume_usd , project_name , trunc(block_timestamp, 'week') as date_time
from avalanche.core.ez_token_transfers
inner join cex_address_table
on address=TO_ADDRESS
group by project_name , date_time
)
select users,volume_usd,project_name , date_time
from token_transfers_Avalanche_to_Cex_table
Run a query to Download Data