PREVIEW / stock_1min / 2013-07-01

all stock 1-min files

  file:    by_date/stock_1min/2013/2013-07-01.parquet
  size:    14.2 MB
  rows:    1,056,232
  symbols: 2,834

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-01 04:00:00	AAPL	Stock	14.2311	14.2543	14.2311	14.2543	8400.0
2013-07-01 04:02:00	AAPL	Stock	14.2321	14.2321	14.2321	14.2321	2800.0
2013-07-01 04:08:00	AAPL	Stock	14.2393	14.2393	14.2393	14.2393	11200.0
2013-07-01 04:13:00	AAPL	Stock	14.2193	14.2193	14.2193	14.2193	5600.0
2013-07-01 05:21:00	AAPL	Stock	14.2143	14.2143	14.2107	14.2107	8400.0
2013-07-01 05:33:00	AAPL	Stock	14.2393	14.2393	14.2393	14.2393	2800.0
2013-07-01 05:34:00	AAPL	Stock	14.2393	14.2393	14.2393	14.2393	9408.0
2013-07-01 05:35:00	AAPL	Stock	14.2375	14.2375	14.2375	14.2375	2800.0
2013-07-01 05:38:00	AAPL	Stock	14.2411	14.2411	14.2411	14.2411	2800.0
2013-07-01 05:39:00	AAPL	Stock	14.2482	14.2482	14.2482	14.2482	10192.0
2013-07-01 05:48:00	AAPL	Stock	14.2361	14.2361	14.2361	14.2361	14000.0
2013-07-01 05:51:00	AAPL	Stock	14.2321	14.2321	14.2321	14.2321	26880.0
2013-07-01 06:21:00	AAPL	Stock	14.2321	14.2321	14.2321	14.2321	8400.0
2013-07-01 06:39:00	AAPL	Stock	14.2411	14.2411	14.2411	14.2411	15400.0
2013-07-01 06:40:00	AAPL	Stock	14.2482	14.2482	14.2482	14.2482	2800.0
2013-07-01 06:41:00	AAPL	Stock	14.2482	14.2482	14.2411	14.2411	16492.0
2013-07-01 06:54:00	AAPL	Stock	14.2411	14.25	14.2411	14.25	24332.0
2013-07-01 06:55:00	AAPL	Stock	14.2543	14.2607	14.2543	14.2607	35532.0
2013-07-01 06:56:00	AAPL	Stock	14.275	14.2771	14.275	14.2771	12012.0
2013-07-01 06:59:00	AAPL	Stock	14.2857	14.2857	14.2857	14.2857	19600.0
2013-07-01 07:00:00	AAPL	Stock	14.2854	14.2964	14.2821	14.2821	28000.0
2013-07-01 07:01:00	AAPL	Stock	14.2768	14.2857	14.2768	14.2857	28000.0
2013-07-01 07:02:00	AAPL	Stock	14.2857	14.2993	14.2857	14.2993	56000.0
2013-07-01 07:03:00	AAPL	Stock	14.2982	14.3179	14.2982	14.3179	45444.0
2013-07-01 07:04:00	AAPL	Stock	14.3296	14.3304	14.3207	14.3214	22400.0
2013-07-01 07:05:00	AAPL	Stock	14.3214	14.3332	14.3214	14.3321	56000.0
2013-07-01 07:06:00	AAPL	Stock	14.325	14.3379	14.3239	14.3379	42000.0
2013-07-01 07:07:00	AAPL	Stock	14.3389	14.34	14.3364	14.3396	103432.0
2013-07-01 07:08:00	AAPL	Stock	14.3411	14.3529	14.3282	14.3286	58800.0
2013-07-01 07:09:00	AAPL	Stock	14.3304	14.3304	14.3286	14.3286	11200.0
2013-07-01 07:10:00	AAPL	Stock	14.3286	14.3396	14.3286	14.3393	92400.0
2013-07-01 07:11:00	AAPL	Stock	14.3393	14.3571	14.3393	14.3571	69384.0
2013-07-01 07:12:00	AAPL	Stock	14.3575	14.375	14.3575	14.3746	42952.0
2013-07-01 07:13:00	AAPL	Stock	14.3568	14.3568	14.3568	14.3568	2800.0
2013-07-01 07:16:00	AAPL	Stock	14.345	14.345	14.345	14.345	8400.0
2013-07-01 07:17:00	AAPL	Stock	14.355	14.3564	14.3518	14.3518	19600.0
2013-07-01 07:18:00	AAPL	Stock	14.3482	14.3482	14.345	14.345	26880.0
2013-07-01 07:21:00	AAPL	Stock	14.3514	14.3518	14.3514	14.3518	8400.0
2013-07-01 07:22:00	AAPL	Stock	14.35	14.35	14.35	14.35	5600.0
2013-07-01 07:23:00	AAPL	Stock	14.3454	14.3493	14.3446	14.3446	8400.0
2013-07-01 07:24:00	AAPL	Stock	14.3411	14.3411	14.3304	14.3386	51044.0
2013-07-01 07:25:00	AAPL	Stock	14.3307	14.3307	14.3254	14.3254	16800.0
2013-07-01 07:26:00	AAPL	Stock	14.3336	14.3336	14.3336	14.3336	2800.0
2013-07-01 07:27:00	AAPL	Stock	14.3268	14.3268	14.3214	14.3214	130956.0
2013-07-01 07:28:00	AAPL	Stock	14.3225	14.3232	14.3214	14.3214	30156.0
2013-07-01 07:29:00	AAPL	Stock	14.3339	14.3357	14.3339	14.3339	33600.0
2013-07-01 07:30:00	AAPL	Stock	14.335	14.3396	14.335	14.3379	28000.0
2013-07-01 07:31:00	AAPL	Stock	14.3482	14.3643	14.3482	14.3643	54208.0
2013-07-01 07:32:00	AAPL	Stock	14.3571	14.3721	14.3571	14.3721	29400.0
2013-07-01 07:34:00	AAPL	Stock	14.3661	14.3661	14.3571	14.3571	28000.0

> showing 50 of 1,056,232 rows — these rows as CSV

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