PREVIEW / stock_1hour / 2000-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-09.parquet
  size:    287 KB
  rows:    14,812
  symbols: 1,163

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-09 08:00:00	AAPL	Stock	0.8463	0.8661	0.8463	0.8644	1456000.0
2000-06-09 09:00:00	AAPL	Stock	0.861	0.8728	0.8449	0.8449	45449600.0
2000-06-09 10:00:00	AAPL	Stock	0.8449	0.8722	0.8449	0.8694	46065600.0
2000-06-09 11:00:00	AAPL	Stock	0.87	0.8744	0.8638	0.8689	34988800.0
2000-06-09 12:00:00	AAPL	Stock	0.8694	0.8694	0.8583	0.8605	37654400.0
2000-06-09 13:00:00	AAPL	Stock	0.8594	0.8605	0.8426	0.8516	30609600.0
2000-06-09 14:00:00	AAPL	Stock	0.8504	0.8616	0.8504	0.8544	20899200.0
2000-06-09 15:00:00	AAPL	Stock	0.8555	0.8636	0.8499	0.8549	30867200.0
2000-06-09 16:00:00	AAPL	Stock	0.8555	0.8585	0.8499	0.8527	3987200.0
2000-06-09 17:00:00	AAPL	Stock	0.8566	0.8566	0.8566	0.8566	11200.0
2000-06-09 08:00:00	MSFT	Stock	34.75	35.25	34.75	34.9375	310600.0
2000-06-09 09:00:00	MSFT	Stock	34.9375	34.9375	34.2188	34.2812	6839200.0
2000-06-09 10:00:00	MSFT	Stock	34.2812	34.625	34.25	34.5	6225400.0
2000-06-09 11:00:00	MSFT	Stock	34.5312	34.6875	34.375	34.5	4039200.0
2000-06-09 12:00:00	MSFT	Stock	34.4688	34.5	34.25	34.3438	3271800.0
2000-06-09 13:00:00	MSFT	Stock	34.3438	34.375	34.1562	34.2188	2615600.0
2000-06-09 14:00:00	MSFT	Stock	34.25	34.4375	34.1875	34.3438	3826200.0
2000-06-09 15:00:00	MSFT	Stock	34.375	34.5625	34.25	34.4375	6563000.0
2000-06-09 16:00:00	MSFT	Stock	34.4375	34.5625	34.2812	34.4375	1252800.0
2000-06-09 17:00:00	MSFT	Stock	34.4375	34.5312	34.375	34.4844	2800.0
2000-06-09 18:00:00	MSFT	Stock	34.375	34.5	34.375	34.4375	1200.0
2000-06-09 08:00:00	NVDA	Stock	0.2595	0.2595	0.2595	0.2595	96000.0
2000-06-09 09:00:00	NVDA	Stock	0.2595	0.2677	0.2594	0.2667	115536000.0
2000-06-09 10:00:00	NVDA	Stock	0.2664	0.275	0.2625	0.2656	83952000.0
2000-06-09 11:00:00	NVDA	Stock	0.2646	0.2703	0.2641	0.2677	58080000.0
2000-06-09 12:00:00	NVDA	Stock	0.2677	0.2677	0.263	0.2633	65808000.0
2000-06-09 13:00:00	NVDA	Stock	0.2633	0.2643	0.2609	0.2616	69696000.0
2000-06-09 14:00:00	NVDA	Stock	0.2612	0.2641	0.257	0.2578	38352000.0
2000-06-09 15:00:00	NVDA	Stock	0.2581	0.2635	0.2581	0.2634	30624000.0
2000-06-09 16:00:00	NVDA	Stock	0.2634	0.2634	0.2604	0.2604	1008000.0
2000-06-09 17:00:00	NVDA	Stock	0.2604	0.2604	0.2604	0.2604	48000.0
2000-06-09 08:00:00	AMZN	Stock	2.5938	2.6688	2.5938	2.6688	216000.0
2000-06-09 09:00:00	AMZN	Stock	2.6375	2.6625	2.5906	2.6312	8006000.0
2000-06-09 10:00:00	AMZN	Stock	2.6312	2.6594	2.6125	2.6312	6330000.0
2000-06-09 11:00:00	AMZN	Stock	2.6281	2.6375	2.6125	2.6219	3908000.0
2000-06-09 12:00:00	AMZN	Stock	2.6219	2.6312	2.6188	2.6312	3158000.0
2000-06-09 13:00:00	AMZN	Stock	2.6312	2.6344	2.6188	2.6188	3860000.0
2000-06-09 14:00:00	AMZN	Stock	2.625	2.6438	2.6062	2.6125	5726000.0
2000-06-09 15:00:00	AMZN	Stock	2.6125	2.6375	2.6	2.6094	5976000.0
2000-06-09 16:00:00	AMZN	Stock	2.6094	2.6344	2.6	2.6125	1006000.0
2000-06-09 17:00:00	AMZN	Stock	2.6234	2.625	2.6125	2.6125	24000.0
2000-06-09 18:00:00	AMZN	Stock	2.6219	2.6219	2.6125	2.6125	6000.0
2000-06-09 09:00:00	CL	Stock	28.4375	28.5	28.375	28.5	227400.0
2000-06-09 10:00:00	CL	Stock	28.5	28.6875	28.5	28.5938	271200.0
2000-06-09 11:00:00	CL	Stock	28.5938	28.7812	28.5625	28.7188	197200.0
2000-06-09 12:00:00	CL	Stock	28.7188	28.7188	28.4688	28.5625	239200.0
2000-06-09 13:00:00	CL	Stock	28.5312	28.5625	28.375	28.4062	242600.0
2000-06-09 14:00:00	CL	Stock	28.375	28.5312	28.375	28.4688	146000.0
2000-06-09 15:00:00	CL	Stock	28.4375	28.5625	28.4062	28.4375	375200.0
2000-06-09 16:00:00	CL	Stock	28.4375	28.4375	28.4375	28.4375	28200.0

> showing 50 of 14,812 rows — these rows as CSV

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