PREVIEW / etf_5min / 2018-06-20

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-06-20.parquet
  size:    1.3 MB
  rows:    57,513

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
2018-06-20 04:00:00	SPY	ETF	276.34	276.39	276.25	276.28	15036.0
2018-06-20 04:05:00	SPY	ETF	276.15	276.3	276.15	276.3	7152.0
2018-06-20 04:10:00	SPY	ETF	276.14	276.14	276.12	276.12	300.0
2018-06-20 04:15:00	SPY	ETF	276.17	276.17	276.14	276.14	3000.0
2018-06-20 04:20:00	SPY	ETF	276.18	276.18	276.14	276.14	500.0
2018-06-20 04:25:00	SPY	ETF	276.17	276.22	276.17	276.22	775.0
2018-06-20 04:30:00	SPY	ETF	276.2	276.2	276.2	276.2	100.0
2018-06-20 04:35:00	SPY	ETF	276.26	276.26	276.26	276.26	150.0
2018-06-20 04:40:00	SPY	ETF	276.26	276.26	276.26	276.26	400.0
2018-06-20 04:45:00	SPY	ETF	276.23	276.23	276.23	276.23	100.0
2018-06-20 04:50:00	SPY	ETF	276.22	276.22	276.22	276.22	250.0
2018-06-20 05:00:00	SPY	ETF	276.31	276.4	276.31	276.4	620.0
2018-06-20 05:05:00	SPY	ETF	276.39	276.39	276.39	276.39	120.0
2018-06-20 05:20:00	SPY	ETF	276.46	276.46	276.46	276.46	202.0
2018-06-20 05:25:00	SPY	ETF	276.41	276.41	276.41	276.41	200.0
2018-06-20 05:30:00	SPY	ETF	276.5	276.5	276.5	276.5	160.0
2018-06-20 05:35:00	SPY	ETF	276.47	276.47	276.47	276.47	150.0
2018-06-20 05:50:00	SPY	ETF	276.42	276.5	276.42	276.5	5300.0
2018-06-20 05:55:00	SPY	ETF	276.48	276.48	276.48	276.48	100.0
2018-06-20 06:15:00	SPY	ETF	276.37	276.37	276.37	276.37	610.0
2018-06-20 06:30:00	SPY	ETF	276.48	276.48	276.48	276.48	300.0
2018-06-20 06:40:00	SPY	ETF	276.53	276.53	276.39	276.52	2390.0
2018-06-20 06:45:00	SPY	ETF	276.55	276.57	276.47	276.47	4410.0
2018-06-20 06:50:00	SPY	ETF	276.41	276.41	276.41	276.41	1400.0
2018-06-20 06:55:00	SPY	ETF	276.4	276.4	276.38	276.38	2500.0
2018-06-20 07:00:00	SPY	ETF	276.44	276.45	276.3	276.32	13565.0
2018-06-20 07:05:00	SPY	ETF	276.23	276.3	276.16	276.2	16450.0
2018-06-20 07:10:00	SPY	ETF	276.2	276.2	276.04	276.06	11225.0
2018-06-20 07:15:00	SPY	ETF	276.0	276.05	275.99	275.99	28863.0
2018-06-20 07:20:00	SPY	ETF	275.99	276.04	275.96	276.04	5012.0
2018-06-20 07:25:00	SPY	ETF	276.04	276.09	276.04	276.09	5848.0
2018-06-20 07:30:00	SPY	ETF	276.12	276.14	276.09	276.09	2300.0
2018-06-20 07:35:00	SPY	ETF	276.06	276.2	276.06	276.2	5307.0
2018-06-20 07:40:00	SPY	ETF	276.2	276.2	276.14	276.15	31743.0
2018-06-20 07:45:00	SPY	ETF	276.15	276.15	276.15	276.15	22510.0
2018-06-20 07:50:00	SPY	ETF	276.14	276.19	276.12	276.12	3068.0
2018-06-20 07:55:00	SPY	ETF	276.11	276.11	276.07	276.1	3755.0
2018-06-20 08:00:00	SPY	ETF	276.32	276.42	275.62	276.18	25370.0
2018-06-20 08:05:00	SPY	ETF	276.19	276.2	276.16	276.16	28310.0
2018-06-20 08:10:00	SPY	ETF	276.16	276.2	276.15	276.15	19025.0
2018-06-20 08:15:00	SPY	ETF	276.19	276.19	276.16	276.17	8352.0
2018-06-20 08:20:00	SPY	ETF	276.16	276.3	276.16	276.3	28555.0
2018-06-20 08:25:00	SPY	ETF	276.29	276.3	276.23	276.29	24070.0
2018-06-20 08:30:00	SPY	ETF	276.27	276.29	276.21	276.23	27155.0
2018-06-20 08:35:00	SPY	ETF	276.22	276.27	276.21	276.26	7121.0
2018-06-20 08:40:00	SPY	ETF	276.28	276.29	276.26	276.26	2724.0
2018-06-20 08:45:00	SPY	ETF	276.27	276.31	276.26	276.29	13113.0
2018-06-20 08:50:00	SPY	ETF	276.3	276.38	276.26	276.37	32514.0
2018-06-20 08:55:00	SPY	ETF	276.3601	276.39	276.35	276.35	19733.0
2018-06-20 09:00:00	SPY	ETF	276.35	276.37	276.31	276.37	26703.0

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

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