swapper,

block_timestamp as fecha,

tx_group_id,

lead(tx_group_id) over (partition by swapper order by fecha),

swap_from_asset_id,

lead(swap_from_asset_id) over (partition by swapper order by fecha),

swap_from_amount,

lead(swap_from_amount) over (partition by swapper order by fecha),

swap_to_asset_id,

lead(swap_to_asset_id) over (partition by swapper order by fecha),

swap_to_amount,

lead(swap_to_amount) over (partition by swapper order by fecha),

swap_program,

lead(swap_program) over (partition by swapper order by fecha)

FROM algorand.swaps

WHERE swap_from_asset_id IN (31566704, 312769)

AND fecha >= '2022-01-01'

AND swap_to_asset_id

LIMIT 10