PREVIEW / stock_1hour / 2002-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-14.parquet
  size:    398 KB
  rows:    18,784
  symbols: 1,361

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-01-14 08:00:00	AAPL	Stock	0.373	0.3759	0.373	0.3759	28000.0
2002-01-14 09:00:00	AAPL	Stock	0.375	0.3821	0.3748	0.3786	38332000.0
2002-01-14 10:00:00	AAPL	Stock	0.3788	0.3814	0.375	0.3766	86178400.0
2002-01-14 11:00:00	AAPL	Stock	0.3766	0.3781	0.3732	0.3775	50724800.0
2002-01-14 12:00:00	AAPL	Stock	0.3777	0.3777	0.3754	0.3764	26616800.0
2002-01-14 13:00:00	AAPL	Stock	0.3768	0.3786	0.375	0.3763	35733600.0
2002-01-14 14:00:00	AAPL	Stock	0.3763	0.3807	0.3752	0.3795	40314400.0
2002-01-14 15:00:00	AAPL	Stock	0.3804	0.3807	0.375	0.3779	95116000.0
2002-01-14 16:00:00	AAPL	Stock	0.3777	0.3791	0.3764	0.3768	15624000.0
2002-01-14 17:00:00	AAPL	Stock	0.3777	0.3777	0.3777	0.3777	1506400.0
2002-01-14 08:00:00	MSFT	Stock	34.25	34.3125	34.075	34.27	262200.0
2002-01-14 09:00:00	MSFT	Stock	34.3	34.52	34.13	34.3345	6263800.0
2002-01-14 10:00:00	MSFT	Stock	34.33	34.49	34.05	34.09	8691200.0
2002-01-14 11:00:00	MSFT	Stock	34.19	34.225	34.02	34.095	6761800.0
2002-01-14 12:00:00	MSFT	Stock	34.095	34.11	33.87	33.925	7937600.0
2002-01-14 13:00:00	MSFT	Stock	33.915	34.145	33.9	34.1	4080200.0
2002-01-14 14:00:00	MSFT	Stock	34.065	34.375	33.89	34.325	6189000.0
2002-01-14 15:00:00	MSFT	Stock	34.325	34.48	34.18	34.225	7354400.0
2002-01-14 16:00:00	MSFT	Stock	34.215	34.26	34.1387	34.1596	1554400.0
2002-01-14 17:00:00	MSFT	Stock	34.405	34.405	34.23	34.275	244600.0
2002-01-14 18:00:00	MSFT	Stock	34.32	34.32	34.32	34.32	1800.0
2002-01-14 08:00:00	NVDA	Stock	0.5234	0.5237	0.5187	0.5221	1716000.0
2002-01-14 09:00:00	NVDA	Stock	0.5217	0.5281	0.5042	0.5093	228288000.0
2002-01-14 10:00:00	NVDA	Stock	0.5093	0.5152	0.5062	0.5083	239244000.0
2002-01-14 11:00:00	NVDA	Stock	0.5087	0.5116	0.5067	0.5077	127164000.0
2002-01-14 12:00:00	NVDA	Stock	0.5075	0.5077	0.5006	0.5044	118788000.0
2002-01-14 13:00:00	NVDA	Stock	0.5045	0.5088	0.503	0.5062	103344000.0
2002-01-14 14:00:00	NVDA	Stock	0.5062	0.5083	0.5002	0.5055	170160000.0
2002-01-14 15:00:00	NVDA	Stock	0.5054	0.5089	0.498	0.498	260316000.0
2002-01-14 16:00:00	NVDA	Stock	0.498	0.5243	0.4973	0.4987	54144000.0
2002-01-14 17:00:00	NVDA	Stock	0.4979	0.4992	0.4975	0.498	1248000.0
2002-01-14 18:00:00	NVDA	Stock	0.4995	0.5	0.4994	0.5	120000.0
2002-01-14 08:00:00	AMZN	Stock	0.549	0.55	0.54	0.5449	284000.0
2002-01-14 09:00:00	AMZN	Stock	0.545	0.5485	0.5175	0.5225	24026000.0
2002-01-14 10:00:00	AMZN	Stock	0.523	0.535	0.521	0.5275	18526000.0
2002-01-14 11:00:00	AMZN	Stock	0.5275	0.5275	0.5125	0.513	18460000.0
2002-01-14 12:00:00	AMZN	Stock	0.513	0.5135	0.5045	0.5085	18670000.0
2002-01-14 13:00:00	AMZN	Stock	0.5095	0.5145	0.509	0.512	8252000.0
2002-01-14 14:00:00	AMZN	Stock	0.512	0.515	0.5075	0.5125	9894000.0
2002-01-14 15:00:00	AMZN	Stock	0.5125	0.516	0.505	0.5055	14342000.0
2002-01-14 16:00:00	AMZN	Stock	0.506	0.5192	0.503	0.5055	3556000.0
2002-01-14 17:00:00	AMZN	Stock	0.505	0.5055	0.501	0.505	554000.0
2002-01-14 18:00:00	AMZN	Stock	0.5055	0.5055	0.5055	0.5055	98000.0
2002-01-14 09:00:00	CL	Stock	27.45	27.78	27.45	27.78	261200.0
2002-01-14 10:00:00	CL	Stock	27.79	27.96	27.65	27.925	430800.0
2002-01-14 11:00:00	CL	Stock	27.88	28.0	27.825	28.0	331200.0
2002-01-14 12:00:00	CL	Stock	27.995	28.1	27.96	28.08	200000.0
2002-01-14 13:00:00	CL	Stock	28.1	28.225	28.04	28.22	161200.0
2002-01-14 14:00:00	CL	Stock	28.225	28.25	28.13	28.16	190400.0
2002-01-14 15:00:00	CL	Stock	28.165	28.22	27.9	27.935	505600.0

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

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