PREVIEW / stock_1hour / 2011-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-04.parquet
  size:    901 KB
  rows:    42,810
  symbols: 3,488

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
2011-11-04 04:00:00	AAPL	Stock	14.3571	14.3571	14.3571	14.3571	5600.0
2011-11-04 05:00:00	AAPL	Stock	14.3571	14.3929	14.3571	14.3929	22400.0
2011-11-04 06:00:00	AAPL	Stock	14.4068	14.4068	14.4068	14.4068	2800.0
2011-11-04 07:00:00	AAPL	Stock	14.3929	14.4175	14.3571	14.3571	345856.0
2011-11-04 08:00:00	AAPL	Stock	14.3696	14.4057	14.2857	14.3554	2989280.0
2011-11-04 09:00:00	AAPL	Stock	14.3461	14.4086	14.3182	14.3329	55203428.0
2011-11-04 10:00:00	AAPL	Stock	14.3286	14.3536	14.2857	14.2957	54031404.0
2011-11-04 11:00:00	AAPL	Stock	14.2936	14.3075	14.2557	14.2921	42737436.0
2011-11-04 12:00:00	AAPL	Stock	14.2927	14.3279	14.2914	14.3	24835160.0
2011-11-04 13:00:00	AAPL	Stock	14.3004	14.3529	14.2946	14.3346	27677720.0
2011-11-04 14:00:00	AAPL	Stock	14.3341	14.3532	14.3268	14.3364	22069124.0
2011-11-04 15:00:00	AAPL	Stock	14.3346	14.3393	14.2861	14.2943	53457796.0
2011-11-04 16:00:00	AAPL	Stock	14.2943	14.3954	14.2839	14.285	15701336.0
2011-11-04 17:00:00	AAPL	Stock	14.2857	14.2864	14.25	14.2854	796712.0
2011-11-04 18:00:00	AAPL	Stock	14.2829	14.2943	14.2611	14.2857	311136.0
2011-11-04 19:00:00	AAPL	Stock	14.2929	14.3393	14.2857	14.3393	419216.0
2011-11-04 07:00:00	MSFT	Stock	26.44	26.44	26.44	26.44	300.0
2011-11-04 08:00:00	MSFT	Stock	26.44	26.44	26.3	26.34	45544.0
2011-11-04 09:00:00	MSFT	Stock	26.33	26.41	26.1	26.14	4991833.0
2011-11-04 10:00:00	MSFT	Stock	26.14	26.24	26.0	26.09	5712859.0
2011-11-04 11:00:00	MSFT	Stock	26.09	26.13	26.01	26.06	4220342.0
2011-11-04 12:00:00	MSFT	Stock	26.07	26.14	26.02	26.098	3282908.0
2011-11-04 13:00:00	MSFT	Stock	26.1	26.29	26.062	26.25	3896873.0
2011-11-04 14:00:00	MSFT	Stock	26.248	26.281	26.18	26.21	2633327.0
2011-11-04 15:00:00	MSFT	Stock	26.219	26.28	26.14	26.25	7268524.0
2011-11-04 16:00:00	MSFT	Stock	26.25	26.53	26.068	26.25	3275324.0
2011-11-04 17:00:00	MSFT	Stock	26.24	26.24	26.24	26.24	300.0
2011-11-04 18:00:00	MSFT	Stock	26.25	26.25	26.25	26.25	17148.0
2011-11-04 19:00:00	MSFT	Stock	26.29	26.31	26.29	26.31	4150.0
2011-11-04 08:00:00	NVDA	Stock	0.3632	0.3648	0.362	0.362	115960.0
2011-11-04 09:00:00	NVDA	Stock	0.3645	0.3662	0.3595	0.3625	83484520.0
2011-11-04 10:00:00	NVDA	Stock	0.3625	0.363	0.3572	0.3618	113299600.0
2011-11-04 11:00:00	NVDA	Stock	0.3618	0.365	0.361	0.3642	101414960.0
2011-11-04 12:00:00	NVDA	Stock	0.3642	0.3672	0.3625	0.3669	75884960.0
2011-11-04 13:00:00	NVDA	Stock	0.367	0.3718	0.367	0.3708	69857440.0
2011-11-04 14:00:00	NVDA	Stock	0.3706	0.3708	0.3685	0.3699	69664160.0
2011-11-04 15:00:00	NVDA	Stock	0.3698	0.371	0.3682	0.3705	123195840.0
2011-11-04 16:00:00	NVDA	Stock	0.3705	0.371	0.3572	0.3705	7773160.0
2011-11-04 17:00:00	NVDA	Stock	0.3713	0.3713	0.3705	0.3705	64680.0
2011-11-04 18:00:00	NVDA	Stock	0.3695	0.37	0.3695	0.37	152000.0
2011-11-04 19:00:00	NVDA	Stock	0.37	0.3715	0.37	0.3713	375240.0
2011-11-04 06:00:00	AMZN	Stock	10.8735	10.8885	10.873	10.882	8000.0
2011-11-04 07:00:00	AMZN	Stock	10.883	10.9	10.878	10.886	10000.0
2011-11-04 08:00:00	AMZN	Stock	10.8725	10.9	10.823	10.85	367340.0
2011-11-04 09:00:00	AMZN	Stock	10.8625	10.9115	10.807	10.835	11898020.0
2011-11-04 10:00:00	AMZN	Stock	10.832	10.84	10.7166	10.7345	12984680.0
2011-11-04 11:00:00	AMZN	Stock	10.7365	10.7775	10.719	10.7662	7792480.0
2011-11-04 12:00:00	AMZN	Stock	10.7715	10.7905	10.729	10.7528	5663800.0
2011-11-04 13:00:00	AMZN	Stock	10.748	10.9	10.7415	10.881	11560960.0
2011-11-04 14:00:00	AMZN	Stock	10.8845	10.909	10.825	10.848	9538980.0

> showing 50 of 42,810 rows — these rows as CSV

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