PREVIEW / stock_1hour / 2000-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-23.parquet
  size:    288 KB
  rows:    15,052
  symbols: 1,174

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-06-23 08:00:00	AAPL	Stock	0.9593	0.9643	0.9587	0.9598	884800.0
2000-06-23 09:00:00	AAPL	Stock	0.9587	0.9643	0.9386	0.9487	28862400.0
2000-06-23 10:00:00	AAPL	Stock	0.9531	0.971	0.942	0.9621	35996800.0
2000-06-23 11:00:00	AAPL	Stock	0.9598	0.9754	0.9554	0.9621	26168800.0
2000-06-23 12:00:00	AAPL	Stock	0.9632	0.9688	0.942	0.9481	24925600.0
2000-06-23 13:00:00	AAPL	Stock	0.9487	0.9542	0.9386	0.942	14280000.0
2000-06-23 14:00:00	AAPL	Stock	0.942	0.9509	0.9196	0.9258	32765600.0
2000-06-23 15:00:00	AAPL	Stock	0.9252	0.9431	0.9074	0.923	29926400.0
2000-06-23 16:00:00	AAPL	Stock	0.923	0.9375	0.9141	0.923	3203200.0
2000-06-23 17:00:00	AAPL	Stock	0.923	0.9241	0.923	0.9241	1092000.0
2000-06-23 08:00:00	MSFT	Stock	40.3125	40.3125	39.8438	40.0	242600.0
2000-06-23 09:00:00	MSFT	Stock	39.9688	40.0625	39.0625	39.0625	8670200.0
2000-06-23 10:00:00	MSFT	Stock	39.0625	39.375	38.8125	39.375	12064400.0
2000-06-23 11:00:00	MSFT	Stock	39.3125	39.625	39.125	39.3125	5307800.0
2000-06-23 12:00:00	MSFT	Stock	39.3125	39.375	39.0312	39.125	4523000.0
2000-06-23 13:00:00	MSFT	Stock	39.0938	39.1562	38.6875	38.7188	5463400.0
2000-06-23 14:00:00	MSFT	Stock	38.7188	39.0	38.5625	38.5938	4972600.0
2000-06-23 15:00:00	MSFT	Stock	38.5625	39.0312	38.5	38.8594	6895800.0
2000-06-23 16:00:00	MSFT	Stock	38.8594	39.4062	38.5625	38.8438	848400.0
2000-06-23 17:00:00	MSFT	Stock	38.75	38.8438	38.5938	38.5938	100000.0
2000-06-23 18:00:00	MSFT	Stock	38.5938	38.75	38.5938	38.75	2000.0
2000-06-23 08:00:00	NVDA	Stock	0.3406	0.3539	0.3406	0.35	3072000.0
2000-06-23 09:00:00	NVDA	Stock	0.3437	0.3437	0.3185	0.3208	139296000.0
2000-06-23 10:00:00	NVDA	Stock	0.3208	0.3354	0.319	0.3333	119136000.0
2000-06-23 11:00:00	NVDA	Stock	0.3327	0.3357	0.3271	0.3292	67392000.0
2000-06-23 12:00:00	NVDA	Stock	0.3281	0.3297	0.3208	0.3234	40032000.0
2000-06-23 13:00:00	NVDA	Stock	0.3246	0.3263	0.3172	0.3186	42480000.0
2000-06-23 14:00:00	NVDA	Stock	0.3195	0.3238	0.313	0.3165	62160000.0
2000-06-23 15:00:00	NVDA	Stock	0.3165	0.3193	0.3083	0.3094	102528000.0
2000-06-23 16:00:00	NVDA	Stock	0.3085	0.3104	0.3083	0.3104	3648000.0
2000-06-23 17:00:00	NVDA	Stock	0.3104	0.3104	0.3104	0.3104	192000.0
2000-06-23 08:00:00	AMZN	Stock	2.075	2.1	1.825	1.8375	13032000.0
2000-06-23 09:00:00	AMZN	Stock	1.8344	1.85	1.7281	1.7625	139880000.0
2000-06-23 10:00:00	AMZN	Stock	1.7578	1.7688	1.6406	1.6781	194036000.0
2000-06-23 11:00:00	AMZN	Stock	1.6781	1.7	1.625	1.6469	155752000.0
2000-06-23 12:00:00	AMZN	Stock	1.6469	1.6625	1.6328	1.6531	84430000.0
2000-06-23 13:00:00	AMZN	Stock	1.6531	1.675	1.6453	1.6719	161802000.0
2000-06-23 14:00:00	AMZN	Stock	1.6719	1.6969	1.6234	1.6438	95538000.0
2000-06-23 15:00:00	AMZN	Stock	1.6406	1.7016	1.625	1.6938	127722000.0
2000-06-23 16:00:00	AMZN	Stock	1.6969	1.7047	1.65	1.6984	53034000.0
2000-06-23 17:00:00	AMZN	Stock	1.6969	1.7312	1.6938	1.7031	522000.0
2000-06-23 18:00:00	AMZN	Stock	1.7016	1.7188	1.6969	1.7125	352000.0
2000-06-23 09:00:00	CL	Stock	28.0	28.0312	27.7188	27.7188	198800.0
2000-06-23 10:00:00	CL	Stock	27.6875	28.0	27.6875	27.7812	388600.0
2000-06-23 11:00:00	CL	Stock	27.8125	27.875	27.7812	27.8125	311000.0
2000-06-23 12:00:00	CL	Stock	27.8125	27.875	27.75	27.7812	171800.0
2000-06-23 13:00:00	CL	Stock	27.7812	27.7812	27.5312	27.6875	527400.0
2000-06-23 14:00:00	CL	Stock	27.6875	27.6875	27.5	27.5625	297200.0
2000-06-23 15:00:00	CL	Stock	27.5938	27.7812	27.5312	27.7812	494400.0
2000-06-23 16:00:00	CL	Stock	27.75	27.7812	27.75	27.7812	63200.0

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

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