MLDZMNflow.1
    Updated 2022-08-13
    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