PREVIEW / stock_1min / 2011-06-28

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-06-28.parquet
  size:    13.3 MB
  rows:    1,013,099
  symbols: 2,864

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-06-28 04:51:00	AAPL	Stock	11.8696	11.8696	11.8696	11.8696	2800.0
2011-06-28 07:00:00	AAPL	Stock	11.8575	11.8575	11.8575	11.8575	2800.0
2011-06-28 07:08:00	AAPL	Stock	11.8546	11.8546	11.8546	11.8546	2800.0
2011-06-28 07:13:00	AAPL	Stock	11.8593	11.8593	11.8571	11.8571	5600.0
2011-06-28 07:14:00	AAPL	Stock	11.8643	11.8643	11.8561	11.8561	12600.0
2011-06-28 07:15:00	AAPL	Stock	11.8536	11.8536	11.8536	11.8536	2800.0
2011-06-28 07:17:00	AAPL	Stock	11.8571	11.8571	11.8571	11.8571	2800.0
2011-06-28 07:19:00	AAPL	Stock	11.8571	11.8571	11.8571	11.8571	5600.0
2011-06-28 07:21:00	AAPL	Stock	11.8636	11.8636	11.8636	11.8636	5600.0
2011-06-28 07:23:00	AAPL	Stock	11.8554	11.8554	11.8554	11.8554	2800.0
2011-06-28 07:24:00	AAPL	Stock	11.8554	11.8554	11.8554	11.8554	2800.0
2011-06-28 07:26:00	AAPL	Stock	11.8564	11.8564	11.8564	11.8564	10640.0
2011-06-28 07:27:00	AAPL	Stock	11.8554	11.8554	11.8393	11.8393	70700.0
2011-06-28 07:30:00	AAPL	Stock	11.8289	11.8289	11.8289	11.8289	14000.0
2011-06-28 07:32:00	AAPL	Stock	11.84	11.8411	11.84	11.8411	11200.0
2011-06-28 07:33:00	AAPL	Stock	11.8561	11.8561	11.8561	11.8561	5600.0
2011-06-28 07:34:00	AAPL	Stock	11.8446	11.8446	11.8446	11.8446	2800.0
2011-06-28 07:35:00	AAPL	Stock	11.8518	11.8518	11.8511	11.8518	17780.0
2011-06-28 07:36:00	AAPL	Stock	11.8518	11.8518	11.8514	11.8514	14000.0
2011-06-28 07:37:00	AAPL	Stock	11.8446	11.8446	11.8446	11.8446	14000.0
2011-06-28 07:38:00	AAPL	Stock	11.8446	11.8571	11.8393	11.8393	65464.0
2011-06-28 07:39:00	AAPL	Stock	11.8457	11.8457	11.8457	11.8457	7000.0
2011-06-28 07:41:00	AAPL	Stock	11.8468	11.8468	11.8468	11.8468	5600.0
2011-06-28 07:46:00	AAPL	Stock	11.8393	11.8393	11.8304	11.8304	25200.0
2011-06-28 07:47:00	AAPL	Stock	11.83	11.8304	11.8239	11.8239	61600.0
2011-06-28 07:48:00	AAPL	Stock	11.8232	11.8232	11.8214	11.8214	14280.0
2011-06-28 07:49:00	AAPL	Stock	11.8382	11.8382	11.8382	11.8382	2800.0
2011-06-28 07:58:00	AAPL	Stock	11.8429	11.8429	11.8386	11.8386	16800.0
2011-06-28 07:59:00	AAPL	Stock	11.8425	11.8425	11.8425	11.8425	8400.0
2011-06-28 08:00:00	AAPL	Stock	11.8643	11.8643	11.8514	11.8514	11200.0
2011-06-28 08:02:00	AAPL	Stock	11.8486	11.8639	11.8486	11.8607	46200.0
2011-06-28 08:03:00	AAPL	Stock	11.8536	11.8604	11.8518	11.8518	25760.0
2011-06-28 08:05:00	AAPL	Stock	11.8536	11.8536	11.8525	11.8525	11032.0
2011-06-28 08:07:00	AAPL	Stock	11.8564	11.8564	11.8564	11.8564	5600.0
2011-06-28 08:09:00	AAPL	Stock	11.855	11.855	11.855	11.855	6580.0
2011-06-28 08:11:00	AAPL	Stock	11.8571	11.8571	11.8571	11.8571	14000.0
2011-06-28 08:12:00	AAPL	Stock	11.8536	11.8536	11.8536	11.8536	5600.0
2011-06-28 08:14:00	AAPL	Stock	11.8482	11.8493	11.8482	11.8493	16800.0
2011-06-28 08:15:00	AAPL	Stock	11.8532	11.8536	11.8532	11.8536	8400.0
2011-06-28 08:16:00	AAPL	Stock	11.8568	11.8568	11.8564	11.8564	5600.0
2011-06-28 08:17:00	AAPL	Stock	11.8568	11.8636	11.8568	11.8636	28000.0
2011-06-28 08:18:00	AAPL	Stock	11.8636	11.8636	11.8636	11.8636	16800.0
2011-06-28 08:19:00	AAPL	Stock	11.8679	11.8679	11.8679	11.8679	8400.0
2011-06-28 08:20:00	AAPL	Stock	11.8711	11.8711	11.8711	11.8711	14000.0
2011-06-28 08:21:00	AAPL	Stock	11.8732	11.8804	11.8732	11.8804	21980.0
2011-06-28 08:22:00	AAPL	Stock	11.875	11.875	11.875	11.875	2800.0
2011-06-28 08:23:00	AAPL	Stock	11.8714	11.8714	11.8714	11.8714	2800.0
2011-06-28 08:25:00	AAPL	Stock	11.875	11.8818	11.875	11.8818	21980.0
2011-06-28 08:26:00	AAPL	Stock	11.8818	11.8821	11.8811	11.8821	39200.0
2011-06-28 08:27:00	AAPL	Stock	11.8875	11.8882	11.885	11.885	36400.0

> showing 50 of 1,013,099 rows — these rows as CSV

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