PREVIEW / stock_1hour / 2013-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-26.parquet
  size:    982 KB
  rows:    45,577
  symbols: 3,510

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-07-26 04:00:00	AAPL	Stock	15.665	15.6946	15.665	15.6857	16800.0
2013-07-26 05:00:00	AAPL	Stock	15.6571	15.6571	15.6432	15.6432	8792.0
2013-07-26 06:00:00	AAPL	Stock	15.6071	15.6732	15.6071	15.6146	29876.0
2013-07-26 07:00:00	AAPL	Stock	15.6232	15.6393	15.6143	15.6268	39200.0
2013-07-26 08:00:00	AAPL	Stock	15.64	15.6429	15.5929	15.6068	443632.0
2013-07-26 09:00:00	AAPL	Stock	15.6064	15.6736	15.5121	15.6607	35399700.0
2013-07-26 10:00:00	AAPL	Stock	15.6636	15.7207	15.6368	15.6664	42882868.0
2013-07-26 11:00:00	AAPL	Stock	15.6664	15.7179	15.6618	15.6827	24462004.0
2013-07-26 12:00:00	AAPL	Stock	15.6829	15.7018	15.6625	15.6904	15992788.0
2013-07-26 13:00:00	AAPL	Stock	15.6904	15.71	15.68	15.6957	10659180.0
2013-07-26 14:00:00	AAPL	Stock	15.6964	15.7071	15.6729	15.6968	15383536.0
2013-07-26 15:00:00	AAPL	Stock	15.6968	15.7514	15.6829	15.7496	35006468.0
2013-07-26 16:00:00	AAPL	Stock	15.7496	15.7589	15.6786	15.7493	8482656.0
2013-07-26 17:00:00	AAPL	Stock	15.7529	15.7818	15.7414	15.7489	296800.0
2013-07-26 18:00:00	AAPL	Stock	15.6377	15.7607	15.6377	15.7607	82096.0
2013-07-26 19:00:00	AAPL	Stock	15.7589	15.7661	15.7514	15.7521	68236.0
2013-07-26 05:00:00	MSFT	Stock	31.4	31.4	31.35	31.35	10100.0
2013-07-26 06:00:00	MSFT	Stock	31.35	31.35	31.35	31.35	500.0
2013-07-26 07:00:00	MSFT	Stock	31.3	31.38	31.3	31.35	7000.0
2013-07-26 08:00:00	MSFT	Stock	31.3	31.35	31.27	31.3	26831.0
2013-07-26 09:00:00	MSFT	Stock	31.3	31.4	31.205	31.345	3655148.0
2013-07-26 10:00:00	MSFT	Stock	31.35	31.42	31.29	31.324	5281245.0
2013-07-26 11:00:00	MSFT	Stock	31.325	31.41	31.28	31.373	5097335.0
2013-07-26 12:00:00	MSFT	Stock	31.375	31.44	31.35	31.4	2595477.0
2013-07-26 13:00:00	MSFT	Stock	31.4	31.43	31.35	31.39	3218167.0
2013-07-26 14:00:00	MSFT	Stock	31.39	31.49	31.345	31.475	5459907.0
2013-07-26 15:00:00	MSFT	Stock	31.475	31.62	31.41	31.62	9519775.0
2013-07-26 16:00:00	MSFT	Stock	31.62	31.67	31.348	31.66	2710598.0
2013-07-26 17:00:00	MSFT	Stock	31.63	31.64	31.465	31.64	5470.0
2013-07-26 18:00:00	MSFT	Stock	31.63	31.63	31.55	31.57	2778.0
2013-07-26 19:00:00	MSFT	Stock	31.59	31.6	31.59	31.6	1022.0
2013-07-26 09:00:00	NVDA	Stock	0.353	0.3556	0.352	0.3555	15453280.0
2013-07-26 10:00:00	NVDA	Stock	0.3558	0.3571	0.3544	0.3564	32478440.0
2013-07-26 11:00:00	NVDA	Stock	0.3562	0.3562	0.354	0.3542	13805120.0
2013-07-26 12:00:00	NVDA	Stock	0.3542	0.3558	0.3541	0.3548	13789120.0
2013-07-26 13:00:00	NVDA	Stock	0.3548	0.3555	0.354	0.3541	21875280.0
2013-07-26 14:00:00	NVDA	Stock	0.3541	0.355	0.3538	0.3544	28244200.0
2013-07-26 15:00:00	NVDA	Stock	0.3544	0.356	0.3538	0.3553	75552680.0
2013-07-26 16:00:00	NVDA	Stock	0.355	0.3558	0.3544	0.355	896520.0
2013-07-26 04:00:00	AMZN	Stock	14.8005	14.8475	14.78	14.783	20000.0
2013-07-26 05:00:00	AMZN	Stock	14.785	14.785	14.785	14.785	16000.0
2013-07-26 06:00:00	AMZN	Stock	14.837	14.9365	14.837	14.9	39660.0
2013-07-26 07:00:00	AMZN	Stock	14.892	14.922	14.8505	14.8945	278220.0
2013-07-26 08:00:00	AMZN	Stock	14.9	15.0445	14.8555	14.9655	1040660.0
2013-07-26 09:00:00	AMZN	Stock	14.965	15.2165	14.7775	15.145	36028020.0
2013-07-26 10:00:00	AMZN	Stock	15.1505	15.325	14.98	15.244	33205560.0
2013-07-26 11:00:00	AMZN	Stock	15.2375	15.4118	15.1845	15.3485	24169920.0
2013-07-26 12:00:00	AMZN	Stock	15.3505	15.525	15.3505	15.495	19585100.0
2013-07-26 13:00:00	AMZN	Stock	15.495	15.681	15.479	15.6218	20553620.0
2013-07-26 14:00:00	AMZN	Stock	15.621	15.6673	15.583	15.598	14094120.0

> showing 50 of 45,577 rows — these rows as CSV

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