PREVIEW / stock_1hour / 2011-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-17.parquet
  size:    938 KB
  rows:    44,356
  symbols: 3,517

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-17 04:00:00	AAPL	Stock	11.8071	11.8757	11.8046	11.8214	238000.0
2011-03-17 05:00:00	AAPL	Stock	11.8304	11.8857	11.8218	11.8654	119000.0
2011-03-17 06:00:00	AAPL	Stock	11.8575	11.875	11.8214	11.8321	410340.0
2011-03-17 07:00:00	AAPL	Stock	11.8432	11.9	11.8268	11.885	2264640.0
2011-03-17 08:00:00	AAPL	Stock	11.8775	11.9982	11.8714	11.9886	9091376.0
2011-03-17 09:00:00	AAPL	Stock	11.9904	12.0975	11.9882	12.0407	149714936.0
2011-03-17 10:00:00	AAPL	Stock	12.041	12.1129	12.0179	12.0979	118712720.0
2011-03-17 11:00:00	AAPL	Stock	12.0973	12.1289	12.0682	12.0736	83450780.0
2011-03-17 12:00:00	AAPL	Stock	12.0745	12.0986	12.0629	12.0821	40346768.0
2011-03-17 13:00:00	AAPL	Stock	12.0824	12.0968	11.9996	12.0143	73403876.0
2011-03-17 14:00:00	AAPL	Stock	12.0146	12.0439	11.9682	12.0364	63167356.0
2011-03-17 15:00:00	AAPL	Stock	12.0343	12.0425	11.9364	11.9461	91575848.0
2011-03-17 16:00:00	AAPL	Stock	11.9486	12.044	11.9114	11.9293	13657980.0
2011-03-17 17:00:00	AAPL	Stock	11.9339	11.9514	11.9093	11.9286	819672.0
2011-03-17 18:00:00	AAPL	Stock	11.9286	11.9514	11.9107	11.9107	474292.0
2011-03-17 19:00:00	AAPL	Stock	11.9089	11.9357	11.8993	11.9357	619696.0
2011-03-17 04:00:00	MSFT	Stock	24.76	24.9	24.76	24.9	1270.0
2011-03-17 05:00:00	MSFT	Stock	24.95	24.95	24.95	24.95	400.0
2011-03-17 06:00:00	MSFT	Stock	24.83	24.83	24.83	24.83	100.0
2011-03-17 07:00:00	MSFT	Stock	24.86	24.95	24.86	24.95	6383.0
2011-03-17 08:00:00	MSFT	Stock	24.93	25.04	24.92	25.0	92202.0
2011-03-17 09:00:00	MSFT	Stock	25.05	25.08	24.93	25.0	5579595.0
2011-03-17 10:00:00	MSFT	Stock	25.01	25.16	24.95	25.03	7687589.0
2011-03-17 11:00:00	MSFT	Stock	25.03	25.2	25.022	25.12	11455657.0
2011-03-17 12:00:00	MSFT	Stock	25.12	25.22	25.07	25.075	4488973.0
2011-03-17 13:00:00	MSFT	Stock	25.075	25.15	24.8	24.83	7744700.0
2011-03-17 14:00:00	MSFT	Stock	24.84	24.92	24.8	24.899	5793605.0
2011-03-17 15:00:00	MSFT	Stock	24.89	24.94	24.75	24.8	15448959.0
2011-03-17 16:00:00	MSFT	Stock	24.79	25.15	24.73	24.76	3373841.0
2011-03-17 17:00:00	MSFT	Stock	24.75	24.78	24.75	24.76	90282.0
2011-03-17 18:00:00	MSFT	Stock	24.76	24.78	24.75	24.78	16666.0
2011-03-17 19:00:00	MSFT	Stock	24.76	24.78	24.72	24.72	8550.0
2011-03-17 07:00:00	NVDA	Stock	0.4548	0.4548	0.4468	0.4468	29600.0
2011-03-17 08:00:00	NVDA	Stock	0.4448	0.4512	0.4445	0.45	2261120.0
2011-03-17 09:00:00	NVDA	Stock	0.45	0.4512	0.437	0.438	138417280.0
2011-03-17 10:00:00	NVDA	Stock	0.438	0.44	0.43	0.44	318907680.0
2011-03-17 11:00:00	NVDA	Stock	0.44	0.4448	0.4372	0.4398	168633120.0
2011-03-17 12:00:00	NVDA	Stock	0.4396	0.4458	0.4395	0.4435	122609720.0
2011-03-17 13:00:00	NVDA	Stock	0.4432	0.4458	0.4415	0.4435	135531480.0
2011-03-17 14:00:00	NVDA	Stock	0.4435	0.4468	0.4428	0.4458	99723400.0
2011-03-17 15:00:00	NVDA	Stock	0.4455	0.4488	0.4425	0.4465	228051560.0
2011-03-17 16:00:00	NVDA	Stock	0.4462	0.4475	0.4415	0.4472	15230960.0
2011-03-17 17:00:00	NVDA	Stock	0.4475	0.4475	0.4465	0.447	342680.0
2011-03-17 18:00:00	NVDA	Stock	0.4465	0.4465	0.445	0.445	213320.0
2011-03-17 19:00:00	NVDA	Stock	0.444	0.445	0.4428	0.4428	264000.0
2011-03-17 05:00:00	AMZN	Stock	8.2685	8.2685	8.2685	8.2685	4000.0
2011-03-17 06:00:00	AMZN	Stock	8.283	8.283	8.283	8.283	2000.0
2011-03-17 07:00:00	AMZN	Stock	8.304	8.305	8.272	8.305	25500.0
2011-03-17 08:00:00	AMZN	Stock	8.3	8.327	8.295	8.3025	128880.0
2011-03-17 09:00:00	AMZN	Stock	8.295	8.315	8.158	8.191	18936760.0

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

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