PREVIEW / stock_1hour / 2014-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-23.parquet
  size:    1.0 MB
  rows:    49,357
  symbols: 3,549

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
2014-04-23 05:00:00	AAPL	Stock	18.975	18.975	18.975	18.975	3948.0
2014-04-23 07:00:00	AAPL	Stock	18.9804	18.9875	18.9204	18.9214	113512.0
2014-04-23 08:00:00	AAPL	Stock	18.9196	18.9821	18.9107	18.9379	415520.0
2014-04-23 09:00:00	AAPL	Stock	18.9364	18.9689	18.8482	18.9193	30294096.0
2014-04-23 10:00:00	AAPL	Stock	18.9171	18.9221	18.8607	18.9046	28455868.0
2014-04-23 11:00:00	AAPL	Stock	18.9046	18.9164	18.8686	18.8782	23357040.0
2014-04-23 12:00:00	AAPL	Stock	18.8793	18.8996	18.8657	18.8832	19132848.0
2014-04-23 13:00:00	AAPL	Stock	18.8832	18.8913	18.7936	18.8189	25591748.0
2014-04-23 14:00:00	AAPL	Stock	18.8182	18.8507	18.7871	18.8154	24454360.0
2014-04-23 15:00:00	AAPL	Stock	18.8161	18.8193	18.7304	18.7407	46593092.0
2014-04-23 16:00:00	AAPL	Stock	18.7411	20.33	18.6782	20.0543	74942084.0
2014-04-23 17:00:00	AAPL	Stock	20.0561	20.3346	18.7373	20.1725	42397488.0
2014-04-23 18:00:00	AAPL	Stock	18.7411	20.2021	18.7411	20.2021	4514720.0
2014-04-23 19:00:00	AAPL	Stock	20.1964	20.2361	20.1821	20.2196	2585744.0
2014-04-23 07:00:00	MSFT	Stock	39.93	39.93	39.93	39.93	500.0
2014-04-23 08:00:00	MSFT	Stock	39.96	39.99	39.95	39.96	8740.0
2014-04-23 09:00:00	MSFT	Stock	39.96	40.01	39.67	39.7	3580598.0
2014-04-23 10:00:00	MSFT	Stock	39.7	39.7	39.47	39.56	4580513.0
2014-04-23 11:00:00	MSFT	Stock	39.55	39.66	39.48	39.56	2593085.0
2014-04-23 12:00:00	MSFT	Stock	39.56	39.66	39.48	39.635	1394609.0
2014-04-23 13:00:00	MSFT	Stock	39.64	39.68	39.54	39.63	1357673.0
2014-04-23 14:00:00	MSFT	Stock	39.625	39.74	39.6	39.72	1608266.0
2014-04-23 15:00:00	MSFT	Stock	39.725	39.8	39.64	39.68	5435128.0
2014-04-23 16:00:00	MSFT	Stock	39.69	39.8	39.505	39.75	3073837.0
2014-04-23 17:00:00	MSFT	Stock	39.75	39.8	39.682	39.78	59207.0
2014-04-23 18:00:00	MSFT	Stock	39.74	39.89	39.72	39.85	11266.0
2014-04-23 19:00:00	MSFT	Stock	39.86	39.87	39.83	39.87	12970.0
2014-04-23 09:00:00	NVDA	Stock	0.4718	0.4768	0.4718	0.4745	28570240.0
2014-04-23 10:00:00	NVDA	Stock	0.4748	0.4763	0.472	0.4753	26368600.0
2014-04-23 11:00:00	NVDA	Stock	0.4753	0.4785	0.475	0.4781	45449560.0
2014-04-23 12:00:00	NVDA	Stock	0.4782	0.4782	0.4754	0.4765	16698480.0
2014-04-23 13:00:00	NVDA	Stock	0.4764	0.4775	0.4753	0.4773	26916000.0
2014-04-23 14:00:00	NVDA	Stock	0.4775	0.4775	0.4749	0.4763	22120600.0
2014-04-23 15:00:00	NVDA	Stock	0.4763	0.4775	0.4758	0.4772	75766960.0
2014-04-23 16:00:00	NVDA	Stock	0.4772	0.4812	0.4718	0.48	8298920.0
2014-04-23 17:00:00	NVDA	Stock	0.4772	0.4772	0.4772	0.4772	327120.0
2014-04-23 19:00:00	NVDA	Stock	0.48	0.48	0.48	0.48	4000.0
2014-04-23 07:00:00	AMZN	Stock	16.4745	16.4745	16.4375	16.4375	4000.0
2014-04-23 08:00:00	AMZN	Stock	16.4745	16.4745	16.375	16.389	635400.0
2014-04-23 09:00:00	AMZN	Stock	16.4065	16.7605	16.302	16.4113	11324020.0
2014-04-23 10:00:00	AMZN	Stock	16.398	16.4165	16.2765	16.2935	7470140.0
2014-04-23 11:00:00	AMZN	Stock	16.293	16.3685	16.2275	16.3365	7953600.0
2014-04-23 12:00:00	AMZN	Stock	16.338	16.3435	16.183	16.2475	7512680.0
2014-04-23 13:00:00	AMZN	Stock	16.2475	16.278	16.2015	16.2205	5806840.0
2014-04-23 14:00:00	AMZN	Stock	16.2241	16.2425	16.1695	16.196	8175180.0
2014-04-23 15:00:00	AMZN	Stock	16.1925	16.254	16.1895	16.229	12865660.0
2014-04-23 16:00:00	AMZN	Stock	16.229	16.466	16.224	16.357	3037320.0
2014-04-23 17:00:00	AMZN	Stock	16.3895	16.48	16.2258	16.4	361480.0
2014-04-23 18:00:00	AMZN	Stock	16.229	16.425	16.229	16.229	229760.0
2014-04-23 19:00:00	AMZN	Stock	16.4185	16.47	16.4025	16.45	49400.0

> showing 50 of 49,357 rows — these rows as CSV

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