API

On this page, you can find our different endpoints and some examples of how to quickly connect them to your favorite data analytics tool.

Our API endpoint can be found at https://api.growthepie.com/

Master endpoint

This endpoint contains info on all supported chains and metrics. It is mostly static metadata like chain names, important links, etc.

v1/master.json

Contracts endpoint

We are moving all contract labeling logic to the Open Labels Initiative standard. As a first step, we released labels.growthepie.xyz and are currently working on better API endpoints. Please reach out to us via our Discord or X if you need API access to the new labels dataset - your input will be very valuable for scoping our API endpoints)

Metric endpoint

These are multiple endpoints, one for each metric that we list.

v1/export/{METRIC}.json

It is currently available for the following metrics:

  • daa: Daily Active Addresses

  • fdv: Fully Diluted Valuation

  • fees: Fees Paid by Users

  • market_cap: Market Cap

  • profit: Onchain Profit

  • rent_paid: Rent Paid to L1

  • stables_mcap: Stablecoin Market Cap

  • throughput: Throughput

  • tvl: Total Value Secured

  • txcosts: Median Transaction Costs

  • txcount: Transaction Count

Example

https://api.growthepie.com/v1/export/daa.json

Sample Response

[
 {
        "metric_key": "daa",
        "origin_key": "imx",
        "date": "2023-04-21",
        "value": 8300.0
    },
    {
        "metric_key": "daa",
        "origin_key": "imx",
        "date": "2023-04-25",
        "value": 7834.0
    },
    {
        "metric_key": "daa",
        "origin_key": "imx",
        "date": "2023-04-29",
        "value": 7558.0
    },
    ...
]

Metrics that represent values in currencies like USD or ETH always contain 2 metric keys (i.e. tvl and tvl_eth)

Fundamentals endpoint

This is a very powerful endpoint for analytics and tracking. It returns all Layer 2 metrics for all chains on a daily aggregation level in the last 90 days. It can also be used in Google Sheets and other applications.

v1/fundamentals.json

Sample Response

[
    {
        "metric_key": "daa",
        "origin_key": "imx",
        "date": "2023-04-21",
        "value": 8300.0
    },
    {
        "metric_key": "txcount",
        "origin_key": "zksync_era",
        "date": "2023-02-14",
        "value": 6.0
    },
    {
        "metric_key": "daa",
        "origin_key": "imx",
        "date": "2023-04-25",
        "value": 7834.0
    },
    ...
]

Example Python

You can quickly load data on all Layer 2s into a Pandas dataframe using the following code snippet:

import requests
import pandas as pd

url = 'https://api.growthepie.com/v1/fundamentals.json'
response = requests.get(url)
df = pd.DataFrame(response.json())

If you want to quickly visualize the data points you can use the dataframe plot function. Here filtered down to Arbitrum and transaction count:

df[(df['metric_key'] == 'txcount') & (df['origin_key'] == 'arbitrum')].sort_values('date').plot(x='date', y='value', figsize=(15, 5), title='Arbitrum Daily Transactions')

Example Excel

Excel is still the most widely used tool for data analytics. Using our API, you can build this neat dashboard in less than 2 minutes:

Excel dashboard example

Here is a quick guide on how to pull data from our API and visualize it

Guide for Excel usage

Example PowerBI

PowerBI is a powerful BI and data visualization tool. If you want to load all Layer 2 data into a PowerBI dashboard follow these steps:

  • Open a new PowerBI file

  • Load data using the "Web" data connector

  • Paste the API endpoint in the URL field

  • Make sure the "value" column is formatted as decimal

  • Load the data into your report and have fun exploring.

Here is a quick video walkthrough: https://x.com/web3_data/status/1697573767751548953?s=20

Example Google Sheets

Sometimes it can be useful to have up-to-date Layer 2 data in Google Sheets. With our endpoint, it is very simple.

=ImportJSON("https://api.growthepie.com/v1/fundamentals.json")
PreviousIntroduction

Last updated