PREVIEW / etf_1min / 2019-06-21

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-06-21.parquet
  size:    3.1 MB
  rows:    165,605

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
2019-06-21 04:00:00	SPY	ETF	294.37	294.37	294.37	294.37	446.0
2019-06-21 04:01:00	SPY	ETF	294.37	294.37	294.26	294.26	201.0
2019-06-21 04:02:00	SPY	ETF	294.26	294.26	294.15	294.17	800.0
2019-06-21 04:03:00	SPY	ETF	294.17	294.17	294.04	294.04	931.0
2019-06-21 04:04:00	SPY	ETF	294.09	294.13	294.09	294.13	510.0
2019-06-21 04:05:00	SPY	ETF	294.11	294.11	294.08	294.1	400.0
2019-06-21 04:06:00	SPY	ETF	294.13	294.19	294.13	294.19	5000.0
2019-06-21 04:07:00	SPY	ETF	294.21	294.21	294.21	294.21	225.0
2019-06-21 04:08:00	SPY	ETF	294.21	294.29	294.21	294.26	855.0
2019-06-21 04:09:00	SPY	ETF	294.21	294.21	294.19	294.19	300.0
2019-06-21 04:12:00	SPY	ETF	294.23	294.23	294.23	294.23	110.0
2019-06-21 04:13:00	SPY	ETF	294.26	294.29	294.26	294.29	300.0
2019-06-21 04:15:00	SPY	ETF	294.28	294.28	294.28	294.28	100.0
2019-06-21 04:17:00	SPY	ETF	294.27	294.27	294.22	294.24	1073.0
2019-06-21 04:20:00	SPY	ETF	294.24	294.26	294.24	294.26	300.0
2019-06-21 04:21:00	SPY	ETF	294.2	294.2	294.2	294.2	150.0
2019-06-21 04:22:00	SPY	ETF	294.24	294.24	294.24	294.24	100.0
2019-06-21 04:23:00	SPY	ETF	294.21	294.21	294.16	294.16	1400.0
2019-06-21 04:24:00	SPY	ETF	294.11	294.16	294.11	294.16	600.0
2019-06-21 04:29:00	SPY	ETF	294.19	294.19	294.19	294.19	300.0
2019-06-21 04:31:00	SPY	ETF	294.2	294.24	294.2	294.24	500.0
2019-06-21 04:32:00	SPY	ETF	294.29	294.29	294.29	294.29	100.0
2019-06-21 04:34:00	SPY	ETF	294.24	294.24	294.24	294.24	300.0
2019-06-21 04:35:00	SPY	ETF	294.22	294.24	294.22	294.24	400.0
2019-06-21 04:37:00	SPY	ETF	294.2	294.2	294.2	294.2	200.0
2019-06-21 04:38:00	SPY	ETF	294.2	294.22	294.2	294.22	500.0
2019-06-21 04:39:00	SPY	ETF	294.17	294.17	294.17	294.17	400.0
2019-06-21 04:42:00	SPY	ETF	294.17	294.17	294.17	294.17	388.0
2019-06-21 04:44:00	SPY	ETF	294.1	294.1	294.1	294.1	601.0
2019-06-21 04:45:00	SPY	ETF	294.03	294.03	294.02	294.02	200.0
2019-06-21 04:48:00	SPY	ETF	294.11	294.11	294.06	294.06	2700.0
2019-06-21 04:51:00	SPY	ETF	294.05	294.05	294.05	294.05	600.0
2019-06-21 04:53:00	SPY	ETF	294.0	294.0	293.95	293.95	1225.0
2019-06-21 05:00:00	SPY	ETF	293.99	293.99	293.99	293.99	300.0
2019-06-21 05:01:00	SPY	ETF	293.97	293.97	293.97	293.97	400.0
2019-06-21 05:02:00	SPY	ETF	293.97	294.04	293.97	294.04	12000.0
2019-06-21 05:04:00	SPY	ETF	294.04	294.04	294.04	294.04	2000.0
2019-06-21 05:13:00	SPY	ETF	294.02	294.02	294.02	294.02	6000.0
2019-06-21 05:20:00	SPY	ETF	294.05	294.14	294.05	294.14	600.0
2019-06-21 05:21:00	SPY	ETF	294.16	294.16	294.16	294.16	300.0
2019-06-21 05:22:00	SPY	ETF	294.17	294.17	294.17	294.17	470.0
2019-06-21 05:23:00	SPY	ETF	294.17	294.17	294.17	294.17	300.0
2019-06-21 05:24:00	SPY	ETF	294.14	294.17	294.14	294.17	1700.0
2019-06-21 05:26:00	SPY	ETF	294.25	294.25	294.25	294.25	100.0
2019-06-21 05:31:00	SPY	ETF	294.32	294.32	294.32	294.32	100.0
2019-06-21 05:37:00	SPY	ETF	294.04	294.04	294.04	294.04	300.0
2019-06-21 05:38:00	SPY	ETF	294.07	294.07	294.07	294.07	100.0
2019-06-21 05:40:00	SPY	ETF	294.1	294.1	294.1	294.1	100.0
2019-06-21 05:42:00	SPY	ETF	294.07	294.07	294.07	294.07	300.0
2019-06-21 05:50:00	SPY	ETF	293.96	294.0	293.85	294.0	9677.0

> showing 50 of 165,605 rows — these rows as CSV

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