PREVIEW / stock_1hour / 2000-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-01-26.parquet
  size:    279 KB
  rows:    14,337
  symbols: 1,126

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-01-26 09:00:00	AAPL	Stock	0.9821	1.019	0.9799	1.0179	69540800.0
2000-01-26 10:00:00	AAPL	Stock	1.0181	1.0195	1.0	1.0084	78915200.0
2000-01-26 11:00:00	AAPL	Stock	1.0067	1.0086	0.9911	1.0067	47824000.0
2000-01-26 12:00:00	AAPL	Stock	1.0067	1.0067	0.9955	0.9955	19924800.0
2000-01-26 13:00:00	AAPL	Stock	0.9955	1.0067	0.9955	1.0	15299200.0
2000-01-26 14:00:00	AAPL	Stock	1.0	1.0089	0.9978	1.0	29377600.0
2000-01-26 15:00:00	AAPL	Stock	1.0	1.0067	0.9821	0.9833	68230400.0
2000-01-26 16:00:00	AAPL	Stock	0.9838	0.9838	0.9821	0.9838	2128000.0
2000-01-26 09:00:00	MSFT	Stock	51.2188	51.75	50.75	51.3125	5591000.0
2000-01-26 10:00:00	MSFT	Stock	51.3125	51.3125	50.3438	50.4062	5539000.0
2000-01-26 11:00:00	MSFT	Stock	50.375	50.7812	50.1562	50.625	6119200.0
2000-01-26 12:00:00	MSFT	Stock	50.625	50.75	50.375	50.5	4566400.0
2000-01-26 13:00:00	MSFT	Stock	50.5312	50.625	50.2812	50.375	4174800.0
2000-01-26 14:00:00	MSFT	Stock	50.3438	50.8125	50.0625	50.1875	7310000.0
2000-01-26 15:00:00	MSFT	Stock	50.2188	50.3438	49.5625	49.6875	12424000.0
2000-01-26 16:00:00	MSFT	Stock	49.6875	49.75	49.625	49.6875	77600.0
2000-01-26 09:00:00	NVDA	Stock	0.0883	0.0906	0.088	0.0887	21840000.0
2000-01-26 10:00:00	NVDA	Stock	0.0885	0.0896	0.087	0.0879	50304000.0
2000-01-26 11:00:00	NVDA	Stock	0.0879	0.088	0.0853	0.0858	34176000.0
2000-01-26 12:00:00	NVDA	Stock	0.0857	0.0866	0.0831	0.0866	46704000.0
2000-01-26 13:00:00	NVDA	Stock	0.0859	0.0866	0.0854	0.0865	15456000.0
2000-01-26 14:00:00	NVDA	Stock	0.0857	0.0866	0.0857	0.0862	8688000.0
2000-01-26 15:00:00	NVDA	Stock	0.0857	0.0866	0.0849	0.0854	42336000.0
2000-01-26 16:00:00	NVDA	Stock	0.0846	0.0846	0.0846	0.0846	2880000.0
2000-01-26 09:00:00	AMZN	Stock	3.4312	3.4938	3.4094	3.4656	14426000.0
2000-01-26 10:00:00	AMZN	Stock	3.4625	3.4719	3.3875	3.3969	20210000.0
2000-01-26 11:00:00	AMZN	Stock	3.3969	3.4094	3.35	3.3656	13526000.0
2000-01-26 12:00:00	AMZN	Stock	3.3625	3.3719	3.325	3.3312	13244000.0
2000-01-26 13:00:00	AMZN	Stock	3.3281	3.3562	3.3	3.325	15556000.0
2000-01-26 14:00:00	AMZN	Stock	3.325	3.35	3.25	3.2594	20066000.0
2000-01-26 15:00:00	AMZN	Stock	3.2578	3.2812	3.2375	3.2438	26786000.0
2000-01-26 16:00:00	AMZN	Stock	3.2438	3.2469	3.2406	3.2406	504000.0
2000-01-26 09:00:00	CL	Stock	29.875	29.875	29.4688	29.5938	180200.0
2000-01-26 10:00:00	CL	Stock	29.5625	30.125	29.5	29.875	183800.0
2000-01-26 11:00:00	CL	Stock	29.8438	30.3125	29.7812	30.0625	167200.0
2000-01-26 12:00:00	CL	Stock	30.0	30.0625	29.7812	29.9062	130600.0
2000-01-26 13:00:00	CL	Stock	29.8125	29.9375	29.7812	29.9062	112200.0
2000-01-26 14:00:00	CL	Stock	29.9375	30.125	29.9062	30.0	151200.0
2000-01-26 15:00:00	CL	Stock	30.0312	30.3125	30.0312	30.0938	374000.0
2000-01-26 16:00:00	CL	Stock	30.0938	30.1562	30.0938	30.0938	51000.0
2000-01-26 17:00:00	CL	Stock	30.0938	30.0938	30.0938	30.0938	13400.0

> showing 41 of 14,337 rows — these rows as CSV

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