PREVIEW / stock_5min / 2014-10-27

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-10-27.parquet
  size:    5.3 MB
  rows:    349,525
  symbols: 3,540

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-10-27 04:00:00	AAPL	Stock	26.315	26.4	26.315	26.4	9600.0
2014-10-27 04:10:00	AAPL	Stock	26.4	26.4	26.3975	26.3975	800.0
2014-10-27 04:25:00	AAPL	Stock	26.3975	26.3975	26.3975	26.3975	400.0
2014-10-27 04:30:00	AAPL	Stock	26.34	26.34	26.34	26.34	1200.0
2014-10-27 04:35:00	AAPL	Stock	26.3375	26.3975	26.3175	26.3175	4000.0
2014-10-27 04:55:00	AAPL	Stock	26.315	26.3375	26.3125	26.3375	2800.0
2014-10-27 05:00:00	AAPL	Stock	26.3025	26.3025	26.3	26.3	2000.0
2014-10-27 05:05:00	AAPL	Stock	26.2975	26.325	26.2975	26.325	2000.0
2014-10-27 05:20:00	AAPL	Stock	26.3025	26.3025	26.3	26.3	2000.0
2014-10-27 05:25:00	AAPL	Stock	26.3	26.3125	26.3	26.3125	3600.0
2014-10-27 05:45:00	AAPL	Stock	26.275	26.275	26.275	26.275	800.0
2014-10-27 05:50:00	AAPL	Stock	26.2525	26.2525	26.2525	26.2525	400.0
2014-10-27 06:00:00	AAPL	Stock	26.2625	26.2725	26.25	26.26	6228.0
2014-10-27 06:05:00	AAPL	Stock	26.2525	26.2525	26.2525	26.2525	400.0
2014-10-27 06:10:00	AAPL	Stock	26.26	26.26	26.26	26.26	800.0
2014-10-27 06:15:00	AAPL	Stock	26.25	26.25	26.25	26.25	2800.0
2014-10-27 06:20:00	AAPL	Stock	26.225	26.25	26.225	26.25	5120.0
2014-10-27 06:25:00	AAPL	Stock	26.2475	26.25	26.2475	26.25	10000.0
2014-10-27 06:30:00	AAPL	Stock	26.23	26.23	26.2275	26.2275	1596.0
2014-10-27 06:35:00	AAPL	Stock	26.23	26.23	26.225	26.225	3676.0
2014-10-27 06:45:00	AAPL	Stock	26.22	26.2375	26.215	26.2375	10844.0
2014-10-27 07:00:00	AAPL	Stock	26.2375	26.2425	26.2375	26.2425	4808.0
2014-10-27 07:05:00	AAPL	Stock	26.25	26.2625	26.25	26.2625	12820.0
2014-10-27 07:10:00	AAPL	Stock	26.2675	26.2675	26.2675	26.2675	2000.0
2014-10-27 07:15:00	AAPL	Stock	26.2625	26.265	26.2575	26.26	9812.0
2014-10-27 07:20:00	AAPL	Stock	26.2525	26.2525	26.2425	26.2425	9608.0
2014-10-27 07:25:00	AAPL	Stock	26.25	26.25	26.2375	26.245	8292.0
2014-10-27 07:30:00	AAPL	Stock	26.245	26.245	26.2025	26.215	34376.0
2014-10-27 07:35:00	AAPL	Stock	26.215	26.2225	26.2125	26.215	4000.0
2014-10-27 07:40:00	AAPL	Stock	26.215	26.215	26.2025	26.2125	8368.0
2014-10-27 07:45:00	AAPL	Stock	26.22	26.225	26.195	26.195	34428.0
2014-10-27 07:50:00	AAPL	Stock	26.2075	26.22	26.2075	26.2125	13540.0
2014-10-27 07:55:00	AAPL	Stock	26.2125	26.2125	26.2125	26.2125	7896.0
2014-10-27 08:00:00	AAPL	Stock	26.215	26.305	26.2	26.23	129836.0
2014-10-27 08:05:00	AAPL	Stock	26.225	26.26	26.225	26.2575	65228.0
2014-10-27 08:10:00	AAPL	Stock	26.2575	26.2725	26.2525	26.2675	56120.0
2014-10-27 08:15:00	AAPL	Stock	26.2675	26.2725	26.2625	26.2625	41412.0
2014-10-27 08:20:00	AAPL	Stock	26.255	26.255	26.24	26.24	19944.0
2014-10-27 08:25:00	AAPL	Stock	26.25	26.25	26.235	26.25	45456.0
2014-10-27 08:30:00	AAPL	Stock	26.245	26.25	26.2175	26.2175	94340.0
2014-10-27 08:35:00	AAPL	Stock	26.225	26.225	26.2	26.2	50600.0
2014-10-27 08:40:00	AAPL	Stock	26.2	26.2075	26.19	26.19	69328.0
2014-10-27 08:45:00	AAPL	Stock	26.2	26.2375	26.19	26.2375	68900.0
2014-10-27 08:50:00	AAPL	Stock	26.2225	26.2275	26.2125	26.2275	99220.0
2014-10-27 08:55:00	AAPL	Stock	26.225	26.245	26.2175	26.2375	111892.0
2014-10-27 09:00:00	AAPL	Stock	26.2375	26.2475	26.2275	26.2325	115380.0
2014-10-27 09:05:00	AAPL	Stock	26.2325	26.24	26.195	26.2025	139456.0
2014-10-27 09:10:00	AAPL	Stock	26.2075	26.2075	26.2	26.2	18724.0
2014-10-27 09:15:00	AAPL	Stock	26.205	26.205	26.165	26.18	144704.0
2014-10-27 09:20:00	AAPL	Stock	26.1775	26.2275	26.17	26.2275	107044.0

> showing 50 of 349,525 rows — these rows as CSV

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