PREVIEW / stock_1hour / 2002-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-09.parquet
  size:    392 KB
  rows:    18,785
  symbols: 1,403

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-04-09 08:00:00	AAPL	Stock	0.4463	0.4463	0.4407	0.4407	72800.0
2002-04-09 09:00:00	AAPL	Stock	0.4407	0.4464	0.4389	0.4407	30212000.0
2002-04-09 10:00:00	AAPL	Stock	0.4404	0.4405	0.4359	0.4373	27260800.0
2002-04-09 11:00:00	AAPL	Stock	0.4373	0.4373	0.4303	0.4346	34036800.0
2002-04-09 12:00:00	AAPL	Stock	0.4341	0.4361	0.4325	0.4344	14257600.0
2002-04-09 13:00:00	AAPL	Stock	0.4339	0.4339	0.43	0.4302	15512000.0
2002-04-09 14:00:00	AAPL	Stock	0.4302	0.4352	0.4288	0.4343	18972800.0
2002-04-09 15:00:00	AAPL	Stock	0.4345	0.4348	0.4295	0.4309	35554400.0
2002-04-09 16:00:00	AAPL	Stock	0.4304	0.4354	0.4304	0.4304	7968800.0
2002-04-09 17:00:00	AAPL	Stock	0.4304	0.4304	0.4304	0.4304	50400.0
2002-04-09 08:00:00	MSFT	Stock	28.87	28.87	28.5	28.7045	50000.0
2002-04-09 09:00:00	MSFT	Stock	28.71	28.735	28.31	28.355	7521000.0
2002-04-09 10:00:00	MSFT	Stock	28.36	28.408	28.04	28.27	10127400.0
2002-04-09 11:00:00	MSFT	Stock	28.27	28.275	27.92	27.925	6830200.0
2002-04-09 12:00:00	MSFT	Stock	27.92	27.995	27.815	27.82	5697400.0
2002-04-09 13:00:00	MSFT	Stock	27.82	27.9	27.6695	27.8	7562600.0
2002-04-09 14:00:00	MSFT	Stock	27.8	28.165	27.735	27.9505	8758000.0
2002-04-09 15:00:00	MSFT	Stock	27.955	27.96	27.4	27.435	12085400.0
2002-04-09 16:00:00	MSFT	Stock	27.435	28.0416	27.4	27.445	2149200.0
2002-04-09 17:00:00	MSFT	Stock	27.45	27.46	27.425	27.44	12000.0
2002-04-09 18:00:00	MSFT	Stock	27.45	27.45	27.425	27.425	3000.0
2002-04-09 08:00:00	NVDA	Stock	0.3646	0.3667	0.3626	0.3642	1236000.0
2002-04-09 09:00:00	NVDA	Stock	0.3638	0.3692	0.3627	0.366	161904000.0
2002-04-09 10:00:00	NVDA	Stock	0.3658	0.3662	0.3571	0.362	246288000.0
2002-04-09 11:00:00	NVDA	Stock	0.362	0.3623	0.3532	0.3532	154140000.0
2002-04-09 12:00:00	NVDA	Stock	0.3533	0.3538	0.3433	0.3435	182748000.0
2002-04-09 13:00:00	NVDA	Stock	0.3433	0.3486	0.3417	0.3458	108432000.0
2002-04-09 14:00:00	NVDA	Stock	0.3458	0.3517	0.345	0.3482	135756000.0
2002-04-09 15:00:00	NVDA	Stock	0.3481	0.3489	0.3393	0.3398	274968000.0
2002-04-09 16:00:00	NVDA	Stock	0.3405	0.3527	0.3355	0.3366	33192000.0
2002-04-09 17:00:00	NVDA	Stock	0.3367	0.3397	0.3367	0.3382	1776000.0
2002-04-09 18:00:00	NVDA	Stock	0.3375	0.3392	0.3375	0.3392	228000.0
2002-04-09 08:00:00	AMZN	Stock	0.702	0.71	0.6925	0.705	182000.0
2002-04-09 09:00:00	AMZN	Stock	0.7075	0.724	0.7015	0.7235	26638000.0
2002-04-09 10:00:00	AMZN	Stock	0.724	0.7295	0.7135	0.7195	26052000.0
2002-04-09 11:00:00	AMZN	Stock	0.7195	0.7215	0.714	0.72	15486000.0
2002-04-09 12:00:00	AMZN	Stock	0.7195	0.72	0.7056	0.708	7730000.0
2002-04-09 13:00:00	AMZN	Stock	0.7085	0.71	0.6886	0.693	13898000.0
2002-04-09 14:00:00	AMZN	Stock	0.693	0.705	0.6895	0.6895	11710000.0
2002-04-09 15:00:00	AMZN	Stock	0.689	0.692	0.678	0.68	20566000.0
2002-04-09 16:00:00	AMZN	Stock	0.6795	0.7025	0.676	0.6795	2508000.0
2002-04-09 17:00:00	AMZN	Stock	0.6795	0.681	0.6795	0.68	86000.0
2002-04-09 09:00:00	CL	Stock	28.75	28.82	28.725	28.77	354800.0
2002-04-09 10:00:00	CL	Stock	28.765	28.765	28.5	28.5	296000.0
2002-04-09 11:00:00	CL	Stock	28.51	28.55	28.45	28.54	213000.0
2002-04-09 12:00:00	CL	Stock	28.525	28.66	28.45	28.61	341000.0
2002-04-09 13:00:00	CL	Stock	28.61	28.65	28.56	28.65	255600.0
2002-04-09 14:00:00	CL	Stock	28.64	28.7	28.625	28.695	274800.0
2002-04-09 15:00:00	CL	Stock	28.695	28.72	28.64	28.645	407400.0
2002-04-09 16:00:00	CL	Stock	28.645	28.675	28.635	28.635	70000.0

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

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