base_l2_ecosystem_dashboard__top_defi_protocols · Datasets on Ouro

Dataset documentation

Learn how to interact with this dataset using the Ouro SDK or REST API.

API access requires an API key. Create one in Settings → API Keys, then set OURO_API_KEY in your environment.

Retrieve dataset

Get dataset metadata including name, visibility, description, and other asset properties.

Read schema

Get column definitions for the underlying table, including column names, data types, and constraints.

6 columns

Column	Type
category	`text`
daily_volume_millions	`real`
project	`text`
token	`text`
tvl_millions	`real`
unique_users_7d	`integer`

Query data

Fetch the dataset's rows. Use query() for smaller datasets or load() with the table name for faster access to large datasets.

Update dataset

Update dataset metadata (visibility, description, etc.) and optionally write new rows to the table. Writing new data will replace the existing data in the table. Requires write or admin permission on the dataset.

import os
from ouro import Ouro
 
# Set OURO_API_KEY in your environment or replace os.environ.get("OURO_API_KEY")
ouro = Ouro(api_key=os.environ.get("OURO_API_KEY"))
 
dataset_id = "019d8764-84ce-78c7-b8bc-3b032dc617db"
 
# Retrieve dataset metadata
dataset = ouro.datasets.retrieve(dataset_id)
print(dataset.name, dataset.visibility)
print(dataset.metadata)

# Option 1: Query data by dataset ID (returns Pandas DataFrame)
df = ouro.datasets.query(dataset_id)
print(df.head())
 
# Option 2: Load data by table name (faster for large datasets)
table_name = dataset.metadata["table_name"]  # e.g., "base_l2_ecosystem_dashboard__top_defi_protocols"
df = ouro.datasets.load(table_name)
print(len(df))

import pandas as pd
 
# Update dataset metadata
updated = ouro.datasets.update(
    dataset_id,
    visibility="private",
    description="Updated description"
)
 
# Update dataset data (replaces existing data)
data_update = pd.DataFrame([
    {"name": "Charlie", "age": 33},
    {"name": "Diana", "age": 28},
])
updated = ouro.datasets.update(dataset_id, data=data_update)