PREVIEW / stock_1hour / 2000-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-01.parquet
  size:    300 KB
  rows:    15,418
  symbols: 1,220

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-01 08:00:00	AAPL	Stock	1.0859	1.1027	1.0859	1.0949	1164800.0
2000-09-01 09:00:00	AAPL	Stock	1.0949	1.1183	1.0915	1.1183	41188000.0
2000-09-01 10:00:00	AAPL	Stock	1.1161	1.1295	1.0982	1.1116	66987200.0
2000-09-01 11:00:00	AAPL	Stock	1.1116	1.1261	1.1105	1.1239	29982400.0
2000-09-01 12:00:00	AAPL	Stock	1.1228	1.1228	1.1116	1.1172	15176000.0
2000-09-01 13:00:00	AAPL	Stock	1.1172	1.1183	1.1105	1.115	21212800.0
2000-09-01 14:00:00	AAPL	Stock	1.1155	1.125	1.115	1.1183	22400000.0
2000-09-01 15:00:00	AAPL	Stock	1.1183	1.135	1.1138	1.1339	43965600.0
2000-09-01 16:00:00	AAPL	Stock	1.1328	1.139	1.1205	1.1328	11104800.0
2000-09-01 08:00:00	MSFT	Stock	34.9219	35.25	34.9219	35.1875	168800.0
2000-09-01 09:00:00	MSFT	Stock	35.1875	35.3125	34.8438	35.0312	7553200.0
2000-09-01 10:00:00	MSFT	Stock	35.0312	35.3125	34.9375	34.9844	10724600.0
2000-09-01 11:00:00	MSFT	Stock	35.0	35.125	34.9062	35.0312	4499000.0
2000-09-01 12:00:00	MSFT	Stock	35.0312	35.0469	34.9688	35.0312	3061200.0
2000-09-01 13:00:00	MSFT	Stock	35.0	35.0312	34.875	34.9375	2879800.0
2000-09-01 14:00:00	MSFT	Stock	34.9062	35.0312	34.875	34.9688	3111600.0
2000-09-01 15:00:00	MSFT	Stock	35.0	35.1562	34.9688	35.0625	3913400.0
2000-09-01 16:00:00	MSFT	Stock	35.0625	35.2188	35.0312	35.1875	958000.0
2000-09-01 17:00:00	MSFT	Stock	35.0938	35.25	35.0938	35.125	13000.0
2000-09-01 18:00:00	MSFT	Stock	35.125	35.1562	35.125	35.125	1000.0
2000-09-01 09:00:00	NVDA	Stock	0.3396	0.3396	0.332	0.3367	36576000.0
2000-09-01 10:00:00	NVDA	Stock	0.3375	0.3406	0.3333	0.3349	38712000.0
2000-09-01 11:00:00	NVDA	Stock	0.3349	0.3365	0.3318	0.3339	35400000.0
2000-09-01 12:00:00	NVDA	Stock	0.3339	0.3339	0.3318	0.3328	9000000.0
2000-09-01 13:00:00	NVDA	Stock	0.3333	0.3333	0.3276	0.3323	34512000.0
2000-09-01 14:00:00	NVDA	Stock	0.3299	0.3333	0.3286	0.3286	14208000.0
2000-09-01 15:00:00	NVDA	Stock	0.3297	0.3339	0.3276	0.3313	27504000.0
2000-09-01 16:00:00	NVDA	Stock	0.3315	0.3315	0.3302	0.3302	1512000.0
2000-09-01 17:00:00	NVDA	Stock	0.3333	0.3333	0.3333	0.3333	72000.0
2000-09-01 18:00:00	NVDA	Stock	0.3302	0.3302	0.3302	0.3302	48000.0
2000-09-01 08:00:00	AMZN	Stock	2.0625	2.125	2.0625	2.1188	134000.0
2000-09-01 09:00:00	AMZN	Stock	2.1188	2.1188	2.0813	2.1	11392000.0
2000-09-01 10:00:00	AMZN	Stock	2.1062	2.125	2.0625	2.0844	16626000.0
2000-09-01 11:00:00	AMZN	Stock	2.0844	2.1	2.075	2.0938	9794000.0
2000-09-01 12:00:00	AMZN	Stock	2.0969	2.1203	2.0938	2.1031	10152000.0
2000-09-01 13:00:00	AMZN	Stock	2.1031	2.1031	2.075	2.0813	4020000.0
2000-09-01 14:00:00	AMZN	Stock	2.0844	2.0906	2.0813	2.0875	3518000.0
2000-09-01 15:00:00	AMZN	Stock	2.0875	2.0938	2.075	2.0781	7802000.0
2000-09-01 16:00:00	AMZN	Stock	2.075	2.0906	2.0656	2.0781	1736000.0
2000-09-01 17:00:00	AMZN	Stock	2.075	2.0813	2.075	2.075	72000.0
2000-09-01 18:00:00	AMZN	Stock	2.0844	2.0875	2.0844	2.0875	14000.0
2000-09-01 09:00:00	CL	Stock	25.8125	25.8438	25.625	25.7188	300600.0
2000-09-01 10:00:00	CL	Stock	25.7188	25.8125	25.625	25.8125	258800.0
2000-09-01 11:00:00	CL	Stock	25.8125	25.875	25.7812	25.8125	158000.0
2000-09-01 12:00:00	CL	Stock	25.8125	25.875	25.6562	25.8125	225000.0
2000-09-01 13:00:00	CL	Stock	25.875	25.9062	25.7188	25.9062	161800.0
2000-09-01 14:00:00	CL	Stock	25.9062	26.0312	25.8125	25.875	261200.0
2000-09-01 15:00:00	CL	Stock	25.875	26.0625	25.8125	25.9375	268800.0
2000-09-01 16:00:00	CL	Stock	25.9062	25.9062	25.8281	25.8281	29000.0

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

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