PREVIEW / stock_30min / 2017-02-09

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-09.parquet
  size:    1.6 MB
  rows:    81,848
  symbols: 3,105

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-09 04:00:00	AAPL	Stock	32.9925	32.9925	32.975	32.975	2400.0
2017-02-09 04:30:00	AAPL	Stock	32.95	32.985	32.95	32.95	4776.0
2017-02-09 05:00:00	AAPL	Stock	32.9525	32.9525	32.9375	32.9375	2000.0
2017-02-09 05:30:00	AAPL	Stock	32.95	32.95	32.9375	32.9375	6400.0
2017-02-09 06:00:00	AAPL	Stock	32.9475	32.95	32.9375	32.95	18000.0
2017-02-09 06:30:00	AAPL	Stock	32.95	32.95	32.9475	32.9475	16344.0
2017-02-09 07:00:00	AAPL	Stock	32.95	32.95	32.88	32.925	59976.0
2017-02-09 07:30:00	AAPL	Stock	32.925	32.925	32.905	32.915	42820.0
2017-02-09 08:00:00	AAPL	Stock	32.915	32.975	32.8875	32.9025	211328.0
2017-02-09 08:30:00	AAPL	Stock	32.9025	32.9375	32.9	32.925	222216.0
2017-02-09 09:00:00	AAPL	Stock	32.9225	32.9375	32.8675	32.92	630516.0
2017-02-09 09:30:00	AAPL	Stock	32.915	33.04	32.855	32.8575	16046476.0
2017-02-09 10:00:00	AAPL	Stock	32.8575	32.9075	32.78	32.8588	7780884.0
2017-02-09 10:30:00	AAPL	Stock	32.8575	32.8975	32.8	32.885	4846036.0
2017-02-09 11:00:00	AAPL	Stock	32.885	32.965	32.875	32.9638	4974636.0
2017-02-09 11:30:00	AAPL	Stock	32.9638	32.9862	32.9318	32.969	4733584.0
2017-02-09 12:00:00	AAPL	Stock	32.9688	32.975	32.94	32.96	2644096.0
2017-02-09 12:30:00	AAPL	Stock	32.961	32.975	32.95	32.9675	2286792.0
2017-02-09 13:00:00	AAPL	Stock	32.97	32.9925	32.96	32.99	2281384.0
2017-02-09 13:30:00	AAPL	Stock	32.9892	33.0225	32.98	33.015	4524844.0
2017-02-09 14:00:00	AAPL	Stock	33.0162	33.06	33.0162	33.05	4487520.0
2017-02-09 14:30:00	AAPL	Stock	33.0488	33.1	33.04	33.0912	6201464.0
2017-02-09 15:00:00	AAPL	Stock	33.0925	33.1112	33.05	33.065	6112576.0
2017-02-09 15:30:00	AAPL	Stock	33.065	33.11	33.055	33.1025	11798324.0
2017-02-09 16:00:00	AAPL	Stock	33.1025	33.105	33.0675	33.075	15432532.0
2017-02-09 16:30:00	AAPL	Stock	33.105	33.105	33.07	33.0775	1161352.0
2017-02-09 17:00:00	AAPL	Stock	33.0775	33.1025	33.0775	33.1025	36004.0
2017-02-09 17:30:00	AAPL	Stock	33.1025	33.1025	33.0825	33.1	5260.0
2017-02-09 18:00:00	AAPL	Stock	33.095	33.1025	33.085	33.1025	12800.0
2017-02-09 18:30:00	AAPL	Stock	33.095	33.105	33.095	33.105	3436.0
2017-02-09 19:00:00	AAPL	Stock	33.105	33.1075	33.095	33.095	13528.0
2017-02-09 19:30:00	AAPL	Stock	33.1	33.1175	33.1	33.1125	62704.0
2017-02-09 08:00:00	MSFT	Stock	63.37	63.4	63.36	63.4	2620.0
2017-02-09 08:30:00	MSFT	Stock	63.35	63.47	63.33	63.47	1552.0
2017-02-09 09:00:00	MSFT	Stock	63.34	63.5	63.34	63.48	9476.0
2017-02-09 09:30:00	MSFT	Stock	63.52	63.58	63.32	63.525	2120692.0
2017-02-09 10:00:00	MSFT	Stock	63.525	63.74	63.46	63.73	1669563.0
2017-02-09 10:30:00	MSFT	Stock	63.73	63.8	63.69	63.795	1651677.0
2017-02-09 11:00:00	MSFT	Stock	63.8	64.175	63.77	64.12	2622901.0
2017-02-09 11:30:00	MSFT	Stock	64.13	64.435	64.129	64.316	1909560.0
2017-02-09 12:00:00	MSFT	Stock	64.31	64.33	64.11	64.17	1780684.0
2017-02-09 12:30:00	MSFT	Stock	64.165	64.22	64.09	64.15	822420.0
2017-02-09 13:00:00	MSFT	Stock	64.14	64.19	64.12	64.155	717713.0
2017-02-09 13:30:00	MSFT	Stock	64.155	64.18	64.115	64.165	583869.0
2017-02-09 14:00:00	MSFT	Stock	64.165	64.2	64.13	64.17	627223.0
2017-02-09 14:30:00	MSFT	Stock	64.16	64.205	64.15	64.19	844880.0
2017-02-09 15:00:00	MSFT	Stock	64.195	64.2	64.08	64.085	1129611.0
2017-02-09 15:30:00	MSFT	Stock	64.084	64.12	64.0	64.05	2606083.0
2017-02-09 16:00:00	MSFT	Stock	64.06	64.06	63.98	64.04	1844262.0
2017-02-09 16:30:00	MSFT	Stock	64.06	64.06	63.96	64.0	4672.0

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

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