PREVIEW / stock_1min / 2014-04-09

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-04-09.parquet
  size:    14.3 MB
  rows:    1,056,211
  symbols: 2,868

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-09 04:28:00	AAPL	Stock	18.7493	18.7493	18.7493	18.7493	2800.0
2014-04-09 07:23:00	AAPL	Stock	18.7736	18.7736	18.7736	18.7736	3836.0
2014-04-09 08:00:00	AAPL	Stock	18.7661	18.7675	18.755	18.755	40488.0
2014-04-09 08:01:00	AAPL	Stock	18.745	18.7507	18.745	18.75	44100.0
2014-04-09 08:02:00	AAPL	Stock	18.7643	18.7643	18.75	18.75	21000.0
2014-04-09 08:03:00	AAPL	Stock	18.7504	18.7646	18.75	18.7504	28000.0
2014-04-09 08:05:00	AAPL	Stock	18.7486	18.75	18.7486	18.75	11200.0
2014-04-09 08:07:00	AAPL	Stock	18.75	18.75	18.75	18.75	2800.0
2014-04-09 08:09:00	AAPL	Stock	18.7543	18.7543	18.7543	18.7543	3808.0
2014-04-09 08:11:00	AAPL	Stock	18.7604	18.7604	18.75	18.7571	11536.0
2014-04-09 08:13:00	AAPL	Stock	18.7618	18.7618	18.7557	18.7557	5600.0
2014-04-09 08:14:00	AAPL	Stock	18.75	18.75	18.75	18.75	2800.0
2014-04-09 08:29:00	AAPL	Stock	18.7521	18.7546	18.75	18.7525	16800.0
2014-04-09 08:30:00	AAPL	Stock	18.7439	18.7439	18.7414	18.7418	39200.0
2014-04-09 08:31:00	AAPL	Stock	18.7393	18.7393	18.7393	18.7393	5600.0
2014-04-09 08:32:00	AAPL	Stock	18.7404	18.7404	18.7404	18.7404	2800.0
2014-04-09 08:33:00	AAPL	Stock	18.7396	18.7396	18.7375	18.7375	5600.0
2014-04-09 08:34:00	AAPL	Stock	18.7361	18.7361	18.7321	18.7321	5600.0
2014-04-09 08:35:00	AAPL	Stock	18.7286	18.7321	18.7257	18.7321	11200.0
2014-04-09 08:37:00	AAPL	Stock	18.73	18.7339	18.73	18.7339	29400.0
2014-04-09 08:38:00	AAPL	Stock	18.7368	18.7386	18.7325	18.7325	27244.0
2014-04-09 08:40:00	AAPL	Stock	18.7461	18.7461	18.7457	18.7461	26600.0
2014-04-09 08:43:00	AAPL	Stock	18.7339	18.7339	18.7329	18.7332	11200.0
2014-04-09 08:45:00	AAPL	Stock	18.7239	18.7239	18.7218	18.7218	8400.0
2014-04-09 08:46:00	AAPL	Stock	18.7279	18.7279	18.7279	18.7279	2800.0
2014-04-09 08:47:00	AAPL	Stock	18.7271	18.7271	18.7271	18.7271	2800.0
2014-04-09 08:49:00	AAPL	Stock	18.7343	18.7354	18.7286	18.7354	123620.0
2014-04-09 08:50:00	AAPL	Stock	18.7321	18.7321	18.7321	18.7321	2800.0
2014-04-09 08:51:00	AAPL	Stock	18.7318	18.7318	18.7318	18.7318	2800.0
2014-04-09 08:52:00	AAPL	Stock	18.7279	18.7279	18.7271	18.7271	7980.0
2014-04-09 08:53:00	AAPL	Stock	18.7214	18.7214	18.7146	18.7146	19600.0
2014-04-09 08:54:00	AAPL	Stock	18.7154	18.7154	18.7154	18.7154	2800.0
2014-04-09 08:56:00	AAPL	Stock	18.715	18.715	18.7143	18.7143	19376.0
2014-04-09 08:57:00	AAPL	Stock	18.7139	18.715	18.7139	18.715	33600.0
2014-04-09 09:00:00	AAPL	Stock	18.7196	18.73	18.7196	18.73	29960.0
2014-04-09 09:01:00	AAPL	Stock	18.7257	18.7257	18.7236	18.7236	16800.0
2014-04-09 09:03:00	AAPL	Stock	18.725	18.725	18.7111	18.7111	16800.0
2014-04-09 09:04:00	AAPL	Stock	18.7114	18.7114	18.7007	18.7061	11200.0
2014-04-09 09:05:00	AAPL	Stock	18.7071	18.7071	18.7071	18.7071	2800.0
2014-04-09 09:06:00	AAPL	Stock	18.7036	18.7036	18.7036	18.7036	5600.0
2014-04-09 09:07:00	AAPL	Stock	18.7075	18.7086	18.7068	18.7086	33600.0
2014-04-09 09:08:00	AAPL	Stock	18.7086	18.7086	18.6796	18.6964	43260.0
2014-04-09 09:09:00	AAPL	Stock	18.6804	18.6804	18.6771	18.68	36400.0
2014-04-09 09:10:00	AAPL	Stock	18.6804	18.6843	18.6796	18.6804	38500.0
2014-04-09 09:11:00	AAPL	Stock	18.6811	18.6811	18.6811	18.6811	2800.0
2014-04-09 09:14:00	AAPL	Stock	18.6971	18.6979	18.6971	18.6979	5600.0
2014-04-09 09:15:00	AAPL	Stock	18.6986	18.6986	18.6979	18.6979	21980.0
2014-04-09 09:16:00	AAPL	Stock	18.6914	18.6914	18.6914	18.6914	2800.0
2014-04-09 09:18:00	AAPL	Stock	18.6939	18.6964	18.6929	18.6964	56700.0
2014-04-09 09:19:00	AAPL	Stock	18.6918	18.6918	18.6918	18.6918	2800.0

> showing 50 of 1,056,211 rows — these rows as CSV

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