PREVIEW / stock_1hour / 2023-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-14.parquet
  size:    1.3 MB
  rows:    60,059
  symbols: 1,524

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-14 04:00:00	AAPL	Stock	177.82	179.45	177.73	178.63	90061.0
2023-08-14 05:00:00	AAPL	Stock	178.55	178.71	178.29	178.56	6098.0
2023-08-14 06:00:00	AAPL	Stock	178.56	178.78	178.5	178.63	9096.0
2023-08-14 07:00:00	AAPL	Stock	178.55	178.57	177.99	178.18	62603.0
2023-08-14 08:00:00	AAPL	Stock	178.45	178.765	177.38	177.65	228920.0
2023-08-14 09:00:00	AAPL	Stock	177.65	178.53	177.305	178.275	5315274.0
2023-08-14 10:00:00	AAPL	Stock	178.27	179.69	178.02	179.44	6474711.0
2023-08-14 11:00:00	AAPL	Stock	179.438	179.54	178.94	179.01	3541094.0
2023-08-14 12:00:00	AAPL	Stock	179.015	179.255	178.59	179.16	3135233.0
2023-08-14 13:00:00	AAPL	Stock	179.17	179.44	179.03	179.169	2132027.0
2023-08-14 14:00:00	AAPL	Stock	179.17	179.35	178.7	178.95	2933208.0
2023-08-14 15:00:00	AAPL	Stock	178.96	179.52	178.83	179.51	5424964.0
2023-08-14 16:00:00	AAPL	Stock	179.515	179.6	179.31	179.43	5732499.0
2023-08-14 17:00:00	AAPL	Stock	179.41	179.55	179.41	179.51	32758.0
2023-08-14 18:00:00	AAPL	Stock	179.5	179.84	179.47	179.81	26215.0
2023-08-14 19:00:00	AAPL	Stock	179.82	179.93	179.65	179.91	33854.0
2023-08-14 04:00:00	MSFT	Stock	322.1	323.46	322.1	322.5	6561.0
2023-08-14 05:00:00	MSFT	Stock	322.21	322.51	322.21	322.35	1527.0
2023-08-14 06:00:00	MSFT	Stock	322.56	323.32	322.4	323.32	8862.0
2023-08-14 07:00:00	MSFT	Stock	322.75	322.75	322.2	322.2	6287.0
2023-08-14 08:00:00	MSFT	Stock	322.71	323.0	320.658	321.36	35972.0
2023-08-14 09:00:00	MSFT	Stock	321.5199	321.87	320.08	320.985	1321503.0
2023-08-14 10:00:00	MSFT	Stock	320.99	324.06	320.65	323.61	2465422.0
2023-08-14 11:00:00	MSFT	Stock	323.65	323.9456	322.16	322.87	1653985.0
2023-08-14 12:00:00	MSFT	Stock	322.95	323.135	321.836	322.3799	929295.0
2023-08-14 13:00:00	MSFT	Stock	322.36	322.95	321.71	322.3484	828320.0
2023-08-14 14:00:00	MSFT	Stock	322.35	322.37	321.44	321.94	923095.0
2023-08-14 15:00:00	MSFT	Stock	321.96	324.04	321.74	324.03	1942755.0
2023-08-14 16:00:00	MSFT	Stock	324.03	324.47	323.81	323.9	3000948.0
2023-08-14 17:00:00	MSFT	Stock	323.94	324.04	323.94	324.025	9040.0
2023-08-14 18:00:00	MSFT	Stock	324.02	324.7199	323.819	324.5	11017.0
2023-08-14 19:00:00	MSFT	Stock	324.51	324.64	324.31	324.5	4873.0
2023-08-14 04:00:00	NVDA	Stock	40.6	41.15	40.6	40.93	372510.0
2023-08-14 05:00:00	NVDA	Stock	40.91	40.93	40.852	40.891	66570.0
2023-08-14 06:00:00	NVDA	Stock	40.905	40.98	40.9	40.93	114910.0
2023-08-14 07:00:00	NVDA	Stock	40.903	40.93	40.81	40.914	808820.0
2023-08-14 08:00:00	NVDA	Stock	40.901	40.94	40.5513	40.685	1687820.0
2023-08-14 09:00:00	NVDA	Stock	40.6802	41.65	40.311	41.6314	79695160.0
2023-08-14 10:00:00	NVDA	Stock	41.631	42.838	41.55	42.692	121258930.0
2023-08-14 11:00:00	NVDA	Stock	42.693	43.212	42.441	43.04	79494260.0
2023-08-14 12:00:00	NVDA	Stock	43.03	43.225	42.856	43.138	52654410.0
2023-08-14 13:00:00	NVDA	Stock	43.1385	43.596	43.106	43.478	58192670.0
2023-08-14 14:00:00	NVDA	Stock	43.475	43.625	43.204	43.363	47953810.0
2023-08-14 15:00:00	NVDA	Stock	43.367	43.8	43.323	43.7615	61367120.0
2023-08-14 16:00:00	NVDA	Stock	43.764	44.126	43.75	44.076	22453460.0
2023-08-14 17:00:00	NVDA	Stock	44.07	44.27	44.051	44.26	3286760.0
2023-08-14 18:00:00	NVDA	Stock	44.2669	44.348	44.212	44.29	2088730.0
2023-08-14 19:00:00	NVDA	Stock	44.292	44.566	44.288	44.557	3641110.0
2023-08-14 04:00:00	AMZN	Stock	138.69	139.34	138.49	138.93	19529.0
2023-08-14 05:00:00	AMZN	Stock	138.93	139.02	138.79	139.01	10173.0

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

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