PREVIEW / stock_1hour / 2013-05-29

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-29.parquet
  size:    1009 KB
  rows:    47,717
  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-05-29 05:00:00	AAPL	Stock	15.7239	15.7239	15.7239	15.7239	2800.0
2013-05-29 06:00:00	AAPL	Stock	15.7239	15.7239	15.7118	15.7118	19600.0
2013-05-29 07:00:00	AAPL	Stock	15.6793	15.6896	15.6243	15.6261	653212.0
2013-05-29 08:00:00	AAPL	Stock	15.6379	15.7321	15.5964	15.6889	2267804.0
2013-05-29 09:00:00	AAPL	Stock	15.6957	15.915	15.6929	15.8943	60774504.0
2013-05-29 10:00:00	AAPL	Stock	15.8943	15.9404	15.7914	15.8451	66252452.0
2013-05-29 11:00:00	AAPL	Stock	15.8411	15.8668	15.8044	15.8379	38822952.0
2013-05-29 12:00:00	AAPL	Stock	15.8446	15.8571	15.7964	15.8511	21315476.0
2013-05-29 13:00:00	AAPL	Stock	15.8511	15.9286	15.8293	15.9089	32722732.0
2013-05-29 14:00:00	AAPL	Stock	15.9132	15.9821	15.9004	15.9286	39184124.0
2013-05-29 15:00:00	AAPL	Stock	15.9286	15.9786	15.8896	15.8921	47830440.0
2013-05-29 16:00:00	AAPL	Stock	15.8925	15.9701	15.8822	15.9107	17219412.0
2013-05-29 17:00:00	AAPL	Stock	15.9107	15.9107	15.8839	15.8918	451472.0
2013-05-29 18:00:00	AAPL	Stock	15.8929	15.8982	15.8818	15.8857	75096.0
2013-05-29 19:00:00	AAPL	Stock	15.8893	15.8929	15.88	15.88	139804.0
2013-05-29 06:00:00	MSFT	Stock	34.9	34.9	34.9	34.9	100.0
2013-05-29 07:00:00	MSFT	Stock	34.75	34.85	34.75	34.78	1900.0
2013-05-29 08:00:00	MSFT	Stock	34.83	34.9	34.76	34.8	40996.0
2013-05-29 09:00:00	MSFT	Stock	35.01	35.02	34.62	34.95	6408771.0
2013-05-29 10:00:00	MSFT	Stock	34.95	35.01	34.63	34.645	6568778.0
2013-05-29 11:00:00	MSFT	Stock	34.64	34.72	34.57	34.71	3609684.0
2013-05-29 12:00:00	MSFT	Stock	34.709	34.76	34.59	34.59	2350985.0
2013-05-29 13:00:00	MSFT	Stock	34.596	34.89	34.585	34.85	3073714.0
2013-05-29 14:00:00	MSFT	Stock	34.85	34.97	34.82	34.86	3819642.0
2013-05-29 15:00:00	MSFT	Stock	34.85	34.98	34.84	34.89	6437176.0
2013-05-29 16:00:00	MSFT	Stock	34.88	34.961	34.64	34.88	2176608.0
2013-05-29 17:00:00	MSFT	Stock	34.88	34.88	34.84	34.88	28246.0
2013-05-29 18:00:00	MSFT	Stock	34.88	34.88	34.88	34.88	700.0
2013-05-29 19:00:00	MSFT	Stock	34.8	34.96	34.8	34.96	7475.0
2013-05-29 08:00:00	NVDA	Stock	0.3578	0.3602	0.3578	0.3602	524000.0
2013-05-29 09:00:00	NVDA	Stock	0.359	0.3632	0.359	0.3602	32446720.0
2013-05-29 10:00:00	NVDA	Stock	0.3602	0.3618	0.3596	0.3608	51245520.0
2013-05-29 11:00:00	NVDA	Stock	0.3608	0.3612	0.3595	0.361	39443920.0
2013-05-29 12:00:00	NVDA	Stock	0.3611	0.3621	0.36	0.3601	35515400.0
2013-05-29 13:00:00	NVDA	Stock	0.3601	0.362	0.36	0.3609	65456280.0
2013-05-29 14:00:00	NVDA	Stock	0.361	0.3622	0.3608	0.3615	39864200.0
2013-05-29 15:00:00	NVDA	Stock	0.3615	0.3621	0.3608	0.3608	60686560.0
2013-05-29 16:00:00	NVDA	Stock	0.361	0.362	0.3608	0.362	8598240.0
2013-05-29 17:00:00	NVDA	Stock	0.361	0.361	0.361	0.361	288800.0
2013-05-29 04:00:00	AMZN	Stock	13.35	13.35	13.3075	13.3075	5740.0
2013-05-29 06:00:00	AMZN	Stock	13.275	13.275	13.255	13.255	4000.0
2013-05-29 07:00:00	AMZN	Stock	13.2555	13.2725	13.25	13.2725	24220.0
2013-05-29 08:00:00	AMZN	Stock	13.27	13.35	13.21	13.323	209000.0
2013-05-29 09:00:00	AMZN	Stock	13.3645	13.4125	13.2575	13.357	10599560.0
2013-05-29 10:00:00	AMZN	Stock	13.357	13.4115	13.275	13.2805	5481900.0
2013-05-29 11:00:00	AMZN	Stock	13.281	13.3379	13.2635	13.315	4641800.0
2013-05-29 12:00:00	AMZN	Stock	13.316	13.3445	13.2655	13.2679	2100860.0
2013-05-29 13:00:00	AMZN	Stock	13.269	13.3345	13.2422	13.327	3401500.0
2013-05-29 14:00:00	AMZN	Stock	13.3255	13.3685	13.3106	13.3185	2450940.0
2013-05-29 15:00:00	AMZN	Stock	13.3215	13.3319	13.2605	13.2765	6048360.0

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

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