PREVIEW / stock_30min / 2017-02-02

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-02.parquet
  size:    1.6 MB
  rows:    81,805
  symbols: 3,110

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-02 04:00:00	AAPL	Stock	32.125	32.1325	32.0525	32.0525	11300.0
2017-02-02 04:30:00	AAPL	Stock	32.0525	32.075	32.03	32.075	3388.0
2017-02-02 05:00:00	AAPL	Stock	32.03	32.05	32.0175	32.05	8344.0
2017-02-02 05:30:00	AAPL	Stock	32.05	32.095	32.05	32.095	21724.0
2017-02-02 06:00:00	AAPL	Stock	32.1225	32.125	32.1	32.11	31020.0
2017-02-02 06:30:00	AAPL	Stock	32.085	32.1	32.0525	32.095	13660.0
2017-02-02 07:00:00	AAPL	Stock	32.095	32.12	32.07	32.1	50736.0
2017-02-02 07:30:00	AAPL	Stock	32.1	32.1275	32.0875	32.1	55500.0
2017-02-02 08:00:00	AAPL	Stock	32.0875	32.14	32.07	32.105	325656.0
2017-02-02 08:30:00	AAPL	Stock	32.095	32.1125	32.06	32.08	209336.0
2017-02-02 09:00:00	AAPL	Stock	32.085	32.14	31.995	31.9975	625500.0
2017-02-02 09:30:00	AAPL	Stock	31.9975	32.3475	31.975	32.195	28627672.0
2017-02-02 10:00:00	AAPL	Stock	32.1925	32.205	32.065	32.1812	12872856.0
2017-02-02 10:30:00	AAPL	Stock	32.1825	32.205	32.1025	32.1722	7536404.0
2017-02-02 11:00:00	AAPL	Stock	32.1712	32.1825	32.055	32.0875	6763792.0
2017-02-02 11:30:00	AAPL	Stock	32.0875	32.095	31.985	32.0012	7551304.0
2017-02-02 12:00:00	AAPL	Stock	32.0012	32.01	31.945	31.995	6918532.0
2017-02-02 12:30:00	AAPL	Stock	31.9935	32.115	31.9925	32.07	7086236.0
2017-02-02 13:00:00	AAPL	Stock	32.0695	32.0875	32.0088	32.0362	3487676.0
2017-02-02 13:30:00	AAPL	Stock	32.0375	32.08	32.0175	32.0625	3416860.0
2017-02-02 14:00:00	AAPL	Stock	32.0612	32.0635	31.98	31.985	3625144.0
2017-02-02 14:30:00	AAPL	Stock	31.9875	32.0538	31.975	32.05	4784788.0
2017-02-02 15:00:00	AAPL	Stock	32.0513	32.0775	32.0325	32.07	5137376.0
2017-02-02 15:30:00	AAPL	Stock	32.07	32.1375	32.07	32.1275	12324524.0
2017-02-02 16:00:00	AAPL	Stock	32.1275	32.1325	32.0775	32.0975	7866664.0
2017-02-02 16:30:00	AAPL	Stock	32.0775	32.09	32.0002	32.09	379172.0
2017-02-02 17:00:00	AAPL	Stock	32.08	32.1325	32.0625	32.0625	227528.0
2017-02-02 17:30:00	AAPL	Stock	32.075	32.0825	32.065	32.065	14632.0
2017-02-02 18:00:00	AAPL	Stock	32.065	32.0825	32.0575	32.065	36204.0
2017-02-02 18:30:00	AAPL	Stock	32.0375	32.0375	32.005	32.02	37628.0
2017-02-02 19:00:00	AAPL	Stock	32.005	32.05	32.005	32.05	29416.0
2017-02-02 19:30:00	AAPL	Stock	32.0625	32.0625	32.0125	32.0125	11420.0
2017-02-02 04:00:00	MSFT	Stock	63.45	63.45	63.45	63.45	100.0
2017-02-02 04:30:00	MSFT	Stock	63.54	63.54	63.54	63.54	289.0
2017-02-02 05:00:00	MSFT	Stock	63.42	63.43	63.42	63.43	880.0
2017-02-02 05:30:00	MSFT	Stock	63.39	63.39	63.39	63.39	100.0
2017-02-02 06:00:00	MSFT	Stock	63.4	63.4	63.4	63.4	600.0
2017-02-02 06:30:00	MSFT	Stock	63.36	63.36	63.36	63.36	100.0
2017-02-02 07:00:00	MSFT	Stock	63.4	63.4	63.36	63.4	18800.0
2017-02-02 07:30:00	MSFT	Stock	63.46	63.46	63.46	63.46	597.0
2017-02-02 08:00:00	MSFT	Stock	63.45	63.47	63.37	63.41	5911.0
2017-02-02 08:30:00	MSFT	Stock	63.41	63.46	63.31	63.32	7410.0
2017-02-02 09:00:00	MSFT	Stock	63.35	63.38	63.21	63.25	26726.0
2017-02-02 09:30:00	MSFT	Stock	63.25	63.41	62.75	63.295	8440864.0
2017-02-02 10:00:00	MSFT	Stock	63.29	63.35	62.92	62.95	3674635.0
2017-02-02 10:30:00	MSFT	Stock	62.95	63.2	62.945	63.13	4051732.0
2017-02-02 11:00:00	MSFT	Stock	63.14	63.37	63.14	63.235	2697036.0
2017-02-02 11:30:00	MSFT	Stock	63.232	63.27	62.91	62.934	3323621.0
2017-02-02 12:00:00	MSFT	Stock	62.935	62.98	62.86	62.915	1492278.0
2017-02-02 12:30:00	MSFT	Stock	62.92	63.1	62.88	62.995	1460734.0

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

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