PREVIEW / stock_1hour / 2021-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-29.parquet
  size:    1.5 MB
  rows:    67,662
  symbols: 2,679

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
2021-11-29 04:00:00	AAPL	Stock	158.11	158.95	157.4	158.35	54069.0
2021-11-29 05:00:00	AAPL	Stock	158.4	159.2	158.4	159.18	37378.0
2021-11-29 06:00:00	AAPL	Stock	159.15	159.22	158.8	158.98	56368.0
2021-11-29 07:00:00	AAPL	Stock	159.0	159.16	158.52	159.13	196148.0
2021-11-29 08:00:00	AAPL	Stock	158.75	159.88	158.52	159.81	818847.0
2021-11-29 09:00:00	AAPL	Stock	159.81	160.58	159.08	160.24	13264838.0
2021-11-29 10:00:00	AAPL	Stock	160.23	160.53	158.7901	159.2	12757519.0
2021-11-29 11:00:00	AAPL	Stock	159.21	160.44	158.95	160.36	7930063.0
2021-11-29 12:00:00	AAPL	Stock	160.3643	160.88	160.19	160.525	7745328.0
2021-11-29 13:00:00	AAPL	Stock	160.53	161.19	160.45	161.01	5705699.0
2021-11-29 14:00:00	AAPL	Stock	161.01	161.11	160.4	160.76	5939646.0
2021-11-29 15:00:00	AAPL	Stock	160.76	160.85	159.98	160.23	11167921.0
2021-11-29 16:00:00	AAPL	Stock	160.48	160.54	160.1	160.5	8636684.0
2021-11-29 17:00:00	AAPL	Stock	160.51	160.54	160.31	160.36	22940.0
2021-11-29 18:00:00	AAPL	Stock	160.36	160.58	160.36	160.57	37390.0
2021-11-29 19:00:00	AAPL	Stock	160.52	160.63	160.52	160.63	46703.0
2021-11-29 04:00:00	MSFT	Stock	332.35	334.4	332.35	333.3	4331.0
2021-11-29 05:00:00	MSFT	Stock	333.1	334.27	333.1	334.27	6534.0
2021-11-29 06:00:00	MSFT	Stock	334.12	334.33	333.78	333.78	7424.0
2021-11-29 07:00:00	MSFT	Stock	333.96	333.98	333.2	333.7	23203.0
2021-11-29 08:00:00	MSFT	Stock	333.32	334.41	329.68	334.3	170125.0
2021-11-29 09:00:00	MSFT	Stock	334.25	337.66	334.0	337.205	3283968.0
2021-11-29 10:00:00	MSFT	Stock	337.17	339.03	336.87	337.54	3374239.0
2021-11-29 11:00:00	MSFT	Stock	337.55	338.1	336.1	337.97	1918489.0
2021-11-29 12:00:00	MSFT	Stock	337.98	338.13	337.26	337.72	1400159.0
2021-11-29 13:00:00	MSFT	Stock	337.74	338.26	337.38	337.665	1093719.0
2021-11-29 14:00:00	MSFT	Stock	337.68	337.785	336.63	337.48	1106704.0
2021-11-29 15:00:00	MSFT	Stock	337.475	337.83	335.5	336.55	2736241.0
2021-11-29 16:00:00	MSFT	Stock	336.89	337.59	336.55	337.48	5824801.0
2021-11-29 17:00:00	MSFT	Stock	337.4	337.5	337.4	337.4	6023.0
2021-11-29 18:00:00	MSFT	Stock	337.46	338.0	337.46	337.97	5862.0
2021-11-29 19:00:00	MSFT	Stock	337.83	338.15	337.61	338.15	15318.0
2021-11-29 04:00:00	NVDA	Stock	31.937	32.388	31.9	32.066	236840.0
2021-11-29 05:00:00	NVDA	Stock	32.08	32.259	32.08	32.257	82230.0
2021-11-29 06:00:00	NVDA	Stock	32.279	32.325	32.05	32.13	117660.0
2021-11-29 07:00:00	NVDA	Stock	32.131	32.15	31.92	32.039	1011850.0
2021-11-29 08:00:00	NVDA	Stock	32.0448	32.224	31.503	32.195	2988370.0
2021-11-29 09:00:00	NVDA	Stock	32.2	32.754	32.036	32.464	55139320.0
2021-11-29 10:00:00	NVDA	Stock	32.459	32.604	32.078	32.419	47491620.0
2021-11-29 11:00:00	NVDA	Stock	32.419	32.9	32.3342	32.867	39945950.0
2021-11-29 12:00:00	NVDA	Stock	32.8662	33.146	32.832	32.868	49104340.0
2021-11-29 13:00:00	NVDA	Stock	32.876	33.04	32.757	33.0295	28091490.0
2021-11-29 14:00:00	NVDA	Stock	33.0281	33.089	32.893	33.01	22820420.0
2021-11-29 15:00:00	NVDA	Stock	33.009	33.412	32.9816	33.376	54389660.0
2021-11-29 16:00:00	NVDA	Stock	33.376	33.499	33.3057	33.475	36589640.0
2021-11-29 17:00:00	NVDA	Stock	33.477	33.487	33.44	33.46	237600.0
2021-11-29 18:00:00	NVDA	Stock	33.465	33.6	33.465	33.585	736160.0
2021-11-29 19:00:00	NVDA	Stock	33.585	33.6	33.513	33.565	464500.0
2021-11-29 04:00:00	AMZN	Stock	176.9925	177.375	176.9925	177.1	53040.0
2021-11-29 05:00:00	AMZN	Stock	176.858	176.858	176.858	176.858	2000.0

> showing 50 of 67,662 rows — these rows as CSV

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