uniswap-database-changes-pools-optimism

ciyengar3

v0.0.5/1.8K downloads/Repository

Package ref

uniswap-database-changes-pools-optimism@v0.0.5

Download .spkg

Run package

CLI

Run db_out from the command line.

substreams run uniswap-database-changes-pools-optimism@v0.0.5 db_out -e optimism

Authenticate by running substreams auth or directly on thegraph.market (see docs).

README

Database Changes `Uniswaps`

This repository contains Database Changes events for all uniswap related events.

Modules

Execution graph

7 modules

mapMain

db_out

from #27446

Output

sf.substreams.sink.database.v1.DatabaseChanges

Inputs

sf.substreams.v1.Clockuniswap_v2:map_events uniswap_v3:map_events uniswap_v4:map_events

Show 6 dependencies

map

uniswap_v2:map_events

from #112197986

Output

evm.uniswap.v2.Events

Inputs

paramssf.ethereum.type.v2.Block uniswap_v2:store_pools

store

uniswap_v2:store_pools

from #112197986

Store value

bigint

Update policy

set

Inputs

paramssf.ethereum.type.v2.Block

map

uniswap_v3:map_events

from #27446

Output

evm.uniswap.v3.Events

Inputs

paramssf.ethereum.type.v2.Block uniswap_v3:store_pools

store

uniswap_v3:store_pools

from #27446

Store value

bigint

Update policy

set

Inputs

paramssf.ethereum.type.v2.Block

map

uniswap_v4:map_events

from #130947675

Output

evm.uniswap.v4.Events

Inputs

paramssf.ethereum.type.v2.Block uniswap_v4:store_pools

store

uniswap_v4:store_pools

from #130947675

Store value

proto:evm.store.V4PoolStore

Update policy

set

Inputs

paramssf.ethereum.type.v2.Block

Protobuf

evm.uniswap.v2

Eventsmain

evm.uniswap.v2.Events

Swap[]swap = 1

UniswapV2Pair

Sync[]sync = 2

Mint[]mint = 3

Burn[]burn = 4

PairCreated[]pair_created = 5

UniswapV2Factory

AssociatedEvmTransaction[]associated_evm_transaction = 6

Transfer[]transfer = 7

Approval[]approval = 8

Approval

evm.uniswap.v2.Approval

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespair_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesowner = 11

-- event --

bytesspender = 12

address (indexed)

stringvalue = 13

uint256

Burn

evm.uniswap.v2.Burn

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespair_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytessender = 10

-- event --

stringamount0 = 11

uint256

stringamount1 = 12

uint256

bytesto = 13

address

Mint

evm.uniswap.v2.Mint

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespair_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytessender = 10

-- event --

stringamount0 = 11

uint256

stringamount1 = 12

uint256

PairCreated

evm.uniswap.v2.PairCreated

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespair_factory_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytestoken0 = 10

-- event --

bytestoken1 = 11

bytespair_address = 12

uint64all_pairs_length = 13

total number of pairs created

Swap

evm.uniswap.v2.Swap

bytestx_hash = 1

-- transaction --

bytescaller = 4

-- call --

bytespair_address = 5

-- log --

uint64ordinal = 6

log.ordinal

uint32log_index = 7

log.index

uint32transaction_index = 8

log.transaction_index

uint32block_index = 9

log.block_index

bytessender = 10

-- event --

stringamount0_in = 11

uint256

stringamount0_out = 12

uint256

stringamount1_in = 13

uint256

stringamount1_out = 14

uint256

bytesto = 15

address

Sync

evm.uniswap.v2.Sync

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespair_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

stringreserve0 = 21

-- event --

stringreserve1 = 22

uint112

Transfer

evm.uniswap.v2.Transfer

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespair_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesfrom = 11

-- event --

bytesto = 12

address (indexed)

stringvalue = 13

uint256

evm.uniswap.v3

Eventsmain

evm.uniswap.v3.Events

