PREVIEW / stock_1hour / 2019-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-31.parquet
  size:    1.2 MB
  rows:    52,078
  symbols: 2,601

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-07-31 04:00:00	AAPL	Stock	54.5325	54.575	54.35	54.5	117200.0
2019-07-31 05:00:00	AAPL	Stock	54.5	54.55	54.275	54.3275	91200.0
2019-07-31 06:00:00	AAPL	Stock	54.325	54.445	54.29	54.3375	84768.0
2019-07-31 07:00:00	AAPL	Stock	54.37	54.5725	54.3225	54.455	961592.0
2019-07-31 08:00:00	AAPL	Stock	54.4325	54.5675	54.1	54.1875	1701940.0
2019-07-31 09:00:00	AAPL	Stock	54.1825	55.3425	54.075	54.7775	70461224.0
2019-07-31 10:00:00	AAPL	Stock	54.78	54.985	54.2875	54.5625	41828948.0
2019-07-31 11:00:00	AAPL	Stock	54.5625	54.6925	54.3775	54.4685	13830300.0
2019-07-31 12:00:00	AAPL	Stock	54.4675	54.485	54.0425	54.265	16505412.0
2019-07-31 13:00:00	AAPL	Stock	54.2632	54.4175	54.21	54.3325	8747544.0
2019-07-31 14:00:00	AAPL	Stock	54.3375	54.455	52.825	53.65	32891704.0
2019-07-31 15:00:00	AAPL	Stock	53.645	53.96	53.195	53.195	36357816.0
2019-07-31 16:00:00	AAPL	Stock	53.26	54.2962	53.165	53.175	12779288.0
2019-07-31 17:00:00	AAPL	Stock	53.2125	53.26	53.15	53.17	171968.0
2019-07-31 18:00:00	AAPL	Stock	53.17	53.2725	53.0775	53.2375	245796.0
2019-07-31 19:00:00	AAPL	Stock	53.24	53.3975	53.225	53.225	137640.0
2019-07-31 04:00:00	MSFT	Stock	140.73	140.78	140.73	140.76	2186.0
2019-07-31 05:00:00	MSFT	Stock	140.6	140.6	140.6	140.6	100.0
2019-07-31 06:00:00	MSFT	Stock	140.38	140.38	140.35	140.35	400.0
2019-07-31 07:00:00	MSFT	Stock	140.41	140.41	140.11	140.39	9943.0
2019-07-31 08:00:00	MSFT	Stock	140.15	140.596	140.15	140.5	15689.0
2019-07-31 09:00:00	MSFT	Stock	140.59	140.69	139.215	139.57	3512144.0
2019-07-31 10:00:00	MSFT	Stock	139.56	139.76	138.83	139.26	3754516.0
2019-07-31 11:00:00	MSFT	Stock	139.26	139.545	139.04	139.22	1665555.0
2019-07-31 12:00:00	MSFT	Stock	139.22	139.26	138.87	138.97	1344660.0
2019-07-31 13:00:00	MSFT	Stock	138.97	138.99	138.62	138.91	1911812.0
2019-07-31 14:00:00	MSFT	Stock	138.91	139.09	135.08	136.77	6235325.0
2019-07-31 15:00:00	MSFT	Stock	136.75	137.69	136.21	136.21	9823407.0
2019-07-31 16:00:00	MSFT	Stock	136.24	137.5	136.0	136.2	4209414.0
2019-07-31 17:00:00	MSFT	Stock	136.0	136.27	136.0	136.2	42112.0
2019-07-31 18:00:00	MSFT	Stock	136.1	136.19	135.8	136.19	18455.0
2019-07-31 19:00:00	MSFT	Stock	136.18	136.4	136.07	136.09	22012.0
2019-07-31 05:00:00	NVDA	Stock	4.3578	4.3578	4.3578	4.3578	8000.0
2019-07-31 06:00:00	NVDA	Stock	4.3572	4.3572	4.3572	4.3572	4000.0
2019-07-31 07:00:00	NVDA	Stock	4.355	4.365	4.35	4.3625	224040.0
2019-07-31 08:00:00	NVDA	Stock	4.3612	4.3625	4.3486	4.3538	434360.0
2019-07-31 09:00:00	NVDA	Stock	4.354	4.3588	4.298	4.3296	43384840.0
2019-07-31 10:00:00	NVDA	Stock	4.3292	4.331	4.3015	4.3146	34006000.0
2019-07-31 11:00:00	NVDA	Stock	4.3138	4.3233	4.3015	4.3048	27892200.0
2019-07-31 12:00:00	NVDA	Stock	4.304	4.3168	4.3015	4.3035	22887000.0
2019-07-31 13:00:00	NVDA	Stock	4.303	4.3162	4.3015	4.3141	18648120.0
2019-07-31 14:00:00	NVDA	Stock	4.3135	4.3178	4.1755	4.2282	69827040.0
2019-07-31 15:00:00	NVDA	Stock	4.2282	4.259	4.2136	4.218	79562680.0
2019-07-31 16:00:00	NVDA	Stock	4.218	4.2188	4.1825	4.1912	6812920.0
2019-07-31 17:00:00	NVDA	Stock	4.1912	4.218	4.1862	4.1938	1026440.0
2019-07-31 18:00:00	NVDA	Stock	4.1875	4.2115	4.1838	4.2	650080.0
2019-07-31 19:00:00	NVDA	Stock	4.211	4.212	4.203	4.2088	167680.0
2019-07-31 04:00:00	AMZN	Stock	95.2	95.3325	95.2	95.3325	22000.0
2019-07-31 07:00:00	AMZN	Stock	95.2655	95.2655	95.091	95.175	60380.0
2019-07-31 08:00:00	AMZN	Stock	95.175	95.7515	95.09	95.115	234400.0

> showing 50 of 52,078 rows — these rows as CSV

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