PREVIEW / stock_1hour / 2000-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-14.parquet
  size:    298 KB
  rows:    15,345
  symbols: 1,220

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-09-14 08:00:00	AAPL	Stock	1.0352	1.0536	1.0352	1.0513	2861600.0
2000-09-14 09:00:00	AAPL	Stock	1.0469	1.0603	1.0435	1.0525	34994400.0
2000-09-14 10:00:00	AAPL	Stock	1.0525	1.0647	1.048	1.0525	94186400.0
2000-09-14 11:00:00	AAPL	Stock	1.0525	1.0547	1.0486	1.0525	25788000.0
2000-09-14 12:00:00	AAPL	Stock	1.0536	1.0536	1.0446	1.048	70795200.0
2000-09-14 13:00:00	AAPL	Stock	1.0469	1.0513	1.0435	1.0469	48540800.0
2000-09-14 14:00:00	AAPL	Stock	1.0469	1.0569	1.0458	1.0491	24040800.0
2000-09-14 15:00:00	AAPL	Stock	1.0469	1.0469	1.0145	1.0179	73791200.0
2000-09-14 16:00:00	AAPL	Stock	1.0156	1.0536	1.0006	1.0151	26779200.0
2000-09-14 17:00:00	AAPL	Stock	1.0089	1.0089	1.0089	1.0089	16800.0
2000-09-14 08:00:00	MSFT	Stock	34.625	34.75	34.1094	34.5	418600.0
2000-09-14 09:00:00	MSFT	Stock	34.3125	34.5	34.0625	34.125	7429400.0
2000-09-14 10:00:00	MSFT	Stock	34.125	34.1875	33.8438	33.875	9541600.0
2000-09-14 11:00:00	MSFT	Stock	33.875	33.9375	33.6875	33.75	5825400.0
2000-09-14 12:00:00	MSFT	Stock	33.75	33.7812	33.5	33.5625	8996000.0
2000-09-14 13:00:00	MSFT	Stock	33.5938	33.5938	32.9062	33.0938	15878800.0
2000-09-14 14:00:00	MSFT	Stock	33.0938	33.375	33.0625	33.2188	6916000.0
2000-09-14 15:00:00	MSFT	Stock	33.2188	33.25	32.8438	32.9375	15373600.0
2000-09-14 16:00:00	MSFT	Stock	32.9375	33.8125	32.6875	32.875	1615800.0
2000-09-14 17:00:00	MSFT	Stock	32.875	33.0	32.8125	32.9375	38000.0
2000-09-14 18:00:00	MSFT	Stock	32.9375	33.0625	32.9375	33.0	5200.0
2000-09-14 09:00:00	NVDA	Stock	0.2945	0.3016	0.2919	0.2977	60192000.0
2000-09-14 10:00:00	NVDA	Stock	0.2992	0.3063	0.2984	0.3034	50544000.0
2000-09-14 11:00:00	NVDA	Stock	0.3036	0.3052	0.301	0.3036	28080000.0
2000-09-14 12:00:00	NVDA	Stock	0.3036	0.3047	0.2982	0.301	12936000.0
2000-09-14 13:00:00	NVDA	Stock	0.301	0.301	0.2979	0.2982	7824000.0
2000-09-14 14:00:00	NVDA	Stock	0.2995	0.3005	0.2979	0.2997	3744000.0
2000-09-14 15:00:00	NVDA	Stock	0.3029	0.3042	0.2854	0.2896	33312000.0
2000-09-14 16:00:00	NVDA	Stock	0.2891	0.2945	0.2891	0.2927	1704000.0
2000-09-14 17:00:00	NVDA	Stock	0.2917	0.2917	0.2911	0.2911	72000.0
2000-09-14 08:00:00	AMZN	Stock	2.1312	2.2125	2.1312	2.1875	692000.0
2000-09-14 09:00:00	AMZN	Stock	2.1922	2.25	2.1781	2.2094	20472000.0
2000-09-14 10:00:00	AMZN	Stock	2.2063	2.2906	2.2063	2.2625	31198000.0
2000-09-14 11:00:00	AMZN	Stock	2.2625	2.2891	2.2562	2.2656	15878000.0
2000-09-14 12:00:00	AMZN	Stock	2.2703	2.2812	2.2469	2.2719	10980000.0
2000-09-14 13:00:00	AMZN	Stock	2.2719	2.2844	2.2375	2.2625	10970000.0
2000-09-14 14:00:00	AMZN	Stock	2.2625	2.2969	2.2438	2.2594	13240000.0
2000-09-14 15:00:00	AMZN	Stock	2.25	2.275	2.2312	2.2469	18436000.0
2000-09-14 16:00:00	AMZN	Stock	2.2406	2.2562	2.2328	2.2562	1886000.0
2000-09-14 17:00:00	AMZN	Stock	2.25	2.2656	2.25	2.2625	86000.0
2000-09-14 18:00:00	AMZN	Stock	2.2656	2.2688	2.2656	2.2688	46000.0
2000-09-14 09:00:00	CL	Stock	24.25	24.625	24.125	24.625	3677600.0
2000-09-14 10:00:00	CL	Stock	24.625	24.8125	23.7188	23.8438	7128400.0
2000-09-14 11:00:00	CL	Stock	23.8438	24.0625	23.6875	23.75	4409000.0
2000-09-14 12:00:00	CL	Stock	23.7812	24.3125	23.75	24.2812	4048400.0
2000-09-14 13:00:00	CL	Stock	24.2812	24.3438	23.8438	23.875	3094800.0
2000-09-14 14:00:00	CL	Stock	23.8438	23.9375	23.7188	23.8125	3266600.0
2000-09-14 15:00:00	CL	Stock	23.6562	23.7812	23.4375	23.625	6812200.0
2000-09-14 16:00:00	CL	Stock	23.625	23.75	23.25	23.75	380400.0
2000-09-14 17:00:00	CL	Stock	23.625	23.75	23.625	23.75	184000.0

> showing 50 of 15,345 rows — these rows as CSV

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