PREVIEW / stock_1hour / 2011-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-09.parquet
  size:    908 KB
  rows:    43,196
  symbols: 3,490

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-09-09 04:00:00	AAPL	Stock	13.6732	13.6732	13.6732	13.6732	4200.0
2011-09-09 05:00:00	AAPL	Stock	13.7046	13.7054	13.6786	13.6786	67200.0
2011-09-09 06:00:00	AAPL	Stock	13.7211	13.7211	13.6679	13.6679	70560.0
2011-09-09 07:00:00	AAPL	Stock	13.6682	13.7004	13.6607	13.6893	367248.0
2011-09-09 08:00:00	AAPL	Stock	13.6893	13.805	13.6875	13.755	2396604.0
2011-09-09 09:00:00	AAPL	Stock	13.7514	13.7586	13.6654	13.7129	76998796.0
2011-09-09 10:00:00	AAPL	Stock	13.715	13.7857	13.7064	13.7296	73358824.0
2011-09-09 11:00:00	AAPL	Stock	13.7293	13.7389	13.5236	13.5343	91609672.0
2011-09-09 12:00:00	AAPL	Stock	13.5329	13.5625	13.4707	13.5489	73744944.0
2011-09-09 13:00:00	AAPL	Stock	13.5496	13.5543	13.4196	13.4343	54536972.0
2011-09-09 14:00:00	AAPL	Stock	13.4321	13.4821	13.4196	13.4554	60590684.0
2011-09-09 15:00:00	AAPL	Stock	13.4518	13.4961	13.3936	13.4664	112833896.0
2011-09-09 16:00:00	AAPL	Stock	13.4682	13.7233	13.4087	13.4843	13374620.0
2011-09-09 17:00:00	AAPL	Stock	13.4879	13.4929	13.4771	13.4771	205128.0
2011-09-09 18:00:00	AAPL	Stock	13.4818	13.4818	13.465	13.465	155624.0
2011-09-09 19:00:00	AAPL	Stock	13.4643	13.4643	13.4489	13.4643	172732.0
2011-09-09 06:00:00	MSFT	Stock	26.0	26.01	26.0	26.01	500.0
2011-09-09 07:00:00	MSFT	Stock	26.18	26.18	26.11	26.12	778.0
2011-09-09 08:00:00	MSFT	Stock	26.19	26.28	26.11	26.19	11034.0
2011-09-09 09:00:00	MSFT	Stock	26.18	26.18	25.8	25.94	5469579.0
2011-09-09 10:00:00	MSFT	Stock	25.94	26.1	25.88	25.94	8521343.0
2011-09-09 11:00:00	MSFT	Stock	25.94	26.01	25.5	25.58	11877508.0
2011-09-09 12:00:00	MSFT	Stock	25.59	25.76	25.55	25.73	6700658.0
2011-09-09 13:00:00	MSFT	Stock	25.722	25.8	25.58	25.63	4434527.0
2011-09-09 14:00:00	MSFT	Stock	25.63	25.75	25.58	25.6	5392510.0
2011-09-09 15:00:00	MSFT	Stock	25.6	25.88	25.55	25.73	16506795.0
2011-09-09 16:00:00	MSFT	Stock	25.74	25.86	25.63	25.86	4672204.0
2011-09-09 17:00:00	MSFT	Stock	25.8	25.87	25.8	25.85	5500.0
2011-09-09 18:00:00	MSFT	Stock	25.74	25.81	25.74	25.81	24727.0
2011-09-09 19:00:00	MSFT	Stock	25.8	25.8	25.79	25.8	1850.0
2011-09-09 07:00:00	NVDA	Stock	0.35	0.35	0.3488	0.3488	20000.0
2011-09-09 08:00:00	NVDA	Stock	0.3538	0.3538	0.3538	0.3538	21560.0
2011-09-09 09:00:00	NVDA	Stock	0.3528	0.3561	0.3488	0.3554	66218160.0
2011-09-09 10:00:00	NVDA	Stock	0.3553	0.361	0.3528	0.3578	169868400.0
2011-09-09 11:00:00	NVDA	Stock	0.3578	0.3592	0.3502	0.352	131797080.0
2011-09-09 12:00:00	NVDA	Stock	0.352	0.3545	0.3508	0.3545	85642040.0
2011-09-09 13:00:00	NVDA	Stock	0.3542	0.3548	0.3513	0.3515	68521520.0
2011-09-09 14:00:00	NVDA	Stock	0.3513	0.3518	0.3445	0.3448	115264240.0
2011-09-09 15:00:00	NVDA	Stock	0.3448	0.349	0.344	0.3468	207058800.0
2011-09-09 16:00:00	NVDA	Stock	0.3465	0.3548	0.345	0.345	13157920.0
2011-09-09 17:00:00	NVDA	Stock	0.3473	0.3473	0.3473	0.3473	4000.0
2011-09-09 18:00:00	NVDA	Stock	0.3485	0.3542	0.347	0.3528	2273840.0
2011-09-09 19:00:00	NVDA	Stock	0.352	0.3533	0.3508	0.3533	623960.0
2011-09-09 06:00:00	AMZN	Stock	10.8235	10.8235	10.811	10.811	4000.0
2011-09-09 07:00:00	AMZN	Stock	10.775	10.775	10.7655	10.7655	10000.0
2011-09-09 08:00:00	AMZN	Stock	10.8075	10.853	10.7935	10.824	245260.0
2011-09-09 09:00:00	AMZN	Stock	10.815	10.8165	10.729	10.7485	11457280.0
2011-09-09 10:00:00	AMZN	Stock	10.7414	10.848	10.7335	10.791	10113040.0
2011-09-09 11:00:00	AMZN	Stock	10.792	10.847	10.59	10.6055	13642020.0
2011-09-09 12:00:00	AMZN	Stock	10.6095	10.6215	10.5175	10.6125	11542440.0

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

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