PREVIEW / stock_1hour / 2011-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-14.parquet
  size:    909 KB
  rows:    43,586
  symbols: 3,496

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
2011-09-14 04:00:00	AAPL	Stock	13.7143	13.7143	13.6893	13.6893	11200.0
2011-09-14 05:00:00	AAPL	Stock	13.6964	13.735	13.6964	13.7286	33600.0
2011-09-14 06:00:00	AAPL	Stock	13.725	13.8107	13.725	13.8107	57400.0
2011-09-14 07:00:00	AAPL	Stock	13.81	13.87	13.8089	13.8264	1085616.0
2011-09-14 08:00:00	AAPL	Stock	13.8343	13.845	13.8	13.8214	2450140.0
2011-09-14 09:00:00	AAPL	Stock	13.8182	13.8914	13.8036	13.8725	77077896.0
2011-09-14 10:00:00	AAPL	Stock	13.8725	13.8868	13.7771	13.8625	100443560.0
2011-09-14 11:00:00	AAPL	Stock	13.86	13.9286	13.8525	13.9207	61154296.0
2011-09-14 12:00:00	AAPL	Stock	13.9214	13.9286	13.8732	13.9046	39711588.0
2011-09-14 13:00:00	AAPL	Stock	13.9037	13.9575	13.9004	13.9307	48402004.0
2011-09-14 14:00:00	AAPL	Stock	13.9307	13.9796	13.9282	13.9707	60476724.0
2011-09-14 15:00:00	AAPL	Stock	13.9721	14.0075	13.8943	13.9029	126728196.0
2011-09-14 16:00:00	AAPL	Stock	13.9039	14.001	13.7364	13.9036	12433568.0
2011-09-14 17:00:00	AAPL	Stock	13.8932	13.8946	13.8793	13.8929	216076.0
2011-09-14 18:00:00	AAPL	Stock	13.8957	13.9036	13.8871	13.8968	264180.0
2011-09-14 19:00:00	AAPL	Stock	13.8989	13.9057	13.8971	13.9	232204.0
2011-09-14 04:00:00	MSFT	Stock	26.0	26.0	26.0	26.0	200.0
2011-09-14 07:00:00	MSFT	Stock	26.23	26.26	26.17	26.26	600.0
2011-09-14 08:00:00	MSFT	Stock	26.2	26.26	26.16	26.2	40139.0
2011-09-14 09:00:00	MSFT	Stock	26.2	26.25	26.02	26.18	4929937.0
2011-09-14 10:00:00	MSFT	Stock	26.19	26.19	25.89	26.06	12572146.0
2011-09-14 11:00:00	MSFT	Stock	26.06	26.34	25.99	26.33	7386585.0
2011-09-14 12:00:00	MSFT	Stock	26.34	26.37	26.22	26.235	6406916.0
2011-09-14 13:00:00	MSFT	Stock	26.23	26.43	26.22	26.34	5899723.0
2011-09-14 14:00:00	MSFT	Stock	26.35	26.58	26.34	26.56	7802254.0
2011-09-14 15:00:00	MSFT	Stock	26.57	26.8	26.49	26.5	17208708.0
2011-09-14 16:00:00	MSFT	Stock	26.5	26.767	26.04	26.5	3068788.0
2011-09-14 17:00:00	MSFT	Stock	26.54	26.58	26.45	26.51	77686.0
2011-09-14 18:00:00	MSFT	Stock	26.51	26.51	26.49	26.5	39136.0
2011-09-14 19:00:00	MSFT	Stock	26.55	26.58	26.49	26.55	3005.0
2011-09-14 07:00:00	NVDA	Stock	0.376	0.3773	0.373	0.3738	512800.0
2011-09-14 08:00:00	NVDA	Stock	0.375	0.376	0.3725	0.3733	3425400.0
2011-09-14 09:00:00	NVDA	Stock	0.373	0.3813	0.3723	0.379	278593960.0
2011-09-14 10:00:00	NVDA	Stock	0.379	0.3798	0.3725	0.3785	313113480.0
2011-09-14 11:00:00	NVDA	Stock	0.3785	0.384	0.3775	0.3813	191310200.0
2011-09-14 12:00:00	NVDA	Stock	0.3813	0.3838	0.3785	0.3833	128592840.0
2011-09-14 13:00:00	NVDA	Stock	0.3834	0.385	0.3818	0.3835	125812960.0
2011-09-14 14:00:00	NVDA	Stock	0.3835	0.385	0.3815	0.3833	162654840.0
2011-09-14 15:00:00	NVDA	Stock	0.3835	0.3868	0.3815	0.382	278949080.0
2011-09-14 16:00:00	NVDA	Stock	0.3813	0.3858	0.3632	0.3818	17066600.0
2011-09-14 17:00:00	NVDA	Stock	0.3813	0.3813	0.3795	0.3808	439880.0
2011-09-14 18:00:00	NVDA	Stock	0.3815	0.3842	0.3808	0.3815	171920.0
2011-09-14 19:00:00	NVDA	Stock	0.3815	0.383	0.3815	0.383	223800.0
2011-09-14 05:00:00	AMZN	Stock	10.9795	10.9795	10.9795	10.9795	2000.0
2011-09-14 06:00:00	AMZN	Stock	10.9995	11.01	10.9995	11.01	24000.0
2011-09-14 07:00:00	AMZN	Stock	11.05	11.075	11.025	11.0565	63000.0
2011-09-14 08:00:00	AMZN	Stock	11.036	11.055	11.0	11.047	191080.0
2011-09-14 09:00:00	AMZN	Stock	11.0375	11.048	10.9308	10.9645	15602280.0
2011-09-14 10:00:00	AMZN	Stock	10.965	11.03	10.8362	11.0165	17759360.0
2011-09-14 11:00:00	AMZN	Stock	11.0165	11.1235	11.004	11.1195	15755720.0

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

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