PREVIEW / etf_1min / 2017-05-24

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-05-24.parquet
  size:    2.6 MB
  rows:    133,448

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-05-24 04:12:00	SPY	ETF	240.1	240.1	240.1	240.1	310.0
2017-05-24 04:22:00	SPY	ETF	240.12	240.12	240.12	240.12	500.0
2017-05-24 04:24:00	SPY	ETF	240.17	240.17	240.17	240.17	500.0
2017-05-24 04:36:00	SPY	ETF	240.19	240.19	240.19	240.19	4000.0
2017-05-24 05:17:00	SPY	ETF	240.17	240.17	240.17	240.17	800.0
2017-05-24 05:35:00	SPY	ETF	240.12	240.12	240.12	240.12	333.0
2017-05-24 05:51:00	SPY	ETF	240.17	240.2	240.17	240.2	5200.0
2017-05-24 06:20:00	SPY	ETF	240.16	240.21	240.16	240.2	96100.0
2017-05-24 06:21:00	SPY	ETF	240.2	240.2	240.14	240.15	6300.0
2017-05-24 06:28:00	SPY	ETF	240.15	240.15	240.15	240.15	200.0
2017-05-24 06:42:00	SPY	ETF	240.07	240.07	240.07	240.07	500.0
2017-05-24 06:48:00	SPY	ETF	240.05	240.05	240.05	240.05	599.0
2017-05-24 06:49:00	SPY	ETF	240.07	240.07	240.07	240.07	100.0
2017-05-24 06:53:00	SPY	ETF	240.07	240.07	240.07	240.07	100.0
2017-05-24 06:56:00	SPY	ETF	240.06	240.06	240.06	240.06	326.0
2017-05-24 06:57:00	SPY	ETF	240.06	240.06	240.06	240.06	175.0
2017-05-24 07:00:00	SPY	ETF	240.02	240.02	240.02	240.02	1301.0
2017-05-24 07:02:00	SPY	ETF	240.04	240.05	240.04	240.05	1151.0
2017-05-24 07:05:00	SPY	ETF	240.07	240.07	240.07	240.07	5927.0
2017-05-24 07:06:00	SPY	ETF	240.07	240.07	240.07	240.07	100.0
2017-05-24 07:12:00	SPY	ETF	240.06	240.06	240.06	240.06	100.0
2017-05-24 07:13:00	SPY	ETF	240.06	240.06	240.06	240.06	101.0
2017-05-24 07:24:00	SPY	ETF	240.1	240.1	240.1	240.1	6000.0
2017-05-24 07:25:00	SPY	ETF	240.1	240.11	240.1	240.11	6000.0
2017-05-24 07:28:00	SPY	ETF	240.08	240.08	240.08	240.08	101.0
2017-05-24 07:30:00	SPY	ETF	240.08	240.08	240.08	240.08	500.0
2017-05-24 07:33:00	SPY	ETF	240.09	240.09	240.08	240.08	800.0
2017-05-24 07:34:00	SPY	ETF	240.08	240.08	240.08	240.08	300.0
2017-05-24 07:35:00	SPY	ETF	240.08	240.08	240.08	240.08	200.0
2017-05-24 07:37:00	SPY	ETF	240.05	240.05	240.05	240.05	9951.0
2017-05-24 07:38:00	SPY	ETF	240.05	240.05	240.05	240.05	16000.0
2017-05-24 07:39:00	SPY	ETF	240.05	240.05	240.02	240.02	26450.0
2017-05-24 07:47:00	SPY	ETF	240.12	240.12	240.12	240.12	302.0
2017-05-24 07:48:00	SPY	ETF	240.1	240.12	240.1	240.12	2812.0
2017-05-24 07:49:00	SPY	ETF	240.1	240.1	240.1	240.1	1000.0
2017-05-24 07:50:00	SPY	ETF	240.11	240.11	240.1	240.1	2900.0
2017-05-24 07:51:00	SPY	ETF	240.1	240.1	240.1	240.1	400.0
2017-05-24 07:52:00	SPY	ETF	240.09	240.09	240.09	240.09	200.0
2017-05-24 07:54:00	SPY	ETF	240.1	240.11	240.09	240.11	8751.0
2017-05-24 07:55:00	SPY	ETF	240.12	240.12	240.1	240.1	1300.0
2017-05-24 07:56:00	SPY	ETF	240.12	240.12	240.12	240.12	3000.0
2017-05-24 07:57:00	SPY	ETF	240.11	240.13	240.11	240.13	500.0
2017-05-24 07:59:00	SPY	ETF	240.11	240.13	240.11	240.13	500.0
2017-05-24 08:00:00	SPY	ETF	240.07	240.13	240.03	240.13	3718.0
2017-05-24 08:01:00	SPY	ETF	240.13	240.13	240.13	240.13	637.0
2017-05-24 08:02:00	SPY	ETF	240.13	240.15	240.13	240.15	4407.0
2017-05-24 08:03:00	SPY	ETF	240.16	240.16	240.16	240.16	5044.0
2017-05-24 08:04:00	SPY	ETF	240.14	240.14	240.14	240.14	2170.0
2017-05-24 08:05:00	SPY	ETF	240.14	240.15	240.14	240.15	644.0
2017-05-24 08:07:00	SPY	ETF	240.15	240.15	240.15	240.15	200.0

> showing 50 of 133,448 rows — these rows as CSV

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