PREVIEW / stock_1min / 2013-07-29

all stock 1-min files

  file:    by_date/stock_1min/2013/2013-07-29.parquet
  size:    13.0 MB
  rows:    949,027
  symbols: 2,845

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-29 04:00:00	AAPL	Stock	15.7661	15.7661	15.75	15.75	11200.0
2013-07-29 05:45:00	AAPL	Stock	15.7571	15.7571	15.7571	15.7571	2800.0
2013-07-29 06:52:00	AAPL	Stock	15.75	15.75	15.75	15.75	2800.0
2013-07-29 07:06:00	AAPL	Stock	15.7571	15.7571	15.7464	15.7464	14000.0
2013-07-29 07:08:00	AAPL	Stock	15.7468	15.7468	15.7468	15.7468	5600.0
2013-07-29 07:19:00	AAPL	Stock	15.7457	15.7582	15.7457	15.7582	27160.0
2013-07-29 07:21:00	AAPL	Stock	15.7679	15.7679	15.7679	15.7679	5600.0
2013-07-29 07:38:00	AAPL	Stock	15.7321	15.7321	15.7279	15.7279	11200.0
2013-07-29 07:41:00	AAPL	Stock	15.7321	15.7321	15.7136	15.7143	39200.0
2013-07-29 07:42:00	AAPL	Stock	15.7143	15.7143	15.7143	15.7143	2800.0
2013-07-29 07:43:00	AAPL	Stock	15.7143	15.7143	15.7143	15.7143	16800.0
2013-07-29 07:45:00	AAPL	Stock	15.7143	15.7143	15.7143	15.7143	8484.0
2013-07-29 07:59:00	AAPL	Stock	15.7289	15.7289	15.7289	15.7289	2800.0
2013-07-29 08:00:00	AAPL	Stock	15.7429	15.7843	15.7321	15.7321	48524.0
2013-07-29 08:01:00	AAPL	Stock	15.7343	15.7343	15.7321	15.7321	8484.0
2013-07-29 08:02:00	AAPL	Stock	15.7286	15.7286	15.7286	15.7286	2800.0
2013-07-29 08:03:00	AAPL	Stock	15.7143	15.7143	15.7143	15.7143	14000.0
2013-07-29 08:07:00	AAPL	Stock	15.7232	15.7261	15.7232	15.7261	11200.0
2013-07-29 08:13:00	AAPL	Stock	15.7239	15.7239	15.7239	15.7239	5040.0
2013-07-29 08:16:00	AAPL	Stock	15.7321	15.7321	15.7321	15.7321	2800.0
2013-07-29 08:17:00	AAPL	Stock	15.7232	15.7232	15.7232	15.7232	2800.0
2013-07-29 08:20:00	AAPL	Stock	15.7232	15.7232	15.7179	15.7196	16800.0
2013-07-29 08:21:00	AAPL	Stock	15.7257	15.7411	15.7257	15.7411	14000.0
2013-07-29 08:22:00	AAPL	Stock	15.7421	15.7425	15.7421	15.7425	8400.0
2013-07-29 08:23:00	AAPL	Stock	15.7429	15.7429	15.7429	15.7429	14000.0
2013-07-29 08:31:00	AAPL	Stock	15.7443	15.7443	15.7443	15.7443	2800.0
2013-07-29 08:33:00	AAPL	Stock	15.7364	15.7364	15.7364	15.7364	22400.0
2013-07-29 08:34:00	AAPL	Stock	15.7364	15.7364	15.7364	15.7364	2800.0
2013-07-29 08:38:00	AAPL	Stock	15.7425	15.7425	15.7425	15.7425	2800.0
2013-07-29 08:39:00	AAPL	Stock	15.7425	15.7429	15.7418	15.7429	25200.0
2013-07-29 08:41:00	AAPL	Stock	15.7386	15.7411	15.7325	15.7325	36400.0
2013-07-29 08:46:00	AAPL	Stock	15.7321	15.7321	15.7321	15.7321	5600.0
2013-07-29 08:49:00	AAPL	Stock	15.7254	15.7286	15.7232	15.7286	13440.0
2013-07-29 08:50:00	AAPL	Stock	15.7254	15.7254	15.7179	15.7179	42476.0
2013-07-29 08:54:00	AAPL	Stock	15.725	15.725	15.725	15.725	2800.0
2013-07-29 08:55:00	AAPL	Stock	15.7254	15.7282	15.7254	15.7268	19600.0
2013-07-29 08:59:00	AAPL	Stock	15.7268	15.7268	15.7268	15.7268	12572.0
2013-07-29 09:00:00	AAPL	Stock	15.7221	15.7232	15.7218	15.7229	53200.0
2013-07-29 09:01:00	AAPL	Stock	15.7221	15.7232	15.7221	15.7232	6720.0
2013-07-29 09:02:00	AAPL	Stock	15.7175	15.7175	15.7175	15.7175	8400.0
2013-07-29 09:04:00	AAPL	Stock	15.7171	15.7171	15.7171	15.7171	4200.0
2013-07-29 09:05:00	AAPL	Stock	15.725	15.7279	15.725	15.7279	11172.0
2013-07-29 09:06:00	AAPL	Stock	15.725	15.725	15.725	15.725	81312.0
2013-07-29 09:07:00	AAPL	Stock	15.7175	15.7175	15.7175	15.7175	2800.0
2013-07-29 09:09:00	AAPL	Stock	15.7239	15.7239	15.7239	15.7239	2800.0
2013-07-29 09:12:00	AAPL	Stock	15.7186	15.7186	15.7168	15.7168	12964.0
2013-07-29 09:13:00	AAPL	Stock	15.7168	15.7175	15.7168	15.7175	7000.0
2013-07-29 09:14:00	AAPL	Stock	15.7175	15.7175	15.7175	15.7175	2800.0
2013-07-29 09:18:00	AAPL	Stock	15.7179	15.7179	15.7179	15.7179	2800.0
2013-07-29 09:20:00	AAPL	Stock	15.7229	15.7275	15.7229	15.7275	8400.0

> showing 50 of 949,027 rows — these rows as CSV

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