PREVIEW / stock_1hour / 2000-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-03-24.parquet
  size:    288 KB
  rows:    14,502
  symbols: 1,146

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-03-24 09:00:00	AAPL	Stock	1.2718	1.2852	1.2344	1.2467	48910400.0
2000-03-24 10:00:00	AAPL	Stock	1.2478	1.2779	1.2478	1.2684	74020800.0
2000-03-24 11:00:00	AAPL	Stock	1.2684	1.2801	1.2567	1.2589	49044800.0
2000-03-24 12:00:00	AAPL	Stock	1.26	1.2612	1.2455	1.2483	66393600.0
2000-03-24 13:00:00	AAPL	Stock	1.2483	1.2511	1.2182	1.2199	49761600.0
2000-03-24 14:00:00	AAPL	Stock	1.2193	1.2461	1.2098	1.2098	71288000.0
2000-03-24 15:00:00	AAPL	Stock	1.2098	1.2388	1.2098	1.2372	63347200.0
2000-03-24 16:00:00	AAPL	Stock	1.2377	1.2383	1.2377	1.2383	716800.0
2000-03-24 09:00:00	MSFT	Stock	56.3125	56.5	55.25	55.6562	13424000.0
2000-03-24 10:00:00	MSFT	Stock	55.625	57.5	55.1562	57.375	26374000.0
2000-03-24 11:00:00	MSFT	Stock	57.4062	57.5	56.2812	56.5938	13921400.0
2000-03-24 12:00:00	MSFT	Stock	56.5938	56.875	56.2188	56.625	6818000.0
2000-03-24 13:00:00	MSFT	Stock	56.6562	56.875	55.1562	55.2031	11787400.0
2000-03-24 14:00:00	MSFT	Stock	55.2188	55.875	54.7812	55.0	12847800.0
2000-03-24 15:00:00	MSFT	Stock	55.0	57.25	55.0	55.8438	20900000.0
2000-03-24 16:00:00	MSFT	Stock	55.8438	55.8438	55.8125	55.8438	128800.0
2000-03-24 09:00:00	NVDA	Stock	0.2013	0.2104	0.2013	0.2073	14784000.0
2000-03-24 10:00:00	NVDA	Stock	0.2073	0.2086	0.2046	0.207	21552000.0
2000-03-24 11:00:00	NVDA	Stock	0.2082	0.2083	0.2022	0.2078	34128000.0
2000-03-24 12:00:00	NVDA	Stock	0.2062	0.2076	0.2042	0.2052	8352000.0
2000-03-24 13:00:00	NVDA	Stock	0.2047	0.207	0.1979	0.1982	15456000.0
2000-03-24 14:00:00	NVDA	Stock	0.1982	0.2005	0.1885	0.1915	57312000.0
2000-03-24 15:00:00	NVDA	Stock	0.1917	0.1971	0.1875	0.194	73488000.0
2000-03-24 16:00:00	NVDA	Stock	0.1941	0.1941	0.1941	0.1941	1296000.0
2000-03-24 09:00:00	AMZN	Stock	3.7312	3.7531	3.6406	3.6734	56320000.0
2000-03-24 10:00:00	AMZN	Stock	3.675	3.7625	3.65	3.725	35694000.0
2000-03-24 11:00:00	AMZN	Stock	3.725	3.7312	3.6625	3.6875	13844000.0
2000-03-24 12:00:00	AMZN	Stock	3.6906	3.7562	3.6625	3.6812	22046000.0
2000-03-24 13:00:00	AMZN	Stock	3.6812	3.7188	3.6125	3.6297	14214000.0
2000-03-24 14:00:00	AMZN	Stock	3.625	3.6656	3.5688	3.5844	17804000.0
2000-03-24 15:00:00	AMZN	Stock	3.5844	3.6656	3.5656	3.6344	17590000.0
2000-03-24 16:00:00	AMZN	Stock	3.6312	3.6344	3.6312	3.6344	220000.0
2000-03-24 09:00:00	CL	Stock	26.5938	27.6562	26.5938	27.625	453200.0
2000-03-24 10:00:00	CL	Stock	27.6562	28.0	27.5625	27.8438	954000.0
2000-03-24 11:00:00	CL	Stock	27.8438	27.8438	27.625	27.6875	585000.0
2000-03-24 12:00:00	CL	Stock	27.6562	27.6875	27.2812	27.3125	710600.0
2000-03-24 13:00:00	CL	Stock	27.3438	27.4062	27.2188	27.2188	562800.0
2000-03-24 14:00:00	CL	Stock	27.25	27.3125	27.1562	27.3125	519400.0
2000-03-24 15:00:00	CL	Stock	27.3125	27.3438	27.1562	27.2188	692000.0
2000-03-24 16:00:00	CL	Stock	27.2188	27.2188	27.1875	27.1875	77600.0

> showing 40 of 14,502 rows — these rows as CSV

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