PREVIEW / stock_1hour / 2006-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-21.parquet
  size:    589 KB
  rows:    28,471
  symbols: 2,322

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-21 07:00:00	AAPL	Stock	2.4118	2.4161	2.4118	2.4118	142800.0
2006-08-21 08:00:00	AAPL	Stock	2.4161	2.4161	2.4014	2.4014	1037064.0
2006-08-21 09:00:00	AAPL	Stock	2.4018	2.4068	2.3664	2.3668	95242784.0
2006-08-21 10:00:00	AAPL	Stock	2.3668	2.3871	2.3625	2.3785	98123872.0
2006-08-21 11:00:00	AAPL	Stock	2.3782	2.3879	2.3704	2.3814	63118384.0
2006-08-21 12:00:00	AAPL	Stock	2.3814	2.3893	2.3732	2.3875	61222364.0
2006-08-21 13:00:00	AAPL	Stock	2.3875	2.3971	2.3786	2.3843	60035136.0
2006-08-21 14:00:00	AAPL	Stock	2.3843	2.3875	2.3718	2.3776	56994952.0
2006-08-21 15:00:00	AAPL	Stock	2.3778	2.3882	2.3764	2.3786	79187136.0
2006-08-21 16:00:00	AAPL	Stock	2.3786	2.3811	2.375	2.3768	3649072.0
2006-08-21 17:00:00	AAPL	Stock	2.3768	2.3775	2.375	2.3771	195244.0
2006-08-21 18:00:00	AAPL	Stock	2.3768	2.3771	2.3718	2.3732	168896.0
2006-08-21 07:00:00	MSFT	Stock	25.72	25.8	25.7	25.72	4550.0
2006-08-21 08:00:00	MSFT	Stock	25.7	25.75	25.65	25.75	83207.0
2006-08-21 09:00:00	MSFT	Stock	25.72	25.75	25.56	25.64	8999115.0
2006-08-21 10:00:00	MSFT	Stock	25.64	25.77	25.6	25.75	13933958.0
2006-08-21 11:00:00	MSFT	Stock	25.74	26.05	25.74	25.96	19333724.0
2006-08-21 12:00:00	MSFT	Stock	25.95	25.98	25.91	25.94	7230784.0
2006-08-21 13:00:00	MSFT	Stock	25.94	26.03	25.93	25.96	7831478.0
2006-08-21 14:00:00	MSFT	Stock	25.96	26.12	25.96	26.06	12139912.0
2006-08-21 15:00:00	MSFT	Stock	26.06	26.13	25.64	26.12	14397676.0
2006-08-21 16:00:00	MSFT	Stock	26.12	26.15	25.924	26.11	1008424.0
2006-08-21 17:00:00	MSFT	Stock	26.1	26.12	26.1	26.1	15473.0
2006-08-21 18:00:00	MSFT	Stock	26.1	26.1	26.1	26.1	600.0
2006-08-21 08:00:00	NVDA	Stock	0.45	0.4508	0.4483	0.45	541200.0
2006-08-21 09:00:00	NVDA	Stock	0.4492	0.4502	0.4417	0.4442	77172360.0
2006-08-21 10:00:00	NVDA	Stock	0.4442	0.449	0.4408	0.4419	87458460.0
2006-08-21 11:00:00	NVDA	Stock	0.4417	0.4442	0.4392	0.4394	68760900.0
2006-08-21 12:00:00	NVDA	Stock	0.4392	0.4438	0.4392	0.4423	40904100.0
2006-08-21 13:00:00	NVDA	Stock	0.4425	0.4445	0.44	0.4403	33612120.0
2006-08-21 14:00:00	NVDA	Stock	0.4403	0.4428	0.4382	0.4388	46573980.0
2006-08-21 15:00:00	NVDA	Stock	0.4388	0.4425	0.4385	0.439	121490760.0
2006-08-21 16:00:00	NVDA	Stock	0.4392	0.4393	0.439	0.4392	4373220.0
2006-08-21 17:00:00	NVDA	Stock	0.4392	0.4392	0.4383	0.4383	96000.0
2006-08-21 08:00:00	AMZN	Stock	1.452	1.452	1.4255	1.426	43400.0
2006-08-21 09:00:00	AMZN	Stock	1.445	1.449	1.4215	1.427	14632920.0
2006-08-21 10:00:00	AMZN	Stock	1.427	1.4275	1.4095	1.4125	16351140.0
2006-08-21 11:00:00	AMZN	Stock	1.4125	1.413	1.3985	1.4025	18661460.0
2006-08-21 12:00:00	AMZN	Stock	1.402	1.411	1.4	1.405	5873620.0
2006-08-21 13:00:00	AMZN	Stock	1.4055	1.417	1.4053	1.4145	10814980.0
2006-08-21 14:00:00	AMZN	Stock	1.414	1.425	1.404	1.4095	9475480.0
2006-08-21 15:00:00	AMZN	Stock	1.41	1.4125	1.4025	1.406	27295120.0
2006-08-21 16:00:00	AMZN	Stock	1.406	1.411	1.405	1.407	635700.0
2006-08-21 17:00:00	AMZN	Stock	1.4065	1.4065	1.4065	1.4065	38000.0
2006-08-21 18:00:00	AMZN	Stock	1.408	1.408	1.408	1.408	4000.0
2006-08-21 09:00:00	CL	Stock	29.61	29.71	29.56	29.6	251400.0
2006-08-21 10:00:00	CL	Stock	29.6	29.67	29.535	29.59	375600.0
2006-08-21 11:00:00	CL	Stock	29.59	29.65	29.565	29.62	366200.0
2006-08-21 12:00:00	CL	Stock	29.625	29.8	29.6	29.755	280600.0
2006-08-21 13:00:00	CL	Stock	29.755	29.775	29.623	29.655	296200.0

> showing 50 of 28,471 rows — these rows as CSV

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