PREVIEW / etf_1min / 2019-01-10

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-01-10.parquet
  size:    3.4 MB
  rows:    177,907

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-01-10 04:00:00	SPY	ETF	255.92	255.92	255.92	255.92	273.0
2019-01-10 04:01:00	SPY	ETF	255.83	255.87	255.78	255.87	775.0
2019-01-10 04:02:00	SPY	ETF	255.9	255.9	255.81	255.81	425.0
2019-01-10 04:03:00	SPY	ETF	255.86	255.92	255.86	255.92	2019.0
2019-01-10 04:04:00	SPY	ETF	255.91	255.92	255.91	255.92	225.0
2019-01-10 04:05:00	SPY	ETF	255.94	255.97	255.94	255.97	429.0
2019-01-10 04:06:00	SPY	ETF	255.96	255.96	255.96	255.96	200.0
2019-01-10 04:08:00	SPY	ETF	255.84	255.84	255.84	255.84	179.0
2019-01-10 04:09:00	SPY	ETF	255.85	255.88	255.85	255.88	507.0
2019-01-10 04:10:00	SPY	ETF	255.92	256.0	255.92	256.0	5490.0
2019-01-10 04:11:00	SPY	ETF	255.94	255.94	255.9	255.92	2069.0
2019-01-10 04:12:00	SPY	ETF	255.88	255.88	255.86	255.86	969.0
2019-01-10 04:13:00	SPY	ETF	255.86	255.86	255.84	255.84	1400.0
2019-01-10 04:14:00	SPY	ETF	255.8	255.8	255.74	255.74	1507.0
2019-01-10 04:15:00	SPY	ETF	255.87	255.92	255.87	255.92	1069.0
2019-01-10 04:16:00	SPY	ETF	255.88	255.88	255.88	255.88	369.0
2019-01-10 04:17:00	SPY	ETF	255.92	255.93	255.92	255.93	269.0
2019-01-10 04:18:00	SPY	ETF	255.88	255.88	255.88	255.88	679.0
2019-01-10 04:19:00	SPY	ETF	255.86	255.88	255.84	255.85	2669.0
2019-01-10 04:20:00	SPY	ETF	255.92	255.93	255.92	255.93	469.0
2019-01-10 04:21:00	SPY	ETF	255.91	255.93	255.84	255.84	1812.0
2019-01-10 04:22:00	SPY	ETF	255.89	255.89	255.86	255.86	1500.0
2019-01-10 04:23:00	SPY	ETF	255.91	255.99	255.91	255.99	1607.0
2019-01-10 04:24:00	SPY	ETF	255.98	256.02	255.98	255.98	1838.0
2019-01-10 04:25:00	SPY	ETF	255.94	255.94	255.91	255.91	1138.0
2019-01-10 04:27:00	SPY	ETF	255.99	255.99	255.92	255.92	900.0
2019-01-10 04:28:00	SPY	ETF	256.0	256.09	256.0	256.09	3138.0
2019-01-10 04:29:00	SPY	ETF	256.06	256.16	256.06	256.16	1877.0
2019-01-10 04:30:00	SPY	ETF	256.13	256.13	256.1	256.1	1169.0
2019-01-10 04:31:00	SPY	ETF	256.14	256.15	256.14	256.15	469.0
2019-01-10 04:32:00	SPY	ETF	256.11	256.11	256.04	256.04	1407.0
2019-01-10 04:33:00	SPY	ETF	256.04	256.04	256.0	256.0	838.0
2019-01-10 04:37:00	SPY	ETF	256.02	256.05	256.02	256.05	969.0
2019-01-10 04:38:00	SPY	ETF	256.1	256.15	256.1	256.15	738.0
2019-01-10 04:39:00	SPY	ETF	256.2	256.2	256.2	256.2	179.0
2019-01-10 04:40:00	SPY	ETF	256.21	256.26	256.18	256.26	4069.0
2019-01-10 04:42:00	SPY	ETF	256.2	256.2	256.2	256.2	369.0
2019-01-10 04:44:00	SPY	ETF	256.21	256.21	256.21	256.21	300.0
2019-01-10 04:47:00	SPY	ETF	256.15	256.2	256.15	256.2	738.0
2019-01-10 04:50:00	SPY	ETF	256.21	256.3	256.21	256.3	1472.0
2019-01-10 04:53:00	SPY	ETF	256.23	256.23	256.1	256.1	1576.0
2019-01-10 04:56:00	SPY	ETF	256.1	256.1	256.1	256.1	219.0
2019-01-10 04:57:00	SPY	ETF	256.07	256.07	256.05	256.05	538.0
2019-01-10 04:59:00	SPY	ETF	256.03	256.03	256.0	256.0	738.0
2019-01-10 05:00:00	SPY	ETF	256.06	256.06	256.06	256.06	300.0
2019-01-10 05:01:00	SPY	ETF	256.1	256.1	256.1	256.1	369.0
2019-01-10 05:02:00	SPY	ETF	256.2	256.2	256.2	256.2	369.0
2019-01-10 05:03:00	SPY	ETF	256.21	256.21	256.21	256.21	369.0
2019-01-10 05:05:00	SPY	ETF	256.15	256.15	256.15	256.15	300.0
2019-01-10 05:06:00	SPY	ETF	256.25	256.25	256.25	256.25	569.0

> showing 50 of 177,907 rows — these rows as CSV

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