19 lines
394 B
Python
19 lines
394 B
Python
import duckdb
|
|
import os
|
|
import polars as pl
|
|
|
|
|
|
db = duckdb.connect('/mnt/bulk/data/ynab_data.duckdb')
|
|
|
|
# SELECT * FROM gold.transactions
|
|
relevant_data = db.sql('''
|
|
SELECT
|
|
transaction_date,
|
|
sum(transaction_amount) as total
|
|
FROM gold.transactions
|
|
GROUP BY transaction_date
|
|
ORDER BY transaction_date DESC
|
|
''')
|
|
print("Data after SQL query:")
|
|
print(relevant_data)
|