PREVIEW / stock_1hour / 2000-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-16.parquet
  size:    299 KB
  rows:    15,458
  symbols: 1,208

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-16 08:00:00	AAPL	Stock	0.8326	0.8337	0.8326	0.8337	33600.0
2000-08-16 09:00:00	AAPL	Stock	0.8348	0.8527	0.8348	0.8516	18698400.0
2000-08-16 10:00:00	AAPL	Stock	0.8504	0.8638	0.8493	0.8616	28963200.0
2000-08-16 11:00:00	AAPL	Stock	0.8616	0.8705	0.8605	0.8705	26723200.0
2000-08-16 12:00:00	AAPL	Stock	0.8705	0.875	0.8638	0.8705	19661600.0
2000-08-16 13:00:00	AAPL	Stock	0.8705	0.8717	0.8627	0.8638	14084000.0
2000-08-16 14:00:00	AAPL	Stock	0.8638	0.8739	0.8627	0.8672	11009600.0
2000-08-16 15:00:00	AAPL	Stock	0.8672	0.8728	0.8638	0.8661	16139200.0
2000-08-16 16:00:00	AAPL	Stock	0.8655	0.8884	0.8638	0.8884	7403200.0
2000-08-16 17:00:00	AAPL	Stock	0.885	0.8929	0.8795	0.8817	308000.0
2000-08-16 18:00:00	AAPL	Stock	0.8839	0.8839	0.8839	0.8839	28000.0
2000-08-16 08:00:00	MSFT	Stock	36.0	36.0	36.0	36.0	20000.0
2000-08-16 09:00:00	MSFT	Stock	36.0	36.125	35.8125	36.0938	10519200.0
2000-08-16 10:00:00	MSFT	Stock	36.0938	36.0938	35.8125	35.8438	7117400.0
2000-08-16 11:00:00	MSFT	Stock	35.875	35.9375	35.75	35.8438	4708600.0
2000-08-16 12:00:00	MSFT	Stock	35.8438	35.875	35.6875	35.7812	4990800.0
2000-08-16 13:00:00	MSFT	Stock	35.8125	35.8125	35.2812	35.4844	5904800.0
2000-08-16 14:00:00	MSFT	Stock	35.4688	35.625	35.4062	35.4375	4552400.0
2000-08-16 15:00:00	MSFT	Stock	35.4375	35.5625	35.3125	35.5312	5073400.0
2000-08-16 16:00:00	MSFT	Stock	35.5312	35.6562	35.3594	35.5	1170400.0
2000-08-16 17:00:00	MSFT	Stock	35.625	35.6562	35.625	35.625	11400.0
2000-08-16 18:00:00	MSFT	Stock	35.625	35.625	35.5312	35.5312	3000.0
2000-08-16 08:00:00	NVDA	Stock	0.2967	0.3	0.2967	0.3	4392000.0
2000-08-16 09:00:00	NVDA	Stock	0.3	0.3128	0.3	0.3099	85536000.0
2000-08-16 10:00:00	NVDA	Stock	0.3117	0.312	0.3036	0.3044	48144000.0
2000-08-16 11:00:00	NVDA	Stock	0.3057	0.3057	0.3005	0.3031	32112000.0
2000-08-16 12:00:00	NVDA	Stock	0.3031	0.306	0.3031	0.3055	9720000.0
2000-08-16 13:00:00	NVDA	Stock	0.3055	0.3057	0.2979	0.2997	17688000.0
2000-08-16 14:00:00	NVDA	Stock	0.2997	0.3036	0.2987	0.301	22968000.0
2000-08-16 15:00:00	NVDA	Stock	0.2995	0.3047	0.2951	0.3029	36456000.0
2000-08-16 16:00:00	NVDA	Stock	0.3029	0.3083	0.3023	0.3083	7800000.0
2000-08-16 17:00:00	NVDA	Stock	0.3073	0.3073	0.3073	0.3073	48000.0
2000-08-16 18:00:00	NVDA	Stock	0.3063	0.3063	0.306	0.306	72000.0
2000-08-16 08:00:00	AMZN	Stock	1.95	1.95	1.8688	1.875	992000.0
2000-08-16 09:00:00	AMZN	Stock	1.875	1.975	1.8625	1.9469	40704000.0
2000-08-16 10:00:00	AMZN	Stock	1.9469	1.9938	1.9344	1.9344	43624000.0
2000-08-16 11:00:00	AMZN	Stock	1.9344	1.95	1.9156	1.9281	18526000.0
2000-08-16 12:00:00	AMZN	Stock	1.925	1.9531	1.9188	1.9438	16962000.0
2000-08-16 13:00:00	AMZN	Stock	1.9438	1.9562	1.9125	1.9219	19594000.0
2000-08-16 14:00:00	AMZN	Stock	1.9219	1.9562	1.9188	1.9469	20994000.0
2000-08-16 15:00:00	AMZN	Stock	1.9469	1.9594	1.9281	1.9344	25832000.0
2000-08-16 16:00:00	AMZN	Stock	1.9344	1.9719	1.8188	1.925	2576000.0
2000-08-16 17:00:00	AMZN	Stock	1.9344	1.9344	1.9312	1.9312	3816000.0
2000-08-16 18:00:00	AMZN	Stock	1.9406	1.9438	1.9406	1.9438	14000.0
2000-08-16 09:00:00	CL	Stock	27.0625	27.125	26.8125	27.0312	537800.0
2000-08-16 10:00:00	CL	Stock	27.0312	27.0312	26.875	26.9375	247000.0
2000-08-16 11:00:00	CL	Stock	26.9062	27.1875	26.9062	27.1562	426000.0
2000-08-16 12:00:00	CL	Stock	27.1875	27.3125	26.9688	26.9688	224800.0
2000-08-16 13:00:00	CL	Stock	26.9688	27.0	26.9062	26.9062	175800.0
2000-08-16 14:00:00	CL	Stock	26.9375	26.9375	26.875	26.9062	178400.0

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

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