PREVIEW / stock_1hour / 2022-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-10.parquet
  size:    1.4 MB
  rows:    63,671
  symbols: 2,160

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-10 04:00:00	AAPL	Stock	134.87	135.8	134.87	135.52	32400.0
2022-11-10 05:00:00	AAPL	Stock	135.6	135.98	135.38	135.98	25760.0
2022-11-10 06:00:00	AAPL	Stock	135.83	136.19	135.62	136.0	18802.0
2022-11-10 07:00:00	AAPL	Stock	136.0	136.05	135.55	135.74	53237.0
2022-11-10 08:00:00	AAPL	Stock	135.9216	140.42	135.08	140.13	1879260.0
2022-11-10 09:00:00	AAPL	Stock	140.1299	143.37	139.64	143.29	15548951.0
2022-11-10 10:00:00	AAPL	Stock	143.3	143.7	142.17	143.21	14023185.0
2022-11-10 11:00:00	AAPL	Stock	143.21	143.43	142.15	143.1175	8033701.0
2022-11-10 12:00:00	AAPL	Stock	143.12	143.65	142.7201	142.86	6933868.0
2022-11-10 13:00:00	AAPL	Stock	142.85	144.06	142.85	143.8685	7167078.0
2022-11-10 14:00:00	AAPL	Stock	143.865	144.6102	143.83	144.54	6758314.0
2022-11-10 15:00:00	AAPL	Stock	144.535	146.87	144.4199	146.8	22578823.0
2022-11-10 16:00:00	AAPL	Stock	146.78	147.29	146.66	147.29	21762561.0
2022-11-10 17:00:00	AAPL	Stock	147.29	147.59	147.0	147.15	225833.0
2022-11-10 18:00:00	AAPL	Stock	147.1	147.35	146.91	147.3	134679.0
2022-11-10 19:00:00	AAPL	Stock	147.3	147.3	146.8	147.2	83640.0
2022-11-10 04:00:00	MSFT	Stock	224.67	224.77	224.4	224.74	1108.0
2022-11-10 05:00:00	MSFT	Stock	224.43	225.0	224.02	225.0	2549.0
2022-11-10 06:00:00	MSFT	Stock	224.72	225.65	224.71	225.65	1315.0
2022-11-10 07:00:00	MSFT	Stock	225.7	225.79	224.83	225.32	16942.0
2022-11-10 08:00:00	MSFT	Stock	224.8267	234.5	224.82	234.3	349350.0
2022-11-10 09:00:00	MSFT	Stock	234.1	240.0	233.21	239.875	5500803.0
2022-11-10 10:00:00	MSFT	Stock	239.885	240.29	237.32	238.73	4414779.0
2022-11-10 11:00:00	MSFT	Stock	238.736	239.99	237.54	239.96	2911280.0
2022-11-10 12:00:00	MSFT	Stock	239.96	240.75	238.9168	239.03	2582694.0
2022-11-10 13:00:00	MSFT	Stock	239.04	240.13	238.66	239.5869	1944885.0
2022-11-10 14:00:00	MSFT	Stock	239.61	239.88	238.74	239.67	1681308.0
2022-11-10 15:00:00	MSFT	Stock	239.64	243.33	239.17	242.93	7212232.0
2022-11-10 16:00:00	MSFT	Stock	242.92	243.9539	242.76	243.78	9719217.0
2022-11-10 17:00:00	MSFT	Stock	243.85	243.98	243.61	243.7	8799.0
2022-11-10 18:00:00	MSFT	Stock	243.61	244.0	243.3	244.0	13493.0
2022-11-10 19:00:00	MSFT	Stock	243.92	243.92	243.24	243.7	12043.0
2022-11-10 04:00:00	NVDA	Stock	13.783	13.8	13.73	13.766	89360.0
2022-11-10 05:00:00	NVDA	Stock	13.752	13.757	13.63	13.67	204830.0
2022-11-10 06:00:00	NVDA	Stock	13.68	13.691	13.644	13.644	179410.0
2022-11-10 07:00:00	NVDA	Stock	13.649	13.667	13.519	13.54	650210.0
2022-11-10 08:00:00	NVDA	Stock	13.6504	14.677	13.5065	14.554	8261270.0
2022-11-10 09:00:00	NVDA	Stock	14.545	14.995	14.522	14.9765	95148500.0
2022-11-10 10:00:00	NVDA	Stock	14.9785	15.032	14.837	15.02	88185590.0
2022-11-10 11:00:00	NVDA	Stock	15.0197	15.31	14.988	15.2931	66194980.0
2022-11-10 12:00:00	NVDA	Stock	15.293	15.314	15.18	15.243	61254880.0
2022-11-10 13:00:00	NVDA	Stock	15.245	15.513	15.234	15.4849	53479080.0
2022-11-10 14:00:00	NVDA	Stock	15.4845	15.548	15.438	15.526	49965440.0
2022-11-10 15:00:00	NVDA	Stock	15.5231	15.773	15.472	15.75	103259770.0
2022-11-10 16:00:00	NVDA	Stock	15.747	15.85	15.73	15.84	59792210.0
2022-11-10 17:00:00	NVDA	Stock	15.85	15.879	15.8372	15.85	957680.0
2022-11-10 18:00:00	NVDA	Stock	15.85	15.862	15.802	15.809	772960.0
2022-11-10 19:00:00	NVDA	Stock	15.83	15.859	15.811	15.859	628790.0
2022-11-10 04:00:00	AMZN	Stock	86.93	86.93	86.37	86.51	67120.0
2022-11-10 05:00:00	AMZN	Stock	86.44	86.65	86.36	86.51	29712.0

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

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