PREVIEW / stock_1hour / 2011-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-14.parquet
  size:    929 KB
  rows:    44,048
  symbols: 3,516

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-03-14 04:00:00	AAPL	Stock	12.25	12.3589	12.25	12.3571	94500.0
2011-03-14 05:00:00	AAPL	Stock	12.3482	12.4321	12.3482	12.4321	168364.0
2011-03-14 06:00:00	AAPL	Stock	12.4107	12.4821	12.4107	12.4643	78400.0
2011-03-14 07:00:00	AAPL	Stock	12.4682	12.5604	12.4682	12.5071	1034796.0
2011-03-14 08:00:00	AAPL	Stock	12.5064	12.6161	12.5036	12.6161	3420256.0
2011-03-14 09:00:00	AAPL	Stock	12.6143	12.7143	12.5971	12.7087	80148628.0
2011-03-14 10:00:00	AAPL	Stock	12.7075	12.7316	12.6225	12.6275	86524704.0
2011-03-14 11:00:00	AAPL	Stock	12.6279	12.66	12.5632	12.5868	69657588.0
2011-03-14 12:00:00	AAPL	Stock	12.5886	12.6143	12.5468	12.5996	43564528.0
2011-03-14 13:00:00	AAPL	Stock	12.5982	12.6189	12.575	12.5971	31628464.0
2011-03-14 14:00:00	AAPL	Stock	12.5961	12.6429	12.5914	12.6114	38490396.0
2011-03-14 15:00:00	AAPL	Stock	12.6114	12.6564	12.6071	12.6271	60352600.0
2011-03-14 16:00:00	AAPL	Stock	12.6271	12.7244	12.5986	12.6168	12578020.0
2011-03-14 17:00:00	AAPL	Stock	12.6182	12.6211	12.6168	12.6175	124040.0
2011-03-14 18:00:00	AAPL	Stock	12.6175	12.6318	12.6175	12.6282	215376.0
2011-03-14 19:00:00	AAPL	Stock	12.6318	12.6321	12.5714	12.5889	500892.0
2011-03-14 04:00:00	MSFT	Stock	25.89	25.89	25.36	25.37	1530.0
2011-03-14 05:00:00	MSFT	Stock	25.3	25.38	25.3	25.38	300.0
2011-03-14 06:00:00	MSFT	Stock	25.37	25.41	25.37	25.41	2100.0
2011-03-14 07:00:00	MSFT	Stock	25.42	25.51	25.42	25.49	8700.0
2011-03-14 08:00:00	MSFT	Stock	25.55	25.6	25.45	25.54	23403.0
2011-03-14 09:00:00	MSFT	Stock	25.53	25.53	25.4	25.485	5347089.0
2011-03-14 10:00:00	MSFT	Stock	25.485	25.61	25.35	25.4	7219825.0
2011-03-14 11:00:00	MSFT	Stock	25.405	25.47	25.36	25.43	6684140.0
2011-03-14 12:00:00	MSFT	Stock	25.435	25.47	25.38	25.42	3300994.0
2011-03-14 13:00:00	MSFT	Stock	25.42	25.54	25.38	25.495	6959459.0
2011-03-14 14:00:00	MSFT	Stock	25.49	25.58	25.48	25.525	6251139.0
2011-03-14 15:00:00	MSFT	Stock	25.52	25.76	25.5	25.707	14564199.0
2011-03-14 16:00:00	MSFT	Stock	25.7	25.75	25.499	25.7	2523742.0
2011-03-14 17:00:00	MSFT	Stock	25.7	25.7	25.69	25.69	383.0
2011-03-14 18:00:00	MSFT	Stock	25.7	25.7	25.67	25.7	3283.0
2011-03-14 19:00:00	MSFT	Stock	25.66	25.66	25.6	25.6	5400.0
2011-03-14 04:00:00	NVDA	Stock	0.45	0.45	0.45	0.45	4000.0
2011-03-14 07:00:00	NVDA	Stock	0.4498	0.4498	0.444	0.444	108000.0
2011-03-14 08:00:00	NVDA	Stock	0.447	0.4562	0.4465	0.4555	3383760.0
2011-03-14 09:00:00	NVDA	Stock	0.4562	0.4662	0.4525	0.4643	192901920.0
2011-03-14 10:00:00	NVDA	Stock	0.4643	0.4645	0.4528	0.454	186348160.0
2011-03-14 11:00:00	NVDA	Stock	0.454	0.4562	0.4488	0.4508	114995640.0
2011-03-14 12:00:00	NVDA	Stock	0.451	0.4522	0.4475	0.4502	85239680.0
2011-03-14 13:00:00	NVDA	Stock	0.4502	0.457	0.4495	0.4542	92278240.0
2011-03-14 14:00:00	NVDA	Stock	0.4545	0.4575	0.4525	0.454	107119720.0
2011-03-14 15:00:00	NVDA	Stock	0.454	0.4572	0.4528	0.455	201386240.0
2011-03-14 16:00:00	NVDA	Stock	0.455	0.4556	0.4507	0.455	13462920.0
2011-03-14 17:00:00	NVDA	Stock	0.4542	0.4555	0.4528	0.4528	233200.0
2011-03-14 18:00:00	NVDA	Stock	0.455	0.4555	0.453	0.4532	306800.0
2011-03-14 19:00:00	NVDA	Stock	0.4532	0.4548	0.451	0.4518	364520.0
2011-03-14 04:00:00	AMZN	Stock	8.3275	8.3275	8.278	8.278	4000.0
2011-03-14 07:00:00	AMZN	Stock	8.35	8.35	8.345	8.345	8000.0
2011-03-14 08:00:00	AMZN	Stock	8.34	8.35	8.3205	8.3475	102300.0
2011-03-14 09:00:00	AMZN	Stock	8.35	8.404	8.3125	8.384	11195600.0

> showing 50 of 44,048 rows — these rows as CSV

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