
optimism
optimismSubstreams package for Velodrome V2 on Optimism. Indexes pool creation, swaps, and liquidity events, outputting DatabaseChanges for SQL sink consumption.
| Contract | Address | Init Block |
|---|---|---|
| PoolFactory | 0xF1046053aa5682b4F9a81b5481394DA16BE5FF5a |
119142390 |
sf.ethereum.type.v2.Block
│
▼
map_factory_events ← PoolCreated events from PoolFactory
│
▼
store_pools ← set_if_not_exists; keys = pool addresses
│ (get mode)
▼
map_pool_events ← Swap / Mint / Burn filtered to known pools
│
▼
db_out ← DatabaseChanges for SQL sink
| Table | Primary Key | Description |
|---|---|---|
pools |
address |
Pool creation events (token0, token1, stable flag) |
swaps |
{tx_hash}-{log_index} |
Swap events with amounts in/out |
liquidity_events |
{tx_hash}-{log_index} |
Mint and burn events |
See schema.sql for full column definitions.
# Run against Optimism
substreams run velodrome-substreams-v0.1.0.spkg map_factory_events \
-e optimism.streamingfast.io:443 \
-s 119142390 -t +200 -o jsonl
# Pipe to PostgreSQL sink
substreams-sink-postgres run \
"host=localhost user=dev password=dev dbname=velodrome" \
velodrome-substreams-v0.1.0.spkg db_out
substreams build
substreams pack substreams.yaml
substreams gui velodrome-substreams@v0.1.0 map_factory_eventssubstreams gui velodrome-substreams@v0.1.0 map_pool_eventssubstreams gui velodrome-substreams@v0.1.0 db_outsubstreams gui velodrome-substreams@v0.1.0 store_poolsmessage
Request
message
Response
message
BlockUndoSignal
message
BlockScopedData
message
SessionInit
message
InitialSnapshotComplete
message
InitialSnapshotData
message
MapModuleOutput
message
StoreModuleOutput
message
OutputDebugInfo
message
ModulesProgress
message
ProcessedBytes
message
Error
message
Job
message
Stage
message
ModuleStats
message
ExternalCallMetric
message
StoreDelta
message
BlockRange
message
DeployRequest
message
Parameter
message
DeployResponse
message
UpdateRequest
message
UpdateResponse
message
InfoRequest
message
InfoResponse
message
SinkProgress
message
PackageInfo
message
ListRequest
message
ListResponse
message
DeploymentWithStatus
message
RemoveRequest
message
RemoveResponse
message
PauseRequest
message
PauseResponse
message
StopRequest
message
StopResponse
message
ResumeRequest
message
ResumeResponse
enum
DeploymentStatus
message
DatabaseChanges
message
TableChange
message
CompositePrimaryKey
message
Field
message
Pool
message
Pools
message
Swap
message
LiquidityEvent
message
Events
message
FileDescriptorSet
message
FileDescriptorProto
message
DescriptorProto
message
ExtensionRangeOptions
message
FieldDescriptorProto
message
OneofDescriptorProto
message
EnumDescriptorProto
message
EnumValueDescriptorProto
message
ServiceDescriptorProto
message
MethodDescriptorProto
message
FileOptions
message
MessageOptions
message
FieldOptions
message
OneofOptions
message
EnumOptions
message
EnumValueOptions
message
ServiceOptions
message
MethodOptions
message
UninterpretedOption
message
SourceCodeInfo
message
GeneratedCodeInfo
message
Any
message
Timestamp
message
Modules
message
Binary
message
Module
message
Package
message
NetworkParams
message
PackageMetadata
message
ModuleMetadata
message
Clock
message
BlockRef