MostlyData_Solana MEV program data
    Updated 2024-10-31
    with transfer_list as(
    select
    tx_id,
    tx_to,
    tx_from,
    mint,
    amount,
    floor(index) as index_test,
    index

    from solana.core.fact_transfers
    where
    block_timestamp >= current_date() - interval '{{days}} days'
    and block_timestamp < current_date()
    ),


    ordered_transfers as(
    select
    tx_id,
    tx_to,
    tx_from,
    mint,
    amount,
    index_test,
    row_number() over (partition BY tx_id ORDER BY index_test asc,
    (index - index_test) * power(10, len(cast(index as varchar)) - len(cast(index_test as varchar))) asc) AS row_number_asc,
    row_number() over (partition BY tx_id ORDER BY index_test desc,
    (index - index_test) * power(10, len(cast(index as varchar)) - len(cast(index_test as varchar))) desc) AS row_number_desc

    from transfer_list

    ),

    transaction_list_all as(
    select
    QueryRunArchived: QueryRun has been archived