PREVIEW / stock_1hour / 2006-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-11.parquet
  size:    597 KB
  rows:    28,542
  symbols: 2,226

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-11 07:00:00	AAPL	Stock	2.4421	2.4421	2.4421	2.4421	19600.0
2006-04-11 08:00:00	AAPL	Stock	2.4421	2.4707	2.4393	2.4693	5607280.0
2006-04-11 09:00:00	AAPL	Stock	2.4689	2.475	2.425	2.4314	166179076.0
2006-04-11 10:00:00	AAPL	Stock	2.4311	2.4354	2.3954	2.425	259111216.0
2006-04-11 11:00:00	AAPL	Stock	2.4254	2.4361	2.4129	2.4164	117100480.0
2006-04-11 12:00:00	AAPL	Stock	2.4168	2.4743	2.4082	2.4239	60423188.0
2006-04-11 13:00:00	AAPL	Stock	2.4236	2.4557	2.4232	2.4311	129734948.0
2006-04-11 14:00:00	AAPL	Stock	2.4311	2.4443	2.4293	2.4336	66424092.0
2006-04-11 15:00:00	AAPL	Stock	2.4332	2.4332	2.4118	2.4314	122391444.0
2006-04-11 16:00:00	AAPL	Stock	2.4311	2.4336	2.4282	2.4311	2018128.0
2006-04-11 17:00:00	AAPL	Stock	2.4311	2.4493	2.43	2.4304	501228.0
2006-04-11 18:00:00	AAPL	Stock	2.4321	2.4321	2.4286	2.43	169680.0
2006-04-11 06:00:00	MSFT	Stock	27.22	27.22	27.22	27.22	700.0
2006-04-11 07:00:00	MSFT	Stock	27.24	27.25	27.23	27.23	2450.0
2006-04-11 08:00:00	MSFT	Stock	27.28	27.28	27.25	27.25	14129.0
2006-04-11 09:00:00	MSFT	Stock	27.25	27.3	27.17	27.26	3074473.0
2006-04-11 10:00:00	MSFT	Stock	27.26	27.32	27.13	27.24	7412053.0
2006-04-11 11:00:00	MSFT	Stock	27.24	27.26	27.17	27.192	3231577.0
2006-04-11 12:00:00	MSFT	Stock	27.19	27.2	27.1	27.16	4462862.0
2006-04-11 13:00:00	MSFT	Stock	27.16	27.24	27.12	27.138	4542521.0
2006-04-11 14:00:00	MSFT	Stock	27.14	27.23	27.1	27.13	4703633.0
2006-04-11 15:00:00	MSFT	Stock	27.12	27.17	27.0	27.12	13171696.0
2006-04-11 16:00:00	MSFT	Stock	27.12	27.15	27.1	27.13	325194.0
2006-04-11 17:00:00	MSFT	Stock	27.11	27.11	27.11	27.11	1217.0
2006-04-11 08:00:00	NVDA	Stock	0.5	0.5022	0.5	0.5022	204000.0
2006-04-11 09:00:00	NVDA	Stock	0.5025	0.5025	0.4895	0.4895	104150280.0
2006-04-11 10:00:00	NVDA	Stock	0.4895	0.4923	0.4848	0.4895	170929620.0
2006-04-11 11:00:00	NVDA	Stock	0.4895	0.4965	0.4875	0.4902	90480720.0
2006-04-11 12:00:00	NVDA	Stock	0.4902	0.4948	0.4895	0.4925	46421940.0
2006-04-11 13:00:00	NVDA	Stock	0.4923	0.4947	0.4905	0.4913	41626440.0
2006-04-11 14:00:00	NVDA	Stock	0.4913	0.4963	0.4912	0.4912	57462780.0
2006-04-11 15:00:00	NVDA	Stock	0.4912	0.4913	0.485	0.4877	179472900.0
2006-04-11 16:00:00	NVDA	Stock	0.4877	0.4888	0.4873	0.4873	377520.0
2006-04-11 17:00:00	NVDA	Stock	0.4878	0.4878	0.4878	0.4878	36000.0
2006-04-11 18:00:00	NVDA	Stock	0.4878	0.4878	0.4878	0.4878	8280.0
2006-04-11 08:00:00	AMZN	Stock	1.83	1.83	1.83	1.83	10000.0
2006-04-11 09:00:00	AMZN	Stock	1.83	1.8375	1.805	1.805	10514160.0
2006-04-11 10:00:00	AMZN	Stock	1.805	1.8065	1.778	1.7835	29055640.0
2006-04-11 11:00:00	AMZN	Stock	1.783	1.7865	1.7785	1.7859	17129600.0
2006-04-11 12:00:00	AMZN	Stock	1.786	1.7965	1.7815	1.7835	5999820.0
2006-04-11 13:00:00	AMZN	Stock	1.7835	1.8035	1.782	1.799	15595360.0
2006-04-11 14:00:00	AMZN	Stock	1.7995	1.8045	1.7875	1.788	17560840.0
2006-04-11 15:00:00	AMZN	Stock	1.788	1.804	1.776	1.803	30726280.0
2006-04-11 16:00:00	AMZN	Stock	1.8025	1.805	1.801	1.804	328720.0
2006-04-11 17:00:00	AMZN	Stock	1.805	1.805	1.805	1.805	12700.0
2006-04-11 09:00:00	CL	Stock	28.775	28.86	28.725	28.75	410800.0
2006-04-11 10:00:00	CL	Stock	28.735	28.735	28.495	28.635	884400.0
2006-04-11 11:00:00	CL	Stock	28.625	28.69	28.6	28.615	483800.0
2006-04-11 12:00:00	CL	Stock	28.615	28.6735	28.58	28.58	426000.0
2006-04-11 13:00:00	CL	Stock	28.58	28.645	28.5	28.525	592600.0

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

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