PREVIEW / stock_5min / 2010-07-28

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-07-28.parquet
  size:    4.5 MB
  rows:    314,568
  symbols: 3,445

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-07-28 05:35:00	AAPL	Stock	9.4489	9.4489	9.4489	9.4489	2800.0
2010-07-28 07:00:00	AAPL	Stock	9.4071	9.4071	9.3993	9.3993	16800.0
2010-07-28 07:20:00	AAPL	Stock	9.4211	9.425	9.4211	9.425	21000.0
2010-07-28 07:35:00	AAPL	Stock	9.4246	9.4425	9.4246	9.4425	53004.0
2010-07-28 07:40:00	AAPL	Stock	9.4346	9.4425	9.4346	9.4425	22400.0
2010-07-28 07:45:00	AAPL	Stock	9.4393	9.4425	9.4368	9.4425	72800.0
2010-07-28 07:50:00	AAPL	Stock	9.4425	9.4464	9.4404	9.4404	46984.0
2010-07-28 07:55:00	AAPL	Stock	9.4461	9.4461	9.4411	9.4461	21000.0
2010-07-28 08:00:00	AAPL	Stock	9.4457	9.4536	9.4321	9.4375	844480.0
2010-07-28 08:05:00	AAPL	Stock	9.4318	9.4471	9.4304	9.4443	390796.0
2010-07-28 08:10:00	AAPL	Stock	9.4429	9.4471	9.4414	9.4446	74900.0
2010-07-28 08:15:00	AAPL	Stock	9.4443	9.4454	9.4371	9.4389	111384.0
2010-07-28 08:20:00	AAPL	Stock	9.4389	9.4411	9.4307	9.4411	233408.0
2010-07-28 08:25:00	AAPL	Stock	9.4411	9.4411	9.4296	9.4386	225764.0
2010-07-28 08:30:00	AAPL	Stock	9.4321	9.4321	9.4039	9.415	984676.0
2010-07-28 08:35:00	AAPL	Stock	9.4154	9.4182	9.4	9.4107	455560.0
2010-07-28 08:40:00	AAPL	Stock	9.4089	9.4157	9.4054	9.4054	151088.0
2010-07-28 08:45:00	AAPL	Stock	9.4061	9.4104	9.4011	9.4104	64960.0
2010-07-28 08:50:00	AAPL	Stock	9.4107	9.4282	9.4107	9.4236	197764.0
2010-07-28 08:55:00	AAPL	Stock	9.4236	9.4275	9.4214	9.425	195356.0
2010-07-28 09:00:00	AAPL	Stock	9.425	9.4261	9.4175	9.4175	174132.0
2010-07-28 09:05:00	AAPL	Stock	9.4182	9.4204	9.4107	9.4114	195804.0
2010-07-28 09:10:00	AAPL	Stock	9.4118	9.4171	9.4107	9.4171	230692.0
2010-07-28 09:15:00	AAPL	Stock	9.4179	9.4179	9.4089	9.4096	94304.0
2010-07-28 09:20:00	AAPL	Stock	9.4125	9.4129	9.4089	9.4125	70700.0
2010-07-28 09:25:00	AAPL	Stock	9.4107	9.4157	9.4089	9.4157	86660.0
2010-07-28 09:30:00	AAPL	Stock	9.4164	9.4439	9.4107	9.4211	13492864.0
2010-07-28 09:35:00	AAPL	Stock	9.4232	9.4779	9.4211	9.4696	26142536.0
2010-07-28 09:40:00	AAPL	Stock	9.47	9.4814	9.4571	9.4661	13771044.0
2010-07-28 09:45:00	AAPL	Stock	9.4668	9.4916	9.4668	9.4761	15011948.0
2010-07-28 09:50:00	AAPL	Stock	9.4771	9.4857	9.4464	9.4504	11573604.0
2010-07-28 09:55:00	AAPL	Stock	9.4514	9.4914	9.4479	9.4896	15325660.0
2010-07-28 10:00:00	AAPL	Stock	9.4889	9.4996	9.4732	9.4789	14130900.0
2010-07-28 10:05:00	AAPL	Stock	9.4782	9.4854	9.4507	9.4521	8876448.0
2010-07-28 10:10:00	AAPL	Stock	9.4525	9.4561	9.4314	9.4468	15373708.0
2010-07-28 10:15:00	AAPL	Stock	9.4464	9.4643	9.4421	9.455	7288960.0
2010-07-28 10:20:00	AAPL	Stock	9.4525	9.4544	9.4321	9.4329	8250900.0
2010-07-28 10:25:00	AAPL	Stock	9.4354	9.4493	9.4336	9.4486	5579840.0
2010-07-28 10:30:00	AAPL	Stock	9.4482	9.45	9.4139	9.4271	11019680.0
2010-07-28 10:35:00	AAPL	Stock	9.4271	9.4364	9.4164	9.4286	6511204.0
2010-07-28 10:40:00	AAPL	Stock	9.4282	9.4461	9.4282	9.4425	4464656.0
2010-07-28 10:45:00	AAPL	Stock	9.4421	9.4532	9.4304	9.4407	6025292.0
2010-07-28 10:50:00	AAPL	Stock	9.4412	9.4421	9.425	9.4304	4787412.0
2010-07-28 10:55:00	AAPL	Stock	9.4304	9.4379	9.425	9.4282	3403736.0
2010-07-28 11:00:00	AAPL	Stock	9.4265	9.435	9.415	9.4175	4324684.0
2010-07-28 11:05:00	AAPL	Stock	9.4171	9.4236	9.3982	9.4014	7948780.0
2010-07-28 11:10:00	AAPL	Stock	9.4032	9.4175	9.3989	9.4175	5909344.0
2010-07-28 11:15:00	AAPL	Stock	9.4153	9.4175	9.4018	9.4029	4332188.0
2010-07-28 11:20:00	AAPL	Stock	9.4036	9.4189	9.3996	9.4161	4215764.0
2010-07-28 11:25:00	AAPL	Stock	9.4161	9.4264	9.4132	9.4154	4169452.0

> showing 50 of 314,568 rows — these rows as CSV

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