PREVIEW / stock_1hour / 2005-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-04.parquet
  size:    556 KB
  rows:    25,969
  symbols: 1,916

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-04 08:00:00	AAPL	Stock	1.1348	1.1446	1.1348	1.1393	4573352.0
2005-01-04 09:00:00	AAPL	Stock	1.1311	1.1518	1.1309	1.1473	142757272.0
2005-01-04 10:00:00	AAPL	Stock	1.1475	1.1691	1.1339	1.1666	315973224.0
2005-01-04 11:00:00	AAPL	Stock	1.1666	1.168	1.1563	1.1589	131391960.0
2005-01-04 12:00:00	AAPL	Stock	1.1589	1.1598	1.1473	1.1536	113091552.0
2005-01-04 13:00:00	AAPL	Stock	1.1534	1.1545	1.1443	1.1469	72266824.0
2005-01-04 14:00:00	AAPL	Stock	1.147	1.147	1.1245	1.1377	171620736.0
2005-01-04 15:00:00	AAPL	Stock	1.1377	1.147	1.1268	1.1418	127396304.0
2005-01-04 16:00:00	AAPL	Stock	1.142	1.1438	1.1393	1.1438	3252312.0
2005-01-04 17:00:00	AAPL	Stock	1.1445	1.1473	1.1417	1.1454	1488200.0
2005-01-04 18:00:00	AAPL	Stock	1.1446	1.1473	1.1446	1.1473	126000.0
2005-01-04 08:00:00	MSFT	Stock	26.84	26.89	26.79	26.88	171214.0
2005-01-04 09:00:00	MSFT	Stock	26.87	27.03	26.8	26.95	17428251.0
2005-01-04 10:00:00	MSFT	Stock	26.95	27.1	26.88	26.9	18483102.0
2005-01-04 11:00:00	MSFT	Stock	26.89	27.08	26.87	26.98	13252637.0
2005-01-04 12:00:00	MSFT	Stock	26.98	26.98	26.89	26.95	9348169.0
2005-01-04 13:00:00	MSFT	Stock	26.95	26.98	26.9	26.91	6023954.0
2005-01-04 14:00:00	MSFT	Stock	26.91	26.92	26.66	26.81	13402447.0
2005-01-04 15:00:00	MSFT	Stock	26.81	26.99	26.68	26.84	26032480.0
2005-01-04 16:00:00	MSFT	Stock	26.83	26.93	26.8	26.84	2431607.0
2005-01-04 17:00:00	MSFT	Stock	26.86	26.86	26.71	26.84	310379.0
2005-01-04 18:00:00	MSFT	Stock	26.8	26.8	26.8	26.8	500.0
2005-01-04 08:00:00	NVDA	Stock	0.1965	0.1988	0.1965	0.1988	468240.0
2005-01-04 09:00:00	NVDA	Stock	0.1967	0.1982	0.193	0.1933	93807360.0
2005-01-04 10:00:00	NVDA	Stock	0.1933	0.1949	0.1907	0.1909	146971800.0
2005-01-04 11:00:00	NVDA	Stock	0.1908	0.1914	0.1899	0.1911	65871480.0
2005-01-04 12:00:00	NVDA	Stock	0.1912	0.1912	0.188	0.1886	94829160.0
2005-01-04 13:00:00	NVDA	Stock	0.1887	0.1935	0.1881	0.1885	51270360.0
2005-01-04 14:00:00	NVDA	Stock	0.1885	0.1888	0.1842	0.1862	163603080.0
2005-01-04 15:00:00	NVDA	Stock	0.1862	0.1878	0.1857	0.1871	142641240.0
2005-01-04 16:00:00	NVDA	Stock	0.1868	0.1889	0.1868	0.1877	15468360.0
2005-01-04 17:00:00	NVDA	Stock	0.1875	0.1875	0.1875	0.1875	204000.0
2005-01-04 18:00:00	NVDA	Stock	0.1875	0.1877	0.1875	0.1877	204000.0
2005-01-04 08:00:00	AMZN	Stock	2.144	2.159	2.1335	2.1405	4105220.0
2005-01-04 09:00:00	AMZN	Stock	2.1435	2.203	2.1265	2.127	88858120.0
2005-01-04 10:00:00	AMZN	Stock	2.127	2.163	2.1265	2.1415	83398360.0
2005-01-04 11:00:00	AMZN	Stock	2.1405	2.145	2.1125	2.1155	43882500.0
2005-01-04 12:00:00	AMZN	Stock	2.1155	2.118	2.09	2.0984	43190900.0
2005-01-04 13:00:00	AMZN	Stock	2.098	2.1065	2.093	2.097	23264760.0
2005-01-04 14:00:00	AMZN	Stock	2.096	2.096	2.075	2.082	39269860.0
2005-01-04 15:00:00	AMZN	Stock	2.082	2.1125	2.08	2.111	55349380.0
2005-01-04 16:00:00	AMZN	Stock	2.1075	2.113	2.1045	2.11	1658300.0
2005-01-04 17:00:00	AMZN	Stock	2.1125	2.1125	2.1068	2.109	1041000.0
2005-01-04 18:00:00	AMZN	Stock	2.1095	2.1105	2.1095	2.1105	30760.0
2005-01-04 09:00:00	CL	Stock	25.06	25.24	25.05	25.17	402600.0
2005-01-04 10:00:00	CL	Stock	25.16	25.225	25.135	25.155	401000.0
2005-01-04 11:00:00	CL	Stock	25.155	25.16	25.03	25.04	417400.0
2005-01-04 12:00:00	CL	Stock	25.0355	25.04	25.0	25.0	397400.0
2005-01-04 13:00:00	CL	Stock	25.0	25.045	24.975	24.995	470200.0
2005-01-04 14:00:00	CL	Stock	24.99	24.995	24.88	24.935	836200.0

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

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