PREVIEW / stock_1hour / 2004-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-29.parquet
  size:    517 KB
  rows:    24,115
  symbols: 1,766

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-04-29 08:00:00	AAPL	Stock	0.4723	0.4732	0.4723	0.4732	33600.0
2004-04-29 09:00:00	AAPL	Stock	0.4711	0.4725	0.4639	0.467	52233328.0
2004-04-29 10:00:00	AAPL	Stock	0.467	0.4821	0.467	0.4765	84131320.0
2004-04-29 11:00:00	AAPL	Stock	0.4766	0.4793	0.4693	0.4748	32300072.0
2004-04-29 12:00:00	AAPL	Stock	0.4752	0.4802	0.4727	0.4784	44989168.0
2004-04-29 13:00:00	AAPL	Stock	0.478	0.4813	0.4745	0.4768	27792968.0
2004-04-29 14:00:00	AAPL	Stock	0.477	0.4786	0.4739	0.4754	84424480.0
2004-04-29 15:00:00	AAPL	Stock	0.4754	0.4789	0.4736	0.4789	61875912.0
2004-04-29 16:00:00	AAPL	Stock	0.4789	0.4821	0.4775	0.4791	8047424.0
2004-04-29 17:00:00	AAPL	Stock	0.4782	0.4791	0.4782	0.4791	100800.0
2004-04-29 18:00:00	AAPL	Stock	0.4775	0.4775	0.4775	0.4775	22400.0
2004-04-29 08:00:00	MSFT	Stock	26.51	26.67	26.47	26.65	712307.0
2004-04-29 09:00:00	MSFT	Stock	26.62	26.75	26.47	26.702	7379306.0
2004-04-29 10:00:00	MSFT	Stock	26.71	26.94	26.67	26.858	12326757.0
2004-04-29 11:00:00	MSFT	Stock	26.86	26.89	26.71	26.77	7329714.0
2004-04-29 12:00:00	MSFT	Stock	26.77	26.84	26.65	26.72	8172848.0
2004-04-29 13:00:00	MSFT	Stock	26.72	26.83	26.69	26.76	5265556.0
2004-04-29 14:00:00	MSFT	Stock	26.77	26.8	26.51	26.52	10145206.0
2004-04-29 15:00:00	MSFT	Stock	26.51	26.7	26.31	26.51	16983094.0
2004-04-29 16:00:00	MSFT	Stock	26.51	26.6	26.43	26.48	1106550.0
2004-04-29 17:00:00	MSFT	Stock	26.774	26.774	26.45	26.45	472676.0
2004-04-29 18:00:00	MSFT	Stock	26.52	26.52	26.52	26.52	100.0
2004-04-29 08:00:00	NVDA	Stock	0.1833	0.1837	0.1823	0.1832	120000.0
2004-04-29 09:00:00	NVDA	Stock	0.1832	0.1837	0.1793	0.1803	45916080.0
2004-04-29 10:00:00	NVDA	Stock	0.1803	0.1835	0.1796	0.1827	74246280.0
2004-04-29 11:00:00	NVDA	Stock	0.1826	0.1839	0.1808	0.1813	74930880.0
2004-04-29 12:00:00	NVDA	Stock	0.1812	0.1815	0.1796	0.1797	72195480.0
2004-04-29 13:00:00	NVDA	Stock	0.1799	0.1816	0.1796	0.1808	60688800.0
2004-04-29 14:00:00	NVDA	Stock	0.1809	0.181	0.1769	0.1781	80668080.0
2004-04-29 15:00:00	NVDA	Stock	0.178	0.1804	0.1762	0.1788	171049200.0
2004-04-29 16:00:00	NVDA	Stock	0.1788	0.1792	0.1786	0.1788	5530680.0
2004-04-29 17:00:00	NVDA	Stock	0.1787	0.1787	0.1787	0.1787	24960.0
2004-04-29 18:00:00	NVDA	Stock	0.179	0.179	0.179	0.179	120000.0
2004-04-29 08:00:00	AMZN	Stock	2.3415	2.35	2.3415	2.3455	72000.0
2004-04-29 09:00:00	AMZN	Stock	2.347	2.3505	2.2941	2.312	22520620.0
2004-04-29 10:00:00	AMZN	Stock	2.312	2.354	2.31	2.346	28679460.0
2004-04-29 11:00:00	AMZN	Stock	2.346	2.3465	2.312	2.314	14024600.0
2004-04-29 12:00:00	AMZN	Stock	2.3155	2.326	2.295	2.299	14249060.0
2004-04-29 13:00:00	AMZN	Stock	2.299	2.3115	2.295	2.3055	13576620.0
2004-04-29 14:00:00	AMZN	Stock	2.307	2.308	2.2755	2.2995	28819520.0
2004-04-29 15:00:00	AMZN	Stock	2.2995	2.318	2.285	2.309	31631640.0
2004-04-29 16:00:00	AMZN	Stock	2.3075	2.313	2.2755	2.3065	1500560.0
2004-04-29 17:00:00	AMZN	Stock	2.3065	2.3065	2.3065	2.3065	148160.0
2004-04-29 18:00:00	AMZN	Stock	2.307	2.3205	2.307	2.3205	51500.0
2004-04-29 09:00:00	CL	Stock	28.27	28.415	28.205	28.405	300000.0
2004-04-29 10:00:00	CL	Stock	28.38	28.525	28.315	28.505	471200.0
2004-04-29 11:00:00	CL	Stock	28.495	28.615	28.485	28.61	482200.0
2004-04-29 12:00:00	CL	Stock	28.61	28.79	28.605	28.765	481600.0
2004-04-29 13:00:00	CL	Stock	28.77	28.785	28.695	28.695	350800.0
2004-04-29 14:00:00	CL	Stock	28.695	28.775	28.58	28.775	689800.0

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

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