PREVIEW / stock_1hour / 2005-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-02-02.parquet
  size:    542 KB
  rows:    25,583
  symbols: 1,920

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
2005-02-02 08:00:00	AAPL	Stock	1.3964	1.3982	1.3911	1.3936	1900808.0
2005-02-02 09:00:00	AAPL	Stock	1.3939	1.397	1.3873	1.3888	108654224.0
2005-02-02 10:00:00	AAPL	Stock	1.3884	1.4213	1.3884	1.4209	236900104.0
2005-02-02 11:00:00	AAPL	Stock	1.4205	1.4252	1.415	1.4227	144235056.0
2005-02-02 12:00:00	AAPL	Stock	1.4229	1.4268	1.4154	1.4219	100059400.0
2005-02-02 13:00:00	AAPL	Stock	1.4214	1.425	1.4184	1.4198	68281192.0
2005-02-02 14:00:00	AAPL	Stock	1.4198	1.427	1.4114	1.415	148762096.0
2005-02-02 15:00:00	AAPL	Stock	1.415	1.4243	1.402	1.4214	204581272.0
2005-02-02 16:00:00	AAPL	Stock	1.422	1.4221	1.4122	1.4161	2752008.0
2005-02-02 17:00:00	AAPL	Stock	1.4163	1.422	1.4152	1.4182	4411792.0
2005-02-02 18:00:00	AAPL	Stock	1.417	1.417	1.4161	1.4161	78400.0
2005-02-02 08:00:00	MSFT	Stock	26.4	26.48	26.4	26.45	14150.0
2005-02-02 09:00:00	MSFT	Stock	26.44	26.48	26.29	26.32	9967112.0
2005-02-02 10:00:00	MSFT	Stock	26.319	26.47	26.28	26.42	17806524.0
2005-02-02 11:00:00	MSFT	Stock	26.41	26.47	26.35	26.4	8609263.0
2005-02-02 12:00:00	MSFT	Stock	26.4	26.41	26.36	26.41	6383982.0
2005-02-02 13:00:00	MSFT	Stock	26.41	26.42	26.34	26.37	6204600.0
2005-02-02 14:00:00	MSFT	Stock	26.38	26.42	26.31	26.37	11074295.0
2005-02-02 15:00:00	MSFT	Stock	26.37	26.5	26.28	26.47	16343071.0
2005-02-02 16:00:00	MSFT	Stock	26.47	26.48	26.379	26.43	589937.0
2005-02-02 17:00:00	MSFT	Stock	26.43	26.48	26.42	26.43	1051796.0
2005-02-02 18:00:00	MSFT	Stock	26.42	26.42	26.4	26.4	1030.0
2005-02-02 08:00:00	NVDA	Stock	0.2033	0.2056	0.2015	0.205	38919720.0
2005-02-02 09:00:00	NVDA	Stock	0.2046	0.2052	0.1965	0.2019	618804120.0
2005-02-02 10:00:00	NVDA	Stock	0.2019	0.2023	0.1987	0.2012	365224920.0
2005-02-02 11:00:00	NVDA	Stock	0.2012	0.2023	0.2008	0.2011	147203400.0
2005-02-02 12:00:00	NVDA	Stock	0.201	0.2021	0.2	0.2012	106026240.0
2005-02-02 13:00:00	NVDA	Stock	0.2013	0.202	0.2012	0.2017	40085400.0
2005-02-02 14:00:00	NVDA	Stock	0.2017	0.207	0.2004	0.2057	332004360.0
2005-02-02 15:00:00	NVDA	Stock	0.2056	0.2065	0.2034	0.2057	366554160.0
2005-02-02 16:00:00	NVDA	Stock	0.2055	0.2057	0.2024	0.2054	6678960.0
2005-02-02 17:00:00	NVDA	Stock	0.2046	0.2054	0.2042	0.2054	798000.0
2005-02-02 18:00:00	NVDA	Stock	0.2042	0.2045	0.2042	0.2045	36000.0
2005-02-02 08:00:00	AMZN	Stock	2.16	2.165	2.152	2.1535	399500.0
2005-02-02 09:00:00	AMZN	Stock	2.1525	2.1795	2.0775	2.08	52183820.0
2005-02-02 10:00:00	AMZN	Stock	2.08	2.1175	2.043	2.1055	97048380.0
2005-02-02 11:00:00	AMZN	Stock	2.1055	2.144	2.0815	2.0975	36153140.0
2005-02-02 12:00:00	AMZN	Stock	2.098	2.1	2.0735	2.092	19633200.0
2005-02-02 13:00:00	AMZN	Stock	2.0915	2.103	2.085	2.0885	16753820.0
2005-02-02 14:00:00	AMZN	Stock	2.089	2.1	2.075	2.08	40232860.0
2005-02-02 15:00:00	AMZN	Stock	2.08	2.1075	2.0575	2.094	85045800.0
2005-02-02 16:00:00	AMZN	Stock	2.094	2.24	1.795	1.8105	171911700.0
2005-02-02 17:00:00	AMZN	Stock	1.8145	2.0904	1.785	1.7895	25587160.0
2005-02-02 18:00:00	AMZN	Stock	1.7895	1.8	1.78	1.78	7166940.0
2005-02-02 09:00:00	CL	Stock	26.625	26.715	26.625	26.655	582600.0
2005-02-02 10:00:00	CL	Stock	26.66	26.965	26.66	26.85	1052000.0
2005-02-02 11:00:00	CL	Stock	26.85	26.955	26.82	26.87	876400.0
2005-02-02 12:00:00	CL	Stock	26.875	27.025	26.875	27.025	1004000.0
2005-02-02 13:00:00	CL	Stock	27.025	27.04	26.97	27.0	531800.0
2005-02-02 14:00:00	CL	Stock	27.0	27.14	27.0	27.025	1093600.0

> showing 50 of 25,583 rows — these rows as CSV

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