PREVIEW / stock_1hour / 2010-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-28.parquet
  size:    896 KB
  rows:    43,324
  symbols: 3,458

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-06-28 04:00:00	AAPL	Stock	9.5289	9.5646	9.5289	9.5536	8400.0
2010-06-28 05:00:00	AAPL	Stock	9.5571	9.5571	9.5571	9.5571	32760.0
2010-06-28 06:00:00	AAPL	Stock	9.5893	9.5893	9.5786	9.5786	21392.0
2010-06-28 07:00:00	AAPL	Stock	9.5625	9.5679	9.5196	9.5525	186536.0
2010-06-28 08:00:00	AAPL	Stock	9.5521	9.5618	9.5018	9.5143	4956924.0
2010-06-28 09:00:00	AAPL	Stock	9.5168	9.6054	9.4857	9.5611	107753072.0
2010-06-28 10:00:00	AAPL	Stock	9.5621	9.5625	9.4471	9.5357	121567432.0
2010-06-28 11:00:00	AAPL	Stock	9.5362	9.5929	9.5321	9.5618	69130712.0
2010-06-28 12:00:00	AAPL	Stock	9.5611	9.5861	9.5479	9.572	40543580.0
2010-06-28 13:00:00	AAPL	Stock	9.5736	9.5754	9.5211	9.5614	43197000.0
2010-06-28 14:00:00	AAPL	Stock	9.5614	9.6071	9.5461	9.5882	68001808.0
2010-06-28 15:00:00	AAPL	Stock	9.5879	9.6339	9.5779	9.5821	116513684.0
2010-06-28 16:00:00	AAPL	Stock	9.5821	9.6228	9.5393	9.5786	8626604.0
2010-06-28 17:00:00	AAPL	Stock	9.5786	9.5929	9.4926	9.5807	612780.0
2010-06-28 18:00:00	AAPL	Stock	9.5821	9.5911	9.5786	9.5879	259084.0
2010-06-28 19:00:00	AAPL	Stock	9.5825	9.6036	9.5825	9.5964	284592.0
2010-06-28 04:00:00	MSFT	Stock	24.53	24.53	24.53	24.53	200.0
2010-06-28 06:00:00	MSFT	Stock	24.55	24.55	24.55	24.55	500.0
2010-06-28 07:00:00	MSFT	Stock	24.53	24.58	24.53	24.57	19300.0
2010-06-28 08:00:00	MSFT	Stock	24.57	24.57	24.47	24.52	97395.0
2010-06-28 09:00:00	MSFT	Stock	24.52	24.56	24.12	24.15	11648090.0
2010-06-28 10:00:00	MSFT	Stock	24.15	24.52	24.14	24.49	12026699.0
2010-06-28 11:00:00	MSFT	Stock	24.485	24.61	24.48	24.535	8127565.0
2010-06-28 12:00:00	MSFT	Stock	24.53	24.56	24.39	24.501	6457145.0
2010-06-28 13:00:00	MSFT	Stock	24.509	24.53	24.43	24.46	6334413.0
2010-06-28 14:00:00	MSFT	Stock	24.455	24.46	24.34	24.4	7952183.0
2010-06-28 15:00:00	MSFT	Stock	24.4	24.46	24.25	24.3	14316073.0
2010-06-28 16:00:00	MSFT	Stock	24.3	24.546	24.27	24.34	6203872.0
2010-06-28 17:00:00	MSFT	Stock	24.32	24.35	24.31	24.31	5163.0
2010-06-28 18:00:00	MSFT	Stock	24.31	24.31	24.31	24.31	73138.0
2010-06-28 19:00:00	MSFT	Stock	24.31	24.33	24.3	24.32	3150.0
2010-06-28 08:00:00	NVDA	Stock	0.28	0.28	0.2758	0.2783	97600.0
2010-06-28 09:00:00	NVDA	Stock	0.2785	0.2792	0.2725	0.2728	61434760.0
2010-06-28 10:00:00	NVDA	Stock	0.2729	0.2789	0.2725	0.2785	66330000.0
2010-06-28 11:00:00	NVDA	Stock	0.2785	0.2815	0.2785	0.2803	74701680.0
2010-06-28 12:00:00	NVDA	Stock	0.2803	0.2805	0.2775	0.2778	36653960.0
2010-06-28 13:00:00	NVDA	Stock	0.2779	0.2791	0.2768	0.2788	31665440.0
2010-06-28 14:00:00	NVDA	Stock	0.2789	0.28	0.2778	0.2795	31024120.0
2010-06-28 15:00:00	NVDA	Stock	0.2795	0.28	0.277	0.277	64520760.0
2010-06-28 16:00:00	NVDA	Stock	0.277	0.2795	0.2768	0.2795	5013360.0
2010-06-28 19:00:00	NVDA	Stock	0.2752	0.2752	0.2752	0.2752	22320.0
2010-06-28 06:00:00	AMZN	Stock	6.001	6.001	6.0005	6.0005	4000.0
2010-06-28 07:00:00	AMZN	Stock	6.0	6.0	5.9915	5.9915	24000.0
2010-06-28 08:00:00	AMZN	Stock	5.999	5.9995	5.955	5.955	234080.0
2010-06-28 09:00:00	AMZN	Stock	5.9575	5.96	5.88	5.8825	21171320.0
2010-06-28 10:00:00	AMZN	Stock	5.8847	5.982	5.855	5.9766	28088140.0
2010-06-28 11:00:00	AMZN	Stock	5.9755	6.002	5.9385	5.94	11895300.0
2010-06-28 12:00:00	AMZN	Stock	5.9398	5.946	5.8962	5.9	9664000.0
2010-06-28 13:00:00	AMZN	Stock	5.9	5.925	5.88	5.922	9041000.0
2010-06-28 14:00:00	AMZN	Stock	5.9225	5.935	5.8974	5.9165	8191000.0

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

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