PREVIEW / etf_1min / 2017-04-07

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-04-07.parquet
  size:    2.6 MB
  rows:    139,800

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-04-07 04:00:00	SPY	ETF	235.1	235.1	235.1	235.1	200.0
2017-04-07 04:04:00	SPY	ETF	235.15	235.15	235.15	235.15	400.0
2017-04-07 04:07:00	SPY	ETF	235.0	235.0	235.0	235.0	100.0
2017-04-07 04:20:00	SPY	ETF	235.03	235.03	235.0	235.0	1000.0
2017-04-07 04:23:00	SPY	ETF	234.99	234.99	234.96	234.96	200.0
2017-04-07 04:24:00	SPY	ETF	235.0	235.0	234.97	234.97	400.0
2017-04-07 04:27:00	SPY	ETF	234.96	234.96	234.96	234.96	600.0
2017-04-07 04:28:00	SPY	ETF	235.0	235.0	235.0	235.0	200.0
2017-04-07 04:32:00	SPY	ETF	234.99	234.99	234.91	234.91	3600.0
2017-04-07 04:37:00	SPY	ETF	234.92	234.92	234.92	234.92	1200.0
2017-04-07 04:41:00	SPY	ETF	235.12	235.12	235.12	235.12	1500.0
2017-04-07 04:46:00	SPY	ETF	235.1	235.1	235.1	235.1	100.0
2017-04-07 04:48:00	SPY	ETF	235.1	235.1	235.1	235.1	2000.0
2017-04-07 04:51:00	SPY	ETF	235.09	235.09	235.06	235.06	5000.0
2017-04-07 04:53:00	SPY	ETF	235.12	235.12	235.12	235.12	3000.0
2017-04-07 04:54:00	SPY	ETF	235.09	235.09	235.09	235.09	3000.0
2017-04-07 04:57:00	SPY	ETF	235.03	235.03	235.0	235.0	6500.0
2017-04-07 04:58:00	SPY	ETF	235.04	235.04	235.04	235.04	100.0
2017-04-07 04:59:00	SPY	ETF	235.04	235.04	235.04	235.04	100.0
2017-04-07 05:01:00	SPY	ETF	235.0	235.02	235.0	235.02	500.0
2017-04-07 05:06:00	SPY	ETF	234.95	234.95	234.95	234.95	500.0
2017-04-07 05:07:00	SPY	ETF	234.95	234.95	234.95	234.95	1000.0
2017-04-07 05:17:00	SPY	ETF	234.89	234.89	234.89	234.89	235.0
2017-04-07 05:20:00	SPY	ETF	234.82	234.82	234.82	234.82	1000.0
2017-04-07 05:21:00	SPY	ETF	234.8	234.8	234.8	234.8	110.0
2017-04-07 05:24:00	SPY	ETF	234.79	234.79	234.78	234.78	400.0
2017-04-07 05:26:00	SPY	ETF	234.76	234.76	234.76	234.76	100.0
2017-04-07 05:28:00	SPY	ETF	234.8	234.8	234.8	234.8	500.0
2017-04-07 05:32:00	SPY	ETF	234.7	234.7	234.7	234.7	210.0
2017-04-07 05:33:00	SPY	ETF	234.73	234.73	234.73	234.73	100.0
2017-04-07 05:34:00	SPY	ETF	234.71	234.71	234.71	234.71	100.0
2017-04-07 05:36:00	SPY	ETF	234.72	234.72	234.72	234.72	100.0
2017-04-07 05:37:00	SPY	ETF	234.7	234.7	234.7	234.7	300.0
2017-04-07 05:39:00	SPY	ETF	234.78	234.78	234.78	234.78	700.0
2017-04-07 05:40:00	SPY	ETF	234.78	234.78	234.78	234.78	1495.0
2017-04-07 05:42:00	SPY	ETF	234.8	234.8	234.8	234.8	300.0
2017-04-07 05:45:00	SPY	ETF	234.75	234.75	234.7	234.7	3600.0
2017-04-07 05:48:00	SPY	ETF	234.8	234.8	234.8	234.8	100.0
2017-04-07 06:03:00	SPY	ETF	234.91	234.91	234.9	234.9	372.0
2017-04-07 06:10:00	SPY	ETF	234.9	234.9	234.9	234.9	405.0
2017-04-07 06:11:00	SPY	ETF	234.9	234.9	234.9	234.9	21500.0
2017-04-07 06:12:00	SPY	ETF	234.9	234.9	234.85	234.85	3603.0
2017-04-07 06:13:00	SPY	ETF	234.89	234.89	234.83	234.83	1155.0
2017-04-07 06:14:00	SPY	ETF	234.86	234.86	234.86	234.86	1000.0
2017-04-07 06:18:00	SPY	ETF	234.92	234.92	234.92	234.92	596.0
2017-04-07 06:21:00	SPY	ETF	234.92	234.92	234.92	234.92	100.0
2017-04-07 06:22:00	SPY	ETF	234.95	234.95	234.95	234.95	151.0
2017-04-07 06:24:00	SPY	ETF	235.0	235.0	235.0	235.0	101.0
2017-04-07 06:25:00	SPY	ETF	235.0	235.01	235.0	235.0	1003.0
2017-04-07 06:29:00	SPY	ETF	235.04	235.04	235.04	235.04	100.0

> showing 50 of 139,800 rows — these rows as CSV

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