PREVIEW / stock_1hour / 2023-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-28.parquet
  size:    1.4 MB
  rows:    60,987
  symbols: 1,798

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-28 04:00:00	AAPL	Stock	147.04	147.43	147.04	147.2	20153.0
2023-02-28 05:00:00	AAPL	Stock	147.2	147.69	147.18	147.61	13705.0
2023-02-28 06:00:00	AAPL	Stock	147.63	147.85	147.46	147.83	10515.0
2023-02-28 07:00:00	AAPL	Stock	147.83	148.23	147.75	148.11	34639.0
2023-02-28 08:00:00	AAPL	Stock	147.8901	148.26	147.28	147.59	124661.0
2023-02-28 09:00:00	AAPL	Stock	147.64	147.78	146.75	147.71	4531172.0
2023-02-28 10:00:00	AAPL	Stock	147.71	148.0	147.08	147.52	5701373.0
2023-02-28 11:00:00	AAPL	Stock	147.53	148.18	147.5136	147.95	3276822.0
2023-02-28 12:00:00	AAPL	Stock	147.96	148.8244	147.96	148.6686	3025157.0
2023-02-28 13:00:00	AAPL	Stock	148.67	149.08	148.62	148.825	3157744.0
2023-02-28 14:00:00	AAPL	Stock	148.83	148.985	148.26	148.318	3098700.0
2023-02-28 15:00:00	AAPL	Stock	148.315	148.38	147.37	147.4	7554819.0
2023-02-28 16:00:00	AAPL	Stock	147.39	147.65	147.0	147.13	12712465.0
2023-02-28 17:00:00	AAPL	Stock	147.19	147.41	147.1	147.17	27232.0
2023-02-28 18:00:00	AAPL	Stock	147.26	147.37	147.03	147.13	24688.0
2023-02-28 19:00:00	AAPL	Stock	147.1	147.1	146.85	146.93	54365.0
2023-02-28 04:00:00	MSFT	Stock	250.01	250.3	249.14	249.16	4030.0
2023-02-28 05:00:00	MSFT	Stock	249.17	249.83	249.17	249.66	1474.0
2023-02-28 06:00:00	MSFT	Stock	249.7	250.16	249.7	250.16	1977.0
2023-02-28 07:00:00	MSFT	Stock	250.5	250.91	250.49	250.8	8029.0
2023-02-28 08:00:00	MSFT	Stock	250.65	251.47	249.75	250.0	28851.0
2023-02-28 09:00:00	MSFT	Stock	250.16	250.26	248.69	249.8	1414656.0
2023-02-28 10:00:00	MSFT	Stock	249.84	250.41	249.1	249.815	1644605.0
2023-02-28 11:00:00	MSFT	Stock	249.82	250.5	249.13	249.6	1583349.0
2023-02-28 12:00:00	MSFT	Stock	249.65	251.19	249.63	250.88	1120405.0
2023-02-28 13:00:00	MSFT	Stock	250.89	251.49	250.7359	251.02	1086529.0
2023-02-28 14:00:00	MSFT	Stock	251.03	251.15	249.71	249.76	1249854.0
2023-02-28 15:00:00	MSFT	Stock	249.76	250.4	248.8	249.4	2866630.0
2023-02-28 16:00:00	MSFT	Stock	249.4	250.29	248.9301	249.13	4352878.0
2023-02-28 17:00:00	MSFT	Stock	249.42	249.42	248.89	249.1	59489.0
2023-02-28 18:00:00	MSFT	Stock	249.25	249.4	248.8	248.8	6201.0
2023-02-28 19:00:00	MSFT	Stock	248.92	249.0	248.35	248.5	9259.0
2023-02-28 04:00:00	NVDA	Stock	23.519	23.519	23.353	23.416	119690.0
2023-02-28 05:00:00	NVDA	Stock	23.41	23.527	23.41	23.52	113340.0
2023-02-28 06:00:00	NVDA	Stock	23.502	23.625	23.502	23.601	79390.0
2023-02-28 07:00:00	NVDA	Stock	23.579	23.688	23.579	23.641	447800.0
2023-02-28 08:00:00	NVDA	Stock	23.64	23.68	23.388	23.48	1574840.0
2023-02-28 09:00:00	NVDA	Stock	23.481	23.594	23.321	23.4756	47342880.0
2023-02-28 10:00:00	NVDA	Stock	23.478	23.566	23.291	23.4248	49643970.0
2023-02-28 11:00:00	NVDA	Stock	23.427	23.554	23.4265	23.547	36529940.0
2023-02-28 12:00:00	NVDA	Stock	23.549	23.75	23.531	23.705	41285400.0
2023-02-28 13:00:00	NVDA	Stock	23.704	23.825	23.7	23.776	32245760.0
2023-02-28 14:00:00	NVDA	Stock	23.778	23.8087	23.562	23.578	37772660.0
2023-02-28 15:00:00	NVDA	Stock	23.575	23.587	23.206	23.21	66449200.0
2023-02-28 16:00:00	NVDA	Stock	23.216	23.25	23.04	23.062	46690630.0
2023-02-28 17:00:00	NVDA	Stock	23.058	23.09	22.759	22.95	4542770.0
2023-02-28 18:00:00	NVDA	Stock	22.95	22.964	22.862	22.87	1190220.0
2023-02-28 19:00:00	NVDA	Stock	22.87	22.874	22.816	22.835	868940.0
2023-02-28 04:00:00	AMZN	Stock	93.4	93.49	93.15	93.32	8954.0
2023-02-28 05:00:00	AMZN	Stock	93.39	93.6	93.39	93.56	6964.0

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

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