PREVIEW / stock_1hour / 2014-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-31.parquet
  size:    1.1 MB
  rows:    49,602
  symbols: 3,587

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-07-31 04:00:00	AAPL	Stock	24.4875	24.4875	24.225	24.25	48332.0
2014-07-31 05:00:00	AAPL	Stock	24.225	24.25	24.175	24.2275	57560.0
2014-07-31 06:00:00	AAPL	Stock	24.25	24.2675	24.2125	24.2175	89788.0
2014-07-31 07:00:00	AAPL	Stock	24.2225	24.3225	24.1875	24.2875	290236.0
2014-07-31 08:00:00	AAPL	Stock	24.3	24.55	24.215	24.305	872664.0
2014-07-31 09:00:00	AAPL	Stock	24.3025	24.3625	24.1375	24.1425	31323200.0
2014-07-31 10:00:00	AAPL	Stock	24.14	24.215	23.95	23.9925	39869744.0
2014-07-31 11:00:00	AAPL	Stock	23.9925	24.05	23.84	23.8612	31771316.0
2014-07-31 12:00:00	AAPL	Stock	23.8625	24.0075	23.8325	23.9738	24410720.0
2014-07-31 13:00:00	AAPL	Stock	23.975	24.0688	23.9225	24.0625	14974380.0
2014-07-31 14:00:00	AAPL	Stock	24.065	24.1	23.9625	23.965	16760184.0
2014-07-31 15:00:00	AAPL	Stock	23.9668	24.0275	23.865	23.895	35440364.0
2014-07-31 16:00:00	AAPL	Stock	23.8925	24.0502	23.875	23.8925	12458232.0
2014-07-31 17:00:00	AAPL	Stock	23.8925	23.9842	23.8125	23.86	713032.0
2014-07-31 18:00:00	AAPL	Stock	23.865	23.9	23.85	23.85	372204.0
2014-07-31 19:00:00	AAPL	Stock	23.87	23.885	23.85	23.86	209392.0
2014-07-31 05:00:00	MSFT	Stock	43.2	43.2	43.2	43.2	100.0
2014-07-31 07:00:00	MSFT	Stock	43.12	43.21	43.12	43.21	9800.0
2014-07-31 08:00:00	MSFT	Stock	43.21	43.28	43.09	43.15	5526.0
2014-07-31 09:00:00	MSFT	Stock	43.27	43.61	43.25	43.33	2810787.0
2014-07-31 10:00:00	MSFT	Stock	43.32	43.43	43.08	43.17	3642675.0
2014-07-31 11:00:00	MSFT	Stock	43.17	43.42	43.16	43.38	5026051.0
2014-07-31 12:00:00	MSFT	Stock	43.39	43.42	43.21	43.415	1769315.0
2014-07-31 13:00:00	MSFT	Stock	43.42	43.58	43.38	43.54	2331061.0
2014-07-31 14:00:00	MSFT	Stock	43.535	43.69	43.37	43.38	3698343.0
2014-07-31 15:00:00	MSFT	Stock	43.38	43.46	43.17	43.17	6711623.0
2014-07-31 16:00:00	MSFT	Stock	43.2	43.36	43.15	43.16	4039355.0
2014-07-31 17:00:00	MSFT	Stock	43.16	43.411	43.151	43.16	43740.0
2014-07-31 18:00:00	MSFT	Stock	43.16	43.17	43.16	43.16	1525.0
2014-07-31 19:00:00	MSFT	Stock	43.16	43.16	43.16	43.16	1047.0
2014-07-31 04:00:00	NVDA	Stock	0.455	0.455	0.455	0.455	40000.0
2014-07-31 07:00:00	NVDA	Stock	0.45	0.45	0.45	0.45	30200.0
2014-07-31 08:00:00	NVDA	Stock	0.4502	0.4502	0.45	0.45	121800.0
2014-07-31 09:00:00	NVDA	Stock	0.448	0.45	0.445	0.4452	27033880.0
2014-07-31 10:00:00	NVDA	Stock	0.4452	0.4455	0.4385	0.4392	50517440.0
2014-07-31 11:00:00	NVDA	Stock	0.4392	0.4409	0.4376	0.4378	83485600.0
2014-07-31 12:00:00	NVDA	Stock	0.4378	0.4398	0.4375	0.4389	42646320.0
2014-07-31 13:00:00	NVDA	Stock	0.439	0.4398	0.4375	0.439	27723320.0
2014-07-31 14:00:00	NVDA	Stock	0.439	0.4408	0.438	0.4392	43248080.0
2014-07-31 15:00:00	NVDA	Stock	0.4394	0.44	0.4366	0.4375	93433880.0
2014-07-31 16:00:00	NVDA	Stock	0.4375	0.4382	0.4372	0.4375	20506360.0
2014-07-31 17:00:00	NVDA	Stock	0.4375	0.4382	0.4374	0.4382	581840.0
2014-07-31 04:00:00	AMZN	Stock	16.017	16.017	16.007	16.007	6200.0
2014-07-31 06:00:00	AMZN	Stock	15.981	15.981	15.981	15.981	2000.0
2014-07-31 07:00:00	AMZN	Stock	15.9825	16.002	15.9825	16.002	14080.0
2014-07-31 08:00:00	AMZN	Stock	15.9945	16.0485	15.9425	15.951	222000.0
2014-07-31 09:00:00	AMZN	Stock	15.9545	16.0342	15.905	15.921	11679760.0
2014-07-31 10:00:00	AMZN	Stock	15.9215	15.9225	15.7505	15.7505	16815380.0
2014-07-31 11:00:00	AMZN	Stock	15.7525	15.783	15.653	15.673	14116020.0
2014-07-31 12:00:00	AMZN	Stock	15.6735	15.738	15.6465	15.7135	8899520.0

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

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