PREVIEW / stock_1hour / 2015-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-01.parquet
  size:    1.0 MB
  rows:    48,912
  symbols: 3,503

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-06-01 04:00:00	AAPL	Stock	32.5	32.7175	32.5	32.7175	44388.0
2015-06-01 05:00:00	AAPL	Stock	32.6	32.6	32.6	32.6	400.0
2015-06-01 06:00:00	AAPL	Stock	32.605	32.675	32.605	32.6425	32900.0
2015-06-01 07:00:00	AAPL	Stock	32.64	32.775	32.64	32.765	109300.0
2015-06-01 08:00:00	AAPL	Stock	32.75	32.775	32.65	32.7375	688904.0
2015-06-01 09:00:00	AAPL	Stock	32.735	32.865	32.535	32.6775	26623620.0
2015-06-01 10:00:00	AAPL	Stock	32.6775	32.7425	32.5125	32.6325	24303072.0
2015-06-01 11:00:00	AAPL	Stock	32.6325	32.715	32.57	32.5912	12264348.0
2015-06-01 12:00:00	AAPL	Stock	32.5912	32.7488	32.5775	32.7328	13182056.0
2015-06-01 13:00:00	AAPL	Stock	32.7362	32.75	32.675	32.6965	9656608.0
2015-06-01 14:00:00	AAPL	Stock	32.6975	32.7175	32.6425	32.6965	9597700.0
2015-06-01 15:00:00	AAPL	Stock	32.696	32.7125	32.5925	32.6325	14749636.0
2015-06-01 16:00:00	AAPL	Stock	32.6275	32.6948	32.605	32.6948	5118000.0
2015-06-01 17:00:00	AAPL	Stock	32.6325	32.6825	32.6325	32.67	245544.0
2015-06-01 18:00:00	AAPL	Stock	32.6625	32.67	32.635	32.6625	105068.0
2015-06-01 19:00:00	AAPL	Stock	32.6575	32.675	32.655	32.6725	83624.0
2015-06-01 04:00:00	MSFT	Stock	47.07	47.07	47.07	47.07	100.0
2015-06-01 05:00:00	MSFT	Stock	46.97	46.97	46.97	46.97	100.0
2015-06-01 06:00:00	MSFT	Stock	46.93	46.97	46.93	46.97	922.0
2015-06-01 07:00:00	MSFT	Stock	46.91	46.99	46.9	46.99	2900.0
2015-06-01 08:00:00	MSFT	Stock	47.17	47.22	47.12	47.16	19000.0
2015-06-01 09:00:00	MSFT	Stock	46.86	47.3	46.76	46.82	3526231.0
2015-06-01 10:00:00	MSFT	Stock	46.83	47.02	46.62	46.905	4207370.0
2015-06-01 11:00:00	MSFT	Stock	46.905	47.2	46.89	47.105	2695020.0
2015-06-01 12:00:00	MSFT	Stock	47.105	47.54	47.09	47.52	2687920.0
2015-06-01 13:00:00	MSFT	Stock	47.52	47.77	47.5	47.605	3213617.0
2015-06-01 14:00:00	MSFT	Stock	47.605	47.68	47.48	47.55	2235801.0
2015-06-01 15:00:00	MSFT	Stock	47.55	47.61	47.2	47.24	5819168.0
2015-06-01 16:00:00	MSFT	Stock	47.23	47.33	47.229	47.254	2406628.0
2015-06-01 17:00:00	MSFT	Stock	47.23	47.23	47.23	47.23	15500.0
2015-06-01 18:00:00	MSFT	Stock	47.23	47.23	47.15	47.23	380.0
2015-06-01 19:00:00	MSFT	Stock	47.2	47.23	47.2	47.21	700.0
2015-06-01 07:00:00	NVDA	Stock	0.553	0.553	0.553	0.553	12000.0
2015-06-01 08:00:00	NVDA	Stock	0.557	0.5572	0.557	0.5572	24000.0
2015-06-01 09:00:00	NVDA	Stock	0.5572	0.562	0.5558	0.559	48109520.0
2015-06-01 10:00:00	NVDA	Stock	0.559	0.5595	0.5535	0.5545	45111520.0
2015-06-01 11:00:00	NVDA	Stock	0.5548	0.5562	0.5532	0.5559	38733320.0
2015-06-01 12:00:00	NVDA	Stock	0.5558	0.5645	0.5558	0.5642	59769280.0
2015-06-01 13:00:00	NVDA	Stock	0.564	0.565	0.5622	0.5636	37757880.0
2015-06-01 14:00:00	NVDA	Stock	0.5636	0.5638	0.5615	0.5615	19738640.0
2015-06-01 15:00:00	NVDA	Stock	0.5618	0.5624	0.559	0.5595	50482560.0
2015-06-01 16:00:00	NVDA	Stock	0.5595	0.5595	0.5592	0.5592	66981120.0
2015-06-01 17:00:00	NVDA	Stock	0.5595	0.5595	0.5595	0.5595	4000.0
2015-06-01 18:00:00	NVDA	Stock	0.561	0.561	0.561	0.561	36000.0
2015-06-01 19:00:00	NVDA	Stock	0.561	0.561	0.561	0.561	8000.0
2015-06-01 07:00:00	AMZN	Stock	21.51	21.51	21.51	21.51	12000.0
2015-06-01 08:00:00	AMZN	Stock	21.51	21.63	21.51	21.5185	54280.0
2015-06-01 09:00:00	AMZN	Stock	21.5515	21.65	21.4345	21.492	8321400.0
2015-06-01 10:00:00	AMZN	Stock	21.4952	21.575	21.31	21.441	8264980.0
2015-06-01 11:00:00	AMZN	Stock	21.4435	21.486	21.422	21.4485	3992380.0

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

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