PREVIEW / stock_1hour / 2000-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-06.parquet
  size:    299 KB
  rows:    15,579
  symbols: 1,216

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-06 08:00:00	AAPL	Stock	1.1161	1.1161	1.106	1.106	364000.0
2000-09-06 09:00:00	AAPL	Stock	1.1071	1.1138	1.0915	1.1071	37811200.0
2000-09-06 10:00:00	AAPL	Stock	1.1071	1.1083	1.0837	1.0859	36988000.0
2000-09-06 11:00:00	AAPL	Stock	1.0871	1.0871	1.0804	1.0837	55630400.0
2000-09-06 12:00:00	AAPL	Stock	1.0837	1.0837	1.0737	1.0815	19006400.0
2000-09-06 13:00:00	AAPL	Stock	1.0804	1.0815	1.0658	1.067	29271200.0
2000-09-06 14:00:00	AAPL	Stock	1.067	1.0742	1.0625	1.0636	35246400.0
2000-09-06 15:00:00	AAPL	Stock	1.0647	1.067	1.0313	1.0435	118692000.0
2000-09-06 16:00:00	AAPL	Stock	1.0435	1.0513	1.0402	1.048	12801600.0
2000-09-06 17:00:00	AAPL	Stock	1.0458	1.0491	1.0435	1.0458	487200.0
2000-09-06 18:00:00	AAPL	Stock	1.0458	1.0491	1.0458	1.0491	22400.0
2000-09-06 08:00:00	MSFT	Stock	35.0938	35.0938	35.0625	35.0625	29600.0
2000-09-06 09:00:00	MSFT	Stock	35.0625	35.3125	35.0	35.2188	5139200.0
2000-09-06 10:00:00	MSFT	Stock	35.2188	35.3438	35.1562	35.25	7230800.0
2000-09-06 11:00:00	MSFT	Stock	35.25	35.25	35.0625	35.1562	9781200.0
2000-09-06 12:00:00	MSFT	Stock	35.1875	35.1875	35.0938	35.1875	6667600.0
2000-09-06 13:00:00	MSFT	Stock	35.1562	35.1875	35.0	35.0	12448600.0
2000-09-06 14:00:00	MSFT	Stock	35.0	35.125	34.9375	34.9375	6709400.0
2000-09-06 15:00:00	MSFT	Stock	34.9375	34.9688	34.6562	34.7188	11481600.0
2000-09-06 16:00:00	MSFT	Stock	34.7188	35.0156	34.6875	34.7188	2249800.0
2000-09-06 17:00:00	MSFT	Stock	34.75	34.75	34.7031	34.7344	4200.0
2000-09-06 18:00:00	MSFT	Stock	34.7812	34.7812	34.7812	34.7812	1200.0
2000-09-06 09:00:00	NVDA	Stock	0.3336	0.3336	0.3255	0.3266	21336000.0
2000-09-06 10:00:00	NVDA	Stock	0.3263	0.3279	0.3125	0.3141	62088000.0
2000-09-06 11:00:00	NVDA	Stock	0.3143	0.3151	0.3107	0.313	28968000.0
2000-09-06 12:00:00	NVDA	Stock	0.3133	0.3138	0.3063	0.312	23760000.0
2000-09-06 13:00:00	NVDA	Stock	0.312	0.3135	0.3086	0.3112	24168000.0
2000-09-06 14:00:00	NVDA	Stock	0.3112	0.3125	0.3086	0.3091	21720000.0
2000-09-06 15:00:00	NVDA	Stock	0.3091	0.312	0.3063	0.3102	32064000.0
2000-09-06 16:00:00	NVDA	Stock	0.3089	0.3104	0.3083	0.3083	864000.0
2000-09-06 08:00:00	AMZN	Stock	2.2	2.275	2.2	2.2625	392000.0
2000-09-06 09:00:00	AMZN	Stock	2.2625	2.4812	2.2469	2.3781	115186000.0
2000-09-06 10:00:00	AMZN	Stock	2.3781	2.4125	2.3531	2.3844	49696000.0
2000-09-06 11:00:00	AMZN	Stock	2.3875	2.4125	2.3562	2.3906	20120000.0
2000-09-06 12:00:00	AMZN	Stock	2.3969	2.4313	2.3906	2.4031	14606000.0
2000-09-06 13:00:00	AMZN	Stock	2.4062	2.4094	2.375	2.3906	13046000.0
2000-09-06 14:00:00	AMZN	Stock	2.3922	2.4188	2.3688	2.3812	17004000.0
2000-09-06 15:00:00	AMZN	Stock	2.3812	2.3875	2.2844	2.2938	40986000.0
2000-09-06 16:00:00	AMZN	Stock	2.2969	2.3313	2.25	2.25	3138000.0
2000-09-06 17:00:00	AMZN	Stock	2.2625	2.2625	2.2188	2.2344	458000.0
2000-09-06 18:00:00	AMZN	Stock	2.2375	2.25	2.2344	2.25	320000.0
2000-09-06 09:00:00	CL	Stock	26.4375	26.9688	26.4375	26.9062	789000.0
2000-09-06 10:00:00	CL	Stock	26.875	26.9375	26.7188	26.7812	494800.0
2000-09-06 11:00:00	CL	Stock	26.7812	26.9062	26.7812	26.875	856600.0
2000-09-06 12:00:00	CL	Stock	26.8438	27.1562	26.8438	27.0625	334800.0
2000-09-06 13:00:00	CL	Stock	27.0625	27.125	26.875	26.9062	519000.0
2000-09-06 14:00:00	CL	Stock	26.875	26.9062	26.7812	26.875	242800.0
2000-09-06 15:00:00	CL	Stock	26.875	27.375	26.7812	27.25	1257000.0
2000-09-06 16:00:00	CL	Stock	27.2812	27.3125	26.9531	27.3125	949400.0

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

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