PREVIEW / etf_5min / 2016-07-20

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-07-20.parquet
  size:    1.1 MB
  rows:    49,747

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
2016-07-20 04:00:00	SPY	ETF	216.4	216.4	216.4	216.4	595.0
2016-07-20 04:05:00	SPY	ETF	216.44	216.5	216.44	216.45	1900.0
2016-07-20 04:10:00	SPY	ETF	216.48	216.54	216.48	216.54	2006.0
2016-07-20 04:15:00	SPY	ETF	216.48	216.53	216.48	216.5	1101.0
2016-07-20 04:20:00	SPY	ETF	216.5	216.56	216.5	216.53	763.0
2016-07-20 04:25:00	SPY	ETF	216.54	216.57	216.53	216.57	1827.0
2016-07-20 04:30:00	SPY	ETF	216.57	216.57	216.56	216.56	1025.0
2016-07-20 04:35:00	SPY	ETF	216.58	216.64	216.58	216.64	1995.0
2016-07-20 04:40:00	SPY	ETF	216.65	216.73	216.65	216.73	1934.0
2016-07-20 04:45:00	SPY	ETF	216.73	216.85	216.73	216.85	2141.0
2016-07-20 04:50:00	SPY	ETF	216.83	216.85	216.78	216.78	2405.0
2016-07-20 04:55:00	SPY	ETF	216.75	216.76	216.75	216.75	2105.0
2016-07-20 05:00:00	SPY	ETF	216.75	216.79	216.75	216.78	3200.0
2016-07-20 05:05:00	SPY	ETF	216.85	216.97	216.85	216.93	6665.0
2016-07-20 05:10:00	SPY	ETF	216.96	216.96	216.94	216.94	1597.0
2016-07-20 05:15:00	SPY	ETF	216.88	216.91	216.88	216.91	2000.0
2016-07-20 05:20:00	SPY	ETF	216.97	217.04	216.97	217.03	5618.0
2016-07-20 05:25:00	SPY	ETF	217.06	217.09	217.03	217.09	2411.0
2016-07-20 05:30:00	SPY	ETF	217.03	217.04	217.0	217.0	13104.0
2016-07-20 05:35:00	SPY	ETF	217.03	217.04	217.0	217.0	6505.0
2016-07-20 05:40:00	SPY	ETF	217.03	217.05	217.03	217.05	2100.0
2016-07-20 05:45:00	SPY	ETF	217.0	217.0	217.0	217.0	300.0
2016-07-20 05:50:00	SPY	ETF	217.09	217.09	217.05	217.06	2000.0
2016-07-20 05:55:00	SPY	ETF	217.04	217.04	217.03	217.03	900.0
2016-07-20 06:00:00	SPY	ETF	217.05	217.05	217.05	217.05	100.0
2016-07-20 06:05:00	SPY	ETF	217.03	217.03	217.0	217.0	451.0
2016-07-20 06:10:00	SPY	ETF	217.03	217.04	216.98	217.04	643.0
2016-07-20 06:15:00	SPY	ETF	217.0	217.04	217.0	217.04	2100.0
2016-07-20 06:20:00	SPY	ETF	217.0	217.0	216.98	217.0	3800.0
2016-07-20 06:25:00	SPY	ETF	217.01	217.01	216.98	216.98	1600.0
2016-07-20 06:30:00	SPY	ETF	216.98	217.0	216.98	217.0	4000.0
2016-07-20 06:35:00	SPY	ETF	217.01	217.01	217.01	217.01	200.0
2016-07-20 06:40:00	SPY	ETF	216.98	216.98	216.96	216.96	1301.0
2016-07-20 06:45:00	SPY	ETF	216.93	216.96	216.93	216.95	1200.0
2016-07-20 06:50:00	SPY	ETF	216.96	217.01	216.95	216.95	1403.0
2016-07-20 06:55:00	SPY	ETF	216.96	216.96	216.93	216.93	1186.0
2016-07-20 07:00:00	SPY	ETF	216.93	216.99	216.93	216.99	1904.0
2016-07-20 07:05:00	SPY	ETF	216.93	216.96	216.9	216.9	9051.0
2016-07-20 07:10:00	SPY	ETF	216.88	216.9	216.88	216.88	5701.0
2016-07-20 07:15:00	SPY	ETF	216.9	216.9	216.9	216.9	3672.0
2016-07-20 07:20:00	SPY	ETF	216.9	216.91	216.9	216.9	928.0
2016-07-20 07:25:00	SPY	ETF	216.89	216.9	216.89	216.89	1199.0
2016-07-20 07:30:00	SPY	ETF	216.87	216.89	216.86	216.86	24608.0
2016-07-20 07:35:00	SPY	ETF	216.86	216.9	216.85	216.9	6704.0
2016-07-20 07:40:00	SPY	ETF	216.91	216.91	216.85	216.86	5751.0
2016-07-20 07:45:00	SPY	ETF	216.86	216.86	216.8	216.81	6435.0
2016-07-20 07:50:00	SPY	ETF	216.81	216.83	216.8	216.83	75226.0
2016-07-20 07:55:00	SPY	ETF	216.85	216.86	216.83	216.83	3276.0
2016-07-20 08:00:00	SPY	ETF	216.83	216.96	216.79	216.81	27471.0
2016-07-20 08:05:00	SPY	ETF	215.973	216.81	215.973	216.76	90174.0

> showing 50 of 49,747 rows — these rows as CSV

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