PREVIEW / stock_1hour / 2014-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-13.parquet
  size:    1.0 MB
  rows:    48,483
  symbols: 3,571

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-08-13 04:00:00	AAPL	Stock	24.0725	24.0725	24.0025	24.0225	56976.0
2014-08-13 05:00:00	AAPL	Stock	24.0275	24.0275	23.9975	24.0275	37504.0
2014-08-13 06:00:00	AAPL	Stock	24.0275	24.07	24.0275	24.065	32844.0
2014-08-13 07:00:00	AAPL	Stock	24.0625	24.0975	24.0525	24.0875	89624.0
2014-08-13 08:00:00	AAPL	Stock	24.0875	24.0975	24.0375	24.05	440472.0
2014-08-13 09:00:00	AAPL	Stock	24.0575	24.1275	24.01	24.0775	17218128.0
2014-08-13 10:00:00	AAPL	Stock	24.0765	24.1725	24.075	24.16	19024660.0
2014-08-13 11:00:00	AAPL	Stock	24.16	24.2375	24.1598	24.1975	17458640.0
2014-08-13 12:00:00	AAPL	Stock	24.1962	24.2125	24.165	24.205	8416992.0
2014-08-13 13:00:00	AAPL	Stock	24.205	24.27	24.19	24.2675	11006004.0
2014-08-13 14:00:00	AAPL	Stock	24.27	24.2775	24.215	24.2665	12935372.0
2014-08-13 15:00:00	AAPL	Stock	24.2653	24.3075	24.24	24.3075	24762360.0
2014-08-13 16:00:00	AAPL	Stock	24.31	24.325	24.1865	24.3175	5672100.0
2014-08-13 17:00:00	AAPL	Stock	24.31	24.325	24.0278	24.32	283992.0
2014-08-13 18:00:00	AAPL	Stock	24.315	24.3275	24.3125	24.3275	41796.0
2014-08-13 19:00:00	AAPL	Stock	24.32	24.33	24.3125	24.32	77624.0
2014-08-13 08:00:00	MSFT	Stock	43.65	43.74	43.65	43.74	525.0
2014-08-13 09:00:00	MSFT	Stock	43.66	43.85	43.52	43.58	3035185.0
2014-08-13 10:00:00	MSFT	Stock	43.58	43.85	43.56	43.83	4148423.0
2014-08-13 11:00:00	MSFT	Stock	43.83	44.0	43.83	43.89	2404672.0
2014-08-13 12:00:00	MSFT	Stock	43.89	44.18	43.86	44.07	2995030.0
2014-08-13 13:00:00	MSFT	Stock	44.06	44.12	43.95	43.955	2286146.0
2014-08-13 14:00:00	MSFT	Stock	43.955	44.08	43.94	44.04	1690735.0
2014-08-13 15:00:00	MSFT	Stock	44.043	44.1	43.98	44.08	4024837.0
2014-08-13 16:00:00	MSFT	Stock	44.08	44.15	43.911	44.04	1189682.0
2014-08-13 17:00:00	MSFT	Stock	44.08	44.1	43.628	44.05	79980.0
2014-08-13 18:00:00	MSFT	Stock	44.08	44.08	44.0	44.0	11483.0
2014-08-13 19:00:00	MSFT	Stock	44.0	44.11	44.0	44.11	1258.0
2014-08-13 08:00:00	NVDA	Stock	0.475	0.4788	0.475	0.475	260000.0
2014-08-13 09:00:00	NVDA	Stock	0.4732	0.4748	0.4702	0.4708	19510960.0
2014-08-13 10:00:00	NVDA	Stock	0.4708	0.4763	0.4708	0.4755	35286360.0
2014-08-13 11:00:00	NVDA	Stock	0.4758	0.4793	0.4754	0.4775	29609440.0
2014-08-13 12:00:00	NVDA	Stock	0.4774	0.4775	0.4742	0.4745	22885840.0
2014-08-13 13:00:00	NVDA	Stock	0.4745	0.4758	0.4738	0.4751	14316360.0
2014-08-13 14:00:00	NVDA	Stock	0.4753	0.476	0.4742	0.4742	17993240.0
2014-08-13 15:00:00	NVDA	Stock	0.4742	0.4758	0.4742	0.475	49464880.0
2014-08-13 16:00:00	NVDA	Stock	0.4753	0.4754	0.4748	0.4754	60109360.0
2014-08-13 17:00:00	NVDA	Stock	0.4753	0.4753	0.4753	0.4753	166480.0
2014-08-13 04:00:00	AMZN	Stock	16.0195	16.0195	16.0195	16.0195	3000.0
2014-08-13 06:00:00	AMZN	Stock	16.07	16.3	16.07	16.2735	198640.0
2014-08-13 07:00:00	AMZN	Stock	16.252	16.34	16.22	16.3	442500.0
2014-08-13 08:00:00	AMZN	Stock	16.3	16.415	16.2055	16.328	1165940.0
2014-08-13 09:00:00	AMZN	Stock	16.3265	16.525	16.2975	16.413	29693080.0
2014-08-13 10:00:00	AMZN	Stock	16.42	16.586	16.401	16.536	18150580.0
2014-08-13 11:00:00	AMZN	Stock	16.5355	16.57	16.464	16.503	10560000.0
2014-08-13 12:00:00	AMZN	Stock	16.4953	16.509	16.388	16.3969	7477980.0
2014-08-13 13:00:00	AMZN	Stock	16.3965	16.453	16.3565	16.4448	4649700.0
2014-08-13 14:00:00	AMZN	Stock	16.449	16.4565	16.358	16.405	4121420.0
2014-08-13 15:00:00	AMZN	Stock	16.4	16.464	16.307	16.314	16374480.0
2014-08-13 16:00:00	AMZN	Stock	16.314	16.5126	16.314	16.325	260060.0

> showing 50 of 48,483 rows — these rows as CSV

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