Sandeshsolana pull
    Updated 2022-09-28
    with first_txn as
    (
    select *,instruction:"accounts"[0] as buyer from solana.core.fact_events
    where block_timestamp >= current_date - interval '1 week'
    -- and program_id='MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'
    qualify (row_number() over(partition by buyer order by block_timestamp asc)=1)
    ),
    first_eden_txn as
    (
    select * from first_txn
    where program_id='MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'
    -- qualify (row_number() over(partition by buyer order by block_timestamp asc)=1)
    )
    select
    count(distinct fet.buyer)/count(distinct ft.buyer) as pull_factor
    from first_eden_txn fet, first_txn ft


    Run a query to Download Data