PREVIEW / stock_1hour / 2004-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-12-31.parquet
  size:    529 KB
  rows:    25,032
  symbols: 1,904

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-31 08:00:00	AAPL	Stock	1.1589	1.165	1.1589	1.1616	1251040.0
2004-12-31 09:00:00	AAPL	Stock	1.1616	1.1616	1.1545	1.1564	30028768.0
2004-12-31 10:00:00	AAPL	Stock	1.1566	1.1593	1.1518	1.155	41361208.0
2004-12-31 11:00:00	AAPL	Stock	1.1554	1.1554	1.15	1.152	33848920.0
2004-12-31 12:00:00	AAPL	Stock	1.1518	1.1548	1.1434	1.15	38413144.0
2004-12-31 13:00:00	AAPL	Stock	1.15	1.1561	1.15	1.1539	25552576.0
2004-12-31 14:00:00	AAPL	Stock	1.1539	1.158	1.1539	1.1555	26195792.0
2004-12-31 15:00:00	AAPL	Stock	1.1555	1.1589	1.1479	1.15	57715448.0
2004-12-31 16:00:00	AAPL	Stock	1.1495	1.15	1.1471	1.15	13899984.0
2004-12-31 17:00:00	AAPL	Stock	1.1486	1.1495	1.1486	1.1491	67200.0
2004-12-31 18:00:00	AAPL	Stock	1.1491	1.1491	1.1491	1.1491	61600.0
2004-12-31 08:00:00	MSFT	Stock	26.8	26.82	26.78	26.8	34000.0
2004-12-31 09:00:00	MSFT	Stock	26.81	26.86	26.74	26.84	5993540.0
2004-12-31 10:00:00	MSFT	Stock	26.84	26.85	26.77	26.79	4810675.0
2004-12-31 11:00:00	MSFT	Stock	26.79	26.81	26.73	26.75	8586404.0
2004-12-31 12:00:00	MSFT	Stock	26.75	26.78	26.71	26.75	7037766.0
2004-12-31 13:00:00	MSFT	Stock	26.75	26.79	26.74	26.78	5826180.0
2004-12-31 14:00:00	MSFT	Stock	26.77	26.8	26.75	26.761	6182813.0
2004-12-31 15:00:00	MSFT	Stock	26.7673	26.81	26.679	26.72	13104222.0
2004-12-31 16:00:00	MSFT	Stock	26.72	26.73	26.66	26.69	2497823.0
2004-12-31 17:00:00	MSFT	Stock	26.69	26.72	26.68	26.72	7283.0
2004-12-31 18:00:00	MSFT	Stock	26.69	26.69	26.68	26.68	6800.0
2004-12-31 08:00:00	NVDA	Stock	0.1925	0.1975	0.1912	0.1949	11361720.0
2004-12-31 09:00:00	NVDA	Stock	0.1948	0.1962	0.1906	0.195	132536520.0
2004-12-31 10:00:00	NVDA	Stock	0.1949	0.1973	0.1943	0.1962	120324000.0
2004-12-31 11:00:00	NVDA	Stock	0.1962	0.1968	0.1951	0.1952	69623280.0
2004-12-31 12:00:00	NVDA	Stock	0.1952	0.1962	0.1952	0.196	39807960.0
2004-12-31 13:00:00	NVDA	Stock	0.1961	0.1965	0.1958	0.1961	33164760.0
2004-12-31 14:00:00	NVDA	Stock	0.196	0.1971	0.1959	0.1963	50128320.0
2004-12-31 15:00:00	NVDA	Stock	0.1963	0.1968	0.1957	0.1964	110289480.0
2004-12-31 16:00:00	NVDA	Stock	0.1964	0.1965	0.1954	0.1954	5319360.0
2004-12-31 17:00:00	NVDA	Stock	0.1962	0.1962	0.1962	0.1962	12000.0
2004-12-31 18:00:00	NVDA	Stock	0.1962	0.1962	0.1962	0.1962	18000.0
2004-12-31 08:00:00	AMZN	Stock	2.2595	2.2645	2.2485	2.26	141880.0
2004-12-31 09:00:00	AMZN	Stock	2.2575	2.2745	2.2525	2.2585	13564240.0
2004-12-31 10:00:00	AMZN	Stock	2.258	2.262	2.253	2.2585	10899740.0
2004-12-31 11:00:00	AMZN	Stock	2.2584	2.2605	2.2535	2.2579	9594060.0
2004-12-31 12:00:00	AMZN	Stock	2.258	2.26	2.2495	2.25	6962120.0
2004-12-31 13:00:00	AMZN	Stock	2.2495	2.253	2.249	2.2515	4047520.0
2004-12-31 14:00:00	AMZN	Stock	2.2515	2.2535	2.247	2.247	6086140.0
2004-12-31 15:00:00	AMZN	Stock	2.2475	2.2475	2.208	2.213	42046660.0
2004-12-31 16:00:00	AMZN	Stock	2.213	2.2175	2.2075	2.2145	2149280.0
2004-12-31 17:00:00	AMZN	Stock	2.2145	2.2145	2.2125	2.2125	94600.0
2004-12-31 09:00:00	CL	Stock	25.65	25.67	25.475	25.56	237200.0
2004-12-31 10:00:00	CL	Stock	25.55	25.555	25.475	25.53	261200.0
2004-12-31 11:00:00	CL	Stock	25.53	25.53	25.41	25.495	430000.0
2004-12-31 12:00:00	CL	Stock	25.5	25.585	25.5	25.585	307200.0
2004-12-31 13:00:00	CL	Stock	25.58	25.6	25.57	25.57	168800.0
2004-12-31 14:00:00	CL	Stock	25.57	25.65	25.55	25.59	259000.0
2004-12-31 15:00:00	CL	Stock	25.59	25.63	25.55	25.58	648400.0

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

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