PREVIEW / etf_1min / 2018-08-29

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-08-29.parquet
  size:    2.9 MB
  rows:    147,854

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-29 04:07:00	SPY	ETF	290.15	290.21	290.15	290.21	600.0
2018-08-29 04:08:00	SPY	ETF	290.22	290.22	290.22	290.22	369.0
2018-08-29 04:09:00	SPY	ETF	290.22	290.22	290.22	290.22	400.0
2018-08-29 04:10:00	SPY	ETF	290.21	290.21	290.21	290.21	400.0
2018-08-29 04:17:00	SPY	ETF	290.22	290.22	290.22	290.22	300.0
2018-08-29 04:23:00	SPY	ETF	290.25	290.25	290.25	290.25	1202.0
2018-08-29 04:25:00	SPY	ETF	290.22	290.22	290.22	290.22	400.0
2018-08-29 04:28:00	SPY	ETF	290.2	290.2	290.2	290.2	100.0
2018-08-29 04:38:00	SPY	ETF	290.22	290.22	290.22	290.22	400.0
2018-08-29 04:52:00	SPY	ETF	290.17	290.17	290.17	290.17	300.0
2018-08-29 05:00:00	SPY	ETF	290.1	290.1	290.1	290.1	300.0
2018-08-29 05:03:00	SPY	ETF	290.15	290.15	290.15	290.15	500.0
2018-08-29 05:04:00	SPY	ETF	290.15	290.15	290.15	290.15	300.0
2018-08-29 05:05:00	SPY	ETF	290.15	290.15	290.15	290.15	1100.0
2018-08-29 05:15:00	SPY	ETF	290.15	290.15	290.15	290.15	400.0
2018-08-29 05:17:00	SPY	ETF	290.17	290.17	290.17	290.17	700.0
2018-08-29 05:21:00	SPY	ETF	290.22	290.22	290.22	290.22	300.0
2018-08-29 05:22:00	SPY	ETF	290.25	290.26	290.25	290.26	900.0
2018-08-29 05:23:00	SPY	ETF	290.22	290.22	290.22	290.22	2000.0
2018-08-29 05:25:00	SPY	ETF	290.2	290.2	290.2	290.2	800.0
2018-08-29 05:31:00	SPY	ETF	290.1	290.1	290.1	290.1	100.0
2018-08-29 05:38:00	SPY	ETF	290.07	290.07	290.02	290.02	3707.0
2018-08-29 05:43:00	SPY	ETF	289.94	289.97	289.94	289.94	2600.0
2018-08-29 05:45:00	SPY	ETF	289.97	289.97	289.97	289.97	600.0
2018-08-29 05:47:00	SPY	ETF	290.02	290.02	290.02	290.02	1200.0
2018-08-29 05:48:00	SPY	ETF	290.02	290.02	290.02	290.02	600.0
2018-08-29 05:51:00	SPY	ETF	290.02	290.02	290.02	290.02	500.0
2018-08-29 05:53:00	SPY	ETF	290.02	290.02	290.02	290.02	600.0
2018-08-29 06:00:00	SPY	ETF	290.02	290.02	290.02	290.02	2800.0
2018-08-29 06:01:00	SPY	ETF	290.02	290.02	290.02	290.02	200.0
2018-08-29 06:03:00	SPY	ETF	290.02	290.02	289.96	289.96	2700.0
2018-08-29 06:07:00	SPY	ETF	290.02	290.02	289.96	289.96	1100.0
2018-08-29 06:17:00	SPY	ETF	290.03	290.03	290.03	290.03	400.0
2018-08-29 06:18:00	SPY	ETF	290.02	290.02	290.01	290.01	900.0
2018-08-29 06:20:00	SPY	ETF	290.01	290.01	290.0	290.0	2100.0
2018-08-29 06:22:00	SPY	ETF	289.96	289.96	289.96	289.96	500.0
2018-08-29 06:23:00	SPY	ETF	289.92	289.92	289.92	289.92	1052.0
2018-08-29 06:33:00	SPY	ETF	289.96	289.96	289.96	289.96	600.0
2018-08-29 06:36:00	SPY	ETF	290.0	290.0	290.0	290.0	600.0
2018-08-29 06:38:00	SPY	ETF	289.97	289.97	289.97	289.97	100.0
2018-08-29 06:47:00	SPY	ETF	289.93	289.93	289.93	289.93	1000.0
2018-08-29 06:50:00	SPY	ETF	289.93	289.93	289.93	289.93	100.0
2018-08-29 06:51:00	SPY	ETF	289.93	289.93	289.93	289.93	500.0
2018-08-29 06:53:00	SPY	ETF	289.93	289.93	289.89	289.89	1000.0
2018-08-29 06:57:00	SPY	ETF	289.9	289.9	289.9	289.9	400.0
2018-08-29 07:01:00	SPY	ETF	289.94	289.95	289.94	289.95	4098.0
2018-08-29 07:03:00	SPY	ETF	289.98	289.98	289.98	289.98	122.0
2018-08-29 07:04:00	SPY	ETF	289.98	289.98	289.98	289.98	2083.0
2018-08-29 07:05:00	SPY	ETF	289.98	289.98	289.98	289.98	550.0
2018-08-29 07:06:00	SPY	ETF	289.97	289.97	289.97	289.97	3000.0

> showing 50 of 147,854 rows — these rows as CSV

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