PREVIEW / etf_1min / 2017-11-21

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-11-21.parquet
  size:    2.7 MB
  rows:    144,511

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-11-21 04:04:00	SPY	ETF	258.27	258.27	258.27	258.27	500.0
2017-11-21 04:09:00	SPY	ETF	258.24	258.24	258.24	258.24	200.0
2017-11-21 04:17:00	SPY	ETF	258.2	258.2	258.2	258.2	100.0
2017-11-21 04:21:00	SPY	ETF	258.24	258.24	258.24	258.24	300.0
2017-11-21 04:32:00	SPY	ETF	258.35	258.35	258.33	258.33	300.0
2017-11-21 04:33:00	SPY	ETF	258.37	258.37	258.37	258.37	300.0
2017-11-21 04:43:00	SPY	ETF	258.4	258.4	258.4	258.4	400.0
2017-11-21 05:01:00	SPY	ETF	258.5	258.5	258.5	258.5	400.0
2017-11-21 05:02:00	SPY	ETF	258.55	258.55	258.55	258.55	500.0
2017-11-21 05:08:00	SPY	ETF	258.55	258.55	258.55	258.55	500.0
2017-11-21 05:09:00	SPY	ETF	258.56	258.65	258.56	258.65	1000.0
2017-11-21 05:18:00	SPY	ETF	258.63	258.63	258.63	258.63	2000.0
2017-11-21 05:23:00	SPY	ETF	258.75	258.75	258.75	258.75	808.0
2017-11-21 05:24:00	SPY	ETF	258.78	258.8	258.78	258.8	1102.0
2017-11-21 05:30:00	SPY	ETF	258.88	258.88	258.88	258.88	100.0
2017-11-21 05:38:00	SPY	ETF	258.86	258.86	258.86	258.86	100.0
2017-11-21 05:55:00	SPY	ETF	258.85	258.85	258.85	258.85	100.0
2017-11-21 05:58:00	SPY	ETF	258.87	258.87	258.87	258.87	105.0
2017-11-21 06:00:00	SPY	ETF	258.9	258.95	258.9	258.95	1700.0
2017-11-21 06:16:00	SPY	ETF	258.88	258.88	258.88	258.88	100.0
2017-11-21 06:23:00	SPY	ETF	258.9	258.9	258.9	258.9	300.0
2017-11-21 06:25:00	SPY	ETF	258.9	258.9	258.88	258.88	600.0
2017-11-21 06:26:00	SPY	ETF	258.9	258.9	258.9	258.9	300.0
2017-11-21 06:27:00	SPY	ETF	258.9	258.9	258.9	258.9	4000.0
2017-11-21 06:28:00	SPY	ETF	258.91	258.91	258.91	258.91	1000.0
2017-11-21 06:31:00	SPY	ETF	258.89	258.89	258.89	258.89	19500.0
2017-11-21 06:34:00	SPY	ETF	258.89	258.89	258.89	258.89	300.0
2017-11-21 06:35:00	SPY	ETF	258.89	258.89	258.89	258.89	5000.0
2017-11-21 06:36:00	SPY	ETF	258.89	258.89	258.89	258.89	159.0
2017-11-21 06:41:00	SPY	ETF	258.86	258.86	258.85	258.85	1000.0
2017-11-21 06:42:00	SPY	ETF	258.87	258.87	258.87	258.87	500.0
2017-11-21 06:46:00	SPY	ETF	258.88	258.88	258.88	258.88	4400.0
2017-11-21 06:47:00	SPY	ETF	258.9	258.91	258.9	258.91	600.0
2017-11-21 06:49:00	SPY	ETF	258.9	258.9	258.9	258.9	300.0
2017-11-21 06:50:00	SPY	ETF	258.9	258.91	258.9	258.91	500.0
2017-11-21 06:51:00	SPY	ETF	258.9	258.9	258.9	258.9	100.0
2017-11-21 06:57:00	SPY	ETF	258.93	258.94	258.93	258.94	500.0
2017-11-21 06:59:00	SPY	ETF	258.94	259.05	258.94	259.04	34800.0
2017-11-21 07:00:00	SPY	ETF	259.05	259.05	258.97	259.01	23750.0
2017-11-21 07:02:00	SPY	ETF	259.04	259.04	259.02	259.02	6339.0
2017-11-21 07:03:00	SPY	ETF	259.02	259.02	259.02	259.02	9000.0
2017-11-21 07:04:00	SPY	ETF	259.04	259.04	259.04	259.04	281.0
2017-11-21 07:05:00	SPY	ETF	258.99	259.0	258.99	259.0	1687.0
2017-11-21 07:06:00	SPY	ETF	259.01	259.02	259.01	259.02	2669.0
2017-11-21 07:10:00	SPY	ETF	259.0	259.0	259.0	259.0	1200.0
2017-11-21 07:12:00	SPY	ETF	258.98	259.0	258.98	259.0	850.0
2017-11-21 07:13:00	SPY	ETF	258.99	259.07	258.99	259.06	12529.0
2017-11-21 07:14:00	SPY	ETF	259.06	259.06	259.04	259.05	5400.0
2017-11-21 07:15:00	SPY	ETF	259.06	259.14	259.04	259.13	16077.0
2017-11-21 07:16:00	SPY	ETF	259.14	259.14	259.1	259.1	800.0

> showing 50 of 144,511 rows — these rows as CSV

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