PREVIEW / stock_1hour / 2023-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-28.parquet
  size:    1.3 MB
  rows:    59,282
  symbols: 1,748

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-28 04:00:00	AAPL	Stock	157.95	158.06	157.26	157.57	17564.0
2023-03-28 05:00:00	AAPL	Stock	157.55	157.64	157.5	157.6	6593.0
2023-03-28 06:00:00	AAPL	Stock	157.6	157.67	157.38	157.5	13070.0
2023-03-28 07:00:00	AAPL	Stock	157.57	157.79	157.4	157.7	68277.0
2023-03-28 08:00:00	AAPL	Stock	157.4904	158.13	157.4	157.6428	106090.0
2023-03-28 09:00:00	AAPL	Stock	157.59	158.49	156.77	156.77	5544668.0
2023-03-28 10:00:00	AAPL	Stock	156.765	157.3101	156.08	156.45	6801177.0
2023-03-28 11:00:00	AAPL	Stock	156.44	157.03	156.39	156.91	4594816.0
2023-03-28 12:00:00	AAPL	Stock	156.92	156.95	156.435	156.54	3008908.0
2023-03-28 13:00:00	AAPL	Stock	156.56	156.63	155.98	156.085	3823080.0
2023-03-28 14:00:00	AAPL	Stock	156.08	156.76	156.05	156.735	3454661.0
2023-03-28 15:00:00	AAPL	Stock	156.74	157.73	156.74	157.67	7009028.0
2023-03-28 16:00:00	AAPL	Stock	157.67	157.78	157.52	157.65	6113093.0
2023-03-28 17:00:00	AAPL	Stock	157.64	157.67	157.6	157.65	8604.0
2023-03-28 18:00:00	AAPL	Stock	157.66	157.71	157.5999	157.6	13251.0
2023-03-28 19:00:00	AAPL	Stock	157.63	157.78	157.6	157.7	27433.0
2023-03-28 04:00:00	MSFT	Stock	276.75	276.75	274.15	275.0	8476.0
2023-03-28 05:00:00	MSFT	Stock	274.99	275.5	274.99	275.2	2385.0
2023-03-28 06:00:00	MSFT	Stock	275.2	276.0	274.89	275.0	5331.0
2023-03-28 07:00:00	MSFT	Stock	275.36	276.1	275.36	275.8	4524.0
2023-03-28 08:00:00	MSFT	Stock	275.5272	277.32	275.21	275.71	24783.0
2023-03-28 09:00:00	MSFT	Stock	275.6	276.18	272.74	273.7306	2544067.0
2023-03-28 10:00:00	MSFT	Stock	273.73	274.27	272.06	272.1346	2128652.0
2023-03-28 11:00:00	MSFT	Stock	272.15	274.1	272.0451	273.7499	2348425.0
2023-03-28 12:00:00	MSFT	Stock	273.75	273.838	273.04	273.46	1202621.0
2023-03-28 13:00:00	MSFT	Stock	273.47	273.63	272.12	272.25	2053288.0
2023-03-28 14:00:00	MSFT	Stock	272.24	273.6499	272.15	273.59	1264205.0
2023-03-28 15:00:00	MSFT	Stock	273.61	275.33	273.61	275.26	2454964.0
2023-03-28 16:00:00	MSFT	Stock	275.23	275.86	275.0	275.63	2697405.0
2023-03-28 17:00:00	MSFT	Stock	275.63	275.8	275.5076	275.5076	3860.0
2023-03-28 18:00:00	MSFT	Stock	275.67	275.93	275.4	275.55	6124.0
2023-03-28 19:00:00	MSFT	Stock	275.7	276.17	275.7	276.17	6919.0
2023-03-28 04:00:00	NVDA	Stock	26.48	26.48	26.321	26.34	116890.0
2023-03-28 05:00:00	NVDA	Stock	26.35	26.399	26.326	26.338	113430.0
2023-03-28 06:00:00	NVDA	Stock	26.35	26.45	26.326	26.37	94080.0
2023-03-28 07:00:00	NVDA	Stock	26.385	26.575	26.385	26.495	417530.0
2023-03-28 08:00:00	NVDA	Stock	26.4296	26.5973	26.385	26.4265	1052940.0
2023-03-28 09:00:00	NVDA	Stock	26.4258	26.513	25.895	25.928	50801530.0
2023-03-28 10:00:00	NVDA	Stock	25.926	26.164	25.85	26.0212	53493800.0
2023-03-28 11:00:00	NVDA	Stock	26.026	26.315	26.021	26.2599	46127320.0
2023-03-28 12:00:00	NVDA	Stock	26.2615	26.295	26.093	26.196	32197370.0
2023-03-28 13:00:00	NVDA	Stock	26.2	26.259	26.121	26.1781	20079860.0
2023-03-28 14:00:00	NVDA	Stock	26.173	26.28	26.168	26.1985	22388830.0
2023-03-28 15:00:00	NVDA	Stock	26.205	26.435	26.1955	26.414	41111570.0
2023-03-28 16:00:00	NVDA	Stock	26.41	26.48	26.353	26.382	13383120.0
2023-03-28 17:00:00	NVDA	Stock	26.387	26.4399	26.385	26.401	251510.0
2023-03-28 18:00:00	NVDA	Stock	26.411	26.466	26.411	26.422	246930.0
2023-03-28 19:00:00	NVDA	Stock	26.426	26.48	26.421	26.47	203950.0
2023-03-28 04:00:00	AMZN	Stock	98.0	98.0	97.33	97.61	12688.0
2023-03-28 05:00:00	AMZN	Stock	97.77	97.9	97.61	97.61	12888.0

> showing 50 of 59,282 rows — these rows as CSV

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