PREVIEW / stock_1hour / 2005-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-05.parquet
  size:    563 KB
  rows:    26,394
  symbols: 1,909

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-05 08:00:00	AAPL	Stock	1.152	1.1598	1.1475	1.1502	3764544.0
2005-01-05 09:00:00	AAPL	Stock	1.1418	1.1652	1.1418	1.1563	167026328.0
2005-01-05 10:00:00	AAPL	Stock	1.1563	1.1607	1.1446	1.1484	125653640.0
2005-01-05 11:00:00	AAPL	Stock	1.1486	1.1568	1.1466	1.1505	71858024.0
2005-01-05 12:00:00	AAPL	Stock	1.1507	1.1518	1.1438	1.1496	58121280.0
2005-01-05 13:00:00	AAPL	Stock	1.1496	1.1555	1.1484	1.1545	67202576.0
2005-01-05 14:00:00	AAPL	Stock	1.1541	1.1568	1.1534	1.1539	54087712.0
2005-01-05 15:00:00	AAPL	Stock	1.1543	1.162	1.1518	1.152	125669432.0
2005-01-05 16:00:00	AAPL	Stock	1.1518	1.1527	1.1505	1.1505	3354344.0
2005-01-05 17:00:00	AAPL	Stock	1.1507	1.153	1.1502	1.153	477008.0
2005-01-05 18:00:00	AAPL	Stock	1.1543	1.1545	1.1543	1.1543	28000.0
2005-01-05 08:00:00	MSFT	Stock	26.8	26.9	26.8	26.83	25116.0
2005-01-05 09:00:00	MSFT	Stock	26.83	26.98	26.8	26.9	9041002.0
2005-01-05 10:00:00	MSFT	Stock	26.9	27.0	26.85	26.92	11023455.0
2005-01-05 11:00:00	MSFT	Stock	26.92	26.99	26.89	26.95	8042463.0
2005-01-05 12:00:00	MSFT	Stock	26.95	26.99	26.91	26.98	7004699.0
2005-01-05 13:00:00	MSFT	Stock	26.98	27.1	26.97	27.01	10329499.0
2005-01-05 14:00:00	MSFT	Stock	27.01	27.05	26.9	26.92	8868706.0
2005-01-05 15:00:00	MSFT	Stock	26.91	26.96	26.76	26.77	12761413.0
2005-01-05 16:00:00	MSFT	Stock	26.78	26.79	26.72	26.75	2026628.0
2005-01-05 17:00:00	MSFT	Stock	26.75	26.78	26.75	26.77	37661.0
2005-01-05 18:00:00	MSFT	Stock	26.78	26.79	26.78	26.79	7600.0
2005-01-05 08:00:00	NVDA	Stock	0.1867	0.1867	0.1842	0.1842	825600.0
2005-01-05 09:00:00	NVDA	Stock	0.1842	0.1908	0.1842	0.1899	97394280.0
2005-01-05 10:00:00	NVDA	Stock	0.1899	0.1912	0.1857	0.1869	134265240.0
2005-01-05 11:00:00	NVDA	Stock	0.187	0.1884	0.1859	0.1872	68848920.0
2005-01-05 12:00:00	NVDA	Stock	0.1871	0.1876	0.1852	0.1865	68150160.0
2005-01-05 13:00:00	NVDA	Stock	0.1865	0.1908	0.1865	0.1902	96786480.0
2005-01-05 14:00:00	NVDA	Stock	0.1902	0.1908	0.1888	0.1898	63935640.0
2005-01-05 15:00:00	NVDA	Stock	0.1898	0.191	0.1878	0.1889	183062160.0
2005-01-05 16:00:00	NVDA	Stock	0.189	0.1894	0.1889	0.1894	3285120.0
2005-01-05 17:00:00	NVDA	Stock	0.1892	0.1892	0.1888	0.189	1004880.0
2005-01-05 18:00:00	NVDA	Stock	0.1897	0.1897	0.189	0.1894	171600.0
2005-01-05 08:00:00	AMZN	Stock	2.105	2.108	2.1045	2.1055	135840.0
2005-01-05 09:00:00	AMZN	Stock	2.105	2.1315	2.078	2.1225	34512460.0
2005-01-05 10:00:00	AMZN	Stock	2.122	2.138	2.1145	2.121	31940820.0
2005-01-05 11:00:00	AMZN	Stock	2.1205	2.1285	2.1075	2.111	22305180.0
2005-01-05 12:00:00	AMZN	Stock	2.1115	2.1125	2.089	2.0995	19761220.0
2005-01-05 13:00:00	AMZN	Stock	2.0985	2.112	2.098	2.1065	14098740.0
2005-01-05 14:00:00	AMZN	Stock	2.1065	2.108	2.0925	2.095	13683040.0
2005-01-05 15:00:00	AMZN	Stock	2.0945	2.106	2.0825	2.088	27841940.0
2005-01-05 16:00:00	AMZN	Stock	2.0875	2.0885	2.082	2.0885	861720.0
2005-01-05 17:00:00	AMZN	Stock	2.0885	2.0885	2.088	2.0885	91600.0
2005-01-05 18:00:00	AMZN	Stock	2.0885	2.0885	2.0885	2.0885	69000.0
2005-01-05 09:00:00	CL	Stock	24.525	24.74	24.52	24.62	1250000.0
2005-01-05 10:00:00	CL	Stock	24.62	24.63	24.245	24.335	2218400.0
2005-01-05 11:00:00	CL	Stock	24.33	24.415	24.32	24.34	944200.0
2005-01-05 12:00:00	CL	Stock	24.345	24.36	24.26	24.315	1056800.0
2005-01-05 13:00:00	CL	Stock	24.315	24.455	24.31	24.365	745200.0
2005-01-05 14:00:00	CL	Stock	24.365	24.425	24.36	24.4	831600.0

> showing 50 of 26,394 rows — these rows as CSV

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