PREVIEW / stock_1hour / 2023-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-23.parquet
  size:    1.3 MB
  rows:    59,945
  symbols: 1,830

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-02-23 04:00:00	AAPL	Stock	149.74	149.81	149.06	149.36	24841.0
2023-02-23 05:00:00	AAPL	Stock	149.35	149.38	149.2	149.38	5320.0
2023-02-23 06:00:00	AAPL	Stock	149.38	149.6	149.32	149.5	8019.0
2023-02-23 07:00:00	AAPL	Stock	149.58	149.9	149.51	149.73	59503.0
2023-02-23 08:00:00	AAPL	Stock	149.576	149.99	149.18	149.6	236429.0
2023-02-23 09:00:00	AAPL	Stock	149.66	150.34	149.366	149.58	5604077.0
2023-02-23 10:00:00	AAPL	Stock	149.58	149.79	147.6701	147.98	7137557.0
2023-02-23 11:00:00	AAPL	Stock	147.97	148.25	147.47	147.54	5011233.0
2023-02-23 12:00:00	AAPL	Stock	147.53	147.82	147.24	147.73	3372330.0
2023-02-23 13:00:00	AAPL	Stock	147.74	148.4	147.43	148.1986	3243518.0
2023-02-23 14:00:00	AAPL	Stock	148.19	149.66	148.05	149.24	4650779.0
2023-02-23 15:00:00	AAPL	Stock	149.26	149.93	149.25	149.42	6443401.0
2023-02-23 16:00:00	AAPL	Stock	149.42	149.46	149.1	149.23	5663146.0
2023-02-23 17:00:00	AAPL	Stock	149.2	149.28	149.16	149.18	11586.0
2023-02-23 18:00:00	AAPL	Stock	149.16	149.16	148.91	148.94	17504.0
2023-02-23 19:00:00	AAPL	Stock	148.94	149.18	148.94	148.95	19046.0
2023-02-23 04:00:00	MSFT	Stock	252.7	254.28	252.7	253.51	44943.0
2023-02-23 05:00:00	MSFT	Stock	253.72	254.07	253.5	253.7	7711.0
2023-02-23 06:00:00	MSFT	Stock	254.28	254.48	254.0	254.41	17053.0
2023-02-23 07:00:00	MSFT	Stock	254.51	254.51	253.66	254.01	28477.0
2023-02-23 08:00:00	MSFT	Stock	254.38	254.57	253.15	254.32	99350.0
2023-02-23 09:00:00	MSFT	Stock	254.32	256.84	254.22	256.35	3112124.0
2023-02-23 10:00:00	MSFT	Stock	256.37	256.61	253.04	253.07	2871033.0
2023-02-23 11:00:00	MSFT	Stock	253.07	253.69	251.26	251.3	2729733.0
2023-02-23 12:00:00	MSFT	Stock	251.33	251.96	251.14	251.62	1672914.0
2023-02-23 13:00:00	MSFT	Stock	251.61	252.05	250.48	251.8804	1913304.0
2023-02-23 14:00:00	MSFT	Stock	251.8761	254.5	251.68	253.85	2076584.0
2023-02-23 15:00:00	MSFT	Stock	253.8738	255.59	253.8701	254.83	3368330.0
2023-02-23 16:00:00	MSFT	Stock	254.79	255.01	254.52	254.92	3954414.0
2023-02-23 17:00:00	MSFT	Stock	254.89	255.19	254.77	255.19	10610.0
2023-02-23 18:00:00	MSFT	Stock	255.12	255.29	254.55	254.6	14711.0
2023-02-23 19:00:00	MSFT	Stock	254.53	255.29	254.5	254.9	10537.0
2023-02-23 04:00:00	NVDA	Stock	22.58	22.6	22.34	22.365	1407610.0
2023-02-23 05:00:00	NVDA	Stock	22.382	22.468	22.373	22.39	557100.0
2023-02-23 06:00:00	NVDA	Stock	22.392	22.517	22.392	22.515	487630.0
2023-02-23 07:00:00	NVDA	Stock	22.51	22.963	22.505	22.885	5538190.0
2023-02-23 08:00:00	NVDA	Stock	22.741	23.423	22.4382	23.362	22397600.0
2023-02-23 09:00:00	NVDA	Stock	23.37	23.8247	23.025	23.715	222222540.0
2023-02-23 10:00:00	NVDA	Stock	23.715	23.888	23.481	23.5465	182544340.0
2023-02-23 11:00:00	NVDA	Stock	23.547	23.641	23.155	23.2695	114888640.0
2023-02-23 12:00:00	NVDA	Stock	23.277	23.538	23.261	23.4187	77143390.0
2023-02-23 13:00:00	NVDA	Stock	23.421	23.737	23.284	23.6775	62660380.0
2023-02-23 14:00:00	NVDA	Stock	23.675	23.8	23.575	23.6571	73333620.0
2023-02-23 15:00:00	NVDA	Stock	23.66	23.777	23.582	23.658	102322070.0
2023-02-23 16:00:00	NVDA	Stock	23.653	23.711	23.62	23.64	27346450.0
2023-02-23 17:00:00	NVDA	Stock	23.644	23.666	23.644	23.651	949210.0
2023-02-23 18:00:00	NVDA	Stock	23.651	23.665	23.606	23.61	429320.0
2023-02-23 19:00:00	NVDA	Stock	23.61	23.664	23.605	23.662	593720.0
2023-02-23 04:00:00	AMZN	Stock	96.36	96.69	95.7	96.2	18190.0
2023-02-23 05:00:00	AMZN	Stock	96.18	96.22	96.0	96.22	9964.0

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

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