PREVIEW / stock_1hour / 2002-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-03-19.parquet
  size:    389 KB
  rows:    18,285
  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-19 08:00:00	AAPL	Stock	0.442	0.442	0.4417	0.4417	2324000.0
2002-03-19 09:00:00	AAPL	Stock	0.4414	0.4425	0.4395	0.4413	15898400.0
2002-03-19 10:00:00	AAPL	Stock	0.4411	0.4421	0.4368	0.4388	21196000.0
2002-03-19 11:00:00	AAPL	Stock	0.4389	0.4425	0.4388	0.442	18407200.0
2002-03-19 12:00:00	AAPL	Stock	0.442	0.4457	0.4416	0.4455	31276000.0
2002-03-19 13:00:00	AAPL	Stock	0.4455	0.447	0.4448	0.4463	27563200.0
2002-03-19 14:00:00	AAPL	Stock	0.4459	0.4509	0.4434	0.4446	58503200.0
2002-03-19 15:00:00	AAPL	Stock	0.4446	0.4461	0.4409	0.4429	33381600.0
2002-03-19 16:00:00	AAPL	Stock	0.4438	0.4446	0.4421	0.4443	8808800.0
2002-03-19 18:00:00	AAPL	Stock	0.445	0.445	0.445	0.445	11200.0
2002-03-19 08:00:00	MSFT	Stock	30.925	31.225	30.925	31.075	61400.0
2002-03-19 09:00:00	MSFT	Stock	31.075	31.24	31.0	31.22	4518200.0
2002-03-19 10:00:00	MSFT	Stock	31.2195	31.2455	31.105	31.17	4977600.0
2002-03-19 11:00:00	MSFT	Stock	31.17	31.2	31.08	31.15	2408600.0
2002-03-19 12:00:00	MSFT	Stock	31.15	31.18	31.075	31.1	2758400.0
2002-03-19 13:00:00	MSFT	Stock	31.085	31.18	31.06	31.1345	2272200.0
2002-03-19 14:00:00	MSFT	Stock	31.135	31.295	30.865	31.055	7840800.0
2002-03-19 15:00:00	MSFT	Stock	31.0655	31.125	30.75	31.12	7767400.0
2002-03-19 16:00:00	MSFT	Stock	31.12	31.145	31.0189	31.1	1516600.0
2002-03-19 17:00:00	MSFT	Stock	31.1	31.175	31.1	31.1098	8600.0
2002-03-19 08:00:00	NVDA	Stock	0.4421	0.4457	0.4412	0.4429	984000.0
2002-03-19 09:00:00	NVDA	Stock	0.4401	0.4429	0.4385	0.4412	84660000.0
2002-03-19 10:00:00	NVDA	Stock	0.4412	0.4437	0.4372	0.4383	100524000.0
2002-03-19 11:00:00	NVDA	Stock	0.4384	0.4395	0.4354	0.4361	69996000.0
2002-03-19 12:00:00	NVDA	Stock	0.4362	0.4373	0.4312	0.4313	91512000.0
2002-03-19 13:00:00	NVDA	Stock	0.4312	0.4342	0.4296	0.4333	98472000.0
2002-03-19 14:00:00	NVDA	Stock	0.4333	0.4358	0.4283	0.4311	178800000.0
2002-03-19 15:00:00	NVDA	Stock	0.4312	0.4325	0.4278	0.4305	118092000.0
2002-03-19 16:00:00	NVDA	Stock	0.4307	0.4356	0.4292	0.4308	10704000.0
2002-03-19 17:00:00	NVDA	Stock	0.4309	0.4332	0.4309	0.4331	588000.0
2002-03-19 18:00:00	NVDA	Stock	0.4332	0.4333	0.4332	0.4333	60000.0
2002-03-19 08:00:00	AMZN	Stock	0.7523	0.7628	0.7523	0.758	166000.0
2002-03-19 09:00:00	AMZN	Stock	0.758	0.77	0.753	0.7655	20386000.0
2002-03-19 10:00:00	AMZN	Stock	0.765	0.77	0.7575	0.7605	13410000.0
2002-03-19 11:00:00	AMZN	Stock	0.76	0.761	0.7515	0.757	7520000.0
2002-03-19 12:00:00	AMZN	Stock	0.757	0.7625	0.755	0.7565	4904000.0
2002-03-19 13:00:00	AMZN	Stock	0.756	0.7595	0.756	0.758	3672000.0
2002-03-19 14:00:00	AMZN	Stock	0.7576	0.761	0.739	0.7415	14770000.0
2002-03-19 15:00:00	AMZN	Stock	0.7414	0.7515	0.728	0.7335	17442000.0
2002-03-19 16:00:00	AMZN	Stock	0.733	0.7547	0.7325	0.745	6870000.0
2002-03-19 17:00:00	AMZN	Stock	0.736	0.736	0.733	0.733	36000.0
2002-03-19 18:00:00	AMZN	Stock	0.7375	0.7375	0.7375	0.7375	4000.0
2002-03-19 09:00:00	CL	Stock	28.25	28.515	28.25	28.475	457400.0
2002-03-19 10:00:00	CL	Stock	28.485	28.825	28.47	28.735	1482400.0
2002-03-19 11:00:00	CL	Stock	28.735	28.775	28.65	28.65	639800.0
2002-03-19 12:00:00	CL	Stock	28.67	28.74	28.615	28.63	503200.0
2002-03-19 13:00:00	CL	Stock	28.63	28.675	28.55	28.63	535800.0
2002-03-19 14:00:00	CL	Stock	28.63	28.63	28.425	28.525	450800.0
2002-03-19 15:00:00	CL	Stock	28.525	28.535	28.36	28.425	807800.0
2002-03-19 16:00:00	CL	Stock	28.43	28.58	28.43	28.435	436800.0

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

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