PREVIEW / stock_1hour / 2000-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-05-19.parquet
  size:    271 KB
  rows:    14,120
  symbols: 1,157

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-05-19 09:00:00	AAPL	Stock	0.8862	0.8862	0.8555	0.8577	117163200.0
2000-05-19 10:00:00	AAPL	Stock	0.8577	0.8577	0.846	0.846	197758400.0
2000-05-19 11:00:00	AAPL	Stock	0.846	0.856	0.841	0.8521	90574400.0
2000-05-19 12:00:00	AAPL	Stock	0.8527	0.8583	0.8477	0.8527	67110400.0
2000-05-19 13:00:00	AAPL	Stock	0.8527	0.8566	0.851	0.8544	49403200.0
2000-05-19 14:00:00	AAPL	Stock	0.8549	0.865	0.8532	0.8599	72923200.0
2000-05-19 15:00:00	AAPL	Stock	0.8583	0.8591	0.8376	0.8396	113142400.0
2000-05-19 16:00:00	AAPL	Stock	0.841	0.841	0.8382	0.8393	560000.0
2000-05-19 09:00:00	MSFT	Stock	32.6875	32.9688	32.625	32.7188	8314600.0
2000-05-19 10:00:00	MSFT	Stock	32.7031	32.75	32.5312	32.5938	8071600.0
2000-05-19 11:00:00	MSFT	Stock	32.5625	32.625	32.5	32.5312	10819400.0
2000-05-19 12:00:00	MSFT	Stock	32.5625	32.5938	32.2812	32.5	13528800.0
2000-05-19 13:00:00	MSFT	Stock	32.5	32.625	32.25	32.5	4782800.0
2000-05-19 14:00:00	MSFT	Stock	32.5	32.6562	32.375	32.4844	5343400.0
2000-05-19 15:00:00	MSFT	Stock	32.4688	32.5938	32.375	32.5312	10324000.0
2000-05-19 16:00:00	MSFT	Stock	32.5312	32.5312	32.5	32.5312	163600.0
2000-05-19 09:00:00	NVDA	Stock	0.2083	0.2167	0.2068	0.2102	114000000.0
2000-05-19 10:00:00	NVDA	Stock	0.21	0.2121	0.2089	0.2091	77232000.0
2000-05-19 11:00:00	NVDA	Stock	0.2094	0.2146	0.2081	0.2138	55872000.0
2000-05-19 12:00:00	NVDA	Stock	0.2139	0.2161	0.2115	0.2133	22080000.0
2000-05-19 13:00:00	NVDA	Stock	0.2122	0.2125	0.2073	0.212	18192000.0
2000-05-19 14:00:00	NVDA	Stock	0.2111	0.2198	0.2083	0.2187	119568000.0
2000-05-19 15:00:00	NVDA	Stock	0.2187	0.2193	0.2109	0.2125	65472000.0
2000-05-19 16:00:00	NVDA	Stock	0.2125	0.2128	0.2125	0.2128	240000.0
2000-05-19 09:00:00	AMZN	Stock	2.7312	2.7875	2.7	2.7	16022000.0
2000-05-19 10:00:00	AMZN	Stock	2.7	2.7031	2.65	2.6875	18672000.0
2000-05-19 11:00:00	AMZN	Stock	2.6844	2.7125	2.6625	2.6875	10712000.0
2000-05-19 12:00:00	AMZN	Stock	2.6875	2.6938	2.6562	2.6719	6026000.0
2000-05-19 13:00:00	AMZN	Stock	2.6719	2.6875	2.6281	2.6625	8032000.0
2000-05-19 14:00:00	AMZN	Stock	2.6656	2.7562	2.6594	2.7453	11676000.0
2000-05-19 15:00:00	AMZN	Stock	2.7375	2.7438	2.6125	2.6312	15338000.0
2000-05-19 16:00:00	AMZN	Stock	2.6344	2.6375	2.6312	2.6312	2078000.0
2000-05-19 09:00:00	CL	Stock	29.4375	29.4375	28.875	28.875	359800.0
2000-05-19 10:00:00	CL	Stock	28.875	28.875	28.375	28.4062	548200.0
2000-05-19 11:00:00	CL	Stock	28.375	28.5938	28.3125	28.4375	485400.0
2000-05-19 12:00:00	CL	Stock	28.4688	28.5	28.4062	28.4375	150400.0
2000-05-19 13:00:00	CL	Stock	28.4062	28.4375	28.2188	28.3125	331200.0
2000-05-19 14:00:00	CL	Stock	28.3125	28.4688	28.2812	28.375	282600.0
2000-05-19 15:00:00	CL	Stock	28.375	28.5938	28.3438	28.4375	374000.0
2000-05-19 16:00:00	CL	Stock	28.4688	28.4688	28.4688	28.4688	86200.0

> showing 40 of 14,120 rows — these rows as CSV

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