PREVIEW / stock_5min / 2014-07-23

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-07-23.parquet
  size:    5.2 MB
  rows:    346,687
  symbols: 3,559

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-23 04:00:00	AAPL	Stock	23.585	23.6175	23.585	23.6175	3416.0
2014-07-23 04:05:00	AAPL	Stock	23.62	23.62	23.5775	23.5775	1200.0
2014-07-23 04:10:00	AAPL	Stock	23.5775	23.615	23.5775	23.615	3600.0
2014-07-23 04:20:00	AAPL	Stock	23.6	23.6225	23.6	23.6	5020.0
2014-07-23 04:30:00	AAPL	Stock	23.625	23.625	23.6	23.6	2000.0
2014-07-23 04:35:00	AAPL	Stock	23.6	23.6	23.5975	23.5975	800.0
2014-07-23 04:40:00	AAPL	Stock	23.6025	23.6025	23.6025	23.6025	400.0
2014-07-23 04:45:00	AAPL	Stock	23.5975	23.6075	23.5975	23.6075	800.0
2014-07-23 05:10:00	AAPL	Stock	23.59	23.59	23.585	23.585	1960.0
2014-07-23 05:20:00	AAPL	Stock	23.595	23.595	23.595	23.595	400.0
2014-07-23 05:25:00	AAPL	Stock	23.6	23.6	23.5825	23.5825	2000.0
2014-07-23 05:35:00	AAPL	Stock	23.5875	23.5875	23.5875	23.5875	7400.0
2014-07-23 05:40:00	AAPL	Stock	23.5775	23.5775	23.5775	23.5775	9200.0
2014-07-23 05:45:00	AAPL	Stock	23.5875	23.5875	23.5875	23.5875	800.0
2014-07-23 05:50:00	AAPL	Stock	23.5875	23.5875	23.5875	23.5875	1200.0
2014-07-23 05:55:00	AAPL	Stock	23.5975	23.6	23.5975	23.6	3520.0
2014-07-23 06:00:00	AAPL	Stock	23.5875	23.5875	23.555	23.575	3140.0
2014-07-23 06:05:00	AAPL	Stock	23.5675	23.5875	23.5675	23.5875	3940.0
2014-07-23 06:10:00	AAPL	Stock	23.575	23.575	23.575	23.575	14452.0
2014-07-23 06:15:00	AAPL	Stock	23.57	23.57	23.57	23.57	4676.0
2014-07-23 06:20:00	AAPL	Stock	23.57	23.57	23.5675	23.5675	2380.0
2014-07-23 06:25:00	AAPL	Stock	23.575	23.575	23.575	23.575	1200.0
2014-07-23 06:30:00	AAPL	Stock	23.57	23.57	23.5475	23.565	11948.0
2014-07-23 06:40:00	AAPL	Stock	23.565	23.565	23.545	23.545	6000.0
2014-07-23 06:45:00	AAPL	Stock	23.565	23.565	23.565	23.565	1000.0
2014-07-23 06:50:00	AAPL	Stock	23.57	23.575	23.57	23.57	15144.0
2014-07-23 06:55:00	AAPL	Stock	23.57	23.57	23.545	23.5625	12980.0
2014-07-23 07:00:00	AAPL	Stock	23.5625	23.575	23.5625	23.57	34152.0
2014-07-23 07:05:00	AAPL	Stock	23.5625	23.5625	23.53	23.55	14424.0
2014-07-23 07:10:00	AAPL	Stock	23.55	23.575	23.55	23.575	113252.0
2014-07-23 07:15:00	AAPL	Stock	23.57	23.6975	23.57	23.695	187956.0
2014-07-23 07:20:00	AAPL	Stock	23.6875	23.7325	23.675	23.7275	181156.0
2014-07-23 07:25:00	AAPL	Stock	23.7175	23.7875	23.7	23.7875	297260.0
2014-07-23 07:30:00	AAPL	Stock	23.79	23.88	23.775	23.85	288860.0
2014-07-23 07:35:00	AAPL	Stock	23.8725	23.9675	23.87	23.9675	257128.0
2014-07-23 07:40:00	AAPL	Stock	23.9675	23.9675	23.8775	23.8775	124440.0
2014-07-23 07:45:00	AAPL	Stock	23.8925	23.915	23.8575	23.875	126488.0
2014-07-23 07:50:00	AAPL	Stock	23.8625	23.875	23.8125	23.8475	122056.0
2014-07-23 07:55:00	AAPL	Stock	23.8525	23.855	23.8375	23.845	129700.0
2014-07-23 08:00:00	AAPL	Stock	23.8475	23.97	23.53	23.765	951788.0
2014-07-23 08:05:00	AAPL	Stock	23.77	23.825	23.75	23.8	329680.0
2014-07-23 08:10:00	AAPL	Stock	23.8025	23.805	23.775	23.7775	181312.0
2014-07-23 08:15:00	AAPL	Stock	23.7775	23.7875	23.7575	23.7725	251524.0
2014-07-23 08:20:00	AAPL	Stock	23.7725	23.78	23.755	23.755	199140.0
2014-07-23 08:25:00	AAPL	Stock	23.7625	23.7625	23.7125	23.7175	443136.0
2014-07-23 08:30:00	AAPL	Stock	23.72	23.735	23.6825	23.725	309308.0
2014-07-23 08:35:00	AAPL	Stock	23.715	23.735	23.7	23.735	216984.0
2014-07-23 08:40:00	AAPL	Stock	23.735	23.8125	23.7225	23.8125	799012.0
2014-07-23 08:45:00	AAPL	Stock	23.81	23.83	23.7875	23.8125	533016.0
2014-07-23 08:50:00	AAPL	Stock	23.8125	23.825	23.7975	23.8075	307916.0

> showing 50 of 346,687 rows — these rows as CSV

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