PREVIEW / stock_1hour / 2008-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-16.parquet
  size:    846 KB
  rows:    40,703
  symbols: 3,290

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
2008-05-16 05:00:00	AAPL	Stock	6.7857	6.79	6.7857	6.79	28000.0
2008-05-16 07:00:00	AAPL	Stock	6.8089	6.8089	6.7811	6.7811	365680.0
2008-05-16 08:00:00	AAPL	Stock	6.7786	6.8018	6.7625	6.7996	3320044.0
2008-05-16 09:00:00	AAPL	Stock	6.7986	6.7986	6.745	6.7771	137842544.0
2008-05-16 10:00:00	AAPL	Stock	6.7771	6.7839	6.6896	6.7129	147292908.0
2008-05-16 11:00:00	AAPL	Stock	6.7129	6.7382	6.6786	6.7264	104464948.0
2008-05-16 12:00:00	AAPL	Stock	6.7269	6.7489	6.7161	6.7446	54819996.0
2008-05-16 13:00:00	AAPL	Stock	6.7439	6.7468	6.6936	6.7143	73336620.0
2008-05-16 14:00:00	AAPL	Stock	6.7143	6.7314	6.7025	6.7068	79395120.0
2008-05-16 15:00:00	AAPL	Stock	6.7061	6.7271	6.6929	6.7029	140896112.0
2008-05-16 16:00:00	AAPL	Stock	6.7025	6.7306	6.3411	6.7054	9454284.0
2008-05-16 17:00:00	AAPL	Stock	6.7264	6.7264	6.7	6.7054	254072.0
2008-05-16 18:00:00	AAPL	Stock	6.7054	6.7082	6.6964	6.6964	434000.0
2008-05-16 19:00:00	AAPL	Stock	6.7029	6.7082	6.6911	6.7082	146048.0
2008-05-16 08:00:00	MSFT	Stock	30.45	30.45	30.36	30.42	6360.0
2008-05-16 09:00:00	MSFT	Stock	30.42	30.5	30.09	30.12	12975420.0
2008-05-16 10:00:00	MSFT	Stock	30.12	30.23	30.04	30.08	10805080.0
2008-05-16 11:00:00	MSFT	Stock	30.08	30.21	30.0	30.05	8107453.0
2008-05-16 12:00:00	MSFT	Stock	30.05	30.105	30.0	30.05	10844378.0
2008-05-16 13:00:00	MSFT	Stock	30.05	30.08	29.965	29.971	10046670.0
2008-05-16 14:00:00	MSFT	Stock	29.97	30.01	29.92	29.98	9318725.0
2008-05-16 15:00:00	MSFT	Stock	29.99	30.04	29.95	30.0	13941914.0
2008-05-16 16:00:00	MSFT	Stock	30.0	30.15	29.9	29.99	3046006.0
2008-05-16 17:00:00	MSFT	Stock	29.98	30.04	29.93	30.02	10896.0
2008-05-16 18:00:00	MSFT	Stock	30.03	30.03	29.96	29.98	3360.0
2008-05-16 19:00:00	MSFT	Stock	30.02	30.02	29.98	30.02	780.0
2008-05-16 07:00:00	NVDA	Stock	0.5952	0.5952	0.5952	0.5952	8000.0
2008-05-16 08:00:00	NVDA	Stock	0.5952	0.605	0.5952	0.605	1292200.0
2008-05-16 09:00:00	NVDA	Stock	0.6048	0.6088	0.5958	0.6013	161435560.0
2008-05-16 10:00:00	NVDA	Stock	0.6014	0.6038	0.592	0.5952	201683720.0
2008-05-16 11:00:00	NVDA	Stock	0.595	0.601	0.5908	0.5995	147750960.0
2008-05-16 12:00:00	NVDA	Stock	0.5992	0.6082	0.5955	0.606	104595880.0
2008-05-16 13:00:00	NVDA	Stock	0.6063	0.6075	0.601	0.6033	134340400.0
2008-05-16 14:00:00	NVDA	Stock	0.6034	0.608	0.6018	0.6068	105664240.0
2008-05-16 15:00:00	NVDA	Stock	0.6068	0.6115	0.6065	0.6098	162102480.0
2008-05-16 16:00:00	NVDA	Stock	0.6098	0.6105	0.5595	0.6082	15637400.0
2008-05-16 17:00:00	NVDA	Stock	0.6093	0.6108	0.598	0.6098	9164360.0
2008-05-16 18:00:00	NVDA	Stock	0.6103	0.6103	0.6093	0.6103	36000.0
2008-05-16 19:00:00	NVDA	Stock	0.6103	0.6103	0.6088	0.6088	35720.0
2008-05-16 08:00:00	AMZN	Stock	3.8045	3.8045	3.8045	3.8045	2000.0
2008-05-16 09:00:00	AMZN	Stock	3.8	3.822	3.7575	3.778	23073160.0
2008-05-16 10:00:00	AMZN	Stock	3.778	3.788	3.747	3.755	20286380.0
2008-05-16 11:00:00	AMZN	Stock	3.7545	3.7755	3.743	3.7685	10589960.0
2008-05-16 12:00:00	AMZN	Stock	3.7685	3.792	3.7645	3.7785	7276740.0
2008-05-16 13:00:00	AMZN	Stock	3.7775	3.811	3.775	3.793	14277220.0
2008-05-16 14:00:00	AMZN	Stock	3.7905	3.816	3.7875	3.813	13236920.0
2008-05-16 15:00:00	AMZN	Stock	3.813	3.8415	3.8075	3.823	29256780.0
2008-05-16 16:00:00	AMZN	Stock	3.822	3.8375	3.741	3.825	5179360.0
2008-05-16 17:00:00	AMZN	Stock	3.776	3.825	3.776	3.825	53420.0
2008-05-16 08:00:00	TLT	Stock	91.76	91.76	91.6	91.6	200.0

> showing 50 of 40,703 rows — these rows as CSV

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