PREVIEW / stock_1hour / 2004-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-02-06.parquet
  size:    492 KB
  rows:    22,914
  symbols: 1,721

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-02-06 08:00:00	AAPL	Stock	0.4045	0.4045	0.4045	0.4045	56000.0
2004-02-06 09:00:00	AAPL	Stock	0.3996	0.4071	0.3996	0.4023	21210056.0
2004-02-06 10:00:00	AAPL	Stock	0.4025	0.4088	0.4023	0.4066	32061344.0
2004-02-06 11:00:00	AAPL	Stock	0.4066	0.4068	0.4053	0.4057	12619824.0
2004-02-06 12:00:00	AAPL	Stock	0.4057	0.4064	0.4039	0.4056	22407224.0
2004-02-06 13:00:00	AAPL	Stock	0.4055	0.4061	0.4048	0.4055	16212896.0
2004-02-06 14:00:00	AAPL	Stock	0.4055	0.4063	0.4041	0.4054	29785112.0
2004-02-06 15:00:00	AAPL	Stock	0.4052	0.4066	0.4039	0.4054	38712072.0
2004-02-06 16:00:00	AAPL	Stock	0.4061	0.4061	0.3998	0.4055	1758848.0
2004-02-06 17:00:00	AAPL	Stock	0.4055	0.4055	0.4055	0.4055	218624.0
2004-02-06 18:00:00	AAPL	Stock	0.4029	0.4029	0.4027	0.4027	56000.0
2004-02-06 08:00:00	MSFT	Stock	26.96	27.2	26.91	27.01	119525.0
2004-02-06 09:00:00	MSFT	Stock	27.01	27.17	26.93	27.02	6788632.0
2004-02-06 10:00:00	MSFT	Stock	27.02	27.19	26.95	27.16	8636796.0
2004-02-06 11:00:00	MSFT	Stock	27.17	27.17	27.0	27.03	4818489.0
2004-02-06 12:00:00	MSFT	Stock	27.03	27.06	26.99	27.0	4080851.0
2004-02-06 13:00:00	MSFT	Stock	27.0	27.05	26.98	27.02	4152999.0
2004-02-06 14:00:00	MSFT	Stock	27.01	27.04	26.97	26.97	4661250.0
2004-02-06 15:00:00	MSFT	Stock	26.97	27.17	26.96	27.08	11933071.0
2004-02-06 16:00:00	MSFT	Stock	27.08	27.1	27.04	27.05	465350.0
2004-02-06 17:00:00	MSFT	Stock	27.06	27.08	27.04	27.07	52479.0
2004-02-06 18:00:00	MSFT	Stock	27.06	27.07	27.05	27.05	4300.0
2004-02-06 09:00:00	NVDA	Stock	0.1875	0.1908	0.1862	0.1887	54827880.0
2004-02-06 10:00:00	NVDA	Stock	0.1887	0.1923	0.1881	0.1919	84472680.0
2004-02-06 11:00:00	NVDA	Stock	0.1921	0.1921	0.1903	0.1903	47417640.0
2004-02-06 12:00:00	NVDA	Stock	0.1903	0.191	0.1897	0.1899	34631640.0
2004-02-06 13:00:00	NVDA	Stock	0.1899	0.191	0.1899	0.1908	63423840.0
2004-02-06 14:00:00	NVDA	Stock	0.1908	0.1909	0.1902	0.1908	51388080.0
2004-02-06 15:00:00	NVDA	Stock	0.1908	0.1912	0.1893	0.1897	113078640.0
2004-02-06 16:00:00	NVDA	Stock	0.1901	0.1901	0.1891	0.1898	5855400.0
2004-02-06 17:00:00	NVDA	Stock	0.1897	0.1897	0.1897	0.1897	161760.0
2004-02-06 18:00:00	NVDA	Stock	0.1898	0.1898	0.1898	0.1898	12000.0
2004-02-06 08:00:00	AMZN	Stock	2.3025	2.325	2.302	2.3075	400000.0
2004-02-06 09:00:00	AMZN	Stock	2.305	2.3365	2.288	2.3005	26140500.0
2004-02-06 10:00:00	AMZN	Stock	2.3	2.305	2.2755	2.2968	36888580.0
2004-02-06 11:00:00	AMZN	Stock	2.297	2.312	2.288	2.3045	15488020.0
2004-02-06 12:00:00	AMZN	Stock	2.3045	2.307	2.294	2.294	7117040.0
2004-02-06 13:00:00	AMZN	Stock	2.2935	2.31	2.2925	2.3035	7066480.0
2004-02-06 14:00:00	AMZN	Stock	2.3033	2.3125	2.293	2.308	9876900.0
2004-02-06 15:00:00	AMZN	Stock	2.308	2.321	2.3074	2.3165	22056260.0
2004-02-06 16:00:00	AMZN	Stock	2.319	2.32	2.3135	2.3185	856700.0
2004-02-06 17:00:00	AMZN	Stock	2.3185	2.3185	2.3165	2.3165	82620.0
2004-02-06 09:00:00	CL	Stock	27.325	27.375	27.26	27.285	1244400.0
2004-02-06 10:00:00	CL	Stock	27.305	27.45	27.295	27.33	1927200.0
2004-02-06 11:00:00	CL	Stock	27.33	27.4	27.32	27.34	685800.0
2004-02-06 12:00:00	CL	Stock	27.34	27.35	27.26	27.325	1281000.0
2004-02-06 13:00:00	CL	Stock	27.325	27.425	27.315	27.425	1729400.0
2004-02-06 14:00:00	CL	Stock	27.345	27.465	27.345	27.45	747000.0
2004-02-06 15:00:00	CL	Stock	27.455	27.51	27.325	27.395	1352400.0
2004-02-06 16:00:00	CL	Stock	27.4	27.4	27.4	27.4	1600.0

> showing 50 of 22,914 rows — these rows as CSV

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