https://github.com/Uniswap/v3-core/blob/main/contracts/interfaces/IUniswapV3Factory.sol https://github.com/Uniswap/v3-core/blob/main/contracts/interfaces/IUniswapV3Pool.sol https://github.com/Uniswap/v3-core/blob/main/contracts/interfaces/pool/IUniswapV3PoolEvents.sol

Swap[]swap = 1

IUniswapV3Pool

Initialize[]initialize = 2

Mint[]mint = 3

Collect[]collect = 4

Burn[]burn = 5

Flash[]flash = 6

IncreaseObservationCardinalityNext[]increase_observation_cardinality_next = 7

SetFeeProtocol[]set_fee_protocol = 8

CollectProtocol[]collect_protocol = 9

PoolCreated[]pool_created = 10

IUniswapV3Factory

OwnerChanged[]owner_changed = 11

FeeAmountEnabled[]fee_amount_enabled = 12

AssociatedEvmTransaction[]associated_evm_transaction = 13

PositionManagerApproval[]position_manager_approval = 14

PositionManager (ERC721-like for V3)

PositionManagerApprovalForAll[]position_manager_approval_for_all = 15

PositionManagerCollect[]position_manager_collect = 16

PositionManagerDecreaseLiquidity[]position_manager_decrease_liquidity = 17

PositionManagerIncreaseLiquidity[]position_manager_increase_liquidity = 18

PositionManagerTransfer[]position_manager_transfer = 19

Burn

evm.uniswap.v3.Burn

/ @notice Emitted when a position's liquidity is removed / @dev Does not withdraw any fees earned by the liquidity position, which must be withdrawn via #collect / @param owner The owner of the position for which liquidity is removed / @param tickLower The lower tick of the position / @param tickUpper The upper tick of the position / @param amount The amount of liquidity to remove / @param amount0 The amount of token0 withdrawn / @param amount1 The amount of token1 withdrawn

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesowner = 10

-- event --

int32tick_lower = 11

int24

int32tick_upper = 12

int24

stringamount = 13

uint128

stringamount0 = 14

uint256

stringamount1 = 15

uint256

Collect

evm.uniswap.v3.Collect

/ @notice Emitted when fees are collected by the owner of a position / @dev Collect events may be emitted with zero amount0 and amount1 when the caller chooses not to collect fees / @param owner The owner of the position for which fees are collected / @param tickLower The lower tick of the position / @param tickUpper The upper tick of the position / @param amount0 The amount of token0 fees collected / @param amount1 The amount of token1 fees collected

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesowner = 10

-- event --

bytesrecipient = 11

address

int32tick_lower = 12

int24

int32tick_upper = 13

int24

stringamount0 = 14

uint128

stringamount1 = 15

uint128

CollectProtocol

evm.uniswap.v3.CollectProtocol

/ @notice Emitted when the collected protocol fees are withdrawn by the factory owner / @param sender The address that collects the protocol fees / @param recipient The address that receives the collected protocol fees / @param amount0 The amount of token0 protocol fees that is withdrawn / @param amount0 The amount of token1 protocol fees that is withdrawn

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytessender = 10

-- event --

bytesrecipient = 11

address

stringamount0 = 12

uint128

stringamount1 = 13

uint128

FeeAmountEnabled

evm.uniswap.v3.FeeAmountEnabled

/ @notice Emitted when a new fee amount is enabled for pool creation via the factory / @param fee The enabled fee, denominated in hundredths of a bip / @param tickSpacing The minimum number of ticks between initialized ticks for pools created with the given fee

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_factory_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

uint64fee = 10

-- event --

int32tick_spacing = 11

int24

Flash

evm.uniswap.v3.Flash

/ @notice Emitted by the pool for any flashes of token0/token1 / @param sender The address that initiated the swap call, and that received the callback / @param recipient The address that received the tokens from flash / @param amount0 The amount of token0 that was flashed / @param amount1 The amount of token1 that was flashed / @param paid0 The amount of token0 paid for the flash, which can exceed the amount0 plus the fee / @param paid1 The amount of token1 paid for the flash, which can exceed the amount1 plus the fee

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytessender = 10

