MLDZMNflow.8
    Updated 2022-08-14
    with tb1 as (SELECT
    *
    FROM solana.core.dim_labels where label_type = 'cex' and label_subtype = 'hot_wallet'
    )

    select
    LABEL as token,
    count(distinct tx_id) as no_usage
    from solana.core.fact_transfers s left outer join solana.core.dim_labels b on s.mint=b.ADDRESS
    where TX_FROM in (select ADDRESS from tb1)
    and BLOCK_TIMESTAMP>=CURRENT_DATE-180
    group by 1 having token is not null
    order by 2 desc limit 10