Dex Swaps

eth.dex_swaps

Purpose: TODO (describe what this table powers and its grain).

Columns

• block_timestamp — DateTime
• block_number — UInt64
• tx_hash — FixedString(66)
• log_index — UInt32
• dex — LowCardinality(String)
• pool_address — FixedString(42)
• token_in — FixedString(42)
• token_out — FixedString(42)
• amount_in — Decimal(76, 18)
• amount_out — Decimal(76, 18)
• price_usd — Nullable(Decimal(76, 18))
• amount_usd — Nullable(Decimal(76, 18))
• _inserted_at — DateTime

Modeling notes

• Engine: MergeTree
• Partition key: toYYYYMM(block_timestamp)
• Sorting (ORDER BY): token_in, token_out, block_timestamp, tx_hash, log_index