-- event --

bytesrecipient = 11

address

stringamount0 = 12

uint256

stringamount1 = 13

uint256

stringpaid0 = 14

uint256

stringpaid1 = 15

uint256

IncreaseObservationCardinalityNext

evm.uniswap.v3.IncreaseObservationCardinalityNext

/ @notice Emitted by the pool for increases to the number of observations that can be stored / @dev observationCardinalityNext is not the observation cardinality until an observation is written at the index / just before a mint/swap/burn. / @param observationCardinalityNextOld The previous value of the next observation cardinality / @param observationCardinalityNextNew The updated value of the next observation cardinality

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

uint64observation_cardinality_next_old = 10

-- event --

uint64observation_cardinality_next_new = 11

uint16

Initialize

evm.uniswap.v3.Initialize

In Uniswap v3, the initialize function is a crucial setup step that configures a newly deployed pool by setting its initial square root price (sqrtPriceX96) and corresponding tick value. After the pool is created via the PoolCreated event, calling initialize establishes the starting price and essential parameters, thereby enabling the pool to process swaps and support liquidity provisioning. Without this initialization, the pool remains unconfigured and cannot operate properly.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

stringsqrt_price_x96 = 21

-- event --

int32tick = 22

int24

Mint

evm.uniswap.v3.Mint

/ @notice Emitted when liquidity is minted for a given position / @param sender The address that minted the liquidity / @param owner The owner of the position and recipient of any minted liquidity / @param tickLower The lower tick of the position / @param tickUpper The upper tick of the position / @param amount The amount of liquidity minted to the position range / @param amount0 How much token0 was required for the minted liquidity / @param amount1 How much token1 was required for the minted liquidity

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytessender = 10

-- event --

bytesowner = 11

address

int32tick_lower = 12

int24

int32tick_upper = 13

int24

stringamount = 14

uint128

stringamount0 = 15

uint256

stringamount1 = 16

uint256

OwnerChanged

evm.uniswap.v3.OwnerChanged

/ @notice Emitted when the owner of the factory is changed / @param oldOwner The owner before the owner was changed / @param newOwner The owner after the owner was changed

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_factory_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesold_owner = 10

-- event --

bytesnew_owner = 11

address

PoolCreated

evm.uniswap.v3.PoolCreated

/ @notice Emitted when a pool is created / @param token0 The first token of the pool by address sort order / @param token1 The second token of the pool by address sort order / @param fee The fee collected upon every swap in the pool, denominated in hundredths of a bip / @param tickSpacing The minimum number of ticks between initialized ticks / @param pool The address of the created pool

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_factory_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytestoken0 = 10

-- event --

bytestoken1 = 11

uint64fee = 12

uint24 (e.g., 3000 represents 0.30%)

int32tick_spacing = 13

int24 (e.g., 60)

bytespool_address = 14

address

PositionManagerApproval

evm.uniswap.v3.PositionManagerApproval

/ @notice Emitted when approval is given to approved to manage tokenId.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesposition_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesowner = 10

-- event --

bytesapproved = 11

address

stringtoken_id = 12

uint256

PositionManagerApprovalForAll

evm.uniswap.v3.PositionManagerApprovalForAll

/ @notice Emitted when operator is enabled or disabled for owner.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesposition_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesowner = 10

-- event --

bytesoperator = 11

address

boolapproved = 12

bool

PositionManagerCollect

evm.uniswap.v3.PositionManagerCollect

/ @notice Emitted when fees are collected from a position via the PositionManager.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesposition_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

stringtoken_id = 10

-- event --

bytesrecipient = 11

address

stringamount0 = 12

uint256

stringamount1 = 13

uint256

PositionManagerDecreaseLiquidity

evm.uniswap.v3.PositionManagerDecreaseLiquidity

/ @notice Emitted when a position's liquidity is decreased via the PositionManager.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesposition_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

stringtoken_id = 10

-- event --

stringliquidity = 11

