PREVIEW / stock_1hour / 2011-02-10

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-10.parquet
  size:    944 KB
  rows:    44,884
  symbols: 3,541

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-02-10 04:00:00	AAPL	Stock	12.7089	12.7089	12.6764	12.6929	78400.0
2011-02-10 05:00:00	AAPL	Stock	12.7046	12.725	12.7046	12.7143	71400.0
2011-02-10 06:00:00	AAPL	Stock	12.6893	12.7411	12.6893	12.7411	53200.0
2011-02-10 07:00:00	AAPL	Stock	12.7143	12.7807	12.7036	12.7357	538524.0
2011-02-10 08:00:00	AAPL	Stock	12.7382	12.7479	12.6936	12.7296	2950444.0
2011-02-10 09:00:00	AAPL	Stock	12.7286	12.7807	12.7189	12.7539	70695632.0
2011-02-10 10:00:00	AAPL	Stock	12.7529	12.8511	12.7404	12.8218	106189076.0
2011-02-10 11:00:00	AAPL	Stock	12.8204	12.8571	12.8143	12.8364	66431624.0
2011-02-10 12:00:00	AAPL	Stock	12.8361	12.8482	12.8018	12.8193	45787476.0
2011-02-10 13:00:00	AAPL	Stock	12.8193	12.8232	12.4286	12.62	257682572.0
2011-02-10 14:00:00	AAPL	Stock	12.6204	12.7307	12.5904	12.6693	146113576.0
2011-02-10 15:00:00	AAPL	Stock	12.6696	12.7036	12.5932	12.6621	199369408.0
2011-02-10 16:00:00	AAPL	Stock	12.6636	12.7863	12.6293	12.6318	15166788.0
2011-02-10 17:00:00	AAPL	Stock	12.6325	12.7644	12.6125	12.6254	724332.0
2011-02-10 18:00:00	AAPL	Stock	12.6254	12.6621	12.6254	12.6486	590996.0
2011-02-10 19:00:00	AAPL	Stock	12.65	12.65	12.6357	12.6464	488180.0
2011-02-10 04:00:00	MSFT	Stock	27.8	27.8	27.7	27.7	600.0
2011-02-10 06:00:00	MSFT	Stock	27.7	27.72	27.7	27.72	3000.0
2011-02-10 07:00:00	MSFT	Stock	27.78	27.83	27.78	27.83	1200.0
2011-02-10 08:00:00	MSFT	Stock	27.83	27.9	27.78	27.84	29325.0
2011-02-10 09:00:00	MSFT	Stock	27.85	27.94	27.36	27.398	11839009.0
2011-02-10 10:00:00	MSFT	Stock	27.398	27.56	27.29	27.52	15002819.0
2011-02-10 11:00:00	MSFT	Stock	27.518	27.62	27.45	27.459	7965745.0
2011-02-10 12:00:00	MSFT	Stock	27.459	27.48	27.41	27.415	5669152.0
2011-02-10 13:00:00	MSFT	Stock	27.41	27.45	27.36	27.4	6237432.0
2011-02-10 14:00:00	MSFT	Stock	27.4	27.45	27.32	27.411	8516395.0
2011-02-10 15:00:00	MSFT	Stock	27.41	27.5	27.32	27.485	17745329.0
2011-02-10 16:00:00	MSFT	Stock	27.5	27.97	27.37	27.37	2627324.0
2011-02-10 17:00:00	MSFT	Stock	27.37	27.43	27.35	27.4	10822.0
2011-02-10 18:00:00	MSFT	Stock	27.43	27.5	27.43	27.43	9002.0
2011-02-10 19:00:00	MSFT	Stock	27.44	27.45	27.4	27.45	4315.0
2011-02-10 07:00:00	NVDA	Stock	0.5755	0.5762	0.5752	0.5755	287600.0
2011-02-10 08:00:00	NVDA	Stock	0.5775	0.5775	0.5668	0.5702	4398080.0
2011-02-10 09:00:00	NVDA	Stock	0.571	0.576	0.565	0.5725	163397920.0
2011-02-10 10:00:00	NVDA	Stock	0.5725	0.5802	0.57	0.572	238779400.0
2011-02-10 11:00:00	NVDA	Stock	0.5718	0.5748	0.5688	0.5712	131806560.0
2011-02-10 12:00:00	NVDA	Stock	0.5712	0.5768	0.5698	0.57	100472560.0
2011-02-10 13:00:00	NVDA	Stock	0.5702	0.5718	0.567	0.5685	103352000.0
2011-02-10 14:00:00	NVDA	Stock	0.5685	0.5715	0.5674	0.5695	84881480.0
2011-02-10 15:00:00	NVDA	Stock	0.5697	0.5705	0.5652	0.5705	197850240.0
2011-02-10 16:00:00	NVDA	Stock	0.5705	0.5825	0.5685	0.5705	14476560.0
2011-02-10 17:00:00	NVDA	Stock	0.5705	0.5712	0.5688	0.5688	272000.0
2011-02-10 18:00:00	NVDA	Stock	0.5688	0.57	0.5668	0.5668	308000.0
2011-02-10 19:00:00	NVDA	Stock	0.567	0.5698	0.5668	0.567	407360.0
2011-02-10 08:00:00	AMZN	Stock	9.1975	9.2245	9.1865	9.21	100780.0
2011-02-10 09:00:00	AMZN	Stock	9.203	9.2745	9.18	9.2395	15920480.0
2011-02-10 10:00:00	AMZN	Stock	9.2406	9.332	9.216	9.286	21298940.0
2011-02-10 11:00:00	AMZN	Stock	9.285	9.362	9.275	9.3495	14962760.0
2011-02-10 12:00:00	AMZN	Stock	9.347	9.3555	9.3115	9.317	8298600.0
2011-02-10 13:00:00	AMZN	Stock	9.318	9.3312	9.2585	9.305	11660520.0

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

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