PREVIEW / stock_1hour / 2022-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-09.parquet
  size:    1.4 MB
  rows:    61,297
  symbols: 2,091

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-11-09 04:00:00	AAPL	Stock	140.05	140.05	138.4	138.4	36206.0
2022-11-09 05:00:00	AAPL	Stock	138.63	139.1	138.42	139.07	17220.0
2022-11-09 06:00:00	AAPL	Stock	139.07	139.42	139.0	139.0	15557.0
2022-11-09 07:00:00	AAPL	Stock	139.19	139.5	138.65	139.4	49851.0
2022-11-09 08:00:00	AAPL	Stock	139.1821	140.0	138.3106	138.5315	199254.0
2022-11-09 09:00:00	AAPL	Stock	138.56	139.07	136.98	137.27	7221538.0
2022-11-09 10:00:00	AAPL	Stock	137.27	137.98	136.145	136.515	9055898.0
2022-11-09 11:00:00	AAPL	Stock	136.52	137.41	136.4101	136.61	6247062.0
2022-11-09 12:00:00	AAPL	Stock	136.61	136.7102	136.13	136.35	4670283.0
2022-11-09 13:00:00	AAPL	Stock	136.36	136.57	135.0	135.22	7148410.0
2022-11-09 14:00:00	AAPL	Stock	135.23	135.54	134.7	134.77	7439648.0
2022-11-09 15:00:00	AAPL	Stock	134.77	135.4799	134.5933	134.87	12107945.0
2022-11-09 16:00:00	AAPL	Stock	134.89	135.17	134.74	134.88	10538452.0
2022-11-09 17:00:00	AAPL	Stock	134.91	134.94	134.73	134.8058	49963.0
2022-11-09 18:00:00	AAPL	Stock	134.86	135.18	134.86	135.05	34411.0
2022-11-09 19:00:00	AAPL	Stock	135.04	135.5	134.95	135.27	74802.0
2022-11-09 04:00:00	MSFT	Stock	228.72	228.92	228.0	228.0	560.0
2022-11-09 05:00:00	MSFT	Stock	227.4	228.19	227.19	228.19	1317.0
2022-11-09 06:00:00	MSFT	Stock	228.41	228.41	228.41	228.41	150.0
2022-11-09 07:00:00	MSFT	Stock	228.24	228.35	227.63	228.1	4434.0
2022-11-09 08:00:00	MSFT	Stock	228.6028	229.0	226.65	227.24	28398.0
2022-11-09 09:00:00	MSFT	Stock	228.87	228.87	226.51	227.18	3514184.0
2022-11-09 10:00:00	MSFT	Stock	227.23	228.6327	225.3	225.86	2346600.0
2022-11-09 11:00:00	MSFT	Stock	225.9	228.28	225.9	227.19	1493993.0
2022-11-09 12:00:00	MSFT	Stock	227.18	227.68	226.44	226.6	1248820.0
2022-11-09 13:00:00	MSFT	Stock	226.6	226.98	224.7861	225.22	1487340.0
2022-11-09 14:00:00	MSFT	Stock	225.23	226.1499	224.33	224.46	1741384.0
2022-11-09 15:00:00	MSFT	Stock	224.45	225.6	224.34	224.52	3667954.0
2022-11-09 16:00:00	MSFT	Stock	224.51	225.42	224.51	224.87	4821837.0
2022-11-09 17:00:00	MSFT	Stock	224.86	225.12	224.65	224.75	5024.0
2022-11-09 18:00:00	MSFT	Stock	224.98	225.1	224.59	224.93	5339.0
2022-11-09 19:00:00	MSFT	Stock	224.77	225.2	224.68	225.02	31448.0
2022-11-09 04:00:00	NVDA	Stock	14.301	14.601	14.301	14.441	121290.0
2022-11-09 05:00:00	NVDA	Stock	14.433	14.497	14.41	14.497	66500.0
2022-11-09 06:00:00	NVDA	Stock	14.487	14.539	14.343	14.36	177350.0
2022-11-09 07:00:00	NVDA	Stock	14.389	14.425	14.29	14.38	566410.0
2022-11-09 08:00:00	NVDA	Stock	14.375	14.611	14.11	14.14	2594620.0
2022-11-09 09:00:00	NVDA	Stock	14.131	14.211	13.883	14.041	69566540.0
2022-11-09 10:00:00	NVDA	Stock	14.039	14.1179	13.819	13.9237	70515650.0
2022-11-09 11:00:00	NVDA	Stock	13.925	14.022	13.892	13.946	42714010.0
2022-11-09 12:00:00	NVDA	Stock	13.9475	13.989	13.846	13.9695	38582310.0
2022-11-09 13:00:00	NVDA	Stock	13.971	14.0152	13.7641	13.816	43060780.0
2022-11-09 14:00:00	NVDA	Stock	13.817	13.909	13.776	13.803	31346070.0
2022-11-09 15:00:00	NVDA	Stock	13.805	13.881	13.759	13.783	51055080.0
2022-11-09 16:00:00	NVDA	Stock	13.782	13.795	13.736	13.7518	30211460.0
2022-11-09 17:00:00	NVDA	Stock	13.75	13.776	13.74	13.7404	65240.0
2022-11-09 18:00:00	NVDA	Stock	13.754	13.758	13.717	13.718	160310.0
2022-11-09 19:00:00	NVDA	Stock	13.715	13.745	13.707	13.72	220960.0
2022-11-09 04:00:00	AMZN	Stock	90.53	90.53	89.66	89.66	11503.0
2022-11-09 05:00:00	AMZN	Stock	89.7	89.97	89.2	89.96	23124.0

> showing 50 of 61,297 rows — these rows as CSV

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