PREVIEW / stock_1hour / 2014-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-10.parquet
  size:    1.0 MB
  rows:    49,372
  symbols: 3,552

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-06-10 04:00:00	AAPL	Stock	23.45	23.6075	23.45	23.56	156824.0
2014-06-10 05:00:00	AAPL	Stock	23.55	23.625	23.54	23.55	141100.0
2014-06-10 06:00:00	AAPL	Stock	23.55	23.5725	23.5225	23.535	162132.0
2014-06-10 07:00:00	AAPL	Stock	23.525	23.5375	23.45	23.49	351112.0
2014-06-10 08:00:00	AAPL	Stock	23.4925	23.5875	23.45	23.5125	837412.0
2014-06-10 09:00:00	AAPL	Stock	23.515	23.7625	23.5025	23.575	62489208.0
2014-06-10 10:00:00	AAPL	Stock	23.575	23.6375	23.475	23.575	47510592.0
2014-06-10 11:00:00	AAPL	Stock	23.575	23.63	23.4375	23.4975	30471520.0
2014-06-10 12:00:00	AAPL	Stock	23.4975	23.4992	23.3925	23.45	22908040.0
2014-06-10 13:00:00	AAPL	Stock	23.45	23.505	23.415	23.4975	15495368.0
2014-06-10 14:00:00	AAPL	Stock	23.495	23.5625	23.48	23.5495	16468428.0
2014-06-10 15:00:00	AAPL	Stock	23.5475	23.565	23.525	23.5625	25061520.0
2014-06-10 16:00:00	AAPL	Stock	23.5625	23.575	23.5435	23.5625	6718420.0
2014-06-10 17:00:00	AAPL	Stock	23.5625	23.57	23.5575	23.5625	159228.0
2014-06-10 18:00:00	AAPL	Stock	23.5625	23.5675	23.55	23.56	125068.0
2014-06-10 19:00:00	AAPL	Stock	23.5625	23.575	23.55	23.5725	201688.0
2014-06-10 07:00:00	MSFT	Stock	41.13	41.16	41.13	41.16	200.0
2014-06-10 08:00:00	MSFT	Stock	41.05	41.15	41.05	41.15	2027.0
2014-06-10 09:00:00	MSFT	Stock	41.16	41.16	40.86	41.0	2706289.0
2014-06-10 10:00:00	MSFT	Stock	41.01	41.14	41.0	41.134	1939398.0
2014-06-10 11:00:00	MSFT	Stock	41.13	41.16	41.021	41.07	1054072.0
2014-06-10 12:00:00	MSFT	Stock	41.07	41.13	41.04	41.1	904148.0
2014-06-10 13:00:00	MSFT	Stock	41.11	41.11	41.02	41.103	974195.0
2014-06-10 14:00:00	MSFT	Stock	41.1	41.109	41.015	41.028	1185724.0
2014-06-10 15:00:00	MSFT	Stock	41.025	41.14	41.02	41.11	3057557.0
2014-06-10 16:00:00	MSFT	Stock	41.11	41.11	41.08	41.08	2051644.0
2014-06-10 17:00:00	MSFT	Stock	41.1	41.1	41.1	41.1	4900.0
2014-06-10 18:00:00	MSFT	Stock	41.09	41.09	41.08	41.08	597.0
2014-06-10 19:00:00	MSFT	Stock	41.11	41.11	41.11	41.11	1000.0
2014-06-10 09:00:00	NVDA	Stock	0.4753	0.4772	0.4725	0.477	23957400.0
2014-06-10 10:00:00	NVDA	Stock	0.4768	0.478	0.4758	0.4774	42453400.0
2014-06-10 11:00:00	NVDA	Stock	0.4772	0.4775	0.4763	0.4768	16305520.0
2014-06-10 12:00:00	NVDA	Stock	0.4768	0.4785	0.4759	0.4763	21376360.0
2014-06-10 13:00:00	NVDA	Stock	0.4763	0.477	0.4755	0.476	17179160.0
2014-06-10 14:00:00	NVDA	Stock	0.476	0.481	0.4755	0.4785	36894120.0
2014-06-10 15:00:00	NVDA	Stock	0.4786	0.4795	0.4782	0.4786	40660960.0
2014-06-10 16:00:00	NVDA	Stock	0.4788	0.4793	0.477	0.4793	13558760.0
2014-06-10 17:00:00	NVDA	Stock	0.4793	0.4793	0.4788	0.4788	195560.0
2014-06-10 07:00:00	AMZN	Stock	16.3985	16.44	16.3985	16.406	27860.0
2014-06-10 08:00:00	AMZN	Stock	16.419	16.435	16.3995	16.3995	278340.0
2014-06-10 09:00:00	AMZN	Stock	16.3835	16.665	16.374	16.5615	13520280.0
2014-06-10 10:00:00	AMZN	Stock	16.553	16.725	16.4715	16.675	15625440.0
2014-06-10 11:00:00	AMZN	Stock	16.675	16.7745	16.647	16.768	9558260.0
2014-06-10 12:00:00	AMZN	Stock	16.7695	16.7745	16.617	16.7055	6491440.0
2014-06-10 13:00:00	AMZN	Stock	16.7083	16.775	16.67	16.693	5077580.0
2014-06-10 14:00:00	AMZN	Stock	16.697	16.6995	16.596	16.6145	5155960.0
2014-06-10 15:00:00	AMZN	Stock	16.6105	16.632	16.589	16.6195	8553660.0
2014-06-10 16:00:00	AMZN	Stock	16.6205	16.639	16.6	16.616	242460.0
2014-06-10 17:00:00	AMZN	Stock	16.642	16.6445	16.64	16.64	32080.0
2014-06-10 18:00:00	AMZN	Stock	16.644	16.6445	16.615	16.6445	41000.0

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

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