PREVIEW / stock_5min / 2011-08-18

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-08-18.parquet
  size:    5.1 MB
  rows:    344,434
  symbols: 3,548

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-08-18 04:00:00	AAPL	Stock	13.5154	13.5154	13.5154	13.5154	2800.0
2011-08-18 04:05:00	AAPL	Stock	13.4457	13.4457	13.4457	13.4457	2800.0
2011-08-18 04:50:00	AAPL	Stock	13.4114	13.4114	13.4114	13.4114	2800.0
2011-08-18 05:05:00	AAPL	Stock	13.3825	13.3825	13.3746	13.3746	28000.0
2011-08-18 05:15:00	AAPL	Stock	13.3221	13.3221	13.3221	13.3221	8372.0
2011-08-18 05:20:00	AAPL	Stock	13.3536	13.3625	13.2682	13.2682	19600.0
2011-08-18 05:25:00	AAPL	Stock	13.3664	13.3736	13.3664	13.3736	8400.0
2011-08-18 05:30:00	AAPL	Stock	13.3736	13.3789	13.3721	13.3789	16800.0
2011-08-18 05:50:00	AAPL	Stock	13.3921	13.3921	13.3921	13.3921	8400.0
2011-08-18 06:25:00	AAPL	Stock	13.3875	13.3929	13.3875	13.3929	11200.0
2011-08-18 06:30:00	AAPL	Stock	13.3804	13.3868	13.3804	13.3868	11200.0
2011-08-18 06:35:00	AAPL	Stock	13.385	13.385	13.385	13.385	2800.0
2011-08-18 06:45:00	AAPL	Stock	13.3846	13.3846	13.3846	13.3846	2800.0
2011-08-18 07:00:00	AAPL	Stock	13.4032	13.4286	13.3936	13.4286	61600.0
2011-08-18 07:05:00	AAPL	Stock	13.4186	13.4354	13.4179	13.4204	56448.0
2011-08-18 07:10:00	AAPL	Stock	13.4204	13.4204	13.4036	13.4036	28000.0
2011-08-18 07:15:00	AAPL	Stock	13.4032	13.4032	13.3839	13.4032	122220.0
2011-08-18 07:20:00	AAPL	Stock	13.4018	13.4139	13.3932	13.3932	95200.0
2011-08-18 07:25:00	AAPL	Stock	13.4014	13.4014	13.4014	13.4014	2800.0
2011-08-18 07:30:00	AAPL	Stock	13.4082	13.4082	13.3654	13.3732	58660.0
2011-08-18 07:35:00	AAPL	Stock	13.3743	13.3818	13.3646	13.3725	94444.0
2011-08-18 07:40:00	AAPL	Stock	13.3693	13.3693	13.3536	13.3571	94668.0
2011-08-18 07:45:00	AAPL	Stock	13.3571	13.3646	13.3571	13.3607	37576.0
2011-08-18 07:50:00	AAPL	Stock	13.3618	13.3732	13.3618	13.3732	22400.0
2011-08-18 07:55:00	AAPL	Stock	13.3732	13.3857	13.365	13.3714	101360.0
2011-08-18 08:00:00	AAPL	Stock	13.3786	13.425	13.3661	13.3839	505148.0
2011-08-18 08:05:00	AAPL	Stock	13.395	13.3986	13.3814	13.3893	203812.0
2011-08-18 08:10:00	AAPL	Stock	13.3893	13.3904	13.3839	13.3868	169204.0
2011-08-18 08:15:00	AAPL	Stock	13.3864	13.4043	13.3857	13.3925	360052.0
2011-08-18 08:20:00	AAPL	Stock	13.3886	13.3893	13.3839	13.3889	78792.0
2011-08-18 08:25:00	AAPL	Stock	13.3861	13.3889	13.3643	13.3654	411768.0
2011-08-18 08:30:00	AAPL	Stock	13.3654	13.3714	13.3393	13.3393	941528.0
2011-08-18 08:35:00	AAPL	Stock	13.3396	13.3571	13.3396	13.3568	298620.0
2011-08-18 08:40:00	AAPL	Stock	13.3511	13.3568	13.3393	13.3396	200480.0
2011-08-18 08:45:00	AAPL	Stock	13.3429	13.3429	13.3243	13.3321	347956.0
2011-08-18 08:50:00	AAPL	Stock	13.3354	13.3454	13.3321	13.3393	186340.0
2011-08-18 08:55:00	AAPL	Stock	13.3393	13.3429	13.3236	13.325	312928.0
2011-08-18 09:00:00	AAPL	Stock	13.3239	13.3321	13.3025	13.3025	523012.0
2011-08-18 09:05:00	AAPL	Stock	13.305	13.305	13.2857	13.2911	974456.0
2011-08-18 09:10:00	AAPL	Stock	13.2911	13.2929	13.2632	13.2679	641900.0
2011-08-18 09:15:00	AAPL	Stock	13.2686	13.2757	13.2232	13.25	1448216.0
2011-08-18 09:20:00	AAPL	Stock	13.2539	13.2768	13.2504	13.2689	410116.0
2011-08-18 09:25:00	AAPL	Stock	13.2746	13.2768	13.2339	13.245	885584.0
2011-08-18 09:30:00	AAPL	Stock	13.24	13.3089	13.2143	13.2268	43058736.0
2011-08-18 09:35:00	AAPL	Stock	13.23	13.2304	13.1393	13.1768	25619608.0
2011-08-18 09:40:00	AAPL	Stock	13.1768	13.18	13.0761	13.1231	27363952.0
2011-08-18 09:45:00	AAPL	Stock	13.1193	13.1657	13.0996	13.1571	19516224.0
2011-08-18 09:50:00	AAPL	Stock	13.1571	13.2132	13.153	13.1796	19291496.0
2011-08-18 09:55:00	AAPL	Stock	13.1775	13.2054	13.1593	13.1668	10288544.0
2011-08-18 10:00:00	AAPL	Stock	13.1661	13.1661	13.0982	13.1311	19601652.0

> showing 50 of 344,434 rows — these rows as CSV

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