PREVIEW / stock_1hour / 2014-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-20.parquet
  size:    1.0 MB
  rows:    49,737
  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-10-20 04:00:00	AAPL	Stock	24.6875	24.7675	24.5325	24.5875	47824.0
2014-10-20 05:00:00	AAPL	Stock	24.55	24.58	24.525	24.575	27940.0
2014-10-20 06:00:00	AAPL	Stock	24.58	24.6625	24.58	24.5875	149664.0
2014-10-20 07:00:00	AAPL	Stock	24.5775	24.7175	24.515	24.575	730132.0
2014-10-20 08:00:00	AAPL	Stock	24.6055	24.7075	24.5025	24.6	1292412.0
2014-10-20 09:00:00	AAPL	Stock	24.605	24.82	24.515	24.7322	37693504.0
2014-10-20 10:00:00	AAPL	Stock	24.735	24.895	24.73	24.8725	39808548.0
2014-10-20 11:00:00	AAPL	Stock	24.8725	24.92	24.79	24.83	29105848.0
2014-10-20 12:00:00	AAPL	Stock	24.8315	24.875	24.765	24.8088	20090776.0
2014-10-20 13:00:00	AAPL	Stock	24.8075	24.86	24.765	24.8288	20996272.0
2014-10-20 14:00:00	AAPL	Stock	24.8312	24.905	24.81	24.8862	28005168.0
2014-10-20 15:00:00	AAPL	Stock	24.885	24.99	24.8725	24.9425	56557304.0
2014-10-20 16:00:00	AAPL	Stock	24.94	25.435	24.5975	25.2125	39021588.0
2014-10-20 17:00:00	AAPL	Stock	25.2175	25.4175	21.7038	25.3125	11654440.0
2014-10-20 18:00:00	AAPL	Stock	25.3125	25.3475	24.94	25.3	1877352.0
2014-10-20 19:00:00	AAPL	Stock	25.2925	25.325	25.28	25.3175	956716.0
2014-10-20 04:00:00	MSFT	Stock	43.7	43.7	43.7	43.7	300.0
2014-10-20 06:00:00	MSFT	Stock	43.68	43.76	43.68	43.76	800.0
2014-10-20 07:00:00	MSFT	Stock	43.51	43.51	43.1	43.1	5100.0
2014-10-20 08:00:00	MSFT	Stock	43.3	43.4	43.2	43.25	13875.0
2014-10-20 09:00:00	MSFT	Stock	43.3	43.3	42.81	43.18	5988702.0
2014-10-20 10:00:00	MSFT	Stock	43.18	43.68	43.12	43.63	4927575.0
2014-10-20 11:00:00	MSFT	Stock	43.62	43.79	43.51	43.79	2863651.0
2014-10-20 12:00:00	MSFT	Stock	43.786	43.91	43.75	43.76	2973871.0
2014-10-20 13:00:00	MSFT	Stock	43.76	43.95	43.67	43.86	2657618.0
2014-10-20 14:00:00	MSFT	Stock	43.86	44.04	43.85	44.04	2675797.0
2014-10-20 15:00:00	MSFT	Stock	44.04	44.14	43.99	44.09	6541468.0
2014-10-20 16:00:00	MSFT	Stock	44.08	44.2	43.307	44.003	3941922.0
2014-10-20 17:00:00	MSFT	Stock	44.08	44.31	44.08	44.31	64729.0
2014-10-20 18:00:00	MSFT	Stock	44.19	44.19	44.19	44.19	600.0
2014-10-20 19:00:00	MSFT	Stock	44.29	44.29	44.14	44.14	1722.0
2014-10-20 09:00:00	NVDA	Stock	0.4355	0.442	0.4325	0.4391	27188520.0
2014-10-20 10:00:00	NVDA	Stock	0.4392	0.4412	0.4378	0.4402	28513680.0
2014-10-20 11:00:00	NVDA	Stock	0.4402	0.4431	0.4392	0.441	19188960.0
2014-10-20 12:00:00	NVDA	Stock	0.441	0.4422	0.4388	0.4395	21154880.0
2014-10-20 13:00:00	NVDA	Stock	0.4396	0.4402	0.4381	0.4385	23201360.0
2014-10-20 14:00:00	NVDA	Stock	0.4382	0.4402	0.4382	0.4395	15970200.0
2014-10-20 15:00:00	NVDA	Stock	0.4398	0.4408	0.4384	0.4392	43254480.0
2014-10-20 16:00:00	NVDA	Stock	0.4392	0.4392	0.439	0.439	11632200.0
2014-10-20 17:00:00	NVDA	Stock	0.4392	0.4402	0.4392	0.4402	852880.0
2014-10-20 07:00:00	AMZN	Stock	15.15	15.15	15.15	15.15	11000.0
2014-10-20 08:00:00	AMZN	Stock	15.1355	15.145	15.0975	15.126	166740.0
2014-10-20 09:00:00	AMZN	Stock	15.124	15.222	15.1055	15.2005	9629960.0
2014-10-20 10:00:00	AMZN	Stock	15.211	15.2805	15.155	15.1615	10136560.0
2014-10-20 11:00:00	AMZN	Stock	15.1745	15.242	15.136	15.2155	7256900.0
2014-10-20 12:00:00	AMZN	Stock	15.215	15.242	15.1335	15.138	6256440.0
2014-10-20 13:00:00	AMZN	Stock	15.1385	15.165	15.101	15.1445	9399020.0
2014-10-20 14:00:00	AMZN	Stock	15.145	15.2345	15.1425	15.2225	5461380.0
2014-10-20 15:00:00	AMZN	Stock	15.224	15.3265	15.218	15.3025	8023320.0
2014-10-20 16:00:00	AMZN	Stock	15.3105	15.3136	15.199	15.3105	3037340.0

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

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