PREVIEW / stock_1hour / 2023-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-24.parquet
  size:    1.3 MB
  rows:    60,769
  symbols: 1,641

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-24 04:00:00	AAPL	Stock	171.49	171.49	171.08	171.32	23657.0
2023-05-24 05:00:00	AAPL	Stock	171.25	171.44	171.25	171.34	6074.0
2023-05-24 06:00:00	AAPL	Stock	171.21	171.33	170.87	170.95	28640.0
2023-05-24 07:00:00	AAPL	Stock	170.98	171.15	170.41	170.5	75487.0
2023-05-24 08:00:00	AAPL	Stock	171.0983	171.57	170.2232	170.3	144632.0
2023-05-24 09:00:00	AAPL	Stock	170.27	172.27	170.07	171.835	5700661.0
2023-05-24 10:00:00	AAPL	Stock	171.84	171.9199	170.97	171.26	5099117.0
2023-05-24 11:00:00	AAPL	Stock	171.255	171.68	170.765	171.0	4013149.0
2023-05-24 12:00:00	AAPL	Stock	171.005	171.32	170.535	171.1	2881703.0
2023-05-24 13:00:00	AAPL	Stock	171.1	171.78	170.85	171.6227	3118079.0
2023-05-24 14:00:00	AAPL	Stock	171.63	171.8	171.03	171.33	3004018.0
2023-05-24 15:00:00	AAPL	Stock	171.33	172.4183	171.15	171.85	6645974.0
2023-05-24 16:00:00	AAPL	Stock	171.84	172.44	170.81	171.57	4369252.0
2023-05-24 17:00:00	AAPL	Stock	171.55	171.73	171.25	171.61	156292.0
2023-05-24 18:00:00	AAPL	Stock	171.61	171.69	171.0	171.04	121672.0
2023-05-24 19:00:00	AAPL	Stock	171.18	171.18	170.84	171.0	71207.0
2023-05-24 04:00:00	MSFT	Stock	315.0	315.2	314.5	315.2	6455.0
2023-05-24 05:00:00	MSFT	Stock	315.4	315.79	315.21	315.42	3759.0
2023-05-24 06:00:00	MSFT	Stock	315.5	315.82	314.73	314.79	4600.0
2023-05-24 07:00:00	MSFT	Stock	315.0	315.26	314.35	314.51	18144.0
2023-05-24 08:00:00	MSFT	Stock	314.9	315.5	313.47	313.47	61154.0
2023-05-24 09:00:00	MSFT	Stock	313.46	316.5	313.35	315.69	2474991.0
2023-05-24 10:00:00	MSFT	Stock	315.65	315.7	312.65	313.13	2602290.0
2023-05-24 11:00:00	MSFT	Stock	313.145	314.06	312.66	313.31	1744278.0
2023-05-24 12:00:00	MSFT	Stock	313.32	313.81	312.61	313.35	1245012.0
2023-05-24 13:00:00	MSFT	Stock	313.36	314.65	313.05	314.52	1056633.0
2023-05-24 14:00:00	MSFT	Stock	314.56	314.89	313.47	313.65	1158578.0
2023-05-24 15:00:00	MSFT	Stock	313.65	315.3218	313.395	313.85	2903316.0
2023-05-24 16:00:00	MSFT	Stock	313.85	319.88	312.94	319.0	2783881.0
2023-05-24 17:00:00	MSFT	Stock	318.99	321.25	318.08	320.61	219078.0
2023-05-24 18:00:00	MSFT	Stock	320.65	320.65	318.2	318.69	80235.0
2023-05-24 19:00:00	MSFT	Stock	318.6	319.6	318.4	319.12	50228.0
2023-05-24 04:00:00	NVDA	Stock	30.451	30.626	30.451	30.545	115450.0
2023-05-24 05:00:00	NVDA	Stock	30.577	30.58	30.42	30.445	182280.0
2023-05-24 06:00:00	NVDA	Stock	30.448	30.468	30.367	30.427	134990.0
2023-05-24 07:00:00	NVDA	Stock	30.427	30.45	30.261	30.34	1376790.0
2023-05-24 08:00:00	NVDA	Stock	30.434	30.827	30.226	30.257	1930890.0
2023-05-24 09:00:00	NVDA	Stock	30.255	30.319	30.025	30.172	53514740.0
2023-05-24 10:00:00	NVDA	Stock	30.173	30.235	29.806	29.867	67385690.0
2023-05-24 11:00:00	NVDA	Stock	29.862	30.065	29.806	29.9745	44322830.0
2023-05-24 12:00:00	NVDA	Stock	29.9771	30.12	29.9126	30.0	30745950.0
2023-05-24 13:00:00	NVDA	Stock	30.0	30.069	29.8881	30.0639	28229680.0
2023-05-24 14:00:00	NVDA	Stock	30.063	30.225	29.993	30.0425	39705740.0
2023-05-24 15:00:00	NVDA	Stock	30.0425	30.607	29.981	30.541	104801820.0
2023-05-24 16:00:00	NVDA	Stock	30.546	37.0	30.1714	36.7	89914370.0
2023-05-24 17:00:00	NVDA	Stock	36.7019	39.5	36.699	38.652	51183520.0
2023-05-24 18:00:00	NVDA	Stock	38.674	38.999	37.66	37.9	19614710.0
2023-05-24 19:00:00	NVDA	Stock	37.92	38.449	37.7	38.06	12965140.0
2023-05-24 04:00:00	AMZN	Stock	115.17	115.58	114.8	115.58	26660.0
2023-05-24 05:00:00	AMZN	Stock	115.55	115.79	115.52	115.57	14895.0

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

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