PREVIEW / stock_5min / 2011-06-23

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-06-23.parquet
  size:    5.0 MB
  rows:    340,244
  symbols: 3,533

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
2011-06-23 04:05:00	AAPL	Stock	11.4846	11.4846	11.4846	11.4846	2800.0
2011-06-23 06:00:00	AAPL	Stock	11.4654	11.4654	11.4654	11.4654	2800.0
2011-06-23 06:25:00	AAPL	Stock	11.4554	11.4554	11.4554	11.4554	14000.0
2011-06-23 06:35:00	AAPL	Stock	11.4543	11.4543	11.4543	11.4543	14000.0
2011-06-23 06:45:00	AAPL	Stock	11.4421	11.4421	11.4421	11.4421	2940.0
2011-06-23 06:55:00	AAPL	Stock	11.4421	11.4421	11.4421	11.4421	9324.0
2011-06-23 07:00:00	AAPL	Stock	11.4461	11.4714	11.4386	11.4518	91112.0
2011-06-23 07:05:00	AAPL	Stock	11.4518	11.4518	11.4518	11.4518	8400.0
2011-06-23 07:15:00	AAPL	Stock	11.4643	11.4821	11.4571	11.4714	28000.0
2011-06-23 07:20:00	AAPL	Stock	11.4679	11.4679	11.4643	11.4643	5600.0
2011-06-23 07:25:00	AAPL	Stock	11.4643	11.4643	11.4643	11.4643	2800.0
2011-06-23 07:35:00	AAPL	Stock	11.4536	11.4554	11.4429	11.4429	112000.0
2011-06-23 07:40:00	AAPL	Stock	11.4482	11.45	11.4404	11.4429	47600.0
2011-06-23 07:45:00	AAPL	Stock	11.4429	11.4604	11.4429	11.4482	22036.0
2011-06-23 07:55:00	AAPL	Stock	11.4571	11.4643	11.4568	11.4596	42000.0
2011-06-23 08:00:00	AAPL	Stock	11.4643	11.4643	11.4361	11.4361	147504.0
2011-06-23 08:05:00	AAPL	Stock	11.4411	11.4425	11.4379	11.4411	39480.0
2011-06-23 08:10:00	AAPL	Stock	11.4464	11.4464	11.4357	11.4357	63028.0
2011-06-23 08:15:00	AAPL	Stock	11.4375	11.4382	11.4311	11.4382	33684.0
2011-06-23 08:20:00	AAPL	Stock	11.4307	11.4343	11.4239	11.4239	219492.0
2011-06-23 08:25:00	AAPL	Stock	11.4225	11.4286	11.4146	11.4146	540232.0
2011-06-23 08:30:00	AAPL	Stock	11.4064	11.4186	11.3929	11.3929	511840.0
2011-06-23 08:35:00	AAPL	Stock	11.3929	11.4054	11.3714	11.3761	471912.0
2011-06-23 08:40:00	AAPL	Stock	11.3764	11.3786	11.3618	11.3711	307188.0
2011-06-23 08:45:00	AAPL	Stock	11.375	11.3811	11.3714	11.3811	318584.0
2011-06-23 08:50:00	AAPL	Stock	11.3804	11.3821	11.3571	11.375	302652.0
2011-06-23 08:55:00	AAPL	Stock	11.375	11.3839	11.3679	11.3818	234052.0
2011-06-23 09:00:00	AAPL	Stock	11.3818	11.3818	11.3625	11.3625	184520.0
2011-06-23 09:05:00	AAPL	Stock	11.3682	11.3821	11.3636	11.3668	406028.0
2011-06-23 09:10:00	AAPL	Stock	11.375	11.3911	11.3746	11.3846	242536.0
2011-06-23 09:15:00	AAPL	Stock	11.3846	11.3854	11.3643	11.3696	246120.0
2011-06-23 09:20:00	AAPL	Stock	11.3743	11.3882	11.3743	11.3857	166740.0
2011-06-23 09:25:00	AAPL	Stock	11.3839	11.3914	11.3839	11.3907	242060.0
2011-06-23 09:30:00	AAPL	Stock	11.3918	11.4432	11.3614	11.4334	20508180.0
2011-06-23 09:35:00	AAPL	Stock	11.4332	11.4914	11.4164	11.4823	14149128.0
2011-06-23 09:40:00	AAPL	Stock	11.4836	11.4836	11.4132	11.4336	11367160.0
2011-06-23 09:45:00	AAPL	Stock	11.4339	11.4707	11.4307	11.4704	7287784.0
2011-06-23 09:50:00	AAPL	Stock	11.4693	11.4893	11.4407	11.4546	10175004.0
2011-06-23 09:55:00	AAPL	Stock	11.4564	11.4911	11.455	11.48	8669276.0
2011-06-23 10:00:00	AAPL	Stock	11.48	11.5204	11.4643	11.5186	11902240.0
2011-06-23 10:05:00	AAPL	Stock	11.5171	11.5518	11.5086	11.5446	13202784.0
2011-06-23 10:10:00	AAPL	Stock	11.5461	11.6057	11.5325	11.57	18464600.0
2011-06-23 10:15:00	AAPL	Stock	11.5704	11.5989	11.5629	11.5946	9643256.0
2011-06-23 10:20:00	AAPL	Stock	11.5964	11.5996	11.545	11.555	8929956.0
2011-06-23 10:25:00	AAPL	Stock	11.5532	11.5704	11.5414	11.5686	7686560.0
2011-06-23 10:30:00	AAPL	Stock	11.5654	11.5893	11.5357	11.5357	7156380.0
2011-06-23 10:35:00	AAPL	Stock	11.5357	11.5357	11.4946	11.5166	10742620.0
2011-06-23 10:40:00	AAPL	Stock	11.5161	11.5289	11.5089	11.5207	4177964.0
2011-06-23 10:45:00	AAPL	Stock	11.5225	11.5275	11.4821	11.4879	6772836.0
2011-06-23 10:50:00	AAPL	Stock	11.4886	11.5204	11.4829	11.5136	5091520.0

> showing 50 of 340,244 rows — these rows as CSV

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