PREVIEW / stock_5min / 2014-07-07

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-07-07.parquet
  size:    5.4 MB
  rows:    365,481
  symbols: 3,594

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-07 04:00:00	AAPL	Stock	23.5125	23.5125	23.5125	23.5125	400.0
2014-07-07 04:25:00	AAPL	Stock	23.515	23.515	23.515	23.515	6300.0
2014-07-07 04:40:00	AAPL	Stock	23.5125	23.5125	23.5125	23.5125	400.0
2014-07-07 04:55:00	AAPL	Stock	23.5075	23.5075	23.5025	23.5025	1200.0
2014-07-07 05:00:00	AAPL	Stock	23.4975	23.4975	23.4975	23.4975	400.0
2014-07-07 05:30:00	AAPL	Stock	23.515	23.515	23.515	23.515	1500.0
2014-07-07 05:50:00	AAPL	Stock	23.51	23.51	23.51	23.51	420.0
2014-07-07 06:00:00	AAPL	Stock	23.5175	23.5175	23.5175	23.5175	400.0
2014-07-07 06:05:00	AAPL	Stock	23.5175	23.5175	23.5175	23.5175	2800.0
2014-07-07 06:40:00	AAPL	Stock	23.5325	23.5325	23.5325	23.5325	2400.0
2014-07-07 06:45:00	AAPL	Stock	23.5325	23.5325	23.5325	23.5325	1284.0
2014-07-07 06:50:00	AAPL	Stock	23.525	23.525	23.525	23.525	400.0
2014-07-07 07:05:00	AAPL	Stock	23.525	23.5325	23.525	23.5325	5076.0
2014-07-07 07:10:00	AAPL	Stock	23.5375	23.5475	23.5375	23.5475	7520.0
2014-07-07 07:15:00	AAPL	Stock	23.5475	23.5475	23.525	23.525	13324.0
2014-07-07 07:30:00	AAPL	Stock	23.5225	23.5375	23.5225	23.5375	5308.0
2014-07-07 07:35:00	AAPL	Stock	23.535	23.5375	23.535	23.5375	800.0
2014-07-07 07:40:00	AAPL	Stock	23.5375	23.5375	23.5375	23.5375	13628.0
2014-07-07 07:45:00	AAPL	Stock	23.5375	23.5375	23.53	23.53	5060.0
2014-07-07 07:50:00	AAPL	Stock	23.52	23.52	23.5125	23.515	10300.0
2014-07-07 07:55:00	AAPL	Stock	23.5125	23.5175	23.5125	23.5175	2920.0
2014-07-07 08:00:00	AAPL	Stock	23.5225	23.5475	23.4875	23.5	106280.0
2014-07-07 08:05:00	AAPL	Stock	23.5	23.5175	23.4975	23.5175	51620.0
2014-07-07 08:10:00	AAPL	Stock	23.515	23.525	23.5125	23.5125	58816.0
2014-07-07 08:15:00	AAPL	Stock	23.51	23.5175	23.51	23.5125	31080.0
2014-07-07 08:20:00	AAPL	Stock	23.5125	23.5175	23.51	23.51	23600.0
2014-07-07 08:25:00	AAPL	Stock	23.5125	23.5125	23.4875	23.4925	40152.0
2014-07-07 08:30:00	AAPL	Stock	23.4875	23.49	23.48	23.4825	10124.0
2014-07-07 08:35:00	AAPL	Stock	23.4825	23.4875	23.4775	23.4775	35200.0
2014-07-07 08:40:00	AAPL	Stock	23.475	23.4975	23.475	23.4925	57152.0
2014-07-07 08:45:00	AAPL	Stock	23.4975	23.5	23.4875	23.495	39240.0
2014-07-07 08:50:00	AAPL	Stock	23.4875	23.495	23.485	23.495	51448.0
2014-07-07 08:55:00	AAPL	Stock	23.495	23.495	23.495	23.495	14480.0
2014-07-07 09:00:00	AAPL	Stock	23.495	23.4975	23.4925	23.4975	15000.0
2014-07-07 09:05:00	AAPL	Stock	23.4975	23.4975	23.495	23.495	16124.0
2014-07-07 09:10:00	AAPL	Stock	23.4975	23.5075	23.4975	23.5075	40068.0
2014-07-07 09:15:00	AAPL	Stock	23.5075	23.51	23.505	23.51	50048.0
2014-07-07 09:20:00	AAPL	Stock	23.51	23.53	23.4975	23.5225	157568.0
2014-07-07 09:25:00	AAPL	Stock	23.5225	23.55	23.5225	23.5375	95900.0
2014-07-07 09:30:00	AAPL	Stock	23.535	23.595	23.525	23.5763	8668344.0
2014-07-07 09:35:00	AAPL	Stock	23.575	23.6225	23.575	23.6222	5106116.0
2014-07-07 09:40:00	AAPL	Stock	23.62	23.65	23.6075	23.6138	5277552.0
2014-07-07 09:45:00	AAPL	Stock	23.6125	23.65	23.6125	23.6225	2499672.0
2014-07-07 09:50:00	AAPL	Stock	23.6225	23.6875	23.6225	23.6842	4060980.0
2014-07-07 09:55:00	AAPL	Stock	23.6825	23.7475	23.675	23.7475	6573280.0
2014-07-07 10:00:00	AAPL	Stock	23.7462	23.7462	23.69	23.7245	4890552.0
2014-07-07 10:05:00	AAPL	Stock	23.7238	23.7425	23.7025	23.7375	2451908.0
2014-07-07 10:10:00	AAPL	Stock	23.7375	23.7425	23.72	23.7375	3076288.0
2014-07-07 10:15:00	AAPL	Stock	23.7372	23.7975	23.7325	23.7875	9292512.0
2014-07-07 10:20:00	AAPL	Stock	23.79	23.8025	23.76	23.785	4204644.0

> showing 50 of 365,481 rows — these rows as CSV

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