PREVIEW / stock_1hour / 2004-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-03-09.parquet
  size:    496 KB
  rows:    23,039
  symbols: 1,731

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-03-09 08:00:00	AAPL	Stock	0.4661	0.4661	0.4625	0.4625	717080.0
2004-03-09 09:00:00	AAPL	Stock	0.4625	0.4732	0.4598	0.4729	33023984.0
2004-03-09 10:00:00	AAPL	Stock	0.4729	0.473	0.4646	0.4729	50622488.0
2004-03-09 11:00:00	AAPL	Stock	0.4729	0.4768	0.4716	0.472	50985704.0
2004-03-09 12:00:00	AAPL	Stock	0.472	0.4752	0.4714	0.4738	48927312.0
2004-03-09 13:00:00	AAPL	Stock	0.4739	0.4752	0.4732	0.4741	42175056.0
2004-03-09 14:00:00	AAPL	Stock	0.4741	0.4811	0.473	0.4789	83168344.0
2004-03-09 15:00:00	AAPL	Stock	0.4789	0.4863	0.478	0.4834	163909816.0
2004-03-09 16:00:00	AAPL	Stock	0.4841	0.4845	0.4821	0.4832	5942440.0
2004-03-09 17:00:00	AAPL	Stock	0.4841	0.4841	0.483	0.483	112560.0
2004-03-09 18:00:00	AAPL	Stock	0.4839	0.4839	0.4839	0.4839	39200.0
2004-03-09 08:00:00	MSFT	Stock	25.83	25.9	25.83	25.84	369235.0
2004-03-09 09:00:00	MSFT	Stock	25.85	26.86	25.61	25.7	6694541.0
2004-03-09 10:00:00	MSFT	Stock	25.7	25.75	25.54	25.75	9579613.0
2004-03-09 11:00:00	MSFT	Stock	25.75	25.97	25.74	25.85	9051339.0
2004-03-09 12:00:00	MSFT	Stock	25.85	25.93	25.73	25.78	6362516.0
2004-03-09 13:00:00	MSFT	Stock	25.78	25.84	25.68	25.69	5740300.0
2004-03-09 14:00:00	MSFT	Stock	25.69	25.8	25.689	25.73	9434353.0
2004-03-09 15:00:00	MSFT	Stock	25.72	25.8	25.64	25.72	13203612.0
2004-03-09 16:00:00	MSFT	Stock	25.71	25.7975	25.65	25.71	363943.0
2004-03-09 17:00:00	MSFT	Stock	25.67	25.71	25.66	25.66	38980.0
2004-03-09 18:00:00	MSFT	Stock	25.67	25.71	25.66	25.67	15594.0
2004-03-09 08:00:00	NVDA	Stock	0.1771	0.1786	0.1771	0.1781	372000.0
2004-03-09 09:00:00	NVDA	Stock	0.1787	0.1801	0.1767	0.1783	30923880.0
2004-03-09 10:00:00	NVDA	Stock	0.1783	0.1787	0.1742	0.1758	64108440.0
2004-03-09 11:00:00	NVDA	Stock	0.1758	0.1785	0.1758	0.1779	38891400.0
2004-03-09 12:00:00	NVDA	Stock	0.1777	0.1787	0.1766	0.1768	34472880.0
2004-03-09 13:00:00	NVDA	Stock	0.1768	0.1779	0.1763	0.1772	30432960.0
2004-03-09 14:00:00	NVDA	Stock	0.1774	0.1779	0.1752	0.1757	32988960.0
2004-03-09 15:00:00	NVDA	Stock	0.1756	0.1777	0.1748	0.1768	46479960.0
2004-03-09 16:00:00	NVDA	Stock	0.1768	0.1777	0.1767	0.1769	1339680.0
2004-03-09 17:00:00	NVDA	Stock	0.1776	0.1776	0.1768	0.1771	391800.0
2004-03-09 08:00:00	AMZN	Stock	2.1685	2.176	2.1685	2.176	41000.0
2004-03-09 09:00:00	AMZN	Stock	2.1805	2.1945	2.164	2.1925	8051640.0
2004-03-09 10:00:00	AMZN	Stock	2.1935	2.1945	2.149	2.169	15417980.0
2004-03-09 11:00:00	AMZN	Stock	2.17	2.171	2.1425	2.149	12154880.0
2004-03-09 12:00:00	AMZN	Stock	2.1485	2.154	2.142	2.149	10077880.0
2004-03-09 13:00:00	AMZN	Stock	2.1485	2.153	2.1275	2.129	12719740.0
2004-03-09 14:00:00	AMZN	Stock	2.1285	2.14	2.121	2.125	12337200.0
2004-03-09 15:00:00	AMZN	Stock	2.124	2.1585	2.1135	2.1395	27441940.0
2004-03-09 16:00:00	AMZN	Stock	2.1365	2.1425	2.133	2.136	414880.0
2004-03-09 17:00:00	AMZN	Stock	2.1355	2.1385	2.1355	2.1385	73240.0
2004-03-09 09:00:00	CL	Stock	28.15	28.15	28.01	28.03	259400.0
2004-03-09 10:00:00	CL	Stock	28.025	28.275	28.025	28.275	357200.0
2004-03-09 11:00:00	CL	Stock	28.285	28.32	28.113	28.185	519600.0
2004-03-09 12:00:00	CL	Stock	28.18	28.23	28.125	28.19	294000.0
2004-03-09 13:00:00	CL	Stock	28.16	28.235	28.155	28.19	249400.0
2004-03-09 14:00:00	CL	Stock	28.19	28.255	28.125	28.175	294200.0
2004-03-09 15:00:00	CL	Stock	28.18	28.215	28.11	28.125	1039000.0
2004-03-09 16:00:00	CL	Stock	28.185	28.185	28.13	28.13	132800.0

> showing 50 of 23,039 rows — these rows as CSV

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