uint128

stringamount0 = 12

uint256

stringamount1 = 13

uint256

PositionManagerIncreaseLiquidity

evm.uniswap.v3.PositionManagerIncreaseLiquidity

/ @notice Emitted when a position's liquidity is increased via the PositionManager.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesposition_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

stringtoken_id = 10

-- event --

stringliquidity = 11

uint128

stringamount0 = 12

uint256

stringamount1 = 13

uint256

PositionManagerTransfer

evm.uniswap.v3.PositionManagerTransfer

/ @notice Emitted when a position NFT is transferred via the PositionManager.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesposition_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesfrom = 10

-- event --

bytesto = 11

address

stringtoken_id = 12

uint256

SetFeeProtocol

evm.uniswap.v3.SetFeeProtocol

/ @notice Emitted when the protocol fee is changed by the pool / @param feeProtocol0Old The previous value of the token0 protocol fee / @param feeProtocol1Old The previous value of the token1 protocol fee / @param feeProtocol0New The updated value of the token0 protocol fee / @param feeProtocol1New The updated value of the token1 protocol fee

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

uint64fee_protocol0_old = 10

-- event --

uint64fee_protocol1_old = 11

uint8

uint64fee_protocol0_new = 12

uint8

uint64fee_protocol1_new = 13

uint8

Swap

evm.uniswap.v3.Swap

In Uniswap v3, the Swap event is emitted when a trade occurs in a liquidity pool. It provides key details of the swap, including the address of the sender initiating the swap, the recipient of the swapped tokens, and the amounts of token0 and token1 involved in the trade. Additionally, the event logs updated state parameters such as the square root price (sqrtPriceX96), current liquidity, and the tick after the swap, thereby reflecting the pool's state changes. This event is essential for on-chain tracking of trades, liquidity dynamics, and price updates.

Price Calculation: Uniswap V3 represents the current pool price using a square root price value, sqrtPriceX96, stored as a Q64.96 fixed-point number (with 64 bits for the integer part and 96 bits for the fraction). To compute the actual price of token0 in terms of token1, the value is squared and then divided by 2^192:

Conversely, to determine the price of token1 in terms of token0, take the reciprocal of the computed price.

This calculation method provides high precision and efficient on-chain computation of price ratios.

bytestx_hash = 1

-- transaction --

bytescaller = 4

-- call --

bytespool_address = 5

-- log --

uint64ordinal = 6

log.ordinal

uint32log_index = 7

log.index

uint32transaction_index = 8

log.transaction_index

uint32block_index = 9

log.block_index

bytessender = 10

-- event --

bytesrecipient = 11

address

stringamount0 = 12

int256

stringamount1 = 13

int256

stringsqrt_price_x96 = 14

uint160

stringliquidity = 15

uint128

int32tick = 16

int24

evm.uniswap.v4

Eventsmain

evm.uniswap.v4.Events

https://github.com/Uniswap/v4-core/blob/main/src/interfaces/IPoolManager.sol https://github.com/Uniswap/v4-core/blob/59d3ecf53afa9264a16bba0e38f4c5d2231f80bc/src/interfaces/IProtocolFees.sol

Swap[]swap = 1

IPoolManager

Initialize[]initialize = 2

ModifyLiquidity[]modify_liquidity = 3

Donate[]donate = 4

ProtocolFeeControllerUpdated[]protocol_fee_controller_updated = 5

IProtocolFees

ProtocolFeeUpdated[]protocol_fee_updated = 6

AssociatedEvmTransaction[]associated_evm_transaction = 7

PositionManagerApproval[]position_manager_approval = 8

PositionManager (ERC721-like + subscription hooks)

PositionManagerApprovalForAll[]position_manager_approval_for_all = 9

PositionManagerSubscription[]position_manager_subscription = 10

PositionManagerUnsubscription[]position_manager_unsubscription = 11

PositionManagerTransfer[]position_manager_transfer = 12

ModifyLiquidityWithAmounts[]modify_liquidity_with_amounts = 13

