MLDZMNflow.10
    Updated 2022-08-14
    with tb1 as (SELECT
    *
    FROM solana.core.dim_labels where label_type = 'cex' and label_subtype = 'hot_wallet'
    ),
    tb2 as (select
    block_timestamp,
    TX_TO as u1,
    tx_id
    from solana.core.fact_transfers
    where TX_FROM in (select ADDRESS from tb1)
    and BLOCK_TIMESTAMP>=CURRENT_DATE-180
    ),

    tb3 as (select
    s.block_timestamp,
    s.TX_TO as u2,
    s.tx_id
    from solana.core.fact_transfers s join tb2 b on s.TX_FROM=b.u1
    where s.block_timestamp>b.block_timestamp
    and s.BLOCK_TIMESTAMP>=CURRENT_DATE-180
    limit 100000)

    select
    distinct EVENT_TYPE as first_actions,
    count(distinct tx_id) as counts
    from solana.core.fact_events
    where tx_id in (select tx_id from tb3)
    group by 1
    having first_actions is not null
    order by 2 desc limit 10





    Run a query to Download Data