PREVIEW / stock_5min / 2012-07-05

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-05.parquet
  size:    4.7 MB
  rows:    317,473
  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
2012-07-05 04:00:00	AAPL	Stock	21.3929	21.3929	21.3929	21.3929	2800.0
2012-07-05 04:25:00	AAPL	Stock	21.3575	21.3575	21.3575	21.3575	11200.0
2012-07-05 04:30:00	AAPL	Stock	21.3732	21.3732	21.3732	21.3732	2800.0
2012-07-05 04:35:00	AAPL	Stock	21.3732	21.3732	21.3732	21.3732	8400.0
2012-07-05 04:40:00	AAPL	Stock	21.3571	21.3571	21.3571	21.3571	2800.0
2012-07-05 05:55:00	AAPL	Stock	21.3582	21.3582	21.3582	21.3582	2800.0
2012-07-05 06:55:00	AAPL	Stock	21.3839	21.3839	21.3839	21.3839	14000.0
2012-07-05 07:00:00	AAPL	Stock	21.3929	21.4821	21.3929	21.4821	28364.0
2012-07-05 07:05:00	AAPL	Stock	21.4921	21.4921	21.4643	21.4679	30800.0
2012-07-05 07:10:00	AAPL	Stock	21.4554	21.4821	21.4554	21.4821	14000.0
2012-07-05 07:15:00	AAPL	Stock	21.4836	21.5007	21.4679	21.5	60900.0
2012-07-05 07:20:00	AAPL	Stock	21.5175	21.5318	21.5175	21.5314	23660.0
2012-07-05 07:25:00	AAPL	Stock	21.5161	21.535	21.5107	21.5111	47600.0
2012-07-05 07:30:00	AAPL	Stock	21.5107	21.5107	21.4839	21.5	109480.0
2012-07-05 07:35:00	AAPL	Stock	21.4964	21.5	21.4821	21.5	30800.0
2012-07-05 07:40:00	AAPL	Stock	21.4993	21.5164	21.4993	21.5161	53340.0
2012-07-05 07:45:00	AAPL	Stock	21.5186	21.5186	21.4893	21.4964	123984.0
2012-07-05 07:50:00	AAPL	Stock	21.5039	21.525	21.5	21.5	173964.0
2012-07-05 07:55:00	AAPL	Stock	21.4839	21.4886	21.4268	21.4489	201684.0
2012-07-05 08:00:00	AAPL	Stock	21.4611	21.5164	21.4214	21.4786	569828.0
2012-07-05 08:05:00	AAPL	Stock	21.4961	21.4961	21.4489	21.4679	235396.0
2012-07-05 08:10:00	AAPL	Stock	21.4679	21.4857	21.4679	21.4746	340116.0
2012-07-05 08:15:00	AAPL	Stock	21.4864	21.5268	21.4864	21.5214	420588.0
2012-07-05 08:20:00	AAPL	Stock	21.5214	21.5261	21.5	21.5057	395920.0
2012-07-05 08:25:00	AAPL	Stock	21.5057	21.5107	21.5	21.5071	230440.0
2012-07-05 08:30:00	AAPL	Stock	21.5125	21.5179	21.5	21.5096	443156.0
2012-07-05 08:35:00	AAPL	Stock	21.5093	21.5196	21.4864	21.4864	896700.0
2012-07-05 08:40:00	AAPL	Stock	21.4904	21.5079	21.475	21.475	734188.0
2012-07-05 08:45:00	AAPL	Stock	21.4818	21.4982	21.4818	21.4979	165368.0
2012-07-05 08:50:00	AAPL	Stock	21.4982	21.5086	21.4829	21.4829	210084.0
2012-07-05 08:55:00	AAPL	Stock	21.4889	21.4982	21.4839	21.495	128100.0
2012-07-05 09:00:00	AAPL	Stock	21.4957	21.4957	21.4854	21.4939	72240.0
2012-07-05 09:05:00	AAPL	Stock	21.4879	21.4964	21.4879	21.4911	144200.0
2012-07-05 09:10:00	AAPL	Stock	21.4879	21.4911	21.4804	21.4911	227220.0
2012-07-05 09:15:00	AAPL	Stock	21.4911	21.4911	21.4796	21.4825	159320.0
2012-07-05 09:20:00	AAPL	Stock	21.4854	21.4904	21.4821	21.4904	154980.0
2012-07-05 09:25:00	AAPL	Stock	21.4861	21.4861	21.4368	21.4368	783104.0
2012-07-05 09:30:00	AAPL	Stock	21.4486	21.5821	21.4161	21.575	23673104.0
2012-07-05 09:35:00	AAPL	Stock	21.5786	21.6239	21.5725	21.5991	20211240.0
2012-07-05 09:40:00	AAPL	Stock	21.5998	21.6643	21.5968	21.6493	17115028.0
2012-07-05 09:45:00	AAPL	Stock	21.6511	21.6714	21.6125	21.6182	17181528.0
2012-07-05 09:50:00	AAPL	Stock	21.6181	21.6225	21.5911	21.5996	10594696.0
2012-07-05 09:55:00	AAPL	Stock	21.6004	21.6229	21.5868	21.6146	6759368.0
2012-07-05 10:00:00	AAPL	Stock	21.6143	21.6346	21.6111	21.615	6195252.0
2012-07-05 10:05:00	AAPL	Stock	21.615	21.6221	21.5893	21.5939	4872056.0
2012-07-05 10:10:00	AAPL	Stock	21.5946	21.5964	21.5668	21.5843	9054752.0
2012-07-05 10:15:00	AAPL	Stock	21.5804	21.6196	21.5689	21.6189	6801676.0
2012-07-05 10:20:00	AAPL	Stock	21.6189	21.6236	21.6114	21.6232	3792320.0
2012-07-05 10:25:00	AAPL	Stock	21.6232	21.625	21.6118	21.6183	3293752.0
2012-07-05 10:30:00	AAPL	Stock	21.6214	21.6625	21.6179	21.6607	6739236.0

> showing 50 of 317,473 rows — these rows as CSV

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