PREVIEW / stock_1hour / 2019-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-01.parquet
  size:    1.1 MB
  rows:    49,928
  symbols: 2,485

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-01 04:00:00	AAPL	Stock	62.3575	62.4	62.2475	62.3625	26972.0
2019-11-01 05:00:00	AAPL	Stock	62.3625	62.3625	62.3475	62.35	5952.0
2019-11-01 06:00:00	AAPL	Stock	62.345	62.345	62.3225	62.3425	7040.0
2019-11-01 07:00:00	AAPL	Stock	62.3325	62.35	62.15	62.15	137764.0
2019-11-01 08:00:00	AAPL	Stock	62.33	62.4275	62.15	62.375	686192.0
2019-11-01 09:00:00	AAPL	Stock	62.38	62.99	62.29	62.9475	23077136.0
2019-11-01 10:00:00	AAPL	Stock	62.94	63.4325	62.8125	63.325	26563252.0
2019-11-01 11:00:00	AAPL	Stock	63.33	63.4475	63.25	63.31	13094232.0
2019-11-01 12:00:00	AAPL	Stock	63.3125	63.3275	63.1075	63.1375	10840864.0
2019-11-01 13:00:00	AAPL	Stock	63.135	63.4575	63.1125	63.4125	10283408.0
2019-11-01 14:00:00	AAPL	Stock	63.41	63.595	63.3275	63.5862	9538924.0
2019-11-01 15:00:00	AAPL	Stock	63.585	63.9825	63.5325	63.96	26618680.0
2019-11-01 16:00:00	AAPL	Stock	63.955	63.975	63.29	63.9425	10129980.0
2019-11-01 17:00:00	AAPL	Stock	63.96	63.9975	63.945	63.9725	193000.0
2019-11-01 18:00:00	AAPL	Stock	63.975	64.0	63.9625	63.9875	57076.0
2019-11-01 19:00:00	AAPL	Stock	63.975	64.05	63.965	64.025	97140.0
2019-11-01 04:00:00	MSFT	Stock	143.87	143.87	143.87	143.87	279.0
2019-11-01 05:00:00	MSFT	Stock	143.95	143.95	143.89	143.94	2068.0
2019-11-01 07:00:00	MSFT	Stock	143.97	143.97	143.75	143.75	7962.0
2019-11-01 08:00:00	MSFT	Stock	143.89	144.3	143.7	144.16	53881.0
2019-11-01 09:00:00	MSFT	Stock	144.1	144.45	143.23	143.28	2675513.0
2019-11-01 10:00:00	MSFT	Stock	143.28	143.84	143.03	143.52	2807444.0
2019-11-01 11:00:00	MSFT	Stock	143.52	143.71	143.32	143.41	1674262.0
2019-11-01 12:00:00	MSFT	Stock	143.42	143.43	142.965	143.02	1745347.0
2019-11-01 13:00:00	MSFT	Stock	143.027	143.35	142.98	143.326	2291791.0
2019-11-01 14:00:00	MSFT	Stock	143.325	143.38	143.22	143.375	1870656.0
2019-11-01 15:00:00	MSFT	Stock	143.37	143.75	143.18	143.72	6188061.0
2019-11-01 16:00:00	MSFT	Stock	143.72	143.89	143.205	143.75	4168053.0
2019-11-01 17:00:00	MSFT	Stock	143.71	143.78	143.7	143.7	11933.0
2019-11-01 18:00:00	MSFT	Stock	143.7	143.71	143.7	143.7	1109.0
2019-11-01 19:00:00	MSFT	Stock	143.7	143.74	143.7	143.74	7418.0
2019-11-01 05:00:00	NVDA	Stock	5.026	5.026	5.0	5.0	52240.0
2019-11-01 06:00:00	NVDA	Stock	5.011	5.011	5.011	5.011	15440.0
2019-11-01 07:00:00	NVDA	Stock	5.0138	5.0138	4.9975	4.9992	388440.0
2019-11-01 08:00:00	NVDA	Stock	5.0038	5.0247	4.9888	4.9935	1503320.0
2019-11-01 09:00:00	NVDA	Stock	4.9935	5.069	4.9648	5.0685	45444400.0
2019-11-01 10:00:00	NVDA	Stock	5.066	5.0972	5.0502	5.0712	51816560.0
2019-11-01 11:00:00	NVDA	Stock	5.0715	5.077	5.0508	5.0718	19560280.0
2019-11-01 12:00:00	NVDA	Stock	5.0718	5.0718	5.0333	5.0626	26596600.0
2019-11-01 13:00:00	NVDA	Stock	5.062	5.0875	5.0615	5.0685	22795920.0
2019-11-01 14:00:00	NVDA	Stock	5.0698	5.0778	5.058	5.064	17589200.0
2019-11-01 15:00:00	NVDA	Stock	5.0632	5.0685	5.0408	5.0685	37567560.0
2019-11-01 16:00:00	NVDA	Stock	5.0648	5.065	5.0562	5.0648	3006720.0
2019-11-01 17:00:00	NVDA	Stock	5.0638	5.0638	5.0545	5.0545	593920.0
2019-11-01 18:00:00	NVDA	Stock	5.0618	5.0625	5.0585	5.06	94400.0
2019-11-01 19:00:00	NVDA	Stock	5.0625	5.0645	5.06	5.0625	89240.0
2019-11-01 06:00:00	AMZN	Stock	89.3225	89.3285	89.3225	89.3285	13240.0
2019-11-01 07:00:00	AMZN	Stock	89.29	89.29	89.0	89.0	50140.0
2019-11-01 08:00:00	AMZN	Stock	89.2	89.425	88.9275	89.4	263960.0
2019-11-01 09:00:00	AMZN	Stock	89.4025	89.7415	89.2605	89.617	11797960.0

> showing 50 of 49,928 rows — these rows as CSV

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