MLDZMNflow.1
Updated 2022-08-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tb1 as (SELECT
*
FROM Ethereum.core.dim_labels where label_type = 'cex' and label_subtype = 'hot_wallet'
)
select
BLOCK_TIMESTAMP::date as day,
count(distinct tx_hash) as no_usage,
sum(AMOUNT_USD) as USD_flow,
sum(USD_flow) over (order by day asc) as cum_flow,
avg(AMOUNT_USD) as average_move
from ethereum.core.ez_token_transfers
where FROM_ADDRESS in (select ADDRESS from tb1)
and BLOCK_TIMESTAMP>=CURRENT_DATE-180
group by 1
Run a query to Download Data