PREVIEW / stock_1hour / 2001-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-05-04.parquet
  size:    351 KB
  rows:    16,214
  symbols: 1,283

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-04 08:00:00	AAPL	Stock	0.4463	0.4464	0.4196	0.4348	3332000.0
2001-05-04 09:00:00	AAPL	Stock	0.4357	0.4423	0.4279	0.4416	53950400.0
2001-05-04 10:00:00	AAPL	Stock	0.4416	0.4468	0.4329	0.4436	63011200.0
2001-05-04 11:00:00	AAPL	Stock	0.442	0.4477	0.4379	0.4434	27888000.0
2001-05-04 12:00:00	AAPL	Stock	0.4434	0.4536	0.443	0.4527	21968800.0
2001-05-04 13:00:00	AAPL	Stock	0.4527	0.4541	0.4475	0.4525	13781600.0
2001-05-04 14:00:00	AAPL	Stock	0.4521	0.4561	0.4482	0.455	24158400.0
2001-05-04 15:00:00	AAPL	Stock	0.4548	0.4616	0.4525	0.4591	38673600.0
2001-05-04 16:00:00	AAPL	Stock	0.4598	0.4616	0.4491	0.4596	12062400.0
2001-05-04 08:00:00	MSFT	Stock	34.55	34.65	33.75	34.2	562600.0
2001-05-04 09:00:00	MSFT	Stock	34.125	34.65	33.925	34.635	15825800.0
2001-05-04 10:00:00	MSFT	Stock	34.65	34.8	34.3	34.655	16360400.0
2001-05-04 11:00:00	MSFT	Stock	34.655	35.0	34.6	34.995	12934200.0
2001-05-04 12:00:00	MSFT	Stock	34.99	35.275	34.985	35.14	13889200.0
2001-05-04 13:00:00	MSFT	Stock	35.14	35.4	34.985	35.29	9556800.0
2001-05-04 14:00:00	MSFT	Stock	35.29	35.435	35.1	35.425	12706400.0
2001-05-04 15:00:00	MSFT	Stock	35.425	35.525	35.295	35.375	26754600.0
2001-05-04 16:00:00	MSFT	Stock	35.37	35.5	35.13	35.375	1799800.0
2001-05-04 17:00:00	MSFT	Stock	35.375	35.475	35.375	35.44	120000.0
2001-05-04 18:00:00	MSFT	Stock	35.45	35.45	35.425	35.425	1400.0
2001-05-04 08:00:00	NVDA	Stock	0.3698	0.3735	0.3556	0.3581	5280000.0
2001-05-04 09:00:00	NVDA	Stock	0.3585	0.3662	0.3567	0.3615	153408000.0
2001-05-04 10:00:00	NVDA	Stock	0.3621	0.3801	0.3595	0.376	228048000.0
2001-05-04 11:00:00	NVDA	Stock	0.376	0.3797	0.3709	0.3761	104616000.0
2001-05-04 12:00:00	NVDA	Stock	0.3761	0.3789	0.375	0.3768	81192000.0
2001-05-04 13:00:00	NVDA	Stock	0.3765	0.3771	0.3715	0.3725	42936000.0
2001-05-04 14:00:00	NVDA	Stock	0.3725	0.3763	0.3632	0.3661	113472000.0
2001-05-04 15:00:00	NVDA	Stock	0.3662	0.3768	0.3656	0.3747	136800000.0
2001-05-04 16:00:00	NVDA	Stock	0.3746	0.3792	0.3733	0.3762	12336000.0
2001-05-04 17:00:00	NVDA	Stock	0.3743	0.375	0.3743	0.375	552000.0
2001-05-04 18:00:00	NVDA	Stock	0.375	0.375	0.375	0.375	96000.0
2001-05-04 08:00:00	AMZN	Stock	0.83	0.83	0.812	0.815	76000.0
2001-05-04 09:00:00	AMZN	Stock	0.815	0.825	0.7965	0.8045	12528000.0
2001-05-04 10:00:00	AMZN	Stock	0.8035	0.8365	0.8015	0.831	16222000.0
2001-05-04 11:00:00	AMZN	Stock	0.831	0.843	0.8225	0.8345	16040000.0
2001-05-04 12:00:00	AMZN	Stock	0.8325	0.849	0.8315	0.841	11450000.0
2001-05-04 13:00:00	AMZN	Stock	0.841	0.8545	0.835	0.847	10768000.0
2001-05-04 14:00:00	AMZN	Stock	0.847	0.863	0.8455	0.8525	11668000.0
2001-05-04 15:00:00	AMZN	Stock	0.8525	0.88	0.8475	0.8775	30378000.0
2001-05-04 16:00:00	AMZN	Stock	0.878	0.882	0.8755	0.8755	9708000.0
2001-05-04 17:00:00	AMZN	Stock	0.878	0.878	0.8755	0.8755	180000.0
2001-05-04 09:00:00	CL	Stock	27.95	27.975	27.85	27.975	67000.0
2001-05-04 10:00:00	CL	Stock	27.945	28.225	27.93	28.125	248000.0
2001-05-04 11:00:00	CL	Stock	28.15	28.25	28.0	28.19	165400.0
2001-05-04 12:00:00	CL	Stock	28.185	28.325	28.155	28.25	133800.0
2001-05-04 13:00:00	CL	Stock	28.25	28.425	28.24	28.345	411400.0
2001-05-04 14:00:00	CL	Stock	28.345	28.35	28.225	28.35	192800.0
2001-05-04 15:00:00	CL	Stock	28.35	28.48	28.235	28.395	429200.0
2001-05-04 16:00:00	CL	Stock	28.4	28.4	28.4	28.4	26400.0

> showing 49 of 16,214 rows — these rows as CSV

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