PREVIEW / stock_1hour / 2011-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-18.parquet
  size:    943 KB
  rows:    46,333
  symbols: 3,527

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-10-18 04:00:00	AAPL	Stock	14.945	14.945	14.945	14.945	2800.0
2011-10-18 05:00:00	AAPL	Stock	14.9821	14.9907	14.9414	14.9414	18200.0
2011-10-18 06:00:00	AAPL	Stock	14.9464	14.9464	14.9464	14.9464	2800.0
2011-10-18 07:00:00	AAPL	Stock	14.9886	15.0089	14.9286	14.9375	601580.0
2011-10-18 08:00:00	AAPL	Stock	14.9561	15.0714	14.9286	15.0618	3920924.0
2011-10-18 09:00:00	AAPL	Stock	15.0625	15.1029	14.905	14.9732	83057716.0
2011-10-18 10:00:00	AAPL	Stock	14.9736	14.9964	14.8568	14.9881	106203776.0
2011-10-18 11:00:00	AAPL	Stock	14.989	15.0661	14.9407	15.0586	74236512.0
2011-10-18 12:00:00	AAPL	Stock	15.0598	15.0714	14.9617	14.9818	55212808.0
2011-10-18 13:00:00	AAPL	Stock	14.9843	15.0429	14.9143	15.0339	59044776.0
2011-10-18 14:00:00	AAPL	Stock	15.0364	15.0571	15.0143	15.0254	61596640.0
2011-10-18 15:00:00	AAPL	Stock	15.0261	15.1717	15.0232	15.0671	215693100.0
2011-10-18 16:00:00	AAPL	Stock	15.0557	15.2071	13.8896	14.1057	149429532.0
2011-10-18 17:00:00	AAPL	Stock	14.1061	15.08	14.0039	14.0707	48409172.0
2011-10-18 18:00:00	AAPL	Stock	14.0714	15.08	14.0704	14.0982	7463176.0
2011-10-18 19:00:00	AAPL	Stock	14.1	14.1046	14.0643	14.0732	5786256.0
2011-10-18 06:00:00	MSFT	Stock	26.97	26.97	26.97	26.97	3000.0
2011-10-18 07:00:00	MSFT	Stock	26.86	26.93	26.76	26.76	9200.0
2011-10-18 08:00:00	MSFT	Stock	26.78	26.9	26.75	26.86	36299.0
2011-10-18 09:00:00	MSFT	Stock	26.86	27.08	26.8	26.9	3296271.0
2011-10-18 10:00:00	MSFT	Stock	26.9	27.16	26.83	27.03	6702477.0
2011-10-18 11:00:00	MSFT	Stock	27.025	27.19	26.94	27.11	5437926.0
2011-10-18 12:00:00	MSFT	Stock	27.11	27.2	27.04	27.14	3851274.0
2011-10-18 13:00:00	MSFT	Stock	27.14	27.19	27.04	27.14	3270992.0
2011-10-18 14:00:00	MSFT	Stock	27.14	27.18	27.01	27.05	5551196.0
2011-10-18 15:00:00	MSFT	Stock	27.045	27.4	27.04	27.285	20288403.0
2011-10-18 16:00:00	MSFT	Stock	27.29	27.42	26.893	27.24	3463805.0
2011-10-18 17:00:00	MSFT	Stock	27.25	27.35	26.92	27.3	152092.0
2011-10-18 18:00:00	MSFT	Stock	27.3	27.31	27.28	27.3	26346.0
2011-10-18 19:00:00	MSFT	Stock	27.32	27.35	27.31	27.31	3902.0
2011-10-18 08:00:00	NVDA	Stock	0.3705	0.3708	0.3688	0.3708	145160.0
2011-10-18 09:00:00	NVDA	Stock	0.3708	0.377	0.3692	0.3723	60067720.0
2011-10-18 10:00:00	NVDA	Stock	0.3723	0.3862	0.3705	0.382	145577760.0
2011-10-18 11:00:00	NVDA	Stock	0.382	0.3848	0.3793	0.3838	53206720.0
2011-10-18 12:00:00	NVDA	Stock	0.3838	0.3842	0.3809	0.382	29429400.0
2011-10-18 13:00:00	NVDA	Stock	0.382	0.3835	0.3798	0.3828	36000520.0
2011-10-18 14:00:00	NVDA	Stock	0.383	0.3842	0.3808	0.382	41251560.0
2011-10-18 15:00:00	NVDA	Stock	0.382	0.388	0.3818	0.387	201040720.0
2011-10-18 16:00:00	NVDA	Stock	0.3865	0.3928	0.3824	0.39	20964320.0
2011-10-18 17:00:00	NVDA	Stock	0.3875	0.3888	0.3853	0.3853	532640.0
2011-10-18 18:00:00	NVDA	Stock	0.3853	0.387	0.3853	0.3853	56000.0
2011-10-18 19:00:00	NVDA	Stock	0.385	0.387	0.3838	0.3838	48000.0
2011-10-18 04:00:00	AMZN	Stock	12.0715	12.0815	12.056	12.07	12000.0
2011-10-18 05:00:00	AMZN	Stock	12.044	12.096	12.044	12.096	10000.0
2011-10-18 06:00:00	AMZN	Stock	12.1	12.1	12.1	12.1	2000.0
2011-10-18 07:00:00	AMZN	Stock	12.068	12.0805	12.04	12.04	30000.0
2011-10-18 08:00:00	AMZN	Stock	12.0425	12.089	12.025	12.0865	130260.0
2011-10-18 09:00:00	AMZN	Stock	12.075	12.1405	11.9125	12.0	13255120.0
2011-10-18 10:00:00	AMZN	Stock	12.0	12.0	11.8312	11.9924	16987760.0
2011-10-18 11:00:00	AMZN	Stock	11.992	12.08	11.901	12.0461	10022720.0

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

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