Extracting Market Insights

Introduction

Welcome to our tutorial on RBL Net, BigQuery, and Google Cloud. In this tutorial, we'll take you through the steps to utilise your RBL Net data and explore market insights, create queries and visualise the results.

Getting started

Let’s start by making sure we have our Google Cloud Project set up with our RBL Net data. If you don’t have one setup, please refer to HOW TO ADD RBL NET DATA TO A ANALYTICS HUB TUTORIAL.

Steps to follow

Now let's go to the left side menu, click on BigQuery and click on Compose a New Query.
SELECT *

FROM `analytics-hub-public-access.my_first_listing.avalanche_blocks`

LIMIT 1000;

Now that we know everything is on there, lets keep moving forward by exploring the trends by time and typing the following query:

SELECT

  DATE_TRUNC(date_column, MONTH) AS month,

  COUNT(*) AS total_token0

FROM `analytics-hub-public-access.my_first_listing.avalanche_blocks`

GROUP BY month

ORDER BY month;

Let’s move on after these query to find our trader segmentation and type the next query

SELECT

   customer_type,

   AVG(lp_token_price_in_usd) AS average_lp_token_price_in_usd

FROM `analytics-hub-public-access.my_first_listing.avalanche_blocks`

GROUP BY exchange_type;

And for our last query we can add the following to calculate the share of the markets.

WITH MarketShare AS (

   SELECT

     exchange,

     COUNT(*) AS total_token0

   FROM `analytics-hub-public-access.my_first_listing.avalanche_blocks`

   GROUP BY exchange

)

SELECT

   exchange,

   Total_token0 / SUM(total_token0) OVER () AS usd_yield

FROM analytics-hub-public-access.my_first_listing.avalanche_blocks;

Now to visualise your data in a spreadsheet click on the “Explore Data” then on “Explore with Sheet” 

And last but not least, you can also explore with Looker Studio by going to the bottom side again and clicking on “Explore Data” then on “Explore with Looking Studio”

Thanks for watching this tutorial and I hope it was helpful. [I’m name of who’s recording] and see you on the next RBL Net video!