Subgrounds can be installed via
pip with the following commands:
pip install --upgrade subgrounds # or python -m pip install --upgrade subgrounds
python >= 3.10.
You can check your version of python via:
We recommend creating python environments to help manage your packages. These help in ensuring your projects have the correct versions for the packages you care about.
If you run into problems during installation, see Environment Setup.
The following example grabs a subgraph for the Aave v2 protocol and queries the top 5 markets ordered by TVL (total value locked), selects their name and their TVL (in USD) and returns the data as a pandas
>>> from subgrounds import Subgrounds >>> >>> sg = Subgrounds() >>> >>> # Load >>> aave_v2 = sg.load_subgraph( ... "https://api.thegraph.com/subgraphs/name/messari/aave-v2-ethereum") >>> >>> # Construct the query >>> latest = aave_v2.Query.markets( ... orderBy=aave_v2.Market.totalValueLockedUSD, ... orderDirection='desc', ... first=5, ... ) >>> >>> # Return query to a dataframe >>> sg.query_df([ ... latest.name, ... latest.totalValueLockedUSD, ... ]) markets_name markets_totalValueLockedUSD 0 Aave interest bearing STETH 1.338931e+09 1 Aave interest bearing WETH 8.387106e+08 2 Aave interest bearing WBTC 6.082906e+08 3 Aave interest bearing USDC 4.085144e+08 4 Aave interest bearing USDT 3.370399e+08