PREVIEW / stock_1hour / 2023-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-23.parquet
  size:    1.4 MB
  rows:    62,654
  symbols: 1,961

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-01-23 04:00:00	AAPL	Stock	138.5	138.5	137.56	137.73	24927.0
2023-01-23 05:00:00	AAPL	Stock	137.74	137.83	137.22	137.41	26033.0
2023-01-23 06:00:00	AAPL	Stock	137.39	137.6	137.3	137.42	13463.0
2023-01-23 07:00:00	AAPL	Stock	137.54	138.13	137.41	137.87	74743.0
2023-01-23 08:00:00	AAPL	Stock	137.5135	138.44	137.4285	138.03	244107.0
2023-01-23 09:00:00	AAPL	Stock	138.06	140.0	137.8	139.87	8456156.0
2023-01-23 10:00:00	AAPL	Stock	139.88	141.48	139.57	141.2152	10986286.0
2023-01-23 11:00:00	AAPL	Stock	141.21	143.315	141.12	142.9	12669369.0
2023-01-23 12:00:00	AAPL	Stock	142.9	142.9	141.94	142.16	7106221.0
2023-01-23 13:00:00	AAPL	Stock	142.15	142.49	141.88	141.95	6275523.0
2023-01-23 14:00:00	AAPL	Stock	141.96	141.98	140.614	140.98	7216192.0
2023-01-23 15:00:00	AAPL	Stock	140.98	141.26	140.36	141.1	10338470.0
2023-01-23 16:00:00	AAPL	Stock	141.09	141.1782	140.9	141.13	6900822.0
2023-01-23 17:00:00	AAPL	Stock	141.1008	141.14	141.07	141.1	39339.0
2023-01-23 18:00:00	AAPL	Stock	141.11	141.13	140.97	141.05	26615.0
2023-01-23 19:00:00	AAPL	Stock	141.03	141.13	141.0	141.11	22238.0
2023-01-23 04:00:00	MSFT	Stock	240.5	240.69	240.3	240.3	7089.0
2023-01-23 05:00:00	MSFT	Stock	240.4	240.6	239.75	240.41	4536.0
2023-01-23 06:00:00	MSFT	Stock	240.55	240.55	239.75	239.75	4712.0
2023-01-23 07:00:00	MSFT	Stock	240.03	240.61	239.88	240.38	27438.0
2023-01-23 08:00:00	MSFT	Stock	240.0	241.42	239.62	240.9704	124639.0
2023-01-23 09:00:00	MSFT	Stock	241.06	242.56	239.65	241.55	3484139.0
2023-01-23 10:00:00	MSFT	Stock	241.6	243.37	240.58	242.62	3064038.0
2023-01-23 11:00:00	MSFT	Stock	242.63	245.165	242.63	244.59	2571893.0
2023-01-23 12:00:00	MSFT	Stock	244.59	244.59	243.62	244.205	2238740.0
2023-01-23 13:00:00	MSFT	Stock	244.21	244.51	243.73	243.77	1772657.0
2023-01-23 14:00:00	MSFT	Stock	243.77	243.87	241.63	242.53	2182094.0
2023-01-23 15:00:00	MSFT	Stock	242.52	243.06	242.03	242.52	3777329.0
2023-01-23 16:00:00	MSFT	Stock	242.5	242.82	242.46	242.68	4727164.0
2023-01-23 17:00:00	MSFT	Stock	242.77	242.8	242.58	242.6201	17455.0
2023-01-23 18:00:00	MSFT	Stock	242.67	242.8	242.0	242.3999	16461.0
2023-01-23 19:00:00	MSFT	Stock	242.4	242.7	242.3	242.6	20108.0
2023-01-23 04:00:00	NVDA	Stock	17.874	18.1	17.874	18.1	143330.0
2023-01-23 05:00:00	NVDA	Stock	18.111	18.116	18.02	18.051	113420.0
2023-01-23 06:00:00	NVDA	Stock	18.035	18.11	18.03	18.063	137500.0
2023-01-23 07:00:00	NVDA	Stock	18.063	18.163	18.045	18.077	533670.0
2023-01-23 08:00:00	NVDA	Stock	18.051	18.163	18.036	18.0857	1698480.0
2023-01-23 09:00:00	NVDA	Stock	18.0866	18.54	17.8175	18.5015	89000820.0
2023-01-23 10:00:00	NVDA	Stock	18.501	18.88	18.482	18.807	104360310.0
2023-01-23 11:00:00	NVDA	Stock	18.808	19.0	18.796	18.9775	78360660.0
2023-01-23 12:00:00	NVDA	Stock	18.98	18.997	18.871	18.986	43989730.0
2023-01-23 13:00:00	NVDA	Stock	18.9875	19.245	18.961	19.1845	56503540.0
2023-01-23 14:00:00	NVDA	Stock	19.1827	19.225	18.9216	19.0225	62268110.0
2023-01-23 15:00:00	NVDA	Stock	19.0235	19.229	18.902	19.185	83770220.0
2023-01-23 16:00:00	NVDA	Stock	19.193	19.24	19.169	19.23	27793650.0
2023-01-23 17:00:00	NVDA	Stock	19.236	19.239	19.193	19.217	590860.0
2023-01-23 18:00:00	NVDA	Stock	19.217	19.238	19.209	19.218	408130.0
2023-01-23 19:00:00	NVDA	Stock	19.218	19.218	19.2	19.202	280230.0
2023-01-23 04:00:00	AMZN	Stock	97.1	97.6	97.01	97.3	22707.0
2023-01-23 05:00:00	AMZN	Stock	97.32	97.32	97.1	97.16	11229.0

> showing 50 of 62,654 rows — these rows as CSV

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