PREVIEW / stock_1min / 2014-07-28

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-07-28.parquet
  size:    14.0 MB
  rows:    1,039,990
  symbols: 2,899

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-07-28 04:00:00	AAPL	Stock	24.4	24.4	24.4	24.4	800.0
2014-07-28 05:08:00	AAPL	Stock	24.4525	24.4525	24.4525	24.4525	1760.0
2014-07-28 05:12:00	AAPL	Stock	24.4625	24.4625	24.4625	24.4625	2000.0
2014-07-28 05:36:00	AAPL	Stock	24.4425	24.4425	24.4425	24.4425	420.0
2014-07-28 05:41:00	AAPL	Stock	24.4425	24.4425	24.4425	24.4425	560.0
2014-07-28 05:44:00	AAPL	Stock	24.4425	24.4425	24.4425	24.4425	3548.0
2014-07-28 05:47:00	AAPL	Stock	24.4425	24.4425	24.4425	24.4425	4400.0
2014-07-28 05:51:00	AAPL	Stock	24.4425	24.4425	24.4425	24.4425	508.0
2014-07-28 06:00:00	AAPL	Stock	24.4375	24.4375	24.4375	24.4375	8000.0
2014-07-28 06:01:00	AAPL	Stock	24.435	24.435	24.435	24.435	800.0
2014-07-28 06:02:00	AAPL	Stock	24.43	24.43	24.43	24.43	1800.0
2014-07-28 06:03:00	AAPL	Stock	24.43	24.43	24.43	24.43	1248.0
2014-07-28 06:06:00	AAPL	Stock	24.43	24.43	24.4275	24.4275	4400.0
2014-07-28 06:10:00	AAPL	Stock	24.43	24.43	24.43	24.43	8000.0
2014-07-28 06:12:00	AAPL	Stock	24.43	24.43	24.43	24.43	8000.0
2014-07-28 06:15:00	AAPL	Stock	24.4225	24.4225	24.4225	24.4225	504.0
2014-07-28 06:18:00	AAPL	Stock	24.405	24.405	24.405	24.405	1200.0
2014-07-28 06:40:00	AAPL	Stock	24.4025	24.4025	24.4025	24.4025	400.0
2014-07-28 07:03:00	AAPL	Stock	24.4375	24.44	24.42	24.44	4248.0
2014-07-28 07:05:00	AAPL	Stock	24.44	24.44	24.44	24.44	2000.0
2014-07-28 07:08:00	AAPL	Stock	24.4475	24.4475	24.4475	24.4475	1600.0
2014-07-28 07:09:00	AAPL	Stock	24.4475	24.45	24.4475	24.45	1120.0
2014-07-28 07:10:00	AAPL	Stock	24.45	24.45	24.45	24.45	4000.0
2014-07-28 07:12:00	AAPL	Stock	24.4425	24.45	24.4425	24.45	5600.0
2014-07-28 07:13:00	AAPL	Stock	24.45	24.45	24.45	24.45	800.0
2014-07-28 07:14:00	AAPL	Stock	24.45	24.45	24.45	24.45	1096.0
2014-07-28 07:16:00	AAPL	Stock	24.4475	24.4475	24.4475	24.4475	800.0
2014-07-28 07:18:00	AAPL	Stock	24.4475	24.45	24.4475	24.45	6400.0
2014-07-28 07:19:00	AAPL	Stock	24.4475	24.4475	24.4375	24.4375	36400.0
2014-07-28 07:23:00	AAPL	Stock	24.4475	24.4475	24.4475	24.4475	3600.0
2014-07-28 07:25:00	AAPL	Stock	24.44	24.44	24.44	24.44	800.0
2014-07-28 07:28:00	AAPL	Stock	24.4425	24.4425	24.4425	24.4425	1000.0
2014-07-28 07:29:00	AAPL	Stock	24.4375	24.4375	24.4375	24.4375	5032.0
2014-07-28 07:34:00	AAPL	Stock	24.4425	24.4425	24.435	24.435	1912.0
2014-07-28 07:36:00	AAPL	Stock	24.4425	24.4425	24.4425	24.4425	548.0
2014-07-28 07:37:00	AAPL	Stock	24.435	24.45	24.435	24.45	4000.0
2014-07-28 07:38:00	AAPL	Stock	24.45	24.45	24.45	24.45	2000.0
2014-07-28 07:39:00	AAPL	Stock	24.45	24.45	24.45	24.45	1600.0
2014-07-28 07:40:00	AAPL	Stock	24.45	24.45	24.45	24.45	400.0
2014-07-28 07:41:00	AAPL	Stock	24.45	24.45	24.445	24.445	800.0
2014-07-28 07:43:00	AAPL	Stock	24.445	24.445	24.4425	24.4425	4400.0
2014-07-28 07:45:00	AAPL	Stock	24.4375	24.4375	24.4375	24.4375	4000.0
2014-07-28 07:46:00	AAPL	Stock	24.4275	24.4275	24.4275	24.4275	2400.0
2014-07-28 07:47:00	AAPL	Stock	24.4275	24.4275	24.4275	24.4275	1600.0
2014-07-28 07:48:00	AAPL	Stock	24.4275	24.4275	24.4275	24.4275	400.0
2014-07-28 07:49:00	AAPL	Stock	24.425	24.425	24.425	24.425	400.0
2014-07-28 07:50:00	AAPL	Stock	24.425	24.425	24.4225	24.4225	4000.0
2014-07-28 07:51:00	AAPL	Stock	24.42	24.42	24.42	24.42	3668.0
2014-07-28 07:53:00	AAPL	Stock	24.425	24.425	24.425	24.425	400.0
2014-07-28 07:55:00	AAPL	Stock	24.425	24.425	24.425	24.425	400.0

> showing 50 of 1,039,990 rows — these rows as CSV

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