PREVIEW / stock_5min / 2014-06-26

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-06-26.parquet
  size:    5.3 MB
  rows:    355,766
  symbols: 3,560

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-06-26 05:00:00	AAPL	Stock	22.59	22.59	22.59	22.59	400.0
2014-06-26 05:35:00	AAPL	Stock	22.6275	22.6275	22.6275	22.6275	1068.0
2014-06-26 06:00:00	AAPL	Stock	22.6375	22.6475	22.6375	22.6475	3600.0
2014-06-26 06:10:00	AAPL	Stock	22.645	22.65	22.645	22.65	800.0
2014-06-26 06:15:00	AAPL	Stock	22.645	22.6525	22.645	22.6525	3352.0
2014-06-26 06:20:00	AAPL	Stock	22.675	22.675	22.67	22.675	3920.0
2014-06-26 06:35:00	AAPL	Stock	22.67	22.67	22.65	22.65	1560.0
2014-06-26 06:40:00	AAPL	Stock	22.65	22.65	22.635	22.635	6960.0
2014-06-26 06:50:00	AAPL	Stock	22.645	22.65	22.645	22.65	4000.0
2014-06-26 07:00:00	AAPL	Stock	22.65	22.65	22.65	22.65	400.0
2014-06-26 07:05:00	AAPL	Stock	22.65	22.65	22.635	22.65	6256.0
2014-06-26 07:10:00	AAPL	Stock	22.64	22.64	22.64	22.64	1600.0
2014-06-26 07:15:00	AAPL	Stock	22.65	22.65	22.64	22.65	2400.0
2014-06-26 07:20:00	AAPL	Stock	22.6325	22.6325	22.6325	22.6325	1200.0
2014-06-26 07:25:00	AAPL	Stock	22.65	22.65	22.65	22.65	19864.0
2014-06-26 07:30:00	AAPL	Stock	22.65	22.65	22.65	22.65	2800.0
2014-06-26 07:40:00	AAPL	Stock	22.6375	22.6375	22.6375	22.6375	1200.0
2014-06-26 07:45:00	AAPL	Stock	22.6475	22.6475	22.6475	22.6475	2800.0
2014-06-26 07:50:00	AAPL	Stock	22.6425	22.6425	22.6425	22.6425	400.0
2014-06-26 07:55:00	AAPL	Stock	22.6375	22.6375	22.6325	22.635	2000.0
2014-06-26 08:00:00	AAPL	Stock	22.65	22.65	22.6175	22.6175	72808.0
2014-06-26 08:05:00	AAPL	Stock	22.6225	22.6225	22.6125	22.615	16400.0
2014-06-26 08:10:00	AAPL	Stock	22.615	22.615	22.6125	22.615	13540.0
2014-06-26 08:15:00	AAPL	Stock	22.6125	22.615	22.595	22.6	31284.0
2014-06-26 08:20:00	AAPL	Stock	22.6	22.6025	22.5975	22.6	17416.0
2014-06-26 08:25:00	AAPL	Stock	22.6025	22.605	22.5925	22.5925	24816.0
2014-06-26 08:30:00	AAPL	Stock	22.5925	22.5975	22.5775	22.5775	26792.0
2014-06-26 08:35:00	AAPL	Stock	22.5825	22.6	22.5825	22.5975	32200.0
2014-06-26 08:40:00	AAPL	Stock	22.6	22.6025	22.5875	22.5875	26224.0
2014-06-26 08:45:00	AAPL	Stock	22.5875	22.595	22.585	22.585	38304.0
2014-06-26 08:50:00	AAPL	Stock	22.5975	22.6	22.5875	22.59	134720.0
2014-06-26 08:55:00	AAPL	Stock	22.59	22.6	22.59	22.595	48000.0
2014-06-26 09:00:00	AAPL	Stock	22.5875	22.5925	22.5875	22.5925	4000.0
2014-06-26 09:05:00	AAPL	Stock	22.595	22.6	22.5875	22.5975	64464.0
2014-06-26 09:10:00	AAPL	Stock	22.5925	22.6	22.5875	22.595	54480.0
2014-06-26 09:15:00	AAPL	Stock	22.5975	22.61	22.5975	22.6	19660.0
2014-06-26 09:20:00	AAPL	Stock	22.6075	22.6075	22.6	22.6	81200.0
2014-06-26 09:25:00	AAPL	Stock	22.605	22.61	22.59	22.6025	132920.0
2014-06-26 09:30:00	AAPL	Stock	22.595	22.635	22.515	22.52	7089112.0
2014-06-26 09:35:00	AAPL	Stock	22.52	22.575	22.4775	22.5525	4367552.0
2014-06-26 09:40:00	AAPL	Stock	22.5525	22.5725	22.495	22.495	2985100.0
2014-06-26 09:45:00	AAPL	Stock	22.5	22.5375	22.4575	22.4587	3726956.0
2014-06-26 09:50:00	AAPL	Stock	22.4587	22.5	22.45	22.485	2755000.0
2014-06-26 09:55:00	AAPL	Stock	22.485	22.5	22.4675	22.4925	2520992.0
2014-06-26 10:00:00	AAPL	Stock	22.4925	22.5	22.455	22.478	3103808.0
2014-06-26 10:05:00	AAPL	Stock	22.4792	22.4975	22.4625	22.49	1917160.0
2014-06-26 10:10:00	AAPL	Stock	22.4875	22.525	22.4725	22.4725	2634408.0
2014-06-26 10:15:00	AAPL	Stock	22.4725	22.5	22.47	22.496	1866940.0
2014-06-26 10:20:00	AAPL	Stock	22.4972	22.515	22.475	22.4925	1635352.0
2014-06-26 10:25:00	AAPL	Stock	22.4907	22.495	22.4538	22.4925	2174992.0

> showing 50 of 355,766 rows — these rows as CSV

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