PREVIEW / stock_5min / 2012-06-28

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-06-28.parquet
  size:    4.7 MB
  rows:    321,641
  symbols: 3,506

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
2012-06-28 04:00:00	AAPL	Stock	20.4643	20.4643	20.4643	20.4643	28000.0
2012-06-28 04:15:00	AAPL	Stock	20.4021	20.4021	20.4021	20.4021	4200.0
2012-06-28 07:00:00	AAPL	Stock	20.4443	20.4521	20.4443	20.4443	42000.0
2012-06-28 07:05:00	AAPL	Stock	20.4518	20.4518	20.45	20.45	5600.0
2012-06-28 07:10:00	AAPL	Stock	20.4464	20.4464	20.4464	20.4464	3080.0
2012-06-28 07:20:00	AAPL	Stock	20.4939	20.5	20.4939	20.5	56000.0
2012-06-28 07:25:00	AAPL	Stock	20.4839	20.4843	20.4821	20.4821	8400.0
2012-06-28 07:35:00	AAPL	Stock	20.4654	20.4654	20.4654	20.4654	2800.0
2012-06-28 07:45:00	AAPL	Stock	20.465	20.465	20.4557	20.4618	14000.0
2012-06-28 07:50:00	AAPL	Stock	20.455	20.455	20.45	20.45	58800.0
2012-06-28 07:55:00	AAPL	Stock	20.4339	20.4339	20.4286	20.4286	11200.0
2012-06-28 08:00:00	AAPL	Stock	20.4596	20.4643	20.4279	20.4279	148512.0
2012-06-28 08:05:00	AAPL	Stock	20.4321	20.4354	20.4286	20.4339	50120.0
2012-06-28 08:10:00	AAPL	Stock	20.4464	20.4471	20.4107	20.4107	97020.0
2012-06-28 08:15:00	AAPL	Stock	20.415	20.4164	20.415	20.4164	16800.0
2012-06-28 08:20:00	AAPL	Stock	20.4268	20.4268	20.4229	20.4229	5600.0
2012-06-28 08:25:00	AAPL	Stock	20.4279	20.4293	20.4279	20.4293	5600.0
2012-06-28 08:30:00	AAPL	Stock	20.4286	20.45	20.4286	20.4464	46340.0
2012-06-28 08:35:00	AAPL	Stock	20.4461	20.4464	20.4286	20.4286	95200.0
2012-06-28 08:45:00	AAPL	Stock	20.4257	20.4321	20.4257	20.4321	25200.0
2012-06-28 08:50:00	AAPL	Stock	20.4304	20.4307	20.4218	20.4218	42840.0
2012-06-28 08:55:00	AAPL	Stock	20.42	20.4229	20.42	20.4207	24164.0
2012-06-28 09:00:00	AAPL	Stock	20.4239	20.4239	20.4179	20.4232	131628.0
2012-06-28 09:05:00	AAPL	Stock	20.4196	20.425	20.4196	20.4196	52052.0
2012-06-28 09:10:00	AAPL	Stock	20.4214	20.4286	20.4139	20.4182	39760.0
2012-06-28 09:15:00	AAPL	Stock	20.4218	20.4286	20.4179	20.4286	43540.0
2012-06-28 09:20:00	AAPL	Stock	20.4207	20.4282	20.4104	20.4182	86268.0
2012-06-28 09:25:00	AAPL	Stock	20.4179	20.4264	20.4118	20.4229	143864.0
2012-06-28 09:30:00	AAPL	Stock	20.4168	20.5	20.3946	20.4204	11960956.0
2012-06-28 09:35:00	AAPL	Stock	20.4236	20.4414	20.3786	20.4114	7222460.0
2012-06-28 09:40:00	AAPL	Stock	20.4105	20.4464	20.4	20.4318	3844596.0
2012-06-28 09:45:00	AAPL	Stock	20.43	20.4554	20.4236	20.4326	3174388.0
2012-06-28 09:50:00	AAPL	Stock	20.4314	20.4624	20.4214	20.4421	3040072.0
2012-06-28 09:55:00	AAPL	Stock	20.4382	20.4543	20.4232	20.4368	3894940.0
2012-06-28 10:00:00	AAPL	Stock	20.4393	20.4561	20.425	20.4464	2663444.0
2012-06-28 10:05:00	AAPL	Stock	20.4431	20.4489	20.4018	20.4389	5129292.0
2012-06-28 10:10:00	AAPL	Stock	20.4393	20.4425	20.4029	20.4043	4069016.0
2012-06-28 10:15:00	AAPL	Stock	20.4057	20.4357	20.3929	20.4254	3763032.0
2012-06-28 10:20:00	AAPL	Stock	20.4346	20.4543	20.4232	20.4296	2183860.0
2012-06-28 10:25:00	AAPL	Stock	20.4293	20.4304	20.3861	20.3928	4236540.0
2012-06-28 10:30:00	AAPL	Stock	20.3893	20.3911	20.3582	20.3696	5432644.0
2012-06-28 10:35:00	AAPL	Stock	20.3718	20.3725	20.3139	20.3207	9290372.0
2012-06-28 10:40:00	AAPL	Stock	20.3171	20.3511	20.3093	20.3379	4978540.0
2012-06-28 10:45:00	AAPL	Stock	20.3414	20.3511	20.3254	20.3371	2871708.0
2012-06-28 10:50:00	AAPL	Stock	20.3368	20.3543	20.3236	20.3271	2779056.0
2012-06-28 10:55:00	AAPL	Stock	20.3264	20.3529	20.3214	20.35	2336432.0
2012-06-28 11:00:00	AAPL	Stock	20.3521	20.3521	20.3143	20.3266	3331664.0
2012-06-28 11:05:00	AAPL	Stock	20.3289	20.3479	20.3221	20.3412	2113888.0
2012-06-28 11:10:00	AAPL	Stock	20.3352	20.3386	20.3096	20.3181	4067308.0
2012-06-28 11:15:00	AAPL	Stock	20.3161	20.3329	20.3046	20.3182	3690764.0

> showing 50 of 321,641 rows — these rows as CSV

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