PREVIEW / stock_1hour / 2002-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-06.parquet
  size:    398 KB
  rows:    18,917
  symbols: 1,471

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-09-06 08:00:00	AAPL	Stock	0.2563	0.2591	0.2563	0.2591	246400.0
2002-09-06 09:00:00	AAPL	Stock	0.2593	0.2616	0.2564	0.257	28526904.0
2002-09-06 10:00:00	AAPL	Stock	0.257	0.2598	0.2559	0.2588	41922888.0
2002-09-06 11:00:00	AAPL	Stock	0.2588	0.2591	0.2563	0.2566	23691864.0
2002-09-06 12:00:00	AAPL	Stock	0.2566	0.2573	0.2563	0.2571	10612728.0
2002-09-06 13:00:00	AAPL	Stock	0.2571	0.2579	0.2555	0.2563	17692360.0
2002-09-06 14:00:00	AAPL	Stock	0.2555	0.2571	0.2546	0.2564	12680472.0
2002-09-06 15:00:00	AAPL	Stock	0.2566	0.2575	0.2541	0.2555	21038304.0
2002-09-06 16:00:00	AAPL	Stock	0.2554	0.257	0.2554	0.2568	13552000.0
2002-09-06 17:00:00	AAPL	Stock	0.2568	0.2568	0.2563	0.2568	2497600.0
2002-09-06 08:00:00	MSFT	Stock	23.4	23.75	23.0575	23.661	1244980.0
2002-09-06 09:00:00	MSFT	Stock	23.66	23.975	23.625	23.865	13710566.0
2002-09-06 10:00:00	MSFT	Stock	23.865	23.975	23.735	23.92	14359516.0
2002-09-06 11:00:00	MSFT	Stock	23.9245	23.995	23.7855	23.835	8992378.0
2002-09-06 12:00:00	MSFT	Stock	23.835	24.0	23.805	23.99	5174096.0
2002-09-06 13:00:00	MSFT	Stock	23.99	24.1395	23.95	23.98	6186930.0
2002-09-06 14:00:00	MSFT	Stock	23.98	24.06	23.915	24.025	5345964.0
2002-09-06 15:00:00	MSFT	Stock	24.03	24.125	23.755	23.885	10557658.0
2002-09-06 16:00:00	MSFT	Stock	23.885	23.945	23.825	23.925	2743354.0
2002-09-06 17:00:00	MSFT	Stock	23.91	23.95	23.91	23.93	317000.0
2002-09-06 18:00:00	MSFT	Stock	23.925	23.945	23.8524	23.925	214600.0
2002-09-06 08:00:00	NVDA	Stock	0.0763	0.079	0.075	0.0787	4723320.0
2002-09-06 09:00:00	NVDA	Stock	0.0785	0.0794	0.0772	0.078	133825440.0
2002-09-06 10:00:00	NVDA	Stock	0.078	0.079	0.0768	0.077	103548000.0
2002-09-06 11:00:00	NVDA	Stock	0.0772	0.0772	0.0762	0.0767	98516640.0
2002-09-06 12:00:00	NVDA	Stock	0.0767	0.0773	0.0766	0.0771	73278120.0
2002-09-06 13:00:00	NVDA	Stock	0.0771	0.0774	0.0767	0.0768	90520560.0
2002-09-06 14:00:00	NVDA	Stock	0.0768	0.0772	0.0766	0.0771	46674600.0
2002-09-06 15:00:00	NVDA	Stock	0.0771	0.0779	0.076	0.0771	148120200.0
2002-09-06 16:00:00	NVDA	Stock	0.0771	0.0775	0.0764	0.0772	18174000.0
2002-09-06 17:00:00	NVDA	Stock	0.0772	0.0772	0.0755	0.0772	4932000.0
2002-09-06 18:00:00	NVDA	Stock	0.0763	0.0771	0.0763	0.0767	485520.0
2002-09-06 08:00:00	AMZN	Stock	0.727	0.7301	0.727	0.73	27860.0
2002-09-06 09:00:00	AMZN	Stock	0.728	0.7415	0.7255	0.738	7375120.0
2002-09-06 10:00:00	AMZN	Stock	0.7395	0.748	0.7365	0.7445	14449240.0
2002-09-06 11:00:00	AMZN	Stock	0.743	0.75	0.7375	0.7455	10422980.0
2002-09-06 12:00:00	AMZN	Stock	0.7465	0.753	0.7445	0.7495	6448640.0
2002-09-06 13:00:00	AMZN	Stock	0.75	0.759	0.7495	0.7565	12273560.0
2002-09-06 14:00:00	AMZN	Stock	0.7565	0.774	0.755	0.767	21599560.0
2002-09-06 15:00:00	AMZN	Stock	0.767	0.773	0.76	0.764	19843980.0
2002-09-06 16:00:00	AMZN	Stock	0.7635	0.7674	0.762	0.763	3222880.0
2002-09-06 17:00:00	AMZN	Stock	0.7655	0.7655	0.7125	0.7655	1288000.0
2002-09-06 18:00:00	AMZN	Stock	0.765	0.765	0.765	0.765	34000.0
2002-09-06 09:00:00	CL	Stock	28.0	28.1	27.585	27.6	1706600.0
2002-09-06 10:00:00	CL	Stock	27.625	27.67	27.4	27.615	1367600.0
2002-09-06 11:00:00	CL	Stock	27.615	27.825	27.55	27.55	525200.0
2002-09-06 12:00:00	CL	Stock	27.555	27.655	27.555	27.6	404000.0
2002-09-06 13:00:00	CL	Stock	27.6	27.63	27.51	27.515	239600.0
2002-09-06 14:00:00	CL	Stock	27.505	27.625	27.46	27.595	405800.0
2002-09-06 15:00:00	CL	Stock	27.59	27.59	27.365	27.4	706000.0

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

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