PREVIEW / stock_1hour / 2014-04-10

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-10.parquet
  size:    1.0 MB
  rows:    48,186
  symbols: 3,553

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-04-10 04:00:00	AAPL	Stock	19.0368	19.05	19.0254	19.0254	43400.0
2014-04-10 05:00:00	AAPL	Stock	19.0357	19.0357	18.9464	18.9464	39200.0
2014-04-10 06:00:00	AAPL	Stock	18.9446	18.975	18.9293	18.975	65184.0
2014-04-10 07:00:00	AAPL	Stock	18.975	19.0464	18.9643	19.0179	590184.0
2014-04-10 08:00:00	AAPL	Stock	19.0036	19.0357	18.9525	18.9554	851228.0
2014-04-10 09:00:00	AAPL	Stock	18.9618	18.9639	18.8354	18.8746	25502120.0
2014-04-10 10:00:00	AAPL	Stock	18.8746	19.0086	18.8536	18.9064	38655876.0
2014-04-10 11:00:00	AAPL	Stock	18.9046	18.9064	18.7961	18.825	26964280.0
2014-04-10 12:00:00	AAPL	Stock	18.8246	18.8261	18.7593	18.7654	18543532.0
2014-04-10 13:00:00	AAPL	Stock	18.7693	18.8214	18.7393	18.8143	19940676.0
2014-04-10 14:00:00	AAPL	Stock	18.8129	18.8221	18.7311	18.7511	16270408.0
2014-04-10 15:00:00	AAPL	Stock	18.7554	18.7554	18.6846	18.6957	36386224.0
2014-04-10 16:00:00	AAPL	Stock	18.6957	18.9175	18.675	18.6957	9559004.0
2014-04-10 17:00:00	AAPL	Stock	18.6786	18.7	18.6732	18.6732	143640.0
2014-04-10 18:00:00	AAPL	Stock	18.6679	18.6957	18.6339	18.6393	504784.0
2014-04-10 19:00:00	AAPL	Stock	18.6071	18.6429	18.6021	18.6429	157444.0
2014-04-10 07:00:00	MSFT	Stock	40.52	40.54	40.5	40.53	1577.0
2014-04-10 08:00:00	MSFT	Stock	40.53	40.55	40.5	40.55	5600.0
2014-04-10 09:00:00	MSFT	Stock	40.51	40.69	40.27	40.295	3977746.0
2014-04-10 10:00:00	MSFT	Stock	40.3	40.65	40.18	40.29	5436662.0
2014-04-10 11:00:00	MSFT	Stock	40.29	40.29	39.88	39.95	4518124.0
2014-04-10 12:00:00	MSFT	Stock	39.955	40.015	39.56	39.61	4962321.0
2014-04-10 13:00:00	MSFT	Stock	39.62	39.76	39.48	39.61	4877837.0
2014-04-10 14:00:00	MSFT	Stock	39.605	39.64	39.26	39.336	5686200.0
2014-04-10 15:00:00	MSFT	Stock	39.34	39.53	39.09	39.38	12069556.0
2014-04-10 16:00:00	MSFT	Stock	39.36	40.39	39.32	39.36	2981819.0
2014-04-10 17:00:00	MSFT	Stock	39.44	39.44	39.33	39.4	4775.0
2014-04-10 18:00:00	MSFT	Stock	39.4	39.4	39.36	39.36	17349.0
2014-04-10 19:00:00	MSFT	Stock	39.36	39.36	39.35	39.35	4960.0
2014-04-10 07:00:00	NVDA	Stock	0.4675	0.4675	0.4415	0.4428	77960.0
2014-04-10 08:00:00	NVDA	Stock	0.4708	0.4708	0.4628	0.4633	28360.0
2014-04-10 09:00:00	NVDA	Stock	0.469	0.4735	0.4668	0.473	27747120.0
2014-04-10 10:00:00	NVDA	Stock	0.4732	0.4755	0.4688	0.469	49012040.0
2014-04-10 11:00:00	NVDA	Stock	0.4688	0.469	0.4652	0.4665	28301960.0
2014-04-10 12:00:00	NVDA	Stock	0.4664	0.4692	0.465	0.4678	51893880.0
2014-04-10 13:00:00	NVDA	Stock	0.4679	0.4683	0.4633	0.4633	43928240.0
2014-04-10 14:00:00	NVDA	Stock	0.4633	0.4645	0.458	0.46	46806840.0
2014-04-10 15:00:00	NVDA	Stock	0.4599	0.4621	0.4582	0.4596	106467800.0
2014-04-10 16:00:00	NVDA	Stock	0.4595	0.4652	0.4594	0.4594	3281920.0
2014-04-10 17:00:00	NVDA	Stock	0.4603	0.4603	0.4603	0.4603	12000.0
2014-04-10 18:00:00	NVDA	Stock	0.46	0.46	0.4595	0.46	107600.0
2014-04-10 19:00:00	NVDA	Stock	0.46	0.46	0.46	0.46	16000.0
2014-04-10 05:00:00	AMZN	Stock	16.625	16.625	16.552	16.552	6700.0
2014-04-10 08:00:00	AMZN	Stock	16.5465	16.5835	16.5005	16.5005	50620.0
2014-04-10 09:00:00	AMZN	Stock	16.5675	16.5815	16.35	16.4225	13967340.0
2014-04-10 10:00:00	AMZN	Stock	16.4195	16.43	16.123	16.1255	14818380.0
2014-04-10 11:00:00	AMZN	Stock	16.125	16.1725	16.0085	16.1152	13924340.0
2014-04-10 12:00:00	AMZN	Stock	16.11	16.1369	16.0053	16.0325	12760500.0
2014-04-10 13:00:00	AMZN	Stock	16.0315	16.0745	15.9	15.9935	14007680.0
2014-04-10 14:00:00	AMZN	Stock	15.9985	16.0975	15.9015	15.946	9991900.0

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

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