PREVIEW / stock_1min / 2014-05-09

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-05-09.parquet
  size:    14.3 MB
  rows:    1,058,266
  symbols: 2,873

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
2014-05-09 04:00:00	AAPL	Stock	20.9964	20.9964	20.8929	20.8929	11200.0
2014-05-09 05:25:00	AAPL	Stock	20.9479	20.9479	20.9457	20.9457	5600.0
2014-05-09 05:59:00	AAPL	Stock	20.9554	20.9554	20.9554	20.9554	2800.0
2014-05-09 06:00:00	AAPL	Stock	20.9518	20.9518	20.9518	20.9518	2800.0
2014-05-09 06:04:00	AAPL	Stock	20.945	20.945	20.945	20.945	2800.0
2014-05-09 06:18:00	AAPL	Stock	20.9429	20.9429	20.9429	20.9429	5600.0
2014-05-09 06:24:00	AAPL	Stock	20.9143	20.9143	20.9107	20.9107	14000.0
2014-05-09 06:28:00	AAPL	Stock	20.8839	20.8839	20.8839	20.8839	5600.0
2014-05-09 06:35:00	AAPL	Stock	20.9082	20.9082	20.9082	20.9082	2800.0
2014-05-09 07:00:00	AAPL	Stock	20.9107	20.9107	20.9107	20.9107	4284.0
2014-05-09 07:01:00	AAPL	Stock	20.9107	20.9107	20.9107	20.9107	10920.0
2014-05-09 07:05:00	AAPL	Stock	20.9107	20.9107	20.9107	20.9107	5600.0
2014-05-09 07:19:00	AAPL	Stock	20.9096	20.9107	20.9096	20.9107	19600.0
2014-05-09 07:20:00	AAPL	Stock	20.9107	20.9107	20.9107	20.9107	7000.0
2014-05-09 07:21:00	AAPL	Stock	20.8975	20.9107	20.8975	20.9107	9800.0
2014-05-09 07:22:00	AAPL	Stock	20.9089	20.9089	20.9054	20.9054	8400.0
2014-05-09 07:25:00	AAPL	Stock	20.8968	20.8968	20.8929	20.8929	7756.0
2014-05-09 07:27:00	AAPL	Stock	20.8839	20.8839	20.8636	20.8636	25200.0
2014-05-09 07:32:00	AAPL	Stock	20.8907	20.8921	20.8907	20.8921	5964.0
2014-05-09 07:33:00	AAPL	Stock	20.8968	20.9071	20.8968	20.9071	16772.0
2014-05-09 07:34:00	AAPL	Stock	20.9107	20.9696	20.9107	20.9696	33600.0
2014-05-09 07:41:00	AAPL	Stock	20.9286	20.9286	20.9093	20.9093	33600.0
2014-05-09 07:46:00	AAPL	Stock	20.9168	20.9168	20.9168	20.9168	2800.0
2014-05-09 07:49:00	AAPL	Stock	20.9214	20.9214	20.9214	20.9214	2800.0
2014-05-09 07:50:00	AAPL	Stock	20.9254	20.9254	20.9093	20.9093	37716.0
2014-05-09 07:57:00	AAPL	Stock	20.9129	20.9129	20.9071	20.9129	9940.0
2014-05-09 07:58:00	AAPL	Stock	20.905	20.905	20.905	20.905	2940.0
2014-05-09 08:00:00	AAPL	Stock	20.9107	20.9196	20.8679	20.8768	110516.0
2014-05-09 08:01:00	AAPL	Stock	20.8929	20.9025	20.8929	20.8929	32116.0
2014-05-09 08:02:00	AAPL	Stock	20.895	20.895	20.895	20.895	56000.0
2014-05-09 08:03:00	AAPL	Stock	20.9	20.9	20.9	20.9	2800.0
2014-05-09 08:07:00	AAPL	Stock	20.9036	20.9036	20.9036	20.9036	4200.0
2014-05-09 08:08:00	AAPL	Stock	20.9036	20.9036	20.8929	20.8929	8400.0
2014-05-09 08:11:00	AAPL	Stock	20.9132	20.9214	20.9018	20.9193	44912.0
2014-05-09 08:13:00	AAPL	Stock	20.9189	20.9189	20.8768	20.8768	82012.0
2014-05-09 08:20:00	AAPL	Stock	20.8932	20.8932	20.8932	20.8932	4228.0
2014-05-09 08:23:00	AAPL	Stock	20.8839	20.8839	20.8768	20.8768	23380.0
2014-05-09 08:24:00	AAPL	Stock	20.8768	20.8768	20.8679	20.8679	39620.0
2014-05-09 08:25:00	AAPL	Stock	20.8679	20.875	20.8636	20.875	46816.0
2014-05-09 08:27:00	AAPL	Stock	20.8714	20.8714	20.8571	20.8714	31612.0
2014-05-09 08:28:00	AAPL	Stock	20.8732	20.8732	20.8714	20.8714	11200.0
2014-05-09 08:30:00	AAPL	Stock	20.875	20.875	20.8714	20.8714	8400.0
2014-05-09 08:31:00	AAPL	Stock	20.875	20.875	20.8654	20.8654	16800.0
2014-05-09 08:32:00	AAPL	Stock	20.875	20.875	20.8661	20.8679	10948.0
2014-05-09 08:33:00	AAPL	Stock	20.8768	20.8768	20.8643	20.8661	31640.0
2014-05-09 08:34:00	AAPL	Stock	20.8775	20.8793	20.8661	20.875	16800.0
2014-05-09 08:35:00	AAPL	Stock	20.8689	20.8689	20.8664	20.8664	16800.0
2014-05-09 08:36:00	AAPL	Stock	20.875	20.875	20.875	20.875	2800.0
2014-05-09 08:38:00	AAPL	Stock	20.8714	20.8714	20.8643	20.8679	32620.0
2014-05-09 08:39:00	AAPL	Stock	20.8679	20.8679	20.8571	20.8571	38164.0

> showing 50 of 1,058,266 rows — these rows as CSV

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