PREVIEW / stock_1min / 2013-07-18

all stock 1-min files

  file:    by_date/stock_1min/2013/2013-07-18.parquet
  size:    13.3 MB
  rows:    970,221
  symbols: 2,821

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
2013-07-18 08:00:00	AAPL	Stock	15.375	15.375	15.375	15.375	5040.0
2013-07-18 08:01:00	AAPL	Stock	15.3214	15.3214	15.3214	15.3214	14000.0
2013-07-18 08:04:00	AAPL	Stock	15.3636	15.3646	15.3636	15.3646	5600.0
2013-07-18 08:08:00	AAPL	Stock	15.3632	15.3632	15.3632	15.3632	2800.0
2013-07-18 08:09:00	AAPL	Stock	15.3586	15.3586	15.3579	15.3579	5600.0
2013-07-18 08:12:00	AAPL	Stock	15.3621	15.3621	15.3614	15.3614	5600.0
2013-07-18 08:13:00	AAPL	Stock	15.3725	15.3725	15.3725	15.3725	2800.0
2013-07-18 08:15:00	AAPL	Stock	15.375	15.375	15.375	15.375	7980.0
2013-07-18 08:16:00	AAPL	Stock	15.375	15.375	15.375	15.375	11312.0
2013-07-18 08:17:00	AAPL	Stock	15.3768	15.3768	15.3768	15.3768	5600.0
2013-07-18 08:18:00	AAPL	Stock	15.375	15.375	15.375	15.375	6216.0
2013-07-18 08:22:00	AAPL	Stock	15.375	15.3839	15.375	15.3839	33488.0
2013-07-18 08:23:00	AAPL	Stock	15.3893	15.3929	15.3893	15.3921	29120.0
2013-07-18 08:24:00	AAPL	Stock	15.3929	15.3946	15.3768	15.3875	77476.0
2013-07-18 08:25:00	AAPL	Stock	15.3821	15.3821	15.3746	15.3779	85764.0
2013-07-18 08:29:00	AAPL	Stock	15.3775	15.3775	15.3754	15.3775	13944.0
2013-07-18 08:32:00	AAPL	Stock	15.3818	15.3864	15.3818	15.3864	22400.0
2013-07-18 08:34:00	AAPL	Stock	15.3914	15.3929	15.3914	15.3929	49840.0
2013-07-18 08:35:00	AAPL	Stock	15.4032	15.4057	15.4032	15.4057	27972.0
2013-07-18 08:36:00	AAPL	Stock	15.4043	15.4057	15.4043	15.4057	14000.0
2013-07-18 08:37:00	AAPL	Stock	15.4046	15.4193	15.4046	15.4193	82264.0
2013-07-18 08:39:00	AAPL	Stock	15.4114	15.4114	15.4093	15.4093	16800.0
2013-07-18 08:40:00	AAPL	Stock	15.4157	15.4168	15.4107	15.4168	19600.0
2013-07-18 08:42:00	AAPL	Stock	15.4179	15.4286	15.4139	15.4286	153832.0
2013-07-18 08:43:00	AAPL	Stock	15.4239	15.4339	15.4239	15.4339	145796.0
2013-07-18 08:44:00	AAPL	Stock	15.43	15.4464	15.4286	15.4307	172788.0
2013-07-18 08:45:00	AAPL	Stock	15.4361	15.4364	15.4361	15.4364	8400.0
2013-07-18 08:46:00	AAPL	Stock	15.4361	15.4446	15.4357	15.4432	66920.0
2013-07-18 08:47:00	AAPL	Stock	15.4421	15.4543	15.4421	15.4536	117376.0
2013-07-18 08:48:00	AAPL	Stock	15.4482	15.4714	15.4482	15.4707	234248.0
2013-07-18 08:49:00	AAPL	Stock	15.4714	15.4821	15.4671	15.4804	100072.0
2013-07-18 08:50:00	AAPL	Stock	15.4739	15.4743	15.4679	15.4679	56280.0
2013-07-18 08:51:00	AAPL	Stock	15.4693	15.4796	15.4693	15.4754	36400.0
2013-07-18 08:52:00	AAPL	Stock	15.4704	15.4914	15.4704	15.4914	229908.0
2013-07-18 08:53:00	AAPL	Stock	15.4911	15.4914	15.4821	15.4821	62104.0
2013-07-18 08:54:00	AAPL	Stock	15.4768	15.4839	15.4732	15.4839	61600.0
2013-07-18 08:55:00	AAPL	Stock	15.48	15.4821	15.48	15.48	15260.0
2013-07-18 08:56:00	AAPL	Stock	15.4821	15.4911	15.4821	15.4911	62132.0
2013-07-18 08:57:00	AAPL	Stock	15.4886	15.4904	15.4832	15.4832	35700.0
2013-07-18 08:58:00	AAPL	Stock	15.4911	15.4911	15.4886	15.4911	11200.0
2013-07-18 09:00:00	AAPL	Stock	15.4893	15.4982	15.4893	15.4982	185752.0
2013-07-18 09:01:00	AAPL	Stock	15.4932	15.4971	15.4893	15.4893	61572.0
2013-07-18 09:02:00	AAPL	Stock	15.4929	15.5	15.4918	15.4996	76804.0
2013-07-18 09:03:00	AAPL	Stock	15.4996	15.5057	15.4943	15.4943	152460.0
2013-07-18 09:04:00	AAPL	Stock	15.4929	15.4964	15.4893	15.4893	107968.0
2013-07-18 09:05:00	AAPL	Stock	15.4889	15.4918	15.4875	15.4918	36400.0
2013-07-18 09:06:00	AAPL	Stock	15.4954	15.4957	15.4929	15.4929	58800.0
2013-07-18 09:07:00	AAPL	Stock	15.495	15.4957	15.4929	15.4929	19600.0
2013-07-18 09:08:00	AAPL	Stock	15.4875	15.4875	15.4875	15.4875	2800.0
2013-07-18 09:09:00	AAPL	Stock	15.4879	15.4929	15.4857	15.4857	37380.0

> showing 50 of 970,221 rows — these rows as CSV

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