PREVIEW / stock_1hour / 2014-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-03.parquet
  size:    1.1 MB
  rows:    48,969
  symbols: 3,547

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-02-03 05:00:00	AAPL	Stock	17.8571	17.8571	17.8571	17.8571	2800.0
2014-02-03 06:00:00	AAPL	Stock	17.8089	17.8571	17.8089	17.8482	82208.0
2014-02-03 07:00:00	AAPL	Stock	17.91	17.9429	17.8946	17.9429	232764.0
2014-02-03 08:00:00	AAPL	Stock	17.9321	18.035	17.8932	17.9654	1718416.0
2014-02-03 09:00:00	AAPL	Stock	17.9646	18.1332	17.8786	18.1182	60080776.0
2014-02-03 10:00:00	AAPL	Stock	18.1136	18.1186	17.9107	18.0182	62895672.0
2014-02-03 11:00:00	AAPL	Stock	18.0182	18.0393	17.9371	18.0014	29540112.0
2014-02-03 12:00:00	AAPL	Stock	17.9986	18.0061	17.9168	17.9232	28566888.0
2014-02-03 13:00:00	AAPL	Stock	17.9259	17.9425	17.8539	17.9062	37711016.0
2014-02-03 14:00:00	AAPL	Stock	17.9062	17.9375	17.8436	17.8436	26465208.0
2014-02-03 15:00:00	AAPL	Stock	17.8452	17.9282	17.8321	17.9154	50912624.0
2014-02-03 16:00:00	AAPL	Stock	17.9118	17.9925	17.8986	17.9136	23351468.0
2014-02-03 17:00:00	AAPL	Stock	17.9071	17.9418	17.9036	17.9343	535276.0
2014-02-03 18:00:00	AAPL	Stock	17.9346	17.9393	17.9118	17.9393	430276.0
2014-02-03 19:00:00	AAPL	Stock	17.9293	17.9464	17.9261	17.9464	249536.0
2014-02-03 06:00:00	MSFT	Stock	37.79	37.79	37.58	37.58	600.0
2014-02-03 07:00:00	MSFT	Stock	37.61	37.75	37.6	37.75	1400.0
2014-02-03 08:00:00	MSFT	Stock	37.71	37.84	37.54	37.63	32398.0
2014-02-03 09:00:00	MSFT	Stock	37.63	37.985	37.37	37.455	7314785.0
2014-02-03 10:00:00	MSFT	Stock	37.455	37.46	36.92	37.15	9314293.0
2014-02-03 11:00:00	MSFT	Stock	37.141	37.24	36.94	36.99	5497908.0
2014-02-03 12:00:00	MSFT	Stock	36.985	37.215	36.835	36.965	4820833.0
2014-02-03 13:00:00	MSFT	Stock	36.965	37.02	36.72	36.88	6273222.0
2014-02-03 14:00:00	MSFT	Stock	36.87	36.88	36.6	36.6	5066531.0
2014-02-03 15:00:00	MSFT	Stock	36.605	36.686	36.43	36.48	11692873.0
2014-02-03 16:00:00	MSFT	Stock	36.49	37.84	36.42	36.55	9973673.0
2014-02-03 17:00:00	MSFT	Stock	36.48	36.6	36.48	36.48	99807.0
2014-02-03 18:00:00	MSFT	Stock	36.48	36.5	36.48	36.49	32085.0
2014-02-03 19:00:00	MSFT	Stock	36.55	36.6	36.54	36.6	5368.0
2014-02-03 09:00:00	NVDA	Stock	0.3962	0.3962	0.3913	0.3942	24644400.0
2014-02-03 10:00:00	NVDA	Stock	0.394	0.394	0.3898	0.3901	48988520.0
2014-02-03 11:00:00	NVDA	Stock	0.39	0.3913	0.3893	0.3893	58652880.0
2014-02-03 12:00:00	NVDA	Stock	0.3893	0.392	0.389	0.39	36197320.0
2014-02-03 13:00:00	NVDA	Stock	0.3902	0.3902	0.387	0.3881	48562720.0
2014-02-03 14:00:00	NVDA	Stock	0.3881	0.3893	0.387	0.3873	49521040.0
2014-02-03 15:00:00	NVDA	Stock	0.387	0.3879	0.3858	0.3873	95993240.0
2014-02-03 16:00:00	NVDA	Stock	0.3873	0.3875	0.387	0.3873	19534400.0
2014-02-03 17:00:00	NVDA	Stock	0.3873	0.3873	0.3873	0.3873	297880.0
2014-02-03 05:00:00	AMZN	Stock	17.95	17.95	17.95	17.95	2000.0
2014-02-03 06:00:00	AMZN	Stock	17.925	17.925	17.865	17.865	8240.0
2014-02-03 07:00:00	AMZN	Stock	17.8625	17.9	17.84	17.9	124080.0
2014-02-03 08:00:00	AMZN	Stock	17.887	18.0475	17.887	17.913	559680.0
2014-02-03 09:00:00	AMZN	Stock	17.905	18.0425	17.672	17.7	30963020.0
2014-02-03 10:00:00	AMZN	Stock	17.6905	17.698	17.3035	17.3805	37196980.0
2014-02-03 11:00:00	AMZN	Stock	17.38	17.5495	17.357	17.4155	27118320.0
2014-02-03 12:00:00	AMZN	Stock	17.411	17.4205	17.3	17.363	14151740.0
2014-02-03 13:00:00	AMZN	Stock	17.3625	17.4045	17.005	17.131	23000600.0
2014-02-03 14:00:00	AMZN	Stock	17.1205	17.157	17.0165	17.0525	15745020.0
2014-02-03 15:00:00	AMZN	Stock	17.051	17.3395	17.05	17.3065	29672100.0
2014-02-03 16:00:00	AMZN	Stock	17.3075	17.427	17.2	17.2505	3978080.0

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

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