PREVIEW / stock_1hour / 2001-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-04-24.parquet
  size:    350 KB
  rows:    16,477
  symbols: 1,278

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-04-24 08:00:00	AAPL	Stock	0.433	0.4366	0.4304	0.4366	487200.0
2001-04-24 09:00:00	AAPL	Stock	0.4404	0.4438	0.4339	0.4384	56414400.0
2001-04-24 10:00:00	AAPL	Stock	0.4384	0.4464	0.4355	0.4407	60698400.0
2001-04-24 11:00:00	AAPL	Stock	0.4407	0.4425	0.4332	0.4339	38522400.0
2001-04-24 12:00:00	AAPL	Stock	0.4338	0.4393	0.4293	0.4348	41893600.0
2001-04-24 13:00:00	AAPL	Stock	0.4348	0.442	0.4332	0.4377	28800800.0
2001-04-24 14:00:00	AAPL	Stock	0.4377	0.4411	0.4288	0.4288	37816800.0
2001-04-24 15:00:00	AAPL	Stock	0.4304	0.4313	0.4198	0.4291	74748800.0
2001-04-24 16:00:00	AAPL	Stock	0.4293	0.4475	0.427	0.4291	13356000.0
2001-04-24 17:00:00	AAPL	Stock	0.4241	0.4241	0.4241	0.4241	33600.0
2001-04-24 08:00:00	MSFT	Stock	33.9	34.325	33.75	34.31	85400.0
2001-04-24 09:00:00	MSFT	Stock	34.31	34.37	33.6	33.71	8983800.0
2001-04-24 10:00:00	MSFT	Stock	33.7	34.775	33.57	34.515	20767600.0
2001-04-24 11:00:00	MSFT	Stock	34.52	34.675	34.445	34.625	6700600.0
2001-04-24 12:00:00	MSFT	Stock	34.625	34.93	34.245	34.695	13140800.0
2001-04-24 13:00:00	MSFT	Stock	34.7	34.73	34.315	34.315	6031600.0
2001-04-24 14:00:00	MSFT	Stock	34.305	34.32	33.83	33.97	11365200.0
2001-04-24 15:00:00	MSFT	Stock	33.975	34.08	33.61	33.775	14310200.0
2001-04-24 16:00:00	MSFT	Stock	33.775	34.26	33.5	33.9	3063400.0
2001-04-24 17:00:00	MSFT	Stock	33.79	33.925	33.75	33.9	31800.0
2001-04-24 18:00:00	MSFT	Stock	33.875	33.9	33.875	33.9	2600.0
2001-04-24 08:00:00	NVDA	Stock	0.3417	0.3479	0.3415	0.3438	1560000.0
2001-04-24 09:00:00	NVDA	Stock	0.3448	0.3583	0.3385	0.357	150984000.0
2001-04-24 10:00:00	NVDA	Stock	0.357	0.3679	0.3552	0.3591	221424000.0
2001-04-24 11:00:00	NVDA	Stock	0.359	0.3629	0.3552	0.3604	152784000.0
2001-04-24 12:00:00	NVDA	Stock	0.3604	0.362	0.3567	0.3596	111960000.0
2001-04-24 13:00:00	NVDA	Stock	0.3592	0.3612	0.3556	0.3558	60048000.0
2001-04-24 14:00:00	NVDA	Stock	0.3558	0.3563	0.3263	0.3274	397344000.0
2001-04-24 15:00:00	NVDA	Stock	0.3281	0.3312	0.3135	0.3189	629280000.0
2001-04-24 16:00:00	NVDA	Stock	0.3189	0.3208	0.3152	0.3177	16392000.0
2001-04-24 17:00:00	NVDA	Stock	0.3179	0.3206	0.3173	0.3188	792000.0
2001-04-24 18:00:00	NVDA	Stock	0.3188	0.3188	0.314	0.3144	648000.0
2001-04-24 08:00:00	AMZN	Stock	0.821	0.825	0.8	0.82	90000.0
2001-04-24 09:00:00	AMZN	Stock	0.824	0.833	0.81	0.815	17742000.0
2001-04-24 10:00:00	AMZN	Stock	0.815	0.8395	0.8085	0.8225	20154000.0
2001-04-24 11:00:00	AMZN	Stock	0.822	0.826	0.815	0.824	11616000.0
2001-04-24 12:00:00	AMZN	Stock	0.8225	0.835	0.82	0.832	10846000.0
2001-04-24 13:00:00	AMZN	Stock	0.832	0.84	0.82	0.831	7840000.0
2001-04-24 14:00:00	AMZN	Stock	0.8305	0.833	0.809	0.811	14800000.0
2001-04-24 15:00:00	AMZN	Stock	0.811	0.819	0.774	0.7885	30366000.0
2001-04-24 16:00:00	AMZN	Stock	0.7885	0.881	0.7755	0.78	16034000.0
2001-04-24 17:00:00	AMZN	Stock	0.7825	0.8	0.778	0.789	2692000.0
2001-04-24 18:00:00	AMZN	Stock	0.79	0.795	0.789	0.791	302000.0
2001-04-24 09:00:00	CL	Stock	26.325	26.6	26.06	26.475	760400.0
2001-04-24 10:00:00	CL	Stock	26.48	26.525	26.45	26.5	488600.0
2001-04-24 11:00:00	CL	Stock	26.5	26.6	26.48	26.51	392800.0
2001-04-24 12:00:00	CL	Stock	26.515	26.525	26.26	26.265	578800.0
2001-04-24 13:00:00	CL	Stock	26.265	26.475	26.25	26.4	267800.0
2001-04-24 14:00:00	CL	Stock	26.425	26.475	26.375	26.38	243000.0
2001-04-24 15:00:00	CL	Stock	26.425	26.45	26.175	26.2	439600.0

> showing 50 of 16,477 rows — these rows as CSV

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