marquVpe Sandwhich - v1.3 - aggregated - bundles weekly heatmap
    Updated 2025-01-23
    with

    createsandwhichv2_txs as (

    select
    instruction :accounts[2] as sandwhich_acc
    from solana.core.fact_events
    where succeeded
    and program_id = 'vpeNALD89BZ4KxNUFjdLmFXBCwtyqBDQ85ouNoax38b'
    and substr(livequery.utils.udf_base58_to_hex(instruction :data), 3, 16) = 'b3ecc1a00df8fe9a' -- CreateSandwhichV2
    and block_timestamp ::date > current_date() - interval '30 days'
    ),

    swap_in_txs as (

    select

    fact_events.block_timestamp
    , fact_events.block_id
    , fact_events.tx_id as fr_tx_id
    , fee / pow(10,9) as fee_swap_in
    , createsandwhichv2_txs.sandwhich_acc

    , swapper as fr_swapper
    , swap_from_amount as fr_swap_from_amount
    , swap_from_mint as fr_swap_from_mint
    , swap_to_amount as fr_swap_to_amount
    , swap_to_mint as fr_swap_to_mint

    from solana.core.fact_events
    inner join createsandwhichv2_txs
    on fact_events.instruction :accounts[6] = createsandwhichv2_txs.sandwhich_acc
    or fact_events.instruction :accounts[7] = createsandwhichv2_txs.sandwhich_acc
    left join solana.defi.fact_swaps
    QueryRunArchived: QueryRun has been archived