Use the labels table to find treasury addresses which you can use to verify on Etherscan. You can also find most DAO's treasury addresses in their documentation.

One extra tip is to search on Etherscan. e.g. "Nouns: " , "Nouns DAO: "

One point to explore further: There are way more outflow of ETH than there are inflow of ETH. Why?

Use current balances to show current balances for an address. You can filter for tokens which the table has prices for in the 'has_price' column

One example of digging deeper here is to ask the question why is stETH added periodically? How does the DAO obtain more stETH?

To create our balances over time table, we will use a combination of lead(), lag(), iff() and coalesce() functions.

Read more about snowflake functions here: https://docs.snowflake.com/en/sql-reference/functions/lead

1. Create a dashboard visualizing treasury holdings of a DAO of your choice. It should contain:
a. current balances of at least 2 tokens
b. balances over time of at least 2 tokens
c. inflows and outflows for 1 token

2. Share any insights about the increase or decrease in inflows/outflows of a token. E.g. was the DAO selling the token? Find evidence to support your insights

3. Use appropriate graphs to show the data

4. Dashboard is due a week before the NEXT session, submit your dashboard here