PREVIEW / stock_1hour / 2010-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-31.parquet
  size:    916 KB
  rows:    43,375
  symbols: 3,479

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
2010-03-31 04:00:00	AAPL	Stock	8.4446	8.4546	8.4446	8.4518	26320.0
2010-03-31 05:00:00	AAPL	Stock	8.4546	8.4618	8.4546	8.4618	30380.0
2010-03-31 06:00:00	AAPL	Stock	8.445	8.4618	8.4396	8.4568	29680.0
2010-03-31 07:00:00	AAPL	Stock	8.4611	8.4614	8.4393	8.4496	113792.0
2010-03-31 08:00:00	AAPL	Stock	8.4475	8.4475	8.3764	8.3968	2653252.0
2010-03-31 09:00:00	AAPL	Stock	8.3964	8.4504	8.3929	8.42	74266108.0
2010-03-31 10:00:00	AAPL	Stock	8.4196	8.4361	8.3986	8.4186	72661456.0
2010-03-31 11:00:00	AAPL	Stock	8.4179	8.4282	8.4071	8.4196	29311576.0
2010-03-31 12:00:00	AAPL	Stock	8.4196	8.4275	8.415	8.4193	15820952.0
2010-03-31 13:00:00	AAPL	Stock	8.42	8.4357	8.4157	8.4289	22324372.0
2010-03-31 14:00:00	AAPL	Stock	8.4285	8.4411	8.4	8.4075	35248248.0
2010-03-31 15:00:00	AAPL	Stock	8.4062	8.4125	8.3736	8.39	79495724.0
2010-03-31 16:00:00	AAPL	Stock	8.39	8.4225	8.3661	8.4043	23906176.0
2010-03-31 17:00:00	AAPL	Stock	8.3904	8.4096	8.3904	8.4071	1288840.0
2010-03-31 18:00:00	AAPL	Stock	8.4071	8.4125	8.3929	8.4125	373100.0
2010-03-31 19:00:00	AAPL	Stock	8.4107	8.4107	8.4	8.4043	291648.0
2010-03-31 08:00:00	MSFT	Stock	29.64	29.84	29.64	29.7	12129.0
2010-03-31 09:00:00	MSFT	Stock	29.69	29.72	29.43	29.48	4742684.0
2010-03-31 10:00:00	MSFT	Stock	29.48	29.645	29.48	29.64	4948288.0
2010-03-31 11:00:00	MSFT	Stock	29.64	29.66	29.52	29.55	3547794.0
2010-03-31 12:00:00	MSFT	Stock	29.55	29.56	29.46	29.49	7604065.0
2010-03-31 13:00:00	MSFT	Stock	29.48	29.5	29.42	29.46	3984242.0
2010-03-31 14:00:00	MSFT	Stock	29.45	29.48	29.23	29.25	14400961.0
2010-03-31 15:00:00	MSFT	Stock	29.249	29.33	29.17	29.26	15352848.0
2010-03-31 16:00:00	MSFT	Stock	29.26	29.77	29.2	29.27	7009174.0
2010-03-31 17:00:00	MSFT	Stock	29.27	29.37	29.27	29.35	211375.0
2010-03-31 18:00:00	MSFT	Stock	29.29	29.36	29.29	29.31	2728.0
2010-03-31 19:00:00	MSFT	Stock	29.35	29.35	29.31	29.31	664.0
2010-03-31 08:00:00	NVDA	Stock	0.4412	0.4412	0.4355	0.4362	203000.0
2010-03-31 09:00:00	NVDA	Stock	0.4362	0.4425	0.4348	0.4362	44198280.0
2010-03-31 10:00:00	NVDA	Stock	0.4362	0.44	0.436	0.4388	82998920.0
2010-03-31 11:00:00	NVDA	Stock	0.4386	0.4405	0.4368	0.4398	47376120.0
2010-03-31 12:00:00	NVDA	Stock	0.4399	0.4408	0.4388	0.4391	29099760.0
2010-03-31 13:00:00	NVDA	Stock	0.439	0.4395	0.4378	0.439	22426160.0
2010-03-31 14:00:00	NVDA	Stock	0.4388	0.4399	0.4352	0.4358	35941040.0
2010-03-31 15:00:00	NVDA	Stock	0.4355	0.4362	0.4328	0.4348	95862640.0
2010-03-31 16:00:00	NVDA	Stock	0.4348	0.4408	0.4335	0.435	23591280.0
2010-03-31 17:00:00	NVDA	Stock	0.4345	0.4355	0.4328	0.4355	2219240.0
2010-03-31 08:00:00	AMZN	Stock	6.795	6.81	6.7835	6.7915	247780.0
2010-03-31 09:00:00	AMZN	Stock	6.805	6.821	6.729	6.7435	14369800.0
2010-03-31 10:00:00	AMZN	Stock	6.743	6.802	6.724	6.7835	19502560.0
2010-03-31 11:00:00	AMZN	Stock	6.784	6.8175	6.763	6.7985	10159000.0
2010-03-31 12:00:00	AMZN	Stock	6.797	6.8365	6.7892	6.818	8862740.0
2010-03-31 13:00:00	AMZN	Stock	6.8185	6.835	6.8045	6.8298	4933080.0
2010-03-31 14:00:00	AMZN	Stock	6.83	6.84	6.7975	6.8065	10541300.0
2010-03-31 15:00:00	AMZN	Stock	6.8065	6.813	6.78	6.7895	16349020.0
2010-03-31 16:00:00	AMZN	Stock	6.7865	6.8063	6.7775	6.7865	6242160.0
2010-03-31 17:00:00	AMZN	Stock	6.8275	6.8275	6.78	6.7815	66380.0
2010-03-31 18:00:00	AMZN	Stock	6.7865	6.8125	6.7825	6.7825	95540.0
2010-03-31 07:00:00	TLT	Stock	88.94	89.0	88.94	89.0	1340.0

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

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