PREVIEW / stock_1hour / 2011-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-19.parquet
  size:    958 KB
  rows:    44,777
  symbols: 3,547

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-19 04:00:00	AAPL	Stock	12.1346	12.1346	12.1125	12.1125	14700.0
2011-05-19 05:00:00	AAPL	Stock	12.1125	12.1518	12.1125	12.1518	16800.0
2011-05-19 06:00:00	AAPL	Stock	12.1914	12.1914	12.1904	12.1907	23688.0
2011-05-19 07:00:00	AAPL	Stock	12.19	12.1921	12.1732	12.1818	178640.0
2011-05-19 08:00:00	AAPL	Stock	12.1786	12.2096	12.1607	12.2054	1652980.0
2011-05-19 09:00:00	AAPL	Stock	12.2071	12.2291	12.1767	12.1807	50916852.0
2011-05-19 10:00:00	AAPL	Stock	12.1807	12.1957	12.1254	12.1404	50272012.0
2011-05-19 11:00:00	AAPL	Stock	12.1404	12.1554	12.0954	12.0996	31792796.0
2011-05-19 12:00:00	AAPL	Stock	12.1007	12.1771	12.0989	12.1671	31979948.0
2011-05-19 13:00:00	AAPL	Stock	12.1671	12.1911	12.1536	12.175	22644468.0
2011-05-19 14:00:00	AAPL	Stock	12.1761	12.1914	12.1461	12.1496	27634320.0
2011-05-19 15:00:00	AAPL	Stock	12.1504	12.1757	12.1482	12.1625	33742380.0
2011-05-19 16:00:00	AAPL	Stock	12.1625	12.2243	12.1468	12.165	6635412.0
2011-05-19 17:00:00	AAPL	Stock	12.1661	12.1661	12.1625	12.1625	33824.0
2011-05-19 18:00:00	AAPL	Stock	12.1625	12.1685	12.1607	12.1607	498288.0
2011-05-19 19:00:00	AAPL	Stock	12.1596	12.1596	12.1532	12.1596	59948.0
2011-05-19 05:00:00	MSFT	Stock	24.65	24.65	24.65	24.65	1000.0
2011-05-19 06:00:00	MSFT	Stock	24.68	24.7	24.68	24.7	1400.0
2011-05-19 07:00:00	MSFT	Stock	24.68	24.68	24.67	24.67	600.0
2011-05-19 08:00:00	MSFT	Stock	24.68	24.72	24.68	24.69	56516.0
2011-05-19 09:00:00	MSFT	Stock	24.7	24.88	24.66	24.73	4872978.0
2011-05-19 10:00:00	MSFT	Stock	24.73	24.73	24.55	24.56	7109040.0
2011-05-19 11:00:00	MSFT	Stock	24.57	24.62	24.5	24.61	5598003.0
2011-05-19 12:00:00	MSFT	Stock	24.61	24.83	24.61	24.76	4974988.0
2011-05-19 13:00:00	MSFT	Stock	24.765	24.82	24.74	24.765	3399796.0
2011-05-19 14:00:00	MSFT	Stock	24.76	24.8	24.65	24.72	4170145.0
2011-05-19 15:00:00	MSFT	Stock	24.71	24.76	24.69	24.715	5585212.0
2011-05-19 16:00:00	MSFT	Stock	24.72	24.79	24.575	24.72	1526308.0
2011-05-19 17:00:00	MSFT	Stock	24.72	24.72	24.65	24.65	37625.0
2011-05-19 18:00:00	MSFT	Stock	24.61	24.72	24.61	24.67	15711.0
2011-05-19 19:00:00	MSFT	Stock	24.67	24.67	24.67	24.67	2000.0
2011-05-19 08:00:00	NVDA	Stock	0.455	0.455	0.452	0.452	364000.0
2011-05-19 09:00:00	NVDA	Stock	0.4548	0.4548	0.4432	0.4445	89451760.0
2011-05-19 10:00:00	NVDA	Stock	0.444	0.4442	0.4378	0.4385	153211600.0
2011-05-19 11:00:00	NVDA	Stock	0.4387	0.4408	0.438	0.439	70442160.0
2011-05-19 12:00:00	NVDA	Stock	0.439	0.4432	0.4385	0.443	88995400.0
2011-05-19 13:00:00	NVDA	Stock	0.4428	0.4458	0.4418	0.4452	65590280.0
2011-05-19 14:00:00	NVDA	Stock	0.445	0.4462	0.442	0.444	73110560.0
2011-05-19 15:00:00	NVDA	Stock	0.4438	0.4455	0.4432	0.4442	96422200.0
2011-05-19 16:00:00	NVDA	Stock	0.4444	0.45	0.4428	0.4432	7940560.0
2011-05-19 17:00:00	NVDA	Stock	0.4432	0.4432	0.4432	0.4432	80000.0
2011-05-19 18:00:00	NVDA	Stock	0.4432	0.4462	0.4422	0.4462	377120.0
2011-05-19 19:00:00	NVDA	Stock	0.445	0.445	0.4422	0.4422	37200.0
2011-05-19 08:00:00	AMZN	Stock	9.922	9.931	9.9	9.91	138060.0
2011-05-19 09:00:00	AMZN	Stock	9.903	9.9975	9.88	9.956	13835700.0
2011-05-19 10:00:00	AMZN	Stock	9.95	9.9805	9.8775	9.8978	16154680.0
2011-05-19 11:00:00	AMZN	Stock	9.9	9.93	9.8985	9.906	7543080.0
2011-05-19 12:00:00	AMZN	Stock	9.9058	9.9745	9.904	9.949	9756840.0
2011-05-19 13:00:00	AMZN	Stock	9.949	9.9852	9.9435	9.9605	7295120.0
2011-05-19 14:00:00	AMZN	Stock	9.9583	9.967	9.918	9.938	6919040.0

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

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