PREVIEW / etf_5min / 2014-11-06

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-11-06.parquet
  size:    1.1 MB
  rows:    46,119

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
2014-11-06 04:00:00	SPY	ETF	202.08	202.11	201.92	201.92	8938.0
2014-11-06 04:05:00	SPY	ETF	201.97	201.97	201.9	201.93	31200.0
2014-11-06 04:10:00	SPY	ETF	201.98	202.09	201.98	202.09	234.0
2014-11-06 04:15:00	SPY	ETF	202.04	202.04	202.04	202.04	1500.0
2014-11-06 04:35:00	SPY	ETF	202.03	202.11	202.03	202.06	4760.0
2014-11-06 04:40:00	SPY	ETF	201.99	201.99	201.98	201.98	3000.0
2014-11-06 04:45:00	SPY	ETF	202.12	202.12	202.0	202.0	1202.0
2014-11-06 04:50:00	SPY	ETF	202.03	202.03	202.03	202.03	150.0
2014-11-06 04:55:00	SPY	ETF	201.98	201.98	201.98	201.98	200.0
2014-11-06 05:00:00	SPY	ETF	202.04	202.07	202.04	202.07	3060.0
2014-11-06 05:05:00	SPY	ETF	202.09	202.09	202.09	202.09	100.0
2014-11-06 05:10:00	SPY	ETF	202.09	202.09	202.04	202.04	300.0
2014-11-06 05:20:00	SPY	ETF	202.05	202.1	202.05	202.1	700.0
2014-11-06 05:30:00	SPY	ETF	202.06	202.06	202.06	202.06	500.0
2014-11-06 05:35:00	SPY	ETF	202.11	202.11	202.11	202.11	1000.0
2014-11-06 05:40:00	SPY	ETF	202.16	202.21	202.16	202.21	2656.0
2014-11-06 05:45:00	SPY	ETF	202.11	202.11	202.11	202.11	2000.0
2014-11-06 05:50:00	SPY	ETF	202.11	202.11	202.11	202.11	1500.0
2014-11-06 05:55:00	SPY	ETF	202.22	202.22	202.21	202.21	1422.0
2014-11-06 06:00:00	SPY	ETF	202.26	202.26	202.15	202.15	3000.0
2014-11-06 06:05:00	SPY	ETF	202.31	202.31	202.31	202.31	1050.0
2014-11-06 06:10:00	SPY	ETF	202.25	202.25	202.14	202.14	440.0
2014-11-06 06:15:00	SPY	ETF	202.13	202.13	202.13	202.13	2260.0
2014-11-06 06:20:00	SPY	ETF	202.23	202.23	202.18	202.18	400.0
2014-11-06 06:25:00	SPY	ETF	202.17	202.19	202.17	202.18	1643.0
2014-11-06 06:30:00	SPY	ETF	202.18	202.21	202.17	202.21	7400.0
2014-11-06 06:40:00	SPY	ETF	202.15	202.19	202.15	202.19	4940.0
2014-11-06 06:45:00	SPY	ETF	202.24	202.24	202.2	202.2	2232.0
2014-11-06 06:50:00	SPY	ETF	202.18	202.18	202.13	202.15	4655.0
2014-11-06 07:00:00	SPY	ETF	202.2	202.21	202.18	202.18	25500.0
2014-11-06 07:05:00	SPY	ETF	202.18	202.22	202.13	202.15	24400.0
2014-11-06 07:10:00	SPY	ETF	202.16	202.16	202.1	202.1	7100.0
2014-11-06 07:15:00	SPY	ETF	202.13	202.14	201.98	202.0	16368.0
2014-11-06 07:20:00	SPY	ETF	202.01	202.01	201.92	201.96	36555.0
2014-11-06 07:25:00	SPY	ETF	201.96	201.96	201.95	201.95	600.0
2014-11-06 07:30:00	SPY	ETF	201.96	202.01	201.96	202.0	10820.0
2014-11-06 07:35:00	SPY	ETF	202.0	202.04	201.99	201.99	14100.0
2014-11-06 07:40:00	SPY	ETF	202.05	202.15	202.03	202.13	16978.0
2014-11-06 07:45:00	SPY	ETF	202.1	202.19	202.07	202.18	9182.0
2014-11-06 07:50:00	SPY	ETF	202.15	202.15	202.1	202.1	25743.0
2014-11-06 07:55:00	SPY	ETF	202.08	202.08	201.92	201.97	25957.0
2014-11-06 08:00:00	SPY	ETF	201.98	202.04	201.96	202.03	26704.0
2014-11-06 08:05:00	SPY	ETF	201.98	202.03	201.97	202.02	7400.0
2014-11-06 08:10:00	SPY	ETF	202.03	202.04	201.97	202.03	7006.0
2014-11-06 08:15:00	SPY	ETF	202.03	202.12	202.01	202.08	28207.0
2014-11-06 08:20:00	SPY	ETF	202.08	202.09	202.01	202.06	18694.0
2014-11-06 08:25:00	SPY	ETF	202.06	202.12	202.05	202.08	15844.0
2014-11-06 08:30:00	SPY	ETF	202.11	202.59	202.07	202.56	314852.0
2014-11-06 08:35:00	SPY	ETF	202.57	203.3	202.47	202.81	937669.0
2014-11-06 08:40:00	SPY	ETF	202.83	202.88	202.47	202.47	403091.0

> showing 50 of 46,119 rows — these rows as CSV

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