PREVIEW / etf_5min / 2018-02-01

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-02-01.parquet
  size:    1.5 MB
  rows:    63,519

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-02-01 04:00:00	SPY	ETF	282.63	282.63	282.63	282.63	200.0
2018-02-01 04:05:00	SPY	ETF	282.68	282.71	282.68	282.71	700.0
2018-02-01 04:20:00	SPY	ETF	282.52	282.55	282.52	282.55	320.0
2018-02-01 04:25:00	SPY	ETF	282.47	282.47	282.45	282.45	600.0
2018-02-01 04:30:00	SPY	ETF	282.42	282.42	282.38	282.38	600.0
2018-02-01 04:35:00	SPY	ETF	282.5	282.51	282.5	282.51	2500.0
2018-02-01 04:55:00	SPY	ETF	282.47	282.47	282.47	282.47	300.0
2018-02-01 05:00:00	SPY	ETF	282.42	282.42	282.4	282.4	1150.0
2018-02-01 05:10:00	SPY	ETF	282.5	282.5	282.4	282.42	900.0
2018-02-01 05:15:00	SPY	ETF	282.4	282.42	282.4	282.42	510.0
2018-02-01 05:35:00	SPY	ETF	282.57	282.57	282.57	282.57	300.0
2018-02-01 05:40:00	SPY	ETF	282.55	282.55	282.42	282.42	700.0
2018-02-01 05:45:00	SPY	ETF	282.42	282.44	282.39	282.39	3030.0
2018-02-01 05:50:00	SPY	ETF	282.34	282.35	282.27	282.34	4030.0
2018-02-01 05:55:00	SPY	ETF	282.27	282.29	282.27	282.29	2010.0
2018-02-01 06:00:00	SPY	ETF	282.14	282.19	282.14	282.17	864.0
2018-02-01 06:05:00	SPY	ETF	282.08	282.08	282.03	282.03	650.0
2018-02-01 06:10:00	SPY	ETF	282.05	282.13	282.05	282.13	1215.0
2018-02-01 06:15:00	SPY	ETF	282.19	282.19	282.19	282.19	500.0
2018-02-01 06:20:00	SPY	ETF	282.23	282.23	282.23	282.23	100.0
2018-02-01 06:30:00	SPY	ETF	282.34	282.34	282.32	282.32	660.0
2018-02-01 06:35:00	SPY	ETF	282.32	282.32	282.26	282.32	1700.0
2018-02-01 06:40:00	SPY	ETF	282.28	282.28	282.24	282.24	5400.0
2018-02-01 06:45:00	SPY	ETF	282.19	282.19	282.08	282.1	29000.0
2018-02-01 06:50:00	SPY	ETF	282.09	282.2	282.08	282.2	22599.0
2018-02-01 06:55:00	SPY	ETF	282.18	282.19	282.18	282.19	500.0
2018-02-01 07:00:00	SPY	ETF	282.22	282.22	282.1	282.1	29269.0
2018-02-01 07:05:00	SPY	ETF	282.12	282.17	282.05	282.17	2705.0
2018-02-01 07:10:00	SPY	ETF	282.1	282.16	282.0	282.0	14072.0
2018-02-01 07:15:00	SPY	ETF	281.98	282.0	281.94	282.0	26238.0
2018-02-01 07:20:00	SPY	ETF	281.95	282.05	281.89	282.05	3132.0
2018-02-01 07:25:00	SPY	ETF	282.16	282.16	282.12	282.12	905.0
2018-02-01 07:30:00	SPY	ETF	282.14	282.17	282.11	282.15	23216.0
2018-02-01 07:35:00	SPY	ETF	282.08	282.08	282.02	282.02	2671.0
2018-02-01 07:40:00	SPY	ETF	282.05	282.15	282.0	282.0	11670.0
2018-02-01 07:45:00	SPY	ETF	282.05	282.08	282.01	282.06	6315.0
2018-02-01 07:50:00	SPY	ETF	282.09	282.24	282.08	282.14	104425.0
2018-02-01 07:55:00	SPY	ETF	282.12	282.25	282.12	282.25	8058.0
2018-02-01 08:00:00	SPY	ETF	282.22	282.94	281.89	282.15	100935.0
2018-02-01 08:05:00	SPY	ETF	282.18	282.28	282.11	282.16	85815.0
2018-02-01 08:10:00	SPY	ETF	282.12	282.2	282.04	282.05	15209.0
2018-02-01 08:15:00	SPY	ETF	282.08	282.08	281.39	281.45	129100.0
2018-02-01 08:20:00	SPY	ETF	281.45	281.65	281.44	281.59	102426.0
2018-02-01 08:25:00	SPY	ETF	281.65	281.9	281.53	281.54	46073.0
2018-02-01 08:30:00	SPY	ETF	281.52	281.52	280.88	281.26	301442.0
2018-02-01 08:35:00	SPY	ETF	281.25	281.35	281.17	281.28	100482.0
2018-02-01 08:40:00	SPY	ETF	281.23	281.23	280.96	281.12	149116.0
2018-02-01 08:45:00	SPY	ETF	281.09	281.28	280.96	280.98	148147.0
2018-02-01 08:50:00	SPY	ETF	280.95	281.21	280.75	281.14	206686.0
2018-02-01 08:55:00	SPY	ETF	281.16	281.9	281.05	281.11	92451.0

> showing 50 of 63,519 rows — these rows as CSV

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