PREVIEW / stock_5min / 2013-06-10

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-06-10.parquet
  size:    5.0 MB
  rows:    338,140
  symbols: 3,520

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-06-10 04:00:00	AAPL	Stock	15.8689	15.8689	15.8689	15.8689	14000.0
2013-06-10 04:05:00	AAPL	Stock	15.8679	15.8679	15.8679	15.8679	2800.0
2013-06-10 04:10:00	AAPL	Stock	15.8679	15.8679	15.8679	15.8679	2800.0
2013-06-10 04:50:00	AAPL	Stock	15.8757	15.8757	15.8757	15.8757	2800.0
2013-06-10 05:15:00	AAPL	Stock	15.8925	15.8925	15.8925	15.8925	2800.0
2013-06-10 05:20:00	AAPL	Stock	15.8768	15.8768	15.8757	15.8757	5600.0
2013-06-10 05:25:00	AAPL	Stock	15.8757	15.8757	15.8757	15.8757	2800.0
2013-06-10 06:00:00	AAPL	Stock	15.8671	15.8671	15.8671	15.8671	2800.0
2013-06-10 06:25:00	AAPL	Stock	15.8875	15.8875	15.8875	15.8875	2800.0
2013-06-10 06:30:00	AAPL	Stock	15.875	15.8925	15.8746	15.8925	18200.0
2013-06-10 06:40:00	AAPL	Stock	15.8929	15.8929	15.8929	15.8929	2800.0
2013-06-10 06:45:00	AAPL	Stock	15.8804	15.8804	15.8804	15.8804	5600.0
2013-06-10 06:50:00	AAPL	Stock	15.8804	15.8804	15.8804	15.8804	2800.0
2013-06-10 06:55:00	AAPL	Stock	15.8686	15.8686	15.8686	15.8686	2800.0
2013-06-10 07:00:00	AAPL	Stock	15.8793	15.8804	15.8714	15.8714	15932.0
2013-06-10 07:05:00	AAPL	Stock	15.8804	15.8925	15.8804	15.8914	23156.0
2013-06-10 07:10:00	AAPL	Stock	15.8882	15.8975	15.8839	15.8975	142268.0
2013-06-10 07:15:00	AAPL	Stock	15.8936	15.8936	15.8839	15.8921	46872.0
2013-06-10 07:20:00	AAPL	Stock	15.8846	15.8889	15.8679	15.8679	51184.0
2013-06-10 07:25:00	AAPL	Stock	15.8664	15.8746	15.8643	15.8746	38808.0
2013-06-10 07:30:00	AAPL	Stock	15.8746	15.8746	15.8696	15.8696	27748.0
2013-06-10 07:35:00	AAPL	Stock	15.8679	15.8679	15.8679	15.8679	2800.0
2013-06-10 07:45:00	AAPL	Stock	15.8746	15.8746	15.8586	15.8679	37240.0
2013-06-10 07:50:00	AAPL	Stock	15.8679	15.8679	15.8679	15.8679	2800.0
2013-06-10 07:55:00	AAPL	Stock	15.8679	15.8743	15.8679	15.8743	70168.0
2013-06-10 08:00:00	AAPL	Stock	15.8739	15.8918	15.84	15.8446	545048.0
2013-06-10 08:05:00	AAPL	Stock	15.8457	15.8571	15.7321	15.8561	89460.0
2013-06-10 08:10:00	AAPL	Stock	15.8529	15.8607	15.8475	15.85	95760.0
2013-06-10 08:15:00	AAPL	Stock	15.8532	15.8543	15.8046	15.8046	206780.0
2013-06-10 08:20:00	AAPL	Stock	15.8168	15.8236	15.8096	15.8196	117376.0
2013-06-10 08:25:00	AAPL	Stock	15.8146	15.8375	15.8146	15.8371	175056.0
2013-06-10 08:30:00	AAPL	Stock	15.8339	15.835	15.8218	15.8286	110320.0
2013-06-10 08:35:00	AAPL	Stock	15.8361	15.8457	15.8321	15.8346	149996.0
2013-06-10 08:40:00	AAPL	Stock	15.8311	15.8311	15.8096	15.8096	174748.0
2013-06-10 08:45:00	AAPL	Stock	15.8096	15.8204	15.7843	15.8089	3500000.0
2013-06-10 08:50:00	AAPL	Stock	15.8125	15.8214	15.8079	15.8214	85512.0
2013-06-10 08:55:00	AAPL	Stock	15.8136	15.8304	15.8107	15.8304	150640.0
2013-06-10 09:00:00	AAPL	Stock	15.8354	15.8482	15.8346	15.8411	74312.0
2013-06-10 09:05:00	AAPL	Stock	15.8468	15.8468	15.8357	15.8357	78064.0
2013-06-10 09:10:00	AAPL	Stock	15.8393	15.84	15.8329	15.8389	90748.0
2013-06-10 09:15:00	AAPL	Stock	15.8375	15.8389	15.8357	15.8389	96040.0
2013-06-10 09:20:00	AAPL	Stock	15.8389	15.8461	15.8389	15.8461	132664.0
2013-06-10 09:25:00	AAPL	Stock	15.8486	15.8839	15.8486	15.8836	780808.0
2013-06-10 09:30:00	AAPL	Stock	15.8764	15.9	15.825	15.8793	15559208.0
2013-06-10 09:35:00	AAPL	Stock	15.8789	15.9396	15.8682	15.9307	10971604.0
2013-06-10 09:40:00	AAPL	Stock	15.9296	15.9521	15.8982	15.9336	8098916.0
2013-06-10 09:45:00	AAPL	Stock	15.9289	15.976	15.9111	15.9654	7809424.0
2013-06-10 09:50:00	AAPL	Stock	15.9652	16.0154	15.9521	15.9686	9468788.0
2013-06-10 09:55:00	AAPL	Stock	15.9714	15.9979	15.9518	15.9807	7956508.0
2013-06-10 10:00:00	AAPL	Stock	15.9811	15.9954	15.9343	15.9562	6420708.0

> showing 50 of 338,140 rows — these rows as CSV

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