headitmanagerthe average number of transactions a "new wallet" makes in their first 24 hours
    Updated 2022-02-11
    with new_users_transactions as
    (
    SELECT count(*) as COUNT,tx_from_address, MIN(block_timestamp :: date) As FIRST_PROGRAM_DATE
    FROM solana.transactions
    where program_id !='11111111111111111111111111111111' and block_timestamp :: date >= '2022-02-01'
    and tx_from_address in (select tx_from_address from solana.transactions
    where program_id ='11111111111111111111111111111111' and block_timestamp :: date >= '2022-02-01')
    GROUP BY tx_from_address
    )
    select sum(COUNT)/count(*) as AVERAGE from new_users_transactions

    Run a query to Download Data