PREVIEW / stock_1hour / 2001-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-05-24.parquet
  size:    367 KB
  rows:    17,444
  symbols: 1,302

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-05-24 08:00:00	AAPL	Stock	0.4145	0.4145	0.4145	0.4145	67200.0
2001-05-24 09:00:00	AAPL	Stock	0.4143	0.4161	0.4107	0.413	19465600.0
2001-05-24 10:00:00	AAPL	Stock	0.413	0.415	0.4107	0.4109	32827200.0
2001-05-24 11:00:00	AAPL	Stock	0.4111	0.4125	0.4039	0.407	37010400.0
2001-05-24 12:00:00	AAPL	Stock	0.407	0.4127	0.407	0.4096	17606400.0
2001-05-24 13:00:00	AAPL	Stock	0.4095	0.4107	0.4055	0.4073	21515200.0
2001-05-24 14:00:00	AAPL	Stock	0.4073	0.4105	0.4057	0.4091	34378400.0
2001-05-24 15:00:00	AAPL	Stock	0.4091	0.4161	0.4084	0.4159	56252000.0
2001-05-24 16:00:00	AAPL	Stock	0.4159	0.4161	0.4107	0.4143	28644000.0
2001-05-24 17:00:00	AAPL	Stock	0.4143	0.4152	0.4143	0.4152	1450400.0
2001-05-24 18:00:00	AAPL	Stock	0.4054	0.4121	0.4054	0.4121	39200.0
2001-05-24 08:00:00	MSFT	Stock	34.9	35.125	34.85	34.85	46400.0
2001-05-24 09:00:00	MSFT	Stock	34.855	35.19	34.44	35.125	12881000.0
2001-05-24 10:00:00	MSFT	Stock	35.125	35.13	34.7	34.865	10592000.0
2001-05-24 11:00:00	MSFT	Stock	34.86	35.24	34.85	35.21	7286800.0
2001-05-24 12:00:00	MSFT	Stock	35.21	35.275	35.005	35.05	5246200.0
2001-05-24 13:00:00	MSFT	Stock	35.05	35.36	35.0	35.3	4433400.0
2001-05-24 14:00:00	MSFT	Stock	35.3	35.62	35.22	35.515	17420400.0
2001-05-24 15:00:00	MSFT	Stock	35.515	35.89	35.465	35.855	16428000.0
2001-05-24 16:00:00	MSFT	Stock	35.855	35.875	35.27	35.805	3175800.0
2001-05-24 17:00:00	MSFT	Stock	35.84	35.86	35.825	35.845	221400.0
2001-05-24 18:00:00	MSFT	Stock	35.845	35.85	35.81	35.83	4600.0
2001-05-24 08:00:00	NVDA	Stock	0.3845	0.3879	0.3788	0.3833	4320000.0
2001-05-24 09:00:00	NVDA	Stock	0.3842	0.3842	0.3698	0.3796	306312000.0
2001-05-24 10:00:00	NVDA	Stock	0.3797	0.3805	0.3702	0.3749	305112000.0
2001-05-24 11:00:00	NVDA	Stock	0.375	0.3835	0.3735	0.3835	149976000.0
2001-05-24 12:00:00	NVDA	Stock	0.3833	0.3928	0.3823	0.3896	236496000.0
2001-05-24 13:00:00	NVDA	Stock	0.3896	0.3925	0.3858	0.3882	102648000.0
2001-05-24 14:00:00	NVDA	Stock	0.3882	0.3979	0.3846	0.3938	179304000.0
2001-05-24 15:00:00	NVDA	Stock	0.3938	0.3993	0.3863	0.3895	287952000.0
2001-05-24 16:00:00	NVDA	Stock	0.3894	0.3917	0.389	0.3903	33072000.0
2001-05-24 17:00:00	NVDA	Stock	0.3895	0.3913	0.3895	0.3913	864000.0
2001-05-24 18:00:00	NVDA	Stock	0.3906	0.3906	0.3904	0.3904	120000.0
2001-05-24 08:00:00	AMZN	Stock	0.7775	0.825	0.7775	0.7825	36000.0
2001-05-24 09:00:00	AMZN	Stock	0.784	0.795	0.777	0.79	15182000.0
2001-05-24 10:00:00	AMZN	Stock	0.789	0.792	0.7625	0.7655	13078000.0
2001-05-24 11:00:00	AMZN	Stock	0.7655	0.785	0.7625	0.775	8358000.0
2001-05-24 12:00:00	AMZN	Stock	0.775	0.776	0.77	0.77	3460000.0
2001-05-24 13:00:00	AMZN	Stock	0.77	0.7715	0.7625	0.7675	4988000.0
2001-05-24 14:00:00	AMZN	Stock	0.7675	0.7855	0.7675	0.7855	14960000.0
2001-05-24 15:00:00	AMZN	Stock	0.7855	0.8375	0.785	0.8375	35350000.0
2001-05-24 16:00:00	AMZN	Stock	0.8375	0.85	0.819	0.84	5652000.0
2001-05-24 17:00:00	AMZN	Stock	0.84	0.847	0.8375	0.845	350000.0
2001-05-24 18:00:00	AMZN	Stock	0.84	0.84	0.8375	0.84	50000.0
2001-05-24 09:00:00	CL	Stock	28.325	28.475	28.25	28.375	298400.0
2001-05-24 10:00:00	CL	Stock	28.39	28.45	28.275	28.33	255400.0
2001-05-24 11:00:00	CL	Stock	28.4	28.41	28.305	28.385	146200.0
2001-05-24 12:00:00	CL	Stock	28.385	28.5	28.375	28.38	134600.0
2001-05-24 13:00:00	CL	Stock	28.375	28.445	28.335	28.425	121200.0
2001-05-24 14:00:00	CL	Stock	28.4	28.7	28.4	28.605	247800.0

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

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