PREVIEW / stock_1min / 2011-01-27

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-01-27.parquet
  size:    12.9 MB
  rows:    963,896
  symbols: 2,875

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-01-27 04:20:00	AAPL	Stock	12.3032	12.3032	12.3032	12.3032	5600.0
2011-01-27 05:30:00	AAPL	Stock	12.3107	12.3107	12.3107	12.3107	2800.0
2011-01-27 05:41:00	AAPL	Stock	12.3225	12.3225	12.3214	12.3214	19600.0
2011-01-27 05:42:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	2800.0
2011-01-27 05:50:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	14000.0
2011-01-27 05:52:00	AAPL	Stock	12.3386	12.3386	12.3386	12.3386	2800.0
2011-01-27 06:00:00	AAPL	Stock	12.3257	12.3257	12.325	12.325	5600.0
2011-01-27 06:01:00	AAPL	Stock	12.325	12.325	12.325	12.325	5600.0
2011-01-27 06:02:00	AAPL	Stock	12.325	12.325	12.325	12.325	2800.0
2011-01-27 06:17:00	AAPL	Stock	12.3339	12.3339	12.3339	12.3339	2800.0
2011-01-27 06:19:00	AAPL	Stock	12.3339	12.3339	12.3339	12.3339	2800.0
2011-01-27 06:20:00	AAPL	Stock	12.3339	12.3339	12.3339	12.3339	13720.0
2011-01-27 06:27:00	AAPL	Stock	12.3375	12.3375	12.3375	12.3375	2800.0
2011-01-27 06:29:00	AAPL	Stock	12.3329	12.3329	12.3329	12.3329	2800.0
2011-01-27 06:32:00	AAPL	Stock	12.3189	12.3189	12.3189	12.3189	2800.0
2011-01-27 06:39:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	2800.0
2011-01-27 06:52:00	AAPL	Stock	12.3268	12.3268	12.3268	12.3268	14000.0
2011-01-27 07:00:00	AAPL	Stock	12.3268	12.3268	12.3268	12.3268	5600.0
2011-01-27 07:02:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	2800.0
2011-01-27 07:10:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	5600.0
2011-01-27 07:16:00	AAPL	Stock	12.3304	12.3304	12.3304	12.3304	2800.0
2011-01-27 07:24:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	5600.0
2011-01-27 07:25:00	AAPL	Stock	12.3214	12.3214	12.295	12.295	68320.0
2011-01-27 07:26:00	AAPL	Stock	12.3079	12.3079	12.3079	12.3079	2800.0
2011-01-27 07:30:00	AAPL	Stock	12.3186	12.3186	12.3175	12.3175	7280.0
2011-01-27 07:31:00	AAPL	Stock	12.3143	12.3143	12.3143	12.3143	2800.0
2011-01-27 07:34:00	AAPL	Stock	12.3207	12.3207	12.3207	12.3207	2800.0
2011-01-27 07:36:00	AAPL	Stock	12.315	12.3214	12.315	12.3214	5600.0
2011-01-27 07:37:00	AAPL	Stock	12.3211	12.3214	12.3211	12.3214	56560.0
2011-01-27 07:44:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	2800.0
2011-01-27 07:46:00	AAPL	Stock	12.3214	12.3214	12.3214	12.3214	8400.0
2011-01-27 07:54:00	AAPL	Stock	12.3157	12.3157	12.3157	12.3157	2800.0
2011-01-27 07:55:00	AAPL	Stock	12.3161	12.3186	12.3161	12.3186	18284.0
2011-01-27 08:00:00	AAPL	Stock	12.3054	12.3175	12.3046	12.3175	79408.0
2011-01-27 08:01:00	AAPL	Stock	12.3175	12.3175	12.3043	12.3043	62412.0
2011-01-27 08:02:00	AAPL	Stock	12.3121	12.3143	12.3043	12.3043	11200.0
2011-01-27 08:03:00	AAPL	Stock	12.3125	12.3193	12.3125	12.3193	19600.0
2011-01-27 08:05:00	AAPL	Stock	12.3139	12.3139	12.3139	12.3139	2800.0
2011-01-27 08:06:00	AAPL	Stock	12.3139	12.3143	12.3125	12.3143	25200.0
2011-01-27 08:07:00	AAPL	Stock	12.3125	12.3139	12.3125	12.3139	5600.0
2011-01-27 08:08:00	AAPL	Stock	12.3143	12.3143	12.3143	12.3143	12460.0
2011-01-27 08:09:00	AAPL	Stock	12.3107	12.3107	12.3107	12.3107	30800.0
2011-01-27 08:10:00	AAPL	Stock	12.3161	12.3168	12.3118	12.3118	20188.0
2011-01-27 08:11:00	AAPL	Stock	12.3118	12.3118	12.3057	12.3057	22400.0
2011-01-27 08:12:00	AAPL	Stock	12.31	12.3161	12.31	12.3136	27160.0
2011-01-27 08:14:00	AAPL	Stock	12.3136	12.3139	12.3129	12.3129	33600.0
2011-01-27 08:15:00	AAPL	Stock	12.3071	12.3071	12.3057	12.3057	31920.0
2011-01-27 08:16:00	AAPL	Stock	12.3057	12.3064	12.3018	12.3018	85540.0
2011-01-27 08:18:00	AAPL	Stock	12.3043	12.3043	12.3043	12.3043	11200.0
2011-01-27 08:20:00	AAPL	Stock	12.3075	12.3075	12.3075	12.3075	2800.0

> showing 50 of 963,896 rows — these rows as CSV

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