Dune work
Here I have put some links to Dune queries I have done while working at Summer.fi. Please note that these might not be maintaned anymore and are owned by the oasis_app user on Dune.
These were not used to create any charts on Dune, but rather as a part of the data pipeline that ended up with charts in Tableau. The data was extracted from Dune via the Dune API with a scheduled python script, pushed to the Snowflake data warehouse and loaded into Tableau.
Closing prices for all tokens supported on Aave
All Summer.fi competitor transactions
Please see this post for an example of extracting Dune data with the Dune API: Extracting data with the Dune API