HitmonleeCryptoAny Asset Holders Distribution
    Updated 2024-06-30
    with flows as (
    select
    TX_to as User_address,
    sum(AMOUNT) as flow
    from
    solana.core.fact_transfers
    where
    mint = '{{Token_Address}}'
    group by
    TX_to

    union all

    select
    TX_from as User_address,
    sum(-AMOUNT) as flow
    from
    solana.core.fact_transfers
    where
    mint = '{{Token_Address}}'
    group by
    TX_from
    ),
    main as (
    select
    User_address,
    sum(flow) as Holding_Balance
    from
    flows
    group by
    User_address
    having sum(flow) > 0.1
    )
    select
    case
    when Holding_Balance < 10 then 'A: < 10'
    QueryRunArchived: QueryRun has been archived