PREVIEW / stock_1hour / 2013-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-12.parquet
  size:    988 KB
  rows:    45,975
  symbols: 3,494

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
2013-06-12 05:00:00	AAPL	Stock	15.7043	15.7043	15.7043	15.7043	2800.0
2013-06-12 06:00:00	AAPL	Stock	15.7054	15.7286	15.6964	15.7286	51772.0
2013-06-12 07:00:00	AAPL	Stock	15.7321	15.7454	15.7	15.7232	247352.0
2013-06-12 08:00:00	AAPL	Stock	15.7271	15.7454	15.6429	15.7221	1142540.0
2013-06-12 09:00:00	AAPL	Stock	15.7221	15.7589	15.6361	15.6479	41103888.0
2013-06-12 10:00:00	AAPL	Stock	15.6479	15.6511	15.5229	15.5379	53330508.0
2013-06-12 11:00:00	AAPL	Stock	15.5389	15.5854	15.4896	15.5029	31107748.0
2013-06-12 12:00:00	AAPL	Stock	15.5029	15.5614	15.4964	15.5511	23447396.0
2013-06-12 13:00:00	AAPL	Stock	15.555	15.5879	15.53	15.5433	18013744.0
2013-06-12 14:00:00	AAPL	Stock	15.5432	15.5475	15.4896	15.5071	26320588.0
2013-06-12 15:00:00	AAPL	Stock	15.505	15.5071	15.4107	15.4321	54265456.0
2013-06-12 16:00:00	AAPL	Stock	15.4343	15.6458	15.4143	15.6458	13635720.0
2013-06-12 17:00:00	AAPL	Stock	15.425	15.4354	15.4193	15.4193	1079456.0
2013-06-12 18:00:00	AAPL	Stock	15.4193	15.425	15.4179	15.4189	96180.0
2013-06-12 19:00:00	AAPL	Stock	15.4175	15.4214	15.4107	15.4161	146944.0
2013-06-12 08:00:00	MSFT	Stock	34.95	35.0	34.95	34.99	8084.0
2013-06-12 09:00:00	MSFT	Stock	34.99	35.27	34.91	35.127	3473365.0
2013-06-12 10:00:00	MSFT	Stock	35.13	35.22	35.065	35.125	5406850.0
2013-06-12 11:00:00	MSFT	Stock	35.125	35.16	35.01	35.06	6105592.0
2013-06-12 12:00:00	MSFT	Stock	35.06	35.08	34.94	35.035	4405076.0
2013-06-12 13:00:00	MSFT	Stock	35.035	35.11	34.96	35.07	3175692.0
2013-06-12 14:00:00	MSFT	Stock	35.065	35.08	34.85	34.99	3876237.0
2013-06-12 15:00:00	MSFT	Stock	34.985	35.01	34.88	34.99	7077393.0
2013-06-12 16:00:00	MSFT	Stock	34.995	35.06	34.91	35.0	2270511.0
2013-06-12 17:00:00	MSFT	Stock	34.95	35.0	34.93	34.93	8797.0
2013-06-12 18:00:00	MSFT	Stock	34.94	34.95	34.94	34.95	950.0
2013-06-12 19:00:00	MSFT	Stock	34.95	34.95	34.95	34.95	100.0
2013-06-12 09:00:00	NVDA	Stock	0.357	0.3576	0.355	0.3572	30802000.0
2013-06-12 10:00:00	NVDA	Stock	0.357	0.3589	0.355	0.356	36553280.0
2013-06-12 11:00:00	NVDA	Stock	0.3562	0.3572	0.354	0.3546	33229280.0
2013-06-12 12:00:00	NVDA	Stock	0.3546	0.355	0.3493	0.3513	50808960.0
2013-06-12 13:00:00	NVDA	Stock	0.3515	0.3539	0.3508	0.3536	36898920.0
2013-06-12 14:00:00	NVDA	Stock	0.3535	0.3563	0.3525	0.3544	51073160.0
2013-06-12 15:00:00	NVDA	Stock	0.3542	0.3548	0.351	0.3515	63230520.0
2013-06-12 16:00:00	NVDA	Stock	0.3513	0.3542	0.351	0.3542	9642040.0
2013-06-12 17:00:00	NVDA	Stock	0.3513	0.3513	0.3513	0.3513	290640.0
2013-06-12 04:00:00	AMZN	Stock	13.7625	13.7625	13.7625	13.7625	2000.0
2013-06-12 07:00:00	AMZN	Stock	13.804	13.814	13.804	13.814	4000.0
2013-06-12 08:00:00	AMZN	Stock	13.849	13.849	13.75	13.83	123440.0
2013-06-12 09:00:00	AMZN	Stock	13.825	13.8485	13.6625	13.676	10392260.0
2013-06-12 10:00:00	AMZN	Stock	13.676	13.745	13.647	13.651	7116420.0
2013-06-12 11:00:00	AMZN	Stock	13.6555	13.701	13.5975	13.6005	5451180.0
2013-06-12 12:00:00	AMZN	Stock	13.6005	13.643	13.57	13.639	4291380.0
2013-06-12 13:00:00	AMZN	Stock	13.6395	13.675	13.5885	13.6072	2509680.0
2013-06-12 14:00:00	AMZN	Stock	13.6045	13.6544	13.537	13.571	3578560.0
2013-06-12 15:00:00	AMZN	Stock	13.572	13.599	13.5225	13.5835	9371640.0
2013-06-12 16:00:00	AMZN	Stock	13.5755	13.6506	13.5615	13.5835	460060.0
2013-06-12 17:00:00	AMZN	Stock	13.5835	13.5835	13.5835	13.5835	7440.0
2013-06-12 18:00:00	AMZN	Stock	13.577	13.578	13.5645	13.578	18720.0
2013-06-12 19:00:00	AMZN	Stock	13.578	13.5785	13.578	13.5785	6500.0

> showing 50 of 45,975 rows — these rows as CSV

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