PREVIEW / stock_1hour / 2002-01-15

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-15.parquet
  size:    386 KB
  rows:    18,698
  symbols: 1,362

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-15 08:00:00	AAPL	Stock	0.3786	0.3816	0.3786	0.3816	22400.0
2002-01-15 09:00:00	AAPL	Stock	0.3795	0.388	0.3788	0.3838	30223200.0
2002-01-15 10:00:00	AAPL	Stock	0.3838	0.3848	0.3807	0.3836	44228800.0
2002-01-15 11:00:00	AAPL	Stock	0.3839	0.3879	0.3834	0.3848	37536800.0
2002-01-15 12:00:00	AAPL	Stock	0.3854	0.3875	0.3848	0.3861	35380800.0
2002-01-15 13:00:00	AAPL	Stock	0.3861	0.3875	0.3825	0.383	26980800.0
2002-01-15 14:00:00	AAPL	Stock	0.383	0.3868	0.3821	0.3863	44497600.0
2002-01-15 15:00:00	AAPL	Stock	0.3863	0.3886	0.3843	0.3871	42716800.0
2002-01-15 16:00:00	AAPL	Stock	0.387	0.3893	0.383	0.3875	9116800.0
2002-01-15 17:00:00	AAPL	Stock	0.3868	0.3875	0.3839	0.3839	929600.0
2002-01-15 08:00:00	MSFT	Stock	34.225	34.495	34.225	34.425	39800.0
2002-01-15 09:00:00	MSFT	Stock	34.45	34.515	34.25	34.44	6105600.0
2002-01-15 10:00:00	MSFT	Stock	34.435	34.61	34.3585	34.54	10002000.0
2002-01-15 11:00:00	MSFT	Stock	34.535	34.81	34.5305	34.71	11400400.0
2002-01-15 12:00:00	MSFT	Stock	34.715	34.75	34.505	34.585	4231400.0
2002-01-15 13:00:00	MSFT	Stock	34.59	34.65	34.265	34.305	4186800.0
2002-01-15 14:00:00	MSFT	Stock	34.305	34.5605	34.27	34.42	6448000.0
2002-01-15 15:00:00	MSFT	Stock	34.425	34.8	34.42	34.77	11612000.0
2002-01-15 16:00:00	MSFT	Stock	34.77	35.0	34.31	34.39	3637800.0
2002-01-15 17:00:00	MSFT	Stock	34.709	34.775	34.335	34.4	399600.0
2002-01-15 18:00:00	MSFT	Stock	34.4	34.4	34.35	34.35	2800.0
2002-01-15 08:00:00	NVDA	Stock	0.5117	0.5208	0.5052	0.517	26784000.0
2002-01-15 09:00:00	NVDA	Stock	0.5166	0.5281	0.5104	0.5268	360900000.0
2002-01-15 10:00:00	NVDA	Stock	0.5268	0.5367	0.5254	0.5363	389364000.0
2002-01-15 11:00:00	NVDA	Stock	0.5362	0.5405	0.5339	0.5366	211800000.0
2002-01-15 12:00:00	NVDA	Stock	0.5363	0.5375	0.534	0.5372	90792000.0
2002-01-15 13:00:00	NVDA	Stock	0.5372	0.5405	0.5301	0.531	157788000.0
2002-01-15 14:00:00	NVDA	Stock	0.5313	0.5358	0.5287	0.5313	196752000.0
2002-01-15 15:00:00	NVDA	Stock	0.5315	0.5448	0.5302	0.5442	289332000.0
2002-01-15 16:00:00	NVDA	Stock	0.5442	0.5458	0.5325	0.5372	60216000.0
2002-01-15 17:00:00	NVDA	Stock	0.5435	0.5445	0.5362	0.537	2736000.0
2002-01-15 18:00:00	NVDA	Stock	0.5375	0.5375	0.5357	0.5358	324000.0
2002-01-15 08:00:00	AMZN	Stock	0.5125	0.524	0.5125	0.5175	154000.0
2002-01-15 09:00:00	AMZN	Stock	0.5175	0.52	0.5104	0.517	17360000.0
2002-01-15 10:00:00	AMZN	Stock	0.5165	0.521	0.512	0.514	24188000.0
2002-01-15 11:00:00	AMZN	Stock	0.5135	0.519	0.51	0.5115	10998000.0
2002-01-15 12:00:00	AMZN	Stock	0.5115	0.5145	0.5085	0.512	11866000.0
2002-01-15 13:00:00	AMZN	Stock	0.512	0.5145	0.5085	0.5085	7550000.0
2002-01-15 14:00:00	AMZN	Stock	0.5085	0.5145	0.508	0.509	7802000.0
2002-01-15 15:00:00	AMZN	Stock	0.509	0.515	0.508	0.515	13906000.0
2002-01-15 16:00:00	AMZN	Stock	0.515	0.5205	0.503	0.503	2804000.0
2002-01-15 17:00:00	AMZN	Stock	0.503	0.5145	0.496	0.4995	386000.0
2002-01-15 18:00:00	AMZN	Stock	0.4995	0.505	0.4985	0.4985	74000.0
2002-01-15 09:00:00	CL	Stock	27.95	28.275	27.95	28.275	297800.0
2002-01-15 10:00:00	CL	Stock	28.295	28.44	28.26	28.385	359000.0
2002-01-15 11:00:00	CL	Stock	28.38	28.425	28.305	28.31	286200.0
2002-01-15 12:00:00	CL	Stock	28.31	28.4	28.295	28.39	233200.0
2002-01-15 13:00:00	CL	Stock	28.4	28.585	28.375	28.51	400600.0
2002-01-15 14:00:00	CL	Stock	28.51	28.515	28.305	28.315	383200.0
2002-01-15 15:00:00	CL	Stock	28.315	28.455	28.3	28.435	539000.0

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

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