PREVIEW / stock_1hour / 2015-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-08.parquet
  size:    1.0 MB
  rows:    48,877
  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
2015-05-08 04:00:00	AAPL	Stock	31.505	31.505	31.375	31.4375	12792.0
2015-05-08 05:00:00	AAPL	Stock	31.4475	31.575	31.4475	31.5325	42548.0
2015-05-08 06:00:00	AAPL	Stock	31.5125	31.5225	31.45	31.4925	11336.0
2015-05-08 07:00:00	AAPL	Stock	31.475	31.475	31.4125	31.4375	135168.0
2015-05-08 08:00:00	AAPL	Stock	31.44	31.6475	31.38	31.625	1758832.0
2015-05-08 09:00:00	AAPL	Stock	31.6375	31.795	31.5275	31.7352	36133908.0
2015-05-08 10:00:00	AAPL	Stock	31.74	31.76	31.6	31.7125	22745788.0
2015-05-08 11:00:00	AAPL	Stock	31.7125	31.8775	31.7	31.835	22957392.0
2015-05-08 12:00:00	AAPL	Stock	31.835	31.8675	31.7575	31.8012	14267748.0
2015-05-08 13:00:00	AAPL	Stock	31.8	31.8962	31.78	31.81	17074652.0
2015-05-08 14:00:00	AAPL	Stock	31.81	31.85	31.77	31.8425	12525192.0
2015-05-08 15:00:00	AAPL	Stock	31.8435	31.905	31.8038	31.9	29525012.0
2015-05-08 16:00:00	AAPL	Stock	31.9	31.935	31.791	31.875	21055580.0
2015-05-08 17:00:00	AAPL	Stock	31.8575	31.875	31.855	31.8625	142084.0
2015-05-08 18:00:00	AAPL	Stock	31.8652	31.875	31.8575	31.86	107956.0
2015-05-08 19:00:00	AAPL	Stock	31.865	31.8725	31.855	31.86	128148.0
2015-05-08 07:00:00	MSFT	Stock	47.01	47.01	46.88	46.88	1300.0
2015-05-08 08:00:00	MSFT	Stock	46.9	47.45	46.9	47.4	76088.0
2015-05-08 09:00:00	MSFT	Stock	47.43	47.98	47.33	47.76	6474558.0
2015-05-08 10:00:00	MSFT	Stock	47.76	47.83	47.59	47.71	4888869.0
2015-05-08 11:00:00	MSFT	Stock	47.7	47.8	47.565	47.78	3361051.0
2015-05-08 12:00:00	MSFT	Stock	47.77	47.83	47.63	47.706	2546169.0
2015-05-08 13:00:00	MSFT	Stock	47.705	47.78	47.67	47.715	2279908.0
2015-05-08 14:00:00	MSFT	Stock	47.71	47.74	47.63	47.73	2784220.0
2015-05-08 15:00:00	MSFT	Stock	47.72	47.84	47.66	47.72	5582026.0
2015-05-08 16:00:00	MSFT	Stock	47.75	47.778	47.67	47.778	4661813.0
2015-05-08 17:00:00	MSFT	Stock	47.74	47.74	47.74	47.74	300.0
2015-05-08 18:00:00	MSFT	Stock	47.7	47.75	47.7	47.75	1501.0
2015-05-08 19:00:00	MSFT	Stock	47.749	47.75	47.749	47.75	1800.0
2015-05-08 07:00:00	NVDA	Stock	0.5505	0.5505	0.53	0.53	578600.0
2015-05-08 08:00:00	NVDA	Stock	0.5338	0.5425	0.5338	0.5358	6520520.0
2015-05-08 09:00:00	NVDA	Stock	0.5358	0.546	0.52	0.5296	228312360.0
2015-05-08 10:00:00	NVDA	Stock	0.5299	0.535	0.5255	0.5274	160125040.0
2015-05-08 11:00:00	NVDA	Stock	0.5272	0.5315	0.5192	0.5192	128188400.0
2015-05-08 12:00:00	NVDA	Stock	0.5194	0.5235	0.5122	0.5162	115818560.0
2015-05-08 13:00:00	NVDA	Stock	0.5162	0.5232	0.5145	0.5232	97126400.0
2015-05-08 14:00:00	NVDA	Stock	0.523	0.5245	0.5175	0.5238	96464960.0
2015-05-08 15:00:00	NVDA	Stock	0.5238	0.5247	0.5186	0.5207	199660120.0
2015-05-08 16:00:00	NVDA	Stock	0.5202	0.5206	0.5198	0.5206	80327400.0
2015-05-08 17:00:00	NVDA	Stock	0.5202	0.5202	0.5192	0.5192	49000.0
2015-05-08 18:00:00	NVDA	Stock	0.5192	0.5192	0.5188	0.5188	22000.0
2015-05-08 19:00:00	NVDA	Stock	0.5192	0.5205	0.5192	0.5205	54000.0
2015-05-08 08:00:00	AMZN	Stock	21.336	21.5035	21.336	21.5035	590220.0
2015-05-08 09:00:00	AMZN	Stock	21.514	21.681	21.495	21.638	9948780.0
2015-05-08 10:00:00	AMZN	Stock	21.6355	21.675	21.5775	21.6583	7295720.0
2015-05-08 11:00:00	AMZN	Stock	21.6625	21.7575	21.6625	21.7542	8792860.0
2015-05-08 12:00:00	AMZN	Stock	21.751	21.76	21.7075	21.7125	5910320.0
2015-05-08 13:00:00	AMZN	Stock	21.7155	21.724	21.689	21.701	5671440.0
2015-05-08 14:00:00	AMZN	Stock	21.699	21.7225	21.6565	21.667	5587860.0
2015-05-08 15:00:00	AMZN	Stock	21.664	21.7249	21.6345	21.6835	11761320.0

> showing 50 of 48,877 rows — these rows as CSV

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