PREVIEW / etf_5min / 2017-05-24

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-05-24.parquet
  size:    1.2 MB
  rows:    52,152

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-05-24 04:10:00	SPY	ETF	240.1	240.1	240.1	240.1	310.0
2017-05-24 04:20:00	SPY	ETF	240.12	240.17	240.12	240.17	1000.0
2017-05-24 04:35:00	SPY	ETF	240.19	240.19	240.19	240.19	4000.0
2017-05-24 05:15:00	SPY	ETF	240.17	240.17	240.17	240.17	800.0
2017-05-24 05:35:00	SPY	ETF	240.12	240.12	240.12	240.12	333.0
2017-05-24 05:50:00	SPY	ETF	240.17	240.2	240.17	240.2	5200.0
2017-05-24 06:20:00	SPY	ETF	240.16	240.21	240.14	240.15	102400.0
2017-05-24 06:25:00	SPY	ETF	240.15	240.15	240.15	240.15	200.0
2017-05-24 06:40:00	SPY	ETF	240.07	240.07	240.07	240.07	500.0
2017-05-24 06:45:00	SPY	ETF	240.05	240.07	240.05	240.07	699.0
2017-05-24 06:50:00	SPY	ETF	240.07	240.07	240.07	240.07	100.0
2017-05-24 06:55:00	SPY	ETF	240.06	240.06	240.06	240.06	501.0
2017-05-24 07:00:00	SPY	ETF	240.02	240.05	240.02	240.05	2452.0
2017-05-24 07:05:00	SPY	ETF	240.07	240.07	240.07	240.07	6027.0
2017-05-24 07:10:00	SPY	ETF	240.06	240.06	240.06	240.06	201.0
2017-05-24 07:20:00	SPY	ETF	240.1	240.1	240.1	240.1	6000.0
2017-05-24 07:25:00	SPY	ETF	240.1	240.11	240.08	240.08	6101.0
2017-05-24 07:30:00	SPY	ETF	240.08	240.09	240.08	240.08	1600.0
2017-05-24 07:35:00	SPY	ETF	240.08	240.08	240.02	240.02	52601.0
2017-05-24 07:45:00	SPY	ETF	240.12	240.12	240.1	240.1	4114.0
2017-05-24 07:50:00	SPY	ETF	240.11	240.11	240.09	240.11	12251.0
2017-05-24 07:55:00	SPY	ETF	240.12	240.13	240.1	240.13	5300.0
2017-05-24 08:00:00	SPY	ETF	240.07	240.16	240.03	240.14	15976.0
2017-05-24 08:05:00	SPY	ETF	240.14	240.19	240.14	240.19	6245.0
2017-05-24 08:10:00	SPY	ETF	240.2	240.25	240.19	240.25	27252.0
2017-05-24 08:15:00	SPY	ETF	240.23	240.23	240.2	240.2	13369.0
2017-05-24 08:20:00	SPY	ETF	240.18	240.21	240.18	240.19	8211.0
2017-05-24 08:25:00	SPY	ETF	240.19	240.19	240.16	240.19	7358.0
2017-05-24 08:30:00	SPY	ETF	240.2	240.21	240.18	240.21	7313.0
2017-05-24 08:35:00	SPY	ETF	240.2	240.21	240.18	240.18	7015.0
2017-05-24 08:40:00	SPY	ETF	240.19	240.21	240.18	240.18	20383.0
2017-05-24 08:45:00	SPY	ETF	240.17	240.19	240.13	240.17	15561.0
2017-05-24 08:50:00	SPY	ETF	240.17	240.2	240.17	240.19	8391.0
2017-05-24 08:55:00	SPY	ETF	240.19	240.23	240.18	240.2	26034.0
2017-05-24 09:00:00	SPY	ETF	240.22	240.22	240.2	240.21	36449.0
2017-05-24 09:05:00	SPY	ETF	240.21	240.21	240.18	240.19	21249.0
2017-05-24 09:10:00	SPY	ETF	240.18	240.18	240.13	240.14	13992.0
2017-05-24 09:15:00	SPY	ETF	240.15	240.18	240.13	240.17	6179.0
2017-05-24 09:20:00	SPY	ETF	240.16	240.28	240.15	240.27	37931.0
2017-05-24 09:25:00	SPY	ETF	240.28	240.39	240.27	240.33	87657.0
2017-05-24 09:30:00	SPY	ETF	240.32	240.35	240.22	240.27	983992.0
2017-05-24 09:35:00	SPY	ETF	240.27	240.29	240.09	240.1583	718783.0
2017-05-24 09:40:00	SPY	ETF	240.1573	240.18	240.08	240.16	461361.0
2017-05-24 09:45:00	SPY	ETF	240.15	240.2	240.14	240.18	379917.0
2017-05-24 09:50:00	SPY	ETF	240.18	240.31	240.18	240.27	601207.0
2017-05-24 09:55:00	SPY	ETF	240.2775	240.3	240.18	240.19	305496.0
2017-05-24 10:00:00	SPY	ETF	240.185	240.24	240.03	240.0899	562591.0
2017-05-24 10:05:00	SPY	ETF	240.08	240.19	240.02	240.12	1075833.0
2017-05-24 10:10:00	SPY	ETF	240.11	240.19	240.06	240.16	481763.0
2017-05-24 10:15:00	SPY	ETF	240.16	240.18	240.0501	240.14	436422.0

> showing 50 of 52,152 rows — these rows as CSV

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