PREVIEW / stock_1hour / 2000-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-28.parquet
  size:    295 KB
  rows:    15,345
  symbols: 1,219

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-08-28 08:00:00	AAPL	Stock	1.014	1.0156	1.0134	1.0134	184800.0
2000-08-28 09:00:00	AAPL	Stock	1.0134	1.0446	1.0134	1.0413	65010400.0
2000-08-28 10:00:00	AAPL	Stock	1.0435	1.0536	1.0368	1.0402	63448000.0
2000-08-28 11:00:00	AAPL	Stock	1.0402	1.0469	1.0335	1.0357	52617600.0
2000-08-28 12:00:00	AAPL	Stock	1.0357	1.0424	1.0346	1.0413	36394400.0
2000-08-28 13:00:00	AAPL	Stock	1.0413	1.0424	1.0357	1.0368	30676800.0
2000-08-28 14:00:00	AAPL	Stock	1.0379	1.0391	1.0335	1.0346	24320800.0
2000-08-28 15:00:00	AAPL	Stock	1.0352	1.0402	1.0324	1.0368	64439200.0
2000-08-28 16:00:00	AAPL	Stock	1.0402	1.0424	1.0357	1.0424	17024000.0
2000-08-28 17:00:00	AAPL	Stock	1.0374	1.0374	1.0374	1.0374	2128000.0
2000-08-28 08:00:00	MSFT	Stock	35.3438	35.3438	35.0	35.0625	61200.0
2000-08-28 09:00:00	MSFT	Stock	35.125	35.3125	35.0625	35.2188	4696400.0
2000-08-28 10:00:00	MSFT	Stock	35.2188	35.625	35.1875	35.25	8321600.0
2000-08-28 11:00:00	MSFT	Stock	35.25	35.4062	35.2188	35.3125	5536200.0
2000-08-28 12:00:00	MSFT	Stock	35.3438	35.375	35.2812	35.3125	5355800.0
2000-08-28 13:00:00	MSFT	Stock	35.3125	35.4062	35.2188	35.3125	7326800.0
2000-08-28 14:00:00	MSFT	Stock	35.3125	35.4062	35.3125	35.375	3090000.0
2000-08-28 15:00:00	MSFT	Stock	35.3438	36.0625	35.3125	35.6562	19276400.0
2000-08-28 16:00:00	MSFT	Stock	35.6875	35.8438	35.25	35.7188	1457200.0
2000-08-28 17:00:00	MSFT	Stock	35.6562	35.7188	35.625	35.625	5200.0
2000-08-28 18:00:00	MSFT	Stock	35.5312	35.6875	35.5312	35.6875	2200.0
2000-08-28 09:00:00	NVDA	Stock	0.3146	0.3156	0.3104	0.3128	13608000.0
2000-08-28 10:00:00	NVDA	Stock	0.3135	0.3229	0.3133	0.3201	39624000.0
2000-08-28 11:00:00	NVDA	Stock	0.3198	0.3292	0.3198	0.3229	34800000.0
2000-08-28 12:00:00	NVDA	Stock	0.3232	0.3266	0.3208	0.324	14856000.0
2000-08-28 13:00:00	NVDA	Stock	0.324	0.3268	0.3229	0.3247	26496000.0
2000-08-28 14:00:00	NVDA	Stock	0.3247	0.3247	0.3188	0.3203	23208000.0
2000-08-28 15:00:00	NVDA	Stock	0.3208	0.3255	0.3208	0.325	33672000.0
2000-08-28 16:00:00	NVDA	Stock	0.3242	0.325	0.3237	0.3237	1848000.0
2000-08-28 17:00:00	NVDA	Stock	0.3255	0.326	0.3255	0.326	120000.0
2000-08-28 08:00:00	AMZN	Stock	1.9438	1.9484	1.9125	1.9312	376000.0
2000-08-28 09:00:00	AMZN	Stock	1.9375	1.9625	1.9281	1.9359	11476000.0
2000-08-28 10:00:00	AMZN	Stock	1.9375	2.125	1.9312	2.075	68364000.0
2000-08-28 11:00:00	AMZN	Stock	2.0813	2.0938	2.0125	2.0219	52300000.0
2000-08-28 12:00:00	AMZN	Stock	2.0219	2.0375	2.0125	2.0156	10148000.0
2000-08-28 13:00:00	AMZN	Stock	2.0156	2.0406	1.9719	1.9969	15042000.0
2000-08-28 14:00:00	AMZN	Stock	1.9969	2.0031	1.9656	1.9688	6796000.0
2000-08-28 15:00:00	AMZN	Stock	1.9656	1.9812	1.9375	1.9562	15774000.0
2000-08-28 16:00:00	AMZN	Stock	1.95	2.0391	1.9469	2.0391	768000.0
2000-08-28 17:00:00	AMZN	Stock	1.9562	1.9562	1.9562	1.9562	10000.0
2000-08-28 18:00:00	AMZN	Stock	1.9578	1.9594	1.95	1.95	12000.0
2000-08-28 09:00:00	CL	Stock	26.6875	26.6875	26.4375	26.5625	164400.0
2000-08-28 10:00:00	CL	Stock	26.5625	27.0625	26.5625	26.9062	430200.0
2000-08-28 11:00:00	CL	Stock	26.9062	27.0312	26.8438	26.9688	176600.0
2000-08-28 12:00:00	CL	Stock	26.9688	27.0	26.5312	26.6875	279400.0
2000-08-28 13:00:00	CL	Stock	26.6875	26.7812	26.4375	26.7188	342200.0
2000-08-28 14:00:00	CL	Stock	26.6875	26.7188	26.3438	26.4062	267800.0
2000-08-28 15:00:00	CL	Stock	26.4375	26.4375	26.2188	26.3125	378000.0
2000-08-28 16:00:00	CL	Stock	26.3125	26.3125	26.3125	26.3125	42800.0

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

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