PREVIEW / stock_1hour / 2002-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-03-15.parquet
  size:    399 KB
  rows:    18,608
  symbols: 1,395

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
2002-03-15 09:00:00	AAPL	Stock	0.4357	0.4414	0.4352	0.4354	25491200.0
2002-03-15 10:00:00	AAPL	Stock	0.4359	0.4445	0.433	0.4432	46188800.0
2002-03-15 11:00:00	AAPL	Stock	0.4429	0.445	0.4425	0.4436	13423200.0
2002-03-15 12:00:00	AAPL	Stock	0.4434	0.4443	0.4404	0.4436	18620000.0
2002-03-15 13:00:00	AAPL	Stock	0.4436	0.4445	0.4407	0.4413	15657600.0
2002-03-15 14:00:00	AAPL	Stock	0.4418	0.4439	0.4413	0.4426	17729600.0
2002-03-15 15:00:00	AAPL	Stock	0.4429	0.4455	0.4404	0.4455	49593600.0
2002-03-15 16:00:00	AAPL	Stock	0.4455	0.4464	0.444	0.4455	17964800.0
2002-03-15 17:00:00	AAPL	Stock	0.4455	0.4455	0.4455	0.4455	106400.0
2002-03-15 08:00:00	MSFT	Stock	30.3	30.6	30.275	30.35	142200.0
2002-03-15 09:00:00	MSFT	Stock	30.35	30.875	30.29	30.62	12506400.0
2002-03-15 10:00:00	MSFT	Stock	30.625	30.93	30.55	30.895	6302600.0
2002-03-15 11:00:00	MSFT	Stock	30.885	31.105	30.875	30.985	5324800.0
2002-03-15 12:00:00	MSFT	Stock	30.99	31.02	30.585	30.775	5956000.0
2002-03-15 13:00:00	MSFT	Stock	30.775	30.865	30.68	30.865	2673200.0
2002-03-15 14:00:00	MSFT	Stock	30.85	31.1	30.825	31.075	4200000.0
2002-03-15 15:00:00	MSFT	Stock	31.085	31.255	30.845	31.245	8056000.0
2002-03-15 16:00:00	MSFT	Stock	31.245	31.25	30.7565	31.185	7727600.0
2002-03-15 17:00:00	MSFT	Stock	31.185	31.25	30.7607	31.25	509800.0
2002-03-15 18:00:00	MSFT	Stock	31.205	31.215	31.205	31.215	7200.0
2002-03-15 08:00:00	NVDA	Stock	0.4172	0.4294	0.4125	0.425	9024000.0
2002-03-15 09:00:00	NVDA	Stock	0.4242	0.4283	0.4168	0.421	201120000.0
2002-03-15 10:00:00	NVDA	Stock	0.4209	0.4351	0.4202	0.4327	210840000.0
2002-03-15 11:00:00	NVDA	Stock	0.4323	0.4387	0.4292	0.431	184860000.0
2002-03-15 12:00:00	NVDA	Stock	0.4306	0.4325	0.4225	0.4306	208872000.0
2002-03-15 13:00:00	NVDA	Stock	0.4307	0.4321	0.4275	0.4311	65148000.0
2002-03-15 14:00:00	NVDA	Stock	0.4312	0.4367	0.4308	0.4362	93804000.0
2002-03-15 15:00:00	NVDA	Stock	0.4361	0.4402	0.4325	0.4397	169584000.0
2002-03-15 16:00:00	NVDA	Stock	0.4397	0.4417	0.4305	0.4408	15420000.0
2002-03-15 17:00:00	NVDA	Stock	0.4416	0.4416	0.4397	0.4412	252000.0
2002-03-15 18:00:00	NVDA	Stock	0.4408	0.4408	0.4408	0.4408	12000.0
2002-03-15 08:00:00	AMZN	Stock	0.7225	0.7248	0.7052	0.71	622000.0
2002-03-15 09:00:00	AMZN	Stock	0.71	0.73	0.6955	0.6975	50136000.0
2002-03-15 10:00:00	AMZN	Stock	0.6975	0.712	0.6925	0.7095	58336000.0
2002-03-15 11:00:00	AMZN	Stock	0.71	0.713	0.7	0.706	21542000.0
2002-03-15 12:00:00	AMZN	Stock	0.7055	0.71	0.697	0.707	17002000.0
2002-03-15 13:00:00	AMZN	Stock	0.706	0.709	0.693	0.699	19612000.0
2002-03-15 14:00:00	AMZN	Stock	0.6985	0.702	0.695	0.7	12768000.0
2002-03-15 15:00:00	AMZN	Stock	0.6995	0.7045	0.6875	0.7015	25414000.0
2002-03-15 16:00:00	AMZN	Stock	0.7015	0.704	0.6935	0.7012	12644000.0
2002-03-15 17:00:00	AMZN	Stock	0.702	0.702	0.695	0.6955	98000.0
2002-03-15 18:00:00	AMZN	Stock	0.7015	0.7015	0.6975	0.6975	28000.0
2002-03-15 09:00:00	CL	Stock	27.4	27.475	27.37	27.475	1514400.0
2002-03-15 10:00:00	CL	Stock	27.47	27.6	27.455	27.575	999600.0
2002-03-15 11:00:00	CL	Stock	27.575	27.85	27.575	27.85	693600.0
2002-03-15 12:00:00	CL	Stock	27.85	27.915	27.83	27.915	278400.0
2002-03-15 13:00:00	CL	Stock	27.92	27.925	27.84	27.86	365200.0
2002-03-15 14:00:00	CL	Stock	27.845	27.99	27.845	27.975	371600.0
2002-03-15 15:00:00	CL	Stock	27.95	28.0	27.91	27.955	842800.0
2002-03-15 16:00:00	CL	Stock	27.955	27.99	27.67	27.67	163800.0

> showing 50 of 18,608 rows — these rows as CSV

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