PREVIEW / stock_5min / 2011-03-10

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-03-10.parquet
  size:    5.1 MB
  rows:    347,136
  symbols: 3,519

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-03-10 04:00:00	AAPL	Stock	12.5354	12.5354	12.5354	12.5354	7000.0
2011-03-10 04:35:00	AAPL	Stock	12.5118	12.5154	12.5118	12.5154	11200.0
2011-03-10 04:40:00	AAPL	Stock	12.5154	12.5204	12.5154	12.5204	19600.0
2011-03-10 05:50:00	AAPL	Stock	12.4839	12.4839	12.4839	12.4839	5600.0
2011-03-10 05:55:00	AAPL	Stock	12.4839	12.4839	12.4839	12.4839	3192.0
2011-03-10 06:05:00	AAPL	Stock	12.515	12.515	12.515	12.515	2800.0
2011-03-10 06:10:00	AAPL	Stock	12.5154	12.5154	12.5154	12.5154	5600.0
2011-03-10 06:25:00	AAPL	Stock	12.5136	12.5136	12.4907	12.4907	27720.0
2011-03-10 07:00:00	AAPL	Stock	12.49	12.49	12.475	12.475	27636.0
2011-03-10 07:05:00	AAPL	Stock	12.475	12.4982	12.4714	12.4982	56000.0
2011-03-10 07:10:00	AAPL	Stock	12.5089	12.5089	12.5071	12.5071	40600.0
2011-03-10 07:15:00	AAPL	Stock	12.5071	12.5071	12.5071	12.5071	22400.0
2011-03-10 07:20:00	AAPL	Stock	12.5146	12.5193	12.5107	12.5107	10304.0
2011-03-10 07:25:00	AAPL	Stock	12.5071	12.5071	12.5071	12.5071	5936.0
2011-03-10 07:30:00	AAPL	Stock	12.5089	12.5089	12.5089	12.5089	5600.0
2011-03-10 07:35:00	AAPL	Stock	12.5071	12.5071	12.5	12.5	22064.0
2011-03-10 07:40:00	AAPL	Stock	12.5	12.5	12.4889	12.4911	111160.0
2011-03-10 07:45:00	AAPL	Stock	12.5	12.5018	12.5	12.5018	81200.0
2011-03-10 07:50:00	AAPL	Stock	12.5029	12.5029	12.4929	12.4996	20720.0
2011-03-10 07:55:00	AAPL	Stock	12.4982	12.4986	12.4964	12.4964	25200.0
2011-03-10 08:00:00	AAPL	Stock	12.5	12.5186	12.5	12.5125	636384.0
2011-03-10 08:05:00	AAPL	Stock	12.5114	12.5311	12.5114	12.5196	70896.0
2011-03-10 08:10:00	AAPL	Stock	12.5161	12.5179	12.5071	12.5071	54600.0
2011-03-10 08:15:00	AAPL	Stock	12.5071	12.515	12.5007	12.5071	90300.0
2011-03-10 08:20:00	AAPL	Stock	12.5054	12.5054	12.4893	12.4914	333956.0
2011-03-10 08:25:00	AAPL	Stock	12.4911	12.4939	12.4893	12.4939	131544.0
2011-03-10 08:30:00	AAPL	Stock	12.4886	12.5036	12.475	12.4979	600628.0
2011-03-10 08:35:00	AAPL	Stock	12.4993	12.5	12.4843	12.4843	252140.0
2011-03-10 08:40:00	AAPL	Stock	12.475	12.4779	12.4643	12.4779	586040.0
2011-03-10 08:45:00	AAPL	Stock	12.4718	12.4718	12.4546	12.4589	285964.0
2011-03-10 08:50:00	AAPL	Stock	12.4571	12.4571	12.4411	12.4536	673512.0
2011-03-10 08:55:00	AAPL	Stock	12.4536	12.4543	12.4471	12.4496	209216.0
2011-03-10 09:00:00	AAPL	Stock	12.4507	12.4507	12.4429	12.4471	533456.0
2011-03-10 09:05:00	AAPL	Stock	12.4457	12.4511	12.4432	12.445	116508.0
2011-03-10 09:10:00	AAPL	Stock	12.4436	12.4443	12.4286	12.4396	834064.0
2011-03-10 09:15:00	AAPL	Stock	12.4389	12.4571	12.4386	12.4414	379372.0
2011-03-10 09:20:00	AAPL	Stock	12.4414	12.4443	12.4346	12.4357	210588.0
2011-03-10 09:25:00	AAPL	Stock	12.4357	12.48	12.4286	12.48	1206072.0
2011-03-10 09:30:00	AAPL	Stock	12.4804	12.4957	12.3754	12.3929	29611876.0
2011-03-10 09:35:00	AAPL	Stock	12.3957	12.4168	12.3629	12.4121	14523712.0
2011-03-10 09:40:00	AAPL	Stock	12.4118	12.4143	12.3707	12.4052	10929856.0
2011-03-10 09:45:00	AAPL	Stock	12.3996	12.4125	12.3821	12.4017	9913260.0
2011-03-10 09:50:00	AAPL	Stock	12.4004	12.405	12.3832	12.4004	9494352.0
2011-03-10 09:55:00	AAPL	Stock	12.4021	12.4132	12.3929	12.3971	9077012.0
2011-03-10 10:00:00	AAPL	Stock	12.3969	12.4	12.3664	12.3739	8996876.0
2011-03-10 10:05:00	AAPL	Stock	12.3736	12.375	12.3179	12.3375	23212140.0
2011-03-10 10:10:00	AAPL	Stock	12.3371	12.3664	12.3329	12.3584	13179404.0
2011-03-10 10:15:00	AAPL	Stock	12.3575	12.3668	12.3486	12.3562	6147596.0
2011-03-10 10:20:00	AAPL	Stock	12.3546	12.3821	12.3536	12.3796	10163748.0
2011-03-10 10:25:00	AAPL	Stock	12.3802	12.3871	12.3664	12.3729	6868512.0

> showing 50 of 347,136 rows — these rows as CSV

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