PREVIEW / stock_1min / 2018-04-02

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-04-02.parquet
  size:    16.2 MB
  rows:    1,147,937
  symbols: 2,394

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
2018-04-02 04:00:00	AAPL	Stock	41.9	41.9	41.85	41.85	3524.0
2018-04-02 04:08:00	AAPL	Stock	41.9775	41.9775	41.925	41.925	9740.0
2018-04-02 04:09:00	AAPL	Stock	41.925	41.925	41.925	41.925	1200.0
2018-04-02 04:18:00	AAPL	Stock	41.9275	41.9275	41.9275	41.9275	568.0
2018-04-02 04:20:00	AAPL	Stock	41.9375	41.9375	41.925	41.925	7536.0
2018-04-02 04:49:00	AAPL	Stock	41.93	41.95	41.925	41.95	4764.0
2018-04-02 04:54:00	AAPL	Stock	41.95	41.95	41.95	41.95	2212.0
2018-04-02 05:00:00	AAPL	Stock	41.95	41.95	41.925	41.925	8000.0
2018-04-02 05:01:00	AAPL	Stock	41.9275	41.9275	41.925	41.925	12000.0
2018-04-02 05:02:00	AAPL	Stock	41.925	41.925	41.925	41.925	6000.0
2018-04-02 05:09:00	AAPL	Stock	41.9275	41.9275	41.9275	41.9275	4000.0
2018-04-02 05:52:00	AAPL	Stock	41.9375	41.9375	41.9375	41.9375	760.0
2018-04-02 06:07:00	AAPL	Stock	42.0175	42.0475	42.0175	42.0475	10000.0
2018-04-02 06:11:00	AAPL	Stock	42.0475	42.0475	42.0475	42.0475	6400.0
2018-04-02 06:13:00	AAPL	Stock	42.0475	42.0475	42.0475	42.0475	2264.0
2018-04-02 06:22:00	AAPL	Stock	42.0225	42.0225	42.0	42.0	1872.0
2018-04-02 06:24:00	AAPL	Stock	42.02	42.02	42.02	42.02	400.0
2018-04-02 06:50:00	AAPL	Stock	42.0	42.0	42.0	42.0	3940.0
2018-04-02 06:55:00	AAPL	Stock	42.0	42.0	42.0	42.0	1200.0
2018-04-02 06:59:00	AAPL	Stock	41.975	41.975	41.975	41.975	1600.0
2018-04-02 07:00:00	AAPL	Stock	42.0	42.0	41.9175	41.9175	35056.0
2018-04-02 07:01:00	AAPL	Stock	41.9675	41.975	41.92	41.975	14040.0
2018-04-02 07:02:00	AAPL	Stock	41.875	41.875	41.875	41.875	3600.0
2018-04-02 07:03:00	AAPL	Stock	41.875	41.875	41.875	41.875	2000.0
2018-04-02 07:04:00	AAPL	Stock	41.875	41.875	41.85	41.85	5424.0
2018-04-02 07:05:00	AAPL	Stock	41.87	41.87	41.87	41.87	8000.0
2018-04-02 07:06:00	AAPL	Stock	41.875	41.875	41.875	41.875	3600.0
2018-04-02 07:08:00	AAPL	Stock	41.875	41.875	41.875	41.875	400.0
2018-04-02 07:11:00	AAPL	Stock	41.91	41.91	41.91	41.91	3016.0
2018-04-02 07:14:00	AAPL	Stock	41.89	41.925	41.8625	41.925	25236.0
2018-04-02 07:15:00	AAPL	Stock	41.8775	41.9025	41.8775	41.9025	9400.0
2018-04-02 07:17:00	AAPL	Stock	41.8375	41.8375	41.825	41.825	6160.0
2018-04-02 07:19:00	AAPL	Stock	41.84	41.84	41.84	41.84	428.0
2018-04-02 07:20:00	AAPL	Stock	41.835	41.8375	41.835	41.8375	6000.0
2018-04-02 07:21:00	AAPL	Stock	41.815	41.8625	41.815	41.8625	6200.0
2018-04-02 07:22:00	AAPL	Stock	41.825	41.8725	41.825	41.8725	6660.0
2018-04-02 07:24:00	AAPL	Stock	41.87	41.8725	41.8275	41.8275	11668.0
2018-04-02 07:26:00	AAPL	Stock	41.8625	41.8625	41.8625	41.8625	800.0
2018-04-02 07:28:00	AAPL	Stock	41.8525	41.8525	41.8525	41.8525	3700.0
2018-04-02 07:31:00	AAPL	Stock	41.8425	41.8425	41.8425	41.8425	660.0
2018-04-02 07:32:00	AAPL	Stock	41.8425	41.8425	41.825	41.825	3740.0
2018-04-02 07:34:00	AAPL	Stock	41.7975	41.7975	41.7975	41.7975	852.0
2018-04-02 07:36:00	AAPL	Stock	41.7975	41.7975	41.7975	41.7975	400.0
2018-04-02 07:37:00	AAPL	Stock	41.8375	41.8375	41.8125	41.8125	12200.0
2018-04-02 07:38:00	AAPL	Stock	41.8	41.8	41.8	41.8	5600.0
2018-04-02 07:39:00	AAPL	Stock	41.8	41.8	41.8	41.8	4000.0
2018-04-02 07:40:00	AAPL	Stock	41.8	41.8	41.8	41.8	2400.0
2018-04-02 07:41:00	AAPL	Stock	41.8	41.8	41.7925	41.8	6000.0
2018-04-02 07:42:00	AAPL	Stock	41.815	41.815	41.8125	41.8125	2000.0
2018-04-02 07:43:00	AAPL	Stock	41.815	41.815	41.79	41.79	3088.0

> showing 50 of 1,147,937 rows — these rows as CSV

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