PREVIEW / stock_1hour / 2011-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-05.parquet
  size:    947 KB
  rows:    44,627
  symbols: 3,528

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-01-05 04:00:00	AAPL	Stock	11.5714	11.8161	11.5714	11.8125	8400.0
2011-01-05 05:00:00	AAPL	Stock	11.7886	11.8	11.7886	11.8	33600.0
2011-01-05 06:00:00	AAPL	Stock	11.7929	11.7929	11.7746	11.7839	25200.0
2011-01-05 07:00:00	AAPL	Stock	11.7618	11.7757	11.75	11.7625	211400.0
2011-01-05 08:00:00	AAPL	Stock	11.7536	11.8189	11.7532	11.7893	3755808.0
2011-01-05 09:00:00	AAPL	Stock	11.7932	11.8429	11.765	11.8304	42242060.0
2011-01-05 10:00:00	AAPL	Stock	11.8279	11.8746	11.8164	11.8663	44445044.0
2011-01-05 11:00:00	AAPL	Stock	11.8661	11.8989	11.8614	11.8889	35381556.0
2011-01-05 12:00:00	AAPL	Stock	11.8889	11.9375	11.8839	11.9341	33595268.0
2011-01-05 13:00:00	AAPL	Stock	11.9339	11.9393	11.9156	11.9368	22082032.0
2011-01-05 14:00:00	AAPL	Stock	11.9365	11.9365	11.9107	11.9286	22163568.0
2011-01-05 15:00:00	AAPL	Stock	11.9286	11.9407	11.915	11.9286	42153356.0
2011-01-05 16:00:00	AAPL	Stock	11.9286	11.9343	11.7605	11.9311	5723032.0
2011-01-05 17:00:00	AAPL	Stock	11.9307	11.9589	11.9307	11.9482	700476.0
2011-01-05 18:00:00	AAPL	Stock	11.9536	11.9586	11.9286	11.9518	351596.0
2011-01-05 19:00:00	AAPL	Stock	11.9536	11.9571	11.9496	11.9571	342664.0
2011-01-05 04:00:00	MSFT	Stock	28.02	28.02	28.02	28.02	400.0
2011-01-05 07:00:00	MSFT	Stock	27.82	27.82	27.82	27.82	900.0
2011-01-05 08:00:00	MSFT	Stock	27.85	28.04	27.85	28.0	27933.0
2011-01-05 09:00:00	MSFT	Stock	28.0	28.04	27.81	27.859	9008236.0
2011-01-05 10:00:00	MSFT	Stock	27.855	27.91	27.77	27.837	8932134.0
2011-01-05 11:00:00	MSFT	Stock	27.84	27.91	27.8	27.82	6446033.0
2011-01-05 12:00:00	MSFT	Stock	27.83	27.9	27.82	27.855	6007558.0
2011-01-05 13:00:00	MSFT	Stock	27.86	27.89	27.78	27.88	6732044.0
2011-01-05 14:00:00	MSFT	Stock	27.89	27.97	27.87	27.965	8809156.0
2011-01-05 15:00:00	MSFT	Stock	27.96	28.01	27.96	28.0	8789482.0
2011-01-05 16:00:00	MSFT	Stock	28.0	28.02	27.894	28.0	1375931.0
2011-01-05 17:00:00	MSFT	Stock	28.0	28.0	27.98	27.98	8631.0
2011-01-05 18:00:00	MSFT	Stock	27.99	28.0	27.98	27.98	9243.0
2011-01-05 19:00:00	MSFT	Stock	27.98	28.01	27.95	28.01	8468.0
2011-01-05 07:00:00	NVDA	Stock	0.395	0.3995	0.395	0.3995	320000.0
2011-01-05 08:00:00	NVDA	Stock	0.397	0.405	0.3965	0.4035	2608120.0
2011-01-05 09:00:00	NVDA	Stock	0.4035	0.4085	0.3975	0.405	187064720.0
2011-01-05 10:00:00	NVDA	Stock	0.4053	0.4065	0.4008	0.4062	169729040.0
2011-01-05 11:00:00	NVDA	Stock	0.406	0.4112	0.4055	0.4095	138975800.0
2011-01-05 12:00:00	NVDA	Stock	0.4094	0.4162	0.4093	0.4148	183780920.0
2011-01-05 13:00:00	NVDA	Stock	0.4148	0.4186	0.412	0.4185	147502520.0
2011-01-05 14:00:00	NVDA	Stock	0.4184	0.42	0.4168	0.4182	137054000.0
2011-01-05 15:00:00	NVDA	Stock	0.418	0.425	0.4175	0.4248	414228880.0
2011-01-05 16:00:00	NVDA	Stock	0.4248	0.4262	0.4126	0.426	8196080.0
2011-01-05 17:00:00	NVDA	Stock	0.4262	0.4275	0.4245	0.4272	757480.0
2011-01-05 18:00:00	NVDA	Stock	0.4272	0.4288	0.4258	0.4288	854360.0
2011-01-05 19:00:00	NVDA	Stock	0.4293	0.4325	0.4293	0.4312	1657400.0
2011-01-05 07:00:00	AMZN	Stock	9.23	9.23	9.23	9.23	2000.0
2011-01-05 08:00:00	AMZN	Stock	9.2	9.2385	9.185	9.22	175700.0
2011-01-05 09:00:00	AMZN	Stock	9.238	9.318	9.201	9.2823	12224620.0
2011-01-05 10:00:00	AMZN	Stock	9.2805	9.3225	9.2595	9.285	12619300.0
2011-01-05 11:00:00	AMZN	Stock	9.283	9.3445	9.2805	9.31	10044600.0
2011-01-05 12:00:00	AMZN	Stock	9.3092	9.3425	9.304	9.3341	6708620.0
2011-01-05 13:00:00	AMZN	Stock	9.335	9.338	9.3105	9.33	4661760.0

> showing 50 of 44,627 rows — these rows as CSV

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