Approval[]approval = 14

IPoolManager: Other events

OperatorSet[]operator_set = 15

OwnershipTransferred[]ownership_transferred = 16

Transfer[]transfer = 17

Approval

evm.uniswap.v4.Approval

/ @notice Emitted when approval is given to spender to manage id.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesowner = 10

-- event --

bytesspender = 11

address

stringid = 12

uint256

stringamount = 13

uint256

Donate

evm.uniswap.v4.Donate

/ @notice Emitted for donations / @param id The abi encoded hash of the pool key struct for the pool that was donated to / @param sender The address that initiated the donate call / @param amount0 The amount donated in currency0 / @param amount1 The amount donated in currency1

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytespool_id = 10

-- event --

bytessender = 11

address

stringamount0 = 12

uint256

stringamount1 = 13

uint256

Initialize

evm.uniswap.v4.Initialize

/ @notice Emitted when a new pool is initialized / @param id The abi encoded hash of the pool key struct for the new pool / @param currency0 The first currency of the pool by address sort order / @param currency1 The second currency of the pool by address sort order / @param fee The fee collected upon every swap in the pool, denominated in hundredths of a bip / @param tickSpacing The minimum number of ticks between initialized ticks / @param hooks The hooks contract address for the pool, or address(0) if none / @param sqrtPriceX96 The price of the pool on initialization / @param tick The initial tick of the pool corresponding to the initialized price

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytespool_id = 10

-- event --

bytescurrency0 = 11

address (token0)

bytescurrency1 = 12

address (token1)

uint64fee = 13

uint24 (e.g., 3000 represents 0.30%)

int32tick_spacing = 14

int24 (e.g., 60)

stringsqrt_price_x96 = 17

uint160

int32tick = 18

int24

stringhooks = 19

address

ModifyLiquidity

evm.uniswap.v4.ModifyLiquidity

/ @notice Emitted when a liquidity position is modified / @param id The abi encoded hash of the pool key struct for the pool that was modified / @param sender The address that modified the pool / @param tickLower The lower tick of the position / @param tickUpper The upper tick of the position / @param liquidityDelta The amount of liquidity that was added or removed / @param salt The extra data to make positions unique

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytespool_id = 10

-- event --

bytessender = 11

address

int32tick_lower = 12

int24

int32tick_upper = 13

int24

stringliquidity_delta = 14

int128

bytessalt = 18

bytes32

ModifyLiquidityWithAmounts

evm.uniswap.v4.ModifyLiquidityWithAmounts

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytespool_id = 10

-- event --

bytessender = 11

address

int32tick_lower = 12

int24

int32tick_upper = 13

int24

stringliquidity_delta = 14

int128

bytessalt = 18

bytes32

stringliquidity_math_amount0 = 19

calculated amounts from latest pool state

stringliquidity_math_amount1 = 20

uint256

OperatorSet

evm.uniswap.v4.OperatorSet

/ @notice Emitted when operator is enabled or disabled for owner.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesowner = 10

-- event --

bytesoperator = 11

address

boolapproved = 12

bool

OwnershipTransferred

evm.uniswap.v4.OwnershipTransferred

/ @notice Emitted when the contract ownership is transferred.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesuser = 10

-- event --

bytesnew_owner = 11

address

PositionManagerApproval

evm.uniswap.v4.PositionManagerApproval

/ @notice Emitted when approval is given to spender to manage id.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesposition_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesowner = 10

-- event --

bytesspender = 11

address

stringid = 12

uint256

PositionManagerApprovalForAll

evm.uniswap.v4.PositionManagerApprovalForAll

/ @notice Emitted when operator is enabled or disabled for owner.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesposition_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesowner = 10

-- event --

bytesoperator = 11

address

boolapproved = 12

bool

PositionManagerSubscription

evm.uniswap.v4.PositionManagerSubscription

/ @notice Emitted when a position subscribes to a subscriber contract.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesposition_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

stringtoken_id = 10

-- event --

bytessubscriber = 11

