PREVIEW / stock_5min / 2011-07-01

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-07-01.parquet
  size:    4.8 MB
  rows:    327,858
  symbols: 3,511

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-07-01 07:00:00	AAPL	Stock	11.975	12.0357	11.975	11.975	16800.0
2011-07-01 07:15:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	11200.0
2011-07-01 07:20:00	AAPL	Stock	11.9793	11.9821	11.9786	11.9821	28000.0
2011-07-01 07:25:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	30800.0
2011-07-01 07:35:00	AAPL	Stock	11.9839	11.9839	11.9825	11.9825	9100.0
2011-07-01 07:45:00	AAPL	Stock	11.9882	11.9893	11.9882	11.9893	11060.0
2011-07-01 07:50:00	AAPL	Stock	11.9889	11.9889	11.9821	11.9821	48580.0
2011-07-01 08:00:00	AAPL	Stock	11.9882	11.9882	11.9646	11.9646	110180.0
2011-07-01 08:05:00	AAPL	Stock	11.9714	11.9768	11.9714	11.9768	29092.0
2011-07-01 08:10:00	AAPL	Stock	11.9786	11.9786	11.9689	11.9689	11620.0
2011-07-01 08:15:00	AAPL	Stock	11.9807	11.9807	11.9725	11.9732	12880.0
2011-07-01 08:20:00	AAPL	Stock	11.9725	11.9725	11.9682	11.9714	16492.0
2011-07-01 08:25:00	AAPL	Stock	11.9714	11.9804	11.9714	11.9804	25676.0
2011-07-01 08:30:00	AAPL	Stock	11.9804	11.9829	11.9804	11.9821	55776.0
2011-07-01 08:35:00	AAPL	Stock	11.9768	11.9882	11.9768	11.9882	351232.0
2011-07-01 08:45:00	AAPL	Stock	11.9882	11.9882	11.9804	11.9804	11200.0
2011-07-01 08:55:00	AAPL	Stock	11.9857	11.9868	11.9857	11.9857	16800.0
2011-07-01 09:00:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	5600.0
2011-07-01 09:05:00	AAPL	Stock	11.985	11.995	11.9814	11.9896	241052.0
2011-07-01 09:10:00	AAPL	Stock	11.9904	11.995	11.9882	11.9893	240716.0
2011-07-01 09:15:00	AAPL	Stock	11.9882	11.9982	11.9882	11.9964	243684.0
2011-07-01 09:20:00	AAPL	Stock	11.9964	12.0	11.9954	11.9982	60900.0
2011-07-01 09:25:00	AAPL	Stock	11.9964	11.9993	11.9736	11.9946	1022952.0
2011-07-01 09:30:00	AAPL	Stock	11.9943	11.9993	11.9571	11.9637	8387568.0
2011-07-01 09:35:00	AAPL	Stock	11.9634	11.9636	11.9357	11.9457	6931876.0
2011-07-01 09:40:00	AAPL	Stock	11.9432	11.9789	11.9407	11.9752	6648992.0
2011-07-01 09:45:00	AAPL	Stock	11.9757	11.9875	11.9575	11.9829	5359424.0
2011-07-01 09:50:00	AAPL	Stock	11.9827	11.9925	11.9771	11.9907	4055324.0
2011-07-01 09:55:00	AAPL	Stock	11.9891	12.0039	11.9832	11.9911	6341720.0
2011-07-01 10:00:00	AAPL	Stock	11.9925	12.0611	11.9889	12.0454	21206724.0
2011-07-01 10:05:00	AAPL	Stock	12.045	12.0493	12.0257	12.0286	6784764.0
2011-07-01 10:10:00	AAPL	Stock	12.0282	12.0393	12.0071	12.0179	7581308.0
2011-07-01 10:15:00	AAPL	Stock	12.0196	12.0304	12.0118	12.0171	5426904.0
2011-07-01 10:20:00	AAPL	Stock	12.015	12.0339	12.0146	12.0339	4811800.0
2011-07-01 10:25:00	AAPL	Stock	12.0339	12.0371	12.0254	12.0321	4068708.0
2011-07-01 10:30:00	AAPL	Stock	12.0337	12.0407	12.0304	12.0395	3671808.0
2011-07-01 10:35:00	AAPL	Stock	12.0382	12.0411	12.0293	12.0386	4122944.0
2011-07-01 10:40:00	AAPL	Stock	12.0382	12.0436	12.0325	12.0346	4164244.0
2011-07-01 10:45:00	AAPL	Stock	12.0346	12.0371	12.0239	12.0264	3168452.0
2011-07-01 10:50:00	AAPL	Stock	12.0261	12.0311	12.0225	12.025	2488360.0
2011-07-01 10:55:00	AAPL	Stock	12.0254	12.035	12.0186	12.0307	2981104.0
2011-07-01 11:00:00	AAPL	Stock	12.0294	12.0375	12.0279	12.0318	3145016.0
2011-07-01 11:05:00	AAPL	Stock	12.0286	12.0489	12.0286	12.0464	4805892.0
2011-07-01 11:10:00	AAPL	Stock	12.0479	12.0489	12.0332	12.0343	4050452.0
2011-07-01 11:15:00	AAPL	Stock	12.0354	12.0446	12.0339	12.0393	2397864.0
2011-07-01 11:20:00	AAPL	Stock	12.0386	12.0493	12.0379	12.0471	3574284.0
2011-07-01 11:25:00	AAPL	Stock	12.0468	12.0682	12.0461	12.065	7153636.0
2011-07-01 11:30:00	AAPL	Stock	12.065	12.1027	12.065	12.0993	9846508.0
2011-07-01 11:35:00	AAPL	Stock	12.0989	12.1386	12.0968	12.1173	16946804.0
2011-07-01 11:40:00	AAPL	Stock	12.1168	12.1457	12.1168	12.1398	12114368.0

> showing 50 of 327,858 rows — these rows as CSV

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