PREVIEW / stock_5min / 2012-06-26

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-06-26.parquet
  size:    4.8 MB
  rows:    326,187
  symbols: 3,497

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-26 04:45:00	AAPL	Stock	20.4357	20.4357	20.4286	20.4286	30800.0
2012-06-26 05:05:00	AAPL	Stock	20.4304	20.4357	20.4286	20.4286	47600.0
2012-06-26 05:25:00	AAPL	Stock	20.4107	20.4107	20.4107	20.4107	14000.0
2012-06-26 05:35:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	19600.0
2012-06-26 05:45:00	AAPL	Stock	20.4411	20.4411	20.4411	20.4411	5600.0
2012-06-26 06:00:00	AAPL	Stock	20.4639	20.4639	20.4639	20.4639	2800.0
2012-06-26 06:35:00	AAPL	Stock	20.4536	20.4536	20.4536	20.4536	5600.0
2012-06-26 06:45:00	AAPL	Stock	20.4604	20.4604	20.4604	20.4604	2800.0
2012-06-26 07:00:00	AAPL	Stock	20.4468	20.4468	20.4468	20.4468	2800.0
2012-06-26 07:05:00	AAPL	Stock	20.4411	20.4429	20.4393	20.4429	30800.0
2012-06-26 07:10:00	AAPL	Stock	20.4464	20.4464	20.4375	20.4375	16800.0
2012-06-26 07:15:00	AAPL	Stock	20.4293	20.4293	20.4196	20.4196	16800.0
2012-06-26 07:20:00	AAPL	Stock	20.4107	20.4107	20.4107	20.4107	2800.0
2012-06-26 07:30:00	AAPL	Stock	20.4107	20.4204	20.4107	20.4196	8400.0
2012-06-26 07:35:00	AAPL	Stock	20.4071	20.4071	20.3929	20.3929	14000.0
2012-06-26 07:40:00	AAPL	Stock	20.3904	20.3929	20.3786	20.3825	18928.0
2012-06-26 07:45:00	AAPL	Stock	20.3886	20.3886	20.3704	20.375	19600.0
2012-06-26 07:50:00	AAPL	Stock	20.3679	20.3682	20.3661	20.3682	16800.0
2012-06-26 07:55:00	AAPL	Stock	20.39	20.39	20.39	20.39	2800.0
2012-06-26 08:00:00	AAPL	Stock	20.4014	20.4068	20.3893	20.4018	98364.0
2012-06-26 08:05:00	AAPL	Stock	20.4054	20.4054	20.3964	20.4	41944.0
2012-06-26 08:10:00	AAPL	Stock	20.3936	20.4125	20.3932	20.4018	102480.0
2012-06-26 08:15:00	AAPL	Stock	20.3989	20.3989	20.3875	20.3886	93856.0
2012-06-26 08:20:00	AAPL	Stock	20.3914	20.3929	20.3832	20.3832	105084.0
2012-06-26 08:25:00	AAPL	Stock	20.3886	20.3893	20.3821	20.385	34552.0
2012-06-26 08:30:00	AAPL	Stock	20.3846	20.3979	20.3846	20.3946	151620.0
2012-06-26 08:35:00	AAPL	Stock	20.3946	20.3946	20.3911	20.3929	39592.0
2012-06-26 08:40:00	AAPL	Stock	20.3929	20.4	20.3857	20.3893	55300.0
2012-06-26 08:45:00	AAPL	Stock	20.39	20.3929	20.3825	20.3929	49924.0
2012-06-26 08:50:00	AAPL	Stock	20.3961	20.3961	20.3961	20.3961	2800.0
2012-06-26 08:55:00	AAPL	Stock	20.3982	20.4	20.3932	20.3932	30800.0
2012-06-26 09:00:00	AAPL	Stock	20.3975	20.3975	20.3893	20.3893	64316.0
2012-06-26 09:05:00	AAPL	Stock	20.3975	20.4036	20.395	20.3996	77616.0
2012-06-26 09:10:00	AAPL	Stock	20.3968	20.3982	20.3896	20.3929	30240.0
2012-06-26 09:15:00	AAPL	Stock	20.3929	20.3982	20.3929	20.3982	43372.0
2012-06-26 09:20:00	AAPL	Stock	20.3982	20.4014	20.3929	20.4014	104832.0
2012-06-26 09:25:00	AAPL	Stock	20.4018	20.4257	20.3996	20.4054	210840.0
2012-06-26 09:30:00	AAPL	Stock	20.4111	20.4161	20.3146	20.3282	13272140.0
2012-06-26 09:35:00	AAPL	Stock	20.3296	20.4096	20.3214	20.3825	7212016.0
2012-06-26 09:40:00	AAPL	Stock	20.3814	20.4929	20.3814	20.4546	12593168.0
2012-06-26 09:45:00	AAPL	Stock	20.4536	20.4593	20.4243	20.4368	5052712.0
2012-06-26 09:50:00	AAPL	Stock	20.4368	20.4736	20.4286	20.4393	4646180.0
2012-06-26 09:55:00	AAPL	Stock	20.4389	20.4625	20.4304	20.4364	3105564.0
2012-06-26 10:00:00	AAPL	Stock	20.4359	20.4857	20.4115	20.4793	7145124.0
2012-06-26 10:05:00	AAPL	Stock	20.4839	20.5175	20.4711	20.5018	7061236.0
2012-06-26 10:10:00	AAPL	Stock	20.5	20.5018	20.4289	20.4354	6285160.0
2012-06-26 10:15:00	AAPL	Stock	20.4321	20.4436	20.4029	20.4121	5338844.0
2012-06-26 10:20:00	AAPL	Stock	20.4086	20.4279	20.3929	20.4018	3854620.0
2012-06-26 10:25:00	AAPL	Stock	20.3982	20.435	20.3979	20.4189	1849820.0
2012-06-26 10:30:00	AAPL	Stock	20.415	20.4257	20.3968	20.4139	2812796.0

> showing 50 of 326,187 rows — these rows as CSV

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