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