PREVIEW / etf_1min / 2017-05-25

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-05-25.parquet
  size:    2.7 MB
  rows:    141,689

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.01	241.01	241.01	377.0
2017-05-25 04:03:00	SPY	ETF	241.07	241.07	241.07	241.07	3000.0
2017-05-25 04:04:00	SPY	ETF	241.13	241.13	241.13	241.13	2310.0
2017-05-25 04:06:00	SPY	ETF	241.05	241.05	241.05	241.05	525.0
2017-05-25 04:07:00	SPY	ETF	241.05	241.05	241.05	241.05	100.0
2017-05-25 04:09:00	SPY	ETF	241.05	241.05	241.05	241.05	1000.0
2017-05-25 04:11:00	SPY	ETF	241.06	241.09	241.06	241.09	500.0
2017-05-25 04:14:00	SPY	ETF	241.06	241.07	241.06	241.07	400.0
2017-05-25 04:17: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.05	241.05	200.0
2017-05-25 04:29:00	SPY	ETF	241.02	241.02	241.01	241.01	550.0
2017-05-25 04:39:00	SPY	ETF	240.97	240.97	240.97	240.97	4000.0
2017-05-25 04:47:00	SPY	ETF	241.09	241.1	241.09	241.1	4900.0
2017-05-25 04:48:00	SPY	ETF	241.08	241.08	241.08	241.08	100.0
2017-05-25 04:51:00	SPY	ETF	241.1	241.1	241.1	241.1	9200.0
2017-05-25 04:58:00	SPY	ETF	241.12	241.12	241.12	241.12	7200.0
2017-05-25 04:59:00	SPY	ETF	241.12	241.12	241.12	241.12	800.0
2017-05-25 05:00:00	SPY	ETF	241.12	241.17	241.12	241.17	3810.0
2017-05-25 05:01:00	SPY	ETF	241.16	241.18	241.16	241.18	500.0
2017-05-25 05:03:00	SPY	ETF	241.2	241.27	241.2	241.27	1235.0
2017-05-25 05:05:00	SPY	ETF	241.26	241.26	241.26	241.26	300.0
2017-05-25 05:06:00	SPY	ETF	241.24	241.24	241.24	241.24	100.0
2017-05-25 05:08:00	SPY	ETF	241.24	241.24	241.22	241.22	600.0
2017-05-25 05:11:00	SPY	ETF	241.24	241.24	241.24	241.24	200.0
2017-05-25 05:12:00	SPY	ETF	241.24	241.24	241.24	241.24	3800.0
2017-05-25 05:19:00	SPY	ETF	241.24	241.24	241.24	241.24	700.0
2017-05-25 05:22:00	SPY	ETF	241.21	241.21	241.21	241.21	100.0
2017-05-25 05:24:00	SPY	ETF	241.21	241.21	241.21	241.21	100.0
2017-05-25 05:26:00	SPY	ETF	241.2	241.2	241.2	241.2	1500.0
2017-05-25 05:30:00	SPY	ETF	241.31	241.31	241.31	241.31	500.0
2017-05-25 05:31:00	SPY	ETF	241.31	241.31	241.31	241.31	500.0
2017-05-25 05:33:00	SPY	ETF	241.34	241.34	241.34	241.34	1000.0
2017-05-25 05:38: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.34	241.34	500.0
2017-05-25 05:42:00	SPY	ETF	241.31	241.31	241.31	241.31	1000.0
2017-05-25 05:44:00	SPY	ETF	241.2	241.2	241.2	241.2	2500.0
2017-05-25 05:47: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.29	241.29	100.0
2017-05-25 05:58:00	SPY	ETF	241.27	241.27	241.27	241.27	500.0
2017-05-25 06:00:00	SPY	ETF	241.3	241.3	241.3	241.3	500.0
2017-05-25 06:04:00	SPY	ETF	241.26	241.26	241.26	241.26	500.0
2017-05-25 06:12:00	SPY	ETF	241.26	241.26	241.26	241.26	140.0
2017-05-25 06:19: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.3	241.3	41500.0
2017-05-25 06:21:00	SPY	ETF	241.3	241.3	241.3	241.3	5000.0
2017-05-25 06:22:00	SPY	ETF	241.3	241.3	241.27	241.27	15270.0
2017-05-25 06:25:00	SPY	ETF	241.27	241.27	241.27	241.27	1500.0
2017-05-25 06:28:00	SPY	ETF	241.27	241.27	241.23	241.23	5000.0
2017-05-25 06:29:00	SPY	ETF	241.28	241.28	241.28	241.28	500.0

> showing 50 of 141,689 rows — these rows as CSV

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