PREVIEW / stock_1hour / 2003-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-07-22.parquet
  size:    453 KB
  rows:    21,319
  symbols: 1,594

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
2003-07-22 08:00:00	AAPL	Stock	0.3696	0.3705	0.3696	0.3705	28000.0
2003-07-22 09:00:00	AAPL	Stock	0.3714	0.3738	0.3668	0.3732	23423960.0
2003-07-22 10:00:00	AAPL	Stock	0.373	0.3732	0.368	0.3682	33650960.0
2003-07-22 11:00:00	AAPL	Stock	0.3684	0.3716	0.3673	0.3709	35238392.0
2003-07-22 12:00:00	AAPL	Stock	0.3709	0.3718	0.3695	0.3696	18191656.0
2003-07-22 13:00:00	AAPL	Stock	0.3696	0.3705	0.3661	0.3693	22454096.0
2003-07-22 14:00:00	AAPL	Stock	0.3696	0.3714	0.368	0.3705	10839584.0
2003-07-22 15:00:00	AAPL	Stock	0.3705	0.3732	0.3688	0.3725	26789840.0
2003-07-22 16:00:00	AAPL	Stock	0.3725	0.3746	0.3714	0.3732	1764000.0
2003-07-22 17:00:00	AAPL	Stock	0.3732	0.3732	0.3732	0.3732	1237600.0
2003-07-22 08:00:00	MSFT	Stock	26.34	26.34	26.04	26.26	608365.0
2003-07-22 09:00:00	MSFT	Stock	26.23	26.34	26.1311	26.32	5106576.0
2003-07-22 10:00:00	MSFT	Stock	26.3288	26.39	26.136	26.21	7866430.0
2003-07-22 11:00:00	MSFT	Stock	26.201	26.56	26.14	26.51	9401821.0
2003-07-22 12:00:00	MSFT	Stock	26.51	26.55	26.4	26.4	4830797.0
2003-07-22 13:00:00	MSFT	Stock	26.4	26.49	26.25	26.39	5775590.0
2003-07-22 14:00:00	MSFT	Stock	26.39	26.52	26.33	26.49	4868773.0
2003-07-22 15:00:00	MSFT	Stock	26.481	26.54	26.28	26.37	7895754.0
2003-07-22 16:00:00	MSFT	Stock	26.37	26.41	26.2	26.34	606818.0
2003-07-22 17:00:00	MSFT	Stock	26.37	26.379	26.26	26.33	193780.0
2003-07-22 18:00:00	MSFT	Stock	26.3	26.33	26.3	26.33	5300.0
2003-07-22 08:00:00	NVDA	Stock	0.1791	0.1791	0.1769	0.1775	652800.0
2003-07-22 09:00:00	NVDA	Stock	0.1775	0.1807	0.1764	0.1773	95421120.0
2003-07-22 10:00:00	NVDA	Stock	0.1772	0.1787	0.1764	0.1775	83795160.0
2003-07-22 11:00:00	NVDA	Stock	0.1775	0.1804	0.1767	0.1796	102312240.0
2003-07-22 12:00:00	NVDA	Stock	0.1798	0.1804	0.1791	0.1791	53337840.0
2003-07-22 13:00:00	NVDA	Stock	0.1792	0.1795	0.1764	0.1779	62188800.0
2003-07-22 14:00:00	NVDA	Stock	0.178	0.1787	0.1769	0.178	37358040.0
2003-07-22 15:00:00	NVDA	Stock	0.178	0.1787	0.1769	0.1776	83111040.0
2003-07-22 16:00:00	NVDA	Stock	0.1775	0.1782	0.1771	0.1772	6238440.0
2003-07-22 17:00:00	NVDA	Stock	0.1783	0.1787	0.1774	0.1782	1188000.0
2003-07-22 18:00:00	NVDA	Stock	0.1776	0.1776	0.1775	0.1775	120000.0
2003-07-22 08:00:00	AMZN	Stock	1.7705	1.8	1.7705	1.78	261600.0
2003-07-22 09:00:00	AMZN	Stock	1.7805	1.799	1.7495	1.7575	29689560.0
2003-07-22 10:00:00	AMZN	Stock	1.758	1.763	1.7	1.7205	52163560.0
2003-07-22 11:00:00	AMZN	Stock	1.721	1.761	1.7151	1.7605	43554400.0
2003-07-22 12:00:00	AMZN	Stock	1.7605	1.7605	1.7385	1.743	22833680.0
2003-07-22 13:00:00	AMZN	Stock	1.7435	1.7535	1.736	1.7375	23111100.0
2003-07-22 14:00:00	AMZN	Stock	1.738	1.74	1.73	1.738	25611680.0
2003-07-22 15:00:00	AMZN	Stock	1.738	1.7451	1.722	1.745	42277740.0
2003-07-22 16:00:00	AMZN	Stock	1.745	1.8715	1.7375	1.8555	45962800.0
2003-07-22 17:00:00	AMZN	Stock	1.8555	1.8575	1.7445	1.8574	4551380.0
2003-07-22 18:00:00	AMZN	Stock	1.8552	1.856	1.8405	1.8405	777720.0
2003-07-22 08:00:00	CL	Stock	28.29	28.29	28.29	28.29	1200.0
2003-07-22 09:00:00	CL	Stock	28.25	28.25	27.9505	28.035	607800.0
2003-07-22 10:00:00	CL	Stock	28.035	28.285	28.035	28.25	721000.0
2003-07-22 11:00:00	CL	Stock	28.265	28.67	28.26	28.665	1196000.0
2003-07-22 12:00:00	CL	Stock	28.67	28.74	28.525	28.575	514600.0
2003-07-22 13:00:00	CL	Stock	28.57	28.6	28.315	28.51	645600.0
2003-07-22 14:00:00	CL	Stock	28.53	28.57	28.425	28.45	292800.0

> showing 50 of 21,319 rows — these rows as CSV

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