PREVIEW / stock_1hour / 2011-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-05.parquet
  size:    963 KB
  rows:    46,145
  symbols: 3,556

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-05-05 04:00:00	AAPL	Stock	12.5139	12.5139	12.5139	12.5139	2800.0
2011-05-05 06:00:00	AAPL	Stock	12.4464	12.4464	12.4464	12.4464	2800.0
2011-05-05 07:00:00	AAPL	Stock	12.4464	12.4729	12.4464	12.4493	22400.0
2011-05-05 08:00:00	AAPL	Stock	12.4643	12.4643	12.405	12.4393	1528856.0
2011-05-05 09:00:00	AAPL	Stock	12.4321	12.5339	12.4271	12.4771	60426744.0
2011-05-05 10:00:00	AAPL	Stock	12.4767	12.5125	12.4536	12.4593	50590652.0
2011-05-05 11:00:00	AAPL	Stock	12.4571	12.4929	12.4196	12.4818	44339204.0
2011-05-05 12:00:00	AAPL	Stock	12.4818	12.5146	12.4518	12.4668	32718168.0
2011-05-05 13:00:00	AAPL	Stock	12.4661	12.4911	12.4575	12.4761	18837784.0
2011-05-05 14:00:00	AAPL	Stock	12.4771	12.5021	12.4454	12.4468	27705412.0
2011-05-05 15:00:00	AAPL	Stock	12.4464	12.46	12.3589	12.3896	86661036.0
2011-05-05 16:00:00	AAPL	Stock	12.3825	12.4961	12.362	12.3961	9969764.0
2011-05-05 17:00:00	AAPL	Stock	12.3961	12.4011	12.39	12.4007	550620.0
2011-05-05 18:00:00	AAPL	Stock	12.4011	12.4014	12.3839	12.4004	193480.0
2011-05-05 19:00:00	AAPL	Stock	12.3964	12.4107	12.3961	12.4036	224140.0
2011-05-05 06:00:00	MSFT	Stock	26.1	26.1	26.05	26.05	4200.0
2011-05-05 07:00:00	MSFT	Stock	26.0	26.05	26.0	26.05	4900.0
2011-05-05 08:00:00	MSFT	Stock	26.04	26.05	25.95	26.05	27765.0
2011-05-05 09:00:00	MSFT	Stock	26.05	26.08	25.9	25.99	8290873.0
2011-05-05 10:00:00	MSFT	Stock	25.998	26.03	25.865	25.92	8095125.0
2011-05-05 11:00:00	MSFT	Stock	25.91	26.01	25.79	26.01	6973434.0
2011-05-05 12:00:00	MSFT	Stock	26.01	26.08	25.88	25.933	3996814.0
2011-05-05 13:00:00	MSFT	Stock	25.935	26.03	25.91	25.99	4371455.0
2011-05-05 14:00:00	MSFT	Stock	25.985	26.02	25.89	25.89	4135056.0
2011-05-05 15:00:00	MSFT	Stock	25.89	25.9	25.68	25.79	16951127.0
2011-05-05 16:00:00	MSFT	Stock	25.79	26.04	25.755	25.83	2234889.0
2011-05-05 17:00:00	MSFT	Stock	25.83	25.83	25.79	25.79	139987.0
2011-05-05 18:00:00	MSFT	Stock	25.79	25.82	25.79	25.82	13428.0
2011-05-05 19:00:00	MSFT	Stock	25.82	25.82	25.82	25.82	1603.0
2011-05-05 07:00:00	NVDA	Stock	0.466	0.466	0.466	0.466	12000.0
2011-05-05 08:00:00	NVDA	Stock	0.4625	0.4662	0.4625	0.4662	1382000.0
2011-05-05 09:00:00	NVDA	Stock	0.4652	0.466	0.4562	0.4625	73014560.0
2011-05-05 10:00:00	NVDA	Stock	0.4625	0.472	0.4624	0.4695	123356160.0
2011-05-05 11:00:00	NVDA	Stock	0.4692	0.4708	0.462	0.469	96129120.0
2011-05-05 12:00:00	NVDA	Stock	0.469	0.4715	0.4673	0.4688	43565200.0
2011-05-05 13:00:00	NVDA	Stock	0.4685	0.47	0.4678	0.4695	19627200.0
2011-05-05 14:00:00	NVDA	Stock	0.4697	0.4713	0.467	0.467	40214480.0
2011-05-05 15:00:00	NVDA	Stock	0.467	0.468	0.4622	0.4665	134373440.0
2011-05-05 16:00:00	NVDA	Stock	0.4665	0.4692	0.4624	0.4683	7408040.0
2011-05-05 17:00:00	NVDA	Stock	0.4688	0.4688	0.4665	0.4683	522960.0
2011-05-05 18:00:00	NVDA	Stock	0.468	0.4688	0.468	0.4688	520000.0
2011-05-05 06:00:00	AMZN	Stock	9.9805	9.9805	9.98	9.98	4000.0
2011-05-05 07:00:00	AMZN	Stock	9.97	9.97	9.96	9.96	22500.0
2011-05-05 08:00:00	AMZN	Stock	9.96	9.96	9.9	9.915	299000.0
2011-05-05 09:00:00	AMZN	Stock	9.9075	10.05	9.8915	10.0035	15548020.0
2011-05-05 10:00:00	AMZN	Stock	10.003	10.038	9.9035	9.939	12719420.0
2011-05-05 11:00:00	AMZN	Stock	9.935	10.0395	9.9035	10.0234	11334920.0
2011-05-05 12:00:00	AMZN	Stock	10.021	10.05	9.9425	9.969	10394720.0
2011-05-05 13:00:00	AMZN	Stock	9.9655	9.9785	9.891	9.934	7133380.0
2011-05-05 14:00:00	AMZN	Stock	9.935	9.9725	9.8755	9.8766	8070480.0

> showing 50 of 46,145 rows — these rows as CSV

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