shreexWallets Preordered And How Active Are They In Solana
    Updated 2022-06-24
    with wallets as (
    select

    inner_instruction:instructions[1]:parsed:info:authority as wallets_preordered

    from solana.core.fact_events where program_id='781wH11JGQgEoBkBzuc8uoQLtp8KxeHk1yZiS1JhFYKy' and succeeded='TRUE'
    and block_timestamp>= '2022-06-23'

    )
    select
    wallets_preordered,
    count(distinct tx_id) as count_of_txs
    from wallets ,solana.core.fact_transfers
    where tx_from=wallets_preordered
    GROUP BY 1
    ORDER BY count_of_txs DESC


    Run a query to Download Data