PREVIEW / etf_5min / 2013-07-31

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-07-31.parquet
  size:    1001 KB
  rows:    41,526

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
2013-07-31 04:05:00	SPY	ETF	168.83	168.83	168.83	168.83	600.0
2013-07-31 04:10:00	SPY	ETF	168.93	169.08	168.93	169.08	2300.0
2013-07-31 04:15:00	SPY	ETF	169.09	169.1	169.09	169.1	300.0
2013-07-31 04:20:00	SPY	ETF	169.03	169.03	169.03	169.03	200.0
2013-07-31 04:30:00	SPY	ETF	169.08	169.08	169.08	169.08	500.0
2013-07-31 04:35:00	SPY	ETF	169.03	169.03	169.03	169.03	200.0
2013-07-31 04:40:00	SPY	ETF	169.07	169.07	169.04	169.04	1000.0
2013-07-31 04:50:00	SPY	ETF	169.05	169.09	169.05	169.09	1200.0
2013-07-31 04:55:00	SPY	ETF	169.08	169.18	169.08	169.15	1000.0
2013-07-31 05:00:00	SPY	ETF	169.13	169.13	169.1	169.1	4200.0
2013-07-31 05:05:00	SPY	ETF	169.08	169.08	169.05	169.08	1600.0
2013-07-31 05:10:00	SPY	ETF	169.12	169.12	169.12	169.12	300.0
2013-07-31 05:15:00	SPY	ETF	169.08	169.08	168.98	168.98	29700.0
2013-07-31 05:20:00	SPY	ETF	168.98	168.98	168.93	168.93	4200.0
2013-07-31 05:25:00	SPY	ETF	168.98	168.99	168.98	168.99	300.0
2013-07-31 05:30:00	SPY	ETF	169.03	169.03	169.03	169.03	600.0
2013-07-31 05:35:00	SPY	ETF	169.01	169.01	169.01	169.01	100.0
2013-07-31 05:45:00	SPY	ETF	169.04	169.04	169.04	169.04	500.0
2013-07-31 05:55:00	SPY	ETF	168.98	168.98	168.98	168.98	400.0
2013-07-31 06:00:00	SPY	ETF	168.98	168.98	168.98	168.98	10100.0
2013-07-31 06:05:00	SPY	ETF	169.03	169.05	169.03	169.05	21400.0
2013-07-31 06:10:00	SPY	ETF	169.03	169.03	169.03	169.03	200.0
2013-07-31 06:15:00	SPY	ETF	169.06	169.08	169.06	169.08	51300.0
2013-07-31 06:20:00	SPY	ETF	169.1	169.105	169.1	169.105	14100.0
2013-07-31 06:25:00	SPY	ETF	169.11	169.13	169.11	169.13	600.0
2013-07-31 06:30:00	SPY	ETF	169.08	169.08	169.08	169.08	400.0
2013-07-31 06:35:00	SPY	ETF	169.13	169.14	169.13	169.14	6700.0
2013-07-31 06:40:00	SPY	ETF	169.1	169.1	169.08	169.08	600.0
2013-07-31 06:45:00	SPY	ETF	169.04	169.04	169.03	169.03	800.0
2013-07-31 06:50:00	SPY	ETF	168.99	168.99	168.98	168.98	625.0
2013-07-31 07:00:00	SPY	ETF	168.94	169.0	168.93	169.0	4400.0
2013-07-31 07:05:00	SPY	ETF	169.02	169.02	168.96	168.96	600.0
2013-07-31 07:15:00	SPY	ETF	169.02	169.02	169.0	169.0	12600.0
2013-07-31 07:20:00	SPY	ETF	168.99	168.99	168.96	168.96	500.0
2013-07-31 07:25:00	SPY	ETF	168.95	168.95	168.93	168.93	4100.0
2013-07-31 07:30:00	SPY	ETF	168.93	168.93	168.91	168.93	2800.0
2013-07-31 07:35:00	SPY	ETF	168.93	168.93	168.93	168.93	400.0
2013-07-31 07:40:00	SPY	ETF	168.89	168.89	168.83	168.83	18600.0
2013-07-31 07:45:00	SPY	ETF	168.84	168.84	168.84	168.84	1000.0
2013-07-31 07:50:00	SPY	ETF	168.87	168.87	168.87	168.87	200.0
2013-07-31 07:55:00	SPY	ETF	168.85	168.87	168.83	168.83	57080.0
2013-07-31 08:00:00	SPY	ETF	168.89	168.89	168.84	168.85	216543.0
2013-07-31 08:05:00	SPY	ETF	168.88	168.91	168.87	168.87	11065.0
2013-07-31 08:10:00	SPY	ETF	168.88	168.97	168.87	168.95	99855.0
2013-07-31 08:15:00	SPY	ETF	168.96	169.0	168.78	168.83	59842.0
2013-07-31 08:20:00	SPY	ETF	168.81	168.82	168.77	168.82	69047.0
2013-07-31 08:25:00	SPY	ETF	168.83	168.94	168.82	168.88	110090.0
2013-07-31 08:30:00	SPY	ETF	168.86	169.0	168.58	168.75	444617.0
2013-07-31 08:35:00	SPY	ETF	168.74	168.81	168.72	168.8	83405.0
2013-07-31 08:40:00	SPY	ETF	168.8	168.99	168.77	168.94	147430.0

> showing 50 of 41,526 rows — these rows as CSV

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