PREVIEW / stock_1hour / 2011-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-29.parquet
  size:    947 KB
  rows:    44,051
  symbols: 3,563

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-29 06:00:00	AAPL	Stock	12.3929	12.3929	12.3718	12.3718	8400.0
2011-04-29 07:00:00	AAPL	Stock	12.385	12.4286	12.385	12.4214	294980.0
2011-04-29 08:00:00	AAPL	Stock	12.4157	12.4282	12.3925	12.3925	554596.0
2011-04-29 09:00:00	AAPL	Stock	12.3893	12.5357	12.3632	12.4914	77668024.0
2011-04-29 10:00:00	AAPL	Stock	12.4904	12.5307	12.4793	12.5011	52092012.0
2011-04-29 11:00:00	AAPL	Stock	12.5011	12.5232	12.4789	12.5137	35593824.0
2011-04-29 12:00:00	AAPL	Stock	12.5146	12.5661	12.5132	12.5495	44934708.0
2011-04-29 13:00:00	AAPL	Stock	12.55	12.6411	12.5489	12.595	60009376.0
2011-04-29 14:00:00	AAPL	Stock	12.5954	12.6382	12.5811	12.6078	55279420.0
2011-04-29 15:00:00	AAPL	Stock	12.6075	12.6268	12.4675	12.4675	223708744.0
2011-04-29 16:00:00	AAPL	Stock	12.4675	12.6097	12.4366	12.4371	265027364.0
2011-04-29 17:00:00	AAPL	Stock	12.5	12.5068	12.4368	12.4968	172145988.0
2011-04-29 18:00:00	AAPL	Stock	12.5018	12.5046	12.4964	12.4968	577584.0
2011-04-29 19:00:00	AAPL	Stock	12.4979	12.5007	12.4893	12.4893	376712.0
2011-04-29 05:00:00	MSFT	Stock	26.36	26.36	26.3	26.3	2500.0
2011-04-29 06:00:00	MSFT	Stock	26.39	26.4	26.38	26.38	12150.0
2011-04-29 07:00:00	MSFT	Stock	26.31	26.55	26.23	26.5	162485.0
2011-04-29 08:00:00	MSFT	Stock	26.5	26.55	26.35	26.49	488446.0
2011-04-29 09:00:00	MSFT	Stock	26.49	26.64	25.88	25.9	24764110.0
2011-04-29 10:00:00	MSFT	Stock	25.88	25.99	25.48	25.63	38332556.0
2011-04-29 11:00:00	MSFT	Stock	25.62	25.71	25.53	25.623	19865527.0
2011-04-29 12:00:00	MSFT	Stock	25.62	25.77	25.58	25.61	14949844.0
2011-04-29 13:00:00	MSFT	Stock	25.605	25.64	25.41	25.44	16359968.0
2011-04-29 14:00:00	MSFT	Stock	25.44	25.69	25.36	25.602	20747059.0
2011-04-29 15:00:00	MSFT	Stock	25.61	26.03	25.505	26.02	59660585.0
2011-04-29 16:00:00	MSFT	Stock	26.02	26.72	25.565	25.97	69630261.0
2011-04-29 17:00:00	MSFT	Stock	25.97	26.02	25.94	25.94	49505893.0
2011-04-29 18:00:00	MSFT	Stock	25.97	26.04	25.92	25.97	74120.0
2011-04-29 19:00:00	MSFT	Stock	25.97	25.97	25.93	25.93	10459.0
2011-04-29 08:00:00	NVDA	Stock	0.4883	0.4883	0.4875	0.4875	108000.0
2011-04-29 09:00:00	NVDA	Stock	0.4883	0.5058	0.4865	0.5003	157856200.0
2011-04-29 10:00:00	NVDA	Stock	0.5	0.511	0.4998	0.51	166305280.0
2011-04-29 11:00:00	NVDA	Stock	0.51	0.5105	0.504	0.5043	119272400.0
2011-04-29 12:00:00	NVDA	Stock	0.5043	0.5062	0.5038	0.505	53044440.0
2011-04-29 13:00:00	NVDA	Stock	0.505	0.506	0.5049	0.505	31594600.0
2011-04-29 14:00:00	NVDA	Stock	0.505	0.5072	0.5035	0.5035	45718520.0
2011-04-29 15:00:00	NVDA	Stock	0.5035	0.5045	0.4998	0.5003	141613960.0
2011-04-29 16:00:00	NVDA	Stock	0.5003	0.504	0.4875	0.5002	6485400.0
2011-04-29 17:00:00	NVDA	Stock	0.5002	0.5002	0.5	0.5	39696920.0
2011-04-29 18:00:00	NVDA	Stock	0.5018	0.5018	0.5018	0.5018	4000.0
2011-04-29 19:00:00	NVDA	Stock	0.501	0.501	0.5003	0.5008	79600.0
2011-04-29 05:00:00	AMZN	Stock	9.794	9.794	9.794	9.794	2000.0
2011-04-29 07:00:00	AMZN	Stock	9.7895	9.8	9.7895	9.7895	32000.0
2011-04-29 08:00:00	AMZN	Stock	9.7545	9.7545	9.71	9.75	54900.0
2011-04-29 09:00:00	AMZN	Stock	9.744	9.8295	9.706	9.74	13414620.0
2011-04-29 10:00:00	AMZN	Stock	9.74	9.7875	9.689	9.7728	15525980.0
2011-04-29 11:00:00	AMZN	Stock	9.774	9.792	9.748	9.7655	8140160.0
2011-04-29 12:00:00	AMZN	Stock	9.768	9.8	9.7583	9.7713	6276360.0
2011-04-29 13:00:00	AMZN	Stock	9.772	9.7764	9.742	9.7435	6257140.0
2011-04-29 14:00:00	AMZN	Stock	9.744	9.781	9.74	9.7658	8530940.0

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

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