PREVIEW / stock_1hour / 2019-11-25

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-25.parquet
  size:    1.1 MB
  rows:    50,474
  symbols: 2,516

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
2019-11-25 04:00:00	AAPL	Stock	65.6675	65.7975	65.6675	65.7	12736.0
2019-11-25 05:00:00	AAPL	Stock	65.7475	65.75	65.7475	65.75	5908.0
2019-11-25 06:00:00	AAPL	Stock	65.7625	65.7625	65.7375	65.7375	5148.0
2019-11-25 07:00:00	AAPL	Stock	65.7375	65.7375	65.6575	65.6875	59204.0
2019-11-25 08:00:00	AAPL	Stock	65.6625	65.7212	65.4	65.6375	362916.0
2019-11-25 09:00:00	AAPL	Stock	65.6275	66.21	65.585	66.1425	9087480.0
2019-11-25 10:00:00	AAPL	Stock	66.1475	66.41	66.105	66.325	9330752.0
2019-11-25 11:00:00	AAPL	Stock	66.3275	66.37	66.2125	66.2725	5625360.0
2019-11-25 12:00:00	AAPL	Stock	66.2735	66.305	66.235	66.275	2901276.0
2019-11-25 13:00:00	AAPL	Stock	66.275	66.3125	66.155	66.184	3936700.0
2019-11-25 14:00:00	AAPL	Stock	66.1825	66.3175	66.145	66.3145	3943120.0
2019-11-25 15:00:00	AAPL	Stock	66.31	66.61	66.2925	66.605	12062064.0
2019-11-25 16:00:00	AAPL	Stock	66.605	66.605	66.525	66.575	19496536.0
2019-11-25 17:00:00	AAPL	Stock	66.5625	66.575	66.5375	66.5675	57952.0
2019-11-25 18:00:00	AAPL	Stock	66.5675	66.5925	66.5625	66.5925	19104.0
2019-11-25 19:00:00	AAPL	Stock	66.605	66.6775	66.5775	66.6775	65140.0
2019-11-25 04:00:00	MSFT	Stock	149.98	150.2	149.98	150.2	1514.0
2019-11-25 05:00:00	MSFT	Stock	150.21	150.23	150.21	150.23	1949.0
2019-11-25 06:00:00	MSFT	Stock	150.32	150.32	150.25	150.25	497.0
2019-11-25 07:00:00	MSFT	Stock	150.23	150.23	150.01	150.15	17476.0
2019-11-25 08:00:00	MSFT	Stock	150.07	150.19	150.03	150.1	23567.0
2019-11-25 09:00:00	MSFT	Stock	150.1	150.79	149.92	150.64	2267890.0
2019-11-25 10:00:00	MSFT	Stock	150.65	150.865	150.3	150.77	1887107.0
2019-11-25 11:00:00	MSFT	Stock	150.775	150.96	150.7	150.8	1441820.0
2019-11-25 12:00:00	MSFT	Stock	150.8	150.83	150.66	150.775	891230.0
2019-11-25 13:00:00	MSFT	Stock	150.78	150.96	150.7	150.95	1045334.0
2019-11-25 14:00:00	MSFT	Stock	150.955	151.04	150.86	150.96	1326244.0
2019-11-25 15:00:00	MSFT	Stock	150.95	151.35	150.94	151.225	3362476.0
2019-11-25 16:00:00	MSFT	Stock	151.23	151.3	150.0	151.3	7429505.0
2019-11-25 17:00:00	MSFT	Stock	151.3	151.3	151.2	151.3	1492.0
2019-11-25 18:00:00	MSFT	Stock	151.26	151.3	151.23	151.29	2867.0
2019-11-25 19:00:00	MSFT	Stock	151.3	151.46	151.3	151.46	5079.0
2019-11-25 04:00:00	NVDA	Stock	5.3875	5.412	5.375	5.4042	708840.0
2019-11-25 05:00:00	NVDA	Stock	5.415	5.4373	5.415	5.4218	143520.0
2019-11-25 06:00:00	NVDA	Stock	5.425	5.4295	5.4155	5.4168	233000.0
2019-11-25 07:00:00	NVDA	Stock	5.408	5.42	5.3925	5.405	2382080.0
2019-11-25 08:00:00	NVDA	Stock	5.413	5.42	5.3903	5.4083	2308760.0
2019-11-25 09:00:00	NVDA	Stock	5.4095	5.525	5.388	5.4983	121451800.0
2019-11-25 10:00:00	NVDA	Stock	5.4991	5.5342	5.4888	5.508	79320200.0
2019-11-25 11:00:00	NVDA	Stock	5.5082	5.525	5.4905	5.5104	35511480.0
2019-11-25 12:00:00	NVDA	Stock	5.5093	5.5123	5.4845	5.5029	29044680.0
2019-11-25 13:00:00	NVDA	Stock	5.5033	5.5153	5.4985	5.511	26275240.0
2019-11-25 14:00:00	NVDA	Stock	5.5108	5.5353	5.507	5.5168	31244800.0
2019-11-25 15:00:00	NVDA	Stock	5.5165	5.5345	5.5038	5.5308	62941960.0
2019-11-25 16:00:00	NVDA	Stock	5.5303	5.5303	5.4325	5.5225	23588800.0
2019-11-25 17:00:00	NVDA	Stock	5.5225	5.5225	5.5188	5.5193	62480.0
2019-11-25 18:00:00	NVDA	Stock	5.5225	5.525	5.52	5.5212	500960.0
2019-11-25 19:00:00	NVDA	Stock	5.5212	5.525	5.5143	5.525	379480.0
2019-11-25 05:00:00	AMZN	Stock	87.6	87.6	87.6	87.6	5620.0
2019-11-25 06:00:00	AMZN	Stock	87.625	87.625	87.625	87.625	2000.0

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

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