PREVIEW / stock_1hour / 2012-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-16.parquet
  size:    909 KB
  rows:    43,184
  symbols: 3,475

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
2012-07-16 04:00:00	AAPL	Stock	21.6071	21.6071	21.5718	21.5718	62048.0
2012-07-16 05:00:00	AAPL	Stock	21.6071	21.6071	21.5714	21.5714	30800.0
2012-07-16 07:00:00	AAPL	Stock	21.6036	21.6071	21.5804	21.6071	40460.0
2012-07-16 08:00:00	AAPL	Stock	21.5946	21.5946	21.5561	21.5729	1063160.0
2012-07-16 09:00:00	AAPL	Stock	21.5854	21.7761	21.5757	21.6686	62792828.0
2012-07-16 10:00:00	AAPL	Stock	21.6686	21.7404	21.6686	21.7089	45171392.0
2012-07-16 11:00:00	AAPL	Stock	21.7086	21.8436	21.7011	21.7729	56191996.0
2012-07-16 12:00:00	AAPL	Stock	21.7768	21.8029	21.7186	21.7604	28423108.0
2012-07-16 13:00:00	AAPL	Stock	21.7631	21.8089	21.7546	21.7725	22648920.0
2012-07-16 14:00:00	AAPL	Stock	21.7764	21.7986	21.7293	21.7581	23242296.0
2012-07-16 15:00:00	AAPL	Stock	21.7582	21.7836	21.6304	21.6768	52133368.0
2012-07-16 16:00:00	AAPL	Stock	21.6768	21.7322	21.6475	21.6629	4191992.0
2012-07-16 17:00:00	AAPL	Stock	21.6746	21.6768	21.6479	21.6643	1714440.0
2012-07-16 18:00:00	AAPL	Stock	21.6604	21.6639	21.6536	21.6639	81060.0
2012-07-16 19:00:00	AAPL	Stock	21.6668	21.6679	21.6582	21.6643	92204.0
2012-07-16 07:00:00	MSFT	Stock	29.41	29.41	29.41	29.41	400.0
2012-07-16 08:00:00	MSFT	Stock	29.39	29.39	29.3	29.35	10924.0
2012-07-16 09:00:00	MSFT	Stock	29.35	29.62	29.04	29.13	2884801.0
2012-07-16 10:00:00	MSFT	Stock	29.13	29.385	29.09	29.329	4381333.0
2012-07-16 11:00:00	MSFT	Stock	29.325	29.49	29.29	29.489	3377168.0
2012-07-16 12:00:00	MSFT	Stock	29.49	29.53	29.25	29.32	3804231.0
2012-07-16 13:00:00	MSFT	Stock	29.325	29.51	29.3	29.45	2744974.0
2012-07-16 14:00:00	MSFT	Stock	29.45	29.51	29.34	29.37	2670073.0
2012-07-16 15:00:00	MSFT	Stock	29.367	29.46	29.325	29.44	5737624.0
2012-07-16 16:00:00	MSFT	Stock	29.44	29.5	29.354	29.423	1433872.0
2012-07-16 17:00:00	MSFT	Stock	29.44	29.48	29.44	29.44	424460.0
2012-07-16 18:00:00	MSFT	Stock	29.48	29.48	29.48	29.48	300.0
2012-07-16 19:00:00	MSFT	Stock	29.44	29.46	29.44	29.46	1400.0
2012-07-16 08:00:00	NVDA	Stock	0.3125	0.3125	0.3098	0.3123	96800.0
2012-07-16 09:00:00	NVDA	Stock	0.3108	0.3135	0.3095	0.311	46408160.0
2012-07-16 10:00:00	NVDA	Stock	0.3113	0.3155	0.309	0.3144	86288960.0
2012-07-16 11:00:00	NVDA	Stock	0.3143	0.317	0.3143	0.315	41172960.0
2012-07-16 12:00:00	NVDA	Stock	0.315	0.3158	0.3133	0.3144	20674920.0
2012-07-16 13:00:00	NVDA	Stock	0.3145	0.3168	0.3141	0.3163	28961720.0
2012-07-16 14:00:00	NVDA	Stock	0.3163	0.3175	0.3153	0.3155	28110120.0
2012-07-16 15:00:00	NVDA	Stock	0.3155	0.3158	0.3138	0.3153	61512680.0
2012-07-16 16:00:00	NVDA	Stock	0.3153	0.3153	0.3148	0.315	1572720.0
2012-07-16 17:00:00	NVDA	Stock	0.315	0.3153	0.315	0.315	3135960.0
2012-07-16 18:00:00	NVDA	Stock	0.3153	0.3153	0.3153	0.3153	80000.0
2012-07-16 19:00:00	NVDA	Stock	0.3153	0.3153	0.3153	0.3153	40000.0
2012-07-16 07:00:00	AMZN	Stock	10.89	10.89	10.84	10.845	34000.0
2012-07-16 08:00:00	AMZN	Stock	10.869	10.8695	10.811	10.8255	117120.0
2012-07-16 09:00:00	AMZN	Stock	10.825	10.9155	10.825	10.8445	6846980.0
2012-07-16 10:00:00	AMZN	Stock	10.838	10.8565	10.768	10.835	7595920.0
2012-07-16 11:00:00	AMZN	Stock	10.83	10.8935	10.825	10.838	3797820.0
2012-07-16 12:00:00	AMZN	Stock	10.84	10.8525	10.723	10.749	5454080.0
2012-07-16 13:00:00	AMZN	Stock	10.7465	10.812	10.743	10.799	4465680.0
2012-07-16 14:00:00	AMZN	Stock	10.8015	10.8155	10.7815	10.7953	3056060.0
2012-07-16 15:00:00	AMZN	Stock	10.798	10.821	10.7603	10.7995	6725680.0
2012-07-16 16:00:00	AMZN	Stock	10.8015	10.8348	10.7974	10.8005	150240.0

> showing 50 of 43,184 rows — these rows as CSV

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