goozeguztx_fetching
    Updated 2024-10-25
    with all_txs as (
    select
    swap_program,
    block_id,
    block_timestamp as a_time,
    tx_id as a_tx,
    program_id,
    swapper,
    swap_from_mint,
    swap_from_symbol,
    swap_from_amount,
    swap_from_amount_usd,
    swap_to_mint,
    swap_to_symbol,
    swap_to_amount,
    swap_to_amount_usd,
    _log_id,
    inserted_timestamp,
    modified_timestamp,
    ez_swaps_id
    from solana.defi.ez_dex_swaps
    where swap_to_mint = 'FqnqT1GKi8S4Gyk5wnSKvJjXW48HqGtKJt9WS4o2pump'
    or swap_from_mint = 'FqnqT1GKi8S4Gyk5wnSKvJjXW48HqGtKJt9WS4o2pump'
    order by block_timestamp asc
    ),
    hui as (
    select
    block_timestamp as sol_t,
    tx_id as sol_tx,
    owner,
    pre_balance,
    balance
    from
    solana.core.fact_sol_balances
    inner join
    all_txs a on a.a_tx = sol_tx and a.swapper = owner and sol_t = a.a_time
    QueryRunArchived: QueryRun has been archived