PREVIEW / etf_5min / 2016-07-18

all etf 5-min files

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

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-18 04:00:00	SPY	ETF	216.2	216.32	216.2	216.25	17103.0
2016-07-18 04:05:00	SPY	ETF	216.25	216.36	216.24	216.36	3155.0
2016-07-18 04:10:00	SPY	ETF	216.29	216.39	216.28	216.28	2015.0
2016-07-18 04:15:00	SPY	ETF	216.12	216.16	216.02	216.11	13189.0
2016-07-18 04:20:00	SPY	ETF	216.07	216.16	216.06	216.16	8178.0
2016-07-18 04:30:00	SPY	ETF	216.24	216.24	216.24	216.24	1076.0
2016-07-18 04:35:00	SPY	ETF	216.26	216.34	216.26	216.34	6200.0
2016-07-18 04:40:00	SPY	ETF	216.28	216.35	216.28	216.35	2502.0
2016-07-18 04:45:00	SPY	ETF	216.25	216.25	216.21	216.21	3926.0
2016-07-18 04:50:00	SPY	ETF	216.23	216.25	216.23	216.25	305.0
2016-07-18 04:55:00	SPY	ETF	216.26	216.47	216.26	216.47	2999.0
2016-07-18 05:00:00	SPY	ETF	216.43	216.45	216.38	216.44	17254.0
2016-07-18 05:05:00	SPY	ETF	216.44	216.47	216.42	216.42	42958.0
2016-07-18 05:10:00	SPY	ETF	216.4	216.42	216.4	216.42	604.0
2016-07-18 05:15:00	SPY	ETF	216.32	216.32	216.29	216.3	898.0
2016-07-18 05:20:00	SPY	ETF	216.25	216.29	216.19	216.29	2662.0
2016-07-18 05:25:00	SPY	ETF	216.27	216.28	216.23	216.23	15352.0
2016-07-18 05:30:00	SPY	ETF	216.22	216.22	216.22	216.22	600.0
2016-07-18 05:35:00	SPY	ETF	216.2	216.2	216.17	216.19	2352.0
2016-07-18 05:40:00	SPY	ETF	216.15	216.15	216.06	216.06	5557.0
2016-07-18 05:45:00	SPY	ETF	216.08	216.08	215.96	215.99	11502.0
2016-07-18 05:50:00	SPY	ETF	216.01	216.04	215.97	215.97	1302.0
2016-07-18 05:55:00	SPY	ETF	215.98	216.01	215.96	215.96	903.0
2016-07-18 06:00:00	SPY	ETF	216.06	216.12	216.06	216.12	2604.0
2016-07-18 06:05:00	SPY	ETF	216.09	216.11	216.09	216.11	776.0
2016-07-18 06:10:00	SPY	ETF	216.14	216.14	216.14	216.14	201.0
2016-07-18 06:15:00	SPY	ETF	216.14	216.16	216.14	216.16	554.0
2016-07-18 06:20:00	SPY	ETF	216.16	216.2	216.12	216.16	8718.0
2016-07-18 06:25:00	SPY	ETF	216.09	216.09	216.05	216.05	834.0
2016-07-18 06:30:00	SPY	ETF	215.95	215.97	215.89	215.89	1605.0
2016-07-18 06:35:00	SPY	ETF	215.89	215.93	215.89	215.89	7701.0
2016-07-18 06:40:00	SPY	ETF	215.89	215.96	215.89	215.96	1804.0
2016-07-18 06:45:00	SPY	ETF	215.9	215.93	215.87	215.93	1262.0
2016-07-18 06:50:00	SPY	ETF	215.99	216.04	215.99	216.04	6453.0
2016-07-18 06:55:00	SPY	ETF	216.04	216.13	216.04	216.12	3199.0
2016-07-18 07:00:00	SPY	ETF	216.06	216.1	216.06	216.06	34247.0
2016-07-18 07:05:00	SPY	ETF	216.06	216.12	216.06	216.12	34669.0
2016-07-18 07:10:00	SPY	ETF	216.11	216.13	216.06	216.11	10133.0
2016-07-18 07:15:00	SPY	ETF	216.12	216.14	216.1	216.11	30065.0
2016-07-18 07:20:00	SPY	ETF	216.12	216.13	216.06	216.08	21746.0
2016-07-18 07:25:00	SPY	ETF	216.06	216.08	216.02	216.07	24329.0
2016-07-18 07:30:00	SPY	ETF	216.05	216.1	216.04	216.07	34313.0
2016-07-18 07:35:00	SPY	ETF	216.08	216.11	216.08	216.09	9709.0
2016-07-18 07:40:00	SPY	ETF	216.09	216.25	216.09	216.23	39184.0
2016-07-18 07:45:00	SPY	ETF	216.22	216.28	216.21	216.27	20409.0
2016-07-18 07:50:00	SPY	ETF	216.27	216.28	216.26	216.28	39994.0
2016-07-18 07:55:00	SPY	ETF	216.3	216.37	216.3	216.37	11487.0
2016-07-18 08:00:00	SPY	ETF	216.37	216.38	216.03	216.24	225069.0
2016-07-18 08:05:00	SPY	ETF	216.2	216.22	216.18	216.2	85039.0
2016-07-18 08:10:00	SPY	ETF	216.2	216.28	216.2	216.27	88929.0

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

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