PREVIEW / stock_1hour / 2006-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-07.parquet
  size:    591 KB
  rows:    28,240
  symbols: 2,323

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
2006-08-07 04:00:00	AAPL	Stock	2.4321	2.4321	2.4321	2.4321	2800.0
2006-08-07 07:00:00	AAPL	Stock	2.4232	2.4232	2.4107	2.4179	114800.0
2006-08-07 08:00:00	AAPL	Stock	2.4143	2.4304	2.4143	2.425	3160192.0
2006-08-07 09:00:00	AAPL	Stock	2.425	2.4314	2.3854	2.4218	128710036.0
2006-08-07 10:00:00	AAPL	Stock	2.4221	2.4393	2.4082	2.4182	145159392.0
2006-08-07 11:00:00	AAPL	Stock	2.4179	2.4614	2.4146	2.4586	118466264.0
2006-08-07 12:00:00	AAPL	Stock	2.4586	2.4607	2.4443	2.455	81708704.0
2006-08-07 13:00:00	AAPL	Stock	2.4554	2.4857	2.4479	2.455	203261044.0
2006-08-07 14:00:00	AAPL	Stock	2.4554	2.4554	2.3743	2.3889	330548008.0
2006-08-07 15:00:00	AAPL	Stock	2.3886	2.4089	2.3682	2.4004	222089420.0
2006-08-07 16:00:00	AAPL	Stock	2.4014	2.4036	2.3982	2.3989	1758792.0
2006-08-07 17:00:00	AAPL	Stock	2.3989	2.4004	2.3964	2.3982	269696.0
2006-08-07 18:00:00	AAPL	Stock	2.3982	2.4004	2.3964	2.4004	274288.0
2006-08-07 08:00:00	MSFT	Stock	24.13	24.25	24.07	24.2	16800.0
2006-08-07 09:00:00	MSFT	Stock	24.2	24.4	24.2	24.35	3522620.0
2006-08-07 10:00:00	MSFT	Stock	24.35	24.48	24.33	24.341	5729327.0
2006-08-07 11:00:00	MSFT	Stock	24.34	24.35	24.19	24.24	4116545.0
2006-08-07 12:00:00	MSFT	Stock	24.24	24.31	24.2	24.241	2375534.0
2006-08-07 13:00:00	MSFT	Stock	24.24	24.26	24.2	24.21	2618704.0
2006-08-07 14:00:00	MSFT	Stock	24.2	24.35	24.2	24.26	3678249.0
2006-08-07 15:00:00	MSFT	Stock	24.27	24.34	24.2	24.23	9173991.0
2006-08-07 16:00:00	MSFT	Stock	24.22	24.293	24.2	24.22	143998.0
2006-08-07 17:00:00	MSFT	Stock	24.22	24.26	24.22	24.23	105200.0
2006-08-07 18:00:00	MSFT	Stock	24.23	24.23	24.23	24.23	1100.0
2006-08-07 08:00:00	NVDA	Stock	0.3955	0.3955	0.3917	0.3925	308700.0
2006-08-07 09:00:00	NVDA	Stock	0.395	0.3998	0.3875	0.3957	66434940.0
2006-08-07 10:00:00	NVDA	Stock	0.3957	0.4002	0.3903	0.3905	74761980.0
2006-08-07 11:00:00	NVDA	Stock	0.3905	0.3947	0.3892	0.393	46946040.0
2006-08-07 12:00:00	NVDA	Stock	0.393	0.3977	0.3918	0.3973	37772940.0
2006-08-07 13:00:00	NVDA	Stock	0.3973	0.3992	0.3957	0.3978	44090160.0
2006-08-07 14:00:00	NVDA	Stock	0.398	0.3982	0.3928	0.3938	49555140.0
2006-08-07 15:00:00	NVDA	Stock	0.3937	0.3963	0.3928	0.3953	81686100.0
2006-08-07 16:00:00	NVDA	Stock	0.3957	0.3963	0.3937	0.3945	397020.0
2006-08-07 08:00:00	AMZN	Stock	1.35	1.351	1.35	1.3505	21000.0
2006-08-07 09:00:00	AMZN	Stock	1.36	1.3645	1.3295	1.342	13842200.0
2006-08-07 10:00:00	AMZN	Stock	1.342	1.35	1.342	1.345	11489860.0
2006-08-07 11:00:00	AMZN	Stock	1.3445	1.355	1.3425	1.3545	13953180.0
2006-08-07 12:00:00	AMZN	Stock	1.354	1.362	1.3535	1.3535	13117940.0
2006-08-07 13:00:00	AMZN	Stock	1.354	1.356	1.345	1.35	10925180.0
2006-08-07 14:00:00	AMZN	Stock	1.3495	1.3505	1.332	1.3405	15442080.0
2006-08-07 15:00:00	AMZN	Stock	1.34	1.345	1.334	1.339	24459620.0
2006-08-07 16:00:00	AMZN	Stock	1.34	1.345	1.3335	1.342	158520.0
2006-08-07 09:00:00	CL	Stock	29.345	29.44	29.25	29.36	336000.0
2006-08-07 10:00:00	CL	Stock	29.345	29.38	29.275	29.28	345600.0
2006-08-07 11:00:00	CL	Stock	29.275	29.46	29.265	29.445	243600.0
2006-08-07 12:00:00	CL	Stock	29.45	29.51	29.4	29.48	476600.0
2006-08-07 13:00:00	CL	Stock	29.48	29.51	29.475	29.48	580000.0
2006-08-07 14:00:00	CL	Stock	29.48	29.52	29.46	29.515	581800.0
2006-08-07 15:00:00	CL	Stock	29.515	29.53	29.49	29.5	1536200.0

> showing 49 of 28,240 rows — these rows as CSV

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