PREVIEW / stock_1min / 2017-01-24

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-24.parquet
  size:    14.7 MB
  rows:    1,055,263
  symbols: 2,568

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
2017-01-24 04:00:00	AAPL	Stock	29.875	29.875	29.845	29.845	14780.0
2017-01-24 04:02:00	AAPL	Stock	29.8375	29.8375	29.8375	29.8375	400.0
2017-01-24 04:07:00	AAPL	Stock	29.8125	29.8125	29.8125	29.8125	400.0
2017-01-24 04:09:00	AAPL	Stock	29.8125	29.8125	29.8125	29.8125	400.0
2017-01-24 04:15:00	AAPL	Stock	29.8	29.8	29.8	29.8	800.0
2017-01-24 04:21:00	AAPL	Stock	29.8025	29.8025	29.8	29.8	820.0
2017-01-24 04:25:00	AAPL	Stock	29.8325	29.8325	29.8325	29.8325	400.0
2017-01-24 04:31:00	AAPL	Stock	29.8075	29.8075	29.8075	29.8075	800.0
2017-01-24 04:38:00	AAPL	Stock	29.8	29.82	29.8	29.82	10920.0
2017-01-24 04:39:00	AAPL	Stock	29.8125	29.82	29.805	29.805	6696.0
2017-01-24 04:42:00	AAPL	Stock	29.81	29.81	29.81	29.81	400.0
2017-01-24 04:44:00	AAPL	Stock	29.8	29.8	29.8	29.8	480.0
2017-01-24 04:45:00	AAPL	Stock	29.81	29.81	29.8075	29.8075	2400.0
2017-01-24 04:46:00	AAPL	Stock	29.8075	29.8075	29.8075	29.8075	400.0
2017-01-24 04:47:00	AAPL	Stock	29.8075	29.8075	29.8075	29.8075	1600.0
2017-01-24 04:49:00	AAPL	Stock	29.8075	29.8075	29.8075	29.8075	400.0
2017-01-24 04:53:00	AAPL	Stock	29.805	29.805	29.805	29.805	520.0
2017-01-24 04:55:00	AAPL	Stock	29.79	29.79	29.7875	29.7875	880.0
2017-01-24 04:56:00	AAPL	Stock	29.775	29.78	29.77	29.78	6400.0
2017-01-24 04:57:00	AAPL	Stock	29.78	29.78	29.78	29.78	400.0
2017-01-24 05:06:00	AAPL	Stock	29.8	29.8	29.8	29.8	3680.0
2017-01-24 05:30:00	AAPL	Stock	29.7725	29.7725	29.7725	29.7725	4000.0
2017-01-24 05:31:00	AAPL	Stock	29.7925	29.7925	29.77	29.77	7484.0
2017-01-24 05:32:00	AAPL	Stock	29.775	29.775	29.775	29.775	400.0
2017-01-24 05:36:00	AAPL	Stock	29.775	29.775	29.775	29.775	400.0
2017-01-24 05:44:00	AAPL	Stock	29.775	29.775	29.775	29.775	800.0
2017-01-24 05:48:00	AAPL	Stock	29.7775	29.7775	29.75	29.75	8976.0
2017-01-24 05:49:00	AAPL	Stock	29.7275	29.75	29.7275	29.75	2880.0
2017-01-24 06:01:00	AAPL	Stock	29.7825	29.7825	29.75	29.75	1456.0
2017-01-24 06:02:00	AAPL	Stock	29.75	29.75	29.75	29.75	544.0
2017-01-24 06:07:00	AAPL	Stock	29.7825	29.785	29.7825	29.785	2000.0
2017-01-24 06:15:00	AAPL	Stock	29.785	29.795	29.785	29.795	9056.0
2017-01-24 06:16:00	AAPL	Stock	29.7975	29.8075	29.7875	29.7875	2788.0
2017-01-24 06:20:00	AAPL	Stock	29.79	29.7925	29.765	29.765	2400.0
2017-01-24 06:24:00	AAPL	Stock	29.7725	29.785	29.7725	29.785	1200.0
2017-01-24 06:32:00	AAPL	Stock	29.7875	29.7875	29.7875	29.7875	800.0
2017-01-24 06:33:00	AAPL	Stock	29.7875	29.8	29.7875	29.8	3120.0
2017-01-24 06:38:00	AAPL	Stock	29.8075	29.8125	29.8075	29.8125	57336.0
2017-01-24 06:39:00	AAPL	Stock	29.8125	29.8125	29.8	29.8	2100.0
2017-01-24 06:43:00	AAPL	Stock	29.815	29.815	29.8	29.8	3200.0
2017-01-24 06:44:00	AAPL	Stock	29.8075	29.8075	29.8075	29.8075	400.0
2017-01-24 06:45:00	AAPL	Stock	29.8075	29.8075	29.8075	29.8075	656.0
2017-01-24 06:46:00	AAPL	Stock	29.8075	29.8075	29.8075	29.8075	400.0
2017-01-24 06:52:00	AAPL	Stock	29.8125	29.8125	29.8125	29.8125	1700.0
2017-01-24 06:54:00	AAPL	Stock	29.8	29.8	29.8	29.8	556.0
2017-01-24 07:00:00	AAPL	Stock	29.8275	29.8275	29.8275	29.8275	4000.0
2017-01-24 07:01:00	AAPL	Stock	29.83	29.83	29.83	29.83	800.0
2017-01-24 07:02:00	AAPL	Stock	29.835	29.835	29.83	29.83	24000.0
2017-01-24 07:03:00	AAPL	Stock	29.825	29.825	29.825	29.825	400.0
2017-01-24 07:04:00	AAPL	Stock	29.8125	29.835	29.8125	29.835	1800.0

> showing 50 of 1,055,263 rows — these rows as CSV

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