PREVIEW / stock_1min / 2011-06-24

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-06-24.parquet
  size:    14.0 MB
  rows:    1,059,897
  symbols: 2,870

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-24 04:35:00	AAPL	Stock	11.8636	11.8636	11.8636	11.8636	2800.0
2011-06-24 05:14:00	AAPL	Stock	11.9111	11.9111	11.9107	11.9107	5600.0
2011-06-24 05:16:00	AAPL	Stock	11.9107	11.9107	11.9107	11.9107	11200.0
2011-06-24 05:17:00	AAPL	Stock	11.9107	11.9107	11.9107	11.9107	8400.0
2011-06-24 05:25:00	AAPL	Stock	11.9107	11.9107	11.9107	11.9107	11200.0
2011-06-24 05:49:00	AAPL	Stock	11.9071	11.9071	11.9071	11.9071	14000.0
2011-06-24 06:03:00	AAPL	Stock	11.9018	11.9018	11.8764	11.8764	8400.0
2011-06-24 06:07:00	AAPL	Stock	11.8754	11.8754	11.8754	11.8754	10640.0
2011-06-24 06:17:00	AAPL	Stock	11.8679	11.8679	11.8679	11.8679	5600.0
2011-06-24 06:18:00	AAPL	Stock	11.8632	11.8632	11.8632	11.8632	2800.0
2011-06-24 06:42:00	AAPL	Stock	11.8632	11.8632	11.8632	11.8632	5600.0
2011-06-24 06:48:00	AAPL	Stock	11.8643	11.8643	11.8643	11.8643	2800.0
2011-06-24 07:01:00	AAPL	Stock	11.8611	11.8611	11.8611	11.8611	14000.0
2011-06-24 07:02:00	AAPL	Stock	11.8482	11.8482	11.8482	11.8482	14000.0
2011-06-24 07:05:00	AAPL	Stock	11.8571	11.8571	11.8504	11.8504	5600.0
2011-06-24 07:10:00	AAPL	Stock	11.8475	11.8475	11.8464	11.8464	5600.0
2011-06-24 07:11:00	AAPL	Stock	11.8429	11.8454	11.8429	11.8446	14000.0
2011-06-24 07:12:00	AAPL	Stock	11.8429	11.8429	11.8429	11.8429	5600.0
2011-06-24 07:13:00	AAPL	Stock	11.8429	11.8571	11.8429	11.8571	44800.0
2011-06-24 07:16:00	AAPL	Stock	11.8604	11.8604	11.8604	11.8604	2800.0
2011-06-24 07:19:00	AAPL	Stock	11.8529	11.8546	11.8529	11.8546	8400.0
2011-06-24 07:21:00	AAPL	Stock	11.8504	11.8504	11.8482	11.8482	5600.0
2011-06-24 07:25:00	AAPL	Stock	11.8446	11.8446	11.8429	11.8429	5600.0
2011-06-24 07:28:00	AAPL	Stock	11.8418	11.8418	11.8393	11.8393	27300.0
2011-06-24 07:32:00	AAPL	Stock	11.8393	11.8393	11.8393	11.8393	2800.0
2011-06-24 07:33:00	AAPL	Stock	11.8464	11.8464	11.8464	11.8464	2800.0
2011-06-24 07:34:00	AAPL	Stock	11.8464	11.8464	11.8461	11.8461	30380.0
2011-06-24 07:35:00	AAPL	Stock	11.8482	11.8482	11.8461	11.8461	5600.0
2011-06-24 07:36:00	AAPL	Stock	11.8464	11.8464	11.8464	11.8464	2800.0
2011-06-24 07:39:00	AAPL	Stock	11.8446	11.8446	11.8446	11.8446	2800.0
2011-06-24 07:41:00	AAPL	Stock	11.8446	11.8446	11.8446	11.8446	11200.0
2011-06-24 07:42:00	AAPL	Stock	11.8368	11.8368	11.8357	11.8357	5600.0
2011-06-24 07:43:00	AAPL	Stock	11.8339	11.8393	11.8339	11.8393	8400.0
2011-06-24 07:45:00	AAPL	Stock	11.8393	11.8393	11.8393	11.8393	2800.0
2011-06-24 07:47:00	AAPL	Stock	11.8393	11.8393	11.8393	11.8393	2800.0
2011-06-24 07:49:00	AAPL	Stock	11.8393	11.8393	11.8393	11.8393	2800.0
2011-06-24 07:52:00	AAPL	Stock	11.8464	11.8464	11.8464	11.8464	2800.0
2011-06-24 07:53:00	AAPL	Stock	11.85	11.85	11.85	11.85	11200.0
2011-06-24 07:55:00	AAPL	Stock	11.8471	11.8471	11.8471	11.8471	16800.0
2011-06-24 07:56:00	AAPL	Stock	11.8464	11.8464	11.8464	11.8464	2800.0
2011-06-24 07:57:00	AAPL	Stock	11.8464	11.8464	11.8432	11.8432	8400.0
2011-06-24 07:58:00	AAPL	Stock	11.8375	11.8375	11.8229	11.8229	22232.0
2011-06-24 08:00:00	AAPL	Stock	11.8393	11.8464	11.8339	11.8339	100520.0
2011-06-24 08:01:00	AAPL	Stock	11.8321	11.8321	11.8214	11.8221	84280.0
2011-06-24 08:02:00	AAPL	Stock	11.8214	11.8296	11.8214	11.8296	19600.0
2011-06-24 08:03:00	AAPL	Stock	11.8304	11.8321	11.8304	11.8321	8400.0
2011-06-24 08:04:00	AAPL	Stock	11.8254	11.8254	11.8214	11.8239	57204.0
2011-06-24 08:06:00	AAPL	Stock	11.8171	11.8214	11.8171	11.8214	10360.0
2011-06-24 08:07:00	AAPL	Stock	11.8143	11.8143	11.8057	11.8057	36400.0
2011-06-24 08:08:00	AAPL	Stock	11.8057	11.8057	11.8032	11.8036	39200.0

> showing 50 of 1,059,897 rows — these rows as CSV

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