PREVIEW / stock_1hour / 2015-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-26.parquet
  size:    1.0 MB
  rows:    49,614
  symbols: 3,532

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
2015-01-26 04:00:00	AAPL	Stock	28.1375	28.395	28.1375	28.395	158764.0
2015-01-26 05:00:00	AAPL	Stock	28.3575	28.3975	28.3275	28.3375	19152.0
2015-01-26 06:00:00	AAPL	Stock	28.3525	28.4625	28.3175	28.325	116412.0
2015-01-26 07:00:00	AAPL	Stock	28.325	28.485	28.325	28.485	364552.0
2015-01-26 08:00:00	AAPL	Stock	28.485	28.5025	28.245	28.4825	1844896.0
2015-01-26 09:00:00	AAPL	Stock	28.4825	28.4875	28.2825	28.4195	31992536.0
2015-01-26 10:00:00	AAPL	Stock	28.4225	28.5625	28.315	28.555	31253672.0
2015-01-26 11:00:00	AAPL	Stock	28.555	28.5908	28.3775	28.3968	25419268.0
2015-01-26 12:00:00	AAPL	Stock	28.3975	28.4375	28.346	28.3825	17738728.0
2015-01-26 13:00:00	AAPL	Stock	28.3825	28.4475	28.3275	28.4148	14882600.0
2015-01-26 14:00:00	AAPL	Stock	28.4172	28.4525	28.225	28.286	23732952.0
2015-01-26 15:00:00	AAPL	Stock	28.2875	28.345	28.2	28.2725	30988172.0
2015-01-26 16:00:00	AAPL	Stock	28.275	28.4665	28.225	28.3225	21924208.0
2015-01-26 17:00:00	AAPL	Stock	28.315	28.35	28.275	28.35	308788.0
2015-01-26 18:00:00	AAPL	Stock	28.35	28.3625	28.3275	28.36	171136.0
2015-01-26 19:00:00	AAPL	Stock	28.355	28.3725	28.3375	28.37	218968.0
2015-01-26 04:00:00	MSFT	Stock	47.24	47.24	47.24	47.24	2100.0
2015-01-26 05:00:00	MSFT	Stock	47.27	47.36	47.24	47.24	720.0
2015-01-26 06:00:00	MSFT	Stock	47.35	47.46	47.27	47.27	9153.0
2015-01-26 07:00:00	MSFT	Stock	47.24	47.44	47.24	47.33	24327.0
2015-01-26 08:00:00	MSFT	Stock	47.4	47.48	47.31	47.43	52578.0
2015-01-26 09:00:00	MSFT	Stock	47.45	47.45	46.63	46.737	4301535.0
2015-01-26 10:00:00	MSFT	Stock	46.737	46.81	46.47	46.62	5278397.0
2015-01-26 11:00:00	MSFT	Stock	46.626	46.626	46.24	46.37	4562801.0
2015-01-26 12:00:00	MSFT	Stock	46.37	46.62	46.36	46.53	2526916.0
2015-01-26 13:00:00	MSFT	Stock	46.53	46.81	46.48	46.76	2608273.0
2015-01-26 14:00:00	MSFT	Stock	46.77	46.78	46.61	46.64	2677677.0
2015-01-26 15:00:00	MSFT	Stock	46.64	47.08	46.62	47.05	8772068.0
2015-01-26 16:00:00	MSFT	Stock	47.01	47.35	45.45	45.61	7686770.0
2015-01-26 17:00:00	MSFT	Stock	45.64	45.88	44.9	45.15	825929.0
2015-01-26 18:00:00	MSFT	Stock	45.1	45.34	44.9	45.01	731930.0
2015-01-26 19:00:00	MSFT	Stock	45.03	45.05	44.9	45.0	257407.0
2015-01-26 09:00:00	NVDA	Stock	0.5178	0.5178	0.5122	0.517	21700760.0
2015-01-26 10:00:00	NVDA	Stock	0.5173	0.518	0.5138	0.516	14398640.0
2015-01-26 11:00:00	NVDA	Stock	0.5158	0.5173	0.5135	0.514	13452120.0
2015-01-26 12:00:00	NVDA	Stock	0.514	0.5173	0.5138	0.517	10267800.0
2015-01-26 13:00:00	NVDA	Stock	0.5173	0.5174	0.516	0.516	11719560.0
2015-01-26 14:00:00	NVDA	Stock	0.516	0.5162	0.5135	0.5135	17302000.0
2015-01-26 15:00:00	NVDA	Stock	0.5135	0.5155	0.513	0.5152	33513480.0
2015-01-26 16:00:00	NVDA	Stock	0.5154	0.5154	0.515	0.5154	7482360.0
2015-01-26 19:00:00	NVDA	Stock	0.515	0.515	0.515	0.515	16000.0
2015-01-26 04:00:00	AMZN	Stock	15.517	15.517	15.517	15.517	2000.0
2015-01-26 07:00:00	AMZN	Stock	15.5765	15.684	15.5765	15.684	19940.0
2015-01-26 08:00:00	AMZN	Stock	15.59	15.65	15.59	15.645	97900.0
2015-01-26 09:00:00	AMZN	Stock	15.644	15.6725	15.455	15.513	12101220.0
2015-01-26 10:00:00	AMZN	Stock	15.5168	15.576	15.48	15.5303	9435020.0
2015-01-26 11:00:00	AMZN	Stock	15.533	15.533	15.376	15.422	10486220.0
2015-01-26 12:00:00	AMZN	Stock	15.418	15.5	15.4105	15.439	5663060.0
2015-01-26 13:00:00	AMZN	Stock	15.441	15.5324	15.429	15.5015	3389780.0
2015-01-26 14:00:00	AMZN	Stock	15.507	15.5195	15.4385	15.463	5339000.0

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

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