Awesome
Scrooge McDuck Extension
Scrooge McDuck is a third-party financial extension for DuckDB. The main goal of this extension is to support a set of aggregation functions and data scanners for financial data. It currently supports access to the logs of Ethereum nodes and stock information from Yahoo Finance.
This extension is still under development, with no official version released yet.
You can find more details on the supported scanners, custom functions, and usage in the Scrooge wiki.
Disclaimer: This extension is in no way affiliated with the DuckDB Foundation or DuckDB Labs. Therefore, any binaries produced and distributed of this extension are unsigned.
Roadmap
A roadmap for the next version of Scrooge is currently maintained as a discussion. You can find it here.
Why Scrooge?
- DuckDB is an easy-to-use, fast system for analytics. Scrooge takes advantage of all the design decisions of DuckDB that make it a highly performant database system for analytics (e.g., columnar storage, vectorized execution).
- Privacy/Security. Since DuckDB runs locally, all your queries are completely private and fully executed on your machine.
- Cost-Efficiency. Both DuckDB and Scrooge are completely free and available under an MIT License. There are no costs associated with using them, unlike with a cloud-based engine; all you need is your own machine.
- Subquery Flattening. This is a DuckDB optimization that few systems implement. Financial queries (e.g., ROIs) can get extremely complex and will be efficiently executed by DuckDB.
Build
To build, type
make
To run, run the duckdb shell with the unsined flag:
cd build/release/
./duckdb -unsigned
Then, load the Scrooge McDuck extension like so:
LOAD 'extension/scrooge/scrooge.duckdb_extension';