PREVIEW / stock_1hour / 2023-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-10.parquet
  size:    1.4 MB
  rows:    61,127
  symbols: 1,904

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-10 04:00:00	AAPL	Stock	130.02	130.28	129.84	130.13	33916.0
2023-01-10 05:00:00	AAPL	Stock	130.17	130.5	130.1	130.5	11604.0
2023-01-10 06:00:00	AAPL	Stock	130.44	130.46	130.01	130.12	22098.0
2023-01-10 07:00:00	AAPL	Stock	130.12	130.12	129.32	129.75	69417.0
2023-01-10 08:00:00	AAPL	Stock	130.0334	130.4385	129.3	129.85	189317.0
2023-01-10 09:00:00	AAPL	Stock	129.88	131.2636	129.51	129.99	8042778.0
2023-01-10 10:00:00	AAPL	Stock	129.99	130.8367	128.12	129.09	11291600.0
2023-01-10 11:00:00	AAPL	Stock	129.1	129.23	128.66	128.88	6805498.0
2023-01-10 12:00:00	AAPL	Stock	128.87	129.86	128.45	129.73	5505152.0
2023-01-10 13:00:00	AAPL	Stock	129.73	130.27	129.42	130.225	6357684.0
2023-01-10 14:00:00	AAPL	Stock	130.23	130.69	129.98	130.115	5604005.0
2023-01-10 15:00:00	AAPL	Stock	130.115	130.75	129.76	130.75	7778919.0
2023-01-10 16:00:00	AAPL	Stock	130.75	130.8	130.66	130.7	4700624.0
2023-01-10 17:00:00	AAPL	Stock	130.71	130.76	130.7	130.72	23379.0
2023-01-10 18:00:00	AAPL	Stock	130.72	130.76	130.58	130.75	37302.0
2023-01-10 19:00:00	AAPL	Stock	130.75	130.99	130.75	130.97	46849.0
2023-01-10 04:00:00	MSFT	Stock	227.18	227.72	227.12	227.7	5440.0
2023-01-10 05:00:00	MSFT	Stock	227.7	228.07	227.4	228.07	4114.0
2023-01-10 06:00:00	MSFT	Stock	227.03	227.2	226.16	226.3	3451.0
2023-01-10 07:00:00	MSFT	Stock	226.5	226.7	225.72	226.65	17872.0
2023-01-10 08:00:00	MSFT	Stock	226.4453	228.639	225.8	228.6	71735.0
2023-01-10 09:00:00	MSFT	Stock	228.79	230.97	227.2	229.9	3210173.0
2023-01-10 10:00:00	MSFT	Stock	229.9	231.31	227.33	228.73	3351927.0
2023-01-10 11:00:00	MSFT	Stock	228.7201	229.54	227.66	228.23	1725859.0
2023-01-10 12:00:00	MSFT	Stock	228.21	228.9	227.47	228.2799	1404482.0
2023-01-10 13:00:00	MSFT	Stock	228.27	229.1	228.0	228.73	1496054.0
2023-01-10 14:00:00	MSFT	Stock	228.73	228.99	227.89	228.055	1450910.0
2023-01-10 15:00:00	MSFT	Stock	228.045	228.88	227.4846	228.88	2753034.0
2023-01-10 16:00:00	MSFT	Stock	228.87	228.99	228.62	228.77	4724235.0
2023-01-10 17:00:00	MSFT	Stock	228.75	228.9	228.74	228.75	56097.0
2023-01-10 18:00:00	MSFT	Stock	228.7	228.91	228.39	228.91	6190.0
2023-01-10 19:00:00	MSFT	Stock	228.88	229.35	228.85	229.2	7460.0
2023-01-10 04:00:00	NVDA	Stock	15.599	15.681	15.565	15.681	64330.0
2023-01-10 05:00:00	NVDA	Stock	15.698	15.757	15.672	15.72	41260.0
2023-01-10 06:00:00	NVDA	Stock	15.72	15.72	15.603	15.612	74450.0
2023-01-10 07:00:00	NVDA	Stock	15.628	15.632	15.42	15.481	501030.0
2023-01-10 08:00:00	NVDA	Stock	15.5747	15.64	15.4119	15.482	817410.0
2023-01-10 09:00:00	NVDA	Stock	15.497	15.905	15.455	15.715	61492900.0
2023-01-10 10:00:00	NVDA	Stock	15.7102	15.962	15.5626	15.7712	71293580.0
2023-01-10 11:00:00	NVDA	Stock	15.769	15.775	15.632	15.7095	33722900.0
2023-01-10 12:00:00	NVDA	Stock	15.71	15.748	15.636	15.674	22222020.0
2023-01-10 13:00:00	NVDA	Stock	15.671	15.7398	15.613	15.733	25468710.0
2023-01-10 14:00:00	NVDA	Stock	15.736	15.866	15.72	15.8572	36501030.0
2023-01-10 15:00:00	NVDA	Stock	15.856	15.936	15.754	15.913	49013590.0
2023-01-10 16:00:00	NVDA	Stock	15.91	15.913	15.8428	15.899	26152380.0
2023-01-10 17:00:00	NVDA	Stock	15.8924	15.905	15.891	15.9	84960.0
2023-01-10 18:00:00	NVDA	Stock	15.9	15.941	15.892	15.941	129760.0
2023-01-10 19:00:00	NVDA	Stock	15.944	15.988	15.94	15.988	342980.0
2023-01-10 04:00:00	AMZN	Stock	87.4	87.63	87.16	87.6	11360.0
2023-01-10 05:00:00	AMZN	Stock	87.61	87.71	87.53	87.71	11687.0

> showing 50 of 61,127 rows — these rows as CSV

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