PREVIEW / stock_1hour / 2007-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-11.parquet
  size:    772 KB
  rows:    38,213
  symbols: 3,077

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
2007-07-11 09:00:00	AAPL	Stock	4.7168	4.7407	4.6896	4.7189	141604624.0
2007-07-11 10:00:00	AAPL	Stock	4.7193	4.7704	4.7075	4.76	166686380.0
2007-07-11 11:00:00	AAPL	Stock	4.76	4.775	4.7518	4.7543	108440584.0
2007-07-11 12:00:00	AAPL	Stock	4.7543	4.7671	4.7332	4.7411	77809704.0
2007-07-11 13:00:00	AAPL	Stock	4.7411	4.7543	4.7289	4.7314	78027768.0
2007-07-11 14:00:00	AAPL	Stock	4.7314	4.7389	4.6986	4.7061	107054864.0
2007-07-11 15:00:00	AAPL	Stock	4.7061	4.7304	4.7036	4.7246	104025516.0
2007-07-11 16:00:00	AAPL	Stock	4.7246	4.7282	4.7246	4.7282	11141480.0
2007-07-11 09:00:00	MSFT	Stock	29.24	29.49	29.21	29.43	5317988.0
2007-07-11 10:00:00	MSFT	Stock	29.44	29.55	29.39	29.54	8239814.0
2007-07-11 11:00:00	MSFT	Stock	29.54	29.65	29.447	29.5	5473935.0
2007-07-11 12:00:00	MSFT	Stock	29.5	29.56	29.48	29.51	3463266.0
2007-07-11 13:00:00	MSFT	Stock	29.51	29.64	29.51	29.58	3349522.0
2007-07-11 14:00:00	MSFT	Stock	29.57	29.63	29.44	29.481	4924616.0
2007-07-11 15:00:00	MSFT	Stock	29.48	29.59	29.44	29.5	8279526.0
2007-07-11 16:00:00	MSFT	Stock	29.49	29.5	29.49	29.49	1685680.0
2007-07-11 09:00:00	NVDA	Stock	0.7582	0.763	0.748	0.7483	51547020.0
2007-07-11 10:00:00	NVDA	Stock	0.7482	0.7538	0.7463	0.7467	128733660.0
2007-07-11 11:00:00	NVDA	Stock	0.7467	0.7503	0.7442	0.7482	70079820.0
2007-07-11 12:00:00	NVDA	Stock	0.7482	0.7515	0.7477	0.7508	53185200.0
2007-07-11 13:00:00	NVDA	Stock	0.7508	0.7547	0.7498	0.7518	53836200.0
2007-07-11 14:00:00	NVDA	Stock	0.7518	0.7558	0.7492	0.751	121928100.0
2007-07-11 15:00:00	NVDA	Stock	0.751	0.7547	0.7508	0.7538	73378140.0
2007-07-11 16:00:00	NVDA	Stock	0.7545	0.7567	0.7542	0.755	15266880.0
2007-07-11 17:00:00	NVDA	Stock	0.755	0.755	0.7548	0.7548	66000.0
2007-07-11 07:00:00	AMZN	Stock	3.513	3.513	3.513	3.513	39060.0
2007-07-11 08:00:00	AMZN	Stock	3.5145	3.5155	3.5125	3.515	86000.0
2007-07-11 09:00:00	AMZN	Stock	3.515	3.5825	3.5125	3.535	28731340.0
2007-07-11 10:00:00	AMZN	Stock	3.5345	3.555	3.5145	3.5276	28761700.0
2007-07-11 11:00:00	AMZN	Stock	3.528	3.5385	3.5145	3.526	15466320.0
2007-07-11 12:00:00	AMZN	Stock	3.526	3.533	3.5095	3.5135	10238320.0
2007-07-11 13:00:00	AMZN	Stock	3.513	3.5425	3.5075	3.5235	10810160.0
2007-07-11 14:00:00	AMZN	Stock	3.523	3.5345	3.5175	3.5175	9263920.0
2007-07-11 15:00:00	AMZN	Stock	3.517	3.544	3.517	3.5365	22235700.0
2007-07-11 16:00:00	AMZN	Stock	3.538	3.548	3.5365	3.5415	4919500.0
2007-07-11 17:00:00	AMZN	Stock	3.5365	3.543	3.5311	3.543	251800.0
2007-07-11 18:00:00	AMZN	Stock	3.539	3.543	3.539	3.539	6000.0
2007-07-11 09:00:00	TLT	Stock	84.95	85.09	84.76	84.97	135100.0
2007-07-11 10:00:00	TLT	Stock	85.0	85.02	84.82	84.86	89800.0
2007-07-11 11:00:00	TLT	Stock	84.84	84.89	84.48	84.57	88800.0
2007-07-11 12:00:00	TLT	Stock	84.55	84.65	84.46	84.58	132500.0
2007-07-11 13:00:00	TLT	Stock	84.56	84.58	84.32	84.42	224800.0
2007-07-11 14:00:00	TLT	Stock	84.43	84.53	84.35	84.5	184200.0
2007-07-11 15:00:00	TLT	Stock	84.5	84.51	84.37	84.4	278100.0
2007-07-11 16:00:00	TLT	Stock	84.4	84.49	84.32	84.32	22700.0
2007-07-11 09:00:00	CL	Stock	32.75	32.995	32.75	32.86	329400.0
2007-07-11 10:00:00	CL	Stock	32.86	33.24	32.79	33.19	576600.0
2007-07-11 11:00:00	CL	Stock	33.19	33.3	33.135	33.27	542200.0
2007-07-11 12:00:00	CL	Stock	33.27	33.355	33.25	33.335	709800.0
2007-07-11 13:00:00	CL	Stock	33.34	33.495	33.31	33.38	623800.0

> showing 50 of 38,213 rows — these rows as CSV

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