PREVIEW / stock_1hour / 2000-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-22.parquet
  size:    290 KB
  rows:    15,337
  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-08-22 08:00:00	AAPL	Stock	0.9012	0.9012	0.9012	0.9012	1568000.0
2000-08-22 09:00:00	AAPL	Stock	0.904	0.9085	0.8996	0.9051	29058400.0
2000-08-22 10:00:00	AAPL	Stock	0.904	0.9129	0.904	0.9096	39435200.0
2000-08-22 11:00:00	AAPL	Stock	0.9107	0.9275	0.9096	0.9241	45953600.0
2000-08-22 12:00:00	AAPL	Stock	0.9252	0.9342	0.9196	0.9342	45130400.0
2000-08-22 13:00:00	AAPL	Stock	0.9342	0.9431	0.9275	0.9319	45343200.0
2000-08-22 14:00:00	AAPL	Stock	0.9319	0.9397	0.9219	0.933	30301600.0
2000-08-22 15:00:00	AAPL	Stock	0.933	0.9342	0.9219	0.923	30788800.0
2000-08-22 16:00:00	AAPL	Stock	0.9241	0.933	0.9219	0.9308	3253600.0
2000-08-22 17:00:00	AAPL	Stock	0.9018	0.9018	0.9018	0.9018	28000.0
2000-08-22 08:00:00	MSFT	Stock	35.2969	35.5	35.25	35.4375	86200.0
2000-08-22 09:00:00	MSFT	Stock	35.4375	35.875	35.2812	35.875	4919800.0
2000-08-22 10:00:00	MSFT	Stock	35.8438	36.2188	35.8438	36.0	10862200.0
2000-08-22 11:00:00	MSFT	Stock	35.9688	36.0	35.6562	35.6875	5902400.0
2000-08-22 12:00:00	MSFT	Stock	35.6875	35.6875	35.3125	35.4375	6137800.0
2000-08-22 13:00:00	MSFT	Stock	35.4375	35.8125	35.375	35.75	5569800.0
2000-08-22 14:00:00	MSFT	Stock	35.75	35.8438	35.4688	35.6875	10343800.0
2000-08-22 15:00:00	MSFT	Stock	35.6719	35.75	35.5312	35.625	7873600.0
2000-08-22 16:00:00	MSFT	Stock	35.625	36.0625	35.5	35.5938	2338200.0
2000-08-22 17:00:00	MSFT	Stock	35.3125	35.9062	35.3125	35.5938	39600.0
2000-08-22 18:00:00	MSFT	Stock	35.5938	35.5938	35.5938	35.5938	600.0
2000-08-22 08:00:00	NVDA	Stock	0.312	0.312	0.3042	0.3076	1128000.0
2000-08-22 09:00:00	NVDA	Stock	0.3063	0.3156	0.3047	0.3094	125472000.0
2000-08-22 10:00:00	NVDA	Stock	0.3083	0.3124	0.3063	0.3078	92400000.0
2000-08-22 11:00:00	NVDA	Stock	0.3078	0.3115	0.3068	0.307	57648000.0
2000-08-22 12:00:00	NVDA	Stock	0.3068	0.3083	0.306	0.3068	33312000.0
2000-08-22 13:00:00	NVDA	Stock	0.307	0.307	0.3031	0.3044	69792000.0
2000-08-22 14:00:00	NVDA	Stock	0.3042	0.3063	0.2958	0.3003	99888000.0
2000-08-22 15:00:00	NVDA	Stock	0.301	0.301	0.2922	0.2948	164736000.0
2000-08-22 16:00:00	NVDA	Stock	0.2951	0.2953	0.2922	0.2938	7056000.0
2000-08-22 17:00:00	NVDA	Stock	0.293	0.2945	0.2927	0.2938	264000.0
2000-08-22 18:00:00	NVDA	Stock	0.2938	0.2938	0.2927	0.2927	288000.0
2000-08-22 08:00:00	AMZN	Stock	1.875	1.8844	1.8562	1.8562	48000.0
2000-08-22 09:00:00	AMZN	Stock	1.875	1.9094	1.85	1.8625	7964000.0
2000-08-22 10:00:00	AMZN	Stock	1.8594	1.8844	1.8469	1.8562	10928000.0
2000-08-22 11:00:00	AMZN	Stock	1.8562	1.8625	1.8312	1.8469	8316000.0
2000-08-22 12:00:00	AMZN	Stock	1.8375	1.85	1.825	1.8312	5226000.0
2000-08-22 13:00:00	AMZN	Stock	1.8344	1.8656	1.8344	1.85	6408000.0
2000-08-22 14:00:00	AMZN	Stock	1.8531	1.875	1.8219	1.8344	16950000.0
2000-08-22 15:00:00	AMZN	Stock	1.8344	1.8344	1.8031	1.825	12974000.0
2000-08-22 16:00:00	AMZN	Stock	1.8281	1.8312	1.8219	1.8312	1050000.0
2000-08-22 17:00:00	AMZN	Stock	1.8312	1.8438	1.825	1.8438	32000.0
2000-08-22 18:00:00	AMZN	Stock	1.8438	1.8438	1.8312	1.8438	8000.0
2000-08-22 09:00:00	CL	Stock	25.9375	26.3125	25.9062	26.2812	245400.0
2000-08-22 10:00:00	CL	Stock	26.3125	26.3125	25.875	25.9062	216200.0
2000-08-22 11:00:00	CL	Stock	25.9375	25.9375	25.8125	25.8125	215400.0
2000-08-22 12:00:00	CL	Stock	25.7812	25.9062	25.7188	25.875	549800.0
2000-08-22 13:00:00	CL	Stock	25.875	25.875	25.4688	25.5938	519800.0
2000-08-22 14:00:00	CL	Stock	25.5938	25.75	25.2812	25.5625	848600.0
2000-08-22 15:00:00	CL	Stock	25.5625	25.6875	25.375	25.4375	864800.0

> showing 50 of 15,337 rows — these rows as CSV

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