Lookup S7 Retro Funding rewards for a project

oso_reward_lookup.py

from dotenv import load_dotenv
import os
import pandas as pd
from pyoso import Client

load_dotenv()
OSO_API_KEY = os.environ['OSO_API_KEY']
client = Client(api_key=OSO_API_KEY)


rewards = client.to_pandas("""
    select
        p.display_name as project,
        m.display_name as funding_round,
        sum(tm.amount) AS rewards
    from oso.timeseries_metrics_by_project_v0 tm
    join oso.metrics_v0 m on tm.metric_id = m.metric_id
    join oso.projects_v1 p on tm.project_id = p.project_id
    join oso.artifacts_by_project_v1 abp on p.project_id = abp.project_id
    where
        m.metric_name like 'S7_%'       # all Season 7 reward metrics are prefixed with S7
        and abp.artifact_namespace = '' # put your GitHub org name here
    group by 1,2
    order by 3 desc
""")

print(rewards['rewards'].sum())