PREVIEW / stock_1min / 2017-02-03

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-02-03.parquet
  size:    14.2 MB
  rows:    1,028,996
  symbols: 2,574

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-02-03 05:24:00	AAPL	Stock	32.01	32.01	32.01	32.01	400.0
2017-02-03 06:22:00	AAPL	Stock	32.07	32.07	32.07	32.07	400.0
2017-02-03 06:31:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	1200.0
2017-02-03 06:32:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	1200.0
2017-02-03 06:37:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	400.0
2017-02-03 06:40:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	1880.0
2017-02-03 06:47:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	400.0
2017-02-03 06:48:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	400.0
2017-02-03 07:02:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	1600.0
2017-02-03 07:05:00	AAPL	Stock	32.1	32.1	32.1	32.1	800.0
2017-02-03 07:06:00	AAPL	Stock	32.1	32.1	32.1	32.1	1200.0
2017-02-03 07:07:00	AAPL	Stock	32.1	32.1	32.1	32.1	800.0
2017-02-03 07:08:00	AAPL	Stock	32.1025	32.1025	32.1025	32.1025	508.0
2017-02-03 07:10:00	AAPL	Stock	32.1	32.1	32.1	32.1	800.0
2017-02-03 07:11:00	AAPL	Stock	32.1025	32.105	32.1025	32.105	3800.0
2017-02-03 07:12:00	AAPL	Stock	32.1	32.1	32.1	32.1	400.0
2017-02-03 07:20:00	AAPL	Stock	32.1075	32.1075	32.1075	32.1075	1360.0
2017-02-03 07:31:00	AAPL	Stock	32.1225	32.1225	32.1	32.1	1404.0
2017-02-03 07:33:00	AAPL	Stock	32.115	32.115	32.1075	32.1075	800.0
2017-02-03 07:37:00	AAPL	Stock	32.1075	32.1075	32.1075	32.1075	400.0
2017-02-03 07:38:00	AAPL	Stock	32.1	32.1	32.1	32.1	800.0
2017-02-03 07:41:00	AAPL	Stock	32.1	32.1	32.1	32.1	400.0
2017-02-03 07:52:00	AAPL	Stock	32.1175	32.12	32.1175	32.12	8500.0
2017-02-03 08:00:00	AAPL	Stock	32.1175	32.13	32.105	32.105	41844.0
2017-02-03 08:01:00	AAPL	Stock	32.1075	32.1075	32.0625	32.1	43676.0
2017-02-03 08:02:00	AAPL	Stock	32.0825	32.0825	32.0825	32.0825	800.0
2017-02-03 08:03:00	AAPL	Stock	32.0825	32.0825	32.075	32.075	17548.0
2017-02-03 08:04:00	AAPL	Stock	32.07	32.07	32.0625	32.0625	10736.0
2017-02-03 08:05:00	AAPL	Stock	32.0625	32.07	32.0625	32.07	18864.0
2017-02-03 08:06:00	AAPL	Stock	32.07	32.07	32.07	32.07	10852.0
2017-02-03 08:07:00	AAPL	Stock	32.0625	32.0625	32.0625	32.0625	16300.0
2017-02-03 08:08:00	AAPL	Stock	32.05	32.05	32.03	32.03	1200.0
2017-02-03 08:09:00	AAPL	Stock	32.0325	32.0325	32.0325	32.0325	50200.0
2017-02-03 08:10:00	AAPL	Stock	32.05	32.05	32.05	32.05	400.0
2017-02-03 08:11:00	AAPL	Stock	32.05	32.05	32.05	32.05	400.0
2017-02-03 08:12:00	AAPL	Stock	32.05	32.05	32.05	32.05	800.0
2017-02-03 08:14:00	AAPL	Stock	32.04	32.04	32.04	32.04	400.0
2017-02-03 08:15:00	AAPL	Stock	32.05	32.05	32.05	32.05	800.0
2017-02-03 08:17:00	AAPL	Stock	32.05	32.05	32.05	32.05	2304.0
2017-02-03 08:20:00	AAPL	Stock	32.06	32.06	32.06	32.06	1000.0
2017-02-03 08:22:00	AAPL	Stock	32.05	32.0625	32.05	32.0625	10080.0
2017-02-03 08:23:00	AAPL	Stock	32.065	32.065	32.065	32.065	400.0
2017-02-03 08:24:00	AAPL	Stock	32.075	32.075	32.075	32.075	2000.0
2017-02-03 08:25:00	AAPL	Stock	32.0775	32.0775	32.0775	32.0775	400.0
2017-02-03 08:26:00	AAPL	Stock	32.075	32.075	32.07	32.07	3000.0
2017-02-03 08:29:00	AAPL	Stock	32.075	32.075	32.075	32.075	400.0
2017-02-03 08:30:00	AAPL	Stock	32.07	32.1	32.07	32.1	7772.0
2017-02-03 08:31:00	AAPL	Stock	32.0875	32.1025	32.0875	32.1025	4428.0
2017-02-03 08:32:00	AAPL	Stock	32.1075	32.1125	32.1075	32.1125	7600.0
2017-02-03 08:33:00	AAPL	Stock	32.12	32.1225	32.12	32.1225	1200.0

> showing 50 of 1,028,996 rows — these rows as CSV

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