PREVIEW / stock_1hour / 2012-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-27.parquet
  size:    921 KB
  rows:    43,754
  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-01-27 04:00:00	AAPL	Stock	15.9039	15.9464	15.9039	15.9464	30800.0
2012-01-27 05:00:00	AAPL	Stock	15.9639	15.9754	15.9596	15.9754	44800.0
2012-01-27 06:00:00	AAPL	Stock	15.9718	15.9825	15.9586	15.9607	53200.0
2012-01-27 07:00:00	AAPL	Stock	15.9464	15.9464	15.9036	15.9096	333592.0
2012-01-27 08:00:00	AAPL	Stock	15.9071	15.9268	15.835	15.8429	1672524.0
2012-01-27 09:00:00	AAPL	Stock	15.84	15.9714	15.84	15.9557	49249788.0
2012-01-27 10:00:00	AAPL	Stock	15.9557	15.9561	15.8929	15.9269	43830276.0
2012-01-27 11:00:00	AAPL	Stock	15.9271	15.9536	15.9061	15.9168	32367524.0
2012-01-27 12:00:00	AAPL	Stock	15.9186	15.9296	15.895	15.9092	18405968.0
2012-01-27 13:00:00	AAPL	Stock	15.9114	15.94	15.9068	15.9329	17404100.0
2012-01-27 14:00:00	AAPL	Stock	15.9343	15.9389	15.9114	15.9247	20474608.0
2012-01-27 15:00:00	AAPL	Stock	15.925	16.0171	15.9236	15.9811	82165188.0
2012-01-27 16:00:00	AAPL	Stock	15.9796	16.0092	15.9419	15.9911	30440228.0
2012-01-27 17:00:00	AAPL	Stock	15.9964	15.9964	15.9743	15.9782	187992.0
2012-01-27 18:00:00	AAPL	Stock	15.9821	15.9886	15.9793	15.9793	28000.0
2012-01-27 19:00:00	AAPL	Stock	15.9789	15.9871	15.9789	15.9871	173040.0
2012-01-27 07:00:00	MSFT	Stock	29.46	29.46	29.46	29.46	300.0
2012-01-27 08:00:00	MSFT	Stock	29.67	29.67	29.34	29.36	13885.0
2012-01-27 09:00:00	MSFT	Stock	29.36	29.53	29.36	29.5	3379892.0
2012-01-27 10:00:00	MSFT	Stock	29.5	29.51	29.23	29.28	9713007.0
2012-01-27 11:00:00	MSFT	Stock	29.28	29.35	29.2	29.26	4846443.0
2012-01-27 12:00:00	MSFT	Stock	29.27	29.3	29.19	29.2	3565689.0
2012-01-27 13:00:00	MSFT	Stock	29.2	29.3	29.185	29.28	4088733.0
2012-01-27 14:00:00	MSFT	Stock	29.275	29.35	29.25	29.276	5051558.0
2012-01-27 15:00:00	MSFT	Stock	29.276	29.32	29.17	29.22	9701388.0
2012-01-27 16:00:00	MSFT	Stock	29.22	29.5	29.2	29.25	2503240.0
2012-01-27 17:00:00	MSFT	Stock	29.26	29.26	29.23	29.26	9816.0
2012-01-27 18:00:00	MSFT	Stock	29.26	29.26	29.21	29.23	2728.0
2012-01-27 19:00:00	MSFT	Stock	29.2	29.23	29.2	29.23	2742.0
2012-01-27 08:00:00	NVDA	Stock	0.365	0.381	0.365	0.381	68000.0
2012-01-27 09:00:00	NVDA	Stock	0.3715	0.3715	0.3625	0.3672	36632880.0
2012-01-27 10:00:00	NVDA	Stock	0.3672	0.373	0.3655	0.373	73294960.0
2012-01-27 11:00:00	NVDA	Stock	0.3729	0.3735	0.3713	0.3728	44018760.0
2012-01-27 12:00:00	NVDA	Stock	0.3728	0.3733	0.3708	0.3715	65202560.0
2012-01-27 13:00:00	NVDA	Stock	0.3713	0.373	0.3701	0.3718	41702280.0
2012-01-27 14:00:00	NVDA	Stock	0.3718	0.3723	0.37	0.372	56463320.0
2012-01-27 15:00:00	NVDA	Stock	0.372	0.3748	0.3718	0.3728	109179400.0
2012-01-27 16:00:00	NVDA	Stock	0.373	0.374	0.3712	0.3725	3479320.0
2012-01-27 17:00:00	NVDA	Stock	0.3725	0.3728	0.3725	0.3728	260400.0
2012-01-27 18:00:00	NVDA	Stock	0.3723	0.3723	0.3713	0.3713	165600.0
2012-01-27 19:00:00	NVDA	Stock	0.37	0.3713	0.37	0.3713	20000.0
2012-01-27 08:00:00	AMZN	Stock	9.738	9.738	9.65	9.659	297620.0
2012-01-27 09:00:00	AMZN	Stock	9.6705	9.825	9.6165	9.7433	22613540.0
2012-01-27 10:00:00	AMZN	Stock	9.744	9.7935	9.714	9.756	15313120.0
2012-01-27 11:00:00	AMZN	Stock	9.758	9.7685	9.7054	9.744	9413540.0
2012-01-27 12:00:00	AMZN	Stock	9.745	9.7725	9.72	9.7305	8214640.0
2012-01-27 13:00:00	AMZN	Stock	9.7315	9.753	9.7205	9.7285	6667540.0
2012-01-27 14:00:00	AMZN	Stock	9.728	9.75	9.7	9.74	8441200.0
2012-01-27 15:00:00	AMZN	Stock	9.7415	9.7835	9.735	9.7685	15336720.0
2012-01-27 16:00:00	AMZN	Stock	9.772	9.7925	9.7459	9.78	685100.0

> showing 50 of 43,754 rows — these rows as CSV

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