PREVIEW / stock_1hour / 2010-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-07.parquet
  size:    918 KB
  rows:    43,589
  symbols: 3,485

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-04-07 04:00:00	AAPL	Stock	8.5582	8.5582	8.5582	8.5582	50400.0
2010-04-07 06:00:00	AAPL	Stock	8.5589	8.5589	8.5589	8.5589	2800.0
2010-04-07 07:00:00	AAPL	Stock	8.5446	8.5446	8.5271	8.5361	98812.0
2010-04-07 08:00:00	AAPL	Stock	8.5361	8.555	8.5357	8.5436	1743812.0
2010-04-07 09:00:00	AAPL	Stock	8.5436	8.6071	8.5404	8.579	72454284.0
2010-04-07 10:00:00	AAPL	Stock	8.5796	8.6225	8.5761	8.5986	99263164.0
2010-04-07 11:00:00	AAPL	Stock	8.5986	8.6164	8.5861	8.6076	52507588.0
2010-04-07 12:00:00	AAPL	Stock	8.6071	8.6179	8.5961	8.6161	26113948.0
2010-04-07 13:00:00	AAPL	Stock	8.6164	8.64	8.6154	8.6332	55543460.0
2010-04-07 14:00:00	AAPL	Stock	8.6339	8.6375	8.5643	8.5875	107034424.0
2010-04-07 15:00:00	AAPL	Stock	8.5864	8.5929	8.5236	8.5907	140816788.0
2010-04-07 16:00:00	AAPL	Stock	8.5925	8.5964	8.5554	8.5914	9392320.0
2010-04-07 17:00:00	AAPL	Stock	8.5914	8.5943	8.5879	8.5943	297724.0
2010-04-07 18:00:00	AAPL	Stock	8.5921	8.5971	8.5896	8.5971	450044.0
2010-04-07 19:00:00	AAPL	Stock	8.5954	8.5982	8.5864	8.5864	295764.0
2010-04-07 05:00:00	MSFT	Stock	29.29	29.29	29.29	29.29	100.0
2010-04-07 07:00:00	MSFT	Stock	29.25	29.25	29.25	29.25	100.0
2010-04-07 08:00:00	MSFT	Stock	29.31	29.31	29.22	29.27	15458.0
2010-04-07 09:00:00	MSFT	Stock	29.27	29.3	29.14	29.23	7648411.0
2010-04-07 10:00:00	MSFT	Stock	29.23	29.56	29.23	29.46	11978700.0
2010-04-07 11:00:00	MSFT	Stock	29.47	29.485	29.37	29.45	5130318.0
2010-04-07 12:00:00	MSFT	Stock	29.455	29.47	29.24	29.41	6513608.0
2010-04-07 13:00:00	MSFT	Stock	29.41	29.47	29.32	29.37	5198467.0
2010-04-07 14:00:00	MSFT	Stock	29.37	29.39	29.24	29.34	5476713.0
2010-04-07 15:00:00	MSFT	Stock	29.34	29.36	29.19	29.36	11887357.0
2010-04-07 16:00:00	MSFT	Stock	29.36	29.41	29.265	29.31	2483599.0
2010-04-07 17:00:00	MSFT	Stock	29.32	29.367	29.31	29.31	1718.0
2010-04-07 18:00:00	MSFT	Stock	29.35	29.35	29.33	29.33	1707.0
2010-04-07 19:00:00	MSFT	Stock	29.33	29.35	29.25	29.25	1800.0
2010-04-07 07:00:00	NVDA	Stock	0.4262	0.4262	0.4262	0.4262	4720.0
2010-04-07 08:00:00	NVDA	Stock	0.423	0.4275	0.423	0.4238	305520.0
2010-04-07 09:00:00	NVDA	Stock	0.4238	0.4253	0.42	0.4232	88500400.0
2010-04-07 10:00:00	NVDA	Stock	0.4232	0.429	0.4225	0.4272	112231520.0
2010-04-07 11:00:00	NVDA	Stock	0.427	0.4318	0.4265	0.43	88899800.0
2010-04-07 12:00:00	NVDA	Stock	0.43	0.4305	0.428	0.4282	52880520.0
2010-04-07 13:00:00	NVDA	Stock	0.4284	0.4362	0.4282	0.4338	148627320.0
2010-04-07 14:00:00	NVDA	Stock	0.4338	0.4352	0.4318	0.432	138349760.0
2010-04-07 15:00:00	NVDA	Stock	0.432	0.4321	0.4278	0.429	168929480.0
2010-04-07 16:00:00	NVDA	Stock	0.429	0.4338	0.4265	0.4289	7705000.0
2010-04-07 17:00:00	NVDA	Stock	0.4298	0.4298	0.4294	0.4298	2049800.0
2010-04-07 18:00:00	NVDA	Stock	0.4302	0.4312	0.4298	0.4312	108280.0
2010-04-07 19:00:00	NVDA	Stock	0.4318	0.4318	0.4318	0.4318	16280.0
2010-04-07 07:00:00	AMZN	Stock	6.75	6.75	6.75	6.75	2000.0
2010-04-07 08:00:00	AMZN	Stock	6.839	6.84	6.761	6.778	115040.0
2010-04-07 09:00:00	AMZN	Stock	6.781	6.8125	6.739	6.7555	23981220.0
2010-04-07 10:00:00	AMZN	Stock	6.7555	6.789	6.7335	6.759	21171340.0
2010-04-07 11:00:00	AMZN	Stock	6.7595	6.775	6.75	6.766	11778740.0
2010-04-07 12:00:00	AMZN	Stock	6.768	6.7735	6.746	6.757	7430980.0
2010-04-07 13:00:00	AMZN	Stock	6.757	6.775	6.756	6.765	9475120.0
2010-04-07 14:00:00	AMZN	Stock	6.7645	6.778	6.74	6.7482	15293880.0

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

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