garethtdavies
7/21/2019 - 8:31 PM

Google BigQuery Zcash Migration Transactions

Google BigQuery Zcash Migration Transactions

SELECT
  block_number,
  `hash`,
  input_value,
  output_value,
  fee,
  i.type AS input_type,
  o.type AS output_type,
  block_timestamp
FROM
  `bigquery-public-data.crypto_zcash.transactions`,
  UNNEST(inputs) AS i,
  UNNEST(outputs) AS o
WHERE
  block_timestamp_month > "2019-05-01"
  AND is_coinbase = FALSE
  AND input_count = 1
  AND output_count = 1
  AND i.type = "shielded"
  AND o.type = "shielded"
ORDER BY
  block_number ASC