PREVIEW / stock_5min / 2013-04-29

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-04-29.parquet
  size:    5.0 MB
  rows:    330,530
  symbols: 3,507

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
2013-04-29 04:00:00	AAPL	Stock	14.9464	15.3286	14.9464	15.0	39564.0
2013-04-29 04:40:00	AAPL	Stock	14.9607	14.9607	14.9607	14.9607	2800.0
2013-04-29 06:05:00	AAPL	Stock	14.9786	14.9786	14.9786	14.9786	2800.0
2013-04-29 06:10:00	AAPL	Stock	14.9786	14.9786	14.9754	14.9754	5600.0
2013-04-29 06:15:00	AAPL	Stock	14.9754	14.9786	14.9643	14.9786	15428.0
2013-04-29 06:40:00	AAPL	Stock	14.9818	14.9818	14.9818	14.9818	2800.0
2013-04-29 06:50:00	AAPL	Stock	14.9829	14.9829	14.9811	14.9811	7056.0
2013-04-29 06:55:00	AAPL	Stock	14.9754	14.9754	14.9754	14.9754	4844.0
2013-04-29 07:00:00	AAPL	Stock	14.9732	14.9732	14.9546	14.9643	31416.0
2013-04-29 07:05:00	AAPL	Stock	14.9636	14.9636	14.9554	14.9554	5600.0
2013-04-29 07:15:00	AAPL	Stock	14.9639	14.9804	14.9639	14.9646	32648.0
2013-04-29 07:20:00	AAPL	Stock	14.9643	14.9643	14.9643	14.9643	11200.0
2013-04-29 07:25:00	AAPL	Stock	14.9704	14.9782	14.9704	14.9782	14000.0
2013-04-29 07:30:00	AAPL	Stock	14.9771	14.9946	14.9771	14.9921	157864.0
2013-04-29 07:35:00	AAPL	Stock	14.9964	15.0179	14.9964	15.0179	194208.0
2013-04-29 07:40:00	AAPL	Stock	15.0232	15.0232	15.0	15.0004	56000.0
2013-04-29 07:45:00	AAPL	Stock	14.9821	14.9907	14.9721	14.9907	56000.0
2013-04-29 07:50:00	AAPL	Stock	14.9754	14.9911	14.97	14.97	30800.0
2013-04-29 07:55:00	AAPL	Stock	14.9771	14.9818	14.975	14.9818	14000.0
2013-04-29 08:00:00	AAPL	Stock	14.9729	15.0243	14.9643	15.0089	395080.0
2013-04-29 08:05:00	AAPL	Stock	15.0086	15.0104	14.9854	14.9929	187264.0
2013-04-29 08:10:00	AAPL	Stock	14.9929	15.0104	14.9854	15.0104	199248.0
2013-04-29 08:15:00	AAPL	Stock	15.0111	15.0114	15.0046	15.0089	115640.0
2013-04-29 08:20:00	AAPL	Stock	15.0107	15.0179	15.0064	15.0089	139104.0
2013-04-29 08:25:00	AAPL	Stock	15.0071	15.0107	15.0046	15.0107	55832.0
2013-04-29 08:30:00	AAPL	Stock	15.0061	15.0104	15.0046	15.0104	137060.0
2013-04-29 08:35:00	AAPL	Stock	15.0064	15.015	15.0046	15.0082	115276.0
2013-04-29 08:40:00	AAPL	Stock	15.0086	15.0086	14.9896	15.0018	273168.0
2013-04-29 08:45:00	AAPL	Stock	14.9989	15.0	14.9911	14.9932	120540.0
2013-04-29 08:50:00	AAPL	Stock	14.9918	14.9996	14.9857	14.9975	102480.0
2013-04-29 08:55:00	AAPL	Stock	14.9893	14.9975	14.9893	14.9893	20776.0
2013-04-29 09:00:00	AAPL	Stock	14.9893	14.9996	14.9893	14.9989	94696.0
2013-04-29 09:05:00	AAPL	Stock	15.0	15.0039	14.9904	14.9971	465724.0
2013-04-29 09:10:00	AAPL	Stock	14.9971	15.0039	14.9921	15.0007	246820.0
2013-04-29 09:15:00	AAPL	Stock	15.0021	15.0039	14.9964	15.0	144116.0
2013-04-29 09:20:00	AAPL	Stock	14.9986	15.0	14.9821	14.9821	245700.0
2013-04-29 09:25:00	AAPL	Stock	14.9793	15.0196	14.975	15.0171	599424.0
2013-04-29 09:30:00	AAPL	Stock	15.0168	15.1046	15.0	15.0524	26183136.0
2013-04-29 09:35:00	AAPL	Stock	15.0525	15.0821	15.0132	15.0668	10098704.0
2013-04-29 09:40:00	AAPL	Stock	15.065	15.1446	15.0514	15.1371	13756260.0
2013-04-29 09:45:00	AAPL	Stock	15.1362	15.1721	15.1071	15.1689	12013456.0
2013-04-29 09:50:00	AAPL	Stock	15.1697	15.213	15.1611	15.167	17333064.0
2013-04-29 09:55:00	AAPL	Stock	15.1661	15.1846	15.1161	15.1389	11578952.0
2013-04-29 10:00:00	AAPL	Stock	15.1389	15.1854	15.1336	15.1825	10263736.0
2013-04-29 10:05:00	AAPL	Stock	15.1829	15.1946	15.1607	15.1784	8210468.0
2013-04-29 10:10:00	AAPL	Stock	15.1754	15.1786	15.1439	15.1686	5175492.0
2013-04-29 10:15:00	AAPL	Stock	15.1746	15.1875	15.1671	15.1821	5188372.0
2013-04-29 10:20:00	AAPL	Stock	15.1796	15.2482	15.1796	15.2479	12144888.0
2013-04-29 10:25:00	AAPL	Stock	15.2479	15.2539	15.2269	15.2339	7776944.0
2013-04-29 10:30:00	AAPL	Stock	15.2329	15.2482	15.2182	15.2432	4836468.0

> showing 50 of 330,530 rows — these rows as CSV

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