PREVIEW / etf_5min / 2017-11-21

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-11-21.parquet
  size:    1.3 MB
  rows:    55,736

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-11-21 04:00:00	SPY	ETF	258.27	258.27	258.27	258.27	500.0
2017-11-21 04:05:00	SPY	ETF	258.24	258.24	258.24	258.24	200.0
2017-11-21 04:15:00	SPY	ETF	258.2	258.2	258.2	258.2	100.0
2017-11-21 04:20:00	SPY	ETF	258.24	258.24	258.24	258.24	300.0
2017-11-21 04:30:00	SPY	ETF	258.35	258.37	258.33	258.37	600.0
2017-11-21 04:40:00	SPY	ETF	258.4	258.4	258.4	258.4	400.0
2017-11-21 05:00:00	SPY	ETF	258.5	258.55	258.5	258.55	900.0
2017-11-21 05:05:00	SPY	ETF	258.55	258.65	258.55	258.65	1500.0
2017-11-21 05:15:00	SPY	ETF	258.63	258.63	258.63	258.63	2000.0
2017-11-21 05:20:00	SPY	ETF	258.75	258.8	258.75	258.8	1910.0
2017-11-21 05:30:00	SPY	ETF	258.88	258.88	258.88	258.88	100.0
2017-11-21 05:35:00	SPY	ETF	258.86	258.86	258.86	258.86	100.0
2017-11-21 05:55:00	SPY	ETF	258.85	258.87	258.85	258.87	205.0
2017-11-21 06:00:00	SPY	ETF	258.9	258.95	258.9	258.95	1700.0
2017-11-21 06:15:00	SPY	ETF	258.88	258.88	258.88	258.88	100.0
2017-11-21 06:20:00	SPY	ETF	258.9	258.9	258.9	258.9	300.0
2017-11-21 06:25:00	SPY	ETF	258.9	258.91	258.88	258.91	5900.0
2017-11-21 06:30:00	SPY	ETF	258.89	258.89	258.89	258.89	19800.0
2017-11-21 06:35:00	SPY	ETF	258.89	258.89	258.89	258.89	5159.0
2017-11-21 06:40:00	SPY	ETF	258.86	258.87	258.85	258.87	1500.0
2017-11-21 06:45:00	SPY	ETF	258.88	258.91	258.88	258.9	5300.0
2017-11-21 06:50:00	SPY	ETF	258.9	258.91	258.9	258.9	600.0
2017-11-21 06:55:00	SPY	ETF	258.93	259.05	258.93	259.04	35300.0
2017-11-21 07:00:00	SPY	ETF	259.05	259.05	258.97	259.04	39370.0
2017-11-21 07:05:00	SPY	ETF	258.99	259.02	258.99	259.02	4356.0
2017-11-21 07:10:00	SPY	ETF	259.0	259.07	258.98	259.05	19979.0
2017-11-21 07:15:00	SPY	ETF	259.06	259.14	259.04	259.12	49277.0
2017-11-21 07:20:00	SPY	ETF	259.1	259.16	259.1	259.15	46587.0
2017-11-21 07:25:00	SPY	ETF	259.11	259.14	259.09	259.1	27000.0
2017-11-21 07:30:00	SPY	ETF	259.11	259.11	259.06	259.06	9974.0
2017-11-21 07:35:00	SPY	ETF	259.08	259.12	259.07	259.1	83169.0
2017-11-21 07:40:00	SPY	ETF	259.1	259.1	259.06	259.06	34688.0
2017-11-21 07:45:00	SPY	ETF	259.08	259.16	259.08	259.16	9276.0
2017-11-21 07:50:00	SPY	ETF	259.12	259.18	259.09	259.1	49116.0
2017-11-21 07:55:00	SPY	ETF	259.1	259.1	259.09	259.1	15500.0
2017-11-21 08:00:00	SPY	ETF	259.1	259.2	259.0	259.2	83152.0
2017-11-21 08:05:00	SPY	ETF	259.2	259.33	259.18	259.28	64339.0
2017-11-21 08:10:00	SPY	ETF	259.28	259.28	259.22	259.22	26830.0
2017-11-21 08:15:00	SPY	ETF	259.23	259.23	259.13	259.19	67670.0
2017-11-21 08:20:00	SPY	ETF	259.2	259.24	259.19	259.24	21978.0
2017-11-21 08:25:00	SPY	ETF	259.24	259.24	259.17	259.17	59506.0
2017-11-21 08:30:00	SPY	ETF	259.18	259.2	259.15	259.2	59082.0
2017-11-21 08:35:00	SPY	ETF	259.19	259.24	259.19	259.2	39307.0
2017-11-21 08:40:00	SPY	ETF	259.2	259.29	259.2	259.29	53979.0
2017-11-21 08:45:00	SPY	ETF	259.29	259.32	259.24	259.25	40238.0
2017-11-21 08:50:00	SPY	ETF	259.26	259.3	259.25	259.3	38925.0
2017-11-21 08:55:00	SPY	ETF	259.3	259.37	259.29	259.29	31360.0
2017-11-21 09:00:00	SPY	ETF	259.29	259.34	259.25	259.34	29917.0
2017-11-21 09:05:00	SPY	ETF	259.34	259.34	259.29	259.29	4964.0
2017-11-21 09:10:00	SPY	ETF	259.28	259.3	259.25	259.28	46500.0

> showing 50 of 55,736 rows — these rows as CSV

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