PREVIEW / stock_1hour / 2017-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-19.parquet
  size:    1.0 MB
  rows:    47,882
  symbols: 3,060

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
2017-04-19 04:00:00	AAPL	Stock	35.35	35.38	35.35	35.38	3304.0
2017-04-19 05:00:00	AAPL	Stock	35.35	35.35	35.35	35.35	560.0
2017-04-19 06:00:00	AAPL	Stock	35.4	35.4	35.375	35.4	1860.0
2017-04-19 07:00:00	AAPL	Stock	35.3875	35.405	35.3875	35.4	16360.0
2017-04-19 08:00:00	AAPL	Stock	35.395	35.4875	35.395	35.4725	170184.0
2017-04-19 09:00:00	AAPL	Stock	35.4725	35.5	35.38	35.45	9445664.0
2017-04-19 10:00:00	AAPL	Stock	35.45	35.475	35.38	35.4125	7411692.0
2017-04-19 11:00:00	AAPL	Stock	35.4125	35.4825	35.4088	35.45	5428964.0
2017-04-19 12:00:00	AAPL	Stock	35.4475	35.451	35.3275	35.365	5040996.0
2017-04-19 13:00:00	AAPL	Stock	35.3675	35.3725	35.2525	35.255	6443208.0
2017-04-19 14:00:00	AAPL	Stock	35.255	35.2725	35.165	35.18	7666028.0
2017-04-19 15:00:00	AAPL	Stock	35.18	35.21	35.1125	35.165	12962524.0
2017-04-19 16:00:00	AAPL	Stock	35.17	35.1925	35.1575	35.19	4644040.0
2017-04-19 17:00:00	AAPL	Stock	35.185	35.185	35.17	35.175	29980.0
2017-04-19 18:00:00	AAPL	Stock	35.185	35.1875	35.1725	35.175	16320.0
2017-04-19 19:00:00	AAPL	Stock	35.1925	35.235	35.1875	35.23	67428.0
2017-04-19 06:00:00	MSFT	Stock	65.6	65.6	65.55	65.55	404.0
2017-04-19 07:00:00	MSFT	Stock	65.55	65.55	65.55	65.55	900.0
2017-04-19 08:00:00	MSFT	Stock	65.5	65.53	65.5	65.53	832.0
2017-04-19 09:00:00	MSFT	Stock	65.57	65.75	65.5	65.55	2569776.0
2017-04-19 10:00:00	MSFT	Stock	65.55	65.58	65.37	65.435	2413572.0
2017-04-19 11:00:00	MSFT	Stock	65.43	65.53	65.38	65.46	2206299.0
2017-04-19 12:00:00	MSFT	Stock	65.455	65.465	65.3	65.3	1578775.0
2017-04-19 13:00:00	MSFT	Stock	65.3	65.32	65.16	65.24	1985012.0
2017-04-19 14:00:00	MSFT	Stock	65.235	65.25	64.98	65.015	2404739.0
2017-04-19 15:00:00	MSFT	Stock	65.01	65.11	64.89	65.03	4875412.0
2017-04-19 16:00:00	MSFT	Stock	65.04	65.09	65.04	65.07	1704447.0
2017-04-19 17:00:00	MSFT	Stock	65.06	65.1	65.04	65.1	4208098.0
2017-04-19 18:00:00	MSFT	Stock	65.06	65.13	65.06	65.13	1097.0
2017-04-19 07:00:00	NVDA	Stock	2.4875	2.4935	2.4862	2.4935	152040.0
2017-04-19 08:00:00	NVDA	Stock	2.491	2.4958	2.4875	2.4875	553320.0
2017-04-19 09:00:00	NVDA	Stock	2.4913	2.5245	2.4902	2.513	73196520.0
2017-04-19 10:00:00	NVDA	Stock	2.5135	2.5138	2.4883	2.4929	60770880.0
2017-04-19 11:00:00	NVDA	Stock	2.4924	2.5185	2.4923	2.5097	52040080.0
2017-04-19 12:00:00	NVDA	Stock	2.5097	2.5175	2.5048	2.515	38987600.0
2017-04-19 13:00:00	NVDA	Stock	2.515	2.5175	2.5015	2.5093	34727440.0
2017-04-19 14:00:00	NVDA	Stock	2.5088	2.5098	2.4945	2.4969	31296240.0
2017-04-19 15:00:00	NVDA	Stock	2.4968	2.5009	2.4852	2.492	47131840.0
2017-04-19 16:00:00	NVDA	Stock	2.492	2.5028	2.4893	2.4913	8879520.0
2017-04-19 18:00:00	NVDA	Stock	2.4913	2.4945	2.4913	2.4945	143040.0
2017-04-19 19:00:00	NVDA	Stock	2.494	2.494	2.4935	2.494	28000.0
2017-04-19 04:00:00	AMZN	Stock	45.23	45.23	45.23	45.23	2000.0
2017-04-19 05:00:00	AMZN	Stock	45.2875	45.3075	45.2875	45.3075	6000.0
2017-04-19 07:00:00	AMZN	Stock	45.362	45.3845	45.35	45.3845	79980.0
2017-04-19 08:00:00	AMZN	Stock	45.375	45.46	45.3695	45.409	250660.0
2017-04-19 09:00:00	AMZN	Stock	45.4125	45.525	45.2165	45.364	8753340.0
2017-04-19 10:00:00	AMZN	Stock	45.374	45.3755	45.197	45.3033	5423100.0
2017-04-19 11:00:00	AMZN	Stock	45.293	45.4285	45.2825	45.2825	5808000.0
2017-04-19 12:00:00	AMZN	Stock	45.282	45.3	45.2205	45.236	4438080.0
2017-04-19 13:00:00	AMZN	Stock	45.243	45.243	45.077	45.077	5393100.0

> showing 50 of 47,882 rows — these rows as CSV

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