training data

Building a training set from a billion-row table means sampling, and the naive 'ORDER BY random() LIMIT n' sorts the whole table. Stratified sampling takes even more care. Here are both, done efficiently.

Defining the label is half the modeling problem, and the SQL conceals two leakage traps: reaching into the future for features, and a label window not yet fully observed. Here is the correct query.