PREVIEW / stock_1hour / 2015-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-21.parquet
  size:    1.0 MB
  rows:    48,476
  symbols: 3,516

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-21 04:00:00	AAPL	Stock	32.3975	32.41	32.3975	32.41	8800.0
2015-05-21 05:00:00	AAPL	Stock	32.415	32.415	32.415	32.415	2000.0
2015-05-21 06:00:00	AAPL	Stock	32.4475	32.4725	32.425	32.4575	32624.0
2015-05-21 07:00:00	AAPL	Stock	32.4575	32.5225	32.4575	32.495	99132.0
2015-05-21 08:00:00	AAPL	Stock	32.5075	32.51	32.4625	32.4875	316692.0
2015-05-21 09:00:00	AAPL	Stock	32.5	32.6325	32.4575	32.5725	18886672.0
2015-05-21 10:00:00	AAPL	Stock	32.575	32.775	32.5675	32.747	28826756.0
2015-05-21 11:00:00	AAPL	Stock	32.745	32.8475	32.74	32.822	23413068.0
2015-05-21 12:00:00	AAPL	Stock	32.82	32.8725	32.8025	32.855	13468556.0
2015-05-21 13:00:00	AAPL	Stock	32.8575	32.875	32.7575	32.7925	13616192.0
2015-05-21 14:00:00	AAPL	Stock	32.79	32.875	32.78	32.8575	11426676.0
2015-05-21 15:00:00	AAPL	Stock	32.8598	32.9075	32.7875	32.85	25299120.0
2015-05-21 16:00:00	AAPL	Stock	32.8475	32.8675	32.7108	32.8575	7257772.0
2015-05-21 17:00:00	AAPL	Stock	32.8675	32.8975	32.8675	32.89	168924.0
2015-05-21 18:00:00	AAPL	Stock	32.8875	32.9	32.8825	32.895	95848.0
2015-05-21 19:00:00	AAPL	Stock	32.8975	32.9625	32.8928	32.945	300320.0
2015-05-21 04:00:00	MSFT	Stock	47.55	47.55	47.55	47.55	1700.0
2015-05-21 05:00:00	MSFT	Stock	47.43	47.43	47.43	47.43	100.0
2015-05-21 06:00:00	MSFT	Stock	47.44	47.45	47.44	47.45	300.0
2015-05-21 07:00:00	MSFT	Stock	47.49	47.53	47.49	47.49	800.0
2015-05-21 08:00:00	MSFT	Stock	47.5	47.5	47.4	47.4	12667.0
2015-05-21 09:00:00	MSFT	Stock	47.45	47.48	47.005	47.1	3182774.0
2015-05-21 10:00:00	MSFT	Stock	47.1	47.32	47.06	47.27	3629797.0
2015-05-21 11:00:00	MSFT	Stock	47.28	47.56	47.27	47.445	2713959.0
2015-05-21 12:00:00	MSFT	Stock	47.45	47.6	47.38	47.575	1748956.0
2015-05-21 13:00:00	MSFT	Stock	47.58	47.6	47.46	47.48	1375137.0
2015-05-21 14:00:00	MSFT	Stock	47.48	47.59	47.45	47.538	1781934.0
2015-05-21 15:00:00	MSFT	Stock	47.53	47.585	47.39	47.42	4257011.0
2015-05-21 16:00:00	MSFT	Stock	47.42	47.5	47.133	47.5	2960611.0
2015-05-21 17:00:00	MSFT	Stock	47.42	47.42	47.42	47.42	1400.0
2015-05-21 18:00:00	MSFT	Stock	47.5	47.5	47.45	47.45	200.0
2015-05-21 19:00:00	MSFT	Stock	47.45	47.45	47.43	47.44	1700.0
2015-05-21 09:00:00	NVDA	Stock	0.5262	0.5285	0.5232	0.525	20085520.0
2015-05-21 10:00:00	NVDA	Stock	0.5247	0.528	0.5247	0.5256	17966560.0
2015-05-21 11:00:00	NVDA	Stock	0.5255	0.5268	0.5247	0.5262	19898040.0
2015-05-21 12:00:00	NVDA	Stock	0.526	0.5264	0.5245	0.5245	12370520.0
2015-05-21 13:00:00	NVDA	Stock	0.5246	0.5258	0.5242	0.5247	14575840.0
2015-05-21 14:00:00	NVDA	Stock	0.5247	0.526	0.5245	0.5249	20639240.0
2015-05-21 15:00:00	NVDA	Stock	0.525	0.525	0.5218	0.5225	74468400.0
2015-05-21 16:00:00	NVDA	Stock	0.5222	0.5222	0.5222	0.5222	1567320.0
2015-05-21 04:00:00	AMZN	Stock	21.1615	21.1615	21.1615	21.1615	11580.0
2015-05-21 06:00:00	AMZN	Stock	21.2125	21.35	21.2125	21.35	12000.0
2015-05-21 07:00:00	AMZN	Stock	21.35	21.41	21.35	21.4	59080.0
2015-05-21 08:00:00	AMZN	Stock	21.35	21.4385	21.35	21.4	205640.0
2015-05-21 09:00:00	AMZN	Stock	21.396	21.687	21.3756	21.6205	15084760.0
2015-05-21 10:00:00	AMZN	Stock	21.621	21.845	21.6105	21.8	15778120.0
2015-05-21 11:00:00	AMZN	Stock	21.799	21.83	21.7025	21.772	7572140.0
2015-05-21 12:00:00	AMZN	Stock	21.7685	21.7855	21.6875	21.6955	8063620.0
2015-05-21 13:00:00	AMZN	Stock	21.704	21.7245	21.6365	21.657	6092240.0
2015-05-21 14:00:00	AMZN	Stock	21.658	21.728	21.647	21.6565	5487720.0

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

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