PREVIEW / stock_5min / 2014-05-09

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-05-09.parquet
  size:    5.3 MB
  rows:    354,026
  symbols: 3,537

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-05-09 04:00:00	AAPL	Stock	20.9964	20.9964	20.8929	20.8929	11200.0
2014-05-09 05:25:00	AAPL	Stock	20.9479	20.9479	20.9457	20.9457	5600.0
2014-05-09 05:55:00	AAPL	Stock	20.9554	20.9554	20.9554	20.9554	2800.0
2014-05-09 06:00:00	AAPL	Stock	20.9518	20.9518	20.945	20.945	5600.0
2014-05-09 06:15:00	AAPL	Stock	20.9429	20.9429	20.9429	20.9429	5600.0
2014-05-09 06:20:00	AAPL	Stock	20.9143	20.9143	20.9107	20.9107	14000.0
2014-05-09 06:25:00	AAPL	Stock	20.8839	20.8839	20.8839	20.8839	5600.0
2014-05-09 06:35:00	AAPL	Stock	20.9082	20.9082	20.9082	20.9082	2800.0
2014-05-09 07:00:00	AAPL	Stock	20.9107	20.9107	20.9107	20.9107	15204.0
2014-05-09 07:05:00	AAPL	Stock	20.9107	20.9107	20.9107	20.9107	5600.0
2014-05-09 07:15:00	AAPL	Stock	20.9096	20.9107	20.9096	20.9107	19600.0
2014-05-09 07:20:00	AAPL	Stock	20.9107	20.9107	20.8975	20.9054	25200.0
2014-05-09 07:25:00	AAPL	Stock	20.8968	20.8968	20.8636	20.8636	32956.0
2014-05-09 07:30:00	AAPL	Stock	20.8907	20.9696	20.8907	20.9696	56336.0
2014-05-09 07:40:00	AAPL	Stock	20.9286	20.9286	20.9093	20.9093	33600.0
2014-05-09 07:45:00	AAPL	Stock	20.9168	20.9214	20.9168	20.9214	5600.0
2014-05-09 07:50:00	AAPL	Stock	20.9254	20.9254	20.9093	20.9093	37716.0
2014-05-09 07:55:00	AAPL	Stock	20.9129	20.9129	20.905	20.905	12880.0
2014-05-09 08:00:00	AAPL	Stock	20.9107	20.9196	20.8679	20.9	201432.0
2014-05-09 08:05:00	AAPL	Stock	20.9036	20.9036	20.8929	20.8929	12600.0
2014-05-09 08:10:00	AAPL	Stock	20.9132	20.9214	20.8768	20.8768	126924.0
2014-05-09 08:20:00	AAPL	Stock	20.8932	20.8932	20.8679	20.8679	67228.0
2014-05-09 08:25:00	AAPL	Stock	20.8679	20.875	20.8571	20.8714	89628.0
2014-05-09 08:30:00	AAPL	Stock	20.875	20.8793	20.8643	20.875	84588.0
2014-05-09 08:35:00	AAPL	Stock	20.8689	20.875	20.8571	20.8571	90384.0
2014-05-09 08:40:00	AAPL	Stock	20.8575	20.8704	20.8482	20.8668	107128.0
2014-05-09 08:45:00	AAPL	Stock	20.8607	20.8714	20.8607	20.8643	37800.0
2014-05-09 08:50:00	AAPL	Stock	20.8661	20.8804	20.8607	20.8732	146244.0
2014-05-09 08:55:00	AAPL	Stock	20.8836	20.9004	20.8764	20.8939	144676.0
2014-05-09 09:00:00	AAPL	Stock	20.8907	20.8929	20.8789	20.8846	91728.0
2014-05-09 09:05:00	AAPL	Stock	20.8829	20.8832	20.8804	20.8804	14000.0
2014-05-09 09:10:00	AAPL	Stock	20.8896	20.9018	20.8807	20.9	172144.0
2014-05-09 09:15:00	AAPL	Stock	20.9	20.9071	20.8929	20.9054	161672.0
2014-05-09 09:20:00	AAPL	Stock	20.9082	20.9229	20.9068	20.9225	71008.0
2014-05-09 09:25:00	AAPL	Stock	20.9186	20.9186	20.8732	20.8754	482692.0
2014-05-09 09:30:00	AAPL	Stock	20.8764	20.9375	20.8589	20.9289	11825604.0
2014-05-09 09:35:00	AAPL	Stock	20.93	20.9346	20.8518	20.8554	5874624.0
2014-05-09 09:40:00	AAPL	Stock	20.8555	20.8632	20.7914	20.8032	7344512.0
2014-05-09 09:45:00	AAPL	Stock	20.8046	20.8621	20.7986	20.8536	6561828.0
2014-05-09 09:50:00	AAPL	Stock	20.8518	20.8543	20.7914	20.7914	4060224.0
2014-05-09 09:55:00	AAPL	Stock	20.7954	20.8354	20.7707	20.8146	6768888.0
2014-05-09 10:00:00	AAPL	Stock	20.8154	20.8443	20.7814	20.7875	3999520.0
2014-05-09 10:05:00	AAPL	Stock	20.79	20.8389	20.79	20.8182	3032764.0
2014-05-09 10:10:00	AAPL	Stock	20.818	20.86	20.8118	20.8521	3764712.0
2014-05-09 10:15:00	AAPL	Stock	20.8518	20.875	20.8439	20.8621	3136420.0
2014-05-09 10:20:00	AAPL	Stock	20.8625	20.8679	20.8461	20.8532	2209508.0
2014-05-09 10:25:00	AAPL	Stock	20.8546	20.8625	20.8175	20.8186	3123988.0
2014-05-09 10:30:00	AAPL	Stock	20.8175	20.8382	20.8118	20.8191	1908984.0
2014-05-09 10:35:00	AAPL	Stock	20.8179	20.8346	20.8089	20.8304	2591372.0
2014-05-09 10:40:00	AAPL	Stock	20.8314	20.8379	20.7907	20.8046	2059260.0

> showing 50 of 354,026 rows — these rows as CSV

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