PREVIEW / etf_1min / 2017-05-18

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-05-18.parquet
  size:    3.0 MB
  rows:    154,512

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-18 04:00:00	SPY	ETF	236.11	236.15	236.11	236.15	18525.0
2017-05-18 04:01:00	SPY	ETF	236.19	236.19	236.19	236.19	1050.0
2017-05-18 04:03:00	SPY	ETF	236.14	236.24	236.1	236.1	10250.0
2017-05-18 04:04:00	SPY	ETF	236.09	236.09	236.09	236.09	400.0
2017-05-18 04:05:00	SPY	ETF	236.04	236.04	236.02	236.02	11020.0
2017-05-18 04:06:00	SPY	ETF	236.09	236.09	236.09	236.09	300.0
2017-05-18 04:07:00	SPY	ETF	236.05	236.1	236.01	236.1	7800.0
2017-05-18 04:09:00	SPY	ETF	236.12	236.12	236.12	236.12	1600.0
2017-05-18 04:10:00	SPY	ETF	236.12	236.12	236.12	236.12	300.0
2017-05-18 04:13:00	SPY	ETF	236.03	236.08	236.01	236.04	19300.0
2017-05-18 04:14:00	SPY	ETF	235.99	235.99	235.99	235.99	2000.0
2017-05-18 04:15:00	SPY	ETF	235.98	236.0	235.98	236.0	6610.0
2017-05-18 04:16:00	SPY	ETF	235.99	235.99	235.99	235.99	301.0
2017-05-18 04:18:00	SPY	ETF	235.97	235.97	235.97	235.97	101.0
2017-05-18 04:19:00	SPY	ETF	235.94	235.94	235.93	235.93	1103.0
2017-05-18 04:22:00	SPY	ETF	235.92	235.92	235.92	235.92	102.0
2017-05-18 04:23:00	SPY	ETF	235.92	235.92	235.9	235.92	4002.0
2017-05-18 04:24:00	SPY	ETF	235.93	235.95	235.93	235.95	5225.0
2017-05-18 04:25:00	SPY	ETF	235.96	235.96	235.96	235.96	320.0
2017-05-18 04:26:00	SPY	ETF	235.96	236.0	235.96	236.0	5902.0
2017-05-18 04:28:00	SPY	ETF	236.06	236.06	236.06	236.06	300.0
2017-05-18 04:29:00	SPY	ETF	236.07	236.08	236.07	236.08	501.0
2017-05-18 04:30:00	SPY	ETF	236.08	236.1	236.08	236.1	1105.0
2017-05-18 04:31:00	SPY	ETF	236.17	236.17	236.17	236.17	300.0
2017-05-18 04:32:00	SPY	ETF	236.16	236.16	236.16	236.16	599.0
2017-05-18 04:33:00	SPY	ETF	236.17	236.17	236.16	236.17	837.0
2017-05-18 04:34:00	SPY	ETF	236.25	236.25	236.23	236.23	502.0
2017-05-18 04:35:00	SPY	ETF	236.21	236.21	236.21	236.21	200.0
2017-05-18 04:36:00	SPY	ETF	236.25	236.25	236.25	236.25	700.0
2017-05-18 04:38:00	SPY	ETF	236.2	236.27	236.2	236.27	822.0
2017-05-18 04:39:00	SPY	ETF	236.2	236.2	236.2	236.2	1508.0
2017-05-18 04:43:00	SPY	ETF	236.2	236.2	236.2	236.2	202.0
2017-05-18 04:45:00	SPY	ETF	236.16	236.16	236.16	236.16	103.0
2017-05-18 04:46:00	SPY	ETF	236.15	236.15	236.15	236.15	303.0
2017-05-18 04:48:00	SPY	ETF	236.17	236.17	236.17	236.17	100.0
2017-05-18 04:51:00	SPY	ETF	236.11	236.11	236.11	236.11	1023.0
2017-05-18 04:53:00	SPY	ETF	236.22	236.22	236.22	236.22	100.0
2017-05-18 04:55:00	SPY	ETF	236.19	236.2	236.19	236.2	1121.0
2017-05-18 04:56:00	SPY	ETF	236.19	236.19	236.15	236.15	1208.0
2017-05-18 04:58:00	SPY	ETF	236.22	236.22	236.22	236.22	205.0
2017-05-18 04:59:00	SPY	ETF	236.29	236.29	236.29	236.29	10002.0
2017-05-18 05:00:00	SPY	ETF	236.15	236.26	236.15	236.17	1440.0
2017-05-18 05:01:00	SPY	ETF	236.1	236.1	236.1	236.1	1006.0
2017-05-18 05:03:00	SPY	ETF	235.88	236.11	235.88	236.11	1778.0
2017-05-18 05:04:00	SPY	ETF	236.02	236.02	235.97	235.97	1106.0
2017-05-18 05:05:00	SPY	ETF	235.95	235.95	235.93	235.93	1115.0
2017-05-18 05:06:00	SPY	ETF	235.88	235.88	235.72	235.72	8871.0
2017-05-18 05:08:00	SPY	ETF	235.67	235.73	235.67	235.69	10309.0
2017-05-18 05:10:00	SPY	ETF	235.74	235.84	235.74	235.81	3354.0
2017-05-18 05:11:00	SPY	ETF	235.76	235.76	235.76	235.76	105.0

> showing 50 of 154,512 rows — these rows as CSV

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