PREVIEW / stock_1hour / 2011-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-28.parquet
  size:    946 KB
  rows:    44,517
  symbols: 3,566

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-04-28 04:00:00	AAPL	Stock	12.5	12.5	12.5	12.5	2800.0
2011-04-28 05:00:00	AAPL	Stock	12.4993	12.4993	12.4911	12.4911	22400.0
2011-04-28 06:00:00	AAPL	Stock	12.4918	12.4918	12.4679	12.4679	14448.0
2011-04-28 07:00:00	AAPL	Stock	12.48	12.4921	12.4468	12.4529	236796.0
2011-04-28 08:00:00	AAPL	Stock	12.4468	12.4743	12.4107	12.4107	2821084.0
2011-04-28 09:00:00	AAPL	Stock	12.4118	12.4911	12.3475	12.4582	76086388.0
2011-04-28 10:00:00	AAPL	Stock	12.4575	12.4732	12.4132	12.4345	45472196.0
2011-04-28 11:00:00	AAPL	Stock	12.4371	12.4571	12.3821	12.3882	44918468.0
2011-04-28 12:00:00	AAPL	Stock	12.3893	12.4179	12.375	12.3854	27042316.0
2011-04-28 13:00:00	AAPL	Stock	12.3843	12.3943	12.34	12.3893	40882800.0
2011-04-28 14:00:00	AAPL	Stock	12.39	12.392	12.3618	12.3686	24709776.0
2011-04-28 15:00:00	AAPL	Stock	12.3693	12.3979	12.3589	12.3968	67678016.0
2011-04-28 16:00:00	AAPL	Stock	12.3986	12.4232	12.3543	12.3846	20823460.0
2011-04-28 17:00:00	AAPL	Stock	12.3868	12.4107	12.3864	12.4107	2032688.0
2011-04-28 18:00:00	AAPL	Stock	12.4104	12.4107	12.3839	12.3929	283164.0
2011-04-28 19:00:00	AAPL	Stock	12.3929	12.4104	12.3929	12.3932	120344.0
2011-04-28 04:00:00	MSFT	Stock	26.49	26.49	26.49	26.49	100.0
2011-04-28 05:00:00	MSFT	Stock	26.48	26.5	26.47	26.48	2400.0
2011-04-28 06:00:00	MSFT	Stock	26.48	26.48	26.43	26.43	4100.0
2011-04-28 07:00:00	MSFT	Stock	26.46	26.48	26.44	26.47	38300.0
2011-04-28 08:00:00	MSFT	Stock	26.46	26.5	26.37	26.43	102548.0
2011-04-28 09:00:00	MSFT	Stock	26.45	26.55	26.42	26.545	6639480.0
2011-04-28 10:00:00	MSFT	Stock	26.54	26.55	26.4	26.48	8261926.0
2011-04-28 11:00:00	MSFT	Stock	26.488	26.55	26.48	26.52	6065983.0
2011-04-28 12:00:00	MSFT	Stock	26.51	26.68	26.51	26.665	7389186.0
2011-04-28 13:00:00	MSFT	Stock	26.66	26.71	26.57	26.656	6655461.0
2011-04-28 14:00:00	MSFT	Stock	26.654	26.77	26.6	26.691	10250229.0
2011-04-28 15:00:00	MSFT	Stock	26.69	26.87	26.58	26.71	22901455.0
2011-04-28 16:00:00	MSFT	Stock	26.71	27.17	25.97	26.21	8431049.0
2011-04-28 17:00:00	MSFT	Stock	26.23	26.72	26.14	26.25	942499.0
2011-04-28 18:00:00	MSFT	Stock	26.26	26.71	26.25	26.38	214295.0
2011-04-28 19:00:00	MSFT	Stock	26.35	26.4	26.31	26.33	71030.0
2011-04-28 08:00:00	NVDA	Stock	0.4788	0.4818	0.4788	0.4793	60000.0
2011-04-28 09:00:00	NVDA	Stock	0.4793	0.4888	0.477	0.4885	76196440.0
2011-04-28 10:00:00	NVDA	Stock	0.4885	0.495	0.486	0.495	164379760.0
2011-04-28 11:00:00	NVDA	Stock	0.4948	0.4975	0.489	0.4898	151813840.0
2011-04-28 12:00:00	NVDA	Stock	0.4898	0.4898	0.4855	0.4858	75931760.0
2011-04-28 13:00:00	NVDA	Stock	0.4855	0.4862	0.483	0.485	50413720.0
2011-04-28 14:00:00	NVDA	Stock	0.485	0.4892	0.4838	0.4878	46038600.0
2011-04-28 15:00:00	NVDA	Stock	0.4878	0.4898	0.487	0.4875	83772200.0
2011-04-28 16:00:00	NVDA	Stock	0.4875	0.4891	0.487	0.487	34536560.0
2011-04-28 17:00:00	NVDA	Stock	0.4875	0.4875	0.485	0.485	1304080.0
2011-04-28 18:00:00	NVDA	Stock	0.4838	0.4862	0.4832	0.4838	76000.0
2011-04-28 19:00:00	NVDA	Stock	0.4848	0.485	0.4838	0.4838	94400.0
2011-04-28 06:00:00	AMZN	Stock	9.833	9.833	9.833	9.833	2000.0
2011-04-28 07:00:00	AMZN	Stock	9.8155	9.82	9.8005	9.8005	22000.0
2011-04-28 08:00:00	AMZN	Stock	9.813	9.813	9.76	9.79	334780.0
2011-04-28 09:00:00	AMZN	Stock	9.8	9.8395	9.7375	9.82	27603960.0
2011-04-28 10:00:00	AMZN	Stock	9.82	9.8295	9.692	9.7675	29910700.0
2011-04-28 11:00:00	AMZN	Stock	9.77	9.7744	9.638	9.6415	17998620.0

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

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