PREVIEW / stock_1min / 2013-01-24

all stock 1-min files

  file:    by_date/stock_1min/2013/2013-01-24.parquet
  size:    13.3 MB
  rows:    973,221
  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-01-24 04:00:00	AAPL	Stock	16.5714	16.7768	16.5714	16.6464	47068.0
2013-01-24 04:01:00	AAPL	Stock	16.7661	16.7661	16.75	16.75	28000.0
2013-01-24 04:02:00	AAPL	Stock	16.75	16.7764	16.7143	16.7143	101360.0
2013-01-24 04:03:00	AAPL	Stock	16.7086	16.7086	16.705	16.705	42000.0
2013-01-24 04:04:00	AAPL	Stock	16.7139	16.7179	16.7139	16.7179	5600.0
2013-01-24 04:05:00	AAPL	Stock	16.7057	16.7143	16.7029	16.7029	39200.0
2013-01-24 04:06:00	AAPL	Stock	16.6964	16.6964	16.6964	16.6964	18872.0
2013-01-24 04:07:00	AAPL	Stock	16.7054	16.7054	16.7054	16.7054	5600.0
2013-01-24 04:08:00	AAPL	Stock	16.6964	16.6964	16.6911	16.6911	48944.0
2013-01-24 04:09:00	AAPL	Stock	16.6893	16.6893	16.6832	16.6857	61600.0
2013-01-24 04:10:00	AAPL	Stock	16.6821	16.6854	16.6821	16.6829	33600.0
2013-01-24 04:11:00	AAPL	Stock	16.6846	16.6846	16.6846	16.6846	2800.0
2013-01-24 04:12:00	AAPL	Stock	16.6864	16.6864	16.6864	16.6864	19600.0
2013-01-24 04:13:00	AAPL	Stock	16.6864	16.7143	16.6864	16.7143	65940.0
2013-01-24 04:14:00	AAPL	Stock	16.7143	16.7143	16.7143	16.7143	14112.0
2013-01-24 04:15:00	AAPL	Stock	16.7482	16.7482	16.7464	16.7464	19040.0
2013-01-24 04:16:00	AAPL	Stock	16.7464	16.7464	16.7464	16.7464	33600.0
2013-01-24 04:17:00	AAPL	Stock	16.7493	16.75	16.7493	16.7496	26600.0
2013-01-24 04:18:00	AAPL	Stock	16.7496	16.7679	16.7446	16.7679	53200.0
2013-01-24 04:19:00	AAPL	Stock	16.7679	16.7679	16.7679	16.7679	42000.0
2013-01-24 04:20:00	AAPL	Stock	16.7679	16.7686	16.7679	16.7679	131600.0
2013-01-24 04:22:00	AAPL	Stock	16.7679	16.7679	16.7679	16.7679	24920.0
2013-01-24 04:23:00	AAPL	Stock	16.7679	16.7679	16.7618	16.7618	98280.0
2013-01-24 04:24:00	AAPL	Stock	16.75	16.75	16.75	16.75	2800.0
2013-01-24 04:25:00	AAPL	Stock	16.7554	16.7554	16.7529	16.755	14000.0
2013-01-24 04:26:00	AAPL	Stock	16.7554	16.7664	16.7475	16.7664	24360.0
2013-01-24 04:28:00	AAPL	Stock	16.7543	16.7543	16.7536	16.7536	5600.0
2013-01-24 04:29:00	AAPL	Stock	16.7729	16.7857	16.7729	16.7857	58800.0
2013-01-24 04:30:00	AAPL	Stock	16.7857	16.7864	16.7857	16.7857	22708.0
2013-01-24 04:31:00	AAPL	Stock	16.7857	16.7857	16.75	16.75	60900.0
2013-01-24 04:32:00	AAPL	Stock	16.76	16.7604	16.75	16.75	22400.0
2013-01-24 04:33:00	AAPL	Stock	16.7539	16.7604	16.7475	16.75	74900.0
2013-01-24 04:34:00	AAPL	Stock	16.7496	16.75	16.7493	16.7493	39200.0
2013-01-24 04:35:00	AAPL	Stock	16.7539	16.7539	16.75	16.75	25200.0
2013-01-24 04:36:00	AAPL	Stock	16.75	16.75	16.75	16.75	16940.0
2013-01-24 04:38:00	AAPL	Stock	16.75	16.75	16.75	16.75	5600.0
2013-01-24 04:40:00	AAPL	Stock	16.75	16.75	16.75	16.75	8400.0
2013-01-24 04:41:00	AAPL	Stock	16.7479	16.7479	16.7479	16.7479	2800.0
2013-01-24 04:42:00	AAPL	Stock	16.7604	16.7604	16.7604	16.7604	2800.0
2013-01-24 04:43:00	AAPL	Stock	16.7507	16.7857	16.7507	16.7857	79240.0
2013-01-24 04:44:00	AAPL	Stock	16.7779	16.7779	16.7779	16.7779	2800.0
2013-01-24 04:45:00	AAPL	Stock	16.7854	16.7857	16.7736	16.7736	32900.0
2013-01-24 04:46:00	AAPL	Stock	16.7854	16.7857	16.7786	16.7789	127624.0
2013-01-24 04:47:00	AAPL	Stock	16.805	16.805	16.805	16.805	11200.0
2013-01-24 04:48:00	AAPL	Stock	16.8214	16.8214	16.8036	16.8036	44296.0
2013-01-24 04:49:00	AAPL	Stock	16.8225	16.8225	16.8036	16.8036	19600.0
2013-01-24 04:50:00	AAPL	Stock	16.8036	16.8036	16.8036	16.8036	9128.0
2013-01-24 04:52:00	AAPL	Stock	16.81	16.81	16.81	16.81	2800.0
2013-01-24 04:53:00	AAPL	Stock	16.8182	16.8182	16.8161	16.8161	5600.0
2013-01-24 04:57:00	AAPL	Stock	16.8214	16.8357	16.8214	16.8357	56000.0

> showing 50 of 973,221 rows — these rows as CSV

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