PREVIEW / stock_1hour / 2015-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-29.parquet
  size:    1.0 MB
  rows:    48,387
  symbols: 3,480

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
2015-07-29 04:00:00	AAPL	Stock	30.9575	30.9575	30.8725	30.9125	9600.0
2015-07-29 05:00:00	AAPL	Stock	30.915	30.9725	30.9125	30.9725	22608.0
2015-07-29 06:00:00	AAPL	Stock	30.96	30.96	30.875	30.905	13300.0
2015-07-29 07:00:00	AAPL	Stock	30.9	30.905	30.835	30.8625	49424.0
2015-07-29 08:00:00	AAPL	Stock	30.8625	30.9225	30.715	30.7495	537856.0
2015-07-29 09:00:00	AAPL	Stock	30.7525	30.875	30.65	30.6782	17801788.0
2015-07-29 10:00:00	AAPL	Stock	30.6775	30.77	30.5675	30.6825	24188100.0
2015-07-29 11:00:00	AAPL	Stock	30.68	30.7075	30.625	30.69	12424556.0
2015-07-29 12:00:00	AAPL	Stock	30.6875	30.705	30.615	30.645	9297016.0
2015-07-29 13:00:00	AAPL	Stock	30.6462	30.7325	30.6375	30.6925	7946928.0
2015-07-29 14:00:00	AAPL	Stock	30.6905	30.82	30.62	30.78	20011548.0
2015-07-29 15:00:00	AAPL	Stock	30.7825	30.795	30.66	30.745	25166512.0
2015-07-29 16:00:00	AAPL	Stock	30.7475	30.7475	30.5775	30.6638	10948900.0
2015-07-29 17:00:00	AAPL	Stock	30.6325	30.725	30.63	30.665	312624.0
2015-07-29 18:00:00	AAPL	Stock	30.665	30.675	30.6375	30.6475	99376.0
2015-07-29 19:00:00	AAPL	Stock	30.6375	30.675	30.6375	30.64	85368.0
2015-07-29 06:00:00	MSFT	Stock	45.41	45.41	45.41	45.41	100.0
2015-07-29 07:00:00	MSFT	Stock	45.67	45.69	45.5	45.6	5613.0
2015-07-29 08:00:00	MSFT	Stock	45.49	45.59	45.48	45.48	23147.0
2015-07-29 09:00:00	MSFT	Stock	45.45	45.785	45.2	45.51	2871143.0
2015-07-29 10:00:00	MSFT	Stock	45.51	45.99	45.421	45.94	4604990.0
2015-07-29 11:00:00	MSFT	Stock	45.94	46.44	45.89	46.42	5590704.0
2015-07-29 12:00:00	MSFT	Stock	46.42	46.65	46.3	46.636	4449075.0
2015-07-29 13:00:00	MSFT	Stock	46.63	46.78	46.44	46.55	4945280.0
2015-07-29 14:00:00	MSFT	Stock	46.55	46.705	46.38	46.56	5158445.0
2015-07-29 15:00:00	MSFT	Stock	46.56	46.58	46.24	46.28	9079478.0
2015-07-29 16:00:00	MSFT	Stock	46.29	46.32	46.23	46.255	2109244.0
2015-07-29 17:00:00	MSFT	Stock	46.29	46.29	46.13	46.29	5285.0
2015-07-29 18:00:00	MSFT	Stock	46.29	46.39	46.29	46.38	15450.0
2015-07-29 19:00:00	MSFT	Stock	46.13	46.297	46.13	46.25	1650.0
2015-07-29 09:00:00	NVDA	Stock	0.4918	0.4958	0.4902	0.4946	27458960.0
2015-07-29 10:00:00	NVDA	Stock	0.4942	0.4975	0.4923	0.4963	36736320.0
2015-07-29 11:00:00	NVDA	Stock	0.4963	0.4996	0.4952	0.4984	29414160.0
2015-07-29 12:00:00	NVDA	Stock	0.4985	0.4988	0.4965	0.4982	18516920.0
2015-07-29 13:00:00	NVDA	Stock	0.4982	0.5013	0.4982	0.5008	24637520.0
2015-07-29 14:00:00	NVDA	Stock	0.5008	0.5032	0.4992	0.5003	36151320.0
2015-07-29 15:00:00	NVDA	Stock	0.5003	0.5005	0.4985	0.4995	45565400.0
2015-07-29 16:00:00	NVDA	Stock	0.4992	0.4992	0.4976	0.4976	7052800.0
2015-07-29 19:00:00	NVDA	Stock	0.4975	0.4975	0.4975	0.4975	40000.0
2015-07-29 04:00:00	AMZN	Stock	26.461	26.575	26.461	26.575	16000.0
2015-07-29 05:00:00	AMZN	Stock	26.575	26.59	26.575	26.59	146000.0
2015-07-29 06:00:00	AMZN	Stock	26.5645	26.607	26.5255	26.5755	312520.0
2015-07-29 07:00:00	AMZN	Stock	26.575	26.615	26.56	26.5605	207320.0
2015-07-29 08:00:00	AMZN	Stock	26.565	26.65	26.5132	26.5315	913400.0
2015-07-29 09:00:00	AMZN	Stock	26.5205	26.575	26.251	26.359	13185280.0
2015-07-29 10:00:00	AMZN	Stock	26.3595	26.6483	26.2525	26.4835	15936840.0
2015-07-29 11:00:00	AMZN	Stock	26.4835	26.4965	26.3345	26.3645	5218980.0
2015-07-29 12:00:00	AMZN	Stock	26.3745	26.4335	26.3325	26.405	4060640.0
2015-07-29 13:00:00	AMZN	Stock	26.4185	26.425	26.331	26.366	3472040.0
2015-07-29 14:00:00	AMZN	Stock	26.3728	26.5425	26.3146	26.4998	11371080.0

> showing 50 of 48,387 rows — these rows as CSV

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