What's the difference between ethereum.transactions and ethereum.traces?

[1chioku]

I ran a quick query just to check, and the value in each block for ethereum.transactions and ethereum.traces do not match, the value for transactions was always more, cross checked with gas fee accounting, and it's not there either.

Further reading lead me to this article,

It seems that internal calls at the smart contract levels, trigger further conditional transactions that we label as traces (call, create, suicide)? Not sure if I am phrasing that correctly.

But in simple words, there is a subset of value transfers which is not being accounted for in the transaction table but that should be accounted in the traces table.

However should the sum of value in traces be higher for traces in the same block? Grateful if you could shed some light.

WITH
  transactions_table AS (
    SELECT
      block_number,
      SUM(value) AS trans_value
    FROM
      ethereum.transactions
    WHERE
      block_number <= 14830000
      AND block_number >= 14829000
    GROUP BY
      block_number SORT BY block_number DESC
  ),
  traces_table AS (
    SELECT
      block_number,
      SUM(value) AS trace_value
    FROM
      ethereum.traces
    WHERE
      block_number <= 14830000
      AND block_number >= 14829000
    GROUP BY
      block_number SORT BY block_number DESC
  )
SELECT
  a.block_number,
  a.trans_value,
  b.trace_value,
  (a.trans_value - b.trace_value) AS differential
FROM
  transactions_table a
  LEFT JOIN traces_table b ON a.block_number = b.block_number

[andrewhong5297]

This is a great question - it'll be answered on the live stream today, and I'll share the link afterwards :)

[1chioku]

Got it youtube!

Thanks for the clarification.