PREVIEW / stock_1hour / 2007-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-26.parquet
  size:    789 KB
  rows:    39,539
  symbols: 3,127

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-09-26 04:00:00	AAPL	Stock	5.4854	5.4854	5.475	5.475	22400.0
2007-09-26 05:00:00	AAPL	Stock	5.4871	5.4879	5.4871	5.4879	14000.0
2007-09-26 06:00:00	AAPL	Stock	5.4918	5.4954	5.4918	5.4954	25200.0
2007-09-26 07:00:00	AAPL	Stock	5.5046	5.5368	5.5036	5.5264	1505224.0
2007-09-26 08:00:00	AAPL	Stock	5.5268	5.5536	5.5179	5.5311	12780684.0
2007-09-26 09:00:00	AAPL	Stock	5.5307	5.5357	5.4507	5.46	204280804.0
2007-09-26 10:00:00	AAPL	Stock	5.46	5.48	5.4018	5.4357	219545900.0
2007-09-26 11:00:00	AAPL	Stock	5.4357	5.4807	5.4325	5.4546	122851204.0
2007-09-26 12:00:00	AAPL	Stock	5.4543	5.4893	5.4543	5.4814	66023020.0
2007-09-26 13:00:00	AAPL	Stock	5.4814	5.4996	5.4257	5.4354	113195516.0
2007-09-26 14:00:00	AAPL	Stock	5.4346	5.4596	5.4254	5.4314	88165056.0
2007-09-26 15:00:00	AAPL	Stock	5.4318	5.4764	5.4318	5.4543	125776980.0
2007-09-26 16:00:00	AAPL	Stock	5.4561	5.4721	5.4393	5.4496	15851752.0
2007-09-26 17:00:00	AAPL	Stock	5.4468	5.4561	5.4407	5.4429	4256588.0
2007-09-26 18:00:00	AAPL	Stock	5.4429	5.4561	5.4393	5.4393	313936.0
2007-09-26 19:00:00	AAPL	Stock	5.4393	5.4393	5.4286	5.4321	673064.0
2007-09-26 07:00:00	MSFT	Stock	29.78	29.79	29.78	29.79	2382.0
2007-09-26 08:00:00	MSFT	Stock	29.72	29.88	29.68	29.73	44997.0
2007-09-26 09:00:00	MSFT	Stock	29.73	29.74	29.56	29.62	4996503.0
2007-09-26 10:00:00	MSFT	Stock	29.61	29.83	29.61	29.67	9786800.0
2007-09-26 11:00:00	MSFT	Stock	29.66	29.85	29.61	29.79	9814860.0
2007-09-26 12:00:00	MSFT	Stock	29.8	29.83	29.67	29.679	4336461.0
2007-09-26 13:00:00	MSFT	Stock	29.68	29.71	29.48	29.5	7376963.0
2007-09-26 14:00:00	MSFT	Stock	29.51	29.6	29.5	29.52	5666793.0
2007-09-26 15:00:00	MSFT	Stock	29.52	29.61	29.49	29.49	12438642.0
2007-09-26 16:00:00	MSFT	Stock	29.5	29.81	29.48	29.51	5312155.0
2007-09-26 17:00:00	MSFT	Stock	29.5	29.54	29.5	29.5	559728.0
2007-09-26 18:00:00	MSFT	Stock	29.55	29.55	29.55	29.55	5200.0
2007-09-26 19:00:00	MSFT	Stock	29.53	29.55	29.5	29.55	3464.0
2007-09-26 08:00:00	NVDA	Stock	0.8992	0.9113	0.8992	0.9075	686120.0
2007-09-26 09:00:00	NVDA	Stock	0.9075	0.9123	0.8978	0.9065	66131600.0
2007-09-26 10:00:00	NVDA	Stock	0.9065	0.9188	0.902	0.9043	84748680.0
2007-09-26 11:00:00	NVDA	Stock	0.9045	0.9113	0.904	0.9075	61903440.0
2007-09-26 12:00:00	NVDA	Stock	0.9075	0.9133	0.907	0.911	42518200.0
2007-09-26 13:00:00	NVDA	Stock	0.911	0.9148	0.9045	0.9045	68266720.0
2007-09-26 14:00:00	NVDA	Stock	0.9048	0.9138	0.9033	0.9128	67726760.0
2007-09-26 15:00:00	NVDA	Stock	0.9125	0.9188	0.912	0.9162	102892080.0
2007-09-26 16:00:00	NVDA	Stock	0.9162	0.9175	0.8963	0.9168	20645640.0
2007-09-26 17:00:00	NVDA	Stock	0.9168	0.9168	0.9168	0.9168	1799760.0
2007-09-26 18:00:00	NVDA	Stock	0.9195	0.9195	0.9175	0.9175	10800.0
2007-09-26 19:00:00	NVDA	Stock	0.9182	0.92	0.9148	0.92	135320.0
2007-09-26 05:00:00	AMZN	Stock	4.65	4.65	4.65	4.65	2000.0
2007-09-26 07:00:00	AMZN	Stock	4.675	4.6995	4.675	4.6975	44000.0
2007-09-26 08:00:00	AMZN	Stock	4.695	4.747	4.695	4.7355	1473720.0
2007-09-26 09:00:00	AMZN	Stock	4.736	4.7425	4.643	4.65	21580920.0
2007-09-26 10:00:00	AMZN	Stock	4.65	4.6725	4.6145	4.6622	23874340.0
2007-09-26 11:00:00	AMZN	Stock	4.6625	4.68	4.655	4.673	13452300.0
2007-09-26 12:00:00	AMZN	Stock	4.674	4.6945	4.6665	4.673	9402000.0
2007-09-26 13:00:00	AMZN	Stock	4.6738	4.682	4.6425	4.651	9850320.0
2007-09-26 14:00:00	AMZN	Stock	4.649	4.674	4.639	4.665	10415520.0

> showing 50 of 39,539 rows — these rows as CSV

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