PREVIEW / stock_1hour / 2015-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-06.parquet
  size:    1.0 MB
  rows:    48,605
  symbols: 3,525

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-02-06 04:00:00	AAPL	Stock	29.95	29.95	29.9	29.9175	4800.0
2015-02-06 05:00:00	AAPL	Stock	29.9025	29.94	29.9	29.94	2400.0
2015-02-06 06:00:00	AAPL	Stock	29.925	29.925	29.9	29.925	2632.0
2015-02-06 07:00:00	AAPL	Stock	29.95	29.9925	29.95	29.9725	68312.0
2015-02-06 08:00:00	AAPL	Stock	29.965	30.05	29.92	30.0375	1227452.0
2015-02-06 09:00:00	AAPL	Stock	30.0375	30.06	29.8625	29.9475	23564644.0
2015-02-06 10:00:00	AAPL	Stock	29.9475	30.045	29.9325	30.0275	20349668.0
2015-02-06 11:00:00	AAPL	Stock	30.03	30.0625	29.9945	30.06	14433008.0
2015-02-06 12:00:00	AAPL	Stock	30.058	30.0625	29.9275	29.9575	16598780.0
2015-02-06 13:00:00	AAPL	Stock	29.9578	29.9675	29.715	29.855	28351012.0
2015-02-06 14:00:00	AAPL	Stock	29.855	29.93	29.755	29.795	15522528.0
2015-02-06 15:00:00	AAPL	Stock	29.795	29.8	29.6125	29.7275	37268312.0
2015-02-06 16:00:00	AAPL	Stock	29.7325	30.0172	29.69	29.74	6942344.0
2015-02-06 17:00:00	AAPL	Stock	29.7325	29.7475	29.7125	29.7125	226508.0
2015-02-06 18:00:00	AAPL	Stock	29.7125	29.725	29.7075	29.715	59844.0
2015-02-06 19:00:00	AAPL	Stock	29.7175	29.725	29.6925	29.7075	90428.0
2015-02-06 04:00:00	MSFT	Stock	42.55	42.55	42.5	42.5	500.0
2015-02-06 06:00:00	MSFT	Stock	42.5	42.5	42.5	42.5	1700.0
2015-02-06 07:00:00	MSFT	Stock	42.5	42.55	42.49	42.55	745.0
2015-02-06 08:00:00	MSFT	Stock	42.5	42.63	42.4	42.62	12963.0
2015-02-06 09:00:00	MSFT	Stock	42.6	42.79	42.45	42.52	5329804.0
2015-02-06 10:00:00	MSFT	Stock	42.53	42.64	42.5	42.61	3663357.0
2015-02-06 11:00:00	MSFT	Stock	42.61	42.62	42.52	42.55	2704595.0
2015-02-06 12:00:00	MSFT	Stock	42.55	42.61	42.34	42.485	3122193.0
2015-02-06 13:00:00	MSFT	Stock	42.487	42.5	42.25	42.295	3631490.0
2015-02-06 14:00:00	MSFT	Stock	42.29	42.49	42.27	42.28	3713441.0
2015-02-06 15:00:00	MSFT	Stock	42.285	42.42	42.15	42.42	9100238.0
2015-02-06 16:00:00	MSFT	Stock	42.41	42.454	42.343	42.35	2298956.0
2015-02-06 17:00:00	MSFT	Stock	42.4	42.42	42.35	42.4	19180.0
2015-02-06 18:00:00	MSFT	Stock	42.39	42.4	42.39	42.4	500.0
2015-02-06 19:00:00	MSFT	Stock	42.4	42.42	42.4	42.42	600.0
2015-02-06 08:00:00	NVDA	Stock	0.517	0.5175	0.517	0.5175	20000.0
2015-02-06 09:00:00	NVDA	Stock	0.5102	0.5142	0.5095	0.512	22807800.0
2015-02-06 10:00:00	NVDA	Stock	0.5121	0.516	0.5108	0.516	25487840.0
2015-02-06 11:00:00	NVDA	Stock	0.5158	0.5178	0.5158	0.516	19623200.0
2015-02-06 12:00:00	NVDA	Stock	0.516	0.5165	0.5124	0.5142	15691240.0
2015-02-06 13:00:00	NVDA	Stock	0.5145	0.5148	0.5102	0.5112	12553880.0
2015-02-06 14:00:00	NVDA	Stock	0.5115	0.5133	0.5108	0.512	21235200.0
2015-02-06 15:00:00	NVDA	Stock	0.5119	0.5122	0.5078	0.51	58738880.0
2015-02-06 16:00:00	NVDA	Stock	0.51	0.5125	0.51	0.51	24810120.0
2015-02-06 17:00:00	NVDA	Stock	0.5129	0.5129	0.5129	0.5129	540880.0
2015-02-06 05:00:00	AMZN	Stock	18.661	18.661	18.65	18.65	8000.0
2015-02-06 07:00:00	AMZN	Stock	18.6575	18.6575	18.6355	18.6475	26000.0
2015-02-06 08:00:00	AMZN	Stock	18.6365	18.7195	18.6365	18.709	206640.0
2015-02-06 09:00:00	AMZN	Stock	18.702	18.7995	18.6385	18.7085	13046800.0
2015-02-06 10:00:00	AMZN	Stock	18.7085	18.742	18.6185	18.7115	10797840.0
2015-02-06 11:00:00	AMZN	Stock	18.7085	18.7735	18.656	18.751	6864160.0
2015-02-06 12:00:00	AMZN	Stock	18.754	18.765	18.6355	18.677	6891200.0
2015-02-06 13:00:00	AMZN	Stock	18.6802	18.6865	18.5505	18.6105	8648060.0
2015-02-06 14:00:00	AMZN	Stock	18.6116	18.7345	18.5785	18.717	8075380.0

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

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