PREVIEW / etf_1min / 2018-01-17

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-01-17.parquet
  size:    3.4 MB
  rows:    171,700

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-01-17 04:00:00	SPY	ETF	278.11	278.11	278.11	278.11	294.0
2018-01-17 04:01:00	SPY	ETF	278.12	278.14	278.12	278.14	28300.0
2018-01-17 04:02:00	SPY	ETF	278.08	278.08	278.08	278.08	122.0
2018-01-17 04:03:00	SPY	ETF	278.1	278.12	278.1	278.11	41400.0
2018-01-17 04:04:00	SPY	ETF	278.07	278.07	278.07	278.07	100.0
2018-01-17 04:05:00	SPY	ETF	278.08	278.11	278.08	278.11	2600.0
2018-01-17 04:06:00	SPY	ETF	278.08	278.09	278.08	278.09	1100.0
2018-01-17 04:07:00	SPY	ETF	278.09	278.11	278.09	278.11	1300.0
2018-01-17 04:08:00	SPY	ETF	278.11	278.11	278.11	278.11	1000.0
2018-01-17 04:09:00	SPY	ETF	278.11	278.11	278.11	278.11	300.0
2018-01-17 04:10:00	SPY	ETF	278.08	278.11	278.08	278.11	8400.0
2018-01-17 04:11:00	SPY	ETF	278.06	278.06	278.06	278.06	5300.0
2018-01-17 04:15:00	SPY	ETF	278.03	278.03	278.03	278.03	1000.0
2018-01-17 04:21:00	SPY	ETF	278.06	278.06	278.06	278.06	400.0
2018-01-17 04:22:00	SPY	ETF	278.06	278.06	278.06	278.06	353.0
2018-01-17 04:24:00	SPY	ETF	278.06	278.06	278.06	278.06	1000.0
2018-01-17 04:25:00	SPY	ETF	278.06	278.06	278.06	278.06	170.0
2018-01-17 04:26:00	SPY	ETF	278.06	278.06	278.06	278.06	500.0
2018-01-17 04:27:00	SPY	ETF	278.06	278.06	278.05	278.06	3376.0
2018-01-17 04:31:00	SPY	ETF	278.0	278.0	278.0	278.0	100.0
2018-01-17 04:33:00	SPY	ETF	278.04	278.04	278.04	278.04	300.0
2018-01-17 04:34:00	SPY	ETF	277.98	277.98	277.98	277.98	100.0
2018-01-17 04:40:00	SPY	ETF	278.04	278.04	278.04	278.04	200.0
2018-01-17 04:41:00	SPY	ETF	278.03	278.03	278.03	278.03	3000.0
2018-01-17 05:03:00	SPY	ETF	278.1	278.12	278.1	278.12	2100.0
2018-01-17 05:04:00	SPY	ETF	278.15	278.15	278.15	278.15	200.0
2018-01-17 05:05:00	SPY	ETF	278.12	278.12	278.12	278.12	500.0
2018-01-17 05:06:00	SPY	ETF	278.14	278.14	278.14	278.14	1100.0
2018-01-17 05:09:00	SPY	ETF	278.06	278.06	278.06	278.06	800.0
2018-01-17 05:10:00	SPY	ETF	278.04	278.04	278.04	278.04	400.0
2018-01-17 05:11:00	SPY	ETF	278.04	278.05	278.04	278.04	600.0
2018-01-17 05:15:00	SPY	ETF	278.12	278.12	278.12	278.12	5000.0
2018-01-17 05:16:00	SPY	ETF	278.1	278.1	278.1	278.1	100.0
2018-01-17 05:22:00	SPY	ETF	278.01	278.01	278.01	278.01	1100.0
2018-01-17 05:23:00	SPY	ETF	278.01	278.01	278.0	278.0	4899.0
2018-01-17 05:24:00	SPY	ETF	278.0	278.01	277.99	277.99	3600.0
2018-01-17 05:25:00	SPY	ETF	278.0	278.0	278.0	278.0	500.0
2018-01-17 05:29:00	SPY	ETF	277.98	277.98	277.98	277.98	100.0
2018-01-17 05:31:00	SPY	ETF	278.0	278.0	278.0	278.0	1500.0
2018-01-17 05:40:00	SPY	ETF	278.06	278.06	278.06	278.06	3000.0
2018-01-17 05:43:00	SPY	ETF	278.11	278.11	278.11	278.11	4501.0
2018-01-17 05:45:00	SPY	ETF	278.11	278.11	278.11	278.11	2002.0
2018-01-17 05:46:00	SPY	ETF	278.16	278.16	278.16	278.16	1502.0
2018-01-17 05:48:00	SPY	ETF	278.16	278.16	278.16	278.16	1507.0
2018-01-17 05:51:00	SPY	ETF	278.16	278.16	278.16	278.16	1203.0
2018-01-17 05:56:00	SPY	ETF	278.19	278.19	278.19	278.19	2527.0
2018-01-17 05:59:00	SPY	ETF	278.16	278.16	278.16	278.16	9515.0
2018-01-17 06:01:00	SPY	ETF	278.19	278.19	278.19	278.19	179.0
2018-01-17 06:03:00	SPY	ETF	278.21	278.21	278.21	278.21	404.0
2018-01-17 06:07:00	SPY	ETF	278.24	278.24	278.24	278.24	2301.0

> showing 50 of 171,700 rows — these rows as CSV

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