Visualizing on-chain data with BigQuery
Finally, we can use data visualization tools such as Google Data Studio, Looker, or Tableau to create interactive dashboards with our BigQuery data. For example, we could create a real-time dashboard showing the most active Ethereum addresses, or how Bitcoin transactions are evolving.
Visualizing on-chain data with BigQuery can be achieved by integrating BigQuery with any of the visualization tools mentioned previously. For the sake of this example, we will use Google Data Studio due to its seamless integration with BigQuery and GCP as a whole.
Suppose we have the query from the earlier example that calculates the daily average transaction fee for Bitcoin transactions:
SELECT block_timestamp_day, AVG((input.input_value - output.output_value)/100000000) as avg_tx_fee_btc FROM `bigquery-public-data.crypto_bitcoin.transactions` AS t LEFT JOIN UNNEST(inputs) AS input LEFT JOIN UNNEST...