PREVIEW / etf_1min / 2017-07-20

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-07-20.parquet
  size:    2.6 MB
  rows:    134,244

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-07-20 04:00:00	SPY	ETF	247.1	247.26	247.1	247.26	746.0
2017-07-20 04:03:00	SPY	ETF	247.27	247.28	247.27	247.28	700.0
2017-07-20 04:06:00	SPY	ETF	247.27	247.27	247.27	247.27	500.0
2017-07-20 04:20:00	SPY	ETF	247.22	247.23	247.22	247.23	300.0
2017-07-20 04:23:00	SPY	ETF	247.21	247.21	247.21	247.21	100.0
2017-07-20 04:26:00	SPY	ETF	247.15	247.16	247.15	247.16	5700.0
2017-07-20 04:28:00	SPY	ETF	247.15	247.16	247.15	247.15	3101.0
2017-07-20 04:30:00	SPY	ETF	247.18	247.18	247.18	247.18	401.0
2017-07-20 04:31:00	SPY	ETF	247.16	247.26	247.16	247.21	16205.0
2017-07-20 04:34:00	SPY	ETF	247.24	247.24	247.24	247.24	300.0
2017-07-20 04:37:00	SPY	ETF	247.26	247.26	247.26	247.26	301.0
2017-07-20 04:46:00	SPY	ETF	247.24	247.24	247.24	247.24	300.0
2017-07-20 04:49:00	SPY	ETF	247.26	247.26	247.26	247.26	500.0
2017-07-20 05:00:00	SPY	ETF	247.11	247.11	247.11	247.11	500.0
2017-07-20 05:03:00	SPY	ETF	247.05	247.05	247.05	247.05	500.0
2017-07-20 05:05:00	SPY	ETF	247.08	247.08	247.08	247.08	100.0
2017-07-20 05:12:00	SPY	ETF	247.11	247.11	247.11	247.11	301.0
2017-07-20 05:31:00	SPY	ETF	247.16	247.16	247.16	247.16	299.0
2017-07-20 05:33:00	SPY	ETF	247.17	247.18	247.17	247.18	501.0
2017-07-20 05:35:00	SPY	ETF	247.19	247.19	247.19	247.19	304.0
2017-07-20 05:38:00	SPY	ETF	247.18	247.18	247.17	247.17	1021.0
2017-07-20 05:43:00	SPY	ETF	247.16	247.16	247.16	247.16	400.0
2017-07-20 05:46:00	SPY	ETF	247.16	247.16	247.16	247.16	400.0
2017-07-20 05:54:00	SPY	ETF	247.12	247.12	247.12	247.12	101.0
2017-07-20 06:00:00	SPY	ETF	247.12	247.12	247.12	247.12	100.0
2017-07-20 06:12:00	SPY	ETF	247.16	247.16	247.16	247.16	1100.0
2017-07-20 06:16:00	SPY	ETF	247.16	247.16	247.16	247.16	700.0
2017-07-20 06:19:00	SPY	ETF	247.14	247.14	247.14	247.14	200.0
2017-07-20 06:21:00	SPY	ETF	247.18	247.18	247.18	247.18	601.0
2017-07-20 06:22:00	SPY	ETF	247.18	247.18	247.18	247.18	300.0
2017-07-20 06:33:00	SPY	ETF	247.19	247.19	247.19	247.19	300.0
2017-07-20 06:47:00	SPY	ETF	247.1	247.12	247.1	247.12	1800.0
2017-07-20 06:48:00	SPY	ETF	247.14	247.14	247.12	247.12	500.0
2017-07-20 06:52:00	SPY	ETF	247.12	247.12	247.12	247.12	300.0
2017-07-20 06:54:00	SPY	ETF	247.12	247.12	247.12	247.12	300.0
2017-07-20 06:57:00	SPY	ETF	247.1	247.1	247.1	247.1	300.0
2017-07-20 07:03:00	SPY	ETF	247.08	247.08	247.08	247.08	299.0
2017-07-20 07:04:00	SPY	ETF	247.1	247.12	247.1	247.12	1740.0
2017-07-20 07:06:00	SPY	ETF	247.12	247.12	247.12	247.12	300.0
2017-07-20 07:18:00	SPY	ETF	247.1	247.1	247.1	247.1	609.0
2017-07-20 07:19:00	SPY	ETF	247.11	247.11	247.11	247.11	3491.0
2017-07-20 07:20:00	SPY	ETF	247.11	247.11	247.11	247.11	700.0
2017-07-20 07:21:00	SPY	ETF	247.1	247.11	247.1	247.11	1000.0
2017-07-20 07:25:00	SPY	ETF	247.1	247.1	247.1	247.1	600.0
2017-07-20 07:26:00	SPY	ETF	247.1	247.1	247.1	247.1	1601.0
2017-07-20 07:28:00	SPY	ETF	247.13	247.13	247.13	247.13	101.0
2017-07-20 07:31:00	SPY	ETF	247.14	247.16	247.14	247.16	564.0
2017-07-20 07:32:00	SPY	ETF	247.15	247.16	247.15	247.16	600.0
2017-07-20 07:33:00	SPY	ETF	247.15	247.15	247.13	247.13	300.0
2017-07-20 07:34:00	SPY	ETF	247.12	247.12	247.12	247.12	1501.0

> showing 50 of 134,244 rows — these rows as CSV

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