PREVIEW / stock_1hour / 2007-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-29.parquet
  size:    764 KB
  rows:    37,506
  symbols: 3,066

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-06-29 09:00:00	AAPL	Stock	4.3561	4.3907	4.3321	4.37	151233544.0
2007-06-29 10:00:00	AAPL	Stock	4.3696	4.3771	4.3479	4.3736	136917984.0
2007-06-29 11:00:00	AAPL	Stock	4.3739	4.4286	4.3629	4.4057	209436220.0
2007-06-29 12:00:00	AAPL	Stock	4.4061	4.4189	4.3671	4.392	135622564.0
2007-06-29 13:00:00	AAPL	Stock	4.3921	4.4196	4.3696	4.4121	95470928.0
2007-06-29 14:00:00	AAPL	Stock	4.4121	4.4121	4.3789	4.3807	125518988.0
2007-06-29 15:00:00	AAPL	Stock	4.3807	4.3857	4.3246	4.3596	227726660.0
2007-06-29 16:00:00	AAPL	Stock	4.36	4.36	4.3586	4.3586	14222320.0
2007-06-29 09:00:00	MSFT	Stock	29.87	29.93	29.85	29.87	3899222.0
2007-06-29 10:00:00	MSFT	Stock	29.86	29.912	29.77	29.81	6045058.0
2007-06-29 11:00:00	MSFT	Stock	29.81	29.82	29.55	29.56	6649755.0
2007-06-29 12:00:00	MSFT	Stock	29.57	29.58	29.49	29.51	4593976.0
2007-06-29 13:00:00	MSFT	Stock	29.51	29.59	29.46	29.51	6267790.0
2007-06-29 14:00:00	MSFT	Stock	29.5	29.51	29.29	29.32	9293159.0
2007-06-29 15:00:00	MSFT	Stock	29.315	29.48	29.04	29.47	22028701.0
2007-06-29 16:00:00	MSFT	Stock	29.47	29.47	29.47	29.47	3967666.0
2007-06-29 09:00:00	NVDA	Stock	0.7053	0.7053	0.6938	0.6972	44870460.0
2007-06-29 10:00:00	NVDA	Stock	0.697	0.6983	0.691	0.6975	63780660.0
2007-06-29 11:00:00	NVDA	Stock	0.6973	0.6988	0.6935	0.6943	70045140.0
2007-06-29 12:00:00	NVDA	Stock	0.6943	0.6973	0.6917	0.6967	67259220.0
2007-06-29 13:00:00	NVDA	Stock	0.6968	0.6983	0.6948	0.6975	35442600.0
2007-06-29 14:00:00	NVDA	Stock	0.6975	0.6978	0.6938	0.6957	37052100.0
2007-06-29 15:00:00	NVDA	Stock	0.6957	0.6965	0.6882	0.6883	160650300.0
2007-06-29 16:00:00	NVDA	Stock	0.6887	0.689	0.6877	0.6888	23604000.0
2007-06-29 17:00:00	NVDA	Stock	0.69	0.69	0.69	0.69	15000.0
2007-06-29 18:00:00	NVDA	Stock	0.69	0.69	0.6892	0.6892	240000.0
2007-06-29 19:00:00	NVDA	Stock	0.6892	0.6892	0.6873	0.6892	147540.0
2007-06-29 08:00:00	AMZN	Stock	3.4495	3.4495	3.4355	3.436	18040.0
2007-06-29 09:00:00	AMZN	Stock	3.4445	3.4595	3.426	3.4305	13563760.0
2007-06-29 10:00:00	AMZN	Stock	3.4305	3.443	3.427	3.433	12077280.0
2007-06-29 11:00:00	AMZN	Stock	3.4335	3.4435	3.426	3.4285	11300300.0
2007-06-29 12:00:00	AMZN	Stock	3.429	3.442	3.42	3.4265	12359320.0
2007-06-29 13:00:00	AMZN	Stock	3.4265	3.44	3.423	3.4345	7453140.0
2007-06-29 14:00:00	AMZN	Stock	3.435	3.438	3.423	3.4375	13684240.0
2007-06-29 15:00:00	AMZN	Stock	3.4375	3.4405	3.4075	3.4205	29974140.0
2007-06-29 16:00:00	AMZN	Stock	3.4205	3.4245	3.4205	3.4225	2985620.0
2007-06-29 17:00:00	AMZN	Stock	3.421	3.4225	3.4205	3.4225	33400.0
2007-06-29 18:00:00	AMZN	Stock	3.4225	3.4225	3.4225	3.4225	7500.0
2007-06-29 09:00:00	TLT	Stock	84.85	85.05	84.8	84.93	531900.0
2007-06-29 10:00:00	TLT	Stock	84.92	84.92	84.64	84.68	194700.0
2007-06-29 11:00:00	TLT	Stock	84.68	84.87	84.68	84.85	209200.0
2007-06-29 12:00:00	TLT	Stock	84.87	84.93	84.83	84.91	122100.0
2007-06-29 13:00:00	TLT	Stock	84.91	85.01	84.87	84.9	114400.0
2007-06-29 14:00:00	TLT	Stock	84.9	85.19	84.9	85.19	285100.0
2007-06-29 15:00:00	TLT	Stock	85.18	85.3	85.14	85.15	418604.0
2007-06-29 16:00:00	TLT	Stock	85.14	85.23	85.14	85.17	16300.0
2007-06-29 09:00:00	CL	Stock	32.685	32.75	32.485	32.73	399400.0
2007-06-29 10:00:00	CL	Stock	32.735	32.885	32.725	32.755	509000.0
2007-06-29 11:00:00	CL	Stock	32.76	32.77	32.575	32.59	583800.0
2007-06-29 12:00:00	CL	Stock	32.585	32.605	32.45	32.495	479600.0

> showing 50 of 37,506 rows — these rows as CSV

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