PREVIEW / stock_1hour / 2000-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-02.parquet
  size:    293 KB
  rows:    15,177
  symbols: 1,194

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-02 08:00:00	AAPL	Stock	0.8806	0.8806	0.8806	0.8806	492800.0
2000-08-02 09:00:00	AAPL	Stock	0.875	0.8817	0.8638	0.8661	20837600.0
2000-08-02 10:00:00	AAPL	Stock	0.8661	0.8906	0.8655	0.8839	35761600.0
2000-08-02 11:00:00	AAPL	Stock	0.8828	0.8895	0.8817	0.8873	15965600.0
2000-08-02 12:00:00	AAPL	Stock	0.8873	0.8917	0.8828	0.8839	7812000.0
2000-08-02 13:00:00	AAPL	Stock	0.8839	0.8839	0.8683	0.8728	10864000.0
2000-08-02 14:00:00	AAPL	Stock	0.8728	0.8806	0.8694	0.8694	13899200.0
2000-08-02 15:00:00	AAPL	Stock	0.8694	0.8728	0.8426	0.8438	45936800.0
2000-08-02 16:00:00	AAPL	Stock	0.8426	0.8454	0.8393	0.8393	7123200.0
2000-08-02 17:00:00	AAPL	Stock	0.8438	0.8438	0.8348	0.8348	11200.0
2000-08-02 18:00:00	AAPL	Stock	0.8482	0.8482	0.8449	0.8449	33600.0
2000-08-02 08:00:00	MSFT	Stock	34.3594	34.4375	34.3594	34.375	33200.0
2000-08-02 09:00:00	MSFT	Stock	34.2812	34.5	34.0	34.4375	6360000.0
2000-08-02 10:00:00	MSFT	Stock	34.4375	35.0938	34.4062	35.0312	7506600.0
2000-08-02 11:00:00	MSFT	Stock	35.0625	35.2188	34.75	35.0625	5824600.0
2000-08-02 12:00:00	MSFT	Stock	35.0625	35.125	34.875	35.0312	4259200.0
2000-08-02 13:00:00	MSFT	Stock	35.0625	35.1562	34.8438	35.0312	4187200.0
2000-08-02 14:00:00	MSFT	Stock	34.9688	35.0938	34.875	34.875	4755400.0
2000-08-02 15:00:00	MSFT	Stock	34.875	35.0	34.625	34.6875	6922400.0
2000-08-02 16:00:00	MSFT	Stock	34.6875	34.9688	34.6562	34.6875	7652600.0
2000-08-02 17:00:00	MSFT	Stock	34.5625	34.6875	34.5625	34.625	9400.0
2000-08-02 18:00:00	MSFT	Stock	34.75	34.75	34.5	34.5	2400.0
2000-08-02 08:00:00	NVDA	Stock	0.2449	0.2449	0.2449	0.2449	3600000.0
2000-08-02 09:00:00	NVDA	Stock	0.2422	0.2451	0.2378	0.2432	45576000.0
2000-08-02 10:00:00	NVDA	Stock	0.2435	0.249	0.2432	0.2484	41136000.0
2000-08-02 11:00:00	NVDA	Stock	0.2479	0.2484	0.2458	0.2466	24072000.0
2000-08-02 12:00:00	NVDA	Stock	0.2466	0.2505	0.2466	0.2495	24264000.0
2000-08-02 13:00:00	NVDA	Stock	0.2495	0.25	0.2479	0.2497	42672000.0
2000-08-02 14:00:00	NVDA	Stock	0.25	0.254	0.249	0.2505	54192000.0
2000-08-02 15:00:00	NVDA	Stock	0.25	0.2521	0.249	0.25	87792000.0
2000-08-02 16:00:00	NVDA	Stock	0.25	0.2594	0.248	0.248	7032000.0
2000-08-02 17:00:00	NVDA	Stock	0.2521	0.2521	0.2521	0.2521	24000.0
2000-08-02 08:00:00	AMZN	Stock	1.5156	1.5156	1.5125	1.5125	16000.0
2000-08-02 09:00:00	AMZN	Stock	1.5125	1.5438	1.5125	1.5281	9202000.0
2000-08-02 10:00:00	AMZN	Stock	1.5281	1.5875	1.525	1.5734	17776000.0
2000-08-02 11:00:00	AMZN	Stock	1.575	1.5938	1.5688	1.5844	14716000.0
2000-08-02 12:00:00	AMZN	Stock	1.5844	1.5906	1.575	1.5906	9174000.0
2000-08-02 13:00:00	AMZN	Stock	1.5875	1.6	1.575	1.575	8564000.0
2000-08-02 14:00:00	AMZN	Stock	1.5781	1.5875	1.5688	1.575	10818000.0
2000-08-02 15:00:00	AMZN	Stock	1.575	1.5875	1.5375	1.5375	15760000.0
2000-08-02 16:00:00	AMZN	Stock	1.5406	1.5703	1.525	1.55	8262000.0
2000-08-02 17:00:00	AMZN	Stock	1.55	1.55	1.5375	1.5406	42000.0
2000-08-02 18:00:00	AMZN	Stock	1.5438	1.55	1.5406	1.55	10000.0
2000-08-02 09:00:00	CL	Stock	28.5625	28.6875	27.6875	28.3438	501000.0
2000-08-02 10:00:00	CL	Stock	28.375	28.4375	28.0625	28.1562	336200.0
2000-08-02 11:00:00	CL	Stock	28.1562	28.25	28.0312	28.0625	129000.0
2000-08-02 12:00:00	CL	Stock	28.0625	28.1875	27.9688	28.1562	293400.0
2000-08-02 13:00:00	CL	Stock	28.1562	28.1875	28.0625	28.1875	143400.0
2000-08-02 14:00:00	CL	Stock	28.1562	28.2188	28.0312	28.1562	169400.0
2000-08-02 15:00:00	CL	Stock	28.1562	28.375	28.0312	28.3125	273000.0

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

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