PREVIEW / stock_5min / 2013-08-21

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-08-21.parquet
  size:    5.1 MB
  rows:    337,892
  symbols: 3,526

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-08-21 04:00:00	AAPL	Stock	17.9196	17.9196	17.9089	17.9089	14000.0
2013-08-21 05:20:00	AAPL	Stock	17.9136	17.9136	17.9136	17.9136	2800.0
2013-08-21 05:55:00	AAPL	Stock	17.9143	17.9143	17.8775	17.8775	5600.0
2013-08-21 06:05:00	AAPL	Stock	17.8607	17.8607	17.8607	17.8607	2800.0
2013-08-21 06:25:00	AAPL	Stock	17.8929	17.8929	17.8929	17.8929	2800.0
2013-08-21 06:35:00	AAPL	Stock	17.8571	17.8575	17.8571	17.8575	190288.0
2013-08-21 06:40:00	AAPL	Stock	17.8579	17.8946	17.8571	17.8929	42000.0
2013-08-21 06:45:00	AAPL	Stock	17.8793	17.8793	17.86	17.8754	8400.0
2013-08-21 06:50:00	AAPL	Stock	17.8618	17.8618	17.8582	17.8582	5600.0
2013-08-21 06:55:00	AAPL	Stock	17.8571	17.8811	17.8568	17.8811	14000.0
2013-08-21 07:05:00	AAPL	Stock	17.8575	17.8661	17.8575	17.8661	11172.0
2013-08-21 07:10:00	AAPL	Stock	17.88	17.8811	17.8589	17.8589	24864.0
2013-08-21 07:15:00	AAPL	Stock	17.8643	17.88	17.8643	17.88	15400.0
2013-08-21 07:20:00	AAPL	Stock	17.8864	17.9064	17.8857	17.8971	31360.0
2013-08-21 07:25:00	AAPL	Stock	17.9046	17.9289	17.9046	17.925	40824.0
2013-08-21 07:30:00	AAPL	Stock	17.9146	17.9286	17.9146	17.9286	36148.0
2013-08-21 07:40:00	AAPL	Stock	17.9368	17.9464	17.9196	17.9268	117404.0
2013-08-21 07:45:00	AAPL	Stock	17.9321	17.9864	17.9321	17.9786	133000.0
2013-08-21 07:50:00	AAPL	Stock	17.9836	17.9839	17.9543	17.9543	83020.0
2013-08-21 07:55:00	AAPL	Stock	17.9468	17.9554	17.9468	17.9554	29232.0
2013-08-21 08:00:00	AAPL	Stock	17.9471	17.9914	17.8571	17.9786	240436.0
2013-08-21 08:05:00	AAPL	Stock	17.9775	17.9893	17.9764	17.9821	275408.0
2013-08-21 08:10:00	AAPL	Stock	17.9821	17.9846	17.9646	17.9646	200872.0
2013-08-21 08:15:00	AAPL	Stock	17.9779	17.9929	17.9754	17.9929	175280.0
2013-08-21 08:20:00	AAPL	Stock	17.9911	17.9929	17.985	17.9904	39956.0
2013-08-21 08:25:00	AAPL	Stock	17.9868	17.9964	17.9857	17.9857	86660.0
2013-08-21 08:30:00	AAPL	Stock	17.9839	17.9925	17.9839	17.985	274400.0
2013-08-21 08:35:00	AAPL	Stock	17.9832	17.9886	17.9821	17.9821	143556.0
2013-08-21 08:40:00	AAPL	Stock	17.9839	17.9889	17.9839	17.9846	64960.0
2013-08-21 08:45:00	AAPL	Stock	17.9829	17.9829	17.9593	17.9593	458864.0
2013-08-21 08:50:00	AAPL	Stock	17.9589	17.9725	17.9571	17.9607	183092.0
2013-08-21 08:55:00	AAPL	Stock	17.9611	17.9625	17.9504	17.9521	66472.0
2013-08-21 09:00:00	AAPL	Stock	17.95	17.9643	17.95	17.9532	89712.0
2013-08-21 09:05:00	AAPL	Stock	17.9571	17.9664	17.9411	17.9464	175000.0
2013-08-21 09:10:00	AAPL	Stock	17.9589	17.9661	17.9429	17.9661	86800.0
2013-08-21 09:15:00	AAPL	Stock	17.965	17.9682	17.9582	17.9643	75600.0
2013-08-21 09:20:00	AAPL	Stock	17.9643	17.9857	17.9607	17.9821	391944.0
2013-08-21 09:25:00	AAPL	Stock	17.9821	17.9907	17.9661	17.975	218428.0
2013-08-21 09:30:00	AAPL	Stock	17.9689	18.0464	17.9532	18.0464	16356844.0
2013-08-21 09:35:00	AAPL	Stock	18.0468	18.0521	17.9739	18.0129	10006612.0
2013-08-21 09:40:00	AAPL	Stock	18.0203	18.0939	18.0154	18.0715	13651624.0
2013-08-21 09:45:00	AAPL	Stock	18.0746	18.1125	18.0664	18.0929	7271012.0
2013-08-21 09:50:00	AAPL	Stock	18.0936	18.1011	18.0514	18.0671	6331892.0
2013-08-21 09:55:00	AAPL	Stock	18.0671	18.1054	18.0586	18.0896	4925312.0
2013-08-21 10:00:00	AAPL	Stock	18.0896	18.0921	18.0579	18.0768	4652116.0
2013-08-21 10:05:00	AAPL	Stock	18.0775	18.0775	18.0164	18.0164	6357988.0
2013-08-21 10:10:00	AAPL	Stock	18.0164	18.0396	17.9968	18.0229	8520232.0
2013-08-21 10:15:00	AAPL	Stock	18.0243	18.0596	18.0232	18.0289	3698856.0
2013-08-21 10:20:00	AAPL	Stock	18.0289	18.0357	17.9686	17.9907	7777616.0
2013-08-21 10:25:00	AAPL	Stock	17.9904	18.0007	17.9179	17.9286	8449588.0

> showing 50 of 337,892 rows — these rows as CSV

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