PREVIEW / stock_30min / 2011-06-27

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-27.parquet
  size:    1.4 MB
  rows:    75,288
  symbols: 3,551

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-06-27 04:30:00	AAPL	Stock	11.6789	11.6789	11.6789	11.6789	8400.0
2011-06-27 05:00:00	AAPL	Stock	11.7046	11.7046	11.6839	11.6839	5600.0
2011-06-27 06:00:00	AAPL	Stock	11.7104	11.7146	11.7104	11.7146	25200.0
2011-06-27 06:30:00	AAPL	Stock	11.7232	11.7232	11.7143	11.7143	11200.0
2011-06-27 07:00:00	AAPL	Stock	11.7082	11.7511	11.7082	11.7425	286300.0
2011-06-27 07:30:00	AAPL	Stock	11.7496	11.7661	11.7414	11.7446	414120.0
2011-06-27 08:00:00	AAPL	Stock	11.7457	11.7457	11.7254	11.7289	497840.0
2011-06-27 08:30:00	AAPL	Stock	11.7286	11.75	11.7143	11.7343	799092.0
2011-06-27 09:00:00	AAPL	Stock	11.7339	11.7346	11.6864	11.7021	1422372.0
2011-06-27 09:30:00	AAPL	Stock	11.7011	11.7975	11.6875	11.7739	52381588.0
2011-06-27 10:00:00	AAPL	Stock	11.7771	11.84	11.7589	11.84	32220160.0
2011-06-27 10:30:00	AAPL	Stock	11.8411	11.8529	11.8086	11.8175	21266868.0
2011-06-27 11:00:00	AAPL	Stock	11.8182	11.8393	11.8161	11.8239	17754688.0
2011-06-27 11:30:00	AAPL	Stock	11.8246	11.8714	11.8143	11.8679	17610992.0
2011-06-27 12:00:00	AAPL	Stock	11.8675	11.8846	11.843	11.8518	15262436.0
2011-06-27 12:30:00	AAPL	Stock	11.8507	11.8821	11.8489	11.8722	12933088.0
2011-06-27 13:00:00	AAPL	Stock	11.8728	11.8911	11.8536	11.8541	15529752.0
2011-06-27 13:30:00	AAPL	Stock	11.8539	11.8793	11.85	11.8686	10229828.0
2011-06-27 14:00:00	AAPL	Stock	11.8693	11.9225	11.8686	11.9182	23485280.0
2011-06-27 14:30:00	AAPL	Stock	11.9193	11.925	11.8957	11.8964	15582504.0
2011-06-27 15:00:00	AAPL	Stock	11.8971	11.9107	11.8789	11.9007	20422668.0
2011-06-27 15:30:00	AAPL	Stock	11.9004	11.9107	11.8514	11.86	36873620.0
2011-06-27 16:00:00	AAPL	Stock	11.8586	11.8682	11.8389	11.8625	38747184.0
2011-06-27 16:30:00	AAPL	Stock	11.8657	11.8862	11.8586	11.8679	597380.0
2011-06-27 17:00:00	AAPL	Stock	11.8704	11.8732	11.87	11.8729	79800.0
2011-06-27 17:30:00	AAPL	Stock	11.8696	11.8732	11.8693	11.8714	25032.0
2011-06-27 18:00:00	AAPL	Stock	11.8707	11.8768	11.8586	11.8746	529872.0
2011-06-27 18:30:00	AAPL	Stock	11.8786	11.8864	11.8714	11.8714	36148.0
2011-06-27 19:00:00	AAPL	Stock	11.8786	11.885	11.8732	11.8843	62580.0
2011-06-27 19:30:00	AAPL	Stock	11.8839	11.8857	11.8821	11.8857	48272.0
2011-06-27 06:00:00	MSFT	Stock	24.39	24.39	24.39	24.39	400.0
2011-06-27 06:30:00	MSFT	Stock	24.39	24.39	24.39	24.39	400.0
2011-06-27 07:00:00	MSFT	Stock	24.35	24.35	24.35	24.35	447.0
2011-06-27 07:30:00	MSFT	Stock	24.35	24.36	24.35	24.36	2400.0
2011-06-27 08:00:00	MSFT	Stock	24.37	24.37	24.33	24.34	10675.0
2011-06-27 08:30:00	MSFT	Stock	24.34	24.35	24.29	24.29	33950.0
2011-06-27 09:00:00	MSFT	Stock	24.31	24.32	24.22	24.24	80612.0
2011-06-27 09:30:00	MSFT	Stock	24.25	24.7	24.23	24.675	7051332.0
2011-06-27 10:00:00	MSFT	Stock	24.68	25.02	24.67	25.0	8627376.0
2011-06-27 10:30:00	MSFT	Stock	25.0	25.04	24.93	25.015	7376477.0
2011-06-27 11:00:00	MSFT	Stock	25.01	25.17	25.0	25.105	5796926.0
2011-06-27 11:30:00	MSFT	Stock	25.11	25.289	25.1	25.26	6259163.0
2011-06-27 12:00:00	MSFT	Stock	25.25	25.29	25.19	25.275	5886874.0
2011-06-27 12:30:00	MSFT	Stock	25.28	25.29	25.23	25.27	3844499.0
2011-06-27 13:00:00	MSFT	Stock	25.27	25.295	25.23	25.231	3664591.0
2011-06-27 13:30:00	MSFT	Stock	25.235	25.28	25.23	25.27	3038655.0
2011-06-27 14:00:00	MSFT	Stock	25.28	25.4	25.272	25.39	5707218.0
2011-06-27 14:30:00	MSFT	Stock	25.39	25.405	25.35	25.38	3346745.0
2011-06-27 15:00:00	MSFT	Stock	25.375	25.46	25.37	25.45	6220586.0
2011-06-27 15:30:00	MSFT	Stock	25.45	25.45	25.18	25.19	13885076.0

> showing 50 of 75,288 rows — these rows as CSV

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