Search Shortcut cmd + k | ctrl + k

- Overview
- Documentation
- Development
- Download Metrics
- FAQ
- Core Extensions
- List of Community Extensions

- h3
- faiss
- prql
- pivot_table
- scrooge

scrooge
Downloads 343this week

Provides functionality for financial data-analysis, including data scanners for the Ethereum Blockchain and Yahoo Finance

Extension repository on GitHub
Extension descriptor (YAML)

### Installing and Loading

    INSTALL scrooge FROM community;
    LOAD scrooge;

### Example

    -- Set the RPC Provider
    SET eth_node_url = 'https://mempool.merkle.io/rpc/eth/pk_mbs_0b647b195065b3294a5254838a33d062';
    -- Query Transfer events of USDT from blocks 20034078 - 20034100 while parallelizing on one block per thread
    FROM read_eth(
        'USDT',
        'Transfer',
        20034078,
        20034100,
        blocks_per_thread = 1
    );

### About scrooge

Scrooge McDuck is a third-party financial extension for DuckDB. This extension's main goal 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. More information on the supported scanners and functions can be found on Scrooge's wiki page. You can also find a ROI example of Ether on the following blogpost

### Added Functions

function_name | function_type | description | comment | example
--- | --- | --- | --- | ---
first_s | aggregate |  |  |
last_s | aggregate |  |  |
read_eth | table |  |  |
sma | aggregate |  |  |
timebucket | scalar |  |  |
volatility | aggregate |  |  |
yahoo_finance | table |  |  |

### Added Settings

name | description | input_type | scope
--- | --- | --- | ---
eth_node_url | URL of Ethereum node to be queried | VARCHAR | GLOBAL