PREVIEW / stock_1hour / 2014-11-25

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-25.parquet
  size:    1.0 MB
  rows:    48,716
  symbols: 3,562

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-11-25 04:00:00	AAPL	Stock	29.6825	29.8625	29.6825	29.74	36452.0
2014-11-25 05:00:00	AAPL	Stock	29.7375	29.7625	29.7375	29.75	58680.0
2014-11-25 06:00:00	AAPL	Stock	29.7525	29.7825	29.725	29.7375	40564.0
2014-11-25 07:00:00	AAPL	Stock	29.74	29.765	29.7	29.755	421464.0
2014-11-25 08:00:00	AAPL	Stock	29.7525	29.8325	29.48	29.81	1332064.0
2014-11-25 09:00:00	AAPL	Stock	29.81	29.9375	29.755	29.8282	44962928.0
2014-11-25 10:00:00	AAPL	Stock	29.8298	29.91	29.675	29.8312	39661576.0
2014-11-25 11:00:00	AAPL	Stock	29.8325	29.87	29.7625	29.77	19944492.0
2014-11-25 12:00:00	AAPL	Stock	29.7678	29.7825	29.3625	29.395	40895776.0
2014-11-25 13:00:00	AAPL	Stock	29.3875	29.6225	29.385	29.506	28940060.0
2014-11-25 14:00:00	AAPL	Stock	29.5075	29.5752	29.4375	29.4675	19464244.0
2014-11-25 15:00:00	AAPL	Stock	29.47	29.51	29.4	29.4	32492996.0
2014-11-25 16:00:00	AAPL	Stock	29.4	29.8755	29.3938	29.4325	22054440.0
2014-11-25 17:00:00	AAPL	Stock	29.4325	29.5205	29.4	29.435	262684.0
2014-11-25 18:00:00	AAPL	Stock	29.435	29.4425	29.4	29.4425	151560.0
2014-11-25 19:00:00	AAPL	Stock	29.445	29.445	29.425	29.4325	97588.0
2014-11-25 07:00:00	MSFT	Stock	47.63	47.63	47.56	47.56	300.0
2014-11-25 08:00:00	MSFT	Stock	47.63	47.66	47.5	47.6	7045.0
2014-11-25 09:00:00	MSFT	Stock	47.6	47.97	47.52	47.925	3694182.0
2014-11-25 10:00:00	MSFT	Stock	47.93	47.93	47.66	47.78	3364786.0
2014-11-25 11:00:00	MSFT	Stock	47.78	47.96	47.77	47.799	1948506.0
2014-11-25 12:00:00	MSFT	Stock	47.8	47.855	47.77	47.815	1545023.0
2014-11-25 13:00:00	MSFT	Stock	47.815	47.86	47.72	47.76	1869987.0
2014-11-25 14:00:00	MSFT	Stock	47.77	47.775	47.61	47.675	1887292.0
2014-11-25 15:00:00	MSFT	Stock	47.675	47.695	47.45	47.475	6559740.0
2014-11-25 16:00:00	MSFT	Stock	47.475	47.886	47.42	47.51	5243332.0
2014-11-25 17:00:00	MSFT	Stock	47.51	47.774	47.47	47.501	82730.0
2014-11-25 18:00:00	MSFT	Stock	47.501	47.55	47.501	47.55	700.0
2014-11-25 19:00:00	MSFT	Stock	47.51	47.51	47.51	47.51	100.0
2014-11-25 09:00:00	NVDA	Stock	0.5135	0.518	0.5125	0.5145	22283680.0
2014-11-25 10:00:00	NVDA	Stock	0.5145	0.5174	0.5138	0.5148	35999920.0
2014-11-25 11:00:00	NVDA	Stock	0.515	0.5173	0.5142	0.517	20424720.0
2014-11-25 12:00:00	NVDA	Stock	0.5173	0.5173	0.516	0.516	9069840.0
2014-11-25 13:00:00	NVDA	Stock	0.516	0.5162	0.514	0.5148	9205400.0
2014-11-25 14:00:00	NVDA	Stock	0.5145	0.5152	0.5133	0.5141	10113280.0
2014-11-25 15:00:00	NVDA	Stock	0.5141	0.515	0.5138	0.5142	30824040.0
2014-11-25 16:00:00	NVDA	Stock	0.5142	0.5162	0.5137	0.5138	24138160.0
2014-11-25 17:00:00	NVDA	Stock	0.5142	0.5153	0.5142	0.5153	306440.0
2014-11-25 04:00:00	AMZN	Stock	16.78	16.78	16.78	16.78	2000.0
2014-11-25 06:00:00	AMZN	Stock	16.8325	16.8325	16.8325	16.8325	6000.0
2014-11-25 08:00:00	AMZN	Stock	16.825	16.825	16.683	16.7825	87440.0
2014-11-25 09:00:00	AMZN	Stock	16.7875	16.8166	16.644	16.6615	8971000.0
2014-11-25 10:00:00	AMZN	Stock	16.658	16.693	16.5925	16.6125	7384420.0
2014-11-25 11:00:00	AMZN	Stock	16.6125	16.64	16.564	16.614	6358040.0
2014-11-25 12:00:00	AMZN	Stock	16.6175	16.6748	16.601	16.6255	3938580.0
2014-11-25 13:00:00	AMZN	Stock	16.63	16.702	16.616	16.6995	3722120.0
2014-11-25 14:00:00	AMZN	Stock	16.6985	16.749	16.669	16.685	3368800.0
2014-11-25 15:00:00	AMZN	Stock	16.6882	16.7715	16.6835	16.7525	7903900.0
2014-11-25 16:00:00	AMZN	Stock	16.752	16.7625	16.6794	16.7486	4744880.0
2014-11-25 17:00:00	AMZN	Stock	16.749	16.752	16.749	16.7515	36720.0

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

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