PREVIEW / stock_1hour / 2014-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-14.parquet
  size:    1.0 MB
  rows:    47,994
  symbols: 3,521

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-01-14 06:00:00	AAPL	Stock	19.1482	19.1707	19.1482	19.1704	33600.0
2014-01-14 07:00:00	AAPL	Stock	19.1704	19.2679	19.1704	19.26	450436.0
2014-01-14 08:00:00	AAPL	Stock	19.2654	19.2654	19.1875	19.2311	1560748.0
2014-01-14 09:00:00	AAPL	Stock	19.225	19.3214	19.2021	19.2579	50606920.0
2014-01-14 10:00:00	AAPL	Stock	19.2587	19.4207	19.2579	19.4178	53006464.0
2014-01-14 11:00:00	AAPL	Stock	19.4143	19.4679	19.4061	19.4668	37395344.0
2014-01-14 12:00:00	AAPL	Stock	19.4679	19.5261	19.4246	19.4354	28369068.0
2014-01-14 13:00:00	AAPL	Stock	19.4354	19.4625	19.4216	19.4518	18608044.0
2014-01-14 14:00:00	AAPL	Stock	19.4525	19.4762	19.3946	19.4443	19798744.0
2014-01-14 15:00:00	AAPL	Stock	19.4475	19.5193	19.425	19.5139	38511984.0
2014-01-14 16:00:00	AAPL	Stock	19.5134	19.5261	19.2475	19.5143	17721732.0
2014-01-14 17:00:00	AAPL	Stock	19.5193	19.535	19.5139	19.5321	620200.0
2014-01-14 18:00:00	AAPL	Stock	19.5286	19.5482	19.5286	19.5357	371112.0
2014-01-14 19:00:00	AAPL	Stock	19.5339	19.5454	19.5339	19.5357	230132.0
2014-01-14 04:00:00	MSFT	Stock	34.89	35.0	34.89	35.0	8990.0
2014-01-14 05:00:00	MSFT	Stock	34.92	35.02	34.64	34.73	6575.0
2014-01-14 06:00:00	MSFT	Stock	34.73	34.74	34.66	34.7	23347.0
2014-01-14 07:00:00	MSFT	Stock	34.73	34.74	34.69	34.72	46831.0
2014-01-14 08:00:00	MSFT	Stock	34.73	34.74	34.7	34.72	61852.0
2014-01-14 09:00:00	MSFT	Stock	34.72	35.085	34.63	35.04	5769114.0
2014-01-14 10:00:00	MSFT	Stock	35.03	35.48	35.025	35.47	5989058.0
2014-01-14 11:00:00	MSFT	Stock	35.47	35.74	35.44	35.69	5814700.0
2014-01-14 12:00:00	MSFT	Stock	35.685	35.88	35.64	35.81	3821806.0
2014-01-14 13:00:00	MSFT	Stock	35.82	35.85	35.73	35.81	2587037.0
2014-01-14 14:00:00	MSFT	Stock	35.81	35.88	35.73	35.84	3893782.0
2014-01-14 15:00:00	MSFT	Stock	35.844	35.86	35.74	35.77	7572253.0
2014-01-14 16:00:00	MSFT	Stock	35.78	35.783	35.52	35.75	4512339.0
2014-01-14 17:00:00	MSFT	Stock	35.78	35.78	35.78	35.78	10340.0
2014-01-14 18:00:00	MSFT	Stock	35.77	35.77	35.73	35.75	2604.0
2014-01-14 19:00:00	MSFT	Stock	35.74	35.75	35.74	35.75	1160.0
2014-01-14 09:00:00	NVDA	Stock	0.386	0.3909	0.3842	0.39	29249200.0
2014-01-14 10:00:00	NVDA	Stock	0.3902	0.393	0.3901	0.3921	41055360.0
2014-01-14 11:00:00	NVDA	Stock	0.3921	0.393	0.3913	0.3928	19013200.0
2014-01-14 12:00:00	NVDA	Stock	0.3928	0.3945	0.3922	0.3941	17152200.0
2014-01-14 13:00:00	NVDA	Stock	0.3942	0.3958	0.3938	0.3941	23564200.0
2014-01-14 14:00:00	NVDA	Stock	0.3942	0.3968	0.3934	0.3956	24270720.0
2014-01-14 15:00:00	NVDA	Stock	0.3956	0.3962	0.395	0.396	38163000.0
2014-01-14 16:00:00	NVDA	Stock	0.396	0.3964	0.3942	0.396	31539360.0
2014-01-14 17:00:00	NVDA	Stock	0.396	0.396	0.396	0.396	8720.0
2014-01-14 08:00:00	AMZN	Stock	19.648	19.687	19.6265	19.687	65500.0
2014-01-14 09:00:00	AMZN	Stock	19.676	19.721	19.5645	19.686	6864780.0
2014-01-14 10:00:00	AMZN	Stock	19.6732	19.77	19.6025	19.718	7913420.0
2014-01-14 11:00:00	AMZN	Stock	19.718	19.7975	19.6905	19.7965	5988000.0
2014-01-14 12:00:00	AMZN	Stock	19.7975	19.852	19.7617	19.841	5570820.0
2014-01-14 13:00:00	AMZN	Stock	19.8485	19.9215	19.833	19.888	3339180.0
2014-01-14 14:00:00	AMZN	Stock	19.8935	19.9315	19.836	19.9028	2882780.0
2014-01-14 15:00:00	AMZN	Stock	19.901	19.9225	19.868	19.8765	7439000.0
2014-01-14 16:00:00	AMZN	Stock	19.877	19.8925	19.7822	19.885	1995880.0
2014-01-14 17:00:00	AMZN	Stock	19.885	19.885	19.877	19.877	14020.0
2014-01-14 19:00:00	AMZN	Stock	19.9	19.9	19.9	19.9	2000.0

> showing 50 of 47,994 rows — these rows as CSV

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