PREVIEW / etf_5min / 2017-09-05

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-09-05.parquet
  size:    1.3 MB
  rows:    57,181

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-09-05 04:00:00	SPY	ETF	247.3	247.3	247.3	247.3	413.0
2017-09-05 04:30:00	SPY	ETF	247.42	247.42	247.42	247.42	100.0
2017-09-05 04:35:00	SPY	ETF	247.37	247.37	247.37	247.37	300.0
2017-09-05 04:50:00	SPY	ETF	247.29	247.29	247.29	247.29	380.0
2017-09-05 05:05:00	SPY	ETF	247.31	247.31	247.31	247.31	100.0
2017-09-05 05:10:00	SPY	ETF	247.3	247.3	247.3	247.3	201.0
2017-09-05 05:15:00	SPY	ETF	247.32	247.34	247.32	247.34	1403.0
2017-09-05 05:20:00	SPY	ETF	247.35	247.35	247.35	247.35	100.0
2017-09-05 05:25:00	SPY	ETF	247.37	247.37	247.37	247.37	100.0
2017-09-05 05:30:00	SPY	ETF	247.3	247.3	247.3	247.3	505.0
2017-09-05 05:35:00	SPY	ETF	247.27	247.29	247.27	247.29	5300.0
2017-09-05 05:40:00	SPY	ETF	247.25	247.25	247.2	247.2	3655.0
2017-09-05 05:45:00	SPY	ETF	247.2	247.22	247.2	247.2	6850.0
2017-09-05 05:50:00	SPY	ETF	247.17	247.17	247.17	247.17	302.0
2017-09-05 05:55:00	SPY	ETF	247.16	247.18	247.16	247.17	1001.0
2017-09-05 06:00:00	SPY	ETF	247.16	247.16	247.14	247.14	414.0
2017-09-05 06:20:00	SPY	ETF	247.1	247.1	247.07	247.07	6901.0
2017-09-05 06:25:00	SPY	ETF	247.07	247.07	246.94	246.94	2387.0
2017-09-05 06:35:00	SPY	ETF	246.95	246.95	246.94	246.94	2000.0
2017-09-05 06:40:00	SPY	ETF	246.94	247.01	246.94	247.01	25500.0
2017-09-05 06:45:00	SPY	ETF	247.0	247.05	247.0	247.05	15302.0
2017-09-05 06:50:00	SPY	ETF	247.03	247.05	247.01	247.01	36609.0
2017-09-05 06:55:00	SPY	ETF	247.01	247.04	247.01	247.03	460.0
2017-09-05 07:00:00	SPY	ETF	247.05	247.08	247.03	247.03	6004.0
2017-09-05 07:05:00	SPY	ETF	247.06	247.06	247.04	247.04	8761.0
2017-09-05 07:10:00	SPY	ETF	247.2	247.2	247.12	247.14	6462.0
2017-09-05 07:15:00	SPY	ETF	247.15	247.17	247.15	247.17	2966.0
2017-09-05 07:20:00	SPY	ETF	247.2	247.2	247.2	247.2	7006.0
2017-09-05 07:25:00	SPY	ETF	247.21	247.28	247.2	247.25	4365.0
2017-09-05 07:30:00	SPY	ETF	247.25	247.3	247.25	247.29	18463.0
2017-09-05 07:35:00	SPY	ETF	247.28	247.28	247.23	247.23	2485.0
2017-09-05 07:40:00	SPY	ETF	247.28	247.29	247.28	247.28	14144.0
2017-09-05 07:45:00	SPY	ETF	247.28	247.31	247.28	247.3	16950.0
2017-09-05 07:50:00	SPY	ETF	247.3	247.31	247.29	247.31	17500.0
2017-09-05 07:55:00	SPY	ETF	247.31	247.32	247.3	247.3	22800.0
2017-09-05 08:00:00	SPY	ETF	247.31	247.4	247.06	247.37	386992.0
2017-09-05 08:05:00	SPY	ETF	247.37	247.37	247.32	247.33	37552.0
2017-09-05 08:10:00	SPY	ETF	247.34	247.35	247.28	247.29	13807.0
2017-09-05 08:15:00	SPY	ETF	247.27	247.29	247.27	247.29	5369.0
2017-09-05 08:20:00	SPY	ETF	247.29	247.29	247.24	247.24	8940.0
2017-09-05 08:25:00	SPY	ETF	247.26	247.27	247.22	247.24	19800.0
2017-09-05 08:30:00	SPY	ETF	247.23	247.28	247.22	247.27	45515.0
2017-09-05 08:35:00	SPY	ETF	247.29	247.29	247.25	247.28	28788.0
2017-09-05 08:40:00	SPY	ETF	247.29	247.35	247.29	247.34	108243.0
2017-09-05 08:45:00	SPY	ETF	247.34	247.37	247.31	247.35	31070.0
2017-09-05 08:50:00	SPY	ETF	247.35	247.84	247.23	247.23	65644.0
2017-09-05 08:55:00	SPY	ETF	247.24	247.24	247.19	247.22	18583.0
2017-09-05 09:00:00	SPY	ETF	247.22	247.27	247.22	247.22	40069.0
2017-09-05 09:05:00	SPY	ETF	247.23	247.26	247.21	247.21	90222.0
2017-09-05 09:10:00	SPY	ETF	247.21	247.29	247.21	247.27	63840.0

> showing 50 of 57,181 rows — these rows as CSV

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