PREVIEW / stock_1hour / 2005-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-06.parquet
  size:    552 KB
  rows:    25,571
  symbols: 1,915

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-06 08:00:00	AAPL	Stock	1.1607	1.1611	1.1518	1.1538	2485728.0
2005-01-06 09:00:00	AAPL	Stock	1.1554	1.1588	1.1309	1.137	141708000.0
2005-01-06 10:00:00	AAPL	Stock	1.1373	1.1523	1.1316	1.1395	195507200.0
2005-01-06 11:00:00	AAPL	Stock	1.1395	1.1536	1.1386	1.1511	102979352.0
2005-01-06 12:00:00	AAPL	Stock	1.1509	1.1511	1.147	1.1479	33188064.0
2005-01-06 13:00:00	AAPL	Stock	1.148	1.1582	1.1464	1.1561	78834616.0
2005-01-06 14:00:00	AAPL	Stock	1.1563	1.1591	1.1498	1.1529	51589048.0
2005-01-06 15:00:00	AAPL	Stock	1.1529	1.1571	1.1475	1.1532	86660504.0
2005-01-06 16:00:00	AAPL	Stock	1.1525	1.1536	1.1507	1.1536	2642080.0
2005-01-06 17:00:00	AAPL	Stock	1.1536	1.1536	1.152	1.152	2770824.0
2005-01-06 18:00:00	AAPL	Stock	1.1516	1.1523	1.1516	1.1516	29288.0
2005-01-06 08:00:00	MSFT	Stock	26.9	26.9	26.77	26.83	70950.0
2005-01-06 09:00:00	MSFT	Stock	26.83	27.06	26.83	26.87	9308910.0
2005-01-06 10:00:00	MSFT	Stock	26.87	26.95	26.7	26.73	15051692.0
2005-01-06 11:00:00	MSFT	Stock	26.73	26.87	26.73	26.79	7772626.0
2005-01-06 12:00:00	MSFT	Stock	26.79	26.841	26.7	26.71	6037049.0
2005-01-06 13:00:00	MSFT	Stock	26.7	26.81	26.64	26.8	11332898.0
2005-01-06 14:00:00	MSFT	Stock	26.81	26.91	26.77	26.848	12617393.0
2005-01-06 15:00:00	MSFT	Stock	26.84	26.9	26.71	26.72	9991705.0
2005-01-06 16:00:00	MSFT	Stock	26.72	26.806	26.7	26.75	2227178.0
2005-01-06 17:00:00	MSFT	Stock	26.75	26.76	26.74	26.76	282384.0
2005-01-06 18:00:00	MSFT	Stock	26.76	26.77	26.76	26.77	7965.0
2005-01-06 09:00:00	NVDA	Stock	0.1904	0.1946	0.1898	0.19	109746120.0
2005-01-06 10:00:00	NVDA	Stock	0.1901	0.1901	0.1858	0.1868	168504600.0
2005-01-06 11:00:00	NVDA	Stock	0.1869	0.1899	0.1865	0.1883	63919680.0
2005-01-06 12:00:00	NVDA	Stock	0.1883	0.189	0.1875	0.1877	28183200.0
2005-01-06 13:00:00	NVDA	Stock	0.1877	0.1893	0.1867	0.1892	39448920.0
2005-01-06 14:00:00	NVDA	Stock	0.1892	0.1893	0.1876	0.1879	41578320.0
2005-01-06 15:00:00	NVDA	Stock	0.188	0.188	0.1864	0.1871	82554360.0
2005-01-06 16:00:00	NVDA	Stock	0.1868	0.1875	0.1866	0.1867	1342680.0
2005-01-06 17:00:00	NVDA	Stock	0.1867	0.1867	0.1866	0.1867	1464000.0
2005-01-06 18:00:00	NVDA	Stock	0.1886	0.1886	0.1886	0.1886	4512000.0
2005-01-06 08:00:00	AMZN	Stock	2.093	2.1075	2.093	2.1075	36400.0
2005-01-06 09:00:00	AMZN	Stock	2.0965	2.1125	2.0835	2.0845	23297100.0
2005-01-06 10:00:00	AMZN	Stock	2.0845	2.088	2.059	2.061	45581180.0
2005-01-06 11:00:00	AMZN	Stock	2.0615	2.0775	2.045	2.0565	34612400.0
2005-01-06 12:00:00	AMZN	Stock	2.0565	2.0655	2.047	2.065	16819340.0
2005-01-06 13:00:00	AMZN	Stock	2.065	2.0695	2.051	2.066	13830740.0
2005-01-06 14:00:00	AMZN	Stock	2.0665	2.0765	2.0625	2.069	15335600.0
2005-01-06 15:00:00	AMZN	Stock	2.068	2.0705	2.0525	2.0525	19290440.0
2005-01-06 16:00:00	AMZN	Stock	2.052	2.065	2.052	2.063	655080.0
2005-01-06 17:00:00	AMZN	Stock	2.063	2.0675	2.0525	2.0675	993700.0
2005-01-06 18:00:00	AMZN	Stock	2.06	2.06	2.06	2.06	2000.0
2005-01-06 09:00:00	CL	Stock	24.75	24.875	24.625	24.825	876600.0
2005-01-06 10:00:00	CL	Stock	24.82	24.945	24.81	24.825	822600.0
2005-01-06 11:00:00	CL	Stock	24.835	24.98	24.825	24.965	838600.0
2005-01-06 12:00:00	CL	Stock	24.97	25.09	24.95	25.035	565600.0
2005-01-06 13:00:00	CL	Stock	25.04	25.255	25.035	25.25	575600.0
2005-01-06 14:00:00	CL	Stock	25.25	25.25	24.98	24.98	809800.0
2005-01-06 15:00:00	CL	Stock	24.985	24.985	24.855	24.88	1347400.0

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

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