MarquinSmith

Analytical – Honest – Passionate

  • Home
  • Services
  • Mini Projects
    • Data Analytics Helper Tools
    • Bitcoin Price Dashboard
    • Journey to data engineering
    • Tarantino Film Dashboard
    • Woolworths stock price tracker
    • How to reason and argue
  • Reference
    • The BookShelf
    • SQL Cheat Sheet
    • Dockerfile Cheat Sheet
  • Health, fitness and wellbeing
    • Crossfit Workouts
    • Gymnastics
    • Strength and fitness masterclass
    • Nutrition Course
    • Workout Stats
    • Physical Activity Stats
    • 6 week pre season soccer fitness plan
  • About

Author: M Smith

Finance

Jeff Booth conversation on Simply Bitcoin

27th October 202527th October 2025 M SmithLeave a comment

Insightful discussion with Jeff Booth about the interaction between an inflationary system (fiat) and a deflationary system (bitcoin).

Read More ›
Automation

A `.sqlfluff` settings file I like

26th October 202526th October 2025 M SmithLeave a comment

When using SQLfluff to format sql files it is possible to set certain formatting rules that should be followed when formatting the the files. These rules can be specified in …

Read More ›
Automation

Setting up sqlfluff as a pre commit hook using UV

23rd October 202523rd October 2025 M SmithLeave a comment

SQL is a very flexible language when it comes to formatting. As long as the commands and syntax are in the right order then the SQL query will work. Whitespace …

Read More ›
Personal Development

Physical Health Tracker – September 2025

4th October 20253rd October 2025 M SmithLeave a comment
Read More ›
Personal Development

Physical Health Tracker – August 2025

3rd October 20253rd October 2025 M SmithLeave a comment
Read More ›
Automation

A command line tool to compare 2 different csv files

20th September 202520th September 2025 M SmithLeave a comment

Below is a python script that uses the ydata-profiling library to create a report that compares two csv files. This is proving useful in verifying the similarity between original and …

Read More ›
Automation

Pre commit hooks in git YouTube resources

3rd September 2025 M SmithLeave a comment

A collection of YouTube videos I have found useful in learning about hooks in Git. In no particular order:

Read More ›
Data Analysis

Calculate a reasonable daily usage quota for BigQuery

28th July 202528th July 2025 M SmithLeave a comment

A previous post showed how to set a ‘daily query usage‘ quota in BigQuery, and what that quota should be to stay within the free tier of BigQuery. Well, what …

Read More ›
Automation

Archive (tar + gzip) a folder using bash

24th July 202523rd July 2025 M SmithLeave a comment

The following command will create a gzipped (compressed) tar file (many files into one file) for a folder called “Downloads”. In other words all the files and folders in the …

Read More ›
Data Analysis

Set a daily query usage quota in BigQuery

23rd July 202523rd July 2025 M SmithLeave a comment

In BigQuery there is a free tier for querying data. As long as less than 1 tebibyte of data is queried in a month there are no charges associated with …

Read More ›

Posts pagination

1 2 3 4 … 17

Recent Posts

  • Jeff Booth conversation on Simply Bitcoin
  • A `.sqlfluff` settings file I like
  • Setting up sqlfluff as a pre commit hook using UV
  • Physical Health Tracker – September 2025
  • Physical Health Tracker – August 2025

Categories

  • Automation
  • Business
  • cybersecurity
  • Data Analysis
  • Finance
  • Personal Development
  • Python
  • Uncategorised
  • Web Analytics

Archives

Copyright © 2025 MarquinSmith.
Theme Easthill by ThemeMunk. Powered by WordPress.