PREVIEW / stock_1hour / 2023-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-09.parquet
  size:    1.4 MB
  rows:    62,298
  symbols: 1,965

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-09 04:00:00	AAPL	Stock	129.6	130.5	129.6	130.29	43587.0
2023-01-09 05:00:00	AAPL	Stock	130.26	130.5	130.15	130.25	15983.0
2023-01-09 06:00:00	AAPL	Stock	130.21	130.35	130.02	130.22	18072.0
2023-01-09 07:00:00	AAPL	Stock	130.25	130.4	130.16	130.25	95717.0
2023-01-09 08:00:00	AAPL	Stock	130.2	130.63	129.955	130.2	293573.0
2023-01-09 09:00:00	AAPL	Stock	130.24	132.06	130.13	132.015	8677040.0
2023-01-09 10:00:00	AAPL	Stock	132.01	133.14	131.96	132.74	11188066.0
2023-01-09 11:00:00	AAPL	Stock	132.74	133.41	132.67	132.945	7586359.0
2023-01-09 12:00:00	AAPL	Stock	132.94	132.955	132.25	132.459	4845429.0
2023-01-09 13:00:00	AAPL	Stock	132.46	132.64	131.19	131.395	6056020.0
2023-01-09 14:00:00	AAPL	Stock	131.39	131.726	130.59	130.67	6654395.0
2023-01-09 15:00:00	AAPL	Stock	130.68	130.82	129.89	130.19	8460822.0
2023-01-09 16:00:00	AAPL	Stock	130.19	131.709	130.04	130.1	7160513.0
2023-01-09 17:00:00	AAPL	Stock	130.12	130.12	130.03	130.04	23168.0
2023-01-09 18:00:00	AAPL	Stock	130.05	130.07	129.95	130.04	52912.0
2023-01-09 19:00:00	AAPL	Stock	130.01	130.04	129.76	129.85	71626.0
2023-01-09 04:00:00	MSFT	Stock	225.16	226.1	225.16	226.05	6323.0
2023-01-09 05:00:00	MSFT	Stock	225.88	226.2	225.74	226.2	8860.0
2023-01-09 06:00:00	MSFT	Stock	226.0	226.3	225.7	225.85	8002.0
2023-01-09 07:00:00	MSFT	Stock	225.85	226.2	225.72	226.1	12156.0
2023-01-09 08:00:00	MSFT	Stock	225.8	226.72	225.63	226.15	57038.0
2023-01-09 09:00:00	MSFT	Stock	226.16	229.05	225.6794	228.97	2608174.0
2023-01-09 10:00:00	MSFT	Stock	228.98	230.23	228.172	229.4899	2952662.0
2023-01-09 11:00:00	MSFT	Stock	229.49	231.2366	229.49	230.33	2496835.0
2023-01-09 12:00:00	MSFT	Stock	230.33	230.92	230.02	230.73	1859248.0
2023-01-09 13:00:00	MSFT	Stock	230.72	230.94	228.72	229.1774	1725796.0
2023-01-09 14:00:00	MSFT	Stock	229.16	229.98	227.775	227.92	1706143.0
2023-01-09 15:00:00	MSFT	Stock	227.94	228.21	226.77	227.15	3182918.0
2023-01-09 16:00:00	MSFT	Stock	227.15	227.27	226.86	227.09	3928322.0
2023-01-09 17:00:00	MSFT	Stock	227.05	227.0865	226.9	226.93	9003.0
2023-01-09 18:00:00	MSFT	Stock	226.9	227.0	226.78	226.85	13727.0
2023-01-09 19:00:00	MSFT	Stock	227.0	227.0	226.09	226.16	25198.0
2023-01-09 04:00:00	NVDA	Stock	14.859	15.09	14.859	15.069	227490.0
2023-01-09 05:00:00	NVDA	Stock	15.069	15.1	15.069	15.085	107930.0
2023-01-09 06:00:00	NVDA	Stock	15.095	15.119	15.062	15.078	73990.0
2023-01-09 07:00:00	NVDA	Stock	15.075	15.13	15.072	15.112	372640.0
2023-01-09 08:00:00	NVDA	Stock	15.0874	15.241	15.035	15.207	1179160.0
2023-01-09 09:00:00	NVDA	Stock	15.1938	15.772	15.141	15.714	68321080.0
2023-01-09 10:00:00	NVDA	Stock	15.714	15.988	15.714	15.8933	82498460.0
2023-01-09 11:00:00	NVDA	Stock	15.894	16.056	15.875	15.9846	49126740.0
2023-01-09 12:00:00	NVDA	Stock	15.985	16.019	15.913	16.0061	40860330.0
2023-01-09 13:00:00	NVDA	Stock	16.006	16.0337	15.779	15.8443	42774190.0
2023-01-09 14:00:00	NVDA	Stock	15.842	15.984	15.79	15.811	45273070.0
2023-01-09 15:00:00	NVDA	Stock	15.813	15.833	15.575	15.638	63985660.0
2023-01-09 16:00:00	NVDA	Stock	15.638	15.66	15.6034	15.66	22121960.0
2023-01-09 17:00:00	NVDA	Stock	15.66	15.66	15.63	15.638	187590.0
2023-01-09 18:00:00	NVDA	Stock	15.636	15.639	15.61	15.61	178830.0
2023-01-09 19:00:00	NVDA	Stock	15.62	15.625	15.57	15.589	102450.0
2023-01-09 04:00:00	AMZN	Stock	86.51	86.9	86.29	86.76	25577.0
2023-01-09 05:00:00	AMZN	Stock	86.64	86.77	86.55	86.57	21092.0

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

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