PREVIEW / stock_30min / 2016-12-02

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-02.parquet
  size:    1.6 MB
  rows:    81,936
  symbols: 3,150

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2016-12-02 04:00:00	AAPL	Stock	27.325	27.325	27.225	27.25	2564.0
2016-12-02 04:30:00	AAPL	Stock	27.225	27.2375	27.215	27.225	3764.0
2016-12-02 05:00:00	AAPL	Stock	27.2	27.2	27.19	27.19	1712.0
2016-12-02 05:30:00	AAPL	Stock	27.225	27.225	27.225	27.225	3200.0
2016-12-02 06:00:00	AAPL	Stock	27.25	27.26	27.25	27.26	1328.0
2016-12-02 06:30:00	AAPL	Stock	27.25	27.25	27.25	27.25	400.0
2016-12-02 07:00:00	AAPL	Stock	27.2675	27.32	27.2675	27.2925	13524.0
2016-12-02 07:30:00	AAPL	Stock	27.2925	27.3275	27.27	27.3	14648.0
2016-12-02 08:00:00	AAPL	Stock	27.3025	27.3625	27.295	27.3375	74792.0
2016-12-02 08:30:00	AAPL	Stock	27.355	27.385	27.315	27.3425	71504.0
2016-12-02 09:00:00	AAPL	Stock	27.34	27.3725	27.2875	27.3325	220808.0
2016-12-02 09:30:00	AAPL	Stock	27.2925	27.5225	27.25	27.3775	16985032.0
2016-12-02 10:00:00	AAPL	Stock	27.3775	27.4222	27.2125	27.3012	9857652.0
2016-12-02 10:30:00	AAPL	Stock	27.3025	27.3762	27.2752	27.325	7299632.0
2016-12-02 11:00:00	AAPL	Stock	27.3275	27.4825	27.32	27.4612	5956536.0
2016-12-02 11:30:00	AAPL	Stock	27.4625	27.47	27.375	27.4	3976808.0
2016-12-02 12:00:00	AAPL	Stock	27.3975	27.4712	27.39	27.435	3558564.0
2016-12-02 12:30:00	AAPL	Stock	27.435	27.48	27.4125	27.4775	3577800.0
2016-12-02 13:00:00	AAPL	Stock	27.4775	27.48	27.3775	27.3975	3406748.0
2016-12-02 13:30:00	AAPL	Stock	27.4	27.4272	27.3925	27.4075	2344468.0
2016-12-02 14:00:00	AAPL	Stock	27.4075	27.4525	27.37	27.4525	3881548.0
2016-12-02 14:30:00	AAPL	Stock	27.4525	27.4775	27.4375	27.4675	3990292.0
2016-12-02 15:00:00	AAPL	Stock	27.4698	27.4812	27.405	27.4562	4750088.0
2016-12-02 15:30:00	AAPL	Stock	27.455	27.4975	27.3988	27.4725	12383552.0
2016-12-02 16:00:00	AAPL	Stock	27.475	27.495	27.4375	27.475	9080880.0
2016-12-02 16:30:00	AAPL	Stock	27.475	27.485	27.465	27.465	14400.0
2016-12-02 17:00:00	AAPL	Stock	27.4675	27.47	27.4625	27.47	36384.0
2016-12-02 17:30:00	AAPL	Stock	27.465	27.47	27.4625	27.47	3540.0
2016-12-02 18:00:00	AAPL	Stock	27.4725	27.4725	27.46	27.4725	8528.0
2016-12-02 18:30:00	AAPL	Stock	27.4425	27.4675	27.44	27.44	11612.0
2016-12-02 19:00:00	AAPL	Stock	27.44	27.4425	27.4375	27.4375	10800.0
2016-12-02 19:30:00	AAPL	Stock	27.44	27.46	27.4375	27.46	7392.0
2016-12-02 07:00:00	MSFT	Stock	58.9	58.93	58.79	58.93	2622.0
2016-12-02 07:30:00	MSFT	Stock	58.85	58.88	58.74	58.75	400.0
2016-12-02 08:00:00	MSFT	Stock	58.9	59.11	58.9	59.0	2907.0
2016-12-02 08:30:00	MSFT	Stock	59.11	59.11	59.0	59.0	1830.0
2016-12-02 09:00:00	MSFT	Stock	59.0	59.14	58.9	59.06	12061.0
2016-12-02 09:30:00	MSFT	Stock	59.08	59.47	58.835	59.065	3374120.0
2016-12-02 10:00:00	MSFT	Stock	59.07	59.2	58.8	59.04	1867676.0
2016-12-02 10:30:00	MSFT	Stock	59.04	59.35	59.0	59.19	1391146.0
2016-12-02 11:00:00	MSFT	Stock	59.19	59.38	59.065	59.29	1642725.0
2016-12-02 11:30:00	MSFT	Stock	59.29	59.3	59.06	59.12	1492461.0
2016-12-02 12:00:00	MSFT	Stock	59.12	59.21	59.06	59.185	1109734.0
2016-12-02 12:30:00	MSFT	Stock	59.185	59.34	59.09	59.28	983719.0
2016-12-02 13:00:00	MSFT	Stock	59.289	59.3	59.12	59.21	1173490.0
2016-12-02 13:30:00	MSFT	Stock	59.21	59.37	59.18	59.27	989927.0
2016-12-02 14:00:00	MSFT	Stock	59.27	59.33	59.19	59.275	837265.0
2016-12-02 14:30:00	MSFT	Stock	59.27	59.32	59.2	59.24	1221466.0
2016-12-02 15:00:00	MSFT	Stock	59.24	59.32	59.19	59.315	1033637.0
2016-12-02 15:30:00	MSFT	Stock	59.31	59.384	59.19	59.26	3174863.0

> showing 50 of 81,936 rows — these rows as CSV

> unlock the full archive -- $79 one-time