PREVIEW / stock_1hour / 2002-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-04.parquet
  size:    395 KB
  rows:    18,793
  symbols: 1,400

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-04 08:00:00	AAPL	Stock	0.425	0.425	0.4248	0.4248	246400.0
2002-04-04 09:00:00	AAPL	Stock	0.4245	0.4368	0.4227	0.4345	30200800.0
2002-04-04 10:00:00	AAPL	Stock	0.4343	0.4436	0.4321	0.4386	56929600.0
2002-04-04 11:00:00	AAPL	Stock	0.4391	0.4395	0.433	0.435	27143200.0
2002-04-04 12:00:00	AAPL	Stock	0.435	0.4375	0.4346	0.4352	12852000.0
2002-04-04 13:00:00	AAPL	Stock	0.4352	0.4463	0.4348	0.4461	28800800.0
2002-04-04 14:00:00	AAPL	Stock	0.4461	0.4473	0.4366	0.4393	66634400.0
2002-04-04 15:00:00	AAPL	Stock	0.4386	0.4468	0.4375	0.4455	75336800.0
2002-04-04 16:00:00	AAPL	Stock	0.4457	0.4464	0.4332	0.4446	25592000.0
2002-04-04 17:00:00	AAPL	Stock	0.4443	0.4446	0.4443	0.4446	89600.0
2002-04-04 08:00:00	MSFT	Stock	28.44	28.44	27.9	27.975	540400.0
2002-04-04 09:00:00	MSFT	Stock	27.975	28.315	27.8695	28.205	9567400.0
2002-04-04 10:00:00	MSFT	Stock	28.21	28.485	28.065	28.28	12671400.0
2002-04-04 11:00:00	MSFT	Stock	28.285	28.295	28.105	28.12	5983600.0
2002-04-04 12:00:00	MSFT	Stock	28.1195	28.28	28.07	28.125	4837600.0
2002-04-04 13:00:00	MSFT	Stock	28.13	28.2555	27.97	28.06	6961000.0
2002-04-04 14:00:00	MSFT	Stock	28.065	28.105	27.785	27.86	6010000.0
2002-04-04 15:00:00	MSFT	Stock	27.86	28.25	27.714	28.225	11844800.0
2002-04-04 16:00:00	MSFT	Stock	28.225	28.27	28.03	28.2	1645400.0
2002-04-04 17:00:00	MSFT	Stock	28.2	28.225	28.155	28.21	28200.0
2002-04-04 18:00:00	MSFT	Stock	28.2	28.225	28.16	28.225	1400.0
2002-04-04 08:00:00	NVDA	Stock	0.3647	0.3647	0.3554	0.3569	1188000.0
2002-04-04 09:00:00	NVDA	Stock	0.3579	0.3637	0.3531	0.3627	200712000.0
2002-04-04 10:00:00	NVDA	Stock	0.3625	0.3712	0.3614	0.3658	228660000.0
2002-04-04 11:00:00	NVDA	Stock	0.3658	0.3658	0.3562	0.3568	172224000.0
2002-04-04 12:00:00	NVDA	Stock	0.3568	0.3624	0.3562	0.3602	94020000.0
2002-04-04 13:00:00	NVDA	Stock	0.3601	0.3631	0.3587	0.3616	96636000.0
2002-04-04 14:00:00	NVDA	Stock	0.3615	0.3626	0.3567	0.3584	115068000.0
2002-04-04 15:00:00	NVDA	Stock	0.3584	0.3607	0.355	0.359	162204000.0
2002-04-04 16:00:00	NVDA	Stock	0.359	0.3614	0.3579	0.3579	24876000.0
2002-04-04 17:00:00	NVDA	Stock	0.3587	0.359	0.3567	0.3582	408000.0
2002-04-04 18:00:00	NVDA	Stock	0.3571	0.3592	0.3571	0.3572	168000.0
2002-04-04 08:00:00	AMZN	Stock	0.686	0.6884	0.685	0.6855	182000.0
2002-04-04 09:00:00	AMZN	Stock	0.6875	0.69	0.6685	0.674	23966000.0
2002-04-04 10:00:00	AMZN	Stock	0.674	0.6815	0.6665	0.6775	19202000.0
2002-04-04 11:00:00	AMZN	Stock	0.68	0.68	0.672	0.675	14392000.0
2002-04-04 12:00:00	AMZN	Stock	0.675	0.683	0.6745	0.677	10058000.0
2002-04-04 13:00:00	AMZN	Stock	0.677	0.678	0.67	0.6745	9026000.0
2002-04-04 14:00:00	AMZN	Stock	0.6745	0.675	0.6615	0.665	10186000.0
2002-04-04 15:00:00	AMZN	Stock	0.665	0.682	0.6615	0.6785	18738000.0
2002-04-04 16:00:00	AMZN	Stock	0.677	0.6795	0.6645	0.677	5770000.0
2002-04-04 17:00:00	AMZN	Stock	0.677	0.677	0.677	0.677	16000.0
2002-04-04 09:00:00	CL	Stock	28.2	28.535	28.2	28.535	340400.0
2002-04-04 10:00:00	CL	Stock	28.535	28.66	28.51	28.6	663400.0
2002-04-04 11:00:00	CL	Stock	28.605	28.63	28.56	28.58	302600.0
2002-04-04 12:00:00	CL	Stock	28.575	28.625	28.525	28.525	237400.0
2002-04-04 13:00:00	CL	Stock	28.55	28.675	28.54	28.635	352600.0
2002-04-04 14:00:00	CL	Stock	28.64	28.68	28.6	28.665	422400.0
2002-04-04 15:00:00	CL	Stock	28.66	28.725	28.61	28.72	723800.0
2002-04-04 16:00:00	CL	Stock	28.705	28.705	28.605	28.61	301400.0

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

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