PREVIEW / stock_1hour / 2022-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-01.parquet
  size:    1.4 MB
  rows:    61,587
  symbols: 2,075

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-12-01 04:00:00	AAPL	Stock	148.08	148.08	147.04	147.26	41575.0
2022-12-01 05:00:00	AAPL	Stock	147.31	147.56	147.2	147.38	20017.0
2022-12-01 06:00:00	AAPL	Stock	147.3	147.41	147.2	147.41	11490.0
2022-12-01 07:00:00	AAPL	Stock	147.35	147.98	147.33	147.96	128344.0
2022-12-01 08:00:00	AAPL	Stock	147.36	149.14	147.1785	148.22	563910.0
2022-12-01 09:00:00	AAPL	Stock	148.22	149.13	147.41	148.27	8108646.0
2022-12-01 10:00:00	AAPL	Stock	148.3	148.62	146.61	148.211	10223307.0
2022-12-01 11:00:00	AAPL	Stock	148.23	148.26	147.43	147.6599	6386932.0
2022-12-01 12:00:00	AAPL	Stock	147.65	148.0085	147.1	147.92	5308037.0
2022-12-01 13:00:00	AAPL	Stock	147.915	148.4499	147.56	148.2043	5138136.0
2022-12-01 14:00:00	AAPL	Stock	148.2	148.85	147.96	148.8357	4927014.0
2022-12-01 15:00:00	AAPL	Stock	148.84	149.0	148.28	148.33	8433200.0
2022-12-01 16:00:00	AAPL	Stock	148.36	148.36	148.13	148.2	9582728.0
2022-12-01 17:00:00	AAPL	Stock	148.19	148.25	148.06	148.15	27701.0
2022-12-01 18:00:00	AAPL	Stock	148.15	148.15	147.96	148.02	26728.0
2022-12-01 19:00:00	AAPL	Stock	147.96	148.1	147.8	147.86	37476.0
2022-12-01 04:00:00	MSFT	Stock	254.3	254.3	253.56	253.7	8660.0
2022-12-01 05:00:00	MSFT	Stock	253.73	253.8	253.55	253.55	4020.0
2022-12-01 06:00:00	MSFT	Stock	253.4	253.6	253.13	253.55	8170.0
2022-12-01 07:00:00	MSFT	Stock	253.8	254.15	253.2	253.85	17402.0
2022-12-01 08:00:00	MSFT	Stock	253.7128	255.79	253.35	254.3	77212.0
2022-12-01 09:00:00	MSFT	Stock	254.31	256.12	253.13	254.785	2570942.0
2022-12-01 10:00:00	MSFT	Stock	254.84	255.68	250.9156	253.99	2890361.0
2022-12-01 11:00:00	MSFT	Stock	253.99	254.09	252.6	253.18	1931705.0
2022-12-01 12:00:00	MSFT	Stock	253.19	254.39	252.33	254.31	1418358.0
2022-12-01 13:00:00	MSFT	Stock	254.32	255.08	253.63	254.4471	1539623.0
2022-12-01 14:00:00	MSFT	Stock	254.4326	255.95	254.08	255.8202	1459455.0
2022-12-01 15:00:00	MSFT	Stock	255.8261	256.11	254.62	254.71	2993014.0
2022-12-01 16:00:00	MSFT	Stock	254.71	254.9	254.23	254.3122	4190989.0
2022-12-01 17:00:00	MSFT	Stock	254.3001	254.68	254.3	254.3	2563.0
2022-12-01 18:00:00	MSFT	Stock	254.27	254.39	254.27	254.34	2736.0
2022-12-01 19:00:00	MSFT	Stock	254.21	254.21	253.7	253.76	8347.0
2022-12-01 04:00:00	NVDA	Stock	17.041	17.041	16.77	16.8	252940.0
2022-12-01 05:00:00	NVDA	Stock	16.807	16.848	16.807	16.825	59300.0
2022-12-01 06:00:00	NVDA	Stock	16.812	16.87	16.812	16.87	49500.0
2022-12-01 07:00:00	NVDA	Stock	16.878	17.038	16.87	17.0	513060.0
2022-12-01 08:00:00	NVDA	Stock	16.875	17.163	16.856	17.035	2267330.0
2022-12-01 09:00:00	NVDA	Stock	17.038	17.217	16.8409	17.1624	56717890.0
2022-12-01 10:00:00	NVDA	Stock	17.164	17.206	16.635	17.072	71467420.0
2022-12-01 11:00:00	NVDA	Stock	17.074	17.1	16.9156	17.057	44622670.0
2022-12-01 12:00:00	NVDA	Stock	17.06	17.156	16.9482	17.107	36358920.0
2022-12-01 13:00:00	NVDA	Stock	17.11	17.2335	17.088	17.198	40679840.0
2022-12-01 14:00:00	NVDA	Stock	17.198	17.231	17.106	17.217	33664120.0
2022-12-01 15:00:00	NVDA	Stock	17.216	17.265	17.127	17.133	53865300.0
2022-12-01 16:00:00	NVDA	Stock	17.135	17.15	16.929	16.93	32700030.0
2022-12-01 17:00:00	NVDA	Stock	16.9601	17.077	16.9601	17.035	174010.0
2022-12-01 18:00:00	NVDA	Stock	17.03	17.064	17.018	17.036	88680.0
2022-12-01 19:00:00	NVDA	Stock	17.033	17.045	16.944	16.944	359670.0
2022-12-01 04:00:00	AMZN	Stock	96.54	96.68	96.14	96.29	30122.0
2022-12-01 05:00:00	AMZN	Stock	96.3	96.38	96.16	96.16	18788.0

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

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