PREVIEW / stock_1hour / 2014-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-15.parquet
  size:    1.1 MB
  rows:    49,655
  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
2014-12-15 04:00:00	AAPL	Stock	27.5	27.6875	27.5	27.6375	47092.0
2014-12-15 05:00:00	AAPL	Stock	27.655	27.7	27.65	27.675	6000.0
2014-12-15 06:00:00	AAPL	Stock	27.675	27.745	27.635	27.6625	31848.0
2014-12-15 07:00:00	AAPL	Stock	27.6525	27.6825	27.625	27.6425	224668.0
2014-12-15 08:00:00	AAPL	Stock	27.6275	27.695	27.6	27.615	929128.0
2014-12-15 09:00:00	AAPL	Stock	27.605	27.9	27.4325	27.6822	30556524.0
2014-12-15 10:00:00	AAPL	Stock	27.6775	27.69	27.4375	27.5725	31358868.0
2014-12-15 11:00:00	AAPL	Stock	27.565	27.575	26.5875	26.8925	63228736.0
2014-12-15 12:00:00	AAPL	Stock	26.8938	27.43	26.8875	27.3638	33793748.0
2014-12-15 13:00:00	AAPL	Stock	27.3625	27.4625	27.1075	27.1875	21270656.0
2014-12-15 14:00:00	AAPL	Stock	27.185	27.3925	27.125	27.2	21228056.0
2014-12-15 15:00:00	AAPL	Stock	27.2	27.275	26.9375	27.0575	33553752.0
2014-12-15 16:00:00	AAPL	Stock	27.0562	27.6222	26.995	27.025	14439320.0
2014-12-15 17:00:00	AAPL	Stock	27.0125	27.4225	27.0125	27.025	183260.0
2014-12-15 18:00:00	AAPL	Stock	27.0375	27.095	27.035	27.0875	188608.0
2014-12-15 19:00:00	AAPL	Stock	27.0875	27.135	27.0525	27.0525	202452.0
2014-12-15 04:00:00	MSFT	Stock	46.95	47.16	46.95	47.16	300.0
2014-12-15 07:00:00	MSFT	Stock	47.2	47.2	47.2	47.2	100.0
2014-12-15 08:00:00	MSFT	Stock	47.18	47.38	47.09	47.09	12995.0
2014-12-15 09:00:00	MSFT	Stock	47.26	47.67	47.11	47.5	3619177.0
2014-12-15 10:00:00	MSFT	Stock	47.49	47.52	47.01	47.196	3325479.0
2014-12-15 11:00:00	MSFT	Stock	47.2	47.2	46.82	46.831	4204894.0
2014-12-15 12:00:00	MSFT	Stock	46.835	47.08	46.82	47.02	2643468.0
2014-12-15 13:00:00	MSFT	Stock	47.02	47.085	46.68	46.77	2121121.0
2014-12-15 14:00:00	MSFT	Stock	46.76	46.95	46.63	46.73	2312398.0
2014-12-15 15:00:00	MSFT	Stock	46.735	46.86	46.55	46.66	4509295.0
2014-12-15 16:00:00	MSFT	Stock	46.67	47.252	46.65	47.252	5300716.0
2014-12-15 17:00:00	MSFT	Stock	46.769	46.961	46.62	46.67	13607.0
2014-12-15 18:00:00	MSFT	Stock	46.67	46.67	46.67	46.67	20658.0
2014-12-15 19:00:00	MSFT	Stock	46.75	46.77	46.75	46.77	300.0
2014-12-15 08:00:00	NVDA	Stock	0.5047	0.5047	0.5047	0.5047	19840.0
2014-12-15 09:00:00	NVDA	Stock	0.4965	0.5055	0.495	0.4952	39688720.0
2014-12-15 10:00:00	NVDA	Stock	0.4952	0.4978	0.4914	0.4942	39981040.0
2014-12-15 11:00:00	NVDA	Stock	0.4942	0.4944	0.4901	0.4902	37525080.0
2014-12-15 12:00:00	NVDA	Stock	0.4905	0.4942	0.4902	0.494	18639760.0
2014-12-15 13:00:00	NVDA	Stock	0.4938	0.4942	0.4892	0.4899	21306680.0
2014-12-15 14:00:00	NVDA	Stock	0.4898	0.4924	0.4878	0.4905	21331600.0
2014-12-15 15:00:00	NVDA	Stock	0.4905	0.4932	0.489	0.489	59233560.0
2014-12-15 16:00:00	NVDA	Stock	0.4892	0.4966	0.4892	0.4966	13094200.0
2014-12-15 17:00:00	NVDA	Stock	0.4928	0.4928	0.4928	0.4928	1317160.0
2014-12-15 08:00:00	AMZN	Stock	15.454	15.454	15.373	15.373	181740.0
2014-12-15 09:00:00	AMZN	Stock	15.376	15.543	15.371	15.4345	7246380.0
2014-12-15 10:00:00	AMZN	Stock	15.4255	15.4305	15.1075	15.239	18253720.0
2014-12-15 11:00:00	AMZN	Stock	15.2326	15.246	15.129	15.141	7418020.0
2014-12-15 12:00:00	AMZN	Stock	15.1405	15.482	15.14	15.4765	9973760.0
2014-12-15 13:00:00	AMZN	Stock	15.4745	15.494	15.3585	15.4	7228900.0
2014-12-15 14:00:00	AMZN	Stock	15.4035	15.4295	15.3125	15.343	5053660.0
2014-12-15 15:00:00	AMZN	Stock	15.3325	15.3925	15.287	15.3035	8675140.0
2014-12-15 16:00:00	AMZN	Stock	15.307	15.389	15.1847	15.2996	235060.0
2014-12-15 17:00:00	AMZN	Stock	15.3035	15.3035	15.275	15.275	8000.0

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

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