PREVIEW / stock_1min / 2017-01-25

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-25.parquet
  size:    14.7 MB
  rows:    1,056,729
  symbols: 2,579

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-25 04:00:00	AAPL	Stock	30.025	30.055	30.025	30.055	800.0
2017-01-25 04:01:00	AAPL	Stock	30.065	30.065	30.065	30.065	688.0
2017-01-25 05:02:00	AAPL	Stock	30.1	30.1	30.1	30.1	400.0
2017-01-25 05:14:00	AAPL	Stock	30.1	30.1	30.1	30.1	4656.0
2017-01-25 05:15:00	AAPL	Stock	30.1	30.1	30.1	30.1	524.0
2017-01-25 05:27:00	AAPL	Stock	30.11	30.11	30.11	30.11	400.0
2017-01-25 05:37:00	AAPL	Stock	30.065	30.0925	30.0625	30.0925	4400.0
2017-01-25 05:38:00	AAPL	Stock	30.0925	30.0925	30.0925	30.0925	3040.0
2017-01-25 06:01:00	AAPL	Stock	30.0875	30.0875	30.0875	30.0875	400.0
2017-01-25 06:19:00	AAPL	Stock	30.0925	30.0925	30.0925	30.0925	1600.0
2017-01-25 06:27:00	AAPL	Stock	30.095	30.095	30.095	30.095	4000.0
2017-01-25 06:36:00	AAPL	Stock	30.09	30.09	30.09	30.09	400.0
2017-01-25 07:02:00	AAPL	Stock	30.09	30.09	30.09	30.09	1464.0
2017-01-25 07:03:00	AAPL	Stock	30.1	30.1	30.1	30.1	1600.0
2017-01-25 07:05:00	AAPL	Stock	30.1	30.1	30.1	30.1	4000.0
2017-01-25 07:06:00	AAPL	Stock	30.1	30.1	30.1	30.1	8536.0
2017-01-25 07:08:00	AAPL	Stock	30.095	30.095	30.095	30.095	4000.0
2017-01-25 07:09:00	AAPL	Stock	30.09	30.09	30.09	30.09	400.0
2017-01-25 07:20:00	AAPL	Stock	30.09	30.09	30.09	30.09	1124.0
2017-01-25 07:34:00	AAPL	Stock	30.0875	30.0875	30.0875	30.0875	724.0
2017-01-25 07:40:00	AAPL	Stock	30.0875	30.0875	30.0875	30.0875	416.0
2017-01-25 07:44:00	AAPL	Stock	30.0825	30.0825	30.08	30.08	12400.0
2017-01-25 07:45:00	AAPL	Stock	30.0775	30.0775	30.0775	30.0775	400.0
2017-01-25 07:46:00	AAPL	Stock	30.095	30.095	30.095	30.095	972.0
2017-01-25 07:50:00	AAPL	Stock	30.09	30.09	30.09	30.09	800.0
2017-01-25 07:53:00	AAPL	Stock	30.0875	30.09	30.0875	30.09	1372.0
2017-01-25 07:54:00	AAPL	Stock	30.09	30.09	30.09	30.09	5064.0
2017-01-25 07:55:00	AAPL	Stock	30.09	30.09	30.09	30.09	400.0
2017-01-25 08:00:00	AAPL	Stock	30.095	30.095	30.0775	30.09	17300.0
2017-01-25 08:01:00	AAPL	Stock	30.0775	30.0775	30.0775	30.0775	4000.0
2017-01-25 08:02:00	AAPL	Stock	30.0775	30.0775	30.0775	30.0775	1212.0
2017-01-25 08:03:00	AAPL	Stock	30.075	30.075	30.075	30.075	1000.0
2017-01-25 08:04:00	AAPL	Stock	30.065	30.065	30.065	30.065	400.0
2017-01-25 08:05:00	AAPL	Stock	30.0625	30.0625	30.0625	30.0625	2400.0
2017-01-25 08:07:00	AAPL	Stock	30.0575	30.065	30.0575	30.065	6812.0
2017-01-25 08:08:00	AAPL	Stock	30.0725	30.0725	30.0725	30.0725	400.0
2017-01-25 08:09:00	AAPL	Stock	30.0725	30.0725	30.0725	30.0725	400.0
2017-01-25 08:10:00	AAPL	Stock	30.0725	30.0725	30.0725	30.0725	800.0
2017-01-25 08:11:00	AAPL	Stock	30.075	30.075	30.075	30.075	2400.0
2017-01-25 08:12:00	AAPL	Stock	30.075	30.075	30.075	30.075	5904.0
2017-01-25 08:13:00	AAPL	Stock	30.075	30.075	30.0725	30.0725	3600.0
2017-01-25 08:14:00	AAPL	Stock	30.075	30.075	30.0725	30.0725	1796.0
2017-01-25 08:15:00	AAPL	Stock	30.0625	30.0625	30.0575	30.0575	7248.0
2017-01-25 08:16:00	AAPL	Stock	30.07	30.07	30.07	30.07	8000.0
2017-01-25 08:17:00	AAPL	Stock	30.07	30.07	30.06	30.06	2660.0
2017-01-25 08:18:00	AAPL	Stock	30.0625	30.0625	30.0625	30.0625	3548.0
2017-01-25 08:23:00	AAPL	Stock	30.0625	30.0625	30.0625	30.0625	800.0
2017-01-25 08:24:00	AAPL	Stock	30.0625	30.0625	30.0575	30.0575	8316.0
2017-01-25 08:25:00	AAPL	Stock	30.0575	30.0575	30.0575	30.0575	1840.0
2017-01-25 08:26:00	AAPL	Stock	30.0575	30.0575	30.0575	30.0575	2372.0

> showing 50 of 1,056,729 rows — these rows as CSV

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