PREVIEW / stock_1hour / 2023-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-22.parquet
  size:    1.3 MB
  rows:    58,377
  symbols: 1,465

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-08-22 04:00:00	AAPL	Stock	176.16	176.8	176.16	176.6	23238.0
2023-08-22 05:00:00	AAPL	Stock	176.69	176.79	176.49	176.73	23905.0
2023-08-22 06:00:00	AAPL	Stock	176.77	176.88	176.69	176.81	18747.0
2023-08-22 07:00:00	AAPL	Stock	176.76	177.04	176.59	176.95	57920.0
2023-08-22 08:00:00	AAPL	Stock	176.7408	177.1999	175.89	176.81	266584.0
2023-08-22 09:00:00	AAPL	Stock	176.84	177.24	176.25	176.6	4577687.0
2023-08-22 10:00:00	AAPL	Stock	176.595	177.3174	176.26	177.205	4825398.0
2023-08-22 11:00:00	AAPL	Stock	177.21	177.43	176.58	176.7116	4357764.0
2023-08-22 12:00:00	AAPL	Stock	176.72	177.3799	176.27	177.03	3519083.0
2023-08-22 13:00:00	AAPL	Stock	177.02	177.255	176.77	177.06	3100001.0
2023-08-22 14:00:00	AAPL	Stock	177.06	177.37	176.84	177.355	2518057.0
2023-08-22 15:00:00	AAPL	Stock	177.36	177.68	177.08	177.22	6370522.0
2023-08-22 16:00:00	AAPL	Stock	177.23	177.32	177.03	177.09	4215977.0
2023-08-22 17:00:00	AAPL	Stock	177.09	177.16	177.03	177.1	12969.0
2023-08-22 18:00:00	AAPL	Stock	177.1	177.25	177.1	177.1	26731.0
2023-08-22 19:00:00	AAPL	Stock	177.03	177.15	177.0	177.01	10044.0
2023-08-22 04:00:00	MSFT	Stock	322.01	323.8	322.01	323.65	7949.0
2023-08-22 05:00:00	MSFT	Stock	323.23	323.9	323.23	323.58	5506.0
2023-08-22 06:00:00	MSFT	Stock	323.59	323.9	323.59	323.73	2736.0
2023-08-22 07:00:00	MSFT	Stock	323.72	326.0	323.54	325.64	43590.0
2023-08-22 08:00:00	MSFT	Stock	323.75	326.2445	321.6	325.15	99444.0
2023-08-22 09:00:00	MSFT	Stock	325.16	326.075	323.08	324.27	1759482.0
2023-08-22 10:00:00	MSFT	Stock	324.27	325.155	323.37	324.88	1573189.0
2023-08-22 11:00:00	MSFT	Stock	324.92	325.2	323.65	323.94	1147693.0
2023-08-22 12:00:00	MSFT	Stock	323.94	324.05	322.61	323.24	832304.0
2023-08-22 13:00:00	MSFT	Stock	323.25	323.44	322.4	323.3	685875.0
2023-08-22 14:00:00	MSFT	Stock	323.27	323.91	322.87	323.1	686621.0
2023-08-22 15:00:00	MSFT	Stock	323.085	323.6	321.46	322.45	1817527.0
2023-08-22 16:00:00	MSFT	Stock	322.45	322.49	322.1	322.17	2099589.0
2023-08-22 17:00:00	MSFT	Stock	322.09	322.41	322.09	322.41	4513.0
2023-08-22 18:00:00	MSFT	Stock	322.4	322.49	322.3	322.4632	5458.0
2023-08-22 19:00:00	MSFT	Stock	322.44	322.8	322.31	322.31	6469.0
2023-08-22 04:00:00	NVDA	Stock	47.352	47.725	47.32	47.725	765280.0
2023-08-22 05:00:00	NVDA	Stock	47.76	47.929	47.685	47.877	455920.0
2023-08-22 06:00:00	NVDA	Stock	47.88	47.88	47.631	47.67	374290.0
2023-08-22 07:00:00	NVDA	Stock	47.633	47.866	47.632	47.76	2079920.0
2023-08-22 08:00:00	NVDA	Stock	47.654	48.203	47.1	48.1024	6990410.0
2023-08-22 09:00:00	NVDA	Stock	48.1022	48.344	46.21	46.2811	122105010.0
2023-08-22 10:00:00	NVDA	Stock	46.2925	46.995	45.68	46.542	133626140.0
2023-08-22 11:00:00	NVDA	Stock	46.536	46.582	45.604	45.722	68165450.0
2023-08-22 12:00:00	NVDA	Stock	45.7188	45.942	45.3331	45.7745	63748120.0
2023-08-22 13:00:00	NVDA	Stock	45.7699	45.8356	45.4228	45.743	45387040.0
2023-08-22 14:00:00	NVDA	Stock	45.766	45.986	45.455	45.8295	47235060.0
2023-08-22 15:00:00	NVDA	Stock	45.826	46.002	45.441	45.672	76928260.0
2023-08-22 16:00:00	NVDA	Stock	45.668	45.864	45.625	45.732	14122580.0
2023-08-22 17:00:00	NVDA	Stock	45.73	45.8227	45.7	45.766	829250.0
2023-08-22 18:00:00	NVDA	Stock	45.765	45.797	45.702	45.725	469820.0
2023-08-22 19:00:00	NVDA	Stock	45.736	45.837	45.704	45.8	863280.0
2023-08-22 04:00:00	AMZN	Stock	134.89	135.45	134.89	135.22	14287.0
2023-08-22 05:00:00	AMZN	Stock	135.27	135.45	135.12	135.45	5704.0

> showing 50 of 58,377 rows — these rows as CSV

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