PREVIEW / stock_1min / 2014-07-24

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-07-24.parquet
  size:    13.7 MB
  rows:    1,011,707
  symbols: 2,894

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
2014-07-24 04:00:00	AAPL	Stock	24.3275	24.3275	24.3275	24.3275	400.0
2014-07-24 04:02:00	AAPL	Stock	24.35	24.35	24.35	24.35	640.0
2014-07-24 04:09:00	AAPL	Stock	24.325	24.325	24.325	24.325	1120.0
2014-07-24 04:15:00	AAPL	Stock	24.35	24.35	24.3475	24.3475	4000.0
2014-07-24 04:18:00	AAPL	Stock	24.36	24.3725	24.36	24.3725	1200.0
2014-07-24 04:29:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	4720.0
2014-07-24 04:30:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	4000.0
2014-07-24 04:34:00	AAPL	Stock	24.32	24.32	24.32	24.32	400.0
2014-07-24 04:35:00	AAPL	Stock	24.32	24.32	24.32	24.32	800.0
2014-07-24 04:39:00	AAPL	Stock	24.3125	24.3125	24.3125	24.3125	12000.0
2014-07-24 04:44:00	AAPL	Stock	24.3125	24.3125	24.3125	24.3125	2000.0
2014-07-24 04:51:00	AAPL	Stock	24.3175	24.3175	24.3175	24.3175	3280.0
2014-07-24 04:53:00	AAPL	Stock	24.315	24.315	24.315	24.315	620.0
2014-07-24 04:56:00	AAPL	Stock	24.32	24.32	24.32	24.32	5600.0
2014-07-24 05:01:00	AAPL	Stock	24.3225	24.3225	24.3225	24.3225	1200.0
2014-07-24 05:08:00	AAPL	Stock	24.3175	24.3175	24.3	24.3	1200.0
2014-07-24 05:27:00	AAPL	Stock	24.3225	24.325	24.3225	24.325	3896.0
2014-07-24 05:29:00	AAPL	Stock	24.325	24.325	24.325	24.325	4000.0
2014-07-24 05:59:00	AAPL	Stock	24.3125	24.3125	24.3125	24.3125	1200.0
2014-07-24 06:01:00	AAPL	Stock	24.325	24.325	24.325	24.325	6000.0
2014-07-24 06:02:00	AAPL	Stock	24.325	24.325	24.325	24.325	800.0
2014-07-24 06:07:00	AAPL	Stock	24.325	24.325	24.325	24.325	400.0
2014-07-24 06:08:00	AAPL	Stock	24.3275	24.3325	24.3275	24.3325	6772.0
2014-07-24 06:11:00	AAPL	Stock	24.3325	24.3325	24.3325	24.3325	3860.0
2014-07-24 06:13:00	AAPL	Stock	24.3375	24.3375	24.3375	24.3375	4800.0
2014-07-24 06:14:00	AAPL	Stock	24.3375	24.3375	24.3375	24.3375	2400.0
2014-07-24 06:15:00	AAPL	Stock	24.345	24.355	24.345	24.355	2040.0
2014-07-24 06:16:00	AAPL	Stock	24.35	24.3525	24.35	24.3525	800.0
2014-07-24 06:17:00	AAPL	Stock	24.3525	24.3525	24.3525	24.3525	9396.0
2014-07-24 06:18:00	AAPL	Stock	24.355	24.3575	24.35	24.3575	3064.0
2014-07-24 06:21:00	AAPL	Stock	24.36	24.36	24.36	24.36	1340.0
2014-07-24 06:24:00	AAPL	Stock	24.3525	24.3625	24.35	24.3625	9516.0
2014-07-24 06:32:00	AAPL	Stock	24.345	24.345	24.34	24.34	6000.0
2014-07-24 06:35:00	AAPL	Stock	24.35	24.35	24.35	24.35	2000.0
2014-07-24 06:36:00	AAPL	Stock	24.35	24.3525	24.35	24.3525	1312.0
2014-07-24 06:37:00	AAPL	Stock	24.3525	24.3525	24.3525	24.3525	12420.0
2014-07-24 06:41:00	AAPL	Stock	24.3525	24.3525	24.3525	24.3525	400.0
2014-07-24 06:43:00	AAPL	Stock	24.3525	24.3525	24.3525	24.3525	8720.0
2014-07-24 06:44:00	AAPL	Stock	24.3525	24.3525	24.3525	24.3525	980.0
2014-07-24 06:46:00	AAPL	Stock	24.35	24.35	24.35	24.35	2400.0
2014-07-24 06:49:00	AAPL	Stock	24.345	24.35	24.345	24.35	800.0
2014-07-24 06:51:00	AAPL	Stock	24.345	24.345	24.345	24.345	524.0
2014-07-24 06:53:00	AAPL	Stock	24.345	24.345	24.345	24.345	676.0
2014-07-24 06:54:00	AAPL	Stock	24.345	24.345	24.34	24.34	1524.0
2014-07-24 06:56:00	AAPL	Stock	24.3325	24.3325	24.3325	24.3325	840.0
2014-07-24 06:58:00	AAPL	Stock	24.3325	24.35	24.3325	24.35	10636.0
2014-07-24 07:01:00	AAPL	Stock	24.325	24.325	24.325	24.325	1288.0
2014-07-24 07:02:00	AAPL	Stock	24.3425	24.345	24.325	24.325	9812.0
2014-07-24 07:03:00	AAPL	Stock	24.3225	24.3225	24.295	24.295	15300.0
2014-07-24 07:04:00	AAPL	Stock	24.3025	24.3025	24.3025	24.3025	2000.0

> showing 50 of 1,011,707 rows — these rows as CSV

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