PREVIEW / stock_1hour / 2023-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-23.parquet
  size:    1.3 MB
  rows:    60,251
  symbols: 1,600

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-06-23 04:00:00	AAPL	Stock	186.48	186.48	185.8	185.95	22515.0
2023-06-23 05:00:00	AAPL	Stock	185.91	186.21	185.9	186.05	13482.0
2023-06-23 06:00:00	AAPL	Stock	186.11	186.13	185.94	186.0	8011.0
2023-06-23 07:00:00	AAPL	Stock	186.0	186.32	186.0	186.18	50963.0
2023-06-23 08:00:00	AAPL	Stock	186.16	186.3666	185.2	185.38	264078.0
2023-06-23 09:00:00	AAPL	Stock	185.38	186.18	185.01	185.28	5727193.0
2023-06-23 10:00:00	AAPL	Stock	185.27	186.35	185.01	186.27	5862885.0
2023-06-23 11:00:00	AAPL	Stock	186.28	186.69	185.91	186.5613	3904096.0
2023-06-23 12:00:00	AAPL	Stock	186.57	187.14	186.535	186.983	3798424.0
2023-06-23 13:00:00	AAPL	Stock	186.99	187.56	186.985	187.34	3179871.0
2023-06-23 14:00:00	AAPL	Stock	187.34	187.425	186.575	186.7	3473902.0
2023-06-23 15:00:00	AAPL	Stock	186.71	187.25	186.38	186.68	7668104.0
2023-06-23 16:00:00	AAPL	Stock	186.67	186.74	186.35	186.5	9839374.0
2023-06-23 17:00:00	AAPL	Stock	186.48	186.68	186.43	186.51	57033.0
2023-06-23 18:00:00	AAPL	Stock	186.53	186.55	186.47	186.48	12959.0
2023-06-23 19:00:00	AAPL	Stock	186.48	186.52	186.45	186.5	15388.0
2023-06-23 04:00:00	MSFT	Stock	338.02	338.3	337.32	337.32	2451.0
2023-06-23 05:00:00	MSFT	Stock	337.25	337.48	337.15	337.48	1866.0
2023-06-23 06:00:00	MSFT	Stock	337.25	337.25	337.0	337.0	1878.0
2023-06-23 07:00:00	MSFT	Stock	337.34	337.99	336.26	336.81	18692.0
2023-06-23 08:00:00	MSFT	Stock	337.33	339.0	334.12	335.0	57062.0
2023-06-23 09:00:00	MSFT	Stock	335.0	336.18	333.45	334.9	2162801.0
2023-06-23 10:00:00	MSFT	Stock	334.9	337.06	334.49	336.09	2041978.0
2023-06-23 11:00:00	MSFT	Stock	336.125	336.313	335.0232	335.85	1207549.0
2023-06-23 12:00:00	MSFT	Stock	335.87	337.31	335.76	337.19	1051846.0
2023-06-23 13:00:00	MSFT	Stock	337.2445	337.96	337.0107	337.11	1047159.0
2023-06-23 14:00:00	MSFT	Stock	337.09	337.42	335.22	335.6	1094170.0
2023-06-23 15:00:00	MSFT	Stock	335.6	336.3273	334.68	335.01	2821826.0
2023-06-23 16:00:00	MSFT	Stock	335.02	335.07	334.67	334.94	4878197.0
2023-06-23 17:00:00	MSFT	Stock	334.98	335.02	334.76	334.76	7084.0
2023-06-23 18:00:00	MSFT	Stock	335.02	335.02	334.7	334.7	49880.0
2023-06-23 19:00:00	MSFT	Stock	334.7	334.89	334.65	334.85	6244.0
2023-06-23 04:00:00	NVDA	Stock	42.615	42.814	42.52	42.561	202390.0
2023-06-23 05:00:00	NVDA	Stock	42.55	42.687	42.54	42.671	59480.0
2023-06-23 06:00:00	NVDA	Stock	42.653	42.653	42.588	42.653	21000.0
2023-06-23 07:00:00	NVDA	Stock	42.669	42.765	42.65	42.694	421150.0
2023-06-23 08:00:00	NVDA	Stock	42.679	42.766	42.45	42.5	1816770.0
2023-06-23 09:00:00	NVDA	Stock	42.5	42.775	42.015	42.146	49337270.0
2023-06-23 10:00:00	NVDA	Stock	42.145	42.55	42.127	42.3575	51159900.0
2023-06-23 11:00:00	NVDA	Stock	42.36	42.486	42.1321	42.26	32195440.0
2023-06-23 12:00:00	NVDA	Stock	42.2615	42.679	42.261	42.596	28361500.0
2023-06-23 13:00:00	NVDA	Stock	42.59	42.809	42.5209	42.6645	23781800.0
2023-06-23 14:00:00	NVDA	Stock	42.662	42.712	42.363	42.3685	25447880.0
2023-06-23 15:00:00	NVDA	Stock	42.3685	42.484	42.195	42.207	41717820.0
2023-06-23 16:00:00	NVDA	Stock	42.207	42.3469	42.022	42.065	20799040.0
2023-06-23 17:00:00	NVDA	Stock	42.066	42.114	42.062	42.105	359190.0
2023-06-23 18:00:00	NVDA	Stock	42.11	42.209	42.068	42.07	1391660.0
2023-06-23 19:00:00	NVDA	Stock	42.068	42.095	42.05	42.052	321620.0
2023-06-23 04:00:00	AMZN	Stock	130.0	130.0	129.02	129.05	34227.0
2023-06-23 05:00:00	AMZN	Stock	129.14	129.65	129.14	129.51	21022.0

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

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