PREVIEW / etf_1min / 2018-08-21

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-08-21.parquet
  size:    3.0 MB
  rows:    153,732

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-21 04:04:00	SPY	ETF	285.98	285.98	285.98	285.98	100.0
2018-08-21 04:05:00	SPY	ETF	285.96	285.96	285.94	285.96	800.0
2018-08-21 04:06:00	SPY	ETF	285.94	285.96	285.94	285.96	625.0
2018-08-21 04:09:00	SPY	ETF	285.93	285.93	285.93	285.93	100.0
2018-08-21 04:12:00	SPY	ETF	285.92	285.92	285.92	285.92	719.0
2018-08-21 04:13:00	SPY	ETF	285.91	285.91	285.91	285.91	400.0
2018-08-21 04:14:00	SPY	ETF	285.9	285.9	285.9	285.9	200.0
2018-08-21 04:17:00	SPY	ETF	285.95	285.95	285.95	285.95	100.0
2018-08-21 04:18:00	SPY	ETF	285.94	285.94	285.94	285.94	300.0
2018-08-21 04:25:00	SPY	ETF	285.94	285.94	285.94	285.94	300.0
2018-08-21 04:28:00	SPY	ETF	285.94	285.94	285.94	285.94	600.0
2018-08-21 04:30:00	SPY	ETF	285.98	285.98	285.98	285.98	100.0
2018-08-21 04:34:00	SPY	ETF	286.0	286.0	286.0	286.0	400.0
2018-08-21 04:35:00	SPY	ETF	285.99	285.99	285.97	285.97	400.0
2018-08-21 04:36:00	SPY	ETF	285.97	285.99	285.97	285.97	700.0
2018-08-21 04:38:00	SPY	ETF	286.0	286.0	286.0	286.0	100.0
2018-08-21 04:39:00	SPY	ETF	286.0	286.0	286.0	286.0	300.0
2018-08-21 04:40:00	SPY	ETF	285.99	285.99	285.99	285.99	300.0
2018-08-21 04:45:00	SPY	ETF	286.0	286.0	286.0	286.0	100.0
2018-08-21 04:46:00	SPY	ETF	286.0	286.0	286.0	286.0	309.0
2018-08-21 04:48:00	SPY	ETF	286.0	286.0	285.99	285.99	300.0
2018-08-21 04:55:00	SPY	ETF	285.99	286.02	285.99	286.02	932.0
2018-08-21 04:57:00	SPY	ETF	286.05	286.05	286.05	286.05	100.0
2018-08-21 05:01:00	SPY	ETF	286.1	286.13	286.1	286.13	381.0
2018-08-21 05:02:00	SPY	ETF	286.13	286.13	286.13	286.13	252.0
2018-08-21 05:07:00	SPY	ETF	286.07	286.07	286.07	286.07	2500.0
2018-08-21 05:08:00	SPY	ETF	286.07	286.07	286.07	286.07	300.0
2018-08-21 05:09:00	SPY	ETF	286.06	286.06	286.06	286.06	128.0
2018-08-21 05:10:00	SPY	ETF	286.07	286.09	286.07	286.09	2600.0
2018-08-21 05:12:00	SPY	ETF	286.06	286.06	286.06	286.06	300.0
2018-08-21 05:13:00	SPY	ETF	286.06	286.06	286.06	286.06	200.0
2018-08-21 05:15:00	SPY	ETF	286.16	286.16	286.16	286.16	100.0
2018-08-21 05:21:00	SPY	ETF	286.16	286.19	286.16	286.19	400.0
2018-08-21 05:23:00	SPY	ETF	286.22	286.22	286.22	286.22	100.0
2018-08-21 05:33:00	SPY	ETF	286.25	286.25	286.25	286.25	1000.0
2018-08-21 05:35:00	SPY	ETF	286.19	286.19	286.19	286.19	300.0
2018-08-21 05:38:00	SPY	ETF	286.16	286.16	286.16	286.16	310.0
2018-08-21 05:39:00	SPY	ETF	286.14	286.14	286.14	286.14	300.0
2018-08-21 05:43:00	SPY	ETF	286.15	286.15	286.15	286.15	100.0
2018-08-21 05:45:00	SPY	ETF	286.18	286.18	286.18	286.18	100.0
2018-08-21 05:54:00	SPY	ETF	286.13	286.13	286.13	286.13	1800.0
2018-08-21 05:55:00	SPY	ETF	286.16	286.18	286.16	286.18	200.0
2018-08-21 05:59:00	SPY	ETF	286.29	286.33	286.29	286.33	2427.0
2018-08-21 06:04:00	SPY	ETF	286.28	286.33	286.28	286.33	1730.0
2018-08-21 06:11:00	SPY	ETF	286.28	286.28	286.28	286.28	500.0
2018-08-21 06:13:00	SPY	ETF	286.25	286.25	286.25	286.25	1500.0
2018-08-21 06:16:00	SPY	ETF	286.21	286.21	286.21	286.21	300.0
2018-08-21 06:17:00	SPY	ETF	286.25	286.25	286.21	286.21	800.0
2018-08-21 06:19:00	SPY	ETF	286.23	286.23	286.23	286.23	300.0
2018-08-21 06:20:00	SPY	ETF	286.28	286.28	286.28	286.28	100.0

> showing 50 of 153,732 rows — these rows as CSV

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