PREVIEW / stock_1hour / 2022-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-20.parquet
  size:    1.4 MB
  rows:    61,229
  symbols: 2,002

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-20 04:00:00	AAPL	Stock	132.24	132.48	131.75	131.92	30778.0
2022-12-20 05:00:00	AAPL	Stock	132.02	132.19	131.95	132.09	11726.0
2022-12-20 06:00:00	AAPL	Stock	132.14	132.45	132.12	132.28	9825.0
2022-12-20 07:00:00	AAPL	Stock	132.28	132.4	131.65	131.66	63369.0
2022-12-20 08:00:00	AAPL	Stock	132.35	132.7	130.6	131.84	199539.0
2022-12-20 09:00:00	AAPL	Stock	131.84	131.86	129.89	131.32	12471067.0
2022-12-20 10:00:00	AAPL	Stock	131.335	133.25	131.19	132.28	12784563.0
2022-12-20 11:00:00	AAPL	Stock	132.26	132.48	130.845	132.0942	8848021.0
2022-12-20 12:00:00	AAPL	Stock	132.1	132.72	132.0101	132.515	6106192.0
2022-12-20 13:00:00	AAPL	Stock	132.52	132.76	131.77	131.91	5664762.0
2022-12-20 14:00:00	AAPL	Stock	131.91	132.13	131.63	131.83	5440129.0
2022-12-20 15:00:00	AAPL	Stock	131.835	132.44	131.52	132.29	8618697.0
2022-12-20 16:00:00	AAPL	Stock	132.29	132.57	132.24	132.54	7308778.0
2022-12-20 17:00:00	AAPL	Stock	132.55	132.79	132.55	132.79	46268.0
2022-12-20 18:00:00	AAPL	Stock	132.8	133.25	132.77	133.0	113969.0
2022-12-20 19:00:00	AAPL	Stock	133.02	133.06	132.84	133.0	36897.0
2022-12-20 04:00:00	MSFT	Stock	240.45	240.45	239.17	239.51	11129.0
2022-12-20 05:00:00	MSFT	Stock	239.68	239.7	239.48	239.49	500.0
2022-12-20 06:00:00	MSFT	Stock	239.74	240.08	239.74	239.75	1029.0
2022-12-20 07:00:00	MSFT	Stock	239.93	240.02	238.78	238.78	14293.0
2022-12-20 08:00:00	MSFT	Stock	239.3012	240.02	237.4	239.03	20419.0
2022-12-20 09:00:00	MSFT	Stock	239.0	240.85	238.42	240.6202	2358288.0
2022-12-20 10:00:00	MSFT	Stock	240.655	242.5	239.97	241.15	2601354.0
2022-12-20 11:00:00	MSFT	Stock	241.17	241.75	239.28	241.185	2245694.0
2022-12-20 12:00:00	MSFT	Stock	241.22	242.2125	240.9273	241.93	1593957.0
2022-12-20 13:00:00	MSFT	Stock	241.94	242.91	241.15	242.09	1337967.0
2022-12-20 14:00:00	MSFT	Stock	242.11	242.81	241.47	241.67	1298494.0
2022-12-20 15:00:00	MSFT	Stock	241.68	242.68	241.34	241.85	2512668.0
2022-12-20 16:00:00	MSFT	Stock	241.85	242.38	241.52	242.08	3968901.0
2022-12-20 17:00:00	MSFT	Stock	242.14	242.35	242.0	242.0126	4261.0
2022-12-20 18:00:00	MSFT	Stock	242.34	242.92	242.25	242.51	22000.0
2022-12-20 19:00:00	MSFT	Stock	242.6	242.85	242.11	242.75	9192.0
2022-12-20 04:00:00	NVDA	Stock	16.178	16.2	16.159	16.18	94720.0
2022-12-20 05:00:00	NVDA	Stock	16.177	16.247	16.146	16.191	67210.0
2022-12-20 06:00:00	NVDA	Stock	16.19	16.239	16.182	16.185	10350.0
2022-12-20 07:00:00	NVDA	Stock	16.21	16.229	16.139	16.141	107110.0
2022-12-20 08:00:00	NVDA	Stock	16.185	16.239	15.808	16.121	620540.0
2022-12-20 09:00:00	NVDA	Stock	16.118	16.2896	15.852	16.267	55324260.0
2022-12-20 10:00:00	NVDA	Stock	16.271	16.31	16.094	16.2095	64070710.0
2022-12-20 11:00:00	NVDA	Stock	16.208	16.27	15.97	16.1295	43453930.0
2022-12-20 12:00:00	NVDA	Stock	16.131	16.197	15.994	16.1034	33175100.0
2022-12-20 13:00:00	NVDA	Stock	16.104	16.158	15.978	16.113	31369710.0
2022-12-20 14:00:00	NVDA	Stock	16.114	16.207	16.096	16.136	32422510.0
2022-12-20 15:00:00	NVDA	Stock	16.1395	16.175	16.074	16.086	36037560.0
2022-12-20 16:00:00	NVDA	Stock	16.085	16.098	16.075	16.092	21086150.0
2022-12-20 17:00:00	NVDA	Stock	16.095	16.134	16.085	16.134	130140.0
2022-12-20 18:00:00	NVDA	Stock	16.134	16.173	16.1339	16.14	226610.0
2022-12-20 19:00:00	NVDA	Stock	16.16	16.173	16.12	16.12	407290.0
2022-12-20 04:00:00	AMZN	Stock	84.88	84.98	84.51	84.89	34935.0
2022-12-20 05:00:00	AMZN	Stock	84.95	85.15	84.6	84.64	34209.0

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

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