PREVIEW / stock_30min / 2011-07-11

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-11.parquet
  size:    1.4 MB
  rows:    77,028
  symbols: 3,545

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-07-11 04:00:00	AAPL	Stock	12.7179	12.7179	12.7179	12.7179	16800.0
2011-07-11 04:30:00	AAPL	Stock	12.7225	12.7411	12.72	12.7204	14700.0
2011-07-11 05:00:00	AAPL	Stock	12.7161	12.7161	12.7161	12.7161	2800.0
2011-07-11 05:30:00	AAPL	Stock	12.7179	12.7179	12.6911	12.6929	42000.0
2011-07-11 06:00:00	AAPL	Stock	12.7061	12.7182	12.7061	12.7182	61600.0
2011-07-11 06:30:00	AAPL	Stock	12.7382	12.7429	12.7321	12.7429	16800.0
2011-07-11 07:00:00	AAPL	Stock	12.7418	12.7739	12.7393	12.75	261772.0
2011-07-11 07:30:00	AAPL	Stock	12.75	12.7639	12.7229	12.7357	606172.0
2011-07-11 08:00:00	AAPL	Stock	12.7396	12.7679	12.7143	12.7357	1529836.0
2011-07-11 08:30:00	AAPL	Stock	12.7321	12.7536	12.7282	12.75	709464.0
2011-07-11 09:00:00	AAPL	Stock	12.7471	12.7536	12.7261	12.7304	1426040.0
2011-07-11 09:30:00	AAPL	Stock	12.7264	12.8407	12.7182	12.8032	75652584.0
2011-07-11 10:00:00	AAPL	Stock	12.8043	12.8489	12.7536	12.7618	53132464.0
2011-07-11 10:30:00	AAPL	Stock	12.7618	12.7757	12.6611	12.6686	47442080.0
2011-07-11 11:00:00	AAPL	Stock	12.6657	12.6961	12.6194	12.6875	47692764.0
2011-07-11 11:30:00	AAPL	Stock	12.6857	12.725	12.6654	12.71	26732972.0
2011-07-11 12:00:00	AAPL	Stock	12.7118	12.7204	12.6739	12.7075	14561820.0
2011-07-11 12:30:00	AAPL	Stock	12.7071	12.7171	12.6779	12.6871	11030376.0
2011-07-11 13:00:00	AAPL	Stock	12.6861	12.6914	12.6268	12.6664	21944244.0
2011-07-11 13:30:00	AAPL	Stock	12.6664	12.6789	12.6457	12.6692	12574744.0
2011-07-11 14:00:00	AAPL	Stock	12.6689	12.6779	12.6275	12.6393	17112900.0
2011-07-11 14:30:00	AAPL	Stock	12.6379	12.6557	12.6071	12.6361	23816464.0
2011-07-11 15:00:00	AAPL	Stock	12.6334	12.6564	12.6007	12.6467	27099296.0
2011-07-11 15:30:00	AAPL	Stock	12.6455	12.6589	12.6036	12.6464	43071168.0
2011-07-11 16:00:00	AAPL	Stock	12.6443	12.7109	12.6403	12.6479	7233464.0
2011-07-11 16:30:00	AAPL	Stock	12.6486	12.6514	12.6436	12.6457	285516.0
2011-07-11 17:00:00	AAPL	Stock	12.6518	12.6554	12.6371	12.6371	247352.0
2011-07-11 17:30:00	AAPL	Stock	12.6429	12.6429	12.6304	12.6346	926632.0
2011-07-11 18:00:00	AAPL	Stock	12.635	12.6464	12.635	12.6429	212716.0
2011-07-11 18:30:00	AAPL	Stock	12.6429	12.6464	12.6429	12.6464	11200.0
2011-07-11 19:00:00	AAPL	Stock	12.6429	12.6429	12.6393	12.6393	93268.0
2011-07-11 19:30:00	AAPL	Stock	12.6396	12.6421	12.6304	12.6411	70700.0
2011-07-11 04:00:00	MSFT	Stock	26.92	26.92	26.72	26.72	258.0
2011-07-11 05:30:00	MSFT	Stock	26.53	26.53	26.53	26.53	100.0
2011-07-11 06:30:00	MSFT	Stock	26.57	26.58	26.57	26.57	3000.0
2011-07-11 07:00:00	MSFT	Stock	26.58	26.59	26.55	26.59	12300.0
2011-07-11 07:30:00	MSFT	Stock	26.56	26.62	26.55	26.55	4637.0
2011-07-11 08:00:00	MSFT	Stock	26.53	26.62	26.53	26.55	60271.0
2011-07-11 08:30:00	MSFT	Stock	26.55	26.62	26.54	26.6	22486.0
2011-07-11 09:00:00	MSFT	Stock	26.6	26.67	26.57	26.66	122733.0
2011-07-11 09:30:00	MSFT	Stock	26.62	26.79	26.59	26.77	5117831.0
2011-07-11 10:00:00	MSFT	Stock	26.76	26.8	26.62	26.685	3177711.0
2011-07-11 10:30:00	MSFT	Stock	26.681	26.73	26.6	26.6	2708277.0
2011-07-11 11:00:00	MSFT	Stock	26.6	26.65	26.58	26.645	2485422.0
2011-07-11 11:30:00	MSFT	Stock	26.65	26.71	26.62	26.66	3253790.0
2011-07-11 12:00:00	MSFT	Stock	26.654	26.685	26.61	26.65	1512121.0
2011-07-11 12:30:00	MSFT	Stock	26.65	26.72	26.64	26.68	2218803.0
2011-07-11 13:00:00	MSFT	Stock	26.68	26.718	26.55	26.63	3066359.0
2011-07-11 13:30:00	MSFT	Stock	26.63	26.64	26.6	26.62	1393543.0
2011-07-11 14:00:00	MSFT	Stock	26.625	26.64	26.5	26.541	3066353.0

> showing 50 of 77,028 rows — these rows as CSV

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