PREVIEW / stock_1hour / 2010-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-05.parquet
  size:    917 KB
  rows:    43,408
  symbols: 3,491

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
2010-04-05 04:00:00	AAPL	Stock	8.5	8.5114	8.4107	8.5043	70000.0
2010-04-05 06:00:00	AAPL	Stock	8.4964	8.4996	8.4571	8.4571	159068.0
2010-04-05 07:00:00	AAPL	Stock	8.4504	8.475	8.3875	8.4696	1027124.0
2010-04-05 08:00:00	AAPL	Stock	8.4707	8.4936	8.3143	8.4357	27771520.0
2010-04-05 09:00:00	AAPL	Stock	8.4354	8.5089	8.3664	8.4418	190746808.0
2010-04-05 10:00:00	AAPL	Stock	8.4404	8.4821	8.4018	8.4693	136246208.0
2010-04-05 11:00:00	AAPL	Stock	8.4682	8.4854	8.4571	8.469	55570844.0
2010-04-05 12:00:00	AAPL	Stock	8.4689	8.5025	8.4625	8.4844	60283160.0
2010-04-05 13:00:00	AAPL	Stock	8.4846	8.4961	8.475	8.4786	41675200.0
2010-04-05 14:00:00	AAPL	Stock	8.4789	8.5071	8.4696	8.4957	58388148.0
2010-04-05 15:00:00	AAPL	Stock	8.4968	8.5179	8.4825	8.5179	99334956.0
2010-04-05 16:00:00	AAPL	Stock	8.5179	8.5268	8.4647	8.5268	7610876.0
2010-04-05 17:00:00	AAPL	Stock	8.5257	8.5393	8.4651	8.5336	852404.0
2010-04-05 18:00:00	AAPL	Stock	8.5332	8.5454	8.5	8.5079	1868328.0
2010-04-05 19:00:00	AAPL	Stock	8.5125	8.53	8.5064	8.53	872480.0
2010-04-05 07:00:00	MSFT	Stock	29.19	29.27	29.19	29.26	1400.0
2010-04-05 08:00:00	MSFT	Stock	29.24	29.26	29.1	29.13	19818.0
2010-04-05 09:00:00	MSFT	Stock	29.13	29.35	29.03	29.23	5510126.0
2010-04-05 10:00:00	MSFT	Stock	29.23	29.425	29.2	29.34	5579221.0
2010-04-05 11:00:00	MSFT	Stock	29.34	29.38	29.28	29.34	3524705.0
2010-04-05 12:00:00	MSFT	Stock	29.34	29.37	29.26	29.29	2332906.0
2010-04-05 13:00:00	MSFT	Stock	29.288	29.315	29.17	29.245	3785421.0
2010-04-05 14:00:00	MSFT	Stock	29.25	29.34	29.23	29.3	3277508.0
2010-04-05 15:00:00	MSFT	Stock	29.305	29.32	29.23	29.28	7599927.0
2010-04-05 16:00:00	MSFT	Stock	29.27	30.0	29.0	29.24	2113584.0
2010-04-05 17:00:00	MSFT	Stock	29.24	29.3	29.24	29.29	6500.0
2010-04-05 18:00:00	MSFT	Stock	29.29	29.3	29.27	29.3	3973.0
2010-04-05 19:00:00	MSFT	Stock	29.3	29.3	29.28	29.28	5564.0
2010-04-05 08:00:00	NVDA	Stock	0.4362	0.4362	0.4362	0.4362	8000.0
2010-04-05 09:00:00	NVDA	Stock	0.4368	0.437	0.4328	0.434	64908360.0
2010-04-05 10:00:00	NVDA	Stock	0.434	0.4364	0.433	0.4355	52003720.0
2010-04-05 11:00:00	NVDA	Stock	0.4352	0.4362	0.4345	0.436	36711440.0
2010-04-05 12:00:00	NVDA	Stock	0.4362	0.437	0.4356	0.4365	36661320.0
2010-04-05 13:00:00	NVDA	Stock	0.4366	0.4375	0.4362	0.4366	23401960.0
2010-04-05 14:00:00	NVDA	Stock	0.4365	0.4375	0.4355	0.4369	36912480.0
2010-04-05 15:00:00	NVDA	Stock	0.4368	0.4378	0.4365	0.4372	59113880.0
2010-04-05 16:00:00	NVDA	Stock	0.437	0.439	0.4358	0.439	55463920.0
2010-04-05 17:00:00	NVDA	Stock	0.4382	0.4382	0.4382	0.4382	40000.0
2010-04-05 07:00:00	AMZN	Stock	6.65	6.65	6.65	6.65	2000.0
2010-04-05 08:00:00	AMZN	Stock	6.6315	6.6735	6.605	6.65	718320.0
2010-04-05 09:00:00	AMZN	Stock	6.645	6.658	6.539	6.588	22253100.0
2010-04-05 10:00:00	AMZN	Stock	6.588	6.687	6.584	6.6285	22353500.0
2010-04-05 11:00:00	AMZN	Stock	6.629	6.6575	6.6	6.6145	9878020.0
2010-04-05 12:00:00	AMZN	Stock	6.6125	6.631	6.5895	6.5905	8359740.0
2010-04-05 13:00:00	AMZN	Stock	6.5905	6.603	6.566	6.5765	12134460.0
2010-04-05 14:00:00	AMZN	Stock	6.5752	6.5895	6.565	6.573	11018860.0
2010-04-05 15:00:00	AMZN	Stock	6.573	6.5805	6.5585	6.571	17149980.0
2010-04-05 16:00:00	AMZN	Stock	6.5695	6.6215	6.564	6.582	1627540.0
2010-04-05 17:00:00	AMZN	Stock	6.5978	6.5978	6.5825	6.584	16200.0
2010-04-05 18:00:00	AMZN	Stock	6.584	6.589	6.584	6.5875	15800.0

> showing 50 of 43,408 rows — these rows as CSV

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