PREVIEW / stock_1hour / 2011-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-06.parquet
  size:    936 KB
  rows:    44,024
  symbols: 3,520

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-01-06 05:00:00	AAPL	Stock	11.9968	11.9989	11.9661	11.9989	30800.0
2011-01-06 06:00:00	AAPL	Stock	12.0025	12.0321	11.9532	12.0036	73920.0
2011-01-06 07:00:00	AAPL	Stock	12.0089	12.0107	11.985	11.9871	225540.0
2011-01-06 08:00:00	AAPL	Stock	11.9821	12.0168	11.9286	11.9836	1988560.0
2011-01-06 09:00:00	AAPL	Stock	11.9796	11.9854	11.9129	11.9464	43979964.0
2011-01-06 10:00:00	AAPL	Stock	11.9464	11.9732	11.9375	11.9489	43758036.0
2011-01-06 11:00:00	AAPL	Stock	11.9486	11.9636	11.925	11.9418	39494532.0
2011-01-06 12:00:00	AAPL	Stock	11.9418	11.9479	11.9261	11.9304	21662928.0
2011-01-06 13:00:00	AAPL	Stock	11.9293	11.9457	11.9179	11.9439	24917060.0
2011-01-06 14:00:00	AAPL	Stock	11.9439	11.9489	11.8893	11.9075	31543120.0
2011-01-06 15:00:00	AAPL	Stock	11.9075	11.9357	11.8893	11.9161	50565060.0
2011-01-06 16:00:00	AAPL	Stock	11.9189	11.9354	11.9044	11.9154	32752608.0
2011-01-06 17:00:00	AAPL	Stock	11.9154	11.9214	11.9154	11.9214	30744.0
2011-01-06 18:00:00	AAPL	Stock	11.9171	11.9293	11.9121	11.9125	278264.0
2011-01-06 19:00:00	AAPL	Stock	11.9129	11.9196	11.9061	11.9125	301980.0
2011-01-06 04:00:00	MSFT	Stock	28.12	28.12	28.12	28.12	300.0
2011-01-06 07:00:00	MSFT	Stock	28.12	28.12	28.04	28.05	2700.0
2011-01-06 08:00:00	MSFT	Stock	28.03	28.13	27.45	28.08	397465.0
2011-01-06 09:00:00	MSFT	Stock	28.08	28.11	27.86	27.99	6834324.0
2011-01-06 10:00:00	MSFT	Stock	27.99	28.03	27.92	28.03	9927110.0
2011-01-06 11:00:00	MSFT	Stock	28.02	28.34	27.98	28.33	14838814.0
2011-01-06 12:00:00	MSFT	Stock	28.325	28.5	28.23	28.475	11944558.0
2011-01-06 13:00:00	MSFT	Stock	28.47	28.525	28.43	28.5	7726019.0
2011-01-06 14:00:00	MSFT	Stock	28.49	28.67	28.49	28.66	12206711.0
2011-01-06 15:00:00	MSFT	Stock	28.66	28.85	28.63	28.81	18558643.0
2011-01-06 16:00:00	MSFT	Stock	28.81	28.85	28.375	28.7	3771091.0
2011-01-06 17:00:00	MSFT	Stock	28.7	28.77	28.7	28.72	13330.0
2011-01-06 18:00:00	MSFT	Stock	28.77	28.82	28.72	28.77	28365.0
2011-01-06 19:00:00	MSFT	Stock	28.77	28.79	28.73	28.76	5161.0
2011-01-06 07:00:00	NVDA	Stock	0.4345	0.4372	0.4325	0.4325	926000.0
2011-01-06 08:00:00	NVDA	Stock	0.4322	0.4392	0.43	0.4388	6982560.0
2011-01-06 09:00:00	NVDA	Stock	0.4388	0.4595	0.4335	0.4548	552976120.0
2011-01-06 10:00:00	NVDA	Stock	0.4548	0.4615	0.454	0.4598	457200400.0
2011-01-06 11:00:00	NVDA	Stock	0.4598	0.46	0.4545	0.4576	266237000.0
2011-01-06 12:00:00	NVDA	Stock	0.4575	0.4585	0.456	0.458	194815680.0
2011-01-06 13:00:00	NVDA	Stock	0.4579	0.4793	0.457	0.4748	633772880.0
2011-01-06 14:00:00	NVDA	Stock	0.4745	0.4835	0.4698	0.471	660503480.0
2011-01-06 15:00:00	NVDA	Stock	0.4708	0.4835	0.47	0.4835	671757120.0
2011-01-06 16:00:00	NVDA	Stock	0.4828	0.4848	0.4574	0.4835	13151080.0
2011-01-06 17:00:00	NVDA	Stock	0.4835	0.486	0.4832	0.4838	855520.0
2011-01-06 18:00:00	NVDA	Stock	0.485	0.4875	0.484	0.4862	1134600.0
2011-01-06 19:00:00	NVDA	Stock	0.486	0.4868	0.484	0.4862	182520.0
2011-01-06 04:00:00	AMZN	Stock	9.3825	9.3825	9.3825	9.3825	2000.0
2011-01-06 06:00:00	AMZN	Stock	9.375	9.453	9.375	9.425	12000.0
2011-01-06 07:00:00	AMZN	Stock	9.4	9.4285	9.4	9.4285	4000.0
2011-01-06 08:00:00	AMZN	Stock	9.425	9.425	9.34	9.3445	270560.0
2011-01-06 09:00:00	AMZN	Stock	9.3425	9.3695	9.3005	9.3348	8584400.0
2011-01-06 10:00:00	AMZN	Stock	9.3355	9.3705	9.3205	9.335	12186360.0
2011-01-06 11:00:00	AMZN	Stock	9.3345	9.338	9.2625	9.3175	12042160.0
2011-01-06 12:00:00	AMZN	Stock	9.317	9.3245	9.279	9.29	6834540.0

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

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