PREVIEW / stock_1hour / 2023-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-24.parquet
  size:    1.3 MB
  rows:    60,104
  symbols: 1,818

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-02-24 04:00:00	AAPL	Stock	148.19	148.74	148.19	148.37	7539.0
2023-02-24 05:00:00	AAPL	Stock	148.34	148.34	148.15	148.29	8938.0
2023-02-24 06:00:00	AAPL	Stock	148.16	148.2	147.75	147.99	13841.0
2023-02-24 07:00:00	AAPL	Stock	147.98	148.11	147.93	148.0	35866.0
2023-02-24 08:00:00	AAPL	Stock	148.003	149.39	146.75	146.99	266377.0
2023-02-24 09:00:00	AAPL	Stock	147.05	147.28	146.12	146.41	6421028.0
2023-02-24 10:00:00	AAPL	Stock	146.4	146.91	145.95	146.09	8207524.0
2023-02-24 11:00:00	AAPL	Stock	146.1	146.9	145.73	146.4153	4976326.0
2023-02-24 12:00:00	AAPL	Stock	146.415	146.51	145.88	145.98	3437319.0
2023-02-24 13:00:00	AAPL	Stock	145.98	146.3595	145.7202	146.1	3926493.0
2023-02-24 14:00:00	AAPL	Stock	146.1	146.62	145.77	146.5	4285953.0
2023-02-24 15:00:00	AAPL	Stock	146.5119	146.8	145.805	146.71	8658093.0
2023-02-24 16:00:00	AAPL	Stock	146.72	146.8	146.52	146.62	8899719.0
2023-02-24 17:00:00	AAPL	Stock	146.6215	146.63	146.46	146.46	59686.0
2023-02-24 18:00:00	AAPL	Stock	146.5	146.59	146.5	146.5101	15793.0
2023-02-24 19:00:00	AAPL	Stock	146.53	146.53	146.3	146.4	27341.0
2023-02-24 04:00:00	MSFT	Stock	253.61	253.97	253.41	253.5	6778.0
2023-02-24 05:00:00	MSFT	Stock	253.5	253.52	253.2	253.29	3871.0
2023-02-24 06:00:00	MSFT	Stock	253.19	253.19	252.41	252.41	3812.0
2023-02-24 07:00:00	MSFT	Stock	252.71	253.15	252.6	252.87	19330.0
2023-02-24 08:00:00	MSFT	Stock	255.05	255.05	250.11	250.46	112737.0
2023-02-24 09:00:00	MSFT	Stock	250.34	251.0	249.06	249.5516	2466925.0
2023-02-24 10:00:00	MSFT	Stock	249.52	250.13	248.24	248.5	2309615.0
2023-02-24 11:00:00	MSFT	Stock	248.53	249.79	248.295	249.43	1585344.0
2023-02-24 12:00:00	MSFT	Stock	249.46	249.61	248.6	248.6901	1043469.0
2023-02-24 13:00:00	MSFT	Stock	248.7	249.1	248.17	248.94	1150004.0
2023-02-24 14:00:00	MSFT	Stock	248.94	249.64	248.41	249.4506	1098472.0
2023-02-24 15:00:00	MSFT	Stock	249.47	249.7805	248.1	249.21	3195755.0
2023-02-24 16:00:00	MSFT	Stock	249.26	249.46	249.02	249.09	4090030.0
2023-02-24 17:00:00	MSFT	Stock	249.15	249.2	248.9	249.07	6498.0
2023-02-24 18:00:00	MSFT	Stock	249.0999	249.1499	248.95	249.1499	1903.0
2023-02-24 19:00:00	MSFT	Stock	249.14	249.17	248.85	249.08	3968.0
2023-02-24 04:00:00	NVDA	Stock	23.43	23.566	23.376	23.376	270700.0
2023-02-24 05:00:00	NVDA	Stock	23.376	23.433	23.376	23.433	157150.0
2023-02-24 06:00:00	NVDA	Stock	23.44	23.44	23.351	23.399	134350.0
2023-02-24 07:00:00	NVDA	Stock	23.428	23.545	23.415	23.487	778400.0
2023-02-24 08:00:00	NVDA	Stock	23.464	23.565	23.28	23.391	5364280.0
2023-02-24 09:00:00	NVDA	Stock	23.383	23.474	22.984	23.104	87356880.0
2023-02-24 10:00:00	NVDA	Stock	23.108	23.179	22.947	23.0431	77809070.0
2023-02-24 11:00:00	NVDA	Stock	23.0461	23.4169	22.954	23.368	64978000.0
2023-02-24 12:00:00	NVDA	Stock	23.368	23.425	23.091	23.143	57139910.0
2023-02-24 13:00:00	NVDA	Stock	23.143	23.246	23.063	23.227	42254670.0
2023-02-24 14:00:00	NVDA	Stock	23.226	23.385	23.162	23.3707	45233530.0
2023-02-24 15:00:00	NVDA	Stock	23.3714	23.433	23.1841	23.288	64142150.0
2023-02-24 16:00:00	NVDA	Stock	23.294	23.316	23.271	23.306	26331770.0
2023-02-24 17:00:00	NVDA	Stock	23.314	23.318	23.302	23.313	333090.0
2023-02-24 18:00:00	NVDA	Stock	23.303	23.305	23.265	23.284	224260.0
2023-02-24 19:00:00	NVDA	Stock	23.276	23.285	23.261	23.282	201210.0
2023-02-24 04:00:00	AMZN	Stock	95.18	95.38	94.92	94.92	7379.0
2023-02-24 05:00:00	AMZN	Stock	94.9	95.0	94.79	94.93	5849.0

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

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