PREVIEW / stock_30min / 2013-10-23

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-23.parquet
  size:    1.5 MB
  rows:    79,676
  symbols: 3,536

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-10-23 04:00:00	AAPL	Stock	18.4954	18.5268	18.4954	18.5118	19600.0
2013-10-23 04:30:00	AAPL	Stock	18.525	18.5268	18.525	18.5268	14000.0
2013-10-23 05:00:00	AAPL	Stock	18.5357	18.5357	18.5357	18.5357	5600.0
2013-10-23 05:30:00	AAPL	Stock	18.5343	18.5343	18.4954	18.4954	58800.0
2013-10-23 06:00:00	AAPL	Stock	18.4771	18.4771	18.4768	18.4768	56000.0
2013-10-23 06:30:00	AAPL	Stock	18.4821	18.5	18.4589	18.4589	47600.0
2013-10-23 07:00:00	AAPL	Stock	18.4679	18.5	18.4504	18.5	229264.0
2013-10-23 07:30:00	AAPL	Stock	18.5121	18.5179	18.4736	18.4911	140616.0
2013-10-23 08:00:00	AAPL	Stock	18.5168	18.525	18.4571	18.4918	547344.0
2013-10-23 08:30:00	AAPL	Stock	18.4975	18.6336	18.4918	18.6246	1544648.0
2013-10-23 09:00:00	AAPL	Stock	18.6293	18.6643	18.5357	18.5364	2562000.0
2013-10-23 09:30:00	AAPL	Stock	18.5364	18.75	18.5357	18.5854	60987332.0
2013-10-23 10:00:00	AAPL	Stock	18.5871	18.7061	18.5454	18.6553	31613148.0
2013-10-23 10:30:00	AAPL	Stock	18.6521	18.7143	18.6089	18.6429	20880524.0
2013-10-23 11:00:00	AAPL	Stock	18.6493	18.7004	18.6454	18.6829	13228740.0
2013-10-23 11:30:00	AAPL	Stock	18.6854	18.7079	18.6521	18.6704	11534012.0
2013-10-23 12:00:00	AAPL	Stock	18.6761	18.6786	18.6504	18.6704	7354256.0
2013-10-23 12:30:00	AAPL	Stock	18.6711	18.7143	18.6672	18.7133	12148528.0
2013-10-23 13:00:00	AAPL	Stock	18.7093	18.7346	18.7036	18.7269	11443180.0
2013-10-23 13:30:00	AAPL	Stock	18.7286	18.7361	18.7054	18.7054	9935016.0
2013-10-23 14:00:00	AAPL	Stock	18.7076	18.7275	18.6586	18.6798	13001240.0
2013-10-23 14:30:00	AAPL	Stock	18.685	18.7268	18.6796	18.7086	9493932.0
2013-10-23 15:00:00	AAPL	Stock	18.7087	18.7739	18.6625	18.7307	49110516.0
2013-10-23 15:30:00	AAPL	Stock	18.7321	18.7704	18.7118	18.7482	28700280.0
2013-10-23 16:00:00	AAPL	Stock	18.7486	18.7643	18.6796	18.7375	6256208.0
2013-10-23 16:30:00	AAPL	Stock	18.7489	18.7589	18.661	18.7536	409108.0
2013-10-23 17:00:00	AAPL	Stock	18.75	18.75	18.7232	18.7404	196952.0
2013-10-23 17:30:00	AAPL	Stock	18.7343	18.7486	18.7332	18.7339	135520.0
2013-10-23 18:00:00	AAPL	Stock	18.7357	18.7486	18.7357	18.7486	139944.0
2013-10-23 18:30:00	AAPL	Stock	18.7429	18.7479	18.7321	18.7468	162960.0
2013-10-23 19:00:00	AAPL	Stock	18.7436	18.7582	18.7425	18.7579	155568.0
2013-10-23 19:30:00	AAPL	Stock	18.7518	18.7607	18.75	18.7589	179396.0
2013-10-23 06:00:00	MSFT	Stock	34.46	34.46	34.46	34.46	400.0
2013-10-23 08:00:00	MSFT	Stock	34.48	34.55	34.3	34.43	20455.0
2013-10-23 08:30:00	MSFT	Stock	34.44	34.44	34.43	34.43	1100.0
2013-10-23 09:00:00	MSFT	Stock	34.48	34.48	34.33	34.34	6002.0
2013-10-23 09:30:00	MSFT	Stock	34.32	34.49	34.11	34.215	6922712.0
2013-10-23 10:00:00	MSFT	Stock	34.215	34.3	34.16	34.175	4625681.0
2013-10-23 10:30:00	MSFT	Stock	34.17	34.18	33.91	33.96	6491006.0
2013-10-23 11:00:00	MSFT	Stock	33.964	33.97	33.75	33.87	5664249.0
2013-10-23 11:30:00	MSFT	Stock	33.87	34.03	33.86	33.99	2831234.0
2013-10-23 12:00:00	MSFT	Stock	33.985	34.005	33.88	33.949	1690839.0
2013-10-23 12:30:00	MSFT	Stock	33.95	34.1	33.945	34.085	1586018.0
2013-10-23 13:00:00	MSFT	Stock	34.089	34.15	34.04	34.138	1413120.0
2013-10-23 13:30:00	MSFT	Stock	34.14	34.16	34.02	34.038	1468015.0
2013-10-23 14:00:00	MSFT	Stock	34.035	34.085	34.0	34.012	1887842.0
2013-10-23 14:30:00	MSFT	Stock	34.02	34.03	33.94	33.98	2188754.0
2013-10-23 15:00:00	MSFT	Stock	33.98	33.99	33.805	33.87	4060333.0
2013-10-23 15:30:00	MSFT	Stock	33.87	33.87	33.674	33.77	11765981.0
2013-10-23 16:00:00	MSFT	Stock	33.745	34.223	33.7	33.8	2248978.0

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

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