PREVIEW / stock_1hour / 2023-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-11.parquet
  size:    1.3 MB
  rows:    59,959
  symbols: 1,662

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-05-11 04:00:00	AAPL	Stock	173.42	173.99	173.42	173.68	8282.0
2023-05-11 05:00:00	AAPL	Stock	173.74	173.9	173.7	173.78	7620.0
2023-05-11 06:00:00	AAPL	Stock	173.76	173.8	173.58	173.58	3326.0
2023-05-11 07:00:00	AAPL	Stock	173.65	173.75	173.37	173.48	42832.0
2023-05-11 08:00:00	AAPL	Stock	173.7486	174.03	173.42	173.6899	163017.0
2023-05-11 09:00:00	AAPL	Stock	173.71	173.99	172.18	172.27	6383764.0
2023-05-11 10:00:00	AAPL	Stock	172.28	173.255	172.17	173.23	5905227.0
2023-05-11 11:00:00	AAPL	Stock	173.23	173.88	173.1601	173.59	5516611.0
2023-05-11 12:00:00	AAPL	Stock	173.59	174.025	173.35	173.76	4052571.0
2023-05-11 13:00:00	AAPL	Stock	173.76	173.94	173.06	173.6699	3888147.0
2023-05-11 14:00:00	AAPL	Stock	173.67	174.59	173.56	174.37	4656959.0
2023-05-11 15:00:00	AAPL	Stock	174.375	174.4	173.5	173.81	5924424.0
2023-05-11 16:00:00	AAPL	Stock	173.75	173.84	173.54	173.61	5480708.0
2023-05-11 17:00:00	AAPL	Stock	173.62	173.75	173.58	173.6	42855.0
2023-05-11 18:00:00	AAPL	Stock	173.6152	173.74	173.6152	173.74	26401.0
2023-05-11 19:00:00	AAPL	Stock	173.73	173.82	173.7	173.76	28909.0
2023-05-11 04:00:00	MSFT	Stock	312.0	313.06	312.0	312.4	1920.0
2023-05-11 05:00:00	MSFT	Stock	312.6	312.6	311.7	312.1	7030.0
2023-05-11 06:00:00	MSFT	Stock	312.03	312.03	311.27	311.53	5183.0
2023-05-11 07:00:00	MSFT	Stock	311.5	311.68	310.8	311.12	23679.0
2023-05-11 08:00:00	MSFT	Stock	311.6	313.06	310.5	310.7	106576.0
2023-05-11 09:00:00	MSFT	Stock	310.85	311.15	306.2601	307.49	4867179.0
2023-05-11 10:00:00	MSFT	Stock	307.53	309.725	307.02	309.725	3342196.0
2023-05-11 11:00:00	MSFT	Stock	309.73	310.3299	309.03	309.55	2078549.0
2023-05-11 12:00:00	MSFT	Stock	309.55	310.08	308.85	309.6701	1368705.0
2023-05-11 13:00:00	MSFT	Stock	309.69	310.01	308.76	309.69	1562906.0
2023-05-11 14:00:00	MSFT	Stock	309.695	311.12	309.46	310.51	1614398.0
2023-05-11 15:00:00	MSFT	Stock	310.49	310.75	309.68	310.09	2392197.0
2023-05-11 16:00:00	MSFT	Stock	310.07	310.21	309.55	309.99	3132508.0
2023-05-11 17:00:00	MSFT	Stock	309.97	310.0399	309.76	309.97	6895.0
2023-05-11 18:00:00	MSFT	Stock	309.89	310.25	309.89	310.05	13646.0
2023-05-11 19:00:00	MSFT	Stock	310.3	310.38	309.7501	310.2	4205.0
2023-05-11 04:00:00	NVDA	Stock	28.999	28.999	28.934	28.974	59740.0
2023-05-11 05:00:00	NVDA	Stock	28.998	29.06	28.97	29.052	45140.0
2023-05-11 06:00:00	NVDA	Stock	29.06	29.072	28.985	29.038	91200.0
2023-05-11 07:00:00	NVDA	Stock	29.038	29.04	28.931	28.965	353940.0
2023-05-11 08:00:00	NVDA	Stock	28.994	29.06	28.885	28.985	851790.0
2023-05-11 09:00:00	NVDA	Stock	28.985	29.0	28.512	28.5441	32065090.0
2023-05-11 10:00:00	NVDA	Stock	28.546	28.622	28.246	28.408	63154780.0
2023-05-11 11:00:00	NVDA	Stock	28.409	28.674	28.378	28.651	39160730.0
2023-05-11 12:00:00	NVDA	Stock	28.652	28.721	28.573	28.62	26946680.0
2023-05-11 13:00:00	NVDA	Stock	28.623	28.657	28.413	28.529	27949880.0
2023-05-11 14:00:00	NVDA	Stock	28.531	28.63	28.4975	28.608	19890980.0
2023-05-11 15:00:00	NVDA	Stock	28.606	28.64	28.5	28.581	23862920.0
2023-05-11 16:00:00	NVDA	Stock	28.578	28.6	28.563	28.592	14119650.0
2023-05-11 17:00:00	NVDA	Stock	28.599	28.613	28.5291	28.583	326870.0
2023-05-11 18:00:00	NVDA	Stock	28.575	28.635	28.575	28.635	138850.0
2023-05-11 19:00:00	NVDA	Stock	28.622	28.645	28.605	28.644	187780.0
2023-05-11 04:00:00	AMZN	Stock	110.36	111.5	110.25	110.42	15559.0
2023-05-11 05:00:00	AMZN	Stock	110.5	110.69	110.45	110.69	18356.0

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

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