PREVIEW / stock_1min / 2014-04-17

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-04-17.parquet
  size:    13.9 MB
  rows:    1,028,046
  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-04-17 04:54:00	AAPL	Stock	18.4575	18.4575	18.4575	18.4575	5600.0
2014-04-17 07:02:00	AAPL	Stock	18.4571	18.4571	18.4571	18.4571	3024.0
2014-04-17 07:32:00	AAPL	Stock	18.4861	18.4861	18.4861	18.4861	2800.0
2014-04-17 07:33:00	AAPL	Stock	18.4864	18.4864	18.4864	18.4864	2800.0
2014-04-17 07:40:00	AAPL	Stock	18.4996	18.4996	18.4996	18.4996	2800.0
2014-04-17 07:44:00	AAPL	Stock	18.5157	18.5214	18.5154	18.5214	28000.0
2014-04-17 07:58:00	AAPL	Stock	18.515	18.5161	18.515	18.5161	33600.0
2014-04-17 07:59:00	AAPL	Stock	18.5179	18.5218	18.5179	18.5218	5600.0
2014-04-17 08:00:00	AAPL	Stock	18.4571	18.5196	18.4571	18.5196	25200.0
2014-04-17 08:01:00	AAPL	Stock	18.5125	18.5196	18.5125	18.5196	22400.0
2014-04-17 08:03:00	AAPL	Stock	18.5243	18.5264	18.5089	18.5089	19600.0
2014-04-17 08:04:00	AAPL	Stock	18.5114	18.5214	18.5114	18.5214	33600.0
2014-04-17 08:06:00	AAPL	Stock	18.5268	18.5268	18.5268	18.5268	2800.0
2014-04-17 08:10:00	AAPL	Stock	18.5182	18.5182	18.5182	18.5182	5600.0
2014-04-17 08:11:00	AAPL	Stock	18.5182	18.5429	18.5182	18.5429	22400.0
2014-04-17 08:12:00	AAPL	Stock	18.5643	18.5643	18.5554	18.5625	54936.0
2014-04-17 08:16:00	AAPL	Stock	18.5446	18.5536	18.5446	18.5536	11200.0
2014-04-17 08:17:00	AAPL	Stock	18.5604	18.6064	18.5604	18.5714	182756.0
2014-04-17 08:18:00	AAPL	Stock	18.5704	18.5882	18.5554	18.5554	25200.0
2014-04-17 08:19:00	AAPL	Stock	18.5536	18.5736	18.5536	18.5736	9800.0
2014-04-17 08:21:00	AAPL	Stock	18.5786	18.5786	18.5557	18.5714	15120.0
2014-04-17 08:22:00	AAPL	Stock	18.5739	18.5739	18.5739	18.5739	2800.0
2014-04-17 08:23:00	AAPL	Stock	18.5839	18.5857	18.5839	18.5857	13580.0
2014-04-17 08:24:00	AAPL	Stock	18.5929	18.5964	18.5929	18.5964	8400.0
2014-04-17 08:25:00	AAPL	Stock	18.5896	18.5896	18.5896	18.5896	2800.0
2014-04-17 08:27:00	AAPL	Stock	18.5982	18.6089	18.5961	18.6071	67144.0
2014-04-17 08:30:00	AAPL	Stock	18.6071	18.6089	18.6071	18.6089	5656.0
2014-04-17 08:32:00	AAPL	Stock	18.6089	18.6429	18.6089	18.6404	80220.0
2014-04-17 08:33:00	AAPL	Stock	18.6264	18.6275	18.6239	18.6239	114688.0
2014-04-17 08:35:00	AAPL	Stock	18.6114	18.6114	18.6104	18.6104	19600.0
2014-04-17 08:36:00	AAPL	Stock	18.6107	18.6121	18.6071	18.6071	33600.0
2014-04-17 08:38:00	AAPL	Stock	18.6139	18.6154	18.6039	18.6071	58464.0
2014-04-17 08:39:00	AAPL	Stock	18.6043	18.6054	18.6039	18.6039	30800.0
2014-04-17 08:41:00	AAPL	Stock	18.6032	18.6089	18.6032	18.6071	23520.0
2014-04-17 08:42:00	AAPL	Stock	18.6032	18.6032	18.5979	18.5979	8400.0
2014-04-17 08:43:00	AAPL	Stock	18.6057	18.6064	18.6057	18.6064	5600.0
2014-04-17 08:45:00	AAPL	Stock	18.6054	18.6054	18.6036	18.6054	8400.0
2014-04-17 08:46:00	AAPL	Stock	18.6004	18.6004	18.6004	18.6004	2800.0
2014-04-17 08:47:00	AAPL	Stock	18.6071	18.6121	18.6071	18.6121	19320.0
2014-04-17 08:49:00	AAPL	Stock	18.6057	18.615	18.6057	18.615	16800.0
2014-04-17 08:50:00	AAPL	Stock	18.615	18.6211	18.615	18.6168	20160.0
2014-04-17 08:52:00	AAPL	Stock	18.6196	18.6196	18.6196	18.6196	8400.0
2014-04-17 08:54:00	AAPL	Stock	18.6211	18.6214	18.6196	18.6196	8400.0
2014-04-17 08:55:00	AAPL	Stock	18.6204	18.6204	18.6189	18.6189	5600.0
2014-04-17 08:56:00	AAPL	Stock	18.6164	18.6164	18.6164	18.6164	2800.0
2014-04-17 08:57:00	AAPL	Stock	18.6232	18.625	18.6232	18.6232	51268.0
2014-04-17 08:59:00	AAPL	Stock	18.6271	18.6271	18.6271	18.6271	2800.0
2014-04-17 09:00:00	AAPL	Stock	18.6286	18.6286	18.6286	18.6286	5600.0
2014-04-17 09:01:00	AAPL	Stock	18.6332	18.6339	18.6332	18.6339	8400.0
2014-04-17 09:02:00	AAPL	Stock	18.6357	18.6393	18.6357	18.6393	14000.0

> showing 50 of 1,028,046 rows — these rows as CSV

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