PREVIEW / etf_5min / 2017-05-25

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-05-25.parquet
  size:    1.2 MB
  rows:    54,515

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-25 04:00:00	SPY	ETF	241.01	241.13	241.01	241.13	5687.0
2017-05-25 04:05:00	SPY	ETF	241.05	241.05	241.05	241.05	1625.0
2017-05-25 04:10:00	SPY	ETF	241.06	241.09	241.06	241.07	900.0
2017-05-25 04:15:00	SPY	ETF	241.01	241.01	241.01	241.01	200.0
2017-05-25 04:25:00	SPY	ETF	241.05	241.05	241.01	241.01	750.0
2017-05-25 04:35:00	SPY	ETF	240.97	240.97	240.97	240.97	4000.0
2017-05-25 04:45:00	SPY	ETF	241.09	241.1	241.08	241.08	5000.0
2017-05-25 04:50:00	SPY	ETF	241.1	241.1	241.1	241.1	9200.0
2017-05-25 04:55:00	SPY	ETF	241.12	241.12	241.12	241.12	8000.0
2017-05-25 05:00:00	SPY	ETF	241.12	241.27	241.12	241.27	5545.0
2017-05-25 05:05:00	SPY	ETF	241.26	241.26	241.22	241.22	1000.0
2017-05-25 05:10:00	SPY	ETF	241.24	241.24	241.24	241.24	4000.0
2017-05-25 05:15:00	SPY	ETF	241.24	241.24	241.24	241.24	700.0
2017-05-25 05:20:00	SPY	ETF	241.21	241.21	241.21	241.21	200.0
2017-05-25 05:25:00	SPY	ETF	241.2	241.2	241.2	241.2	1500.0
2017-05-25 05:30:00	SPY	ETF	241.31	241.34	241.31	241.34	2000.0
2017-05-25 05:35:00	SPY	ETF	241.31	241.31	241.31	241.31	1975.0
2017-05-25 05:40:00	SPY	ETF	241.34	241.34	241.2	241.2	4000.0
2017-05-25 05:45:00	SPY	ETF	241.3	241.3	241.3	241.3	700.0
2017-05-25 05:50:00	SPY	ETF	241.29	241.29	241.29	241.29	1000.0
2017-05-25 05:55:00	SPY	ETF	241.29	241.29	241.27	241.27	600.0
2017-05-25 06:00:00	SPY	ETF	241.3	241.3	241.26	241.26	1000.0
2017-05-25 06:10:00	SPY	ETF	241.26	241.26	241.26	241.26	140.0
2017-05-25 06:15:00	SPY	ETF	241.3	241.3	241.3	241.3	3730.0
2017-05-25 06:20:00	SPY	ETF	241.3	241.3	241.27	241.27	61770.0
2017-05-25 06:25:00	SPY	ETF	241.27	241.28	241.23	241.28	7000.0
2017-05-25 06:30:00	SPY	ETF	241.25	241.25	241.25	241.25	100.0
2017-05-25 06:35:00	SPY	ETF	241.27	241.28	241.25	241.25	10300.0
2017-05-25 06:40:00	SPY	ETF	241.27	241.29	241.27	241.27	23120.0
2017-05-25 06:45:00	SPY	ETF	241.26	241.27	241.26	241.26	57000.0
2017-05-25 06:50:00	SPY	ETF	241.25	241.26	241.23	241.26	28950.0
2017-05-25 06:55:00	SPY	ETF	241.22	241.22	241.16	241.19	15185.0
2017-05-25 07:00:00	SPY	ETF	241.18	241.27	241.18	241.22	27955.0
2017-05-25 07:05:00	SPY	ETF	241.18	241.21	241.15	241.2	19451.0
2017-05-25 07:10:00	SPY	ETF	241.21	241.21	241.15	241.16	20700.0
2017-05-25 07:15:00	SPY	ETF	241.15	241.19	241.15	241.19	12950.0
2017-05-25 07:20:00	SPY	ETF	241.21	241.24	241.18	241.23	26520.0
2017-05-25 07:25:00	SPY	ETF	241.21	241.21	241.18	241.18	11069.0
2017-05-25 07:30:00	SPY	ETF	241.18	241.19	241.18	241.19	1939.0
2017-05-25 07:35:00	SPY	ETF	241.18	241.18	241.14	241.14	13769.0
2017-05-25 07:40:00	SPY	ETF	241.15	241.16	241.15	241.16	215.0
2017-05-25 07:45:00	SPY	ETF	241.15	241.15	241.01	241.01	121575.0
2017-05-25 07:50:00	SPY	ETF	241.04	241.1	241.04	241.1	20700.0
2017-05-25 07:55:00	SPY	ETF	241.09	241.12	241.06	241.09	8702.0
2017-05-25 08:00:00	SPY	ETF	241.09	241.21	241.05	241.06	56873.0
2017-05-25 08:05:00	SPY	ETF	241.06	241.08	241.03	241.05	23730.0
2017-05-25 08:10:00	SPY	ETF	241.05	241.06	240.99	240.99	49995.0
2017-05-25 08:15:00	SPY	ETF	240.99	241.07	240.98	241.05	21982.0
2017-05-25 08:20:00	SPY	ETF	241.06	241.09	241.05	241.08	19690.0
2017-05-25 08:25:00	SPY	ETF	241.06	241.1	241.06	241.09	18294.0

> showing 50 of 54,515 rows — these rows as CSV

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