PREVIEW / stock_1min / 2013-07-17

all stock 1-min files

  file:    by_date/stock_1min/2013/2013-07-17.parquet
  size:    13.0 MB
  rows:    957,185
  symbols: 2,835

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-07-17 05:03:00	AAPL	Stock	15.335	15.335	15.335	15.335	10612.0
2013-07-17 05:07:00	AAPL	Stock	15.3225	15.3225	15.3225	15.3225	3976.0
2013-07-17 05:28:00	AAPL	Stock	15.3193	15.3193	15.3193	15.3193	10108.0
2013-07-17 05:29:00	AAPL	Stock	15.3186	15.3186	15.3186	15.3186	4508.0
2013-07-17 05:36:00	AAPL	Stock	15.3221	15.3221	15.3221	15.3221	2800.0
2013-07-17 06:33:00	AAPL	Stock	15.3218	15.3218	15.3214	15.3214	11200.0
2013-07-17 06:37:00	AAPL	Stock	15.3221	15.3221	15.3214	15.3214	14280.0
2013-07-17 06:39:00	AAPL	Stock	15.3161	15.3161	15.3161	15.3161	14000.0
2013-07-17 06:52:00	AAPL	Stock	15.3161	15.3161	15.3161	15.3161	27160.0
2013-07-17 07:05:00	AAPL	Stock	15.3214	15.3214	15.3214	15.3214	8876.0
2013-07-17 07:08:00	AAPL	Stock	15.3214	15.3214	15.3214	15.3214	4200.0
2013-07-17 07:09:00	AAPL	Stock	15.3214	15.3214	15.3214	15.3214	22400.0
2013-07-17 07:13:00	AAPL	Stock	15.3229	15.3229	15.3214	15.3214	14000.0
2013-07-17 07:14:00	AAPL	Stock	15.3218	15.3218	15.3218	15.3218	6244.0
2013-07-17 07:24:00	AAPL	Stock	15.3314	15.3329	15.3314	15.3329	6244.0
2013-07-17 07:25:00	AAPL	Stock	15.325	15.3254	15.3229	15.3229	11200.0
2013-07-17 07:29:00	AAPL	Stock	15.3382	15.3414	15.3382	15.3414	8988.0
2013-07-17 07:31:00	AAPL	Stock	15.3329	15.3375	15.3214	15.3214	56000.0
2013-07-17 07:32:00	AAPL	Stock	15.3196	15.3196	15.3036	15.3036	70000.0
2013-07-17 07:35:00	AAPL	Stock	15.3075	15.3075	15.2857	15.2857	48216.0
2013-07-17 07:36:00	AAPL	Stock	15.2857	15.2857	15.2707	15.2707	62188.0
2013-07-17 07:37:00	AAPL	Stock	15.275	15.275	15.2518	15.2525	107380.0
2013-07-17 07:38:00	AAPL	Stock	15.2561	15.2714	15.2561	15.2679	63000.0
2013-07-17 07:39:00	AAPL	Stock	15.2668	15.2668	15.2668	15.2668	8400.0
2013-07-17 07:40:00	AAPL	Stock	15.2668	15.2668	15.2593	15.2625	15456.0
2013-07-17 07:41:00	AAPL	Stock	15.2625	15.2625	15.2625	15.2625	8400.0
2013-07-17 07:42:00	AAPL	Stock	15.2679	15.2679	15.2679	15.2679	16800.0
2013-07-17 07:46:00	AAPL	Stock	15.2861	15.2861	15.2768	15.2768	14000.0
2013-07-17 07:47:00	AAPL	Stock	15.2775	15.2775	15.275	15.275	50428.0
2013-07-17 07:48:00	AAPL	Stock	15.2789	15.2789	15.2789	15.2789	4200.0
2013-07-17 07:49:00	AAPL	Stock	15.2821	15.2821	15.2821	15.2821	3136.0
2013-07-17 07:50:00	AAPL	Stock	15.2821	15.285	15.275	15.285	24864.0
2013-07-17 07:51:00	AAPL	Stock	15.2843	15.2857	15.2843	15.2857	11200.0
2013-07-17 07:52:00	AAPL	Stock	15.2857	15.2857	15.2857	15.2857	2800.0
2013-07-17 07:53:00	AAPL	Stock	15.2857	15.2857	15.2839	15.2857	8960.0
2013-07-17 07:54:00	AAPL	Stock	15.275	15.2786	15.2704	15.2704	60144.0
2013-07-17 07:56:00	AAPL	Stock	15.2761	15.2782	15.2761	15.2782	5600.0
2013-07-17 07:57:00	AAPL	Stock	15.2786	15.2786	15.2786	15.2786	36400.0
2013-07-17 08:00:00	AAPL	Stock	15.2893	15.3036	15.2893	15.3025	39200.0
2013-07-17 08:01:00	AAPL	Stock	15.3025	15.3025	15.3025	15.3025	2800.0
2013-07-17 08:02:00	AAPL	Stock	15.3571	15.3571	15.2964	15.2964	19600.0
2013-07-17 08:03:00	AAPL	Stock	15.2971	15.2971	15.2971	15.2971	2800.0
2013-07-17 08:04:00	AAPL	Stock	15.3125	15.3125	15.3125	15.3125	2800.0
2013-07-17 08:07:00	AAPL	Stock	15.3214	15.3286	15.3196	15.3204	29120.0
2013-07-17 08:08:00	AAPL	Stock	15.3125	15.3125	15.3054	15.3054	16800.0
2013-07-17 08:10:00	AAPL	Stock	15.315	15.315	15.315	15.315	2800.0
2013-07-17 08:11:00	AAPL	Stock	15.315	15.3261	15.315	15.325	23996.0
2013-07-17 08:12:00	AAPL	Stock	15.3214	15.3214	15.3214	15.3214	26880.0
2013-07-17 08:13:00	AAPL	Stock	15.3186	15.3186	15.3136	15.3143	61040.0
2013-07-17 08:14:00	AAPL	Stock	15.3196	15.3196	15.3196	15.3196	2800.0

> showing 50 of 957,185 rows — these rows as CSV

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