PREVIEW / stock_1hour / 2004-01-21

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-21.parquet
  size:    512 KB
  rows:    23,600
  symbols: 1,720

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
2004-01-21 08:00:00	AAPL	Stock	0.4061	0.4069	0.405	0.4054	1383200.0
2004-01-21 09:00:00	AAPL	Stock	0.4041	0.4054	0.4005	0.4014	23915696.0
2004-01-21 10:00:00	AAPL	Stock	0.4013	0.4054	0.4013	0.4048	30371936.0
2004-01-21 11:00:00	AAPL	Stock	0.4046	0.4054	0.4029	0.4036	26164152.0
2004-01-21 12:00:00	AAPL	Stock	0.4036	0.4052	0.4032	0.4039	18303152.0
2004-01-21 13:00:00	AAPL	Stock	0.4041	0.4063	0.4026	0.405	16766792.0
2004-01-21 14:00:00	AAPL	Stock	0.405	0.4102	0.4038	0.4054	52356808.0
2004-01-21 15:00:00	AAPL	Stock	0.4053	0.407	0.4011	0.4029	50408064.0
2004-01-21 16:00:00	AAPL	Stock	0.4034	0.4054	0.402	0.4054	1986824.0
2004-01-21 17:00:00	AAPL	Stock	0.4054	0.4054	0.4054	0.4054	280504.0
2004-01-21 18:00:00	AAPL	Stock	0.4054	0.4054	0.4054	0.4054	140000.0
2004-01-21 08:00:00	MSFT	Stock	28.08	28.35	28.02	28.03	110081.0
2004-01-21 09:00:00	MSFT	Stock	28.02	28.17	28.0	28.06	5326456.0
2004-01-21 10:00:00	MSFT	Stock	28.05	28.08	27.85	27.94	8042077.0
2004-01-21 11:00:00	MSFT	Stock	27.949	28.091	27.92	28.03	5300735.0
2004-01-21 12:00:00	MSFT	Stock	28.03	28.18	28.0	28.15	5588178.0
2004-01-21 13:00:00	MSFT	Stock	28.16	28.2	28.08	28.18	4442003.0
2004-01-21 14:00:00	MSFT	Stock	28.18	28.3	28.16	28.22	8205161.0
2004-01-21 15:00:00	MSFT	Stock	28.22	28.3	28.08	28.29	12206526.0
2004-01-21 16:00:00	MSFT	Stock	28.3	28.31	28.118	28.29	1136887.0
2004-01-21 17:00:00	MSFT	Stock	28.28	28.32	28.26	28.3	71450.0
2004-01-21 18:00:00	MSFT	Stock	28.3	28.32	28.29	28.32	19900.0
2004-01-21 08:00:00	NVDA	Stock	0.2107	0.2107	0.2093	0.2093	132000.0
2004-01-21 09:00:00	NVDA	Stock	0.2083	0.2105	0.2024	0.2042	72304680.0
2004-01-21 10:00:00	NVDA	Stock	0.2042	0.2046	0.2017	0.2027	110600880.0
2004-01-21 11:00:00	NVDA	Stock	0.2027	0.2037	0.2023	0.2032	58182600.0
2004-01-21 12:00:00	NVDA	Stock	0.203	0.2037	0.2021	0.2023	30466320.0
2004-01-21 13:00:00	NVDA	Stock	0.2023	0.2032	0.2014	0.2022	38937000.0
2004-01-21 14:00:00	NVDA	Stock	0.2022	0.2039	0.2017	0.2036	59880360.0
2004-01-21 15:00:00	NVDA	Stock	0.2035	0.2046	0.2012	0.2018	89668560.0
2004-01-21 16:00:00	NVDA	Stock	0.2015	0.2024	0.2012	0.2015	2946960.0
2004-01-21 17:00:00	NVDA	Stock	0.2027	0.203	0.2015	0.2023	278520.0
2004-01-21 18:00:00	NVDA	Stock	0.2023	0.2023	0.2015	0.2015	648000.0
2004-01-21 08:00:00	AMZN	Stock	2.8225	2.827	2.816	2.824	56000.0
2004-01-21 09:00:00	AMZN	Stock	2.8175	2.818	2.7885	2.798	22911860.0
2004-01-21 10:00:00	AMZN	Stock	2.7975	2.7995	2.782	2.7885	20708620.0
2004-01-21 11:00:00	AMZN	Stock	2.7885	2.8115	2.782	2.8005	13512760.0
2004-01-21 12:00:00	AMZN	Stock	2.8005	2.815	2.8	2.8115	9222220.0
2004-01-21 13:00:00	AMZN	Stock	2.8125	2.815	2.799	2.812	6950660.0
2004-01-21 14:00:00	AMZN	Stock	2.812	2.847	2.8111	2.8305	21948000.0
2004-01-21 15:00:00	AMZN	Stock	2.8305	2.8405	2.795	2.81	34149120.0
2004-01-21 16:00:00	AMZN	Stock	2.81	2.844	2.781	2.812	3133940.0
2004-01-21 17:00:00	AMZN	Stock	2.8425	2.8475	2.812	2.8475	1181340.0
2004-01-21 18:00:00	AMZN	Stock	2.847	2.8495	2.846	2.847	45000.0
2004-01-21 09:00:00	CL	Stock	25.65	25.7	25.625	25.67	475600.0
2004-01-21 10:00:00	CL	Stock	25.67	25.745	25.62	25.715	645600.0
2004-01-21 11:00:00	CL	Stock	25.715	25.72	25.645	25.69	602400.0
2004-01-21 12:00:00	CL	Stock	25.695	25.705	25.635	25.64	447600.0
2004-01-21 13:00:00	CL	Stock	25.64	25.695	25.62	25.685	603000.0
2004-01-21 14:00:00	CL	Stock	25.69	25.71	25.685	25.71	462600.0

> showing 50 of 23,600 rows — these rows as CSV

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