flipside

    pnut rock holderss
    mmdrezapnut rock holderss
    Updated 2024-11-19
    with tab1 as (with main as (
    SELECT
    distinct owner AS holder_address,
    sum (balance) as balancee
    FROM
    solana.core.fact_token_balances
    WHERE
    mint = '2qEHjDLDLbuBgRYvsxhc5D6uDWAivNFZGan56P1tpump'
    AND DATE(block_timestamp) = '2024-11-1'
    group by
    1
    ORDER BY
    balancee DESC
    )
    select
    distinct holder_address,
    balancee
    from
    main
    where
    balancee < 200000000
    and balancee >= 100000
    order by
    balancee desc),

    tab2 as (with main as (
    SELECT
    distinct owner AS holder_address,
    sum (balance) as balancee
    FROM
    solana.core.fact_token_balances
    WHERE
    mint = '2qEHjDLDLbuBgRYvsxhc5D6uDWAivNFZGan56P1tpump'
    AND DATE(block_timestamp) = '2024-11-13'
    group by
    1
    QueryRunArchived: QueryRun has been archived