Skip to content

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): ``