PREVIEW / etf_1min / 2017-01-25

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-01-25.parquet
  size:    3.1 MB
  rows:    160,401

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	SPY	ETF	228.14	228.2	228.14	228.15	6150.0
2017-01-25 04:01:00	SPY	ETF	228.18	228.29	228.18	228.21	4800.0
2017-01-25 04:02:00	SPY	ETF	228.22	228.22	228.22	228.22	4050.0
2017-01-25 04:06:00	SPY	ETF	228.22	228.23	228.21	228.21	700.0
2017-01-25 04:13:00	SPY	ETF	228.21	228.21	228.21	228.21	5000.0
2017-01-25 04:14:00	SPY	ETF	228.19	228.19	228.19	228.19	400.0
2017-01-25 04:15:00	SPY	ETF	228.22	228.25	228.22	228.25	2700.0
2017-01-25 04:17:00	SPY	ETF	228.23	228.23	228.23	228.23	100.0
2017-01-25 04:18:00	SPY	ETF	228.21	228.21	228.21	228.21	100.0
2017-01-25 04:20:00	SPY	ETF	228.23	228.23	228.23	228.23	100.0
2017-01-25 04:24:00	SPY	ETF	228.22	228.22	228.22	228.22	1000.0
2017-01-25 04:25:00	SPY	ETF	228.24	228.24	228.24	228.24	1010.0
2017-01-25 04:27:00	SPY	ETF	228.23	228.27	228.23	228.27	2100.0
2017-01-25 04:32:00	SPY	ETF	228.21	228.21	228.21	228.21	200.0
2017-01-25 04:33:00	SPY	ETF	228.22	228.22	228.19	228.19	700.0
2017-01-25 04:35:00	SPY	ETF	228.22	228.22	228.22	228.22	300.0
2017-01-25 04:36:00	SPY	ETF	228.2	228.2	228.2	228.2	1925.0
2017-01-25 04:37:00	SPY	ETF	228.16	228.16	228.16	228.16	5000.0
2017-01-25 04:38:00	SPY	ETF	228.16	228.2	228.16	228.2	2100.0
2017-01-25 04:42:00	SPY	ETF	228.2	228.2	228.2	228.2	300.0
2017-01-25 05:06:00	SPY	ETF	228.03	228.03	228.03	228.03	100.0
2017-01-25 05:07:00	SPY	ETF	228.01	228.01	228.01	228.01	100.0
2017-01-25 05:08:00	SPY	ETF	228.01	228.01	228.01	228.01	5000.0
2017-01-25 05:09:00	SPY	ETF	228.04	228.04	228.04	228.04	100.0
2017-01-25 05:13:00	SPY	ETF	228.05	228.05	228.05	228.05	200.0
2017-01-25 05:14:00	SPY	ETF	228.03	228.03	228.03	228.03	100.0
2017-01-25 05:22:00	SPY	ETF	228.01	228.01	228.0	228.0	700.0
2017-01-25 05:26:00	SPY	ETF	228.0	228.0	228.0	228.0	600.0
2017-01-25 05:38:00	SPY	ETF	228.19	228.19	228.19	228.19	100.0
2017-01-25 05:42:00	SPY	ETF	228.13	228.13	228.13	228.13	1000.0
2017-01-25 05:43:00	SPY	ETF	228.13	228.15	228.13	228.15	4100.0
2017-01-25 05:44:00	SPY	ETF	228.13	228.15	228.13	228.15	702.0
2017-01-25 05:45:00	SPY	ETF	228.18	228.18	228.18	228.18	5000.0
2017-01-25 05:51:00	SPY	ETF	228.19	228.19	228.19	228.19	700.0
2017-01-25 05:55:00	SPY	ETF	228.14	228.14	228.14	228.14	2140.0
2017-01-25 05:56:00	SPY	ETF	228.15	228.15	228.15	228.15	2500.0
2017-01-25 05:58:00	SPY	ETF	228.14	228.14	228.14	228.14	860.0
2017-01-25 06:01:00	SPY	ETF	228.17	228.17	228.17	228.17	100.0
2017-01-25 06:03:00	SPY	ETF	228.14	228.14	228.14	228.14	1710.0
2017-01-25 06:05:00	SPY	ETF	228.15	228.15	228.15	228.15	3000.0
2017-01-25 06:06:00	SPY	ETF	228.14	228.14	228.13	228.13	790.0
2017-01-25 06:34:00	SPY	ETF	228.16	228.16	228.15	228.15	501.0
2017-01-25 06:45:00	SPY	ETF	228.12	228.12	228.1	228.1	5001.0
2017-01-25 06:46:00	SPY	ETF	228.12	228.12	228.11	228.11	400.0
2017-01-25 06:47:00	SPY	ETF	228.08	228.08	228.07	228.07	4700.0
2017-01-25 06:48:00	SPY	ETF	228.08	228.08	228.08	228.08	5000.0
2017-01-25 06:50:00	SPY	ETF	228.08	228.08	228.08	228.08	5000.0
2017-01-25 06:51:00	SPY	ETF	228.08	228.08	228.08	228.08	5100.0
2017-01-25 06:54:00	SPY	ETF	228.08	228.08	228.08	228.08	5000.0
2017-01-25 06:55:00	SPY	ETF	228.08	228.08	228.08	228.08	300.0

> showing 50 of 160,401 rows — these rows as CSV

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