PREVIEW / stock_1hour / 2023-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-25.parquet
  size:    1.3 MB
  rows:    56,717
  symbols: 1,424

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-25 04:00:00	AAPL	Stock	176.46	176.9	176.36	176.73	10134.0
2023-08-25 05:00:00	AAPL	Stock	176.65	177.21	176.58	176.84	33789.0
2023-08-25 06:00:00	AAPL	Stock	176.94	177.12	176.83	176.99	11782.0
2023-08-25 07:00:00	AAPL	Stock	177.04	177.2	176.76	177.2	31937.0
2023-08-25 08:00:00	AAPL	Stock	177.0	177.4	176.21	177.19	107563.0
2023-08-25 09:00:00	AAPL	Stock	177.17	178.1395	176.38	177.6342	3941665.0
2023-08-25 10:00:00	AAPL	Stock	177.62	178.63	175.82	175.89	7380459.0
2023-08-25 11:00:00	AAPL	Stock	175.8999	177.77	175.87	176.66	4797791.0
2023-08-25 12:00:00	AAPL	Stock	176.66	177.84	176.64	177.49	3012140.0
2023-08-25 13:00:00	AAPL	Stock	177.49	177.65	176.94	177.42	2262142.0
2023-08-25 14:00:00	AAPL	Stock	177.415	178.7391	177.3401	178.61	3888619.0
2023-08-25 15:00:00	AAPL	Stock	178.61	179.15	178.43	178.6	7323709.0
2023-08-25 16:00:00	AAPL	Stock	178.6	178.68	178.4	178.53	6409301.0
2023-08-25 17:00:00	AAPL	Stock	178.53	178.61	178.53	178.55	107035.0
2023-08-25 18:00:00	AAPL	Stock	178.55	178.61	178.36	178.44	15366.0
2023-08-25 19:00:00	AAPL	Stock	178.45	178.59	178.45	178.5899	14652.0
2023-08-25 04:00:00	MSFT	Stock	319.81	320.42	319.81	320.07	3325.0
2023-08-25 05:00:00	MSFT	Stock	320.0	320.34	320.0	320.1	3626.0
2023-08-25 06:00:00	MSFT	Stock	320.2	321.12	320.2	321.0	3588.0
2023-08-25 07:00:00	MSFT	Stock	321.0	321.0	320.35	320.75	7928.0
2023-08-25 08:00:00	MSFT	Stock	320.65	321.79	318.91	321.1701	35387.0
2023-08-25 09:00:00	MSFT	Stock	321.1701	323.73	320.72	323.57	1537390.0
2023-08-25 10:00:00	MSFT	Stock	323.51	325.36	319.06	319.18	2554120.0
2023-08-25 11:00:00	MSFT	Stock	319.21	321.46	318.8001	319.63	1860065.0
2023-08-25 12:00:00	MSFT	Stock	319.55	321.21	319.46	321.0055	975537.0
2023-08-25 13:00:00	MSFT	Stock	320.96	321.62	320.05	321.15	731220.0
2023-08-25 14:00:00	MSFT	Stock	321.09	323.62	321.0	323.31	1190382.0
2023-08-25 15:00:00	MSFT	Stock	323.4	324.2	322.27	322.99	2044725.0
2023-08-25 16:00:00	MSFT	Stock	322.93	323.6	322.556	322.556	3412754.0
2023-08-25 17:00:00	MSFT	Stock	322.87	322.88	322.81	322.85	2150.0
2023-08-25 18:00:00	MSFT	Stock	322.71	322.71	322.38	322.55	2894.0
2023-08-25 19:00:00	MSFT	Stock	322.55	322.95	322.55	322.75	5422.0
2023-08-25 04:00:00	NVDA	Stock	47.001	47.885	47.001	47.698	595670.0
2023-08-25 05:00:00	NVDA	Stock	47.662	47.67	47.164	47.3	396860.0
2023-08-25 06:00:00	NVDA	Stock	47.3	47.448	47.3	47.375	177270.0
2023-08-25 07:00:00	NVDA	Stock	47.342	47.444	46.948	47.06	2318790.0
2023-08-25 08:00:00	NVDA	Stock	47.337	47.455	46.83	47.0	3983630.0
2023-08-25 09:00:00	NVDA	Stock	47.017	47.466	46.237	47.025	95364390.0
2023-08-25 10:00:00	NVDA	Stock	47.017	47.805	45.247	45.315	158371220.0
2023-08-25 11:00:00	NVDA	Stock	45.315	46.072	45.024	45.1455	135548330.0
2023-08-25 12:00:00	NVDA	Stock	45.131	45.7375	45.0616	45.4285	82832410.0
2023-08-25 13:00:00	NVDA	Stock	45.433	45.6681	45.212	45.3788	51112410.0
2023-08-25 14:00:00	NVDA	Stock	45.368	46.2237	45.3	46.198	76625820.0
2023-08-25 15:00:00	NVDA	Stock	46.189	46.364	45.77	46.018	95189940.0
2023-08-25 16:00:00	NVDA	Stock	46.002	46.08	45.94	45.995	20329990.0
2023-08-25 17:00:00	NVDA	Stock	45.992	46.006	45.88	45.887	733350.0
2023-08-25 18:00:00	NVDA	Stock	45.887	45.89	45.73	45.82	784540.0
2023-08-25 19:00:00	NVDA	Stock	45.833	45.915	45.82	45.877	584620.0
2023-08-25 04:00:00	AMZN	Stock	132.0	132.5	131.98	132.35	7692.0
2023-08-25 05:00:00	AMZN	Stock	132.27	132.39	132.1	132.1	8641.0

> showing 50 of 56,717 rows — these rows as CSV

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