PREVIEW / stock_1min / 2014-12-18

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-12-18.parquet
  size:    16.4 MB
  rows:    1,177,019
  symbols: 2,917

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-12-18 04:00:00	AAPL	Stock	27.265	27.6425	27.265	27.64	13040.0
2014-12-18 04:08:00	AAPL	Stock	27.6925	27.6925	27.6925	27.6925	688.0
2014-12-18 04:13:00	AAPL	Stock	27.705	27.705	27.705	27.705	400.0
2014-12-18 04:15:00	AAPL	Stock	27.72	27.72	27.72	27.72	800.0
2014-12-18 04:16:00	AAPL	Stock	27.705	27.705	27.705	27.705	400.0
2014-12-18 04:19:00	AAPL	Stock	27.7075	27.7075	27.7075	27.7075	400.0
2014-12-18 04:23:00	AAPL	Stock	27.735	27.735	27.735	27.735	2000.0
2014-12-18 04:24:00	AAPL	Stock	27.7	27.7	27.6925	27.6925	3200.0
2014-12-18 04:25:00	AAPL	Stock	27.6525	27.6675	27.6525	27.6675	1600.0
2014-12-18 04:29:00	AAPL	Stock	27.715	27.715	27.715	27.715	400.0
2014-12-18 04:30:00	AAPL	Stock	27.725	27.74	27.725	27.74	5800.0
2014-12-18 04:31:00	AAPL	Stock	27.74	27.75	27.74	27.75	4000.0
2014-12-18 04:33:00	AAPL	Stock	27.75	27.75	27.75	27.75	400.0
2014-12-18 04:41:00	AAPL	Stock	27.75	27.75	27.75	27.75	400.0
2014-12-18 04:50:00	AAPL	Stock	27.7425	27.7425	27.7425	27.7425	800.0
2014-12-18 04:52:00	AAPL	Stock	27.75	27.75	27.75	27.75	800.0
2014-12-18 04:53:00	AAPL	Stock	27.75	27.75	27.75	27.75	800.0
2014-12-18 04:58:00	AAPL	Stock	27.75	27.75	27.75	27.75	1600.0
2014-12-18 05:03:00	AAPL	Stock	27.75	27.75	27.75	27.75	400.0
2014-12-18 05:08:00	AAPL	Stock	27.7775	27.7775	27.7775	27.7775	400.0
2014-12-18 05:11:00	AAPL	Stock	27.7775	27.7875	27.7775	27.7875	2664.0
2014-12-18 05:12:00	AAPL	Stock	27.8	27.8	27.8	27.8	800.0
2014-12-18 05:17:00	AAPL	Stock	27.8125	27.8125	27.8	27.8	2400.0
2014-12-18 05:19:00	AAPL	Stock	27.825	27.8275	27.825	27.8275	1612.0
2014-12-18 05:21:00	AAPL	Stock	27.825	27.825	27.8125	27.8125	7784.0
2014-12-18 05:22:00	AAPL	Stock	27.8125	27.8125	27.8125	27.8125	1476.0
2014-12-18 05:24:00	AAPL	Stock	27.8125	27.8125	27.8125	27.8125	952.0
2014-12-18 05:27:00	AAPL	Stock	27.825	27.825	27.8175	27.8175	4000.0
2014-12-18 05:28:00	AAPL	Stock	27.825	27.825	27.8175	27.825	11832.0
2014-12-18 05:29:00	AAPL	Stock	27.825	27.825	27.825	27.825	800.0
2014-12-18 05:30:00	AAPL	Stock	27.825	27.825	27.825	27.825	400.0
2014-12-18 05:31:00	AAPL	Stock	27.825	27.875	27.825	27.875	14344.0
2014-12-18 05:32:00	AAPL	Stock	27.875	27.93	27.875	27.925	13100.0
2014-12-18 05:33:00	AAPL	Stock	27.92	27.92	27.92	27.92	2048.0
2014-12-18 05:34:00	AAPL	Stock	27.875	27.875	27.875	27.875	400.0
2014-12-18 05:36:00	AAPL	Stock	27.875	27.9	27.875	27.9	4752.0
2014-12-18 05:39:00	AAPL	Stock	27.895	27.895	27.875	27.875	7000.0
2014-12-18 05:41:00	AAPL	Stock	27.895	27.895	27.895	27.895	4000.0
2014-12-18 05:44:00	AAPL	Stock	27.8825	27.8825	27.8825	27.8825	2000.0
2014-12-18 05:46:00	AAPL	Stock	27.8975	27.8975	27.8975	27.8975	400.0
2014-12-18 05:48:00	AAPL	Stock	27.8825	27.8825	27.875	27.875	6148.0
2014-12-18 05:49:00	AAPL	Stock	27.895	27.9325	27.895	27.9325	19368.0
2014-12-18 05:50:00	AAPL	Stock	27.9375	27.9375	27.9375	27.9375	11760.0
2014-12-18 05:51:00	AAPL	Stock	27.935	27.9375	27.925	27.9375	7600.0
2014-12-18 05:54:00	AAPL	Stock	27.935	27.935	27.935	27.935	400.0
2014-12-18 05:56:00	AAPL	Stock	27.93	27.93	27.93	27.93	400.0
2014-12-18 05:58:00	AAPL	Stock	27.925	27.925	27.925	27.925	2000.0
2014-12-18 06:01:00	AAPL	Stock	27.91	27.91	27.905	27.905	2956.0
2014-12-18 06:02:00	AAPL	Stock	27.8775	27.8775	27.875	27.875	4800.0
2014-12-18 06:03:00	AAPL	Stock	27.8775	27.8775	27.875	27.875	2800.0

> showing 50 of 1,177,019 rows — these rows as CSV

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