PREVIEW / stock_1hour / 2000-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-01-27.parquet
  size:    275 KB
  rows:    14,211
  symbols: 1,129

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-27 09:00:00	AAPL	Stock	0.9715	1.0033	0.9648	1.0011	35862400.0
2000-01-27 10:00:00	AAPL	Stock	1.0014	1.0089	0.9844	1.0022	49638400.0
2000-01-27 11:00:00	AAPL	Stock	1.0022	1.0056	0.9821	0.9874	38315200.0
2000-01-27 12:00:00	AAPL	Stock	0.9844	0.9969	0.9643	0.9693	31427200.0
2000-01-27 13:00:00	AAPL	Stock	0.9688	0.9821	0.9688	0.9699	23419200.0
2000-01-27 14:00:00	AAPL	Stock	0.9704	0.978	0.966	0.9721	47454400.0
2000-01-27 15:00:00	AAPL	Stock	0.9721	0.9888	0.9554	0.9824	83283200.0
2000-01-27 16:00:00	AAPL	Stock	0.9833	0.9833	0.9821	0.9821	604800.0
2000-01-27 09:00:00	MSFT	Stock	49.9375	50.5938	49.375	49.6875	8172000.0
2000-01-27 10:00:00	MSFT	Stock	49.5312	50.2188	49.5	50.1562	10426200.0
2000-01-27 11:00:00	MSFT	Stock	50.1562	50.4688	49.6875	50.0	7911800.0
2000-01-27 12:00:00	MSFT	Stock	49.9688	50.0625	49.4688	49.5938	5265000.0
2000-01-27 13:00:00	MSFT	Stock	49.5938	50.0	49.5	49.5938	4334200.0
2000-01-27 14:00:00	MSFT	Stock	49.5938	49.75	48.6875	48.875	9987400.0
2000-01-27 15:00:00	MSFT	Stock	48.9062	49.5625	48.625	49.4062	13491400.0
2000-01-27 16:00:00	MSFT	Stock	49.3438	49.4375	49.3438	49.375	56200.0
2000-01-27 09:00:00	NVDA	Stock	0.0853	0.0853	0.0812	0.0816	28416000.0
2000-01-27 10:00:00	NVDA	Stock	0.0818	0.0833	0.0818	0.0831	51312000.0
2000-01-27 11:00:00	NVDA	Stock	0.0831	0.0832	0.082	0.082	13920000.0
2000-01-27 12:00:00	NVDA	Stock	0.082	0.082	0.079	0.0797	82320000.0
2000-01-27 13:00:00	NVDA	Stock	0.0797	0.0797	0.0776	0.079	52512000.0
2000-01-27 14:00:00	NVDA	Stock	0.079	0.0798	0.0771	0.0781	69360000.0
2000-01-27 15:00:00	NVDA	Stock	0.0781	0.0805	0.0775	0.0802	112608000.0
2000-01-27 09:00:00	AMZN	Stock	3.2594	3.3375	3.25	3.325	18040000.0
2000-01-27 10:00:00	AMZN	Stock	3.3281	3.3562	3.3125	3.3312	16230000.0
2000-01-27 11:00:00	AMZN	Stock	3.3344	3.3875	3.325	3.35	17418000.0
2000-01-27 12:00:00	AMZN	Stock	3.35	3.3688	3.3	3.3125	14392000.0
2000-01-27 13:00:00	AMZN	Stock	3.3156	3.3312	3.3031	3.3094	7566000.0
2000-01-27 14:00:00	AMZN	Stock	3.3062	3.3219	3.2531	3.2594	10400000.0
2000-01-27 15:00:00	AMZN	Stock	3.2594	3.375	3.2312	3.3438	46054000.0
2000-01-27 16:00:00	AMZN	Stock	3.3594	3.3594	3.3438	3.3469	254000.0
2000-01-27 09:00:00	CL	Stock	29.875	30.25	29.875	30.2188	304800.0
2000-01-27 10:00:00	CL	Stock	30.1875	30.5938	30.1875	30.25	466400.0
2000-01-27 11:00:00	CL	Stock	30.25	30.625	30.25	30.5938	301000.0
2000-01-27 12:00:00	CL	Stock	30.625	30.625	30.3125	30.4062	162000.0
2000-01-27 13:00:00	CL	Stock	30.4375	30.5625	30.2812	30.5625	132800.0
2000-01-27 14:00:00	CL	Stock	30.5625	30.6562	30.0	30.1562	281400.0
2000-01-27 15:00:00	CL	Stock	30.1562	30.2188	29.875	30.125	350000.0
2000-01-27 16:00:00	CL	Stock	30.125	30.1875	30.125	30.1562	33800.0

> showing 39 of 14,211 rows — these rows as CSV

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