PREVIEW / etf_5min / 2017-04-07

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-04-07.parquet
  size:    1.2 MB
  rows:    52,393

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-04-07 04:00:00	SPY	ETF	235.1	235.15	235.1	235.15	600.0
2017-04-07 04:05:00	SPY	ETF	235.0	235.0	235.0	235.0	100.0
2017-04-07 04:20:00	SPY	ETF	235.03	235.03	234.96	234.97	1600.0
2017-04-07 04:25:00	SPY	ETF	234.96	235.0	234.96	235.0	800.0
2017-04-07 04:30:00	SPY	ETF	234.99	234.99	234.91	234.91	3600.0
2017-04-07 04:35:00	SPY	ETF	234.92	234.92	234.92	234.92	1200.0
2017-04-07 04:40:00	SPY	ETF	235.12	235.12	235.12	235.12	1500.0
2017-04-07 04:45:00	SPY	ETF	235.1	235.1	235.1	235.1	2100.0
2017-04-07 04:50:00	SPY	ETF	235.09	235.12	235.06	235.09	11000.0
2017-04-07 04:55:00	SPY	ETF	235.03	235.04	235.0	235.04	6700.0
2017-04-07 05:00:00	SPY	ETF	235.0	235.02	235.0	235.02	500.0
2017-04-07 05:05:00	SPY	ETF	234.95	234.95	234.95	234.95	1500.0
2017-04-07 05:15:00	SPY	ETF	234.89	234.89	234.89	234.89	235.0
2017-04-07 05:20:00	SPY	ETF	234.82	234.82	234.78	234.78	1510.0
2017-04-07 05:25:00	SPY	ETF	234.76	234.8	234.76	234.8	600.0
2017-04-07 05:30:00	SPY	ETF	234.7	234.73	234.7	234.71	410.0
2017-04-07 05:35:00	SPY	ETF	234.72	234.78	234.7	234.78	1100.0
2017-04-07 05:40:00	SPY	ETF	234.78	234.8	234.78	234.8	1795.0
2017-04-07 05:45:00	SPY	ETF	234.75	234.8	234.7	234.8	3700.0
2017-04-07 06:00:00	SPY	ETF	234.91	234.91	234.9	234.9	372.0
2017-04-07 06:10:00	SPY	ETF	234.9	234.9	234.83	234.86	27663.0
2017-04-07 06:15:00	SPY	ETF	234.92	234.92	234.92	234.92	596.0
2017-04-07 06:20:00	SPY	ETF	234.92	235.0	234.92	235.0	352.0
2017-04-07 06:25:00	SPY	ETF	235.0	235.04	235.0	235.04	1103.0
2017-04-07 06:30:00	SPY	ETF	235.03	235.03	235.03	235.03	1500.0
2017-04-07 06:35:00	SPY	ETF	235.01	235.05	235.01	235.05	247.0
2017-04-07 06:40:00	SPY	ETF	235.13	235.31	235.13	235.31	4221.0
2017-04-07 06:45:00	SPY	ETF	235.33	235.33	235.23	235.23	2902.0
2017-04-07 06:50:00	SPY	ETF	235.21	235.22	235.17	235.21	61907.0
2017-04-07 06:55:00	SPY	ETF	235.2	235.2	235.17	235.18	18021.0
2017-04-07 07:00:00	SPY	ETF	235.23	235.26	235.2	235.26	12486.0
2017-04-07 07:05:00	SPY	ETF	235.26	235.34	235.24	235.33	162525.0
2017-04-07 07:10:00	SPY	ETF	235.34	235.35	235.28	235.29	7012.0
2017-04-07 07:15:00	SPY	ETF	235.27	235.32	235.23	235.3	128683.0
2017-04-07 07:20:00	SPY	ETF	235.3	235.41	235.28	235.39	92538.0
2017-04-07 07:25:00	SPY	ETF	235.37	235.45	235.37	235.45	5747.0
2017-04-07 07:30:00	SPY	ETF	235.44	235.52	235.44	235.51	42355.0
2017-04-07 07:35:00	SPY	ETF	235.46	235.46	235.38	235.4	11715.0
2017-04-07 07:40:00	SPY	ETF	235.38	235.38	235.26	235.26	29181.0
2017-04-07 07:45:00	SPY	ETF	235.27	235.27	235.23	235.25	13173.0
2017-04-07 07:50:00	SPY	ETF	235.25	235.28	235.22	235.27	16092.0
2017-04-07 07:55:00	SPY	ETF	235.26	235.26	235.23	235.23	24652.0
2017-04-07 08:00:00	SPY	ETF	235.25	235.38	235.2	235.23	44549.0
2017-04-07 08:05:00	SPY	ETF	235.22	235.22	235.09	235.1	34414.0
2017-04-07 08:10:00	SPY	ETF	235.1	235.2	235.05	235.12	84713.0
2017-04-07 08:15:00	SPY	ETF	235.11	235.13	235.0	235.05	32102.0
2017-04-07 08:20:00	SPY	ETF	235.04	235.07	234.93	235.04	42838.0
2017-04-07 08:25:00	SPY	ETF	235.05	235.18	235.0	235.13	80157.0
2017-04-07 08:30:00	SPY	ETF	235.12	235.14	234.53	234.68	483121.0
2017-04-07 08:35:00	SPY	ETF	234.66	234.88	234.57	234.78	237196.0

> showing 50 of 52,393 rows — these rows as CSV

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