PREVIEW / stock_1hour / 2016-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-27.parquet
  size:    1.0 MB
  rows:    48,292
  symbols: 3,359

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
2016-01-27 04:00:00	AAPL	Stock	24.2625	24.325	24.2625	24.325	31796.0
2016-01-27 05:00:00	AAPL	Stock	24.3025	24.325	23.9425	24.125	203496.0
2016-01-27 06:00:00	AAPL	Stock	24.1525	24.195	23.4198	23.9725	860028.0
2016-01-27 07:00:00	AAPL	Stock	23.9675	24.1025	23.905	24.1025	2444436.0
2016-01-27 08:00:00	AAPL	Stock	24.0875	24.295	23.925	24.1475	6303100.0
2016-01-27 09:00:00	AAPL	Stock	24.155	24.25	23.665	23.832	99617496.0
2016-01-27 10:00:00	AAPL	Stock	23.83	23.8875	23.555	23.5695	82363016.0
2016-01-27 11:00:00	AAPL	Stock	23.5675	23.855	23.51	23.8525	70769068.0
2016-01-27 12:00:00	AAPL	Stock	23.8525	24.0475	23.78	23.8275	68049356.0
2016-01-27 13:00:00	AAPL	Stock	23.8275	23.935	23.755	23.817	38171712.0
2016-01-27 14:00:00	AAPL	Stock	23.8175	23.8875	23.4725	23.5298	58980160.0
2016-01-27 15:00:00	AAPL	Stock	23.52	23.545	23.335	23.3575	60630856.0
2016-01-27 16:00:00	AAPL	Stock	23.355	23.809	23.34	23.3875	9531820.0
2016-01-27 17:00:00	AAPL	Stock	23.395	23.6785	23.365	23.4075	1190512.0
2016-01-27 18:00:00	AAPL	Stock	23.3975	23.475	23.3975	23.4425	428808.0
2016-01-27 19:00:00	AAPL	Stock	23.4575	23.485	23.405	23.4775	202548.0
2016-01-27 04:00:00	MSFT	Stock	51.79	51.79	51.79	51.79	3897.0
2016-01-27 07:00:00	MSFT	Stock	51.78	51.88	51.77	51.88	1630.0
2016-01-27 08:00:00	MSFT	Stock	51.8	52.07	51.8	52.03	9766.0
2016-01-27 09:00:00	MSFT	Stock	52.05	52.17	51.96	52.01	2838525.0
2016-01-27 10:00:00	MSFT	Stock	52.0	52.01	51.25	51.676	4749844.0
2016-01-27 11:00:00	MSFT	Stock	51.67	52.17	51.55	52.035	3074119.0
2016-01-27 12:00:00	MSFT	Stock	52.04	52.185	52.0	52.05	2411080.0
2016-01-27 13:00:00	MSFT	Stock	52.05	52.12	51.9	52.07	2356924.0
2016-01-27 14:00:00	MSFT	Stock	52.08	52.2	51.28	51.395	5929639.0
2016-01-27 15:00:00	MSFT	Stock	51.393	51.396	51.02	51.21	9798377.0
2016-01-27 16:00:00	MSFT	Stock	51.22	51.56	51.2	51.4	2853891.0
2016-01-27 17:00:00	MSFT	Stock	51.4	52.0	51.36	51.85	52014.0
2016-01-27 18:00:00	MSFT	Stock	51.91	51.91	51.61	51.61	20146.0
2016-01-27 19:00:00	MSFT	Stock	51.65	51.78	51.41	51.59	15535.0
2016-01-27 09:00:00	NVDA	Stock	0.7165	0.7175	0.7078	0.7085	12161280.0
2016-01-27 10:00:00	NVDA	Stock	0.7086	0.7086	0.6954	0.7066	47905920.0
2016-01-27 11:00:00	NVDA	Stock	0.7068	0.7149	0.706	0.7138	22168080.0
2016-01-27 12:00:00	NVDA	Stock	0.714	0.7186	0.7135	0.7147	16965960.0
2016-01-27 13:00:00	NVDA	Stock	0.7148	0.7165	0.71	0.7131	14063400.0
2016-01-27 14:00:00	NVDA	Stock	0.7128	0.7158	0.707	0.71	27890080.0
2016-01-27 15:00:00	NVDA	Stock	0.7098	0.7098	0.7032	0.709	57675720.0
2016-01-27 16:00:00	NVDA	Stock	0.709	0.7098	0.7089	0.7098	21738160.0
2016-01-27 18:00:00	NVDA	Stock	0.7062	0.7062	0.7062	0.7062	26000.0
2016-01-27 04:00:00	AMZN	Stock	29.905	29.905	29.875	29.875	6000.0
2016-01-27 05:00:00	AMZN	Stock	29.8985	29.8985	29.8985	29.8985	2000.0
2016-01-27 06:00:00	AMZN	Stock	29.8995	29.8995	29.8995	29.8995	4800.0
2016-01-27 07:00:00	AMZN	Stock	29.85	29.994	29.85	29.97	40640.0
2016-01-27 08:00:00	AMZN	Stock	29.9665	30.06	29.9	30.0	188200.0
2016-01-27 09:00:00	AMZN	Stock	29.995	30.1695	29.385	29.6	16663320.0
2016-01-27 10:00:00	AMZN	Stock	29.5765	29.615	29.2085	29.406	13891740.0
2016-01-27 11:00:00	AMZN	Stock	29.418	29.761	29.361	29.6725	10760640.0
2016-01-27 12:00:00	AMZN	Stock	29.673	29.8394	29.6435	29.653	7097020.0
2016-01-27 13:00:00	AMZN	Stock	29.651	29.712	29.46	29.7	7446220.0
2016-01-27 14:00:00	AMZN	Stock	29.7	29.797	29.206	29.267	14618100.0

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

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