PREVIEW / stock_1min / 2013-07-09

all stock 1-min files

  file:    by_date/stock_1min/2013/2013-07-09.parquet
  size:    13.8 MB
  rows:    1,021,420
  symbols: 2,849

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-09 04:00:00	AAPL	Stock	14.8564	14.8564	14.8564	14.8564	2800.0
2013-07-09 04:06:00	AAPL	Stock	14.8432	14.8432	14.8432	14.8432	3388.0
2013-07-09 04:25:00	AAPL	Stock	14.8489	14.85	14.8489	14.85	14168.0
2013-07-09 05:04:00	AAPL	Stock	14.8482	14.8482	14.8482	14.8482	2800.0
2013-07-09 06:52:00	AAPL	Stock	14.8257	14.8257	14.8257	14.8257	2800.0
2013-07-09 06:57:00	AAPL	Stock	14.8286	14.8286	14.8211	14.8211	8400.0
2013-07-09 06:58:00	AAPL	Stock	14.8211	14.8211	14.8146	14.8146	34076.0
2013-07-09 07:02:00	AAPL	Stock	14.8164	14.8164	14.8164	14.8164	2800.0
2013-07-09 07:03:00	AAPL	Stock	14.8282	14.8282	14.815	14.815	11200.0
2013-07-09 07:04:00	AAPL	Stock	14.8154	14.8154	14.8089	14.8089	10528.0
2013-07-09 07:06:00	AAPL	Stock	14.8089	14.8089	14.8089	14.8089	5600.0
2013-07-09 07:11:00	AAPL	Stock	14.8125	14.8125	14.8125	14.8125	2800.0
2013-07-09 07:14:00	AAPL	Stock	14.8143	14.8143	14.8143	14.8143	2800.0
2013-07-09 07:16:00	AAPL	Stock	14.8125	14.8125	14.8125	14.8125	6720.0
2013-07-09 07:17:00	AAPL	Stock	14.8125	14.8125	14.8125	14.8125	2800.0
2013-07-09 07:18:00	AAPL	Stock	14.8054	14.8054	14.8054	14.8054	5600.0
2013-07-09 07:20:00	AAPL	Stock	14.8071	14.8071	14.8071	14.8071	2800.0
2013-07-09 07:25:00	AAPL	Stock	14.8071	14.8071	14.8071	14.8071	2800.0
2013-07-09 07:30:00	AAPL	Stock	14.8071	14.8071	14.8071	14.8071	5600.0
2013-07-09 07:33:00	AAPL	Stock	14.8079	14.8082	14.8079	14.8082	11200.0
2013-07-09 07:34:00	AAPL	Stock	14.8082	14.8082	14.8082	14.8082	2800.0
2013-07-09 07:36:00	AAPL	Stock	14.8007	14.8007	14.8007	14.8007	2800.0
2013-07-09 07:39:00	AAPL	Stock	14.8011	14.8011	14.7986	14.7986	18424.0
2013-07-09 07:41:00	AAPL	Stock	14.7964	14.7964	14.7964	14.7964	2800.0
2013-07-09 07:46:00	AAPL	Stock	14.7929	14.7929	14.7896	14.7896	5600.0
2013-07-09 07:47:00	AAPL	Stock	14.7857	14.7857	14.7857	14.7857	5600.0
2013-07-09 07:48:00	AAPL	Stock	14.7796	14.7796	14.7796	14.7796	2800.0
2013-07-09 07:49:00	AAPL	Stock	14.7814	14.7818	14.7793	14.7793	8400.0
2013-07-09 07:55:00	AAPL	Stock	14.7914	14.7964	14.7914	14.7964	36400.0
2013-07-09 07:59:00	AAPL	Stock	14.7964	14.7964	14.7964	14.7964	14000.0
2013-07-09 08:00:00	AAPL	Stock	14.7975	14.8232	14.7818	14.8232	67536.0
2013-07-09 08:01:00	AAPL	Stock	14.8014	14.8571	14.8014	14.8118	31360.0
2013-07-09 08:02:00	AAPL	Stock	14.8071	14.8082	14.8071	14.8071	33292.0
2013-07-09 08:03:00	AAPL	Stock	14.8075	14.8075	14.8036	14.8036	11200.0
2013-07-09 08:04:00	AAPL	Stock	14.8036	14.8036	14.8	14.8	16800.0
2013-07-09 08:05:00	AAPL	Stock	14.8	14.8118	14.8	14.8118	44156.0
2013-07-09 08:06:00	AAPL	Stock	14.8	14.8	14.8	14.8	3920.0
2013-07-09 08:07:00	AAPL	Stock	14.81	14.8143	14.81	14.8143	43708.0
2013-07-09 08:13:00	AAPL	Stock	14.8125	14.8125	14.805	14.805	25200.0
2013-07-09 08:15:00	AAPL	Stock	14.8089	14.8179	14.8075	14.8179	17500.0
2013-07-09 08:17:00	AAPL	Stock	14.8089	14.8107	14.8079	14.8107	19600.0
2013-07-09 08:18:00	AAPL	Stock	14.8107	14.8107	14.8107	14.8107	5600.0
2013-07-09 08:19:00	AAPL	Stock	14.8079	14.8107	14.8079	14.8107	30800.0
2013-07-09 08:22:00	AAPL	Stock	14.8175	14.8214	14.8157	14.8214	63700.0
2013-07-09 08:23:00	AAPL	Stock	14.8229	14.8282	14.8229	14.8282	22400.0
2013-07-09 08:24:00	AAPL	Stock	14.8214	14.8214	14.81	14.81	36400.0
2013-07-09 08:25:00	AAPL	Stock	14.8111	14.8111	14.8107	14.8107	8400.0
2013-07-09 08:26:00	AAPL	Stock	14.81	14.81	14.81	14.81	2800.0
2013-07-09 08:28:00	AAPL	Stock	14.8107	14.8107	14.8107	14.8107	8400.0
2013-07-09 08:30:00	AAPL	Stock	14.8204	14.8211	14.8204	14.8211	14000.0

> showing 50 of 1,021,420 rows — these rows as CSV

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