text: SELECT 
      DATE(FROM_UNIXTIME(block.timestamp DIV 1000000)),
      CAST(AVG(transaction.amount/1000000000000000000) AS UNSIGNED INTEGER)
  FROM
      iconation.block
          INNER JOIN
      iconation.transaction ON block.id = transaction.block
  GROUP BY DATE(FROM_UNIXTIME(block.timestamp DIV 1000000))