PREVIEW / stock_1hour / 2014-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-07.parquet
  size:    1.1 MB
  rows:    50,976
  symbols: 3,594

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
2014-07-07 04:00:00	AAPL	Stock	23.5125	23.515	23.5025	23.5025	8300.0
2014-07-07 05:00:00	AAPL	Stock	23.4975	23.515	23.4975	23.51	2320.0
2014-07-07 06:00:00	AAPL	Stock	23.5175	23.5325	23.5175	23.525	7284.0
2014-07-07 07:00:00	AAPL	Stock	23.525	23.5475	23.5125	23.5175	63936.0
2014-07-07 08:00:00	AAPL	Stock	23.5225	23.5475	23.475	23.495	519192.0
2014-07-07 09:00:00	AAPL	Stock	23.495	23.7475	23.4925	23.7475	32560652.0
2014-07-07 10:00:00	AAPL	Stock	23.7462	23.8675	23.69	23.8462	47127532.0
2014-07-07 11:00:00	AAPL	Stock	23.8475	23.85	23.69	23.695	26943660.0
2014-07-07 12:00:00	AAPL	Stock	23.695	23.7825	23.69	23.7805	13929428.0
2014-07-07 13:00:00	AAPL	Stock	23.781	23.8475	23.76	23.845	14007496.0
2014-07-07 14:00:00	AAPL	Stock	23.8462	23.9225	23.82	23.915	23724632.0
2014-07-07 15:00:00	AAPL	Stock	23.9125	23.9975	23.8975	23.9925	38212620.0
2014-07-07 16:00:00	AAPL	Stock	23.9925	24.05	23.7628	24.045	7697872.0
2014-07-07 17:00:00	AAPL	Stock	24.045	24.0925	23.887	24.065	6497496.0
2014-07-07 18:00:00	AAPL	Stock	24.07	24.0775	23.9925	24.0625	351732.0
2014-07-07 19:00:00	AAPL	Stock	24.065	24.0725	24.04	24.0725	264672.0
2014-07-07 08:00:00	MSFT	Stock	41.61	41.61	41.6	41.6	852.0
2014-07-07 09:00:00	MSFT	Stock	41.71	41.92	41.7	41.9	2566156.0
2014-07-07 10:00:00	MSFT	Stock	41.89	42.09	41.84	42.03	3773965.0
2014-07-07 11:00:00	MSFT	Stock	42.025	42.12	42.0	42.08	3142140.0
2014-07-07 12:00:00	MSFT	Stock	42.075	42.1	42.015	42.08	1584535.0
2014-07-07 13:00:00	MSFT	Stock	42.09	42.1	42.055	42.06	1294478.0
2014-07-07 14:00:00	MSFT	Stock	42.06	42.07	42.0	42.04	1830003.0
2014-07-07 15:00:00	MSFT	Stock	42.04	42.055	41.92	41.985	4682758.0
2014-07-07 16:00:00	MSFT	Stock	41.98	42.08	41.98	41.98	1897779.0
2014-07-07 17:00:00	MSFT	Stock	41.98	42.032	41.98	42.01	63766.0
2014-07-07 18:00:00	MSFT	Stock	41.97	41.97	41.95	41.95	1000.0
2014-07-07 08:00:00	NVDA	Stock	0.4723	0.4723	0.4723	0.4723	10000.0
2014-07-07 09:00:00	NVDA	Stock	0.4728	0.4728	0.4698	0.4705	14053560.0
2014-07-07 10:00:00	NVDA	Stock	0.4705	0.4713	0.4692	0.4698	24799760.0
2014-07-07 11:00:00	NVDA	Stock	0.4698	0.4715	0.4692	0.4708	16474240.0
2014-07-07 12:00:00	NVDA	Stock	0.4706	0.472	0.47	0.4708	16651280.0
2014-07-07 13:00:00	NVDA	Stock	0.4706	0.4715	0.4698	0.4702	8022080.0
2014-07-07 14:00:00	NVDA	Stock	0.47	0.4702	0.4678	0.4685	10884840.0
2014-07-07 15:00:00	NVDA	Stock	0.4685	0.4685	0.4668	0.4675	24905960.0
2014-07-07 16:00:00	NVDA	Stock	0.4678	0.4678	0.4676	0.4676	1584080.0
2014-07-07 17:00:00	NVDA	Stock	0.4678	0.4678	0.4678	0.4678	139640.0
2014-07-07 19:00:00	NVDA	Stock	0.47	0.47	0.47	0.47	5000.0
2014-07-07 07:00:00	AMZN	Stock	16.868	16.868	16.868	16.868	2000.0
2014-07-07 08:00:00	AMZN	Stock	16.8515	16.875	16.82	16.86	78000.0
2014-07-07 09:00:00	AMZN	Stock	16.853	16.8855	16.6766	16.7235	8368040.0
2014-07-07 10:00:00	AMZN	Stock	16.723	16.795	16.675	16.676	7355420.0
2014-07-07 11:00:00	AMZN	Stock	16.676	16.736	16.626	16.63	5429520.0
2014-07-07 12:00:00	AMZN	Stock	16.631	16.6875	16.6275	16.684	1859040.0
2014-07-07 13:00:00	AMZN	Stock	16.6875	16.7235	16.6605	16.6974	2713780.0
2014-07-07 14:00:00	AMZN	Stock	16.691	16.71	16.6285	16.658	2714860.0
2014-07-07 15:00:00	AMZN	Stock	16.657	16.6855	16.6375	16.674	7886760.0
2014-07-07 16:00:00	AMZN	Stock	16.6775	16.704	16.6305	16.6305	258860.0
2014-07-07 17:00:00	AMZN	Stock	16.6775	16.6775	16.633	16.633	24000.0
2014-07-07 18:00:00	AMZN	Stock	16.67	16.6865	16.67	16.6865	15500.0

> showing 50 of 50,976 rows — these rows as CSV

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