PREVIEW / etf_5min / 2014-07-02

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-02.parquet
  size:    979 KB
  rows:    43,050

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-07-02 04:00:00	SPY	ETF	197.15	197.15	197.14	197.14	500.0
2014-07-02 04:10:00	SPY	ETF	197.18	197.18	197.16	197.16	700.0
2014-07-02 04:25:00	SPY	ETF	197.2	197.2	197.2	197.2	1500.0
2014-07-02 04:30:00	SPY	ETF	197.2	197.2	197.18	197.18	1000.0
2014-07-02 04:35:00	SPY	ETF	197.17	197.17	197.17	197.17	200.0
2014-07-02 04:40:00	SPY	ETF	197.14	197.14	197.14	197.14	115.0
2014-07-02 05:05:00	SPY	ETF	197.19	197.19	197.19	197.19	200.0
2014-07-02 05:15:00	SPY	ETF	197.19	197.19	197.19	197.19	400.0
2014-07-02 05:20:00	SPY	ETF	197.22	197.22	197.22	197.22	138.0
2014-07-02 05:25:00	SPY	ETF	197.16	197.16	197.16	197.16	200.0
2014-07-02 05:30:00	SPY	ETF	197.18	197.18	197.15	197.15	635.0
2014-07-02 05:35:00	SPY	ETF	197.1	197.18	197.1	197.18	800.0
2014-07-02 05:40:00	SPY	ETF	197.18	197.18	197.15	197.15	333.0
2014-07-02 05:45:00	SPY	ETF	197.18	197.18	197.18	197.18	600.0
2014-07-02 05:55:00	SPY	ETF	197.17	197.17	197.17	197.17	100.0
2014-07-02 06:15:00	SPY	ETF	197.17	197.17	197.17	197.17	200.0
2014-07-02 06:25:00	SPY	ETF	197.14	197.14	197.14	197.14	100.0
2014-07-02 06:35:00	SPY	ETF	197.15	197.15	197.15	197.15	200.0
2014-07-02 06:40:00	SPY	ETF	197.15	197.15	197.1	197.11	3400.0
2014-07-02 06:45:00	SPY	ETF	197.12	197.12	197.09	197.09	2601.0
2014-07-02 06:55:00	SPY	ETF	197.1	197.1	197.1	197.1	1660.0
2014-07-02 07:00:00	SPY	ETF	197.15	197.18	197.15	197.18	10100.0
2014-07-02 07:05:00	SPY	ETF	197.18	197.18	197.18	197.18	400.0
2014-07-02 07:10:00	SPY	ETF	197.19	197.25	197.19	197.25	6550.0
2014-07-02 07:15:00	SPY	ETF	197.23	197.23	197.23	197.23	44600.0
2014-07-02 07:20:00	SPY	ETF	197.22	197.22	197.22	197.22	100.0
2014-07-02 07:25:00	SPY	ETF	197.22	197.23	197.22	197.23	600.0
2014-07-02 07:30:00	SPY	ETF	197.22	197.24	197.22	197.24	26670.0
2014-07-02 07:35:00	SPY	ETF	197.26	197.27	197.25	197.25	11100.0
2014-07-02 07:40:00	SPY	ETF	197.27	197.28	197.27	197.28	9702.0
2014-07-02 07:45:00	SPY	ETF	197.26	197.26	197.26	197.26	200.0
2014-07-02 07:50:00	SPY	ETF	197.25	197.28	197.25	197.28	13900.0
2014-07-02 07:55:00	SPY	ETF	197.27	197.27	197.27	197.27	200.0
2014-07-02 08:00:00	SPY	ETF	197.27	197.27	197.22	197.25	22704.0
2014-07-02 08:05:00	SPY	ETF	197.175	197.26	197.175	197.26	18513.0
2014-07-02 08:10:00	SPY	ETF	197.25	197.26	197.23	197.25	5513.0
2014-07-02 08:15:00	SPY	ETF	197.27	197.5	197.19	197.24	539189.0
2014-07-02 08:20:00	SPY	ETF	197.23	197.3	197.23	197.23	68279.0
2014-07-02 08:25:00	SPY	ETF	197.23	197.25	197.22	197.22	30247.0
2014-07-02 08:30:00	SPY	ETF	197.19	197.21	197.18	197.21	20180.0
2014-07-02 08:35:00	SPY	ETF	197.21	197.24	197.21	197.22	27557.0
2014-07-02 08:40:00	SPY	ETF	197.22	197.29	197.19	197.29	22968.0
2014-07-02 08:45:00	SPY	ETF	197.29	197.33	197.26	197.3	52531.0
2014-07-02 08:50:00	SPY	ETF	197.3	197.3	197.18	197.18	48613.0
2014-07-02 08:55:00	SPY	ETF	197.17	197.22	197.17	197.22	40636.0
2014-07-02 09:00:00	SPY	ETF	197.21	197.21	197.16	197.2	12863.0
2014-07-02 09:05:00	SPY	ETF	197.18	197.18	197.08	197.1	68422.0
2014-07-02 09:10:00	SPY	ETF	197.1	197.13	197.06	197.11	74869.0
2014-07-02 09:15:00	SPY	ETF	197.11	197.14	197.03	197.03	23605.0
2014-07-02 09:20:00	SPY	ETF	197.03	197.03	196.94	196.95	97468.0

> showing 50 of 43,050 rows — these rows as CSV

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