PREVIEW / stock_1hour / 2019-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-05.parquet
  size:    1.1 MB
  rows:    51,113
  symbols: 2,526

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-05 04:00:00	AAPL	Stock	64.55	64.605	64.5	64.575	21020.0
2019-11-05 05:00:00	AAPL	Stock	64.5625	64.5625	64.5625	64.5625	400.0
2019-11-05 06:00:00	AAPL	Stock	64.4775	64.4775	64.4675	64.4675	7076.0
2019-11-05 07:00:00	AAPL	Stock	64.4625	64.5375	64.45	64.4525	148132.0
2019-11-05 08:00:00	AAPL	Stock	64.525	64.5375	64.4375	64.48	290228.0
2019-11-05 09:00:00	AAPL	Stock	64.475	64.48	64.08	64.33	11165488.0
2019-11-05 10:00:00	AAPL	Stock	64.33	64.5475	64.1775	64.3775	13847176.0
2019-11-05 11:00:00	AAPL	Stock	64.38	64.4425	64.2675	64.38	6277220.0
2019-11-05 12:00:00	AAPL	Stock	64.3775	64.4775	64.2875	64.395	5094784.0
2019-11-05 13:00:00	AAPL	Stock	64.395	64.5025	64.3925	64.4525	5001444.0
2019-11-05 14:00:00	AAPL	Stock	64.4512	64.5475	64.39	64.48	5680268.0
2019-11-05 15:00:00	AAPL	Stock	64.4812	64.5128	64.235	64.2875	9802716.0
2019-11-05 16:00:00	AAPL	Stock	64.2825	64.3025	64.1825	64.2375	6097912.0
2019-11-05 17:00:00	AAPL	Stock	64.2375	64.2825	64.1875	64.1875	116296.0
2019-11-05 18:00:00	AAPL	Stock	64.1875	64.2375	64.1825	64.215	54776.0
2019-11-05 19:00:00	AAPL	Stock	64.21	64.225	64.15	64.155	67192.0
2019-11-05 04:00:00	MSFT	Stock	145.0	145.15	145.0	145.1	5552.0
2019-11-05 05:00:00	MSFT	Stock	145.13	145.21	145.12	145.14	3755.0
2019-11-05 06:00:00	MSFT	Stock	145.09	145.09	144.68	144.91	7263.0
2019-11-05 07:00:00	MSFT	Stock	144.95	145.05	144.9	144.92	23671.0
2019-11-05 08:00:00	MSFT	Stock	144.98	145.31	144.85	145.1	72988.0
2019-11-05 09:00:00	MSFT	Stock	145.14	145.15	144.23	144.42	2343150.0
2019-11-05 10:00:00	MSFT	Stock	144.42	144.68	143.905	144.13	2197083.0
2019-11-05 11:00:00	MSFT	Stock	144.15	144.64	144.11	144.539	1414880.0
2019-11-05 12:00:00	MSFT	Stock	144.53	144.73	144.365	144.7	1134057.0
2019-11-05 13:00:00	MSFT	Stock	144.7	144.759	144.46	144.58	1205978.0
2019-11-05 14:00:00	MSFT	Stock	144.578	144.71	144.465	144.517	1137068.0
2019-11-05 15:00:00	MSFT	Stock	144.515	144.78	144.4	144.46	2528474.0
2019-11-05 16:00:00	MSFT	Stock	144.46	144.715	144.35	144.35	3131210.0
2019-11-05 17:00:00	MSFT	Stock	144.25	144.3	144.22	144.3	3052.0
2019-11-05 18:00:00	MSFT	Stock	144.25	144.33	144.19	144.33	14921.0
2019-11-05 19:00:00	MSFT	Stock	144.3	144.35	144.25	144.26	15689.0
2019-11-05 04:00:00	NVDA	Stock	5.2775	5.2945	5.2775	5.2945	63840.0
2019-11-05 05:00:00	NVDA	Stock	5.2945	5.3	5.2925	5.3	59400.0
2019-11-05 06:00:00	NVDA	Stock	5.2908	5.2908	5.2625	5.281	137680.0
2019-11-05 07:00:00	NVDA	Stock	5.2833	5.2975	5.2825	5.2905	613280.0
2019-11-05 08:00:00	NVDA	Stock	5.2902	5.2973	5.2815	5.291	1240360.0
2019-11-05 09:00:00	NVDA	Stock	5.292	5.2938	5.192	5.269	61789120.0
2019-11-05 10:00:00	NVDA	Stock	5.27	5.2775	5.2055	5.2355	48028680.0
2019-11-05 11:00:00	NVDA	Stock	5.2368	5.2842	5.2342	5.276	41216840.0
2019-11-05 12:00:00	NVDA	Stock	5.277	5.283	5.263	5.2772	33183640.0
2019-11-05 13:00:00	NVDA	Stock	5.2763	5.2885	5.2693	5.2735	22281560.0
2019-11-05 14:00:00	NVDA	Stock	5.2742	5.2765	5.2593	5.2685	20490280.0
2019-11-05 15:00:00	NVDA	Stock	5.2693	5.28	5.232	5.2408	39614800.0
2019-11-05 16:00:00	NVDA	Stock	5.2403	5.2715	5.2315	5.233	10039560.0
2019-11-05 17:00:00	NVDA	Stock	5.235	5.2362	5.2312	5.2312	79560.0
2019-11-05 18:00:00	NVDA	Stock	5.2355	5.2403	5.2312	5.2375	87760.0
2019-11-05 19:00:00	NVDA	Stock	5.2368	5.2375	5.2325	5.2325	94720.0
2019-11-05 04:00:00	AMZN	Stock	90.508	90.589	90.508	90.589	7460.0
2019-11-05 05:00:00	AMZN	Stock	90.589	90.589	90.589	90.589	7200.0

> showing 50 of 51,113 rows — these rows as CSV

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