PREVIEW / stock_1hour / 2013-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-07.parquet
  size:    997 KB
  rows:    46,075
  symbols: 3,529

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
2013-06-07 04:00:00	AAPL	Stock	15.675	15.675	15.675	15.675	8400.0
2013-06-07 05:00:00	AAPL	Stock	15.6514	15.6514	15.6429	15.6429	31892.0
2013-06-07 06:00:00	AAPL	Stock	15.6518	15.6518	15.6518	15.6518	9800.0
2013-06-07 07:00:00	AAPL	Stock	15.6607	15.6786	15.5914	15.6071	271320.0
2013-06-07 08:00:00	AAPL	Stock	15.6239	15.6857	15.5868	15.6571	3546592.0
2013-06-07 09:00:00	AAPL	Stock	15.6482	15.6657	15.4561	15.5054	70894880.0
2013-06-07 10:00:00	AAPL	Stock	15.5039	15.6696	15.4621	15.6046	90326544.0
2013-06-07 11:00:00	AAPL	Stock	15.6057	15.6586	15.5682	15.6157	33053384.0
2013-06-07 12:00:00	AAPL	Stock	15.6143	15.7857	15.5939	15.7671	41500872.0
2013-06-07 13:00:00	AAPL	Stock	15.7672	15.83	15.7343	15.7643	49749560.0
2013-06-07 14:00:00	AAPL	Stock	15.7614	15.7746	15.6986	15.7618	29160684.0
2013-06-07 15:00:00	AAPL	Stock	15.7614	15.7929	15.7396	15.7839	49907396.0
2013-06-07 16:00:00	AAPL	Stock	15.7843	15.7925	15.6446	15.6446	32755548.0
2013-06-07 17:00:00	AAPL	Stock	15.7821	15.8036	15.7821	15.8036	187572.0
2013-06-07 18:00:00	AAPL	Stock	15.8054	15.825	15.8054	15.8214	143192.0
2013-06-07 19:00:00	AAPL	Stock	15.8214	15.8304	15.8161	15.8304	117348.0
2013-06-07 05:00:00	MSFT	Stock	34.81	34.81	34.79	34.79	500.0
2013-06-07 07:00:00	MSFT	Stock	34.79	34.9	34.79	34.9	600.0
2013-06-07 08:00:00	MSFT	Stock	34.8	35.1	34.8	35.09	79716.0
2013-06-07 09:00:00	MSFT	Stock	35.09	35.4	34.96	35.4	4251721.0
2013-06-07 10:00:00	MSFT	Stock	35.4	35.5	35.33	35.46	6022864.0
2013-06-07 11:00:00	MSFT	Stock	35.455	35.565	35.44	35.48	4833207.0
2013-06-07 12:00:00	MSFT	Stock	35.48	35.5	35.45	35.46	2412532.0
2013-06-07 13:00:00	MSFT	Stock	35.46	35.52	35.38	35.48	3182078.0
2013-06-07 14:00:00	MSFT	Stock	35.49	35.52	35.43	35.48	2928799.0
2013-06-07 15:00:00	MSFT	Stock	35.482	35.78	35.48	35.66	10665432.0
2013-06-07 16:00:00	MSFT	Stock	35.65	35.68	35.503	35.59	5097775.0
2013-06-07 17:00:00	MSFT	Stock	35.59	35.59	35.59	35.59	200.0
2013-06-07 18:00:00	MSFT	Stock	35.56	35.56	35.56	35.56	100.0
2013-06-07 19:00:00	MSFT	Stock	35.6	35.6	35.55	35.55	4904.0
2013-06-07 09:00:00	NVDA	Stock	0.359	0.3615	0.3572	0.3602	30204280.0
2013-06-07 10:00:00	NVDA	Stock	0.3602	0.3622	0.3592	0.3594	54924960.0
2013-06-07 11:00:00	NVDA	Stock	0.3595	0.363	0.3592	0.363	41622280.0
2013-06-07 12:00:00	NVDA	Stock	0.3629	0.3635	0.3618	0.3632	35385960.0
2013-06-07 13:00:00	NVDA	Stock	0.3632	0.3634	0.3615	0.3615	22962920.0
2013-06-07 14:00:00	NVDA	Stock	0.3615	0.362	0.3598	0.3602	19206280.0
2013-06-07 15:00:00	NVDA	Stock	0.3602	0.3618	0.3595	0.361	58086040.0
2013-06-07 16:00:00	NVDA	Stock	0.3612	0.3613	0.3609	0.3613	11214960.0
2013-06-07 08:00:00	AMZN	Stock	13.4	13.475	13.387	13.4695	272580.0
2013-06-07 09:00:00	AMZN	Stock	13.4505	13.5635	13.3915	13.536	10922540.0
2013-06-07 10:00:00	AMZN	Stock	13.5305	13.745	13.5075	13.699	23768440.0
2013-06-07 11:00:00	AMZN	Stock	13.7008	14.005	13.6935	13.865	17385420.0
2013-06-07 12:00:00	AMZN	Stock	13.8645	13.888	13.8	13.8594	8670720.0
2013-06-07 13:00:00	AMZN	Stock	13.8615	13.8665	13.7625	13.7715	5288380.0
2013-06-07 14:00:00	AMZN	Stock	13.7715	13.8475	13.7326	13.827	6244460.0
2013-06-07 15:00:00	AMZN	Stock	13.825	13.894	13.8125	13.8425	14946840.0
2013-06-07 16:00:00	AMZN	Stock	13.8435	13.875	13.8175	13.845	829240.0
2013-06-07 17:00:00	AMZN	Stock	13.8435	13.85	13.8345	13.85	163020.0
2013-06-07 18:00:00	AMZN	Stock	13.851	13.851	13.85	13.85	6000.0
2013-06-07 06:00:00	META	Stock	23.02	23.02	23.0	23.0	201.0

> showing 50 of 46,075 rows — these rows as CSV

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