PREVIEW / stock_1hour / 2014-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-22.parquet
  size:    1.0 MB
  rows:    48,677
  symbols: 3,572

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
2014-07-22 04:00:00	AAPL	Stock	23.625	23.65	23.625	23.65	44504.0
2014-07-22 05:00:00	AAPL	Stock	23.6825	23.7125	23.6825	23.7	47996.0
2014-07-22 06:00:00	AAPL	Stock	23.7	23.7075	23.6875	23.6875	60900.0
2014-07-22 07:00:00	AAPL	Stock	23.695	23.71	23.6525	23.6525	608044.0
2014-07-22 08:00:00	AAPL	Stock	23.665	23.71	23.6075	23.6475	1060132.0
2014-07-22 09:00:00	AAPL	Stock	23.6475	23.7175	23.5375	23.5675	26613316.0
2014-07-22 10:00:00	AAPL	Stock	23.568	23.645	23.5425	23.582	25727756.0
2014-07-22 11:00:00	AAPL	Stock	23.58	23.6025	23.53	23.5538	21077040.0
2014-07-22 12:00:00	AAPL	Stock	23.5538	23.5925	23.55	23.5825	13609992.0
2014-07-22 13:00:00	AAPL	Stock	23.5812	23.625	23.5675	23.6	14830412.0
2014-07-22 14:00:00	AAPL	Stock	23.6	23.6125	23.535	23.5925	19122140.0
2014-07-22 15:00:00	AAPL	Stock	23.5918	23.7225	23.58	23.675	44560084.0
2014-07-22 16:00:00	AAPL	Stock	23.675	23.8175	23.2	23.6	23977932.0
2014-07-22 17:00:00	AAPL	Stock	23.605	23.68	23.5	23.525	4541108.0
2014-07-22 18:00:00	AAPL	Stock	23.52	23.68	23.5025	23.55	1106168.0
2014-07-22 19:00:00	AAPL	Stock	23.545	23.56	23.5375	23.5375	888908.0
2014-07-22 05:00:00	MSFT	Stock	44.74	44.74	44.74	44.74	200.0
2014-07-22 06:00:00	MSFT	Stock	44.78	45.0	44.78	45.0	1212.0
2014-07-22 07:00:00	MSFT	Stock	44.9	45.06	44.9	45.06	6800.0
2014-07-22 08:00:00	MSFT	Stock	44.93	45.1	44.93	45.04	23295.0
2014-07-22 09:00:00	MSFT	Stock	45.04	45.12	44.82	45.08	4239306.0
2014-07-22 10:00:00	MSFT	Stock	45.085	45.15	44.88	44.89	7925878.0
2014-07-22 11:00:00	MSFT	Stock	44.9	44.96	44.83	44.915	5089496.0
2014-07-22 12:00:00	MSFT	Stock	44.915	45.035	44.9	44.905	2640419.0
2014-07-22 13:00:00	MSFT	Stock	44.905	44.95	44.765	44.765	2648910.0
2014-07-22 14:00:00	MSFT	Stock	44.77	44.85	44.59	44.675	4259543.0
2014-07-22 15:00:00	MSFT	Stock	44.68	44.9	44.66	44.82	9942529.0
2014-07-22 16:00:00	MSFT	Stock	44.83	45.32	43.21	45.03	4098309.0
2014-07-22 17:00:00	MSFT	Stock	45.05	45.71	44.71	45.5	600166.0
2014-07-22 18:00:00	MSFT	Stock	45.56	45.56	44.83	45.45	227150.0
2014-07-22 19:00:00	MSFT	Stock	45.39	45.45	45.32	45.45	45701.0
2014-07-22 09:00:00	NVDA	Stock	0.4675	0.4675	0.4648	0.466	27692280.0
2014-07-22 10:00:00	NVDA	Stock	0.466	0.4698	0.4658	0.4678	53302240.0
2014-07-22 11:00:00	NVDA	Stock	0.4678	0.4688	0.4662	0.4662	23935280.0
2014-07-22 12:00:00	NVDA	Stock	0.4664	0.468	0.4662	0.4673	13520320.0
2014-07-22 13:00:00	NVDA	Stock	0.4674	0.4683	0.4668	0.4671	9878720.0
2014-07-22 14:00:00	NVDA	Stock	0.467	0.4675	0.4643	0.4648	26590920.0
2014-07-22 15:00:00	NVDA	Stock	0.4646	0.4655	0.4608	0.4618	117460040.0
2014-07-22 16:00:00	NVDA	Stock	0.4618	0.4654	0.4614	0.4618	18845120.0
2014-07-22 17:00:00	NVDA	Stock	0.4655	0.4655	0.4655	0.4655	8000.0
2014-07-22 04:00:00	AMZN	Stock	17.894	17.894	17.75	17.77	115720.0
2014-07-22 05:00:00	AMZN	Stock	17.8	17.8	17.75	17.7505	74000.0
2014-07-22 06:00:00	AMZN	Stock	17.725	17.725	17.6485	17.6975	147000.0
2014-07-22 07:00:00	AMZN	Stock	17.69	17.75	17.6585	17.75	215060.0
2014-07-22 08:00:00	AMZN	Stock	17.786	17.7985	17.75	17.762	273280.0
2014-07-22 09:00:00	AMZN	Stock	17.79	17.93	17.7625	17.8908	11703280.0
2014-07-22 10:00:00	AMZN	Stock	17.888	18.1365	17.888	18.112	13329940.0
2014-07-22 11:00:00	AMZN	Stock	18.1045	18.1465	18.057	18.0713	8116460.0
2014-07-22 12:00:00	AMZN	Stock	18.0735	18.08	18.0255	18.0325	3647940.0
2014-07-22 13:00:00	AMZN	Stock	18.03	18.0675	18.03	18.0405	4292920.0

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

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