PREVIEW / etf_1min / 2018-10-02

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-10-02.parquet
  size:    3.1 MB
  rows:    163,973

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
2018-10-02 04:00:00	SPY	ETF	291.33	291.33	291.33	291.33	400.0
2018-10-02 04:05:00	SPY	ETF	291.28	291.28	291.25	291.25	300.0
2018-10-02 04:06:00	SPY	ETF	291.28	291.28	291.25	291.25	345.0
2018-10-02 04:07:00	SPY	ETF	291.25	291.25	291.25	291.25	805.0
2018-10-02 04:08:00	SPY	ETF	291.25	291.25	291.25	291.25	500.0
2018-10-02 04:09:00	SPY	ETF	291.25	291.25	291.25	291.25	300.0
2018-10-02 04:10:00	SPY	ETF	291.25	291.25	291.25	291.25	1500.0
2018-10-02 04:11:00	SPY	ETF	291.26	291.26	291.25	291.25	400.0
2018-10-02 04:14:00	SPY	ETF	291.29	291.29	291.25	291.25	300.0
2018-10-02 04:17:00	SPY	ETF	291.25	291.25	291.25	291.25	250.0
2018-10-02 04:20:00	SPY	ETF	291.25	291.25	291.25	291.25	950.0
2018-10-02 04:21:00	SPY	ETF	291.23	291.23	291.23	291.23	300.0
2018-10-02 04:23:00	SPY	ETF	291.14	291.14	291.14	291.14	100.0
2018-10-02 04:25:00	SPY	ETF	291.14	291.14	291.12	291.12	500.0
2018-10-02 04:31:00	SPY	ETF	291.01	291.01	291.01	291.01	400.0
2018-10-02 04:32:00	SPY	ETF	291.0	291.0	291.0	291.0	5250.0
2018-10-02 04:41:00	SPY	ETF	291.05	291.05	291.03	291.04	1200.0
2018-10-02 04:43:00	SPY	ETF	290.89	290.89	290.89	290.89	100.0
2018-10-02 04:46:00	SPY	ETF	290.92	290.92	290.91	290.91	600.0
2018-10-02 04:47:00	SPY	ETF	290.88	290.88	290.81	290.81	200.0
2018-10-02 04:48:00	SPY	ETF	290.8	290.8	290.8	290.8	1000.0
2018-10-02 04:50:00	SPY	ETF	290.69	290.69	290.69	290.69	150.0
2018-10-02 04:53:00	SPY	ETF	290.81	290.81	290.81	290.81	100.0
2018-10-02 04:58:00	SPY	ETF	290.8	290.8	290.8	290.8	150.0
2018-10-02 05:04:00	SPY	ETF	290.6	290.6	290.6	290.6	300.0
2018-10-02 05:06:00	SPY	ETF	290.62	290.62	290.62	290.62	100.0
2018-10-02 05:13:00	SPY	ETF	290.57	290.57	290.57	290.57	700.0
2018-10-02 05:14:00	SPY	ETF	290.54	290.54	290.54	290.54	780.0
2018-10-02 05:16:00	SPY	ETF	290.62	290.62	290.62	290.62	100.0
2018-10-02 05:18:00	SPY	ETF	290.64	290.64	290.64	290.64	400.0
2018-10-02 05:25:00	SPY	ETF	290.79	290.82	290.79	290.82	1502.0
2018-10-02 05:27:00	SPY	ETF	290.8	290.8	290.8	290.8	500.0
2018-10-02 05:28:00	SPY	ETF	290.82	290.82	290.82	290.82	150.0
2018-10-02 05:32:00	SPY	ETF	290.72	290.72	290.72	290.72	420.0
2018-10-02 05:34:00	SPY	ETF	290.65	290.65	290.65	290.65	150.0
2018-10-02 05:38:00	SPY	ETF	290.67	290.67	290.64	290.64	1000.0
2018-10-02 05:44:00	SPY	ETF	290.7	290.7	290.7	290.7	150.0
2018-10-02 05:48:00	SPY	ETF	290.75	290.75	290.75	290.75	1000.0
2018-10-02 06:02:00	SPY	ETF	290.86	290.86	290.86	290.86	500.0
2018-10-02 06:03:00	SPY	ETF	290.85	290.85	290.83	290.83	2800.0
2018-10-02 06:05:00	SPY	ETF	290.87	290.87	290.85	290.85	300.0
2018-10-02 06:07:00	SPY	ETF	290.81	290.9	290.81	290.9	350.0
2018-10-02 06:08:00	SPY	ETF	290.9	290.97	290.9	290.97	500.0
2018-10-02 06:09:00	SPY	ETF	290.96	290.99	290.96	290.99	753.0
2018-10-02 06:11:00	SPY	ETF	290.96	290.96	290.96	290.96	410.0
2018-10-02 06:12:00	SPY	ETF	290.94	290.94	290.94	290.94	2000.0
2018-10-02 06:13:00	SPY	ETF	290.96	290.96	290.96	290.96	200.0
2018-10-02 06:14:00	SPY	ETF	290.94	290.94	290.94	290.94	200.0
2018-10-02 06:15:00	SPY	ETF	290.96	290.96	290.96	290.96	100.0
2018-10-02 06:18:00	SPY	ETF	290.96	290.96	290.96	290.96	300.0

> showing 50 of 163,973 rows — these rows as CSV

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