RayyykTotal number of unique humans on Solana
    Updated 2022-06-21
    with table_1 as (select date_trunc('hour', block_timestamp) as hour,
    swapper as active_wallet,
    count(distinct(tx_id)) as swap_count
    from solana.core.fact_swaps
    group by 1,2
    having swap_count < 600)

    select count(distinct(active_wallet)) as total_active_wallets
    from table_1
    Run a query to Download Data