PREVIEW / stock_1min / 2012-07-17

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-07-17.parquet
  size:    12.6 MB
  rows:    927,800
  symbols: 2,822

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
2012-07-17 04:12:00	AAPL	Stock	21.7682	21.7682	21.7682	21.7682	2800.0
2012-07-17 04:40:00	AAPL	Stock	21.8029	21.8029	21.8029	21.8029	2800.0
2012-07-17 04:44:00	AAPL	Stock	21.8	21.8	21.8	21.8	2800.0
2012-07-17 05:59:00	AAPL	Stock	21.8	21.8	21.8	21.8	2800.0
2012-07-17 06:06:00	AAPL	Stock	21.7964	21.7964	21.7964	21.7964	8400.0
2012-07-17 06:07:00	AAPL	Stock	21.7964	21.7964	21.7964	21.7964	2800.0
2012-07-17 06:08:00	AAPL	Stock	21.7964	21.7964	21.7964	21.7964	3500.0
2012-07-17 06:14:00	AAPL	Stock	21.8036	21.8036	21.8036	21.8036	8400.0
2012-07-17 06:41:00	AAPL	Stock	21.7857	21.7857	21.7857	21.7857	2800.0
2012-07-17 06:58:00	AAPL	Stock	21.7918	21.7918	21.7911	21.7911	8400.0
2012-07-17 07:00:00	AAPL	Stock	21.7718	21.7718	21.7593	21.7593	27160.0
2012-07-17 07:01:00	AAPL	Stock	21.7825	21.7825	21.7593	21.7804	19740.0
2012-07-17 07:02:00	AAPL	Stock	21.7696	21.7804	21.7639	21.7804	11200.0
2012-07-17 07:10:00	AAPL	Stock	21.7618	21.7618	21.7618	21.7618	2800.0
2012-07-17 07:11:00	AAPL	Stock	21.7596	21.7596	21.7596	21.7596	2800.0
2012-07-17 07:16:00	AAPL	Stock	21.7593	21.7593	21.7571	21.7571	8400.0
2012-07-17 07:17:00	AAPL	Stock	21.7593	21.7804	21.7525	21.7525	153888.0
2012-07-17 07:18:00	AAPL	Stock	21.7696	21.77	21.7679	21.7679	39200.0
2012-07-17 07:19:00	AAPL	Stock	21.7679	21.7679	21.7679	21.7679	16800.0
2012-07-17 07:20:00	AAPL	Stock	21.7821	21.7821	21.7821	21.7821	2800.0
2012-07-17 07:27:00	AAPL	Stock	21.7643	21.7643	21.7643	21.7643	2800.0
2012-07-17 07:28:00	AAPL	Stock	21.7643	21.7643	21.7643	21.7643	2800.0
2012-07-17 07:31:00	AAPL	Stock	21.7643	21.7646	21.7643	21.7643	33376.0
2012-07-17 07:32:00	AAPL	Stock	21.7661	21.7679	21.7661	21.7679	5600.0
2012-07-17 07:33:00	AAPL	Stock	21.7704	21.7704	21.7704	21.7704	2800.0
2012-07-17 07:35:00	AAPL	Stock	21.775	21.775	21.775	21.775	3052.0
2012-07-17 07:40:00	AAPL	Stock	21.7839	21.7839	21.7839	21.7839	2800.0
2012-07-17 07:44:00	AAPL	Stock	21.7829	21.7857	21.7829	21.7857	19600.0
2012-07-17 07:46:00	AAPL	Stock	21.7721	21.7721	21.7718	21.7718	8400.0
2012-07-17 07:47:00	AAPL	Stock	21.7857	21.7907	21.7857	21.7907	8400.0
2012-07-17 07:48:00	AAPL	Stock	21.7854	21.7854	21.7854	21.7854	2800.0
2012-07-17 07:49:00	AAPL	Stock	21.7857	21.7857	21.7857	21.7857	12880.0
2012-07-17 07:51:00	AAPL	Stock	21.7857	21.7857	21.7857	21.7857	2800.0
2012-07-17 07:53:00	AAPL	Stock	21.7857	21.7857	21.7857	21.7857	5600.0
2012-07-17 07:54:00	AAPL	Stock	21.7857	21.7857	21.7857	21.7857	2800.0
2012-07-17 07:58:00	AAPL	Stock	21.7925	21.8036	21.7925	21.8036	53088.0
2012-07-17 08:00:00	AAPL	Stock	21.7979	21.7979	21.7818	21.7857	278796.0
2012-07-17 08:01:00	AAPL	Stock	21.785	21.7857	21.7771	21.7804	49056.0
2012-07-17 08:02:00	AAPL	Stock	21.7779	21.7779	21.7679	21.7679	50428.0
2012-07-17 08:03:00	AAPL	Stock	21.775	21.7768	21.7679	21.7714	63112.0
2012-07-17 08:04:00	AAPL	Stock	21.7764	21.7764	21.7746	21.7746	5600.0
2012-07-17 08:05:00	AAPL	Stock	21.7746	21.7746	21.7743	21.7743	25200.0
2012-07-17 08:06:00	AAPL	Stock	21.7729	21.775	21.7682	21.7714	25144.0
2012-07-17 08:07:00	AAPL	Stock	21.7736	21.775	21.7736	21.775	8344.0
2012-07-17 08:09:00	AAPL	Stock	21.7786	21.7786	21.7714	21.7714	8904.0
2012-07-17 08:10:00	AAPL	Stock	21.77	21.7779	21.7696	21.7779	38920.0
2012-07-17 08:12:00	AAPL	Stock	21.7707	21.7718	21.7696	21.7714	28000.0
2012-07-17 08:14:00	AAPL	Stock	21.7746	21.775	21.7746	21.775	12600.0
2012-07-17 08:15:00	AAPL	Stock	21.7757	21.7786	21.7757	21.7786	28000.0
2012-07-17 08:16:00	AAPL	Stock	21.7786	21.7789	21.7786	21.7786	22820.0

> showing 50 of 927,800 rows — these rows as CSV

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