PREVIEW / stock_1hour / 2023-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-21.parquet
  size:    1.3 MB
  rows:    59,294
  symbols: 1,474

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-21 04:00:00	AAPL	Stock	175.02	175.22	174.82	175.0	25294.0
2023-08-21 05:00:00	AAPL	Stock	175.0	175.2	175.0	175.08	11784.0
2023-08-21 06:00:00	AAPL	Stock	175.1	175.25	175.0	175.04	28919.0
2023-08-21 07:00:00	AAPL	Stock	175.1	175.42	175.02	175.42	30571.0
2023-08-21 08:00:00	AAPL	Stock	175.2176	175.49	174.57	175.19	136828.0
2023-08-21 09:00:00	AAPL	Stock	175.23	175.4	174.35	175.4	4378731.0
2023-08-21 10:00:00	AAPL	Stock	175.4	175.57	173.92	174.24	5466640.0
2023-08-21 11:00:00	AAPL	Stock	174.24	174.47	173.735	174.1501	3479203.0
2023-08-21 12:00:00	AAPL	Stock	174.14	175.14	174.05	175.073	3309843.0
2023-08-21 13:00:00	AAPL	Stock	175.08	175.61	174.86	175.25	3123107.0
2023-08-21 14:00:00	AAPL	Stock	175.25	175.91	175.12	175.655	2802945.0
2023-08-21 15:00:00	AAPL	Stock	175.66	176.13	175.64	175.8	5851186.0
2023-08-21 16:00:00	AAPL	Stock	175.84	175.84	175.5	175.51	9224511.0
2023-08-21 17:00:00	AAPL	Stock	175.53	175.64	175.53	175.6	16893.0
2023-08-21 18:00:00	AAPL	Stock	175.6	175.6	175.5	175.55	28608.0
2023-08-21 19:00:00	AAPL	Stock	175.54	175.62	175.4	175.4	34176.0
2023-08-21 04:00:00	MSFT	Stock	317.5	318.16	317.5	318.16	4212.0
2023-08-21 05:00:00	MSFT	Stock	318.19	318.38	318.03	318.32	1799.0
2023-08-21 06:00:00	MSFT	Stock	318.35	318.4	317.79	317.8	2651.0
2023-08-21 07:00:00	MSFT	Stock	317.71	318.38	317.71	318.35	11079.0
2023-08-21 08:00:00	MSFT	Stock	317.9537	318.5	316.42	317.4104	33348.0
2023-08-21 09:00:00	MSFT	Stock	317.6279	319.94	316.95	319.92	1456781.0
2023-08-21 10:00:00	MSFT	Stock	319.893	321.055	317.77	318.76	2024580.0
2023-08-21 11:00:00	MSFT	Stock	318.8	319.4	317.6101	318.35	1048713.0
2023-08-21 12:00:00	MSFT	Stock	318.28	321.0	318.1	320.91	1007570.0
2023-08-21 13:00:00	MSFT	Stock	320.92	322.2	320.67	321.66	1289053.0
2023-08-21 14:00:00	MSFT	Stock	321.67	322.77	321.54	322.33	995086.0
2023-08-21 15:00:00	MSFT	Stock	322.33	322.76	321.51	321.86	2133979.0
2023-08-21 16:00:00	MSFT	Stock	321.87	321.88	320.87	321.17	3483259.0
2023-08-21 17:00:00	MSFT	Stock	321.27	321.43	321.19	321.37	6506.0
2023-08-21 18:00:00	MSFT	Stock	321.3	321.37	320.61	320.89	14400.0
2023-08-21 19:00:00	MSFT	Stock	321.01	321.69	320.9492	321.5	13422.0
2023-08-21 04:00:00	NVDA	Stock	43.5	44.2	43.5	44.174	993220.0
2023-08-21 05:00:00	NVDA	Stock	44.2	44.228	44.137	44.225	95790.0
2023-08-21 06:00:00	NVDA	Stock	44.245	44.28	44.105	44.14	218640.0
2023-08-21 07:00:00	NVDA	Stock	44.15	44.438	44.062	44.405	1491590.0
2023-08-21 08:00:00	NVDA	Stock	44.08	44.5173	43.6	44.4	4197400.0
2023-08-21 09:00:00	NVDA	Stock	44.38	45.401	44.222	45.33	86695070.0
2023-08-21 10:00:00	NVDA	Stock	45.3282	45.59	45.055	45.171	84040280.0
2023-08-21 11:00:00	NVDA	Stock	45.17	45.37	44.875	45.27	54039570.0
2023-08-21 12:00:00	NVDA	Stock	45.255	45.786	45.253	45.772	55108990.0
2023-08-21 13:00:00	NVDA	Stock	45.769	46.175	45.705	46.0286	55105730.0
2023-08-21 14:00:00	NVDA	Stock	46.035	46.457	46.011	46.4377	53411840.0
2023-08-21 15:00:00	NVDA	Stock	46.444	47.065	46.441	46.967	98752390.0
2023-08-21 16:00:00	NVDA	Stock	46.962	47.274	46.905	47.216	26595190.0
2023-08-21 17:00:00	NVDA	Stock	47.23	47.292	47.043	47.16	2153810.0
2023-08-21 18:00:00	NVDA	Stock	47.169	47.169	47.049	47.115	974240.0
2023-08-21 19:00:00	NVDA	Stock	47.119	47.18	47.074	47.099	1341820.0
2023-08-21 04:00:00	AMZN	Stock	133.52	134.14	133.52	134.08	12007.0
2023-08-21 05:00:00	AMZN	Stock	134.14	134.3	134.0	134.05	6097.0

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

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