V Dex Swaps Dedup

eth.v_dex_swaps_dedup

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

Columns

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

Modeling notes

• Engine: View
• Partition key: ``
• Sorting (ORDER BY): ``