PREVIEW / stock_1hour / 2023-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-04.parquet
  size:    1.3 MB
  rows:    59,706
  symbols: 1,738

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-04-04 04:00:00	AAPL	Stock	165.91	166.1	165.8	166.1	13408.0
2023-04-04 05:00:00	AAPL	Stock	166.09	166.98	166.09	166.92	12130.0
2023-04-04 06:00:00	AAPL	Stock	166.89	167.0	166.72	166.77	12022.0
2023-04-04 07:00:00	AAPL	Stock	166.77	166.9	166.65	166.74	46196.0
2023-04-04 08:00:00	AAPL	Stock	166.85	166.9	165.33	166.5663	113473.0
2023-04-04 09:00:00	AAPL	Stock	166.54	166.7	165.418	166.29	5253454.0
2023-04-04 10:00:00	AAPL	Stock	166.3	166.84	165.89	166.108	6035555.0
2023-04-04 11:00:00	AAPL	Stock	166.1101	166.4156	165.75	166.18	4533437.0
2023-04-04 12:00:00	AAPL	Stock	166.18	166.29	165.5901	165.94	3725496.0
2023-04-04 13:00:00	AAPL	Stock	165.94	166.23	165.715	166.0109	2696494.0
2023-04-04 14:00:00	AAPL	Stock	166.01	166.1099	165.33	165.41	2734841.0
2023-04-04 15:00:00	AAPL	Stock	165.415	165.66	165.11	165.65	6021410.0
2023-04-04 16:00:00	AAPL	Stock	165.65	165.67	165.53	165.64	6870984.0
2023-04-04 17:00:00	AAPL	Stock	165.61	165.64	165.52	165.52	13072.0
2023-04-04 18:00:00	AAPL	Stock	165.57	165.68	165.53	165.64	9216.0
2023-04-04 19:00:00	AAPL	Stock	165.6	165.85	165.6	165.79	23527.0
2023-04-04 04:00:00	MSFT	Stock	287.07	287.42	287.06	287.29	3029.0
2023-04-04 05:00:00	MSFT	Stock	287.27	289.77	287.27	289.77	4595.0
2023-04-04 06:00:00	MSFT	Stock	289.4	289.63	289.2	289.31	8827.0
2023-04-04 07:00:00	MSFT	Stock	289.05	289.88	289.05	289.3	44716.0
2023-04-04 08:00:00	MSFT	Stock	289.48	289.8879	285.74	288.32	61535.0
2023-04-04 09:00:00	MSFT	Stock	288.26	289.62	286.33	288.69	2745654.0
2023-04-04 10:00:00	MSFT	Stock	288.69	290.4499	288.3159	289.14	3695595.0
2023-04-04 11:00:00	MSFT	Stock	289.13	289.6101	287.77	289.07	2709714.0
2023-04-04 12:00:00	MSFT	Stock	289.09	289.2	287.825	288.05	1569581.0
2023-04-04 13:00:00	MSFT	Stock	288.06	288.46	287.6	287.88	1425539.0
2023-04-04 14:00:00	MSFT	Stock	287.87	288.05	286.1	286.19	1537972.0
2023-04-04 15:00:00	MSFT	Stock	286.17	287.28	285.67	287.24	3031766.0
2023-04-04 16:00:00	MSFT	Stock	287.25	287.48	286.85	287.22	3570978.0
2023-04-04 17:00:00	MSFT	Stock	287.27	287.27	287.1	287.2	2565.0
2023-04-04 18:00:00	MSFT	Stock	287.2	287.52	287.17	287.4	9657.0
2023-04-04 19:00:00	MSFT	Stock	287.4	287.88	287.2	287.87	9761.0
2023-04-04 04:00:00	NVDA	Stock	27.922	27.951	27.84	27.95	136360.0
2023-04-04 05:00:00	NVDA	Stock	27.965	28.1	27.965	28.095	200290.0
2023-04-04 06:00:00	NVDA	Stock	28.086	28.112	28.05	28.052	112570.0
2023-04-04 07:00:00	NVDA	Stock	28.069	28.135	28.035	28.103	399970.0
2023-04-04 08:00:00	NVDA	Stock	27.905	28.1339	27.795	28.0223	1248270.0
2023-04-04 09:00:00	NVDA	Stock	28.03	28.043	27.488	27.6508	47645540.0
2023-04-04 10:00:00	NVDA	Stock	27.65	27.802	27.5565	27.7511	58438020.0
2023-04-04 11:00:00	NVDA	Stock	27.7548	27.758	27.5	27.6735	38643590.0
2023-04-04 12:00:00	NVDA	Stock	27.675	27.745	27.534	27.6939	27810400.0
2023-04-04 13:00:00	NVDA	Stock	27.695	27.74	27.597	27.691	19971780.0
2023-04-04 14:00:00	NVDA	Stock	27.689	27.747	27.451	27.4745	30555910.0
2023-04-04 15:00:00	NVDA	Stock	27.4728	27.531	27.307	27.472	45434570.0
2023-04-04 16:00:00	NVDA	Stock	27.453	27.473	27.44	27.473	19249560.0
2023-04-04 17:00:00	NVDA	Stock	27.472	27.472	27.362	27.38	609400.0
2023-04-04 18:00:00	NVDA	Stock	27.385	27.41	27.363	27.4	260190.0
2023-04-04 19:00:00	NVDA	Stock	27.398	27.44	27.388	27.4	286770.0
2023-04-04 04:00:00	AMZN	Stock	102.2	102.5	102.2	102.5	2771.0
2023-04-04 05:00:00	AMZN	Stock	102.54	103.1	102.3	103.1	16731.0

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

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