address

PositionManagerTransfer

evm.uniswap.v4.PositionManagerTransfer

/ @notice Emitted when a position NFT is transferred.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesposition_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesfrom = 10

-- event --

bytesto = 11

address

stringid = 12

uint256

PositionManagerUnsubscription

evm.uniswap.v4.PositionManagerUnsubscription

/ @notice Emitted when a position unsubscribes from a subscriber contract.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesposition_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

stringtoken_id = 10

-- event --

bytessubscriber = 11

address

ProtocolFeeControllerUpdated

evm.uniswap.v4.ProtocolFeeControllerUpdated

/ @notice Emitted when the protocol fee controller address is updated in setProtocolFeeController.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesprotocol_fee_controller_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytesprotocol_fee_controller = 10

-- event --

ProtocolFeeUpdated

evm.uniswap.v4.ProtocolFeeUpdated

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytesprotocol_fee_controller_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytespool_id = 10

-- event --

uint64protocol_fee = 11

uint24

Swap

evm.uniswap.v4.Swap

/ @notice Emitted for swaps between currency0 and currency1 / @param id The abi encoded hash of the pool key struct for the pool that was modified / @param sender The address that initiated the swap call, and that received the callback / @param amount0 The delta of the currency0 balance of the pool / @param amount1 The delta of the currency1 balance of the pool / @param sqrtPriceX96 The sqrt(price) of the pool after the swap, as a Q64.96 / @param liquidity The liquidity of the pool after the swap / @param tick The log base 1.0001 of the price of the pool after the swap / @param fee The swap fee in hundredths of a bip

bytestx_hash = 1

-- transaction --

bytescaller = 4

-- call --

bytespool_manager_address = 5

-- log --

uint64ordinal = 6

log.ordinal

uint32log_index = 7

log.index

uint32transaction_index = 8

log.transaction_index

uint32block_index = 9

log.block_index

bytespool_id = 10

-- event --

bytessender = 11

address

stringamount0 = 13

int256

stringamount1 = 14

int256

stringsqrt_price_x96 = 15

uint160

stringliquidity = 16

uint128

int32tick = 17

int24

stringfee = 18

int256

Transfer

evm.uniswap.v4.Transfer

/ @notice Emitted when balances are transferred.

bytestx_hash = 1

-- transaction --

bytescaller = 2

-- call --

bytespool_manager_address = 3

-- log --

uint64ordinal = 4

log.ordinal

uint32log_index = 5

log.index

uint32transaction_index = 6

log.transaction_index

uint32block_index = 7

log.block_index

bytescaller_address = 10

-- event --

bytesfrom = 11

address

bytesto = 12

address

stringid = 13

uint256

stringamount = 14

uint256

Show 2 dependencies

evm.store

V4PoolStore

evm.store.V4PoolStore

stringsqrt_price_x96 = 1

int32current_tick = 2

evm.transaction

AssociatedEvmTransaction

evm.transaction.AssociatedEvmTransaction

stringtx_hash = 1

stringto = 2

uint64nonce = 3

stringgas_price = 4

uint64gas_limit = 5

stringvalue = 6

stringinput = 7

stringv = 8

stringr = 9

strings = 10

stringgas_used = 11

stringtype = 12

stringmax_fee_per_gas = 14

stringmax_priority_fee_per_gas = 15

uint32index = 16

stringfrom = 17

stringreturn_data = 18

stringpublic_key = 19

uint64begin_ordinal = 20

uint64end_ordinal = 21

stringstatus = 22

string[]calls = 23

stringblob_gas = 24

stringblob_gas_fee_cap = 25

string[]blob_hashes = 26

string[]set_code_authorizations = 27

uniswap-database-changes-pools-optimism

Database Changes Uniswaps

Execution graph

db_out

uniswap_v2:map_events

uniswap_v2:store_pools

uniswap_v3:map_events

uniswap_v3:store_pools

uniswap_v4:map_events

uniswap_v4:store_pools

Database Changes `Uniswaps`