PREVIEW / stock_1hour / 2021-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-26.parquet
  size:    1.5 MB
  rows:    66,821
  symbols: 2,730

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
2021-10-26 04:00:00	AAPL	Stock	148.87	149.48	148.65	149.15	38985.0
2021-10-26 05:00:00	AAPL	Stock	149.13	149.15	148.82	149.08	25447.0
2021-10-26 06:00:00	AAPL	Stock	149.12	149.12	148.81	148.83	21566.0
2021-10-26 07:00:00	AAPL	Stock	148.85	149.11	148.84	149.08	77658.0
2021-10-26 08:00:00	AAPL	Stock	148.889	149.15	148.269	149.08	199596.0
2021-10-26 09:00:00	AAPL	Stock	149.09	150.84	149.06	149.63	9768033.0
2021-10-26 10:00:00	AAPL	Stock	149.63	149.89	149.0101	149.38	8148687.0
2021-10-26 11:00:00	AAPL	Stock	149.39	150.0499	149.38	149.605	7499586.0
2021-10-26 12:00:00	AAPL	Stock	149.61	149.859	149.2	149.4604	5872791.0
2021-10-26 13:00:00	AAPL	Stock	149.46	149.9	149.29	149.615	4366591.0
2021-10-26 14:00:00	AAPL	Stock	149.615	149.71	149.11	149.36	4098407.0
2021-10-26 15:00:00	AAPL	Stock	149.3699	149.835	149.25	149.26	7055029.0
2021-10-26 16:00:00	AAPL	Stock	149.32	149.56	149.2	149.31	7019309.0
2021-10-26 17:00:00	AAPL	Stock	149.3	149.51	149.21	149.33	66955.0
2021-10-26 18:00:00	AAPL	Stock	149.33	149.48	149.3	149.38	33743.0
2021-10-26 19:00:00	AAPL	Stock	149.4	149.5	149.34	149.34	49099.0
2021-10-26 04:00:00	MSFT	Stock	309.6	309.69	309.59	309.66	1640.0
2021-10-26 05:00:00	MSFT	Stock	309.58	309.9	309.02	309.9	2520.0
2021-10-26 06:00:00	MSFT	Stock	310.08	310.2	309.8	309.85	6216.0
2021-10-26 07:00:00	MSFT	Stock	309.97	310.3	309.85	309.85	22061.0
2021-10-26 08:00:00	MSFT	Stock	310.1	310.36	309.35	309.79	51928.0
2021-10-26 09:00:00	MSFT	Stock	309.79	311.2	308.5967	308.885	2502477.0
2021-10-26 10:00:00	MSFT	Stock	308.885	310.62	308.735	310.46	2113790.0
2021-10-26 11:00:00	MSFT	Stock	310.47	312.395	310.372	310.965	2411862.0
2021-10-26 12:00:00	MSFT	Stock	310.9525	311.06	309.6941	310.35	1784768.0
2021-10-26 13:00:00	MSFT	Stock	310.34	310.92	309.41	310.27	1795888.0
2021-10-26 14:00:00	MSFT	Stock	310.27	310.56	309.38	309.64	1327025.0
2021-10-26 15:00:00	MSFT	Stock	309.63	310.77	309.43	309.71	3375117.0
2021-10-26 16:00:00	MSFT	Stock	310.11	316.5	307.73	310.71	5056296.0
2021-10-26 17:00:00	MSFT	Stock	310.67	311.42	309.5	310.02	393831.0
2021-10-26 18:00:00	MSFT	Stock	310.01	316.35	310.01	315.25	485550.0
2021-10-26 19:00:00	MSFT	Stock	315.3	316.7	315.1	316.3	95807.0
2021-10-26 04:00:00	NVDA	Stock	23.642	23.818	23.642	23.793	92580.0
2021-10-26 05:00:00	NVDA	Stock	23.781	23.825	23.781	23.816	55190.0
2021-10-26 06:00:00	NVDA	Stock	23.8	23.8	23.707	23.755	129590.0
2021-10-26 07:00:00	NVDA	Stock	23.759	23.882	23.759	23.882	483530.0
2021-10-26 08:00:00	NVDA	Stock	23.78	23.989	23.76	23.869	1652390.0
2021-10-26 09:00:00	NVDA	Stock	23.876	24.688	23.876	24.629	65982200.0
2021-10-26 10:00:00	NVDA	Stock	24.624	25.259	24.574	24.97	98032120.0
2021-10-26 11:00:00	NVDA	Stock	24.9691	24.996	24.6445	24.669	52570220.0
2021-10-26 12:00:00	NVDA	Stock	24.666	24.8658	24.405	24.666	43875060.0
2021-10-26 13:00:00	NVDA	Stock	24.664	24.904	24.607	24.8888	32753030.0
2021-10-26 14:00:00	NVDA	Stock	24.894	24.949	24.67	24.729	25404300.0
2021-10-26 15:00:00	NVDA	Stock	24.727	24.87	24.638	24.717	42263620.0
2021-10-26 16:00:00	NVDA	Stock	24.717	24.788	24.545	24.575	16360110.0
2021-10-26 17:00:00	NVDA	Stock	24.565	24.7349	24.55	24.576	185210.0
2021-10-26 18:00:00	NVDA	Stock	24.578	24.671	24.566	24.63	193790.0
2021-10-26 19:00:00	NVDA	Stock	24.604	24.628	24.5	24.5	264030.0
2021-10-26 04:00:00	AMZN	Stock	167.73	167.8655	167.73	167.8655	12000.0
2021-10-26 05:00:00	AMZN	Stock	167.85	170.0	167.85	169.2835	57920.0

> showing 50 of 66,821 rows — these rows as CSV

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