PREVIEW / stock_1hour / 2006-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-22.parquet
  size:    622 KB
  rows:    29,684
  symbols: 2,367

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-09-22 08:00:00	AAPL	Stock	2.6661	2.6661	2.6561	2.6636	608748.0
2006-09-22 09:00:00	AAPL	Stock	2.6621	2.6661	2.62	2.6236	115664444.0
2006-09-22 10:00:00	AAPL	Stock	2.6236	2.6264	2.6021	2.6161	136005800.0
2006-09-22 11:00:00	AAPL	Stock	2.6161	2.6196	2.6036	2.6068	100198112.0
2006-09-22 12:00:00	AAPL	Stock	2.6064	2.6104	2.5921	2.6061	92527372.0
2006-09-22 13:00:00	AAPL	Stock	2.6064	2.6157	2.605	2.6104	49936124.0
2006-09-22 14:00:00	AAPL	Stock	2.61	2.6146	2.5954	2.6007	65934372.0
2006-09-22 15:00:00	AAPL	Stock	2.6011	2.6146	2.6	2.6065	96987492.0
2006-09-22 16:00:00	AAPL	Stock	2.6064	2.6089	2.6054	2.6068	1069460.0
2006-09-22 17:00:00	AAPL	Stock	2.6071	2.6075	2.6057	2.6071	197260.0
2006-09-22 18:00:00	AAPL	Stock	2.6071	2.6089	2.6054	2.6089	422240.0
2006-09-22 19:00:00	AAPL	Stock	2.6089	2.6096	2.6089	2.6096	71848.0
2006-09-22 07:00:00	MSFT	Stock	26.81	26.81	26.81	26.81	1700.0
2006-09-22 08:00:00	MSFT	Stock	26.85	26.85	26.77	26.8	19345.0
2006-09-22 09:00:00	MSFT	Stock	26.8	26.85	26.67	26.68	6461679.0
2006-09-22 10:00:00	MSFT	Stock	26.68	26.78	26.523	26.54	8614198.0
2006-09-22 11:00:00	MSFT	Stock	26.54	26.74	26.5	26.71	5520452.0
2006-09-22 12:00:00	MSFT	Stock	26.7	26.71	26.56	26.65	4438616.0
2006-09-22 13:00:00	MSFT	Stock	26.64	26.7	26.56	26.567	3441952.0
2006-09-22 14:00:00	MSFT	Stock	26.56	26.615	26.48	26.52	4692069.0
2006-09-22 15:00:00	MSFT	Stock	26.53	26.75	26.52	26.66	11729317.0
2006-09-22 16:00:00	MSFT	Stock	26.65	26.74	26.65	26.68	258729.0
2006-09-22 17:00:00	MSFT	Stock	26.7	26.7	26.65	26.65	20750.0
2006-09-22 18:00:00	MSFT	Stock	26.65	26.65	26.65	26.65	1300.0
2006-09-22 08:00:00	NVDA	Stock	0.5107	0.5108	0.5083	0.5092	126000.0
2006-09-22 09:00:00	NVDA	Stock	0.5107	0.5137	0.506	0.5097	56905380.0
2006-09-22 10:00:00	NVDA	Stock	0.5097	0.5097	0.4985	0.4992	97380960.0
2006-09-22 11:00:00	NVDA	Stock	0.4992	0.501	0.4955	0.5002	70943460.0
2006-09-22 12:00:00	NVDA	Stock	0.5	0.5017	0.4948	0.4978	142286460.0
2006-09-22 13:00:00	NVDA	Stock	0.498	0.4983	0.4927	0.4933	52322700.0
2006-09-22 14:00:00	NVDA	Stock	0.4933	0.4957	0.4912	0.4942	76487460.0
2006-09-22 15:00:00	NVDA	Stock	0.4943	0.4985	0.4938	0.4967	139346220.0
2006-09-22 16:00:00	NVDA	Stock	0.4955	0.4968	0.4955	0.4968	8387220.0
2006-09-22 17:00:00	NVDA	Stock	0.4972	0.498	0.4968	0.498	228420.0
2006-09-22 18:00:00	NVDA	Stock	0.4982	0.505	0.4982	0.5042	283440.0
2006-09-22 19:00:00	NVDA	Stock	0.5042	0.5042	0.5042	0.5042	12000.0
2006-09-22 08:00:00	AMZN	Stock	1.5	1.5225	1.5	1.5135	22000.0
2006-09-22 09:00:00	AMZN	Stock	1.5135	1.5365	1.5095	1.531	18951180.0
2006-09-22 10:00:00	AMZN	Stock	1.531	1.5325	1.495	1.5135	41535480.0
2006-09-22 11:00:00	AMZN	Stock	1.513	1.5295	1.5105	1.5295	15850960.0
2006-09-22 12:00:00	AMZN	Stock	1.529	1.5325	1.514	1.5305	15096300.0
2006-09-22 13:00:00	AMZN	Stock	1.5295	1.5365	1.5285	1.535	9165580.0
2006-09-22 14:00:00	AMZN	Stock	1.5355	1.5425	1.5315	1.538	15862520.0
2006-09-22 15:00:00	AMZN	Stock	1.538	1.5475	1.5355	1.542	21847180.0
2006-09-22 16:00:00	AMZN	Stock	1.543	1.543	1.542	1.542	53780.0
2006-09-22 17:00:00	AMZN	Stock	1.5435	1.5435	1.5435	1.5435	2880.0
2006-09-22 09:00:00	CL	Stock	30.85	30.97	30.825	30.8865	151400.0
2006-09-22 10:00:00	CL	Stock	30.88	30.88	30.7	30.785	318200.0
2006-09-22 11:00:00	CL	Stock	30.775	30.89	30.76	30.805	427800.0
2006-09-22 12:00:00	CL	Stock	30.805	30.875	30.805	30.835	281000.0

> showing 50 of 29,684 rows — these rows as CSV

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