PREVIEW / stock_1hour / 2023-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-21.parquet
  size:    1.4 MB
  rows:    60,988
  symbols: 1,776

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-03-21 04:00:00	AAPL	Stock	157.45	157.69	157.19	157.2	13242.0
2023-03-21 05:00:00	AAPL	Stock	157.2	157.28	156.73	157.13	15937.0
2023-03-21 06:00:00	AAPL	Stock	157.22	157.46	157.0	157.14	17198.0
2023-03-21 07:00:00	AAPL	Stock	157.14	157.76	157.03	157.52	68118.0
2023-03-21 08:00:00	AAPL	Stock	157.4592	157.73	156.97	157.15	243731.0
2023-03-21 09:00:00	AAPL	Stock	157.1	158.39	156.93	157.65	8114997.0
2023-03-21 10:00:00	AAPL	Stock	157.66	157.97	156.54	156.905	8230530.0
2023-03-21 11:00:00	AAPL	Stock	156.91	157.69	156.851	157.43	7068126.0
2023-03-21 12:00:00	AAPL	Stock	157.43	158.29	157.35	158.1933	5482219.0
2023-03-21 13:00:00	AAPL	Stock	158.2	159.1	158.08	158.6	6614620.0
2023-03-21 14:00:00	AAPL	Stock	158.6099	159.0	158.33	158.8999	5103582.0
2023-03-21 15:00:00	AAPL	Stock	158.89	159.4	158.6	159.4	10036761.0
2023-03-21 16:00:00	AAPL	Stock	159.38	159.38	159.16	159.21	14920841.0
2023-03-21 17:00:00	AAPL	Stock	159.19	159.21	158.86	158.86	49146.0
2023-03-21 18:00:00	AAPL	Stock	158.95	159.05	158.89	159.05	14496.0
2023-03-21 19:00:00	AAPL	Stock	159.05	159.27	158.94	158.97	37817.0
2023-03-21 04:00:00	MSFT	Stock	272.42	272.79	272.21	272.59	3959.0
2023-03-21 05:00:00	MSFT	Stock	272.51	272.51	271.6	271.79	6223.0
2023-03-21 06:00:00	MSFT	Stock	271.79	272.96	271.0	271.5	23826.0
2023-03-21 07:00:00	MSFT	Stock	271.5	273.89	271.4	273.5	48723.0
2023-03-21 08:00:00	MSFT	Stock	273.5	273.8	271.35	273.6	136372.0
2023-03-21 09:00:00	MSFT	Stock	273.59	275.4	272.81	273.8762	2769464.0
2023-03-21 10:00:00	MSFT	Stock	273.89	274.34	269.5191	270.8801	4421880.0
2023-03-21 11:00:00	MSFT	Stock	270.9	271.5	269.68	270.23	2671177.0
2023-03-21 12:00:00	MSFT	Stock	270.24	272.04	270.04	271.88	2151607.0
2023-03-21 13:00:00	MSFT	Stock	271.89	272.79	270.95	270.9615	2045227.0
2023-03-21 14:00:00	MSFT	Stock	270.9697	272.42	270.94	272.06	1693661.0
2023-03-21 15:00:00	MSFT	Stock	272.05	273.84	272.02	273.79	3598615.0
2023-03-21 16:00:00	MSFT	Stock	273.78	273.78	273.12	273.26	6032949.0
2023-03-21 17:00:00	MSFT	Stock	273.2796	273.3	272.9	272.9	11248.0
2023-03-21 18:00:00	MSFT	Stock	272.99	273.15	272.7	273.15	7399.0
2023-03-21 19:00:00	MSFT	Stock	273.0	273.38	272.95	272.95	9809.0
2023-03-21 04:00:00	NVDA	Stock	26.0	26.069	25.981	26.018	110990.0
2023-03-21 05:00:00	NVDA	Stock	26.032	26.034	25.978	25.978	68670.0
2023-03-21 06:00:00	NVDA	Stock	26.023	26.07	25.974	25.98	138790.0
2023-03-21 07:00:00	NVDA	Stock	26.0	26.253	26.0	26.21	799100.0
2023-03-21 08:00:00	NVDA	Stock	26.221	26.346	25.895	26.25	2841830.0
2023-03-21 09:00:00	NVDA	Stock	26.252	26.313	26.034	26.2945	51351090.0
2023-03-21 10:00:00	NVDA	Stock	26.299	26.35	25.79	25.9	69416300.0
2023-03-21 11:00:00	NVDA	Stock	25.901	26.048	25.381	25.568	76765880.0
2023-03-21 12:00:00	NVDA	Stock	25.568	25.945	25.551	25.909	49518820.0
2023-03-21 13:00:00	NVDA	Stock	25.9085	26.237	25.8154	26.0914	46225110.0
2023-03-21 14:00:00	NVDA	Stock	26.099	26.308	26.035	26.264	49191130.0
2023-03-21 15:00:00	NVDA	Stock	26.26	26.392	26.158	26.194	68271820.0
2023-03-21 16:00:00	NVDA	Stock	26.194	26.2575	26.14	26.18	23802820.0
2023-03-21 17:00:00	NVDA	Stock	26.183	26.189	26.15	26.171	297830.0
2023-03-21 18:00:00	NVDA	Stock	26.17	26.185	26.156	26.161	319580.0
2023-03-21 19:00:00	NVDA	Stock	26.161	26.189	26.145	26.189	468320.0
2023-03-21 04:00:00	AMZN	Stock	97.8	97.95	97.57	97.8	13272.0
2023-03-21 05:00:00	AMZN	Stock	97.8	97.8	97.58	97.76	22442.0

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

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