PREVIEW / stock_1hour / 2015-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-03.parquet
  size:    1.0 MB
  rows:    48,645
  symbols: 3,419

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-11-03 04:00:00	AAPL	Stock	30.25	30.25	30.17	30.235	6336.0
2015-11-03 05:00:00	AAPL	Stock	30.225	30.225	30.2125	30.215	17032.0
2015-11-03 06:00:00	AAPL	Stock	30.205	30.21	30.15	30.1625	39048.0
2015-11-03 07:00:00	AAPL	Stock	30.175	30.185	30.0825	30.1675	159168.0
2015-11-03 08:00:00	AAPL	Stock	30.175	30.2	30.1225	30.16	614308.0
2015-11-03 09:00:00	AAPL	Stock	30.16	30.4625	30.16	30.39	23519844.0
2015-11-03 10:00:00	AAPL	Stock	30.3888	30.7025	30.3875	30.6325	35622516.0
2015-11-03 11:00:00	AAPL	Stock	30.6342	30.6575	30.55	30.62	20430440.0
2015-11-03 12:00:00	AAPL	Stock	30.6175	30.6688	30.596	30.6375	10922100.0
2015-11-03 13:00:00	AAPL	Stock	30.6388	30.795	30.63	30.792	16290728.0
2015-11-03 14:00:00	AAPL	Stock	30.792	30.8725	30.775	30.835	21286052.0
2015-11-03 15:00:00	AAPL	Stock	30.8325	30.8475	30.605	30.6475	29918516.0
2015-11-03 16:00:00	AAPL	Stock	30.6425	30.65	30.585	30.6075	11064612.0
2015-11-03 17:00:00	AAPL	Stock	30.62	30.625	30.61	30.625	52360.0
2015-11-03 18:00:00	AAPL	Stock	30.625	30.6375	30.605	30.62	43116.0
2015-11-03 19:00:00	AAPL	Stock	30.615	30.63	30.6025	30.63	79204.0
2015-11-03 04:00:00	MSFT	Stock	52.96	52.96	52.95	52.95	1000.0
2015-11-03 07:00:00	MSFT	Stock	53.16	53.2	53.16	53.16	2400.0
2015-11-03 08:00:00	MSFT	Stock	53.13	53.13	53.07	53.1	6800.0
2015-11-03 09:00:00	MSFT	Stock	53.16	53.34	52.9	53.15	3409225.0
2015-11-03 10:00:00	MSFT	Stock	53.145	53.63	53.112	53.57	5459038.0
2015-11-03 11:00:00	MSFT	Stock	53.57	53.93	53.5	53.9	3612953.0
2015-11-03 12:00:00	MSFT	Stock	53.89	54.04	53.88	54.0	3535971.0
2015-11-03 13:00:00	MSFT	Stock	54.0	54.24	53.98	54.165	4404681.0
2015-11-03 14:00:00	MSFT	Stock	54.165	54.33	53.921	54.26	5776267.0
2015-11-03 15:00:00	MSFT	Stock	54.25	54.39	53.94	54.16	6223632.0
2015-11-03 16:00:00	MSFT	Stock	54.15	54.18	53.916	54.07	1822962.0
2015-11-03 17:00:00	MSFT	Stock	54.1	54.1	54.1	54.1	2800.0
2015-11-03 18:00:00	MSFT	Stock	54.08	54.1	54.07	54.1	8404.0
2015-11-03 19:00:00	MSFT	Stock	54.07	54.1	54.07	54.1	3713.0
2015-11-03 08:00:00	NVDA	Stock	0.7135	0.7135	0.704	0.7125	22000.0
2015-11-03 09:00:00	NVDA	Stock	0.705	0.7173	0.705	0.7071	45347600.0
2015-11-03 10:00:00	NVDA	Stock	0.7068	0.713	0.7045	0.7075	62900920.0
2015-11-03 11:00:00	NVDA	Stock	0.7075	0.7113	0.7075	0.7078	33388760.0
2015-11-03 12:00:00	NVDA	Stock	0.7076	0.7083	0.7056	0.7083	33352480.0
2015-11-03 13:00:00	NVDA	Stock	0.7081	0.7125	0.7075	0.7111	33424960.0
2015-11-03 14:00:00	NVDA	Stock	0.7113	0.716	0.711	0.7135	36379960.0
2015-11-03 15:00:00	NVDA	Stock	0.7135	0.7158	0.712	0.7123	71401320.0
2015-11-03 16:00:00	NVDA	Stock	0.7125	0.715	0.7108	0.7108	25817520.0
2015-11-03 17:00:00	NVDA	Stock	0.7173	0.7173	0.7165	0.7165	20000.0
2015-11-03 07:00:00	AMZN	Stock	31.375	31.375	31.3515	31.375	64260.0
2015-11-03 08:00:00	AMZN	Stock	31.345	31.4245	31.3335	31.397	171200.0
2015-11-03 09:00:00	AMZN	Stock	31.4	31.4945	31.1858	31.242	10731760.0
2015-11-03 10:00:00	AMZN	Stock	31.2605	31.3225	31.1	31.168	12703320.0
2015-11-03 11:00:00	AMZN	Stock	31.1505	31.258	31.1226	31.256	8323920.0
2015-11-03 12:00:00	AMZN	Stock	31.249	31.3055	31.2435	31.2918	5496340.0
2015-11-03 13:00:00	AMZN	Stock	31.2875	31.307	31.2495	31.2723	5933480.0
2015-11-03 14:00:00	AMZN	Stock	31.268	31.3665	31.2602	31.3375	7001960.0
2015-11-03 15:00:00	AMZN	Stock	31.3365	31.344	31.1791	31.266	10360040.0
2015-11-03 16:00:00	AMZN	Stock	31.2655	31.2974	31.2125	31.25	1220060.0

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

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