PREVIEW / stock_1hour / 2000-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-11-02.parquet
  size:    301 KB
  rows:    15,811
  symbols: 1,235

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-11-02 08:00:00	AAPL	Stock	0.3655	0.3817	0.3655	0.3795	1624000.0
2000-11-02 09:00:00	AAPL	Stock	0.3795	0.3917	0.3711	0.3884	84134400.0
2000-11-02 10:00:00	AAPL	Stock	0.3884	0.3906	0.3817	0.3873	82023200.0
2000-11-02 11:00:00	AAPL	Stock	0.3873	0.3884	0.3839	0.3884	73393600.0
2000-11-02 12:00:00	AAPL	Stock	0.3884	0.3929	0.3862	0.3929	64825600.0
2000-11-02 13:00:00	AAPL	Stock	0.3917	0.3929	0.3895	0.3929	27725600.0
2000-11-02 14:00:00	AAPL	Stock	0.3929	0.3973	0.3917	0.3929	69720000.0
2000-11-02 15:00:00	AAPL	Stock	0.394	0.4007	0.3917	0.3984	105968800.0
2000-11-02 16:00:00	AAPL	Stock	0.3984	0.4018	0.3817	0.4007	20176800.0
2000-11-02 17:00:00	AAPL	Stock	0.3884	0.4018	0.3862	0.4007	190400.0
2000-11-02 18:00:00	AAPL	Stock	0.3996	0.4018	0.3996	0.4018	61600.0
2000-11-02 08:00:00	MSFT	Stock	35.25	35.625	34.7969	35.4375	371000.0
2000-11-02 09:00:00	MSFT	Stock	35.4062	35.6875	34.7188	35.125	10136000.0
2000-11-02 10:00:00	MSFT	Stock	35.0938	35.1875	34.9375	35.0938	10867800.0
2000-11-02 11:00:00	MSFT	Stock	35.125	35.3438	34.9688	35.2188	9097400.0
2000-11-02 12:00:00	MSFT	Stock	35.2188	35.2812	35.0625	35.125	6665600.0
2000-11-02 13:00:00	MSFT	Stock	35.0625	35.125	34.9375	35.0312	7744400.0
2000-11-02 14:00:00	MSFT	Stock	35.0312	35.2812	34.9688	35.25	8844000.0
2000-11-02 15:00:00	MSFT	Stock	35.25	35.4219	35.0625	35.125	12978600.0
2000-11-02 16:00:00	MSFT	Stock	35.0625	35.2812	34.9375	35.1875	4064400.0
2000-11-02 17:00:00	MSFT	Stock	35.0	35.1875	35.0	35.125	679200.0
2000-11-02 18:00:00	MSFT	Stock	35.25	35.25	35.125	35.125	18800.0
2000-11-02 09:00:00	NVDA	Stock	0.2682	0.2727	0.2635	0.2719	23064000.0
2000-11-02 10:00:00	NVDA	Stock	0.2711	0.2854	0.2698	0.2792	52224000.0
2000-11-02 11:00:00	NVDA	Stock	0.2794	0.2814	0.2714	0.2792	24264000.0
2000-11-02 12:00:00	NVDA	Stock	0.2792	0.2813	0.2771	0.2792	22296000.0
2000-11-02 13:00:00	NVDA	Stock	0.2792	0.2807	0.2792	0.2792	7824000.0
2000-11-02 14:00:00	NVDA	Stock	0.2797	0.2823	0.2794	0.2805	8928000.0
2000-11-02 15:00:00	NVDA	Stock	0.2813	0.2813	0.274	0.2766	22056000.0
2000-11-02 16:00:00	NVDA	Stock	0.2786	0.2786	0.2742	0.2786	7632000.0
2000-11-02 08:00:00	AMZN	Stock	1.8969	1.9125	1.8719	1.9062	122000.0
2000-11-02 09:00:00	AMZN	Stock	1.9062	1.95	1.875	1.9406	17354000.0
2000-11-02 10:00:00	AMZN	Stock	1.9375	1.9812	1.9188	1.9312	24506000.0
2000-11-02 11:00:00	AMZN	Stock	1.9312	1.95	1.9	1.9219	11190000.0
2000-11-02 12:00:00	AMZN	Stock	1.9219	1.9219	1.8906	1.9125	7922000.0
2000-11-02 13:00:00	AMZN	Stock	1.9125	1.9188	1.875	1.9031	9260000.0
2000-11-02 14:00:00	AMZN	Stock	1.9031	1.9188	1.8875	1.9125	6578000.0
2000-11-02 15:00:00	AMZN	Stock	1.9125	1.9938	1.9062	1.9875	36254000.0
2000-11-02 16:00:00	AMZN	Stock	1.9875	1.9906	1.9594	1.9641	1934000.0
2000-11-02 17:00:00	AMZN	Stock	1.9875	1.9875	1.9469	1.975	474000.0
2000-11-02 18:00:00	AMZN	Stock	1.9875	1.9875	1.9875	1.9875	16000.0
2000-11-02 09:00:00	CL	Stock	28.375	28.59	28.095	28.395	338200.0
2000-11-02 10:00:00	CL	Stock	28.375	29.255	28.375	29.25	764600.0
2000-11-02 11:00:00	CL	Stock	29.235	29.425	29.22	29.395	570800.0
2000-11-02 12:00:00	CL	Stock	29.395	29.395	29.15	29.15	277600.0
2000-11-02 13:00:00	CL	Stock	29.14	29.14	28.94	28.94	226600.0
2000-11-02 14:00:00	CL	Stock	28.925	29.205	28.75	29.205	360600.0
2000-11-02 15:00:00	CL	Stock	29.205	29.25	29.155	29.18	379400.0
2000-11-02 16:00:00	CL	Stock	29.18	29.18	29.175	29.175	85600.0
2000-11-02 17:00:00	CL	Stock	29.175	29.175	29.175	29.175	18000.0

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

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