PREVIEW / stock_1hour / 2018-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-19.parquet
  size:    1.1 MB
  rows:    50,365
  symbols: 2,829

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
2018-06-19 04:00:00	AAPL	Stock	46.75	46.75	46.5	46.65	86264.0
2018-06-19 05:00:00	AAPL	Stock	46.6875	46.74	46.675	46.675	25540.0
2018-06-19 06:00:00	AAPL	Stock	46.7025	46.8	46.7	46.725	28132.0
2018-06-19 07:00:00	AAPL	Stock	46.7	46.825	46.6125	46.725	299904.0
2018-06-19 08:00:00	AAPL	Stock	46.75	46.8225	46.4375	46.5	1038172.0
2018-06-19 09:00:00	AAPL	Stock	46.505	46.6475	46.255	46.2975	22393708.0
2018-06-19 10:00:00	AAPL	Stock	46.2975	46.2975	45.8625	46.205	29162920.0
2018-06-19 11:00:00	AAPL	Stock	46.205	46.32	46.1225	46.283	13867576.0
2018-06-19 12:00:00	AAPL	Stock	46.2825	46.3325	46.2	46.2925	6885508.0
2018-06-19 13:00:00	AAPL	Stock	46.29	46.4775	46.2575	46.42	6778976.0
2018-06-19 14:00:00	AAPL	Stock	46.42	46.46	46.375	46.4275	7353508.0
2018-06-19 15:00:00	AAPL	Stock	46.43	46.4625	46.3175	46.4425	11985636.0
2018-06-19 16:00:00	AAPL	Stock	46.4225	46.4475	46.335	46.3875	12844928.0
2018-06-19 17:00:00	AAPL	Stock	46.3875	46.4375	46.1588	46.435	148404.0
2018-06-19 18:00:00	AAPL	Stock	46.42	46.425	46.4	46.4225	24232.0
2018-06-19 19:00:00	AAPL	Stock	46.4125	46.45	46.4075	46.4375	67852.0
2018-06-19 04:00:00	MSFT	Stock	99.6	99.95	99.25	99.3	10474.0
2018-06-19 05:00:00	MSFT	Stock	99.7	100.09	99.7	99.72	1300.0
2018-06-19 07:00:00	MSFT	Stock	99.94	99.94	99.5	99.75	25481.0
2018-06-19 08:00:00	MSFT	Stock	99.85	101.05	99.45	99.7	38346.0
2018-06-19 09:00:00	MSFT	Stock	99.74	100.3	99.5	100.03	3694647.0
2018-06-19 10:00:00	MSFT	Stock	100.03	100.17	99.52	99.95	4412206.0
2018-06-19 11:00:00	MSFT	Stock	99.945	100.586	99.9	100.5	2868844.0
2018-06-19 12:00:00	MSFT	Stock	100.495	100.53	100.22	100.38	1857093.0
2018-06-19 13:00:00	MSFT	Stock	100.39	100.56	100.16	100.55	1297405.0
2018-06-19 14:00:00	MSFT	Stock	100.55	100.92	100.52	100.84	2004368.0
2018-06-19 15:00:00	MSFT	Stock	100.845	101.0	100.43	100.88	3720972.0
2018-06-19 16:00:00	MSFT	Stock	100.86	100.9	100.81	100.86	3930447.0
2018-06-19 17:00:00	MSFT	Stock	100.86	100.9	100.86	100.9	1150.0
2018-06-19 18:00:00	MSFT	Stock	100.9	100.9	100.78	100.78	3977.0
2018-06-19 19:00:00	MSFT	Stock	100.86	101.0	100.81	100.81	3640.0
2018-06-19 04:00:00	NVDA	Stock	6.5625	6.5625	6.5073	6.5252	50280.0
2018-06-19 05:00:00	NVDA	Stock	6.526	6.5368	6.5225	6.5225	129240.0
2018-06-19 06:00:00	NVDA	Stock	6.535	6.535	6.535	6.535	16000.0
2018-06-19 07:00:00	NVDA	Stock	6.525	6.5525	6.518	6.526	494200.0
2018-06-19 08:00:00	NVDA	Stock	6.525	6.55	6.5158	6.5302	2216720.0
2018-06-19 09:00:00	NVDA	Stock	6.5315	6.5603	6.4312	6.454	105256280.0
2018-06-19 10:00:00	NVDA	Stock	6.454	6.47	6.3755	6.4192	131114080.0
2018-06-19 11:00:00	NVDA	Stock	6.4183	6.4698	6.4045	6.4585	70326000.0
2018-06-19 12:00:00	NVDA	Stock	6.4588	6.4615	6.418	6.4328	38569920.0
2018-06-19 13:00:00	NVDA	Stock	6.4328	6.4522	6.4192	6.45	32384840.0
2018-06-19 14:00:00	NVDA	Stock	6.45	6.4842	6.45	6.4768	40612000.0
2018-06-19 15:00:00	NVDA	Stock	6.4768	6.591	6.4483	6.5043	78519400.0
2018-06-19 16:00:00	NVDA	Stock	6.5123	6.5143	6.499	6.5125	56148880.0
2018-06-19 17:00:00	NVDA	Stock	6.5125	6.5173	6.5075	6.5173	3656840.0
2018-06-19 18:00:00	NVDA	Stock	6.5078	6.5162	6.5078	6.509	283520.0
2018-06-19 19:00:00	NVDA	Stock	6.509	6.5168	6.5078	6.515	187840.0
2018-06-19 04:00:00	AMZN	Stock	85.008	85.2395	84.9155	85.2395	66660.0
2018-06-19 05:00:00	AMZN	Stock	85.225	85.438	85.225	85.3165	25300.0
2018-06-19 06:00:00	AMZN	Stock	85.495	85.495	85.35	85.35	6000.0

> showing 50 of 50,365 rows — these rows as CSV

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