PREVIEW / stock_1hour / 2006-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-21.parquet
  size:    603 KB
  rows:    28,360
  symbols: 2,237

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-04-21 06:00:00	AAPL	Stock	2.4304	2.4304	2.4304	2.4304	2800.0
2006-04-21 07:00:00	AAPL	Stock	2.4268	2.4332	2.4268	2.4282	103600.0
2006-04-21 08:00:00	AAPL	Stock	2.4282	2.4332	2.4232	2.4304	3038448.0
2006-04-21 09:00:00	AAPL	Stock	2.4307	2.4514	2.4164	2.4254	130430720.0
2006-04-21 10:00:00	AAPL	Stock	2.425	2.4357	2.4018	2.4189	152128760.0
2006-04-21 11:00:00	AAPL	Stock	2.4189	2.4243	2.4132	2.4188	66312792.0
2006-04-21 12:00:00	AAPL	Stock	2.4189	2.4225	2.4021	2.4186	88563412.0
2006-04-21 13:00:00	AAPL	Stock	2.4189	2.4193	2.4082	2.4104	42816256.0
2006-04-21 14:00:00	AAPL	Stock	2.4107	2.4118	2.3821	2.3857	124701500.0
2006-04-21 15:00:00	AAPL	Stock	2.3864	2.4071	2.3739	2.3921	160399008.0
2006-04-21 16:00:00	AAPL	Stock	2.3921	2.4221	2.3857	2.3857	3630816.0
2006-04-21 17:00:00	AAPL	Stock	2.385	2.3879	2.3786	2.3839	2106692.0
2006-04-21 18:00:00	AAPL	Stock	2.3825	2.385	2.3818	2.385	189700.0
2006-04-21 08:00:00	MSFT	Stock	27.05	27.08	27.05	27.06	29169.0
2006-04-21 09:00:00	MSFT	Stock	27.06	27.17	27.0	27.1	12876702.0
2006-04-21 10:00:00	MSFT	Stock	27.1	27.2	27.09	27.14	7158030.0
2006-04-21 11:00:00	MSFT	Stock	27.131	27.3	27.09	27.27	8857265.0
2006-04-21 12:00:00	MSFT	Stock	27.27	27.39	27.27	27.32	5529440.0
2006-04-21 13:00:00	MSFT	Stock	27.32	27.35	27.25	27.28	3189656.0
2006-04-21 14:00:00	MSFT	Stock	27.29	27.31	27.11	27.14	9354793.0
2006-04-21 15:00:00	MSFT	Stock	27.14	27.2	27.09	27.13	9732645.0
2006-04-21 16:00:00	MSFT	Stock	27.13	27.187	27.13	27.14	127137.0
2006-04-21 17:00:00	MSFT	Stock	27.14	27.17	27.14	27.17	4389.0
2006-04-21 18:00:00	MSFT	Stock	27.14	27.14	27.14	27.14	465.0
2006-04-21 08:00:00	NVDA	Stock	0.4853	0.4853	0.4822	0.4822	226500.0
2006-04-21 09:00:00	NVDA	Stock	0.485	0.4888	0.4758	0.4785	69380160.0
2006-04-21 10:00:00	NVDA	Stock	0.4783	0.482	0.4757	0.478	93279360.0
2006-04-21 11:00:00	NVDA	Stock	0.478	0.4785	0.4732	0.4738	87371940.0
2006-04-21 12:00:00	NVDA	Stock	0.4738	0.4768	0.4732	0.475	43463820.0
2006-04-21 13:00:00	NVDA	Stock	0.4748	0.4783	0.4748	0.4752	46187880.0
2006-04-21 14:00:00	NVDA	Stock	0.4752	0.4753	0.4622	0.464	179109780.0
2006-04-21 15:00:00	NVDA	Stock	0.464	0.4683	0.463	0.4672	205816860.0
2006-04-21 16:00:00	NVDA	Stock	0.4673	0.468	0.4665	0.4677	7203600.0
2006-04-21 17:00:00	NVDA	Stock	0.4667	0.4678	0.4667	0.4678	315900.0
2006-04-21 18:00:00	NVDA	Stock	0.4692	0.4698	0.4692	0.4698	174000.0
2006-04-21 09:00:00	AMZN	Stock	1.8185	1.839	1.8155	1.8225	9452480.0
2006-04-21 10:00:00	AMZN	Stock	1.822	1.8365	1.8045	1.811	20585200.0
2006-04-21 11:00:00	AMZN	Stock	1.8115	1.8155	1.8095	1.8105	8893360.0
2006-04-21 12:00:00	AMZN	Stock	1.8105	1.8155	1.8075	1.813	6267540.0
2006-04-21 13:00:00	AMZN	Stock	1.8126	1.818	1.8125	1.815	5056020.0
2006-04-21 14:00:00	AMZN	Stock	1.8155	1.816	1.7925	1.795	14708680.0
2006-04-21 15:00:00	AMZN	Stock	1.7945	1.8045	1.786	1.8025	20653620.0
2006-04-21 16:00:00	AMZN	Stock	1.8035	1.8075	1.8015	1.8015	528060.0
2006-04-21 18:00:00	AMZN	Stock	1.805	1.805	1.805	1.805	2000.0
2006-04-21 08:00:00	CL	Stock	28.47	28.47	28.47	28.47	200.0
2006-04-21 09:00:00	CL	Stock	28.65	28.665	28.48	28.525	521400.0
2006-04-21 10:00:00	CL	Stock	28.525	28.67	28.375	28.385	445800.0
2006-04-21 11:00:00	CL	Stock	28.385	28.42	28.29	28.35	517600.0
2006-04-21 12:00:00	CL	Stock	28.35	28.445	28.34	28.42	149600.0
2006-04-21 13:00:00	CL	Stock	28.405	28.415	28.33	28.395	156200.0

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

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