PREVIEW / etf_5min / 2017-10-25

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-10-25.parquet
  size:    1.3 MB
  rows:    56,873

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-10-25 04:05:00	SPY	ETF	256.25	256.25	256.25	256.25	200.0
2017-10-25 04:10:00	SPY	ETF	256.18	256.18	256.17	256.17	500.0
2017-10-25 04:15:00	SPY	ETF	256.15	256.15	256.15	256.15	100.0
2017-10-25 04:30:00	SPY	ETF	256.17	256.17	256.17	256.17	100.0
2017-10-25 04:35:00	SPY	ETF	256.15	256.15	256.13	256.13	200.0
2017-10-25 04:40:00	SPY	ETF	256.17	256.17	256.17	256.17	100.0
2017-10-25 05:05:00	SPY	ETF	256.2	256.2	256.2	256.2	120.0
2017-10-25 05:10:00	SPY	ETF	256.07	256.07	256.05	256.05	200.0
2017-10-25 05:35:00	SPY	ETF	256.18	256.18	256.18	256.18	306.0
2017-10-25 06:00:00	SPY	ETF	256.19	256.19	256.19	256.19	2503.0
2017-10-25 06:25:00	SPY	ETF	256.35	256.35	256.35	256.35	503.0
2017-10-25 06:30:00	SPY	ETF	256.3	256.3	256.3	256.3	103.0
2017-10-25 06:35:00	SPY	ETF	256.25	256.3	256.25	256.3	602.0
2017-10-25 06:50:00	SPY	ETF	256.29	256.3	256.29	256.29	1300.0
2017-10-25 07:00:00	SPY	ETF	256.34	256.38	256.34	256.38	2502.0
2017-10-25 07:05:00	SPY	ETF	256.42	256.43	256.42	256.43	390.0
2017-10-25 07:10:00	SPY	ETF	256.44	256.44	256.35	256.35	1427.0
2017-10-25 07:15:00	SPY	ETF	256.34	256.34	256.3	256.3	8031.0
2017-10-25 07:20:00	SPY	ETF	256.23	256.23	256.23	256.23	532.0
2017-10-25 07:25:00	SPY	ETF	256.18	256.21	256.15	256.18	5260.0
2017-10-25 07:35:00	SPY	ETF	256.2	256.2	256.11	256.12	25291.0
2017-10-25 07:40:00	SPY	ETF	256.12	256.22	256.08	256.21	4523.0
2017-10-25 07:45:00	SPY	ETF	256.21	256.21	256.2	256.2	1885.0
2017-10-25 07:50:00	SPY	ETF	256.19	256.19	256.16	256.16	987.0
2017-10-25 07:55:00	SPY	ETF	256.18	256.18	256.13	256.15	4267.0
2017-10-25 08:00:00	SPY	ETF	256.12	256.2	256.12	256.13	10918.0
2017-10-25 08:05:00	SPY	ETF	256.14	256.18	256.1	256.18	19790.0
2017-10-25 08:10:00	SPY	ETF	256.18	256.23	256.15	256.21	25509.0
2017-10-25 08:15:00	SPY	ETF	256.2	256.23	256.2	256.23	4878.0
2017-10-25 08:20:00	SPY	ETF	256.22	256.26	256.22	256.25	8441.0
2017-10-25 08:25:00	SPY	ETF	256.24	256.31	256.24	256.28	27388.0
2017-10-25 08:30:00	SPY	ETF	256.28	256.32	256.23	256.23	29705.0
2017-10-25 08:35:00	SPY	ETF	256.25	256.25	256.19	256.2	35560.0
2017-10-25 08:40:00	SPY	ETF	256.2	256.22	256.17	256.2	8116.0
2017-10-25 08:45:00	SPY	ETF	256.19	256.19	256.15	256.15	18634.0
2017-10-25 08:50:00	SPY	ETF	256.16	256.19	256.12	256.18	51545.0
2017-10-25 08:55:00	SPY	ETF	256.18	256.24	256.17	256.23	6774.0
2017-10-25 09:00:00	SPY	ETF	256.2	256.25	256.2	256.2	21824.0
2017-10-25 09:05:00	SPY	ETF	256.23	256.23	256.15	256.16	17286.0
2017-10-25 09:10:00	SPY	ETF	256.16	256.2	256.11	256.14	25796.0
2017-10-25 09:15:00	SPY	ETF	256.14	256.17	256.13	256.15	46907.0
2017-10-25 09:20:00	SPY	ETF	256.14	256.21	256.14	256.21	60115.0
2017-10-25 09:25:00	SPY	ETF	256.21	256.22	256.16	256.19	57756.0
2017-10-25 09:30:00	SPY	ETF	256.18	256.31	256.18	256.27	1149271.0
2017-10-25 09:35:00	SPY	ETF	256.26	256.3	256.13	256.21	391851.0
2017-10-25 09:40:00	SPY	ETF	256.21	256.29	256.1	256.16	718087.0
2017-10-25 09:45:00	SPY	ETF	256.15	256.16	256.05	256.1265	437234.0
2017-10-25 09:50:00	SPY	ETF	256.12	256.23	255.77	255.78	1108406.0
2017-10-25 09:55:00	SPY	ETF	255.78	255.9158	255.75	255.805	1193589.0
2017-10-25 10:00:00	SPY	ETF	255.8	255.97	255.77	255.91	759980.0

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

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