PREVIEW / stock_1hour / 2001-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-04.parquet
  size:    357 KB
  rows:    17,187
  symbols: 1,300

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-06-04 08:00:00	AAPL	Stock	0.373	0.3813	0.373	0.3813	229600.0
2001-06-04 09:00:00	AAPL	Stock	0.3759	0.3786	0.3686	0.3688	35470400.0
2001-06-04 10:00:00	AAPL	Stock	0.3682	0.3723	0.367	0.3705	44189600.0
2001-06-04 11:00:00	AAPL	Stock	0.3705	0.3725	0.367	0.3718	33790400.0
2001-06-04 12:00:00	AAPL	Stock	0.3718	0.3741	0.3705	0.3725	43310400.0
2001-06-04 13:00:00	AAPL	Stock	0.3716	0.3727	0.3682	0.3688	31427200.0
2001-06-04 14:00:00	AAPL	Stock	0.3691	0.3729	0.3657	0.372	26868800.0
2001-06-04 15:00:00	AAPL	Stock	0.3723	0.3739	0.3654	0.3688	45186400.0
2001-06-04 16:00:00	AAPL	Stock	0.3688	0.3705	0.3673	0.3673	14229600.0
2001-06-04 17:00:00	AAPL	Stock	0.3671	0.3671	0.3671	0.3671	56000.0
2001-06-04 08:00:00	MSFT	Stock	35.315	35.35	35.165	35.25	73000.0
2001-06-04 09:00:00	MSFT	Stock	35.25	35.5	35.15	35.24	6789400.0
2001-06-04 10:00:00	MSFT	Stock	35.255	35.285	34.9	35.01	8394400.0
2001-06-04 11:00:00	MSFT	Stock	35.01	35.115	34.92	34.985	4308600.0
2001-06-04 12:00:00	MSFT	Stock	34.965	35.37	34.96	35.335	4835000.0
2001-06-04 13:00:00	MSFT	Stock	35.34	35.4	35.205	35.245	3310400.0
2001-06-04 14:00:00	MSFT	Stock	35.255	35.395	35.2	35.355	3568000.0
2001-06-04 15:00:00	MSFT	Stock	35.355	35.51	35.275	35.385	8565400.0
2001-06-04 16:00:00	MSFT	Stock	35.39	35.425	35.235	35.425	1579000.0
2001-06-04 17:00:00	MSFT	Stock	35.4	35.5	35.37	35.5	270000.0
2001-06-04 18:00:00	MSFT	Stock	35.425	35.495	35.425	35.495	800.0
2001-06-04 08:00:00	NVDA	Stock	0.3813	0.3843	0.3792	0.3792	1440000.0
2001-06-04 09:00:00	NVDA	Stock	0.3792	0.38	0.3679	0.3682	113976000.0
2001-06-04 10:00:00	NVDA	Stock	0.3696	0.3729	0.3657	0.3677	140880000.0
2001-06-04 11:00:00	NVDA	Stock	0.3677	0.3706	0.3664	0.3694	66888000.0
2001-06-04 12:00:00	NVDA	Stock	0.3694	0.3725	0.3688	0.3708	39288000.0
2001-06-04 13:00:00	NVDA	Stock	0.3702	0.3723	0.3682	0.3693	97728000.0
2001-06-04 14:00:00	NVDA	Stock	0.3693	0.3713	0.3688	0.3701	42312000.0
2001-06-04 15:00:00	NVDA	Stock	0.37	0.374	0.3683	0.3707	88488000.0
2001-06-04 16:00:00	NVDA	Stock	0.3706	0.3804	0.369	0.3706	7104000.0
2001-06-04 17:00:00	NVDA	Stock	0.3704	0.3706	0.3696	0.3704	216000.0
2001-06-04 08:00:00	AMZN	Stock	0.84	0.8725	0.84	0.8725	132000.0
2001-06-04 09:00:00	AMZN	Stock	0.8725	0.8795	0.8325	0.8325	20232000.0
2001-06-04 10:00:00	AMZN	Stock	0.833	0.833	0.8075	0.8125	22714000.0
2001-06-04 11:00:00	AMZN	Stock	0.8125	0.8375	0.8075	0.8325	10240000.0
2001-06-04 12:00:00	AMZN	Stock	0.835	0.8605	0.8325	0.8525	18788000.0
2001-06-04 13:00:00	AMZN	Stock	0.853	0.858	0.8385	0.8515	9502000.0
2001-06-04 14:00:00	AMZN	Stock	0.851	0.855	0.8385	0.8535	11142000.0
2001-06-04 15:00:00	AMZN	Stock	0.851	0.86	0.84	0.8455	21242000.0
2001-06-04 16:00:00	AMZN	Stock	0.8455	0.85	0.845	0.85	706000.0
2001-06-04 17:00:00	AMZN	Stock	0.8505	0.8525	0.8455	0.8525	30000.0
2001-06-04 18:00:00	AMZN	Stock	0.8525	0.8525	0.85	0.85	46000.0
2001-06-04 09:00:00	CL	Stock	28.75	28.75	28.425	28.48	177200.0
2001-06-04 10:00:00	CL	Stock	28.48	28.505	28.25	28.31	222800.0
2001-06-04 11:00:00	CL	Stock	28.35	28.475	28.28	28.36	138200.0
2001-06-04 12:00:00	CL	Stock	28.31	28.525	28.27	28.51	234000.0
2001-06-04 13:00:00	CL	Stock	28.5	28.55	28.415	28.48	161400.0
2001-06-04 14:00:00	CL	Stock	28.45	28.725	28.45	28.695	440200.0
2001-06-04 15:00:00	CL	Stock	28.69	28.79	28.66	28.725	470400.0
2001-06-04 16:00:00	CL	Stock	28.725	29.0	28.725	29.0	43800.0

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

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