PREVIEW / stock_1hour / 2000-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-13.parquet
  size:    307 KB
  rows:    15,636
  symbols: 1,192

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-07-13 08:00:00	AAPL	Stock	1.0502	1.0502	1.0502	1.0502	1260000.0
2000-07-13 09:00:00	AAPL	Stock	1.0491	1.0692	1.0379	1.067	40045600.0
2000-07-13 10:00:00	AAPL	Stock	1.0647	1.0826	1.0592	1.0781	84403200.0
2000-07-13 11:00:00	AAPL	Stock	1.0804	1.0804	1.0647	1.0748	50881600.0
2000-07-13 12:00:00	AAPL	Stock	1.0742	1.0792	1.0569	1.0625	28324800.0
2000-07-13 13:00:00	AAPL	Stock	1.067	1.067	1.0547	1.0614	44710400.0
2000-07-13 14:00:00	AAPL	Stock	1.0603	1.0636	0.9777	1.0006	67328800.0
2000-07-13 15:00:00	AAPL	Stock	1.0022	1.0335	1.0011	1.01	111904800.0
2000-07-13 16:00:00	AAPL	Stock	1.01	1.0737	0.9955	1.0179	4104800.0
2000-07-13 17:00:00	AAPL	Stock	1.0067	1.019	1.0067	1.0123	296800.0
2000-07-13 18:00:00	AAPL	Stock	1.0089	1.01	1.0089	1.01	33600.0
2000-07-13 08:00:00	MSFT	Stock	39.375	40.1719	39.25	39.8438	250800.0
2000-07-13 09:00:00	MSFT	Stock	39.875	40.0	39.0312	39.125	11966000.0
2000-07-13 10:00:00	MSFT	Stock	39.1562	39.8125	38.6875	39.5938	22600000.0
2000-07-13 11:00:00	MSFT	Stock	39.5938	39.6562	39.125	39.2188	7148800.0
2000-07-13 12:00:00	MSFT	Stock	39.1875	39.3125	39.0938	39.125	5769400.0
2000-07-13 13:00:00	MSFT	Stock	39.1562	39.9062	39.0938	39.8438	11370200.0
2000-07-13 14:00:00	MSFT	Stock	39.8438	39.9688	39.5312	39.6875	7557200.0
2000-07-13 15:00:00	MSFT	Stock	39.6562	40.0	39.5625	39.9688	11340600.0
2000-07-13 16:00:00	MSFT	Stock	39.9375	40.0312	39.375	39.8125	1141800.0
2000-07-13 17:00:00	MSFT	Stock	39.875	40.125	39.6875	39.75	126000.0
2000-07-13 18:00:00	MSFT	Stock	39.75	39.8125	39.75	39.8125	2000.0
2000-07-13 08:00:00	NVDA	Stock	0.2849	0.2849	0.2849	0.2849	120000.0
2000-07-13 09:00:00	NVDA	Stock	0.2896	0.3	0.2875	0.2974	39528000.0
2000-07-13 10:00:00	NVDA	Stock	0.2974	0.2974	0.2896	0.2945	49248000.0
2000-07-13 11:00:00	NVDA	Stock	0.2945	0.3109	0.2945	0.3091	160992000.0
2000-07-13 12:00:00	NVDA	Stock	0.3089	0.3104	0.303	0.303	51504000.0
2000-07-13 13:00:00	NVDA	Stock	0.3025	0.3073	0.3016	0.3063	29328000.0
2000-07-13 14:00:00	NVDA	Stock	0.3063	0.3102	0.301	0.3036	45216000.0
2000-07-13 15:00:00	NVDA	Stock	0.3031	0.3115	0.3031	0.3099	65400000.0
2000-07-13 16:00:00	NVDA	Stock	0.3099	0.3104	0.307	0.3099	3528000.0
2000-07-13 17:00:00	NVDA	Stock	0.3083	0.3083	0.3073	0.3073	216000.0
2000-07-13 18:00:00	NVDA	Stock	0.3083	0.3083	0.3083	0.3083	48000.0
2000-07-13 08:00:00	AMZN	Stock	1.7625	1.7688	1.7562	1.7688	86000.0
2000-07-13 09:00:00	AMZN	Stock	1.7688	1.8	1.7562	1.7906	27194000.0
2000-07-13 10:00:00	AMZN	Stock	1.7844	1.7875	1.7625	1.7781	26382000.0
2000-07-13 11:00:00	AMZN	Stock	1.7781	1.7844	1.7656	1.7781	45960000.0
2000-07-13 12:00:00	AMZN	Stock	1.7781	1.7875	1.7719	1.7781	16024000.0
2000-07-13 13:00:00	AMZN	Stock	1.7812	1.7875	1.775	1.7812	9758000.0
2000-07-13 14:00:00	AMZN	Stock	1.7812	1.7938	1.7781	1.7844	11664000.0
2000-07-13 15:00:00	AMZN	Stock	1.7875	1.7969	1.7438	1.7438	28804000.0
2000-07-13 16:00:00	AMZN	Stock	1.7531	1.7625	1.7469	1.75	4872000.0
2000-07-13 17:00:00	AMZN	Stock	1.7516	1.7875	1.75	1.7875	42000.0
2000-07-13 18:00:00	AMZN	Stock	1.7562	1.7562	1.75	1.75	52000.0
2000-07-13 09:00:00	CL	Stock	26.5	26.5312	25.5	25.5312	1104600.0
2000-07-13 10:00:00	CL	Stock	25.5312	25.875	25.5	25.875	2135200.0
2000-07-13 11:00:00	CL	Stock	25.875	26.125	25.8438	26.125	2271800.0
2000-07-13 12:00:00	CL	Stock	26.0938	26.125	25.9062	26.0	627800.0
2000-07-13 13:00:00	CL	Stock	26.0	26.0938	25.9688	26.0	716000.0
2000-07-13 14:00:00	CL	Stock	25.9688	26.3125	25.9688	26.2812	1990600.0

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

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