PREVIEW / stock_30min / 2017-02-17

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-17.parquet
  size:    1.6 MB
  rows:    81,203
  symbols: 3,101

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
2017-02-17 04:00:00	AAPL	Stock	33.8725	33.8725	33.8725	33.8725	400.0
2017-02-17 04:30:00	AAPL	Stock	33.7425	33.7425	33.725	33.725	1068.0
2017-02-17 05:00:00	AAPL	Stock	33.745	33.745	33.7	33.7175	3376.0
2017-02-17 05:30:00	AAPL	Stock	33.7175	33.7725	33.71	33.7725	2000.0
2017-02-17 06:00:00	AAPL	Stock	33.7425	33.7675	33.7425	33.7525	9880.0
2017-02-17 06:30:00	AAPL	Stock	33.7125	33.725	33.7125	33.725	800.0
2017-02-17 07:00:00	AAPL	Stock	33.755	33.7775	33.7375	33.7525	31444.0
2017-02-17 07:30:00	AAPL	Stock	33.745	33.775	33.745	33.77	17652.0
2017-02-17 08:00:00	AAPL	Stock	33.7525	33.78	33.7125	33.7225	124432.0
2017-02-17 08:30:00	AAPL	Stock	33.715	33.7675	33.715	33.755	45524.0
2017-02-17 09:00:00	AAPL	Stock	33.765	33.7875	33.725	33.775	160844.0
2017-02-17 09:30:00	AAPL	Stock	33.775	33.9	33.775	33.9	21850068.0
2017-02-17 10:00:00	AAPL	Stock	33.8995	33.9475	33.8525	33.89	6895976.0
2017-02-17 10:30:00	AAPL	Stock	33.8875	33.8925	33.8125	33.8175	4370376.0
2017-02-17 11:00:00	AAPL	Stock	33.8188	33.8225	33.7825	33.816	3826056.0
2017-02-17 11:30:00	AAPL	Stock	33.8175	33.8625	33.8175	33.8475	2608096.0
2017-02-17 12:00:00	AAPL	Stock	33.8475	33.875	33.84	33.85	2096592.0
2017-02-17 12:30:00	AAPL	Stock	33.85	33.8545	33.82	33.8475	1887844.0
2017-02-17 13:00:00	AAPL	Stock	33.846	33.8725	33.83	33.8675	2756728.0
2017-02-17 13:30:00	AAPL	Stock	33.8692	33.885	33.86	33.8805	2599804.0
2017-02-17 14:00:00	AAPL	Stock	33.881	33.89	33.865	33.89	2231368.0
2017-02-17 14:30:00	AAPL	Stock	33.89	33.9025	33.87	33.8775	2853052.0
2017-02-17 15:00:00	AAPL	Stock	33.876	33.8825	33.8425	33.845	3187488.0
2017-02-17 15:30:00	AAPL	Stock	33.845	33.9375	33.845	33.9275	11139012.0
2017-02-17 16:00:00	AAPL	Stock	33.9575	33.9575	33.865	33.93	13895376.0
2017-02-17 16:30:00	AAPL	Stock	33.91	33.93	33.9025	33.9125	260408.0
2017-02-17 17:00:00	AAPL	Stock	33.9125	33.925	33.9	33.9125	50608.0
2017-02-17 17:30:00	AAPL	Stock	33.92	33.9225	33.9125	33.9225	15972.0
2017-02-17 18:00:00	AAPL	Stock	33.925	33.9275	33.9225	33.9225	9708.0
2017-02-17 18:30:00	AAPL	Stock	33.9125	33.9225	33.9125	33.9225	7860.0
2017-02-17 19:00:00	AAPL	Stock	33.915	33.92	33.9075	33.9125	14500.0
2017-02-17 19:30:00	AAPL	Stock	33.9125	33.925	33.9125	33.9175	27160.0
2017-02-17 04:00:00	MSFT	Stock	64.44	64.44	64.44	64.44	740.0
2017-02-17 04:30:00	MSFT	Stock	64.44	64.44	64.44	64.44	100.0
2017-02-17 07:00:00	MSFT	Stock	64.45	64.45	64.45	64.45	154.0
2017-02-17 07:30:00	MSFT	Stock	64.4	64.4	64.4	64.4	400.0
2017-02-17 08:00:00	MSFT	Stock	64.42	64.44	64.31	64.31	6159.0
2017-02-17 09:00:00	MSFT	Stock	64.38	64.47	64.3	64.46	30165.0
2017-02-17 09:30:00	MSFT	Stock	64.46	64.6	64.3	64.54	4133695.0
2017-02-17 10:00:00	MSFT	Stock	64.55	64.69	64.51	64.594	1015191.0
2017-02-17 10:30:00	MSFT	Stock	64.6	64.61	64.47	64.49	724880.0
2017-02-17 11:00:00	MSFT	Stock	64.49	64.54	64.37	64.424	738659.0
2017-02-17 11:30:00	MSFT	Stock	64.43	64.48	64.38	64.42	692111.0
2017-02-17 12:00:00	MSFT	Stock	64.42	64.53	64.4	64.5	425252.0
2017-02-17 12:30:00	MSFT	Stock	64.495	64.53	64.45	64.525	597089.0
2017-02-17 13:00:00	MSFT	Stock	64.525	64.54	64.44	64.45	470013.0
2017-02-17 13:30:00	MSFT	Stock	64.45	64.475	64.4	64.4	585261.0
2017-02-17 14:00:00	MSFT	Stock	64.4	64.45	64.39	64.4	565515.0
2017-02-17 14:30:00	MSFT	Stock	64.395	64.45	64.39	64.39	472313.0
2017-02-17 15:00:00	MSFT	Stock	64.39	64.45	64.37	64.435	707319.0

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

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