PREVIEW / stock_30min / 2011-09-13

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-13.parquet
  size:    1.4 MB
  rows:    73,832
  symbols: 3,483

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
2011-09-13 04:00:00	AAPL	Stock	13.5029	13.5029	13.4325	13.4325	44800.0
2011-09-13 04:30:00	AAPL	Stock	13.4632	13.4964	13.4632	13.4964	5600.0
2011-09-13 07:00:00	AAPL	Stock	13.5032	13.5964	13.5	13.5907	720300.0
2011-09-13 07:30:00	AAPL	Stock	13.595	13.6589	13.5396	13.6046	1266356.0
2011-09-13 08:00:00	AAPL	Stock	13.5893	13.5982	13.5446	13.5821	1311576.0
2011-09-13 08:30:00	AAPL	Stock	13.585	13.6518	13.5804	13.6036	1725444.0
2011-09-13 09:00:00	AAPL	Stock	13.6029	13.6482	13.5982	13.6479	2826516.0
2011-09-13 09:30:00	AAPL	Stock	13.6479	13.6661	13.5804	13.6343	69220060.0
2011-09-13 10:00:00	AAPL	Stock	13.6343	13.6964	13.6193	13.6854	43415932.0
2011-09-13 10:30:00	AAPL	Stock	13.6861	13.6964	13.6214	13.6407	29729924.0
2011-09-13 11:00:00	AAPL	Stock	13.6364	13.6511	13.6175	13.6343	16894052.0
2011-09-13 11:30:00	AAPL	Stock	13.6339	13.6618	13.6296	13.6421	16017792.0
2011-09-13 12:00:00	AAPL	Stock	13.6396	13.6561	13.6196	13.6511	12194896.0
2011-09-13 12:30:00	AAPL	Stock	13.6525	13.6868	13.6393	13.6755	17059812.0
2011-09-13 13:00:00	AAPL	Stock	13.6768	13.7268	13.6768	13.7262	23195452.0
2011-09-13 13:30:00	AAPL	Stock	13.7243	13.7679	13.705	13.7557	35969108.0
2011-09-13 14:00:00	AAPL	Stock	13.7539	13.7893	13.7232	13.7868	34151600.0
2011-09-13 14:30:00	AAPL	Stock	13.7879	13.7932	13.75	13.7664	34287232.0
2011-09-13 15:00:00	AAPL	Stock	13.7654	13.7804	13.6964	13.7418	45156972.0
2011-09-13 15:30:00	AAPL	Stock	13.7418	13.7693	13.7207	13.7314	44528596.0
2011-09-13 16:00:00	AAPL	Stock	13.7339	13.7368	13.6989	13.7264	8126188.0
2011-09-13 16:30:00	AAPL	Stock	13.725	13.7705	13.7	13.7029	420224.0
2011-09-13 17:00:00	AAPL	Stock	13.7121	13.7536	13.7061	13.7407	747180.0
2011-09-13 17:30:00	AAPL	Stock	13.7418	13.75	13.7361	13.7479	139804.0
2011-09-13 18:00:00	AAPL	Stock	13.7446	13.7461	13.7214	13.7214	165200.0
2011-09-13 18:30:00	AAPL	Stock	13.7375	13.7429	13.7286	13.7321	65912.0
2011-09-13 19:00:00	AAPL	Stock	13.7436	13.7436	13.7393	13.7425	12600.0
2011-09-13 19:30:00	AAPL	Stock	13.7357	13.7389	13.7239	13.7357	113288.0
2011-09-13 07:00:00	MSFT	Stock	25.84	25.84	25.84	25.84	1000.0
2011-09-13 07:30:00	MSFT	Stock	25.84	25.84	25.83	25.83	5000.0
2011-09-13 08:00:00	MSFT	Stock	25.81	25.86	25.81	25.85	1700.0
2011-09-13 08:30:00	MSFT	Stock	25.83	25.99	25.83	25.95	11960.0
2011-09-13 09:00:00	MSFT	Stock	25.95	25.99	25.91	25.94	36978.0
2011-09-13 09:30:00	MSFT	Stock	25.94	26.0	25.81	25.98	5311984.0
2011-09-13 10:00:00	MSFT	Stock	25.97	26.07	25.93	25.965	4202062.0
2011-09-13 10:30:00	MSFT	Stock	25.96	25.99	25.85	25.91	3408772.0
2011-09-13 11:00:00	MSFT	Stock	25.9	25.94	25.81	25.86	2699099.0
2011-09-13 11:30:00	MSFT	Stock	25.855	25.95	25.82	25.91	2172164.0
2011-09-13 12:00:00	MSFT	Stock	25.9	25.96	25.84	25.96	2432770.0
2011-09-13 12:30:00	MSFT	Stock	25.955	26.0	25.915	25.99	1934216.0
2011-09-13 13:00:00	MSFT	Stock	25.985	26.1	25.985	26.09	2808161.0
2011-09-13 13:30:00	MSFT	Stock	26.088	26.17	26.06	26.122	2173220.0
2011-09-13 14:00:00	MSFT	Stock	26.121	26.17	26.05	26.15	3333009.0
2011-09-13 14:30:00	MSFT	Stock	26.15	26.185	26.01	26.04	3186429.0
2011-09-13 15:00:00	MSFT	Stock	26.035	26.075	25.91	26.03	4439165.0
2011-09-13 15:30:00	MSFT	Stock	26.025	26.12	25.96	26.04	6805409.0
2011-09-13 16:00:00	MSFT	Stock	26.04	26.04	25.89	26.04	2571125.0
2011-09-13 16:30:00	MSFT	Stock	26.03	26.102	25.955	26.03	86840.0
2011-09-13 17:00:00	MSFT	Stock	26.03	26.03	26.03	26.03	1000.0
2011-09-13 17:30:00	MSFT	Stock	26.01	26.03	26.01	26.03	850.0

> showing 50 of 73,832 rows — these rows as CSV

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