PREVIEW / etf_5min / 2017-12-14

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-12-14.parquet
  size:    1.3 MB
  rows:    56,009

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-12-14 04:00:00	SPY	ETF	267.18	267.4	267.18	267.28	1630.0
2017-12-14 04:20:00	SPY	ETF	267.3	267.3	267.3	267.3	100.0
2017-12-14 04:30:00	SPY	ETF	267.38	267.38	267.38	267.38	240.0
2017-12-14 05:05:00	SPY	ETF	267.4	267.4	267.4	267.4	500.0
2017-12-14 05:10:00	SPY	ETF	267.36	267.36	267.36	267.36	100.0
2017-12-14 05:20:00	SPY	ETF	267.2	267.2	267.2	267.2	1000.0
2017-12-14 05:25:00	SPY	ETF	267.26	267.26	267.26	267.26	300.0
2017-12-14 05:30:00	SPY	ETF	267.23	267.23	267.23	267.23	1483.0
2017-12-14 05:40:00	SPY	ETF	267.26	267.32	267.26	267.32	200.0
2017-12-14 05:50:00	SPY	ETF	267.23	267.23	267.23	267.23	1070.0
2017-12-14 05:55:00	SPY	ETF	267.2	267.2	267.2	267.2	3100.0
2017-12-14 06:00:00	SPY	ETF	267.19	267.19	267.19	267.19	700.0
2017-12-14 06:15:00	SPY	ETF	267.26	267.26	267.21	267.21	900.0
2017-12-14 06:20:00	SPY	ETF	267.23	267.23	267.23	267.23	600.0
2017-12-14 06:25:00	SPY	ETF	267.23	267.26	267.23	267.26	400.0
2017-12-14 06:30:00	SPY	ETF	267.25	267.25	267.21	267.21	701.0
2017-12-14 06:35:00	SPY	ETF	267.21	267.21	267.21	267.21	300.0
2017-12-14 06:40:00	SPY	ETF	267.23	267.26	267.21	267.21	4700.0
2017-12-14 06:45:00	SPY	ETF	267.23	267.23	267.23	267.23	900.0
2017-12-14 06:55:00	SPY	ETF	267.17	267.19	267.17	267.19	500.0
2017-12-14 07:00:00	SPY	ETF	267.15	267.16	267.11	267.16	6402.0
2017-12-14 07:05:00	SPY	ETF	267.18	267.21	267.18	267.21	300.0
2017-12-14 07:10:00	SPY	ETF	267.21	267.21	267.18	267.18	1667.0
2017-12-14 07:15:00	SPY	ETF	267.16	267.16	267.14	267.14	480.0
2017-12-14 07:20:00	SPY	ETF	267.16	267.16	267.13	267.14	4450.0
2017-12-14 07:25:00	SPY	ETF	267.15	267.17	267.15	267.17	1100.0
2017-12-14 07:30:00	SPY	ETF	267.17	267.17	267.16	267.16	440.0
2017-12-14 07:35:00	SPY	ETF	267.17	267.17	267.1	267.1	10430.0
2017-12-14 07:40:00	SPY	ETF	267.1	267.1	267.08	267.08	41800.0
2017-12-14 07:45:00	SPY	ETF	267.12	267.17	267.12	267.17	63300.0
2017-12-14 07:50:00	SPY	ETF	267.15	267.16	267.15	267.15	6884.0
2017-12-14 07:55:00	SPY	ETF	267.16	267.16	267.15	267.16	32157.0
2017-12-14 08:00:00	SPY	ETF	267.15	267.16	267.09	267.16	69944.0
2017-12-14 08:05:00	SPY	ETF	267.19	267.19	266.96	266.96	100100.0
2017-12-14 08:10:00	SPY	ETF	267.19	267.19	267.12	267.17	4100.0
2017-12-14 08:15:00	SPY	ETF	267.12	267.12	267.09	267.09	4946.0
2017-12-14 08:20:00	SPY	ETF	267.12	267.19	267.1	267.16	31012.0
2017-12-14 08:25:00	SPY	ETF	267.17	267.17	267.11	267.13	1050.0
2017-12-14 08:30:00	SPY	ETF	267.15	267.19	267.14	267.14	20757.0
2017-12-14 08:35:00	SPY	ETF	267.18	267.19	267.1	267.1	23270.0
2017-12-14 08:40:00	SPY	ETF	267.15	267.19	267.07	267.12	10344.0
2017-12-14 08:45:00	SPY	ETF	267.14	267.17	267.12	267.15	4270.0
2017-12-14 08:50:00	SPY	ETF	267.15	267.21	267.13	267.21	66354.0
2017-12-14 08:55:00	SPY	ETF	267.2	267.24	267.2	267.21	32360.0
2017-12-14 09:00:00	SPY	ETF	267.22	267.23	267.2	267.21	114731.0
2017-12-14 09:05:00	SPY	ETF	267.17	267.2	267.17	267.19	8654.0
2017-12-14 09:10:00	SPY	ETF	267.19	267.2	267.16	267.16	8856.0
2017-12-14 09:15:00	SPY	ETF	267.16	267.16	267.11	267.13	6039.0
2017-12-14 09:20:00	SPY	ETF	267.13	267.13	267.07	267.07	38479.0
2017-12-14 09:25:00	SPY	ETF	267.06	267.12	267.04	267.09	119005.0

> showing 50 of 56,009 rows — these rows as CSV

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