PREVIEW / stock_1hour / 2000-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-21.parquet
  size:    304 KB
  rows:    15,520
  symbols: 1,214

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-21 08:00:00	AAPL	Stock	1.0848	1.0848	1.0469	1.0536	4468800.0
2000-09-21 09:00:00	AAPL	Stock	1.0536	1.0681	1.0402	1.0491	58850400.0
2000-09-21 10:00:00	AAPL	Stock	1.0491	1.0513	1.0246	1.0246	61577600.0
2000-09-21 11:00:00	AAPL	Stock	1.0246	1.0246	1.0045	1.01	60317600.0
2000-09-21 12:00:00	AAPL	Stock	1.01	1.0201	1.0089	1.0128	62042400.0
2000-09-21 13:00:00	AAPL	Stock	1.0123	1.0167	1.0011	1.0067	40734400.0
2000-09-21 14:00:00	AAPL	Stock	1.0056	1.0089	0.9911	0.9978	69008800.0
2000-09-21 15:00:00	AAPL	Stock	0.9978	1.0134	0.9866	1.0112	109844000.0
2000-09-21 16:00:00	AAPL	Stock	1.0112	1.0128	0.9308	0.9464	16900800.0
2000-09-21 17:00:00	AAPL	Stock	0.9375	0.9375	0.9007	0.9107	10326400.0
2000-09-21 18:00:00	AAPL	Stock	0.9113	0.9113	0.8929	0.9018	1360800.0
2000-09-21 08:00:00	MSFT	Stock	32.0312	32.3125	31.6562	31.9375	122800.0
2000-09-21 09:00:00	MSFT	Stock	32.0	32.4375	31.875	32.1875	5386800.0
2000-09-21 10:00:00	MSFT	Stock	32.1875	32.4375	32.125	32.4375	6659600.0
2000-09-21 11:00:00	MSFT	Stock	32.4062	32.4062	32.0312	32.2812	5935800.0
2000-09-21 12:00:00	MSFT	Stock	32.2812	32.5625	32.2812	32.3125	5487600.0
2000-09-21 13:00:00	MSFT	Stock	32.3438	32.4062	32.125	32.2812	4154800.0
2000-09-21 14:00:00	MSFT	Stock	32.2812	32.2812	31.875	32.0	4647800.0
2000-09-21 15:00:00	MSFT	Stock	32.0	32.1875	31.7812	32.0938	6805400.0
2000-09-21 16:00:00	MSFT	Stock	32.0938	32.5	30.0625	30.3125	6306000.0
2000-09-21 17:00:00	MSFT	Stock	30.4375	31.2812	30.0	30.125	1964000.0
2000-09-21 18:00:00	MSFT	Stock	30.1562	30.5938	30.0	30.5625	240800.0
2000-09-21 08:00:00	NVDA	Stock	0.2708	0.2792	0.2708	0.2792	72000.0
2000-09-21 09:00:00	NVDA	Stock	0.2773	0.288	0.2763	0.2852	72384000.0
2000-09-21 10:00:00	NVDA	Stock	0.2852	0.2891	0.2807	0.2865	51624000.0
2000-09-21 11:00:00	NVDA	Stock	0.2865	0.287	0.2802	0.2857	34200000.0
2000-09-21 12:00:00	NVDA	Stock	0.2854	0.2878	0.2839	0.2862	19272000.0
2000-09-21 13:00:00	NVDA	Stock	0.2854	0.2896	0.2844	0.2891	31536000.0
2000-09-21 14:00:00	NVDA	Stock	0.2891	0.2896	0.2844	0.2875	19296000.0
2000-09-21 15:00:00	NVDA	Stock	0.2875	0.2956	0.2854	0.2893	99240000.0
2000-09-21 16:00:00	NVDA	Stock	0.2892	0.2906	0.2708	0.2724	5760000.0
2000-09-21 17:00:00	NVDA	Stock	0.2724	0.2729	0.2708	0.2708	192000.0
2000-09-21 18:00:00	NVDA	Stock	0.2688	0.2688	0.2688	0.2688	48000.0
2000-09-21 08:00:00	AMZN	Stock	1.875	1.8812	1.85	1.875	206000.0
2000-09-21 09:00:00	AMZN	Stock	1.875	2.0125	1.8625	1.975	26002000.0
2000-09-21 10:00:00	AMZN	Stock	1.975	1.9875	1.9375	1.95	22868000.0
2000-09-21 11:00:00	AMZN	Stock	1.9531	1.9531	1.9125	1.9344	20656000.0
2000-09-21 12:00:00	AMZN	Stock	1.9344	1.9531	1.9031	1.95	8636000.0
2000-09-21 13:00:00	AMZN	Stock	1.95	1.9781	1.9469	1.9531	16358000.0
2000-09-21 14:00:00	AMZN	Stock	1.9531	1.9969	1.9531	1.9906	19886000.0
2000-09-21 15:00:00	AMZN	Stock	1.9906	2.025	1.9781	2.0	24708000.0
2000-09-21 16:00:00	AMZN	Stock	2.0031	2.0062	1.9	1.9	3334000.0
2000-09-21 17:00:00	AMZN	Stock	1.9125	1.9406	1.9	1.9125	520000.0
2000-09-21 18:00:00	AMZN	Stock	1.9156	1.9188	1.9	1.9125	80000.0
2000-09-21 09:00:00	CL	Stock	21.5938	21.8125	21.25	21.625	1333400.0
2000-09-21 10:00:00	CL	Stock	21.625	23.0	21.375	22.7812	3575600.0
2000-09-21 11:00:00	CL	Stock	22.75	22.75	22.375	22.5312	1395600.0
2000-09-21 12:00:00	CL	Stock	22.5312	22.5312	22.0312	22.1562	848200.0
2000-09-21 13:00:00	CL	Stock	22.125	22.2188	21.875	22.0	399200.0
2000-09-21 14:00:00	CL	Stock	21.9688	22.0	21.75	21.9688	768800.0

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

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