mattkstewHumans on Solana 4
    Updated 2022-06-19
    with tab1 as (
    select
    date_trunc('day', block_timestamp),
    tx_from,
    count(*) as count1
    from solana.core.fact_transfers
    group by 1, 2 )


    , tab3_2 as (
    select
    date_trunc('day', block_timestamp),
    tx_from as from_addy,
    count(*) as count1
    from solana.core.fact_transfers
    where block_timestamp > current_date - 60
    group by 1, 2
    )

    , tab2 as (
    select
    tx_from as addy,
    max(count1)
    from tab1
    where tx_from in (select from_addy from tab3_2)
    group by 1
    having max(count1) < 201
    order by 2 DESC )

    select
    date_trunc('day', block_timestamp) ,

    CASE
    when mint like 'So11111111111111111111111111111111111111112' then 'SOL'
    when mint like 'kinXdEcpDQeHPEuQnqmUgtYykqKGVFq6CeVX5iAHJq6' then 'KIN'
    Run a query to Download Data