PREVIEW / stock_1hour / 2023-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-22.parquet
  size:    1.4 MB
  rows:    60,787
  symbols: 1,823

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-22 04:00:00	AAPL	Stock	148.94	150.0	148.25	148.74	38116.0
2023-02-22 05:00:00	AAPL	Stock	148.75	148.77	148.45	148.53	8067.0
2023-02-22 06:00:00	AAPL	Stock	148.5	148.5	148.11	148.46	18654.0
2023-02-22 07:00:00	AAPL	Stock	148.5	149.46	148.22	149.18	123115.0
2023-02-22 08:00:00	AAPL	Stock	148.41	149.47	148.2706	148.98	193307.0
2023-02-22 09:00:00	AAPL	Stock	149.0	149.5	147.86	147.93	6515790.0
2023-02-22 10:00:00	AAPL	Stock	147.93	148.4	147.16	148.1401	6431420.0
2023-02-22 11:00:00	AAPL	Stock	148.15	148.32	147.69	148.064	3376660.0
2023-02-22 12:00:00	AAPL	Stock	148.08	149.11	147.84	148.93	4433339.0
2023-02-22 13:00:00	AAPL	Stock	148.925	149.43	148.7645	149.1699	3601118.0
2023-02-22 14:00:00	AAPL	Stock	149.17	149.95	148.26	148.37	6710740.0
2023-02-22 15:00:00	AAPL	Stock	148.37	149.01	148.185	148.93	6748498.0
2023-02-22 16:00:00	AAPL	Stock	148.94	149.6	148.6118	149.35	7112310.0
2023-02-22 17:00:00	AAPL	Stock	149.36	149.48	149.2505	149.35	74328.0
2023-02-22 18:00:00	AAPL	Stock	149.31	149.31	149.02	149.16	44019.0
2023-02-22 19:00:00	AAPL	Stock	149.18	149.3	149.1	149.18	29240.0
2023-02-22 04:00:00	MSFT	Stock	255.5	255.5	251.54	252.88	15404.0
2023-02-22 05:00:00	MSFT	Stock	252.65	252.66	252.12	252.63	1027.0
2023-02-22 06:00:00	MSFT	Stock	252.7	252.7	251.0	251.83	10064.0
2023-02-22 07:00:00	MSFT	Stock	252.01	254.13	252.0	253.6	22059.0
2023-02-22 08:00:00	MSFT	Stock	252.5	254.23	252.43	253.47	59725.0
2023-02-22 09:00:00	MSFT	Stock	253.5	254.34	252.84	253.345	2367381.0
2023-02-22 10:00:00	MSFT	Stock	253.345	253.365	251.39	252.855	2189663.0
2023-02-22 11:00:00	MSFT	Stock	252.87	252.94	251.85	252.5	1507956.0
2023-02-22 12:00:00	MSFT	Stock	252.5	253.08	252.17	252.86	1158709.0
2023-02-22 13:00:00	MSFT	Stock	252.85	253.65	252.73	253.25	847442.0
2023-02-22 14:00:00	MSFT	Stock	253.28	253.8499	251.14	251.23	1936325.0
2023-02-22 15:00:00	MSFT	Stock	251.22	251.69	250.34	251.59	2753937.0
2023-02-22 16:00:00	MSFT	Stock	251.6	253.11	251.51	252.34	4687555.0
2023-02-22 17:00:00	MSFT	Stock	252.44	253.0	251.89	252.75	59579.0
2023-02-22 18:00:00	MSFT	Stock	252.77	252.77	251.76	252.55	22040.0
2023-02-22 19:00:00	MSFT	Stock	252.55	252.7	252.26	252.44	14368.0
2023-02-22 04:00:00	NVDA	Stock	20.649	20.668	20.46	20.55	140280.0
2023-02-22 05:00:00	NVDA	Stock	20.55	20.597	20.523	20.577	42160.0
2023-02-22 06:00:00	NVDA	Stock	20.577	20.599	20.503	20.558	58240.0
2023-02-22 07:00:00	NVDA	Stock	20.56	20.839	20.558	20.82	898220.0
2023-02-22 08:00:00	NVDA	Stock	20.665	20.835	20.553	20.81	1197320.0
2023-02-22 09:00:00	NVDA	Stock	20.814	21.104	20.579	20.825	59216520.0
2023-02-22 10:00:00	NVDA	Stock	20.817	20.827	20.421	20.6177	60836610.0
2023-02-22 11:00:00	NVDA	Stock	20.619	20.829	20.595	20.767	40371820.0
2023-02-22 12:00:00	NVDA	Stock	20.773	20.94	20.7081	20.916	30383460.0
2023-02-22 13:00:00	NVDA	Stock	20.918	20.9919	20.811	20.8824	29762290.0
2023-02-22 14:00:00	NVDA	Stock	20.8816	21.0349	20.6512	20.666	47703220.0
2023-02-22 15:00:00	NVDA	Stock	20.661	20.802	20.62	20.765	54236360.0
2023-02-22 16:00:00	NVDA	Stock	20.754	22.55	20.442	22.285	48340600.0
2023-02-22 17:00:00	NVDA	Stock	22.256	22.652	22.0	22.503	26994840.0
2023-02-22 18:00:00	NVDA	Stock	22.509	22.6	22.47	22.575	5879000.0
2023-02-22 19:00:00	NVDA	Stock	22.579	22.6	22.55	22.599	3358880.0
2023-02-22 04:00:00	AMZN	Stock	94.58	94.93	94.49	94.78	18314.0
2023-02-22 05:00:00	AMZN	Stock	94.78	94.78	94.6	94.74	5700.0

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

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