PREVIEW / stock_30min / 2013-08-06

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-06.parquet
  size:    1.5 MB
  rows:    79,011
  symbols: 3,512

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
2013-08-06 04:00:00	AAPL	Stock	16.7739	16.7768	16.7739	16.7768	11200.0
2013-08-06 05:30:00	AAPL	Stock	16.7257	16.7321	16.7257	16.7321	8400.0
2013-08-06 06:00:00	AAPL	Stock	16.7679	16.7768	16.7446	16.7446	45948.0
2013-08-06 06:30:00	AAPL	Stock	16.7214	16.7214	16.6964	16.6964	61516.0
2013-08-06 07:00:00	AAPL	Stock	16.7139	16.7429	16.6964	16.7404	42280.0
2013-08-06 07:30:00	AAPL	Stock	16.7357	16.7357	16.7143	16.7143	22092.0
2013-08-06 08:00:00	AAPL	Stock	16.705	16.7407	16.705	16.7286	257152.0
2013-08-06 08:30:00	AAPL	Stock	16.725	16.7479	16.725	16.7314	586320.0
2013-08-06 09:00:00	AAPL	Stock	16.7314	16.7457	16.7068	16.7146	424340.0
2013-08-06 09:30:00	AAPL	Stock	16.715	16.8532	16.7143	16.805	57794744.0
2013-08-06 10:00:00	AAPL	Stock	16.8054	16.8218	16.7336	16.7621	27085156.0
2013-08-06 10:30:00	AAPL	Stock	16.7639	16.7668	16.5711	16.5714	39732448.0
2013-08-06 11:00:00	AAPL	Stock	16.5739	16.6786	16.55	16.6537	31687852.0
2013-08-06 11:30:00	AAPL	Stock	16.6582	16.6704	16.5993	16.6143	14029792.0
2013-08-06 12:00:00	AAPL	Stock	16.6171	16.6429	16.5964	16.5999	9234456.0
2013-08-06 12:30:00	AAPL	Stock	16.5996	16.6514	16.5968	16.6268	8844892.0
2013-08-06 13:00:00	AAPL	Stock	16.6293	16.6314	16.6068	16.6158	6992440.0
2013-08-06 13:30:00	AAPL	Stock	16.6139	16.6146	16.575	16.5814	10904040.0
2013-08-06 14:00:00	AAPL	Stock	16.5814	16.6107	16.5061	16.5953	26710208.0
2013-08-06 14:30:00	AAPL	Stock	16.5939	16.6125	16.574	16.5875	13120408.0
2013-08-06 15:00:00	AAPL	Stock	16.5904	16.6546	16.5821	16.6461	15281868.0
2013-08-06 15:30:00	AAPL	Stock	16.6482	16.7143	16.6071	16.615	31347708.0
2013-08-06 16:00:00	AAPL	Stock	16.6161	16.796	16.6154	16.6161	21079744.0
2013-08-06 16:30:00	AAPL	Stock	16.6186	16.6562	16.6161	16.6161	2100616.0
2013-08-06 17:00:00	AAPL	Stock	16.6182	16.6207	16.6107	16.6129	121492.0
2013-08-06 17:30:00	AAPL	Stock	16.6161	16.6186	16.6071	16.6071	33796.0
2013-08-06 18:00:00	AAPL	Stock	16.6071	16.6071	16.6071	16.6071	17108.0
2013-08-06 18:30:00	AAPL	Stock	16.6154	16.6154	16.6154	16.6154	2800.0
2013-08-06 19:00:00	AAPL	Stock	16.6161	16.6161	16.6161	16.6161	2800.0
2013-08-06 19:30:00	AAPL	Stock	16.6182	16.6182	16.6014	16.6143	32480.0
2013-08-06 06:00:00	MSFT	Stock	31.7	31.7	31.69	31.69	313.0
2013-08-06 06:30:00	MSFT	Stock	31.69	31.69	31.69	31.69	100.0
2013-08-06 08:00:00	MSFT	Stock	31.69	31.69	31.66	31.66	384.0
2013-08-06 08:30:00	MSFT	Stock	31.66	31.69	31.66	31.69	5205.0
2013-08-06 09:00:00	MSFT	Stock	31.68	31.74	31.55	31.55	60111.0
2013-08-06 09:30:00	MSFT	Stock	31.6	31.67	31.47	31.54	4091160.0
2013-08-06 10:00:00	MSFT	Stock	31.53	31.55	31.45	31.48	3577269.0
2013-08-06 10:30:00	MSFT	Stock	31.49	31.5	31.42	31.455	2983559.0
2013-08-06 11:00:00	MSFT	Stock	31.456	31.49	31.44	31.46	1968176.0
2013-08-06 11:30:00	MSFT	Stock	31.47	31.53	31.46	31.52	2452427.0
2013-08-06 12:00:00	MSFT	Stock	31.52	31.54	31.46	31.47	1848183.0
2013-08-06 12:30:00	MSFT	Stock	31.47	31.51	31.46	31.5	1561048.0
2013-08-06 13:00:00	MSFT	Stock	31.5	31.51	31.47	31.47	1434383.0
2013-08-06 13:30:00	MSFT	Stock	31.475	31.48	31.39	31.4	1483050.0
2013-08-06 14:00:00	MSFT	Stock	31.4	31.44	31.38	31.435	1664693.0
2013-08-06 14:30:00	MSFT	Stock	31.43	31.445	31.41	31.435	1646947.0
2013-08-06 15:00:00	MSFT	Stock	31.44	31.56	31.43	31.55	3513499.0
2013-08-06 15:30:00	MSFT	Stock	31.545	31.61	31.53	31.58	5746473.0
2013-08-06 16:00:00	MSFT	Stock	31.57	31.656	31.447	31.499	1409406.0
2013-08-06 16:30:00	MSFT	Stock	31.53	31.58	31.52	31.58	573456.0

> showing 50 of 79,011 rows — these rows as CSV

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