PREVIEW / etf_1min / 2019-01-31

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-01-31.parquet
  size:    3.5 MB
  rows:    185,588

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-31 04:00:00	SPY	ETF	268.16	268.16	268.14	268.14	5825.0
2019-01-31 04:12:00	SPY	ETF	268.29	268.32	268.26	268.32	1269.0
2019-01-31 04:13:00	SPY	ETF	268.32	268.32	268.29	268.29	800.0
2019-01-31 04:14:00	SPY	ETF	268.33	268.39	268.33	268.34	2701.0
2019-01-31 04:19:00	SPY	ETF	268.28	268.28	268.25	268.25	1000.0
2019-01-31 04:21:00	SPY	ETF	268.2	268.2	268.2	268.2	100.0
2019-01-31 04:24:00	SPY	ETF	268.18	268.19	268.18	268.19	1000.0
2019-01-31 04:26:00	SPY	ETF	268.18	268.19	268.18	268.19	1000.0
2019-01-31 04:27:00	SPY	ETF	268.18	268.18	268.18	268.18	500.0
2019-01-31 04:28:00	SPY	ETF	268.1	268.1	268.1	268.1	400.0
2019-01-31 04:29:00	SPY	ETF	268.1	268.1	268.1	268.1	230.0
2019-01-31 04:30:00	SPY	ETF	268.1	268.1	268.1	268.1	500.0
2019-01-31 04:31:00	SPY	ETF	268.04	268.04	268.04	268.04	300.0
2019-01-31 04:35:00	SPY	ETF	268.1	268.1	268.1	268.1	518.0
2019-01-31 04:41:00	SPY	ETF	268.09	268.09	268.07	268.07	500.0
2019-01-31 04:43:00	SPY	ETF	268.14	268.14	268.14	268.14	500.0
2019-01-31 04:48:00	SPY	ETF	268.15	268.15	268.15	268.15	3500.0
2019-01-31 04:50:00	SPY	ETF	268.08	268.08	268.05	268.05	400.0
2019-01-31 05:00:00	SPY	ETF	268.01	268.01	267.97	267.97	805.0
2019-01-31 05:01:00	SPY	ETF	267.95	267.95	267.92	267.93	1800.0
2019-01-31 05:02:00	SPY	ETF	267.92	267.92	267.92	267.92	450.0
2019-01-31 05:03:00	SPY	ETF	267.93	267.93	267.93	267.93	400.0
2019-01-31 05:04:00	SPY	ETF	267.93	267.93	267.93	267.93	240.0
2019-01-31 05:05:00	SPY	ETF	267.93	267.93	267.93	267.93	240.0
2019-01-31 05:06:00	SPY	ETF	268.0	268.0	268.0	268.0	571.0
2019-01-31 05:07:00	SPY	ETF	268.0	268.0	268.0	268.0	120.0
2019-01-31 05:08:00	SPY	ETF	267.91	267.91	267.91	267.91	100.0
2019-01-31 05:09:00	SPY	ETF	267.9	267.9	267.9	267.9	200.0
2019-01-31 05:10:00	SPY	ETF	267.9	267.9	267.86	267.86	1000.0
2019-01-31 05:11:00	SPY	ETF	267.9	267.9	267.9	267.9	1000.0
2019-01-31 05:12:00	SPY	ETF	267.9	267.93	267.9	267.93	395.0
2019-01-31 05:18:00	SPY	ETF	268.0	268.0	268.0	268.0	500.0
2019-01-31 05:20:00	SPY	ETF	268.03	268.03	268.03	268.03	385.0
2019-01-31 05:21:00	SPY	ETF	268.04	268.04	268.02	268.02	300.0
2019-01-31 05:25:00	SPY	ETF	267.87	267.87	267.87	267.87	400.0
2019-01-31 05:27:00	SPY	ETF	267.85	267.85	267.79	267.79	960.0
2019-01-31 05:33:00	SPY	ETF	267.78	267.82	267.78	267.82	400.0
2019-01-31 05:34:00	SPY	ETF	267.91	267.91	267.91	267.91	1000.0
2019-01-31 05:35:00	SPY	ETF	267.9	267.9	267.89	267.89	200.0
2019-01-31 05:38:00	SPY	ETF	268.18	268.19	268.18	268.19	1000.0
2019-01-31 05:39:00	SPY	ETF	268.16	268.16	268.16	268.16	100.0
2019-01-31 05:40:00	SPY	ETF	268.1	268.1	268.1	268.1	100.0
2019-01-31 05:44:00	SPY	ETF	268.09	268.09	268.07	268.07	254.0
2019-01-31 05:48:00	SPY	ETF	268.13	268.13	268.13	268.13	210.0
2019-01-31 05:49:00	SPY	ETF	268.11	268.11	268.11	268.11	100.0
2019-01-31 05:50:00	SPY	ETF	268.1	268.1	268.1	268.1	1000.0
2019-01-31 05:51:00	SPY	ETF	268.07	268.07	268.01	268.01	1400.0
2019-01-31 05:53:00	SPY	ETF	268.0	268.0	267.94	267.94	800.0
2019-01-31 05:55:00	SPY	ETF	268.0	268.0	268.0	268.0	300.0
2019-01-31 05:58:00	SPY	ETF	268.0	268.0	268.0	268.0	300.0

> showing 50 of 185,588 rows — these rows as CSV

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