Skip to content

Instantly share code, notes, and snippets.

View thedatadavis's full-sized avatar

Chris Davis thedatadavis

2 followers · 18 following
View GitHub Profile
@thedatadavis
thedatadavis / cboa_equity_weeklys_20251126.csv
Last active November 27, 2025 00:02
List of Stocks with Weekly Options
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
Ticker
AA
AAL
AAOI
AAP
AAPL
ABAT
ABBV
ABNB
ABR
@thedatadavis
thedatadavis / webgrab_jsonl_converter.py
Created October 25, 2025 09:29
Converts jsonl to sqlite for Webgrab
import json
import sqlite3
import sys
import os
def import_jsonl_to_sqlite(jsonl_file_path, db_file_path):
"""
Imports page data from a Webgrab JSON Lines file into an SQLite database.
Each page record includes a batch_id.
"""
@thedatadavis
thedatadavis / state_income_tax_brackets.csv
Last active February 21, 2023 07:17
US State Income Tax Brackets (take top end rates with grain of salt)
state_abbr filer_type tax_rate bracket_start bracket_end tax_year
AK single 0 0 999999999 2022
AK married_jointly 0 0 999999999 2022
AL single 0.02 0 500 2022
AL single 0.04 501 3000 2022
AL single 0.05 3001 999999999 2022
AL married_jointly 0.02 0 1000 2022
AL married_jointly 0.04 1001 6000 2022
AL married_jointly 0.05 6001 999999999 2022
AR single 0.02 0 4300 2022
@thedatadavis
thedatadavis / postgres_calc_running_sum_with_generate_series.sql
Last active December 20, 2022 09:06
Example of using `generate_series` in PostgreSQL to calculate a running sum for each customer
-- Run query here: https://bit.io/christoff12/explore_stuff?view=docs#/retail
with clean_data as (
select
customerid as customer_id,
invoiceno as invoice_id,
stockcode as stock_code,
quantity,
unitprice as unit_price,
@thedatadavis
thedatadavis / working_with_lists_of_dicts.html
Created December 16, 2022 08:46
<!DOCTYPE html>
<html>
<head><meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>working_with_lists_of_dicts</title><script src="https://cdnjs.cloudflare.com/ajax/libs/require.js/2.1.10/require.min.js"></script>
@thedatadavis
thedatadavis / roman_converter.py
Created August 25, 2020 23:44
Converts Roman Numerals up to 50
new_ref = {
'I': 1,
'V': 5,
'X': 10,
'L': 50
}
def convert_roman(roman_numeral):
val = 0
skip_next = False
@thedatadavis
thedatadavis / Track.wsdl
Created June 25, 2020 11:57
<?xml version="1.0" encoding="UTF-8"?>
<!-- UPS Tracking Service WSDL Release Date Jul 12, 2008 -->
<!-- Copyright 2007-2008 United Parcel Service of America, Inc. All rights reserved. -->
<wsdl:definitions name="Track" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:error="http://www.ups.com/XMLSchema/XOLTWS/Error/v1.1" xmlns:upss="http://www.ups.com/XMLSchema/XOLTWS/UPSS/v1.0" xmlns:trk="http://www.ups.com/XMLSchema/XOLTWS/Track/v2.0" xmlns:tns="http://www.ups.com/WSDL/XOLTWS/Track/v2.0" targetNamespace="http://www.ups.com/WSDL/XOLTWS/Track/v2.0">
<wsdl:types>
<xsd:schema>
<!-- This schema defines the UPS Security header used for authorization purposes -->
<xsd:import namespace="http://www.ups.com/XMLSchema/XOLTWS/UPSS/v1.0" schemaLocation="UPSSecurity.xsd"/>
<!-- This schema defines the error detail data types returned within SOAPFaults to provide more specific information pertaining to the pr
@thedatadavis
thedatadavis / blockstack.txt
Created December 16, 2018 08:22
Blockstack verification
Verifying my Blockstack ID is secured with the address 1LMCygrzKWCsaEojTV3h2RLasJr7VyFf6x https://explorer.blockstack.org/address/1LMCygrzKWCsaEojTV3h2RLasJr7VyFf6x