PREVIEW / stock_30min / 2015-02-03

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-03.parquet
  size:    1.6 MB
  rows:    84,963
  symbols: 3,535

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
2015-02-03 04:00:00	AAPL	Stock	29.66	29.74	29.66	29.7375	13576.0
2015-02-03 04:30:00	AAPL	Stock	29.7125	29.7225	29.6625	29.6625	11640.0
2015-02-03 05:00:00	AAPL	Stock	29.665	29.6925	29.665	29.6925	876.0
2015-02-03 05:30:00	AAPL	Stock	29.6375	29.72	29.6375	29.72	19328.0
2015-02-03 06:00:00	AAPL	Stock	29.65	29.6975	29.6375	29.6975	2800.0
2015-02-03 06:30:00	AAPL	Stock	29.6625	29.7175	29.6625	29.6775	45736.0
2015-02-03 07:00:00	AAPL	Stock	29.6775	29.71	29.65	29.65	109472.0
2015-02-03 07:30:00	AAPL	Stock	29.6475	29.675	29.63	29.675	59176.0
2015-02-03 08:00:00	AAPL	Stock	29.6825	29.7125	29.6125	29.675	665872.0
2015-02-03 08:30:00	AAPL	Stock	29.68	29.7175	29.675	29.715	446164.0
2015-02-03 09:00:00	AAPL	Stock	29.715	29.72	29.56	29.625	646692.0
2015-02-03 09:30:00	AAPL	Stock	29.615	29.7725	29.5575	29.7125	31201508.0
2015-02-03 10:00:00	AAPL	Stock	29.7125	29.745	29.6225	29.7412	18325292.0
2015-02-03 10:30:00	AAPL	Stock	29.7412	29.76	29.5275	29.535	18140668.0
2015-02-03 11:00:00	AAPL	Stock	29.531	29.575	29.4825	29.49	14255188.0
2015-02-03 11:30:00	AAPL	Stock	29.49	29.5825	29.4525	29.4725	11187932.0
2015-02-03 12:00:00	AAPL	Stock	29.4575	29.5	29.4025	29.4638	9975872.0
2015-02-03 12:30:00	AAPL	Stock	29.4632	29.565	29.435	29.55	9412964.0
2015-02-03 13:00:00	AAPL	Stock	29.5512	29.613	29.53	29.586	8424956.0
2015-02-03 13:30:00	AAPL	Stock	29.5875	29.6075	29.5125	29.605	8679660.0
2015-02-03 14:00:00	AAPL	Stock	29.6042	29.62	29.525	29.5475	8577588.0
2015-02-03 14:30:00	AAPL	Stock	29.55	29.61	29.5325	29.605	6926816.0
2015-02-03 15:00:00	AAPL	Stock	29.605	29.6075	29.5425	29.5825	8662064.0
2015-02-03 15:30:00	AAPL	Stock	29.5825	29.695	29.5725	29.65	20451072.0
2015-02-03 16:00:00	AAPL	Stock	29.6625	29.7455	29.5615	29.5975	17028668.0
2015-02-03 16:30:00	AAPL	Stock	29.6625	29.6625	29.5838	29.5925	837152.0
2015-02-03 17:00:00	AAPL	Stock	29.5925	29.6	29.58	29.59	53328.0
2015-02-03 17:30:00	AAPL	Stock	29.595	29.6	29.58	29.5875	68516.0
2015-02-03 18:00:00	AAPL	Stock	29.595	29.6625	29.59	29.6	57620.0
2015-02-03 18:30:00	AAPL	Stock	29.6	29.6	29.5825	29.6	76068.0
2015-02-03 19:00:00	AAPL	Stock	29.5925	29.6	29.5925	29.6	44640.0
2015-02-03 19:30:00	AAPL	Stock	29.6	29.6	29.5925	29.6	35796.0
2015-02-03 04:00:00	MSFT	Stock	41.4	41.5	41.4	41.5	5100.0
2015-02-03 04:30:00	MSFT	Stock	41.47	41.47	41.4	41.4	475.0
2015-02-03 05:00:00	MSFT	Stock	41.5	41.5	41.5	41.5	1300.0
2015-02-03 05:30:00	MSFT	Stock	41.49	41.5	41.49	41.5	2800.0
2015-02-03 06:00:00	MSFT	Stock	41.49	41.5	41.49	41.5	1675.0
2015-02-03 07:00:00	MSFT	Stock	41.51	41.59	41.51	41.54	5111.0
2015-02-03 07:30:00	MSFT	Stock	41.54	41.55	41.42	41.42	8800.0
2015-02-03 08:00:00	MSFT	Stock	41.42	41.59	41.38	41.4	11570.0
2015-02-03 08:30:00	MSFT	Stock	41.48	41.48	41.4	41.45	11586.0
2015-02-03 09:00:00	MSFT	Stock	41.45	41.62	41.44	41.62	71839.0
2015-02-03 09:30:00	MSFT	Stock	41.63	41.93	41.545	41.563	5825336.0
2015-02-03 10:00:00	MSFT	Stock	41.565	41.6	41.265	41.41	3907648.0
2015-02-03 10:30:00	MSFT	Stock	41.41	41.515	41.17	41.215	5653726.0
2015-02-03 11:00:00	MSFT	Stock	41.21	41.28	41.1	41.12	3918385.0
2015-02-03 11:30:00	MSFT	Stock	41.13	41.24	41.07	41.1	2725876.0
2015-02-03 12:00:00	MSFT	Stock	41.1	41.18	41.045	41.144	1802296.0
2015-02-03 12:30:00	MSFT	Stock	41.144	41.29	41.095	41.235	2320550.0
2015-02-03 13:00:00	MSFT	Stock	41.235	41.37	41.19	41.268	1597501.0

> showing 50 of 84,963 rows — these rows as CSV

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