PREVIEW / stock_1hour / 2022-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-23.parquet
  size:    1.4 MB
  rows:    63,086
  symbols: 2,378

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
2022-05-23 04:00:00	AAPL	Stock	138.75	139.37	137.8	138.0	50521.0
2022-05-23 05:00:00	AAPL	Stock	138.1	138.45	138.0	138.01	51401.0
2022-05-23 06:00:00	AAPL	Stock	137.98	138.87	137.95	138.72	41454.0
2022-05-23 07:00:00	AAPL	Stock	138.72	138.85	137.91	138.39	151333.0
2022-05-23 08:00:00	AAPL	Stock	138.7435	139.48	137.81	137.94	961720.0
2022-05-23 09:00:00	AAPL	Stock	137.9449	141.03	137.51	139.79	15437731.0
2022-05-23 10:00:00	AAPL	Stock	139.8	141.68	138.69	140.47	17918850.0
2022-05-23 11:00:00	AAPL	Stock	140.49	142.08	140.26	141.98	12946853.0
2022-05-23 12:00:00	AAPL	Stock	141.99	143.26	141.81	142.3765	13151249.0
2022-05-23 13:00:00	AAPL	Stock	142.385	142.8656	141.5207	142.64	9580109.0
2022-05-23 14:00:00	AAPL	Stock	142.6501	142.9199	142.0633	142.215	8203050.0
2022-05-23 15:00:00	AAPL	Stock	142.219	143.25	141.895	143.15	15754334.0
2022-05-23 16:00:00	AAPL	Stock	143.14	143.45	143.05	143.28	8377771.0
2022-05-23 17:00:00	AAPL	Stock	143.28	143.28	140.66	140.98	441710.0
2022-05-23 18:00:00	AAPL	Stock	141.1	141.26	140.5	141.25	190011.0
2022-05-23 19:00:00	AAPL	Stock	141.25	141.4	141.0	141.19	116971.0
2022-05-23 04:00:00	MSFT	Stock	255.01	256.5	253.8	253.83	5248.0
2022-05-23 05:00:00	MSFT	Stock	254.0	255.45	253.0	253.9	18386.0
2022-05-23 06:00:00	MSFT	Stock	253.83	255.88	253.7	255.71	14584.0
2022-05-23 07:00:00	MSFT	Stock	255.45	255.94	254.61	255.5	25820.0
2022-05-23 08:00:00	MSFT	Stock	255.7497	256.25	254.55	255.0023	85300.0
2022-05-23 09:00:00	MSFT	Stock	255.2	258.08	253.43	256.715	3167256.0
2022-05-23 10:00:00	MSFT	Stock	256.715	258.84	255.0601	257.56	4057791.0
2022-05-23 11:00:00	MSFT	Stock	257.58	260.35	257.14	260.08	2936290.0
2022-05-23 12:00:00	MSFT	Stock	260.11	261.5	259.75	260.04	2358203.0
2022-05-23 13:00:00	MSFT	Stock	260.05	260.3799	259.15	260.07	1676690.0
2022-05-23 14:00:00	MSFT	Stock	260.08	260.94	259.5	259.68	1825588.0
2022-05-23 15:00:00	MSFT	Stock	259.7	260.76	258.85	260.65	3758096.0
2022-05-23 16:00:00	MSFT	Stock	260.65	261.18	260.15	260.82	4632076.0
2022-05-23 17:00:00	MSFT	Stock	260.72	260.73	258.1	258.3	53025.0
2022-05-23 18:00:00	MSFT	Stock	258.86	259.0	257.42	258.37	26049.0
2022-05-23 19:00:00	MSFT	Stock	258.34	259.25	258.01	259.0	24714.0
2022-05-23 04:00:00	NVDA	Stock	16.956	17.08	16.55	16.759	397970.0
2022-05-23 05:00:00	NVDA	Stock	16.761	16.848	16.75	16.75	237770.0
2022-05-23 06:00:00	NVDA	Stock	16.78	16.898	16.78	16.88	96240.0
2022-05-23 07:00:00	NVDA	Stock	16.86	16.875	16.538	16.604	783490.0
2022-05-23 08:00:00	NVDA	Stock	16.8436	16.87	16.25	16.365	3540120.0
2022-05-23 09:00:00	NVDA	Stock	16.37	16.828	16.179	16.45	82642330.0
2022-05-23 10:00:00	NVDA	Stock	16.462	16.631	16.258	16.431	94068510.0
2022-05-23 11:00:00	NVDA	Stock	16.4345	16.82	16.385	16.71	77328300.0
2022-05-23 12:00:00	NVDA	Stock	16.71	16.9057	16.618	16.688	77571600.0
2022-05-23 13:00:00	NVDA	Stock	16.689	16.775	16.535	16.7415	45171200.0
2022-05-23 14:00:00	NVDA	Stock	16.746	16.91	16.683	16.802	57969680.0
2022-05-23 15:00:00	NVDA	Stock	16.807	16.915	16.686	16.898	62014820.0
2022-05-23 16:00:00	NVDA	Stock	16.862	16.995	16.862	16.98	19432440.0
2022-05-23 17:00:00	NVDA	Stock	16.98	16.989	16.66	16.686	1417890.0
2022-05-23 18:00:00	NVDA	Stock	16.662	16.725	16.617	16.7	504840.0
2022-05-23 19:00:00	NVDA	Stock	16.7	16.749	16.665	16.68	281870.0
2022-05-23 04:00:00	AMZN	Stock	109.0	109.0	108.5	108.5	9480.0
2022-05-23 06:00:00	AMZN	Stock	108.3755	108.595	108.3755	108.595	4000.0

> showing 50 of 63,086 rows — these rows as CSV

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