PREVIEW / stock_30min / 2007-09-26

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-09-26.parquet
  size:    1.2 MB
  rows:    67,672
  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:30: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:30: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.5282	719964.0
2007-09-26 07:30:00	AAPL	Stock	5.5339	5.5357	5.5179	5.5264	785260.0
2007-09-26 08:00:00	AAPL	Stock	5.5268	5.5536	5.5221	5.5289	8189552.0
2007-09-26 08:30:00	AAPL	Stock	5.5289	5.5393	5.5179	5.5311	4591132.0
2007-09-26 09:00:00	AAPL	Stock	5.5307	5.5357	5.5125	5.515	4892440.0
2007-09-26 09:30:00	AAPL	Stock	5.5175	5.5357	5.4507	5.46	199388364.0
2007-09-26 10:00:00	AAPL	Stock	5.46	5.48	5.455	5.4682	87955336.0
2007-09-26 10:30:00	AAPL	Stock	5.4682	5.4689	5.4018	5.4357	131590564.0
2007-09-26 11:00:00	AAPL	Stock	5.4357	5.4807	5.4325	5.4557	85506792.0
2007-09-26 11:30:00	AAPL	Stock	5.4556	5.4643	5.4489	5.4546	37344412.0
2007-09-26 12:00:00	AAPL	Stock	5.4543	5.4739	5.4543	5.4661	27265028.0
2007-09-26 12:30:00	AAPL	Stock	5.4661	5.4893	5.4643	5.4814	38757992.0
2007-09-26 13:00:00	AAPL	Stock	5.4814	5.4996	5.47	5.4796	45888668.0
2007-09-26 13:30:00	AAPL	Stock	5.48	5.4804	5.4257	5.4354	67306848.0
2007-09-26 14:00:00	AAPL	Stock	5.4346	5.4596	5.4346	5.4404	44723140.0
2007-09-26 14:30:00	AAPL	Stock	5.4407	5.4539	5.4254	5.4314	43441916.0
2007-09-26 15:00:00	AAPL	Stock	5.4318	5.4764	5.4318	5.4629	64493912.0
2007-09-26 15:30:00	AAPL	Stock	5.4629	5.4686	5.44	5.4543	61283068.0
2007-09-26 16:00:00	AAPL	Stock	5.4561	5.4721	5.4393	5.4479	10340820.0
2007-09-26 16:30:00	AAPL	Stock	5.4525	5.4721	5.4432	5.4496	5510932.0
2007-09-26 17:00:00	AAPL	Stock	5.4468	5.4561	5.4407	5.4561	2220316.0
2007-09-26 17:30:00	AAPL	Stock	5.4464	5.4561	5.4429	5.4429	2036272.0
2007-09-26 18:00:00	AAPL	Stock	5.4429	5.4561	5.4414	5.4414	179816.0
2007-09-26 18:30:00	AAPL	Stock	5.4446	5.4464	5.4393	5.4393	134120.0
2007-09-26 19:00:00	AAPL	Stock	5.4393	5.4393	5.4286	5.4286	318052.0
2007-09-26 19:30:00	AAPL	Stock	5.4286	5.4375	5.4286	5.4321	355012.0
2007-09-26 07:30: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.69	26556.0
2007-09-26 08:30:00	MSFT	Stock	29.7	29.75	29.68	29.73	18441.0
2007-09-26 09:00:00	MSFT	Stock	29.73	29.74	29.65	29.67	65636.0
2007-09-26 09:30:00	MSFT	Stock	29.67	29.7	29.56	29.62	4930867.0
2007-09-26 10:00:00	MSFT	Stock	29.61	29.8	29.61	29.78	3915292.0
2007-09-26 10:30:00	MSFT	Stock	29.78	29.83	29.61	29.67	5871508.0
2007-09-26 11:00:00	MSFT	Stock	29.66	29.83	29.61	29.809	6135651.0
2007-09-26 11:30:00	MSFT	Stock	29.81	29.85	29.75	29.79	3679209.0
2007-09-26 12:00:00	MSFT	Stock	29.8	29.82	29.76	29.81	2110827.0
2007-09-26 12:30:00	MSFT	Stock	29.81	29.83	29.67	29.679	2225634.0
2007-09-26 13:00:00	MSFT	Stock	29.68	29.71	29.61	29.61	2893859.0
2007-09-26 13:30:00	MSFT	Stock	29.61	29.62	29.48	29.5	4483104.0
2007-09-26 14:00:00	MSFT	Stock	29.51	29.6	29.5	29.55	3124906.0
2007-09-26 14:30:00	MSFT	Stock	29.55	29.56	29.5	29.52	2541887.0
2007-09-26 15:00:00	MSFT	Stock	29.52	29.57	29.495	29.54	4590815.0
2007-09-26 15:30:00	MSFT	Stock	29.55	29.61	29.49	29.49	7847827.0
2007-09-26 16:00:00	MSFT	Stock	29.5	29.651	29.48	29.5	2283304.0
2007-09-26 16:30:00	MSFT	Stock	29.5	29.81	29.5	29.51	3028851.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	1400.0

> showing 50 of 67,672 rows — these rows as CSV

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