PREVIEW / stock_1hour / 2004-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-12-09.parquet
  size:    534 KB
  rows:    24,769
  symbols: 1,887

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-12-09 08:00:00	AAPL	Stock	1.1268	1.1295	1.1214	1.1214	451080.0
2004-12-09 09:00:00	AAPL	Stock	1.125	1.1291	1.1084	1.12	97003648.0
2004-12-09 10:00:00	AAPL	Stock	1.1195	1.1241	1.11	1.1232	141434832.0
2004-12-09 11:00:00	AAPL	Stock	1.1232	1.1236	1.1138	1.1177	57765008.0
2004-12-09 12:00:00	AAPL	Stock	1.1177	1.123	1.1143	1.1198	52689952.0
2004-12-09 13:00:00	AAPL	Stock	1.1202	1.1373	1.118	1.1302	129433192.0
2004-12-09 14:00:00	AAPL	Stock	1.1296	1.1398	1.1214	1.1393	72639672.0
2004-12-09 15:00:00	AAPL	Stock	1.1391	1.15	1.1373	1.142	171117520.0
2004-12-09 16:00:00	AAPL	Stock	1.1423	1.1457	1.127	1.1438	6373752.0
2004-12-09 17:00:00	AAPL	Stock	1.1445	1.1607	1.1427	1.1545	4340952.0
2004-12-09 18:00:00	AAPL	Stock	1.1545	1.1557	1.1545	1.1554	449456.0
2004-12-09 08:00:00	MSFT	Stock	27.35	27.36	27.12	27.17	795795.0
2004-12-09 09:00:00	MSFT	Stock	27.17	27.26	27.08	27.19	8202438.0
2004-12-09 10:00:00	MSFT	Stock	27.2	27.2	27.01	27.01	11372237.0
2004-12-09 11:00:00	MSFT	Stock	27.01	27.06	26.94	27.03	13273610.0
2004-12-09 12:00:00	MSFT	Stock	27.02	27.15	27.01	27.13	9412553.0
2004-12-09 13:00:00	MSFT	Stock	27.12	27.27	27.11	27.229	10887411.0
2004-12-09 14:00:00	MSFT	Stock	27.23	27.34	27.149	27.34	10260953.0
2004-12-09 15:00:00	MSFT	Stock	27.34	27.35	27.18	27.21	11583648.0
2004-12-09 16:00:00	MSFT	Stock	27.2	27.23	27.01	27.19	2738344.0
2004-12-09 17:00:00	MSFT	Stock	27.18	27.23	27.17	27.17	38792.0
2004-12-09 18:00:00	MSFT	Stock	27.17	27.17	27.17	27.17	190.0
2004-12-09 08:00:00	NVDA	Stock	0.1888	0.1892	0.1887	0.1887	463200.0
2004-12-09 09:00:00	NVDA	Stock	0.1882	0.1917	0.1855	0.1865	169676640.0
2004-12-09 10:00:00	NVDA	Stock	0.1864	0.1872	0.1852	0.186	137804520.0
2004-12-09 11:00:00	NVDA	Stock	0.186	0.1869	0.1852	0.1865	49191240.0
2004-12-09 12:00:00	NVDA	Stock	0.1866	0.19	0.1861	0.1895	105072000.0
2004-12-09 13:00:00	NVDA	Stock	0.1896	0.1926	0.1889	0.1908	153064320.0
2004-12-09 14:00:00	NVDA	Stock	0.1907	0.1915	0.188	0.1915	77044440.0
2004-12-09 15:00:00	NVDA	Stock	0.1915	0.1926	0.19	0.1912	146652840.0
2004-12-09 16:00:00	NVDA	Stock	0.1907	0.1912	0.1898	0.1898	11320320.0
2004-12-09 17:00:00	NVDA	Stock	0.1898	0.1911	0.1892	0.191	526200.0
2004-12-09 08:00:00	AMZN	Stock	1.925	1.925	1.925	1.925	28000.0
2004-12-09 09:00:00	AMZN	Stock	1.9225	1.932	1.9085	1.932	13345420.0
2004-12-09 10:00:00	AMZN	Stock	1.9325	1.9595	1.93	1.949	34178720.0
2004-12-09 11:00:00	AMZN	Stock	1.95	1.957	1.928	1.944	16900100.0
2004-12-09 12:00:00	AMZN	Stock	1.9435	1.9525	1.9415	1.95	9399480.0
2004-12-09 13:00:00	AMZN	Stock	1.95	1.9795	1.95	1.9685	21125220.0
2004-12-09 14:00:00	AMZN	Stock	1.9685	1.991	1.9575	1.99	15412840.0
2004-12-09 15:00:00	AMZN	Stock	1.9905	1.9975	1.9825	1.9915	30976580.0
2004-12-09 16:00:00	AMZN	Stock	1.9905	1.992	1.9855	1.9905	2769120.0
2004-12-09 17:00:00	AMZN	Stock	1.991	1.996	1.988	1.996	48760.0
2004-12-09 18:00:00	AMZN	Stock	1.996	1.9975	1.996	1.9975	67400.0
2004-12-09 09:00:00	CL	Stock	24.785	24.975	24.75	24.95	896200.0
2004-12-09 10:00:00	CL	Stock	24.95	24.9745	24.74	24.83	1024600.0
2004-12-09 11:00:00	CL	Stock	24.835	24.93	24.835	24.87	853400.0
2004-12-09 12:00:00	CL	Stock	24.865	25.02	24.865	24.975	868800.0
2004-12-09 13:00:00	CL	Stock	24.97	25.05	24.96	25.05	920600.0
2004-12-09 14:00:00	CL	Stock	25.05	25.22	24.995	25.2	881200.0
2004-12-09 15:00:00	CL	Stock	25.215	25.215	25.07	25.12	1420400.0

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

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