PREVIEW / stock_30min / 2015-04-07

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-07.parquet
  size:    1.6 MB
  rows:    82,033
  symbols: 3,499

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-04-07 04:00:00	AAPL	Stock	31.93	31.93	31.825	31.835	7188.0
2015-04-07 04:30:00	AAPL	Stock	31.845	31.845	31.825	31.825	1600.0
2015-04-07 05:00:00	AAPL	Stock	31.85	31.85	31.825	31.825	1600.0
2015-04-07 05:30:00	AAPL	Stock	31.875	31.875	31.855	31.855	1600.0
2015-04-07 06:00:00	AAPL	Stock	31.875	31.9225	31.875	31.9225	34560.0
2015-04-07 06:30:00	AAPL	Stock	31.925	31.9425	31.905	31.9425	30256.0
2015-04-07 07:00:00	AAPL	Stock	31.9425	32.03	31.9425	32.005	178388.0
2015-04-07 07:30:00	AAPL	Stock	32.0075	32.03	31.97	31.985	181964.0
2015-04-07 08:00:00	AAPL	Stock	31.98	32.04	31.9575	32.0225	514540.0
2015-04-07 08:30:00	AAPL	Stock	32.0175	32.0175	31.9925	32.0102	488652.0
2015-04-07 09:00:00	AAPL	Stock	32.015	32.0175	31.9075	31.91	702616.0
2015-04-07 09:30:00	AAPL	Stock	31.91	32.0305	31.8	31.8075	27325672.0
2015-04-07 10:00:00	AAPL	Stock	31.8025	31.9075	31.7762	31.87	13631048.0
2015-04-07 10:30:00	AAPL	Stock	31.8725	31.8825	31.7875	31.7925	8122128.0
2015-04-07 11:00:00	AAPL	Stock	31.79	31.8125	31.725	31.725	10508836.0
2015-04-07 11:30:00	AAPL	Stock	31.7325	31.775	31.7325	31.755	4228408.0
2015-04-07 12:00:00	AAPL	Stock	31.7558	31.82	31.7512	31.775	5203028.0
2015-04-07 12:30:00	AAPL	Stock	31.7762	31.7875	31.695	31.715	5780280.0
2015-04-07 13:00:00	AAPL	Stock	31.715	31.7425	31.6675	31.69	4925424.0
2015-04-07 13:30:00	AAPL	Stock	31.6875	31.7012	31.6525	31.6775	5142084.0
2015-04-07 14:00:00	AAPL	Stock	31.6762	31.7225	31.665	31.71	5625852.0
2015-04-07 14:30:00	AAPL	Stock	31.71	31.7575	31.695	31.6975	5440584.0
2015-04-07 15:00:00	AAPL	Stock	31.6975	31.7262	31.5825	31.6175	7705816.0
2015-04-07 15:30:00	AAPL	Stock	31.6175	31.6425	31.495	31.5012	16510584.0
2015-04-07 16:00:00	AAPL	Stock	31.5012	31.505	31.4498	31.475	9190108.0
2015-04-07 16:30:00	AAPL	Stock	31.7475	31.8375	31.45	31.465	129840.0
2015-04-07 17:00:00	AAPL	Stock	31.4725	31.5025	31.4525	31.475	84424.0
2015-04-07 17:30:00	AAPL	Stock	31.475	31.4875	31.475	31.4875	100200.0
2015-04-07 18:00:00	AAPL	Stock	31.4875	31.4875	31.4625	31.48	89360.0
2015-04-07 18:30:00	AAPL	Stock	31.48	31.485	31.4125	31.435	131380.0
2015-04-07 19:00:00	AAPL	Stock	31.435	31.45	31.425	31.4475	49524.0
2015-04-07 19:30:00	AAPL	Stock	31.4425	31.46	31.425	31.435	60416.0
2015-04-07 04:00:00	MSFT	Stock	42.0	42.0	41.47	41.58	1200.0
2015-04-07 04:30:00	MSFT	Stock	41.53	41.53	41.53	41.53	1000.0
2015-04-07 06:30:00	MSFT	Stock	41.5	41.5	41.38	41.42	12996.0
2015-04-07 07:00:00	MSFT	Stock	41.48	41.57	41.48	41.54	1750.0
2015-04-07 07:30:00	MSFT	Stock	41.57	41.57	41.55	41.55	501.0
2015-04-07 08:00:00	MSFT	Stock	41.519	41.54	41.48	41.48	5050.0
2015-04-07 08:30:00	MSFT	Stock	41.48	41.48	41.42	41.43	3443.0
2015-04-07 09:00:00	MSFT	Stock	41.45	41.58	41.31	41.46	51419.0
2015-04-07 09:30:00	MSFT	Stock	41.61	41.63	41.34	41.43	3857168.0
2015-04-07 10:00:00	MSFT	Stock	41.44	41.505	41.31	41.495	2391270.0
2015-04-07 10:30:00	MSFT	Stock	41.495	41.67	41.49	41.58	1439220.0
2015-04-07 11:00:00	MSFT	Stock	41.585	41.72	41.58	41.66	1529075.0
2015-04-07 11:30:00	MSFT	Stock	41.67	41.82	41.665	41.76	1943427.0
2015-04-07 12:00:00	MSFT	Stock	41.76	41.91	41.76	41.885	1355456.0
2015-04-07 12:30:00	MSFT	Stock	41.89	41.9	41.76	41.84	1561042.0
2015-04-07 13:00:00	MSFT	Stock	41.835	41.88	41.8	41.845	1190207.0
2015-04-07 13:30:00	MSFT	Stock	41.84	41.86	41.79	41.79	1226439.0
2015-04-07 14:00:00	MSFT	Stock	41.795	41.87	41.75	41.866	1252191.0

> showing 50 of 82,033 rows — these rows as CSV

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