PREVIEW / stock_1hour / 2023-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-05.parquet
  size:    1.3 MB
  rows:    60,847
  symbols: 1,962

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
2023-01-05 04:00:00	AAPL	Stock	127.0	127.0	125.95	126.4	113877.0
2023-01-05 05:00:00	AAPL	Stock	126.4	126.9	125.79	125.92	89581.0
2023-01-05 06:00:00	AAPL	Stock	125.96	127.09	125.96	126.99	86114.0
2023-01-05 07:00:00	AAPL	Stock	126.93	127.88	126.87	127.6	126444.0
2023-01-05 08:00:00	AAPL	Stock	127.05	127.87	126.25	126.92	583664.0
2023-01-05 09:00:00	AAPL	Stock	126.9115	127.4891	125.32	127.38	10866006.0
2023-01-05 10:00:00	AAPL	Stock	127.3699	127.77	126.16	126.42	11402240.0
2023-01-05 11:00:00	AAPL	Stock	126.42	127.08	126.15	126.68	7593939.0
2023-01-05 12:00:00	AAPL	Stock	126.68	126.955	126.18	126.2474	4665942.0
2023-01-05 13:00:00	AAPL	Stock	126.245	127.04	125.8001	126.27	6956730.0
2023-01-05 14:00:00	AAPL	Stock	126.28	126.47	125.475	125.48	6582539.0
2023-01-05 15:00:00	AAPL	Stock	125.485	125.53	124.76	125.03	12551691.0
2023-01-05 16:00:00	AAPL	Stock	125.02	125.34	124.99	125.16	7969958.0
2023-01-05 17:00:00	AAPL	Stock	125.15	125.15	125.05	125.1	62375.0
2023-01-05 18:00:00	AAPL	Stock	125.13	125.23	124.8	125.17	71977.0
2023-01-05 19:00:00	AAPL	Stock	125.17	125.25	125.12	125.25	34676.0
2023-01-05 04:00:00	MSFT	Stock	227.8	228.34	227.65	228.34	8676.0
2023-01-05 05:00:00	MSFT	Stock	228.33	229.2	228.19	229.1	13989.0
2023-01-05 06:00:00	MSFT	Stock	229.3	229.88	229.15	229.88	25003.0
2023-01-05 07:00:00	MSFT	Stock	229.57	229.89	228.81	229.1	22737.0
2023-01-05 08:00:00	MSFT	Stock	229.53	229.8	226.67	227.3	89597.0
2023-01-05 09:00:00	MSFT	Stock	227.2	227.95	223.67	225.11	4351378.0
2023-01-05 10:00:00	MSFT	Stock	225.12	226.22	223.84	224.2	4237897.0
2023-01-05 11:00:00	MSFT	Stock	224.19	224.78	223.08	223.105	3174598.0
2023-01-05 12:00:00	MSFT	Stock	223.11	223.67	222.24	222.24	3051830.0
2023-01-05 13:00:00	MSFT	Stock	222.26	223.74	221.7602	223.57	4149856.0
2023-01-05 14:00:00	MSFT	Stock	223.58	224.68	223.03	224.28	3199931.0
2023-01-05 15:00:00	MSFT	Stock	224.29	224.295	221.84	222.2501	4637630.0
2023-01-05 16:00:00	MSFT	Stock	222.28	223.2952	222.02	222.29	4658259.0
2023-01-05 17:00:00	MSFT	Stock	222.3	222.3	222.1	222.3	18071.0
2023-01-05 18:00:00	MSFT	Stock	222.34	222.46	222.22	222.46	7110.0
2023-01-05 19:00:00	MSFT	Stock	222.46	222.5	222.21	222.46	9454.0
2023-01-05 04:00:00	NVDA	Stock	14.646	14.717	14.64	14.685	21220.0
2023-01-05 05:00:00	NVDA	Stock	14.723	14.794	14.723	14.761	57150.0
2023-01-05 06:00:00	NVDA	Stock	14.76	14.827	14.76	14.812	117590.0
2023-01-05 07:00:00	NVDA	Stock	14.805	14.874	14.79	14.82	127280.0
2023-01-05 08:00:00	NVDA	Stock	14.804	14.8788	14.477	14.495	1481340.0
2023-01-05 09:00:00	NVDA	Stock	14.497	14.564	14.262	14.3235	39910380.0
2023-01-05 10:00:00	NVDA	Stock	14.3225	14.443	14.182	14.194	62170260.0
2023-01-05 11:00:00	NVDA	Stock	14.1925	14.308	14.148	14.199	42162510.0
2023-01-05 12:00:00	NVDA	Stock	14.201	14.347	14.1975	14.2568	29404230.0
2023-01-05 13:00:00	NVDA	Stock	14.2564	14.4778	14.238	14.359	37807980.0
2023-01-05 14:00:00	NVDA	Stock	14.358	14.448	14.3171	14.383	30310970.0
2023-01-05 15:00:00	NVDA	Stock	14.384	14.398	14.24	14.266	45000190.0
2023-01-05 16:00:00	NVDA	Stock	14.269	14.29	14.2441	14.286	31913230.0
2023-01-05 17:00:00	NVDA	Stock	14.281	14.281	14.256	14.275	97970.0
2023-01-05 18:00:00	NVDA	Stock	14.278	14.288	14.27	14.273	48420.0
2023-01-05 19:00:00	NVDA	Stock	14.27	14.309	14.268	14.299	332990.0
2023-01-05 04:00:00	AMZN	Stock	86.36	87.3	86.32	87.3	97707.0
2023-01-05 05:00:00	AMZN	Stock	87.33	87.5	87.22	87.34	91194.0

> showing 50 of 60,847 rows — these rows as CSV

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