PREVIEW / stock_1min / 2018-04-17

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-04-17.parquet
  size:    15.0 MB
  rows:    1,073,918
  symbols: 2,381

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-17 04:00:00	AAPL	Stock	44.1275	44.25	44.1275	44.25	11464.0
2018-04-17 04:02:00	AAPL	Stock	44.235	44.2525	44.235	44.2525	3736.0
2018-04-17 04:06:00	AAPL	Stock	44.2675	44.2675	44.2675	44.2675	7956.0
2018-04-17 04:09:00	AAPL	Stock	44.2975	44.3	44.2975	44.3	2800.0
2018-04-17 04:12:00	AAPL	Stock	44.295	44.295	44.295	44.295	400.0
2018-04-17 04:18:00	AAPL	Stock	44.295	44.295	44.295	44.295	2444.0
2018-04-17 04:28:00	AAPL	Stock	44.2325	44.2325	44.23	44.23	2040.0
2018-04-17 04:33:00	AAPL	Stock	44.165	44.165	44.165	44.165	588.0
2018-04-17 05:48:00	AAPL	Stock	44.15	44.15	44.15	44.15	400.0
2018-04-17 05:57:00	AAPL	Stock	44.2125	44.215	44.2125	44.215	2776.0
2018-04-17 05:59:00	AAPL	Stock	44.2475	44.25	44.2475	44.25	4200.0
2018-04-17 06:13:00	AAPL	Stock	44.27	44.275	44.27	44.275	7524.0
2018-04-17 06:29:00	AAPL	Stock	44.2075	44.2075	44.2075	44.2075	400.0
2018-04-17 06:30:00	AAPL	Stock	44.2625	44.2625	44.2625	44.2625	4000.0
2018-04-17 06:37:00	AAPL	Stock	44.195	44.195	44.195	44.195	800.0
2018-04-17 06:39:00	AAPL	Stock	44.25	44.25	44.25	44.25	800.0
2018-04-17 06:43:00	AAPL	Stock	44.2025	44.2025	44.2	44.2	1200.0
2018-04-17 06:55:00	AAPL	Stock	44.2475	44.2475	44.2475	44.2475	4000.0
2018-04-17 06:56:00	AAPL	Stock	44.25	44.25	44.25	44.25	800.0
2018-04-17 07:00:00	AAPL	Stock	44.2	44.25	44.2	44.225	19844.0
2018-04-17 07:02:00	AAPL	Stock	44.2	44.2125	44.1575	44.2125	6000.0
2018-04-17 07:06:00	AAPL	Stock	44.195	44.195	44.175	44.195	1600.0
2018-04-17 07:07:00	AAPL	Stock	44.195	44.195	44.195	44.195	1600.0
2018-04-17 07:09:00	AAPL	Stock	44.175	44.175	44.175	44.175	2000.0
2018-04-17 07:10:00	AAPL	Stock	44.195	44.195	44.195	44.195	400.0
2018-04-17 07:11:00	AAPL	Stock	44.175	44.175	44.175	44.175	4000.0
2018-04-17 07:14:00	AAPL	Stock	44.175	44.175	44.17	44.17	6020.0
2018-04-17 07:23:00	AAPL	Stock	44.195	44.1975	44.195	44.1975	3660.0
2018-04-17 07:25:00	AAPL	Stock	44.195	44.195	44.195	44.195	400.0
2018-04-17 07:27:00	AAPL	Stock	44.1875	44.1875	44.1875	44.1875	400.0
2018-04-17 07:28:00	AAPL	Stock	44.1875	44.1875	44.1875	44.1875	3520.0
2018-04-17 07:30:00	AAPL	Stock	44.1875	44.1875	44.1875	44.1875	8400.0
2018-04-17 07:31:00	AAPL	Stock	44.1875	44.1875	44.1875	44.1875	400.0
2018-04-17 07:32:00	AAPL	Stock	44.1875	44.1875	44.1875	44.1875	400.0
2018-04-17 07:37:00	AAPL	Stock	44.1925	44.1925	44.1925	44.1925	5436.0
2018-04-17 07:38:00	AAPL	Stock	44.2	44.2	44.2	44.2	6136.0
2018-04-17 07:39:00	AAPL	Stock	44.215	44.215	44.21	44.21	1212.0
2018-04-17 07:42:00	AAPL	Stock	44.205	44.2125	44.205	44.2125	5200.0
2018-04-17 07:57:00	AAPL	Stock	44.2325	44.2325	44.2325	44.2325	800.0
2018-04-17 07:58:00	AAPL	Stock	44.23	44.23	44.23	44.23	400.0
2018-04-17 07:59:00	AAPL	Stock	44.23	44.23	44.23	44.23	2040.0
2018-04-17 08:00:00	AAPL	Stock	44.17	44.25	44.17	44.225	18136.0
2018-04-17 08:01:00	AAPL	Stock	44.2225	44.225	44.2225	44.225	4720.0
2018-04-17 08:02:00	AAPL	Stock	44.23	44.245	44.23	44.2425	9200.0
2018-04-17 08:03:00	AAPL	Stock	44.245	44.2475	44.2325	44.2325	7504.0
2018-04-17 08:04:00	AAPL	Stock	44.2425	44.2425	44.2425	44.2425	8332.0
2018-04-17 08:05:00	AAPL	Stock	44.2475	44.2625	44.2475	44.2625	18692.0
2018-04-17 08:06:00	AAPL	Stock	44.25	44.25	44.25	44.25	2268.0
2018-04-17 08:07:00	AAPL	Stock	44.26	44.26	44.26	44.26	1600.0
2018-04-17 08:08:00	AAPL	Stock	44.2375	44.2425	44.2375	44.2375	3800.0

> showing 50 of 1,073,918 rows — these rows as CSV

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