Skip to content

Instantly share code, notes, and snippets.

View efnine's full-sized avatar

efNine efnine

View GitHub Profile
with
dau as (
-- This part of the query can be pretty much anything.
-- The only requirement is that it have three columns:
-- dt, user_id, inc_amt
-- Where dt is a date and user_id is some unique identifier for a user.
-- Each dt-user_id pair should be unique in this table.
-- inc_amt represents the amount of value that this user created on dt.
-- The most common case is
-- inc_amt = incremental revenue from the user on dt
@efnine
efnine / sp500_constituents.json
Created December 21, 2021 21:10 — forked from kafkasl/sp500_constituents.json
List of S&P 500 historical constituents from 2008/01/31 to 2019/02/27. JSON format where each date contains a list of the constituents.
This file has been truncated, but you can view the full file.
{
"2008/01/31":[
"GHC",
"MDP",
"GAS",
"AZO",
"MIL",
"MXA",
"ASH",
"SNA",
@efnine
efnine / 0-startup-overview.md
Created December 13, 2021 17:23 — forked from dideler/0-startup-overview.md
Startup Engineering notes