PREVIEW / stock_1hour / 2024-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-01-09.parquet
  size:    1.3 MB
  rows:    59,135
  symbols: 1,175

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
2024-01-09 04:00:00	AAPL	Stock	185.34	185.34	184.85	185.09	19893.0
2024-01-09 05:00:00	AAPL	Stock	185.1	185.1	184.98	185.01	8508.0
2024-01-09 06:00:00	AAPL	Stock	185.0	185.0	184.71	184.72	4862.0
2024-01-09 07:00:00	AAPL	Stock	184.76	184.8	184.16	184.55	48880.0
2024-01-09 08:00:00	AAPL	Stock	184.8	186.43	183.7	183.835	188706.0
2024-01-09 09:00:00	AAPL	Stock	183.87	184.23	182.73	183.27	5325412.0
2024-01-09 10:00:00	AAPL	Stock	183.255	183.98	182.97	183.4925	4561748.0
2024-01-09 11:00:00	AAPL	Stock	183.49	184.8	183.49	184.79	3793114.0
2024-01-09 12:00:00	AAPL	Stock	184.795	184.83	184.375	184.72	2384465.0
2024-01-09 13:00:00	AAPL	Stock	184.72	184.92	184.04	184.48	2816391.0
2024-01-09 14:00:00	AAPL	Stock	184.49	184.685	184.215	184.6102	2451151.0
2024-01-09 15:00:00	AAPL	Stock	184.62	185.15	184.41	185.13	6297815.0
2024-01-09 16:00:00	AAPL	Stock	185.12	185.56	185.03	185.23	7043235.0
2024-01-09 17:00:00	AAPL	Stock	185.2	185.28	185.2	185.23	15831.0
2024-01-09 18:00:00	AAPL	Stock	185.23	185.48	185.15	185.48	14482.0
2024-01-09 19:00:00	AAPL	Stock	185.47	185.5	185.33	185.41	16504.0
2024-01-09 04:00:00	MSFT	Stock	374.2	374.2	373.49	373.72	3811.0
2024-01-09 05:00:00	MSFT	Stock	373.54	373.8	372.0	373.08	18093.0
2024-01-09 06:00:00	MSFT	Stock	373.0	373.0	372.56	372.66	7978.0
2024-01-09 07:00:00	MSFT	Stock	372.87	374.24	372.87	373.55	15393.0
2024-01-09 08:00:00	MSFT	Stock	372.8695	375.25	372.25	372.35	45708.0
2024-01-09 09:00:00	MSFT	Stock	372.38	373.2638	371.4175	371.94	1709611.0
2024-01-09 10:00:00	MSFT	Stock	371.9	374.51	371.19	373.58	2394745.0
2024-01-09 11:00:00	MSFT	Stock	373.58	375.7	373.47	375.69	1247076.0
2024-01-09 12:00:00	MSFT	Stock	375.69	375.77	375.06	375.5804	1089623.0
2024-01-09 13:00:00	MSFT	Stock	375.6	375.99	374.34	375.21	1046586.0
2024-01-09 14:00:00	MSFT	Stock	375.23	375.61	374.92	375.31	764329.0
2024-01-09 15:00:00	MSFT	Stock	375.3	375.8	374.3	375.78	2203265.0
2024-01-09 16:00:00	MSFT	Stock	375.78	376.0	374.96	375.76	3666286.0
2024-01-09 17:00:00	MSFT	Stock	375.84	375.88	375.65	375.88	6915.0
2024-01-09 18:00:00	MSFT	Stock	375.51	375.94	375.5025	375.94	6109.0
2024-01-09 19:00:00	MSFT	Stock	376.0	376.39	375.9	375.9	5480.0
2024-01-09 04:00:00	NVDA	Stock	52.49	52.597	52.153	52.484	322790.0
2024-01-09 05:00:00	NVDA	Stock	52.48	52.495	52.33	52.331	131530.0
2024-01-09 06:00:00	NVDA	Stock	52.354	52.354	52.217	52.244	134810.0
2024-01-09 07:00:00	NVDA	Stock	52.244	52.823	52.237	52.815	2003570.0
2024-01-09 08:00:00	NVDA	Stock	52.31	52.832	52.25	52.388	5858360.0
2024-01-09 09:00:00	NVDA	Stock	52.39	52.542	51.69	52.305	86409030.0
2024-01-09 10:00:00	NVDA	Stock	52.291	52.6199	52.08	52.384	86115670.0
2024-01-09 11:00:00	NVDA	Stock	52.376	53.445	52.36	53.3266	89310040.0
2024-01-09 12:00:00	NVDA	Stock	53.332	53.8	53.249	53.789	74137990.0
2024-01-09 13:00:00	NVDA	Stock	53.78	54.072	53.73	53.9945	77148570.0
2024-01-09 14:00:00	NVDA	Stock	53.985	54.325	53.85	53.9756	69135920.0
2024-01-09 15:00:00	NVDA	Stock	53.984	54.0105	53.0182	53.131	94717700.0
2024-01-09 16:00:00	NVDA	Stock	53.14	53.199	53.083	53.154	20304710.0
2024-01-09 17:00:00	NVDA	Stock	53.17	53.19	53.08	53.159	432740.0
2024-01-09 18:00:00	NVDA	Stock	53.166	53.233	53.13	53.229	380430.0
2024-01-09 19:00:00	NVDA	Stock	53.229	53.28	53.214	53.254	610580.0
2024-01-09 04:00:00	AMZN	Stock	149.07	149.07	148.54	149.0	19230.0
2024-01-09 05:00:00	AMZN	Stock	148.95	149.1	148.85	148.85	7056.0

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

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