PREVIEW / stock_1hour / 2004-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-08.parquet
  size:    526 KB
  rows:    24,919
  symbols: 1,863

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-11-08 08:00:00	AAPL	Stock	0.9784	0.9784	0.9741	0.9755	95200.0
2004-11-08 09:00:00	AAPL	Stock	0.975	0.9902	0.9714	0.9798	76739376.0
2004-11-08 10:00:00	AAPL	Stock	0.98	0.9845	0.9729	0.9821	80988320.0
2004-11-08 11:00:00	AAPL	Stock	0.9823	0.9877	0.978	0.9854	68563208.0
2004-11-08 12:00:00	AAPL	Stock	0.9855	0.9893	0.9816	0.9848	56370552.0
2004-11-08 13:00:00	AAPL	Stock	0.9848	0.9852	0.9793	0.982	39943120.0
2004-11-08 14:00:00	AAPL	Stock	0.9814	0.9834	0.9771	0.9829	42387632.0
2004-11-08 15:00:00	AAPL	Stock	0.9829	0.9829	0.9618	0.9713	133608832.0
2004-11-08 16:00:00	AAPL	Stock	0.9711	0.9759	0.9698	0.9732	3025792.0
2004-11-08 17:00:00	AAPL	Stock	0.9713	0.9713	0.9675	0.9675	218400.0
2004-11-08 18:00:00	AAPL	Stock	0.9688	0.9688	0.9663	0.9663	117600.0
2004-11-08 08:00:00	MSFT	Stock	29.31	29.35	29.2	29.23	67847.0
2004-11-08 09:00:00	MSFT	Stock	29.23	29.27	29.13	29.22	7271457.0
2004-11-08 10:00:00	MSFT	Stock	29.23	29.48	29.2	29.45	18381867.0
2004-11-08 11:00:00	MSFT	Stock	29.45	29.46	29.23	29.29	19439003.0
2004-11-08 12:00:00	MSFT	Stock	29.29	29.341	29.23	29.28	10310852.0
2004-11-08 13:00:00	MSFT	Stock	29.29	29.34	29.25	29.34	11266900.0
2004-11-08 14:00:00	MSFT	Stock	29.34	29.37	29.29	29.33	9571762.0
2004-11-08 15:00:00	MSFT	Stock	29.33	29.36	29.17	29.27	19299722.0
2004-11-08 16:00:00	MSFT	Stock	29.3	29.4	29.25	29.3	5994660.0
2004-11-08 17:00:00	MSFT	Stock	29.3	29.35	29.28	29.28	586545.0
2004-11-08 18:00:00	MSFT	Stock	29.3	29.34	29.29	29.32	2704300.0
2004-11-08 08:00:00	NVDA	Stock	0.1476	0.1476	0.1458	0.1471	3145920.0
2004-11-08 09:00:00	NVDA	Stock	0.1471	0.1506	0.145	0.1482	136833840.0
2004-11-08 10:00:00	NVDA	Stock	0.1482	0.1491	0.1472	0.1488	144644160.0
2004-11-08 11:00:00	NVDA	Stock	0.1489	0.1493	0.1479	0.1479	86845080.0
2004-11-08 12:00:00	NVDA	Stock	0.1479	0.1487	0.1479	0.1483	65896440.0
2004-11-08 13:00:00	NVDA	Stock	0.1482	0.1484	0.1477	0.1483	53187960.0
2004-11-08 14:00:00	NVDA	Stock	0.1483	0.1487	0.1481	0.1486	60893640.0
2004-11-08 15:00:00	NVDA	Stock	0.1485	0.1492	0.1482	0.1486	115048200.0
2004-11-08 16:00:00	NVDA	Stock	0.1487	0.1487	0.1481	0.1485	5077680.0
2004-11-08 17:00:00	NVDA	Stock	0.1484	0.1484	0.1484	0.1484	180000.0
2004-11-08 18:00:00	NVDA	Stock	0.1483	0.1484	0.1482	0.1483	684000.0
2004-11-08 08:00:00	AMZN	Stock	1.8475	1.8545	1.8285	1.8285	440380.0
2004-11-08 09:00:00	AMZN	Stock	1.84	1.868	1.829	1.8465	15992860.0
2004-11-08 10:00:00	AMZN	Stock	1.8465	1.864	1.841	1.8525	27629780.0
2004-11-08 11:00:00	AMZN	Stock	1.8525	1.879	1.8525	1.8765	19467000.0
2004-11-08 12:00:00	AMZN	Stock	1.877	1.878	1.8715	1.877	11611460.0
2004-11-08 13:00:00	AMZN	Stock	1.877	1.877	1.855	1.8555	17507380.0
2004-11-08 14:00:00	AMZN	Stock	1.856	1.861	1.8465	1.8585	16290180.0
2004-11-08 15:00:00	AMZN	Stock	1.858	1.871	1.853	1.8665	22343640.0
2004-11-08 16:00:00	AMZN	Stock	1.866	1.87	1.865	1.865	1147460.0
2004-11-08 17:00:00	AMZN	Stock	1.8605	1.8605	1.8605	1.8605	2000.0
2004-11-08 09:00:00	CL	Stock	23.425	23.48	23.355	23.355	446000.0
2004-11-08 10:00:00	CL	Stock	23.36	23.36	23.195	23.29	847400.0
2004-11-08 11:00:00	CL	Stock	23.29	23.295	23.165	23.18	583200.0
2004-11-08 12:00:00	CL	Stock	23.175	23.26	23.17	23.26	491800.0
2004-11-08 13:00:00	CL	Stock	23.26	23.27	23.17	23.26	523400.0
2004-11-08 14:00:00	CL	Stock	23.255	23.265	23.23	23.24	492200.0
2004-11-08 15:00:00	CL	Stock	23.24	23.25	23.18	23.2	971000.0

> showing 50 of 24,919 rows — these rows as CSV

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