PREVIEW / stock_1hour / 2022-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-04.parquet
  size:    1.4 MB
  rows:    63,774
  symbols: 2,269

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-10-04 04:00:00	AAPL	Stock	144.02	145.27	144.02	144.96	35273.0
2022-10-04 05:00:00	AAPL	Stock	144.91	145.19	144.66	145.15	56694.0
2022-10-04 06:00:00	AAPL	Stock	145.07	145.56	145.04	145.07	28857.0
2022-10-04 07:00:00	AAPL	Stock	145.07	145.18	144.86	145.18	125506.0
2022-10-04 08:00:00	AAPL	Stock	145.0	145.48	144.55	145.18	431322.0
2022-10-04 09:00:00	AAPL	Stock	145.15	145.34	144.5	145.085	11619094.0
2022-10-04 10:00:00	AAPL	Stock	145.085	146.22	145.045	145.75	13316112.0
2022-10-04 11:00:00	AAPL	Stock	145.755	145.79	144.96	145.2802	8384929.0
2022-10-04 12:00:00	AAPL	Stock	145.285	145.67	144.85	144.86	5743245.0
2022-10-04 13:00:00	AAPL	Stock	144.86	145.53	144.26	145.25	7025737.0
2022-10-04 14:00:00	AAPL	Stock	145.25	146.09	145.04	145.8639	5874012.0
2022-10-04 15:00:00	AAPL	Stock	145.86	146.22	145.11	146.16	11874759.0
2022-10-04 16:00:00	AAPL	Stock	146.17	146.22	145.85	145.98	10393646.0
2022-10-04 17:00:00	AAPL	Stock	145.97	146.09	145.71	145.99	47293.0
2022-10-04 18:00:00	AAPL	Stock	145.96	146.01	145.63	145.81	42414.0
2022-10-04 19:00:00	AAPL	Stock	145.8	146.08	145.69	146.0	60586.0
2022-10-04 04:00:00	MSFT	Stock	244.31	244.99	243.01	244.4	7946.0
2022-10-04 05:00:00	MSFT	Stock	244.79	245.25	244.41	245.25	7943.0
2022-10-04 06:00:00	MSFT	Stock	245.15	246.23	244.89	245.96	14999.0
2022-10-04 07:00:00	MSFT	Stock	245.9	245.97	245.5	245.6	30863.0
2022-10-04 08:00:00	MSFT	Stock	245.45	246.0	240.139	244.85	86475.0
2022-10-04 09:00:00	MSFT	Stock	244.85	249.24	244.41	249.155	4107045.0
2022-10-04 10:00:00	MSFT	Stock	249.155	250.36	248.62	249.589	4813853.0
2022-10-04 11:00:00	MSFT	Stock	249.57	249.92	248.23	248.53	2800304.0
2022-10-04 12:00:00	MSFT	Stock	248.54	249.2	247.7403	248.05	1930439.0
2022-10-04 13:00:00	MSFT	Stock	248.035	248.31	246.63	248.09	1677861.0
2022-10-04 14:00:00	MSFT	Stock	248.1	249.11	247.43	248.8581	1692209.0
2022-10-04 15:00:00	MSFT	Stock	248.85	249.01	247.53	248.89	3380199.0
2022-10-04 16:00:00	MSFT	Stock	248.88	249.4	248.65	248.98	5345106.0
2022-10-04 17:00:00	MSFT	Stock	248.9	249.02	248.8	249.0	9973.0
2022-10-04 18:00:00	MSFT	Stock	248.8	249.02	248.52	248.54	18463.0
2022-10-04 19:00:00	MSFT	Stock	248.43	248.55	248.11	248.25	8585.0
2022-10-04 04:00:00	NVDA	Stock	12.711	12.859	12.69	12.834	254190.0
2022-10-04 05:00:00	NVDA	Stock	12.847	12.875	12.801	12.857	133700.0
2022-10-04 06:00:00	NVDA	Stock	12.852	12.931	12.852	12.888	151660.0
2022-10-04 07:00:00	NVDA	Stock	12.872	12.891	12.86	12.886	688010.0
2022-10-04 08:00:00	NVDA	Stock	12.8558	12.897	12.4808	12.857	3857500.0
2022-10-04 09:00:00	NVDA	Stock	12.86	13.02	12.809	12.937	71299790.0
2022-10-04 10:00:00	NVDA	Stock	12.937	13.2133	12.937	13.212	82784010.0
2022-10-04 11:00:00	NVDA	Stock	13.211	13.22	13.113	13.207	66807750.0
2022-10-04 12:00:00	NVDA	Stock	13.208	13.209	13.023	13.0355	51084530.0
2022-10-04 13:00:00	NVDA	Stock	13.0359	13.085	12.9182	13.06	53502920.0
2022-10-04 14:00:00	NVDA	Stock	13.062	13.156	13.016	13.1555	46540920.0
2022-10-04 15:00:00	NVDA	Stock	13.155	13.188	13.0725	13.171	76927910.0
2022-10-04 16:00:00	NVDA	Stock	13.167	13.188	13.154	13.188	29369420.0
2022-10-04 17:00:00	NVDA	Stock	13.188	13.195	13.175	13.18	561760.0
2022-10-04 18:00:00	NVDA	Stock	13.177	13.2	13.113	13.125	668400.0
2022-10-04 19:00:00	NVDA	Stock	13.135	13.185	13.13	13.185	361970.0
2022-10-04 04:00:00	AMZN	Stock	117.74	118.5	117.7	118.2	31499.0
2022-10-04 05:00:00	AMZN	Stock	118.27	118.5	117.89	118.5	14792.0

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

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