PREVIEW / stock_1min / 2014-03-17

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-03-17.parquet
  size:    14.8 MB
  rows:    1,077,209
  symbols: 2,877

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-03-17 04:20:00	AAPL	Stock	18.795	18.7961	18.795	18.7961	14000.0
2014-03-17 05:20:00	AAPL	Stock	18.8646	18.8646	18.8646	18.8646	2800.0
2014-03-17 05:23:00	AAPL	Stock	18.8814	18.8814	18.8814	18.8814	2800.0
2014-03-17 06:09:00	AAPL	Stock	18.8482	18.8482	18.8482	18.8482	2800.0
2014-03-17 06:15:00	AAPL	Stock	18.8279	18.8279	18.8279	18.8279	2800.0
2014-03-17 06:46:00	AAPL	Stock	18.8471	18.8536	18.8471	18.8536	14000.0
2014-03-17 07:00:00	AAPL	Stock	18.8304	18.8304	18.8304	18.8304	2800.0
2014-03-17 07:04:00	AAPL	Stock	18.8393	18.8393	18.8393	18.8393	2800.0
2014-03-17 07:10:00	AAPL	Stock	18.8529	18.86	18.8482	18.86	14980.0
2014-03-17 07:11:00	AAPL	Stock	18.8696	18.8757	18.8675	18.8757	19600.0
2014-03-17 07:13:00	AAPL	Stock	18.875	18.875	18.8664	18.8664	14000.0
2014-03-17 07:18:00	AAPL	Stock	18.8714	18.8714	18.8714	18.8714	2800.0
2014-03-17 07:19:00	AAPL	Stock	18.8664	18.8664	18.8664	18.8664	14000.0
2014-03-17 07:24:00	AAPL	Stock	18.8507	18.8507	18.8507	18.8507	2800.0
2014-03-17 07:25:00	AAPL	Stock	18.8529	18.8529	18.85	18.85	21952.0
2014-03-17 07:35:00	AAPL	Stock	18.8529	18.8529	18.8529	18.8529	4564.0
2014-03-17 07:39:00	AAPL	Stock	18.8561	18.8561	18.8561	18.8561	2800.0
2014-03-17 07:43:00	AAPL	Stock	18.8482	18.8482	18.8482	18.8482	8400.0
2014-03-17 07:46:00	AAPL	Stock	18.8529	18.8529	18.8529	18.8529	14000.0
2014-03-17 07:47:00	AAPL	Stock	18.8482	18.8482	18.8482	18.8482	5600.0
2014-03-17 07:49:00	AAPL	Stock	18.8518	18.8521	18.8518	18.8521	5600.0
2014-03-17 07:55:00	AAPL	Stock	18.8511	18.8511	18.8511	18.8511	2800.0
2014-03-17 07:58:00	AAPL	Stock	18.8393	18.8393	18.8393	18.8393	2800.0
2014-03-17 08:00:00	AAPL	Stock	18.8421	18.8571	18.8329	18.8529	47460.0
2014-03-17 08:01:00	AAPL	Stock	18.8496	18.8496	18.8393	18.8393	33936.0
2014-03-17 08:02:00	AAPL	Stock	18.8493	18.8493	18.8275	18.8275	30100.0
2014-03-17 08:05:00	AAPL	Stock	18.8393	18.8446	18.8393	18.8393	19600.0
2014-03-17 08:06:00	AAPL	Stock	18.8407	18.845	18.8407	18.8429	28000.0
2014-03-17 08:07:00	AAPL	Stock	18.845	18.845	18.845	18.845	2800.0
2014-03-17 08:08:00	AAPL	Stock	18.8457	18.8529	18.8457	18.8529	69776.0
2014-03-17 08:09:00	AAPL	Stock	18.8507	18.8739	18.8507	18.8739	101920.0
2014-03-17 08:10:00	AAPL	Stock	18.86	18.86	18.86	18.86	2800.0
2014-03-17 08:11:00	AAPL	Stock	18.8714	18.8754	18.8714	18.8754	53200.0
2014-03-17 08:13:00	AAPL	Stock	18.8614	18.8818	18.8614	18.8818	5600.0
2014-03-17 08:14:00	AAPL	Stock	18.8604	18.8636	18.8582	18.8582	39200.0
2014-03-17 08:15:00	AAPL	Stock	18.8764	18.8857	18.8764	18.8857	50512.0
2014-03-17 08:16:00	AAPL	Stock	18.8821	18.8857	18.8821	18.8857	11200.0
2014-03-17 08:17:00	AAPL	Stock	18.8796	18.8839	18.875	18.8839	115668.0
2014-03-17 08:18:00	AAPL	Stock	18.88	18.8821	18.8771	18.8771	20160.0
2014-03-17 08:19:00	AAPL	Stock	18.8811	18.8811	18.8768	18.8768	20944.0
2014-03-17 08:21:00	AAPL	Stock	18.8811	18.8811	18.8811	18.8811	28000.0
2014-03-17 08:22:00	AAPL	Stock	18.8679	18.8679	18.8661	18.8661	25900.0
2014-03-17 08:23:00	AAPL	Stock	18.8743	18.875	18.8743	18.875	22400.0
2014-03-17 08:24:00	AAPL	Stock	18.8643	18.8664	18.8629	18.8632	28840.0
2014-03-17 08:25:00	AAPL	Stock	18.8739	18.875	18.8739	18.875	14224.0
2014-03-17 08:26:00	AAPL	Stock	18.8764	18.88	18.8764	18.88	8400.0
2014-03-17 08:27:00	AAPL	Stock	18.8821	18.8821	18.8821	18.8821	11200.0
2014-03-17 08:29:00	AAPL	Stock	18.8739	18.8739	18.865	18.8654	24500.0
2014-03-17 08:31:00	AAPL	Stock	18.8732	18.8732	18.8732	18.8732	2800.0
2014-03-17 08:33:00	AAPL	Stock	18.8729	18.8732	18.8654	18.8693	49000.0

> showing 50 of 1,077,209 rows — these rows as CSV

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