PREVIEW / stock_1hour / 2005-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-06.parquet
  size:    546 KB
  rows:    25,847
  symbols: 1,952

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-04-06 08:00:00	AAPL	Stock	1.49	1.5125	1.49	1.5082	2314620.0
2005-04-06 09:00:00	AAPL	Stock	1.5071	1.5214	1.5	1.5171	74763472.0
2005-04-06 10:00:00	AAPL	Stock	1.5171	1.5279	1.515	1.52	97463968.0
2005-04-06 11:00:00	AAPL	Stock	1.52	1.5289	1.5186	1.525	49101108.0
2005-04-06 12:00:00	AAPL	Stock	1.5246	1.5268	1.5193	1.5218	34524896.0
2005-04-06 13:00:00	AAPL	Stock	1.5221	1.5257	1.5157	1.5186	37189936.0
2005-04-06 14:00:00	AAPL	Stock	1.5189	1.5236	1.515	1.5164	37219196.0
2005-04-06 15:00:00	AAPL	Stock	1.5168	1.5168	1.5054	1.5114	73897824.0
2005-04-06 16:00:00	AAPL	Stock	1.5114	1.5196	1.5111	1.5154	2009644.0
2005-04-06 17:00:00	AAPL	Stock	1.515	1.5179	1.5109	1.5132	1287132.0
2005-04-06 18:00:00	AAPL	Stock	1.5136	1.5175	1.5136	1.5175	128240.0
2005-04-06 08:00:00	MSFT	Stock	24.48	24.49	24.46	24.49	9134.0
2005-04-06 09:00:00	MSFT	Stock	24.47	24.75	24.449	24.64	12812818.0
2005-04-06 10:00:00	MSFT	Stock	24.64	24.88	24.62	24.85	17828829.0
2005-04-06 11:00:00	MSFT	Stock	24.84	24.94	24.82	24.839	11558700.0
2005-04-06 12:00:00	MSFT	Stock	24.84	24.91	24.82	24.86	6522158.0
2005-04-06 13:00:00	MSFT	Stock	24.86	24.881	24.71	24.76	7646074.0
2005-04-06 14:00:00	MSFT	Stock	24.76	24.84	24.74	24.79	6947150.0
2005-04-06 15:00:00	MSFT	Stock	24.781	24.81	24.66	24.67	11753646.0
2005-04-06 16:00:00	MSFT	Stock	24.67	24.77	24.67	24.75	872114.0
2005-04-06 17:00:00	MSFT	Stock	24.68	24.746	24.62	24.62	134652.0
2005-04-06 18:00:00	MSFT	Stock	24.67	24.67	24.62	24.62	9910.0
2005-04-06 08:00:00	NVDA	Stock	0.1937	0.1956	0.1937	0.1954	1197960.0
2005-04-06 09:00:00	NVDA	Stock	0.1952	0.1977	0.1935	0.195	98975760.0
2005-04-06 10:00:00	NVDA	Stock	0.1951	0.1983	0.1948	0.1963	138931800.0
2005-04-06 11:00:00	NVDA	Stock	0.1962	0.1982	0.1962	0.1977	68836440.0
2005-04-06 12:00:00	NVDA	Stock	0.1977	0.1978	0.1966	0.1968	75679080.0
2005-04-06 13:00:00	NVDA	Stock	0.1969	0.197	0.1959	0.1965	27288600.0
2005-04-06 14:00:00	NVDA	Stock	0.1965	0.1967	0.1957	0.1957	34837800.0
2005-04-06 15:00:00	NVDA	Stock	0.1957	0.1961	0.1937	0.1947	113892120.0
2005-04-06 16:00:00	NVDA	Stock	0.1947	0.1956	0.1944	0.1944	2701560.0
2005-04-06 17:00:00	NVDA	Stock	0.1952	0.1955	0.195	0.195	399600.0
2005-04-06 18:00:00	NVDA	Stock	0.1955	0.1955	0.1955	0.1955	84000.0
2005-04-06 09:00:00	AMZN	Stock	1.7625	1.764	1.7415	1.742	21161360.0
2005-04-06 10:00:00	AMZN	Stock	1.742	1.747	1.736	1.7375	26145540.0
2005-04-06 11:00:00	AMZN	Stock	1.738	1.75	1.7375	1.7385	13957900.0
2005-04-06 12:00:00	AMZN	Stock	1.739	1.743	1.736	1.736	5362800.0
2005-04-06 13:00:00	AMZN	Stock	1.7365	1.7415	1.734	1.7355	4882240.0
2005-04-06 14:00:00	AMZN	Stock	1.735	1.7425	1.7345	1.74	10211940.0
2005-04-06 15:00:00	AMZN	Stock	1.74	1.741	1.731	1.741	21325840.0
2005-04-06 16:00:00	AMZN	Stock	1.74	1.741	1.7355	1.7395	1291480.0
2005-04-06 17:00:00	AMZN	Stock	1.741	1.741	1.735	1.7375	617280.0
2005-04-06 09:00:00	CL	Stock	26.245	26.25	26.13	26.225	223800.0
2005-04-06 10:00:00	CL	Stock	26.21	26.33	26.18	26.31	448800.0
2005-04-06 11:00:00	CL	Stock	26.31	26.4	26.275	26.37	370200.0
2005-04-06 12:00:00	CL	Stock	26.365	26.42	26.315	26.4	271200.0
2005-04-06 13:00:00	CL	Stock	26.395	26.435	26.27	26.325	276600.0
2005-04-06 14:00:00	CL	Stock	26.335	26.405	26.29	26.32	207200.0
2005-04-06 15:00:00	CL	Stock	26.325	26.415	26.325	26.4	687800.0
2005-04-06 16:00:00	CL	Stock	26.41	26.41	26.41	26.41	4400.0

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

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