PREVIEW / stock_1hour / 2000-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-04.parquet
  size:    290 KB
  rows:    14,885
  symbols: 1,190

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-04 08:00:00	AAPL	Stock	0.8566	0.8705	0.8566	0.8705	3052000.0
2000-08-04 09:00:00	AAPL	Stock	0.875	0.894	0.8672	0.8929	39244800.0
2000-08-04 10:00:00	AAPL	Stock	0.8929	0.9152	0.8772	0.8806	56616000.0
2000-08-04 11:00:00	AAPL	Stock	0.8795	0.8895	0.875	0.885	15131200.0
2000-08-04 12:00:00	AAPL	Stock	0.885	0.885	0.8638	0.8705	16240000.0
2000-08-04 13:00:00	AAPL	Stock	0.8705	0.8795	0.8482	0.8538	33532800.0
2000-08-04 14:00:00	AAPL	Stock	0.8549	0.8549	0.8438	0.8438	22601600.0
2000-08-04 15:00:00	AAPL	Stock	0.8438	0.8482	0.827	0.846	38735200.0
2000-08-04 16:00:00	AAPL	Stock	0.8449	0.8739	0.8438	0.846	29282400.0
2000-08-04 17:00:00	AAPL	Stock	0.846	0.846	0.8404	0.8415	84000.0
2000-08-04 18:00:00	AAPL	Stock	0.8404	0.8404	0.8404	0.8404	61600.0
2000-08-04 08:00:00	MSFT	Stock	35.125	35.4375	34.6875	34.8125	237600.0
2000-08-04 09:00:00	MSFT	Stock	34.7656	35.0312	34.3125	34.5312	8485600.0
2000-08-04 10:00:00	MSFT	Stock	34.5625	34.75	34.2188	34.25	7886000.0
2000-08-04 11:00:00	MSFT	Stock	34.25	34.4688	34.1875	34.4375	4131200.0
2000-08-04 12:00:00	MSFT	Stock	34.4375	34.5	34.25	34.4688	2749200.0
2000-08-04 13:00:00	MSFT	Stock	34.5	34.5	34.1875	34.3125	3261000.0
2000-08-04 14:00:00	MSFT	Stock	34.2812	34.4688	34.1875	34.3125	3014200.0
2000-08-04 15:00:00	MSFT	Stock	34.2188	34.5938	34.0938	34.5625	6936200.0
2000-08-04 16:00:00	MSFT	Stock	34.5312	34.75	34.4375	34.4375	998000.0
2000-08-04 17:00:00	MSFT	Stock	34.4375	34.5	34.375	34.375	1600.0
2000-08-04 18:00:00	MSFT	Stock	34.375	34.375	34.375	34.375	200.0
2000-08-04 09:00:00	NVDA	Stock	0.2654	0.2708	0.2625	0.2695	47016000.0
2000-08-04 10:00:00	NVDA	Stock	0.2701	0.2706	0.262	0.2622	34584000.0
2000-08-04 11:00:00	NVDA	Stock	0.2622	0.2667	0.2622	0.2661	18792000.0
2000-08-04 12:00:00	NVDA	Stock	0.266	0.2667	0.2615	0.2617	24408000.0
2000-08-04 13:00:00	NVDA	Stock	0.2625	0.2641	0.2615	0.2633	18480000.0
2000-08-04 14:00:00	NVDA	Stock	0.2639	0.2688	0.2625	0.2667	18624000.0
2000-08-04 15:00:00	NVDA	Stock	0.2672	0.2674	0.2625	0.2656	29232000.0
2000-08-04 16:00:00	NVDA	Stock	0.2656	0.2656	0.256	0.2625	2808000.0
2000-08-04 17:00:00	NVDA	Stock	0.2685	0.2685	0.2685	0.2685	600000.0
2000-08-04 08:00:00	AMZN	Stock	1.5766	1.5969	1.575	1.5844	152000.0
2000-08-04 09:00:00	AMZN	Stock	1.5875	1.7094	1.5781	1.6812	27784000.0
2000-08-04 10:00:00	AMZN	Stock	1.6812	1.6812	1.6188	1.625	19524000.0
2000-08-04 11:00:00	AMZN	Stock	1.625	1.6375	1.6063	1.6281	10810000.0
2000-08-04 12:00:00	AMZN	Stock	1.6281	1.6344	1.6125	1.6188	6030000.0
2000-08-04 13:00:00	AMZN	Stock	1.6188	1.6188	1.575	1.5781	13540000.0
2000-08-04 14:00:00	AMZN	Stock	1.5812	1.6281	1.575	1.6156	7184000.0
2000-08-04 15:00:00	AMZN	Stock	1.6188	1.6312	1.6	1.6219	9866000.0
2000-08-04 16:00:00	AMZN	Stock	1.6234	1.6344	1.5781	1.6094	1936000.0
2000-08-04 17:00:00	AMZN	Stock	1.6	1.6	1.6	1.6	6000.0
2000-08-04 18:00:00	AMZN	Stock	1.6063	1.6063	1.6016	1.6016	8000.0
2000-08-04 09:00:00	CL	Stock	28.1875	28.1875	27.6875	27.8125	262400.0
2000-08-04 10:00:00	CL	Stock	27.8125	28.0625	27.7188	27.75	287000.0
2000-08-04 11:00:00	CL	Stock	27.7188	27.9062	27.5938	27.6875	165000.0
2000-08-04 12:00:00	CL	Stock	27.6562	27.6562	27.3438	27.5	256600.0
2000-08-04 13:00:00	CL	Stock	27.5	27.75	27.4062	27.4062	249200.0
2000-08-04 14:00:00	CL	Stock	27.4062	27.5938	27.25	27.3438	262200.0
2000-08-04 15:00:00	CL	Stock	27.375	27.6562	27.25	27.5	355200.0
2000-08-04 16:00:00	CL	Stock	27.4688	27.5	27.4688	27.5	21400.0

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

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