PREVIEW / stock_1hour / 2001-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-11-02.parquet
  size:    361 KB
  rows:    17,346
  symbols: 1,349

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
2001-11-02 08:00:00	AAPL	Stock	0.333	0.333	0.3304	0.3304	39200.0
2001-11-02 09:00:00	AAPL	Stock	0.3311	0.3368	0.3259	0.335	39838400.0
2001-11-02 10:00:00	AAPL	Stock	0.3346	0.3354	0.3268	0.3289	40381600.0
2001-11-02 11:00:00	AAPL	Stock	0.3289	0.333	0.3277	0.3302	17001600.0
2001-11-02 12:00:00	AAPL	Stock	0.3304	0.3339	0.3298	0.3311	13703200.0
2001-11-02 13:00:00	AAPL	Stock	0.3311	0.3313	0.3279	0.3286	8982400.0
2001-11-02 14:00:00	AAPL	Stock	0.3286	0.3302	0.3243	0.3282	25166400.0
2001-11-02 15:00:00	AAPL	Stock	0.3277	0.3334	0.3243	0.3318	41143200.0
2001-11-02 16:00:00	AAPL	Stock	0.3316	0.3321	0.3314	0.3316	4961600.0
2001-11-02 17:00:00	AAPL	Stock	0.3309	0.3309	0.3309	0.3309	632800.0
2001-11-02 08:00:00	MSFT	Stock	30.575	31.295	30.575	30.87	672400.0
2001-11-02 09:00:00	MSFT	Stock	30.85	31.0	30.29	30.625	12944600.0
2001-11-02 10:00:00	MSFT	Stock	30.62	30.77	30.4	30.6	12906800.0
2001-11-02 11:00:00	MSFT	Stock	30.61	31.18	30.485	31.125	8178600.0
2001-11-02 12:00:00	MSFT	Stock	31.125	31.5	31.065	31.495	8917600.0
2001-11-02 13:00:00	MSFT	Stock	31.495	31.5105	31.08	31.11	12208600.0
2001-11-02 14:00:00	MSFT	Stock	31.11	31.275	30.765	30.93	9802000.0
2001-11-02 15:00:00	MSFT	Stock	30.925	31.035	30.62	30.6995	13636000.0
2001-11-02 16:00:00	MSFT	Stock	30.7	31.43	30.65	30.775	2112400.0
2001-11-02 17:00:00	MSFT	Stock	30.6346	30.775	30.6346	30.775	413000.0
2001-11-02 18:00:00	MSFT	Stock	30.775	30.8	30.775	30.775	5800.0
2001-11-02 08:00:00	NVDA	Stock	0.3867	0.3875	0.3837	0.3871	936000.0
2001-11-02 09:00:00	NVDA	Stock	0.3844	0.3974	0.3838	0.39	148152000.0
2001-11-02 10:00:00	NVDA	Stock	0.39	0.3915	0.3717	0.3749	262500000.0
2001-11-02 11:00:00	NVDA	Stock	0.3758	0.3869	0.3731	0.3839	125508000.0
2001-11-02 12:00:00	NVDA	Stock	0.3846	0.3912	0.3817	0.3903	116592000.0
2001-11-02 13:00:00	NVDA	Stock	0.3901	0.3941	0.3875	0.3896	107676000.0
2001-11-02 14:00:00	NVDA	Stock	0.3894	0.3908	0.3842	0.3887	115044000.0
2001-11-02 15:00:00	NVDA	Stock	0.3887	0.3968	0.3868	0.3932	183756000.0
2001-11-02 16:00:00	NVDA	Stock	0.3931	0.3932	0.3892	0.39	19092000.0
2001-11-02 17:00:00	NVDA	Stock	0.3931	0.3931	0.3923	0.3923	180000.0
2001-11-02 18:00:00	NVDA	Stock	0.3923	0.3923	0.3923	0.3923	108000.0
2001-11-02 08:00:00	AMZN	Stock	0.3475	0.349	0.3375	0.347	202000.0
2001-11-02 09:00:00	AMZN	Stock	0.3485	0.3485	0.3375	0.3375	9214000.0
2001-11-02 10:00:00	AMZN	Stock	0.3375	0.3415	0.3355	0.336	15128000.0
2001-11-02 11:00:00	AMZN	Stock	0.336	0.339	0.3335	0.3385	9604000.0
2001-11-02 12:00:00	AMZN	Stock	0.3385	0.343	0.3375	0.343	5722000.0
2001-11-02 13:00:00	AMZN	Stock	0.3415	0.343	0.3375	0.3375	5032000.0
2001-11-02 14:00:00	AMZN	Stock	0.3375	0.342	0.335	0.3405	3532000.0
2001-11-02 15:00:00	AMZN	Stock	0.3405	0.341	0.335	0.336	23710000.0
2001-11-02 16:00:00	AMZN	Stock	0.336	0.337	0.334	0.3355	1434000.0
2001-11-02 17:00:00	AMZN	Stock	0.3355	0.339	0.3355	0.339	38000.0
2001-11-02 18:00:00	AMZN	Stock	0.339	0.339	0.339	0.339	8000.0
2001-11-02 09:00:00	CL	Stock	28.88	28.88	28.68	28.695	375400.0
2001-11-02 10:00:00	CL	Stock	28.695	28.8	28.675	28.8	572000.0
2001-11-02 11:00:00	CL	Stock	28.8	29.0	28.765	29.0	425000.0
2001-11-02 12:00:00	CL	Stock	29.0	29.05	28.91	28.995	415400.0
2001-11-02 13:00:00	CL	Stock	28.995	29.04	28.89	28.935	242400.0
2001-11-02 14:00:00	CL	Stock	28.945	29.205	28.935	29.2	337000.0
2001-11-02 15:00:00	CL	Stock	29.175	29.25	29.15	29.215	545200.0

> showing 50 of 17,346 rows — these rows as CSV

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