PREVIEW / stock_1hour / 2000-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-10-06.parquet
  size:    304 KB
  rows:    15,551
  symbols: 1,232

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-10-06 08:00:00	AAPL	Stock	0.4007	0.4063	0.3945	0.404	1456560.0
2000-10-06 09:00:00	AAPL	Stock	0.4007	0.4096	0.3996	0.404	69848800.0
2000-10-06 10:00:00	AAPL	Stock	0.4029	0.4096	0.3951	0.3962	115287200.0
2000-10-06 11:00:00	AAPL	Stock	0.3951	0.4018	0.394	0.3962	67149600.0
2000-10-06 12:00:00	AAPL	Stock	0.3973	0.3996	0.394	0.3962	57736000.0
2000-10-06 13:00:00	AAPL	Stock	0.3962	0.3984	0.3917	0.3984	103779200.0
2000-10-06 14:00:00	AAPL	Stock	0.3984	0.4018	0.394	0.3973	57624000.0
2000-10-06 15:00:00	AAPL	Stock	0.3973	0.3996	0.3917	0.3962	102692800.0
2000-10-06 16:00:00	AAPL	Stock	0.3962	0.3984	0.3929	0.3962	14996800.0
2000-10-06 17:00:00	AAPL	Stock	0.3973	0.399	0.3951	0.3962	313600.0
2000-10-06 18:00:00	AAPL	Stock	0.3973	0.3973	0.3973	0.3973	67200.0
2000-10-06 08:00:00	MSFT	Stock	27.8125	28.1875	27.5312	27.75	54000.0
2000-10-06 09:00:00	MSFT	Stock	27.75	28.25	27.75	27.9375	7224000.0
2000-10-06 10:00:00	MSFT	Stock	27.9375	28.375	27.75	27.7812	9635400.0
2000-10-06 11:00:00	MSFT	Stock	27.7812	27.9062	27.5	27.625	9722600.0
2000-10-06 12:00:00	MSFT	Stock	27.625	27.875	27.5625	27.7188	6746800.0
2000-10-06 13:00:00	MSFT	Stock	27.7188	27.9688	27.5312	27.9375	5835600.0
2000-10-06 14:00:00	MSFT	Stock	27.9375	27.9688	27.5	27.5625	7531800.0
2000-10-06 15:00:00	MSFT	Stock	27.5625	27.8438	27.375	27.7812	10611600.0
2000-10-06 16:00:00	MSFT	Stock	27.7656	28.0312	27.4062	27.5625	2248600.0
2000-10-06 17:00:00	MSFT	Stock	27.5938	27.8125	27.5312	27.75	17000.0
2000-10-06 18:00:00	MSFT	Stock	27.75	27.7812	27.7344	27.75	2800.0
2000-10-06 08:00:00	NVDA	Stock	0.3063	0.3125	0.3063	0.3125	34368000.0
2000-10-06 09:00:00	NVDA	Stock	0.3125	0.3146	0.2938	0.2984	241848000.0
2000-10-06 10:00:00	NVDA	Stock	0.2984	0.2987	0.2875	0.2875	137544000.0
2000-10-06 11:00:00	NVDA	Stock	0.2875	0.2927	0.281	0.2911	158016000.0
2000-10-06 12:00:00	NVDA	Stock	0.2914	0.293	0.2896	0.2909	58848000.0
2000-10-06 13:00:00	NVDA	Stock	0.2906	0.2917	0.2813	0.2867	70944000.0
2000-10-06 14:00:00	NVDA	Stock	0.2867	0.2906	0.2844	0.2865	62400000.0
2000-10-06 15:00:00	NVDA	Stock	0.2859	0.2867	0.2813	0.2849	154272000.0
2000-10-06 16:00:00	NVDA	Stock	0.2852	0.2852	0.2818	0.2818	41208000.0
2000-10-06 18:00:00	NVDA	Stock	0.2833	0.2833	0.2833	0.2833	48000.0
2000-10-06 08:00:00	AMZN	Stock	1.6156	1.6812	1.6156	1.6656	120000.0
2000-10-06 09:00:00	AMZN	Stock	1.6688	1.6719	1.625	1.65	13728000.0
2000-10-06 10:00:00	AMZN	Stock	1.65	1.6562	1.5375	1.55	35878000.0
2000-10-06 11:00:00	AMZN	Stock	1.55	1.5938	1.5219	1.5812	31924000.0
2000-10-06 12:00:00	AMZN	Stock	1.5781	1.6031	1.5563	1.5781	14654000.0
2000-10-06 13:00:00	AMZN	Stock	1.5781	1.5812	1.5312	1.5625	18722000.0
2000-10-06 14:00:00	AMZN	Stock	1.5594	1.575	1.5094	1.5156	15244000.0
2000-10-06 15:00:00	AMZN	Stock	1.5156	1.5875	1.5094	1.5781	35628000.0
2000-10-06 16:00:00	AMZN	Stock	1.5812	1.6	1.5656	1.5656	2032000.0
2000-10-06 17:00:00	AMZN	Stock	1.5656	1.5812	1.5656	1.5812	38000.0
2000-10-06 09:00:00	CL	Stock	25.075	25.295	25.025	25.265	549800.0
2000-10-06 10:00:00	CL	Stock	25.3	25.625	25.275	25.46	1041200.0
2000-10-06 11:00:00	CL	Stock	25.435	25.49	25.39	25.425	727400.0
2000-10-06 12:00:00	CL	Stock	25.45	25.495	25.4	25.48	350800.0
2000-10-06 13:00:00	CL	Stock	25.48	25.51	25.235	25.265	1001000.0
2000-10-06 14:00:00	CL	Stock	25.275	25.275	24.81	24.9	676200.0
2000-10-06 15:00:00	CL	Stock	24.89	25.025	24.89	24.975	607000.0
2000-10-06 16:00:00	CL	Stock	24.975	25.27	24.975	25.27	88800.0

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

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