PREVIEW / stock_1hour / 2020-08-06

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-06.parquet
  size:    1.3 MB
  rows:    57,411
  symbols: 2,419

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
2020-08-06 04:00:00	AAPL	Stock	110.05	110.05	109.7825	109.875	10996.0
2020-08-06 05:00:00	AAPL	Stock	109.85	109.95	109.825	109.95	20972.0
2020-08-06 06:00:00	AAPL	Stock	109.9975	109.9975	109.6	109.65	26312.0
2020-08-06 07:00:00	AAPL	Stock	109.7	109.875	109.58	109.8475	170368.0
2020-08-06 08:00:00	AAPL	Stock	109.843	110.4212	109.625	110.355	838828.0
2020-08-06 09:00:00	AAPL	Stock	110.3718	111.2275	109.7975	111.06	17904556.0
2020-08-06 10:00:00	AAPL	Stock	111.055	111.45	110.6	111.085	20985488.0
2020-08-06 11:00:00	AAPL	Stock	111.0625	111.7475	111.0625	111.5538	14404216.0
2020-08-06 12:00:00	AAPL	Stock	111.556	112.425	111.5188	112.3675	15950368.0
2020-08-06 13:00:00	AAPL	Stock	112.3712	112.98	111.87	112.9425	18625476.0
2020-08-06 14:00:00	AAPL	Stock	112.9462	114.0125	112.5875	113.926	26084368.0
2020-08-06 15:00:00	AAPL	Stock	113.9375	114.4125	113.4525	113.97	38927436.0
2020-08-06 16:00:00	AAPL	Stock	113.9525	113.9525	113.64	113.9125	8113228.0
2020-08-06 17:00:00	AAPL	Stock	113.9225	114.1975	113.91	114.125	244168.0
2020-08-06 18:00:00	AAPL	Stock	114.1425	114.195	114.0325	114.175	120836.0
2020-08-06 19:00:00	AAPL	Stock	114.125	114.275	114.05	114.25	172240.0
2020-08-06 04:00:00	MSFT	Stock	212.6	212.6	211.99	211.99	1803.0
2020-08-06 05:00:00	MSFT	Stock	211.9	212.0	211.7	211.86	3253.0
2020-08-06 06:00:00	MSFT	Stock	211.93	212.0	211.65	211.75	3693.0
2020-08-06 07:00:00	MSFT	Stock	211.9	212.0	211.7	211.95	17914.0
2020-08-06 08:00:00	MSFT	Stock	211.799	212.88	211.68	212.63	70579.0
2020-08-06 09:00:00	MSFT	Stock	212.648	212.93	211.55	212.81	2553463.0
2020-08-06 10:00:00	MSFT	Stock	212.815	213.95	212.08	212.88	3386093.0
2020-08-06 11:00:00	MSFT	Stock	212.87	214.55	212.67	213.07	4541890.0
2020-08-06 12:00:00	MSFT	Stock	213.08	214.0	212.8	213.97	2375553.0
2020-08-06 13:00:00	MSFT	Stock	213.96	214.765	213.52	214.353	2011364.0
2020-08-06 14:00:00	MSFT	Stock	214.37	215.52	214.305	215.355	2882126.0
2020-08-06 15:00:00	MSFT	Stock	215.36	216.37	215.083	216.35	5705165.0
2020-08-06 16:00:00	MSFT	Stock	216.35	216.35	215.82	216.17	3829107.0
2020-08-06 17:00:00	MSFT	Stock	216.17	216.22	216.06	216.11	14947.0
2020-08-06 18:00:00	MSFT	Stock	216.11	216.19	216.0	216.12	12491.0
2020-08-06 19:00:00	MSFT	Stock	216.12	216.16	216.0	216.15	10900.0
2020-08-06 04:00:00	NVDA	Stock	11.275	11.275	11.255	11.2612	30200.0
2020-08-06 05:00:00	NVDA	Stock	11.2625	11.2625	11.2625	11.2625	8600.0
2020-08-06 06:00:00	NVDA	Stock	11.2625	11.2625	11.22	11.22	65720.0
2020-08-06 07:00:00	NVDA	Stock	11.204	11.225	11.2038	11.22	192440.0
2020-08-06 08:00:00	NVDA	Stock	11.2394	11.3148	11.2025	11.3125	912360.0
2020-08-06 09:00:00	NVDA	Stock	11.3124	11.356	11.2255	11.32	34504040.0
2020-08-06 10:00:00	NVDA	Stock	11.3222	11.3412	11.1788	11.2148	46719160.0
2020-08-06 11:00:00	NVDA	Stock	11.2153	11.2807	11.2	11.2419	32547720.0
2020-08-06 12:00:00	NVDA	Stock	11.2366	11.2795	11.2272	11.2648	18326840.0
2020-08-06 13:00:00	NVDA	Stock	11.2653	11.3055	11.2545	11.285	17438000.0
2020-08-06 14:00:00	NVDA	Stock	11.2858	11.341	11.283	11.3312	16448160.0
2020-08-06 15:00:00	NVDA	Stock	11.3315	11.358	11.3148	11.3365	30231560.0
2020-08-06 16:00:00	NVDA	Stock	11.3355	11.3375	11.3	11.325	11857440.0
2020-08-06 17:00:00	NVDA	Stock	11.3263	11.3355	11.3188	11.322	359480.0
2020-08-06 18:00:00	NVDA	Stock	11.3178	11.3275	11.3178	11.3275	95440.0
2020-08-06 19:00:00	NVDA	Stock	11.3113	11.3275	11.3113	11.325	165640.0
2020-08-06 07:00:00	AMZN	Stock	159.25	159.3	159.05	159.1505	91400.0
2020-08-06 08:00:00	AMZN	Stock	159.0	160.096	159.0	160.0004	445900.0

> showing 50 of 57,411 rows — these rows as CSV

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