PREVIEW / etf_1min / 2018-08-01

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-08-01.parquet
  size:    2.9 MB
  rows:    150,389

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-08-01 04:09:00	SPY	ETF	281.37	281.37	281.37	281.37	300.0
2018-08-01 04:11:00	SPY	ETF	281.4	281.4	281.4	281.4	100.0
2018-08-01 04:12:00	SPY	ETF	281.46	281.5	281.46	281.46	900.0
2018-08-01 04:18:00	SPY	ETF	281.29	281.29	281.29	281.29	700.0
2018-08-01 04:19:00	SPY	ETF	281.29	281.29	281.28	281.28	4200.0
2018-08-01 04:20:00	SPY	ETF	281.23	281.23	281.21	281.21	972.0
2018-08-01 04:21:00	SPY	ETF	281.16	281.16	281.16	281.16	400.0
2018-08-01 04:22:00	SPY	ETF	281.16	281.16	281.16	281.16	721.0
2018-08-01 04:25:00	SPY	ETF	281.23	281.23	281.23	281.23	300.0
2018-08-01 04:27:00	SPY	ETF	281.29	281.29	281.29	281.29	100.0
2018-08-01 04:34:00	SPY	ETF	281.29	281.29	281.24	281.27	2000.0
2018-08-01 04:35:00	SPY	ETF	281.29	281.29	281.29	281.29	700.0
2018-08-01 04:41:00	SPY	ETF	281.21	281.21	281.21	281.21	115.0
2018-08-01 04:42:00	SPY	ETF	281.21	281.21	281.21	281.21	300.0
2018-08-01 04:44:00	SPY	ETF	281.21	281.21	281.21	281.21	1500.0
2018-08-01 04:48:00	SPY	ETF	281.13	281.13	281.13	281.13	300.0
2018-08-01 04:54:00	SPY	ETF	281.21	281.21	281.21	281.21	300.0
2018-08-01 05:09:00	SPY	ETF	281.11	281.11	281.11	281.11	300.0
2018-08-01 05:10:00	SPY	ETF	281.06	281.06	280.98	280.98	902.0
2018-08-01 05:11:00	SPY	ETF	280.98	281.01	280.98	281.01	900.0
2018-08-01 05:18:00	SPY	ETF	281.0	281.0	281.0	281.0	1000.0
2018-08-01 05:23:00	SPY	ETF	280.96	280.96	280.96	280.96	302.0
2018-08-01 05:30:00	SPY	ETF	280.91	280.91	280.91	280.91	500.0
2018-08-01 05:32:00	SPY	ETF	280.93	280.93	280.93	280.93	300.0
2018-08-01 05:34:00	SPY	ETF	280.96	280.96	280.96	280.96	100.0
2018-08-01 05:35:00	SPY	ETF	280.95	280.95	280.95	280.95	100.0
2018-08-01 05:37:00	SPY	ETF	280.94	280.94	280.94	280.94	2000.0
2018-08-01 05:38:00	SPY	ETF	280.91	280.91	280.88	280.88	410.0
2018-08-01 05:41:00	SPY	ETF	280.91	280.96	280.91	280.96	900.0
2018-08-01 05:42:00	SPY	ETF	280.97	280.97	280.97	280.97	1000.0
2018-08-01 05:51:00	SPY	ETF	281.01	281.01	281.01	281.01	400.0
2018-08-01 05:52:00	SPY	ETF	280.96	280.96	280.96	280.96	300.0
2018-08-01 05:55:00	SPY	ETF	280.93	280.93	280.93	280.93	1660.0
2018-08-01 05:56:00	SPY	ETF	280.93	280.95	280.93	280.95	2400.0
2018-08-01 05:58:00	SPY	ETF	280.93	280.93	280.93	280.93	1200.0
2018-08-01 06:00:00	SPY	ETF	280.95	280.95	280.95	280.95	500.0
2018-08-01 06:03:00	SPY	ETF	280.95	280.99	280.95	280.99	600.0
2018-08-01 06:09:00	SPY	ETF	280.96	280.98	280.96	280.96	1800.0
2018-08-01 06:11:00	SPY	ETF	280.98	280.98	280.98	280.98	300.0
2018-08-01 06:13:00	SPY	ETF	280.98	281.03	280.98	281.03	1800.0
2018-08-01 06:14:00	SPY	ETF	281.05	281.06	281.05	281.05	3000.0
2018-08-01 06:15:00	SPY	ETF	281.11	281.11	281.11	281.11	2002.0
2018-08-01 06:17:00	SPY	ETF	281.06	281.06	281.06	281.06	1200.0
2018-08-01 06:18:00	SPY	ETF	281.06	281.06	281.06	281.06	740.0
2018-08-01 06:19:00	SPY	ETF	281.06	281.06	281.06	281.06	300.0
2018-08-01 06:20:00	SPY	ETF	281.09	281.09	281.09	281.09	300.0
2018-08-01 06:21:00	SPY	ETF	281.14	281.14	281.14	281.14	100.0
2018-08-01 06:25:00	SPY	ETF	281.08	281.08	281.08	281.08	1200.0
2018-08-01 06:26:00	SPY	ETF	281.18	281.18	281.18	281.18	100.0
2018-08-01 06:27:00	SPY	ETF	281.2	281.31	281.2	281.31	802.0

> showing 50 of 150,389 rows — these rows as CSV

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