PREVIEW / etf_5min / 2018-02-21

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-02-21.parquet
  size:    1.4 MB
  rows:    60,519

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-02-21 04:00:00	SPY	ETF	271.15	271.15	270.64	270.71	7064.0
2018-02-21 04:05:00	SPY	ETF	270.68	270.85	270.68	270.74	7060.0
2018-02-21 04:10:00	SPY	ETF	270.74	270.74	270.64	270.67	4860.0
2018-02-21 04:15:00	SPY	ETF	270.85	270.92	270.85	270.92	1100.0
2018-02-21 04:20:00	SPY	ETF	270.84	270.84	270.7	270.7	1310.0
2018-02-21 04:25:00	SPY	ETF	270.93	271.12	270.93	271.12	370.0
2018-02-21 04:30:00	SPY	ETF	271.16	271.16	271.16	271.16	1000.0
2018-02-21 04:35:00	SPY	ETF	271.13	271.21	271.12	271.21	950.0
2018-02-21 04:40:00	SPY	ETF	271.16	271.16	271.12	271.13	800.0
2018-02-21 04:45:00	SPY	ETF	271.18	271.18	271.06	271.06	1300.0
2018-02-21 04:50:00	SPY	ETF	270.9	271.06	270.89	271.0	3150.0
2018-02-21 04:55:00	SPY	ETF	271.01	271.01	270.81	270.96	12850.0
2018-02-21 05:00:00	SPY	ETF	271.01	271.01	270.88	270.88	5730.0
2018-02-21 05:05:00	SPY	ETF	270.89	271.07	270.89	270.96	5150.0
2018-02-21 05:10:00	SPY	ETF	271.01	271.01	270.8	270.85	8553.0
2018-02-21 05:15:00	SPY	ETF	270.85	270.88	270.85	270.88	2300.0
2018-02-21 05:20:00	SPY	ETF	270.86	270.91	270.86	270.91	4700.0
2018-02-21 05:25:00	SPY	ETF	270.8	270.92	270.8	270.9	6200.0
2018-02-21 05:30:00	SPY	ETF	270.93	270.93	270.88	270.88	2600.0
2018-02-21 05:35:00	SPY	ETF	270.93	271.16	270.93	271.08	8769.0
2018-02-21 05:40:00	SPY	ETF	271.03	271.03	270.92	270.92	1700.0
2018-02-21 05:45:00	SPY	ETF	270.91	270.92	270.91	270.91	1700.0
2018-02-21 05:50:00	SPY	ETF	270.91	270.99	270.91	270.99	950.0
2018-02-21 05:55:00	SPY	ETF	271.0	271.01	270.94	270.98	1450.0
2018-02-21 06:00:00	SPY	ETF	271.01	271.06	270.99	270.99	1500.0
2018-02-21 06:05:00	SPY	ETF	270.84	270.85	270.84	270.84	6300.0
2018-02-21 06:10:00	SPY	ETF	270.98	270.98	270.89	270.89	900.0
2018-02-21 06:15:00	SPY	ETF	270.81	270.83	270.81	270.81	1840.0
2018-02-21 06:20:00	SPY	ETF	270.79	270.93	270.77	270.93	1100.0
2018-02-21 06:25:00	SPY	ETF	270.93	270.93	270.93	270.93	1100.0
2018-02-21 06:30:00	SPY	ETF	270.93	270.93	270.86	270.86	500.0
2018-02-21 06:35:00	SPY	ETF	270.76	270.83	270.76	270.83	2400.0
2018-02-21 06:40:00	SPY	ETF	270.91	270.91	270.88	270.88	3708.0
2018-02-21 06:45:00	SPY	ETF	270.88	270.88	270.87	270.87	266.0
2018-02-21 06:50:00	SPY	ETF	270.88	271.04	270.88	271.04	12288.0
2018-02-21 06:55:00	SPY	ETF	271.01	271.17	271.0	271.17	16275.0
2018-02-21 07:00:00	SPY	ETF	271.18	271.28	271.18	271.25	24450.0
2018-02-21 07:05:00	SPY	ETF	271.28	271.31	271.23	271.31	6623.0
2018-02-21 07:10:00	SPY	ETF	271.26	271.33	271.25	271.31	2000.0
2018-02-21 07:15:00	SPY	ETF	271.31	271.34	271.28	271.28	26616.0
2018-02-21 07:20:00	SPY	ETF	271.29	271.33	271.29	271.29	1700.0
2018-02-21 07:25:00	SPY	ETF	271.31	271.33	271.18	271.2	3310.0
2018-02-21 07:30:00	SPY	ETF	271.23	271.29	271.23	271.29	1900.0
2018-02-21 07:35:00	SPY	ETF	271.2	271.27	271.2	271.25	4601.0
2018-02-21 07:40:00	SPY	ETF	271.25	271.31	271.24	271.3	7299.0
2018-02-21 07:45:00	SPY	ETF	271.3	271.31	271.14	271.16	5800.0
2018-02-21 07:50:00	SPY	ETF	271.16	271.28	271.16	271.22	5030.0
2018-02-21 07:55:00	SPY	ETF	271.28	271.29	271.26	271.29	2460.0
2018-02-21 08:00:00	SPY	ETF	271.23	271.37	270.82	271.31	71032.0
2018-02-21 08:05:00	SPY	ETF	271.26	271.26	271.21	271.24	20459.0

> showing 50 of 60,519 rows — these rows as CSV

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