PREVIEW / stock_1hour / 2000-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-06.parquet
  size:    281 KB
  rows:    14,315
  symbols: 1,153

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
2000-04-06 09:00:00	AAPL	Stock	1.1663	1.2009	1.1652	1.1775	36142400.0
2000-04-06 10:00:00	AAPL	Stock	1.1766	1.1853	1.1652	1.173	29512000.0
2000-04-06 11:00:00	AAPL	Stock	1.173	1.1847	1.1563	1.1624	32760000.0
2000-04-06 12:00:00	AAPL	Stock	1.1638	1.1741	1.154	1.1669	22579200.0
2000-04-06 13:00:00	AAPL	Stock	1.1657	1.1674	1.1585	1.1663	11076800.0
2000-04-06 14:00:00	AAPL	Stock	1.1629	1.1674	1.125	1.125	31953600.0
2000-04-06 15:00:00	AAPL	Stock	1.1253	1.1256	1.1004	1.1183	81838400.0
2000-04-06 16:00:00	AAPL	Stock	1.1177	1.1177	1.1177	1.1177	1164800.0
2000-04-06 09:00:00	MSFT	Stock	43.9375	44.0	43.4062	43.5938	10138000.0
2000-04-06 10:00:00	MSFT	Stock	43.5625	43.9688	43.4375	43.7188	13344000.0
2000-04-06 11:00:00	MSFT	Stock	43.6875	43.8125	43.4375	43.625	8689800.0
2000-04-06 12:00:00	MSFT	Stock	43.625	43.7812	43.4688	43.5	5847800.0
2000-04-06 13:00:00	MSFT	Stock	43.5	43.6875	43.375	43.5625	4701800.0
2000-04-06 14:00:00	MSFT	Stock	43.5625	43.6875	43.2188	43.3125	6652800.0
2000-04-06 15:00:00	MSFT	Stock	43.3125	43.3125	42.9062	43.0	13067600.0
2000-04-06 16:00:00	MSFT	Stock	43.0	43.0	42.9375	43.0	102000.0
2000-04-06 09:00:00	NVDA	Stock	0.1999	0.2013	0.1904	0.1912	43056000.0
2000-04-06 10:00:00	NVDA	Stock	0.1909	0.1962	0.1909	0.1947	46032000.0
2000-04-06 11:00:00	NVDA	Stock	0.1964	0.2065	0.1927	0.2031	107232000.0
2000-04-06 12:00:00	NVDA	Stock	0.2031	0.21	0.2018	0.2021	62592000.0
2000-04-06 13:00:00	NVDA	Stock	0.2026	0.2068	0.2021	0.2062	20112000.0
2000-04-06 14:00:00	NVDA	Stock	0.2062	0.2062	0.2021	0.2029	39984000.0
2000-04-06 15:00:00	NVDA	Stock	0.2031	0.2036	0.198	0.1999	62304000.0
2000-04-06 09:00:00	AMZN	Stock	3.1719	3.1719	3.1156	3.1156	11144000.0
2000-04-06 10:00:00	AMZN	Stock	3.1219	3.2188	3.1188	3.1719	17330000.0
2000-04-06 11:00:00	AMZN	Stock	3.175	3.2312	3.0938	3.1375	17576000.0
2000-04-06 12:00:00	AMZN	Stock	3.1375	3.2094	3.1062	3.1938	16910000.0
2000-04-06 13:00:00	AMZN	Stock	3.1938	3.2625	3.1844	3.1938	17612000.0
2000-04-06 14:00:00	AMZN	Stock	3.1969	3.2219	3.1562	3.1562	12116000.0
2000-04-06 15:00:00	AMZN	Stock	3.1562	3.225	3.1375	3.2125	19584000.0
2000-04-06 16:00:00	AMZN	Stock	3.2094	3.2125	3.2094	3.2125	350000.0
2000-04-06 09:00:00	CL	Stock	29.2812	29.3125	28.5	28.6875	585600.0
2000-04-06 10:00:00	CL	Stock	28.6875	29.5625	28.6562	29.2812	726400.0
2000-04-06 11:00:00	CL	Stock	29.2812	29.4375	29.0312	29.3125	385600.0
2000-04-06 12:00:00	CL	Stock	29.3125	29.8125	29.25	29.75	239000.0
2000-04-06 13:00:00	CL	Stock	29.8125	30.0	29.4688	29.4688	189200.0
2000-04-06 14:00:00	CL	Stock	29.4688	29.5312	29.1562	29.3125	349600.0
2000-04-06 15:00:00	CL	Stock	29.2812	29.5	29.0938	29.5	471000.0
2000-04-06 16:00:00	CL	Stock	29.4375	29.5	29.4375	29.5	87000.0

> showing 39 of 14,315 rows — these rows as CSV

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