Skip to content

Mv Univ3 Swaps

eth.mv_univ3_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))

Modeling notes

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