PREVIEW / stock_1hour / 2005-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-12.parquet
  size:    547 KB
  rows:    25,715
  symbols: 1,910

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
2005-01-12 08:00:00	AAPL	Stock	1.167	1.1718	1.1529	1.1554	10114832.0
2005-01-12 09:00:00	AAPL	Stock	1.1563	1.1713	1.1304	1.1491	407941408.0
2005-01-12 10:00:00	AAPL	Stock	1.1489	1.1582	1.1445	1.1507	279552056.0
2005-01-12 11:00:00	AAPL	Stock	1.1509	1.1527	1.1393	1.1454	181210232.0
2005-01-12 12:00:00	AAPL	Stock	1.1454	1.1536	1.1443	1.1482	108494344.0
2005-01-12 13:00:00	AAPL	Stock	1.1482	1.167	1.1459	1.1478	88161024.0
2005-01-12 14:00:00	AAPL	Stock	1.148	1.1554	1.1441	1.1475	101006752.0
2005-01-12 15:00:00	AAPL	Stock	1.1473	1.1768	1.1464	1.1698	405084848.0
2005-01-12 16:00:00	AAPL	Stock	1.1696	1.3375	1.1386	1.2893	232285144.0
2005-01-12 17:00:00	AAPL	Stock	1.2877	1.3125	1.1689	1.2979	169456112.0
2005-01-12 18:00:00	AAPL	Stock	1.298	1.3155	1.1689	1.3089	33743976.0
2005-01-12 08:00:00	MSFT	Stock	26.85	26.85	26.78	26.8	27800.0
2005-01-12 09:00:00	MSFT	Stock	26.8	26.83	26.67	26.69	8000506.0
2005-01-12 10:00:00	MSFT	Stock	26.69	26.75	26.62	26.68	10784267.0
2005-01-12 11:00:00	MSFT	Stock	26.68	26.85	26.66	26.74	9682572.0
2005-01-12 12:00:00	MSFT	Stock	26.73	26.8	26.71	26.75	4829437.0
2005-01-12 13:00:00	MSFT	Stock	26.75	26.81	26.7	26.73	5873872.0
2005-01-12 14:00:00	MSFT	Stock	26.73	26.77	26.64	26.679	10745814.0
2005-01-12 15:00:00	MSFT	Stock	26.68	26.82	26.66	26.77	18388068.0
2005-01-12 16:00:00	MSFT	Stock	26.77	26.79	26.68	26.73	2242715.0
2005-01-12 17:00:00	MSFT	Stock	26.75	26.78	26.7	26.74	321713.0
2005-01-12 18:00:00	MSFT	Stock	26.75	26.75	26.72	26.74	8545.0
2005-01-12 08:00:00	NVDA	Stock	0.18	0.1804	0.18	0.1804	579120.0
2005-01-12 09:00:00	NVDA	Stock	0.1807	0.1811	0.1725	0.1732	170368080.0
2005-01-12 10:00:00	NVDA	Stock	0.1731	0.1754	0.173	0.1732	184586880.0
2005-01-12 11:00:00	NVDA	Stock	0.1732	0.1761	0.173	0.1749	199956960.0
2005-01-12 12:00:00	NVDA	Stock	0.1748	0.1765	0.1742	0.1762	81182400.0
2005-01-12 13:00:00	NVDA	Stock	0.1762	0.1775	0.1752	0.1756	99737040.0
2005-01-12 14:00:00	NVDA	Stock	0.1756	0.176	0.1747	0.1751	118714680.0
2005-01-12 15:00:00	NVDA	Stock	0.175	0.1773	0.175	0.1767	153027120.0
2005-01-12 16:00:00	NVDA	Stock	0.1762	0.1791	0.1762	0.1785	32425680.0
2005-01-12 17:00:00	NVDA	Stock	0.1782	0.1785	0.1768	0.1768	1612920.0
2005-01-12 08:00:00	AMZN	Stock	2.098	2.098	2.0875	2.0875	30800.0
2005-01-12 09:00:00	AMZN	Stock	2.0925	2.1	2.055	2.0625	18762460.0
2005-01-12 10:00:00	AMZN	Stock	2.063	2.083	2.041	2.0465	27607040.0
2005-01-12 11:00:00	AMZN	Stock	2.0455	2.079	2.0445	2.068	20123260.0
2005-01-12 12:00:00	AMZN	Stock	2.068	2.079	2.0595	2.0625	11938000.0
2005-01-12 13:00:00	AMZN	Stock	2.0635	2.07	2.059	2.065	8542640.0
2005-01-12 14:00:00	AMZN	Stock	2.064	2.0955	2.0625	2.0905	18109120.0
2005-01-12 15:00:00	AMZN	Stock	2.0905	2.124	2.0895	2.1195	53321760.0
2005-01-12 16:00:00	AMZN	Stock	2.118	2.1375	2.115	2.1345	1366320.0
2005-01-12 17:00:00	AMZN	Stock	2.115	2.13	2.0726	2.123	504100.0
2005-01-12 18:00:00	AMZN	Stock	2.1225	2.1295	2.1165	2.129	322160.0
2005-01-12 09:00:00	CL	Stock	25.055	25.125	25.0	25.07	817200.0
2005-01-12 10:00:00	CL	Stock	25.075	25.13	24.945	25.005	794800.0
2005-01-12 11:00:00	CL	Stock	25.0	25.09	24.955	25.05	567800.0
2005-01-12 12:00:00	CL	Stock	25.05	25.055	24.95	24.98	479600.0
2005-01-12 13:00:00	CL	Stock	24.985	25.055	24.95	25.0	510600.0
2005-01-12 14:00:00	CL	Stock	25.0	25.055	24.99	25.025	458600.0
2005-01-12 15:00:00	CL	Stock	25.03	25.15	24.99	25.13	853800.0

> showing 50 of 25,715 rows — these rows as CSV

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