PREVIEW / stock_1hour / 2015-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-17.parquet
  size:    1.0 MB
  rows:    48,629
  symbols: 3,457

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-08-17 04:00:00	AAPL	Stock	28.9925	29.0875	28.9925	29.0875	13200.0
2015-08-17 05:00:00	AAPL	Stock	29.1	29.1	29.0925	29.0925	980.0
2015-08-17 06:00:00	AAPL	Stock	29.0975	29.105	29.05	29.05	58424.0
2015-08-17 07:00:00	AAPL	Stock	29.09	29.09	28.9725	29.025	87936.0
2015-08-17 08:00:00	AAPL	Stock	29.025	29.0875	28.9575	28.975	716632.0
2015-08-17 09:00:00	AAPL	Stock	28.9775	29.1225	28.875	29.0075	23014592.0
2015-08-17 10:00:00	AAPL	Stock	29.0075	29.3175	28.9925	29.2975	33108052.0
2015-08-17 11:00:00	AAPL	Stock	29.2975	29.39	29.2	29.355	27442668.0
2015-08-17 12:00:00	AAPL	Stock	29.355	29.3825	29.265	29.345	16692860.0
2015-08-17 13:00:00	AAPL	Stock	29.345	29.4125	29.3225	29.3538	14774468.0
2015-08-17 14:00:00	AAPL	Stock	29.3525	29.405	29.2725	29.32	13670828.0
2015-08-17 15:00:00	AAPL	Stock	29.3225	29.33	29.255	29.2925	20562564.0
2015-08-17 16:00:00	AAPL	Stock	29.29	29.32	28.9872	29.3118	5380496.0
2015-08-17 17:00:00	AAPL	Stock	29.305	29.31	29.29	29.3025	103276.0
2015-08-17 18:00:00	AAPL	Stock	29.3025	29.31	29.2975	29.31	52472.0
2015-08-17 19:00:00	AAPL	Stock	29.31	29.31	29.295	29.295	38532.0
2015-08-17 08:00:00	MSFT	Stock	47.01	47.01	46.9	46.9	3002.0
2015-08-17 09:00:00	MSFT	Stock	46.9	46.93	46.57	46.7	2169379.0
2015-08-17 10:00:00	MSFT	Stock	46.691	47.09	46.66	47.01	3551849.0
2015-08-17 11:00:00	MSFT	Stock	47.01	47.14	47.0	47.09	2371859.0
2015-08-17 12:00:00	MSFT	Stock	47.08	47.24	47.08	47.23	1355558.0
2015-08-17 13:00:00	MSFT	Stock	47.224	47.41	47.22	47.345	1581874.0
2015-08-17 14:00:00	MSFT	Stock	47.34	47.41	47.26	47.39	1685029.0
2015-08-17 15:00:00	MSFT	Stock	47.398	47.45	47.28	47.32	3940743.0
2015-08-17 16:00:00	MSFT	Stock	47.32	47.36	47.263	47.263	3378387.0
2015-08-17 18:00:00	MSFT	Stock	47.35	47.35	47.32	47.32	51404.0
2015-08-17 19:00:00	MSFT	Stock	47.33	47.39	47.33	47.39	850.0
2015-08-17 08:00:00	NVDA	Stock	0.5908	0.5998	0.5885	0.5885	76360.0
2015-08-17 09:00:00	NVDA	Stock	0.5875	0.5875	0.5775	0.58	42459840.0
2015-08-17 10:00:00	NVDA	Stock	0.5802	0.5848	0.58	0.5819	46781160.0
2015-08-17 11:00:00	NVDA	Stock	0.582	0.584	0.581	0.5821	40909960.0
2015-08-17 12:00:00	NVDA	Stock	0.582	0.5853	0.5816	0.5845	17872640.0
2015-08-17 13:00:00	NVDA	Stock	0.5846	0.5861	0.5828	0.5828	23164600.0
2015-08-17 14:00:00	NVDA	Stock	0.583	0.5848	0.5825	0.5838	28232960.0
2015-08-17 15:00:00	NVDA	Stock	0.5838	0.585	0.5826	0.5848	56722360.0
2015-08-17 16:00:00	NVDA	Stock	0.5848	0.5848	0.5842	0.5845	900920.0
2015-08-17 19:00:00	NVDA	Stock	0.5843	0.5843	0.5843	0.5843	4000.0
2015-08-17 04:00:00	AMZN	Stock	26.6	26.6	26.5585	26.5745	6000.0
2015-08-17 08:00:00	AMZN	Stock	26.52	26.5275	26.51	26.5275	50940.0
2015-08-17 09:00:00	AMZN	Stock	26.5276	26.662	26.402	26.4335	6618180.0
2015-08-17 10:00:00	AMZN	Stock	26.4245	26.64	26.356	26.6208	7106640.0
2015-08-17 11:00:00	AMZN	Stock	26.6208	26.723	26.6	26.6585	3315920.0
2015-08-17 12:00:00	AMZN	Stock	26.6642	26.8975	26.6519	26.8913	4479780.0
2015-08-17 13:00:00	AMZN	Stock	26.8882	26.937	26.8265	26.832	6015640.0
2015-08-17 14:00:00	AMZN	Stock	26.832	26.8579	26.7605	26.782	5929900.0
2015-08-17 15:00:00	AMZN	Stock	26.7885	26.7945	26.7015	26.765	10348260.0
2015-08-17 16:00:00	AMZN	Stock	26.761	26.796	26.7072	26.77	368520.0
2015-08-17 17:00:00	AMZN	Stock	26.77	26.77	26.737	26.737	81100.0
2015-08-17 18:00:00	AMZN	Stock	26.7545	26.7598	26.75	26.75	16440.0
2015-08-17 19:00:00	AMZN	Stock	26.7594	26.7594	26.7594	26.7594	2000.0

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

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