PREVIEW / etf_5min / 2013-02-15

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-02-15.parquet
  size:    933 KB
  rows:    39,136

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-02-15 04:00:00	SPY	ETF	152.07	152.07	151.95	151.99	7700.0
2013-02-15 04:05:00	SPY	ETF	151.98	151.98	151.91	151.91	3800.0
2013-02-15 04:10:00	SPY	ETF	151.94	151.94	151.94	151.94	250.0
2013-02-15 04:15:00	SPY	ETF	151.94	151.95	151.9	151.9	12900.0
2013-02-15 04:20:00	SPY	ETF	151.92	151.92	151.92	151.92	2700.0
2013-02-15 04:30:00	SPY	ETF	151.87	151.87	151.85	151.85	2000.0
2013-02-15 05:05:00	SPY	ETF	152.02	152.02	152.02	152.02	5000.0
2013-02-15 05:25:00	SPY	ETF	152.1	152.1	152.1	152.1	1000.0
2013-02-15 05:30:00	SPY	ETF	152.12	152.12	152.12	152.12	100.0
2013-02-15 05:40:00	SPY	ETF	152.05	152.05	152.05	152.05	212.0
2013-02-15 05:45:00	SPY	ETF	152.08	152.08	152.04	152.04	10350.0
2013-02-15 05:50:00	SPY	ETF	152.04	152.04	152.04	152.04	100.0
2013-02-15 05:55:00	SPY	ETF	152.07	152.07	152.05	152.05	1370.0
2013-02-15 06:00:00	SPY	ETF	152.05	152.05	152.04	152.04	3000.0
2013-02-15 06:05:00	SPY	ETF	152.03	152.03	152.03	152.03	200.0
2013-02-15 06:10:00	SPY	ETF	152.03	152.05	152.03	152.05	1200.0
2013-02-15 06:15:00	SPY	ETF	152.07	152.07	152.07	152.07	180.0
2013-02-15 06:20:00	SPY	ETF	152.05	152.09	152.03	152.09	3250.0
2013-02-15 06:30:00	SPY	ETF	152.09	152.09	152.09	152.09	200.0
2013-02-15 06:45:00	SPY	ETF	152.17	152.17	152.17	152.17	2500.0
2013-02-15 06:55:00	SPY	ETF	152.16	152.16	152.16	152.16	500.0
2013-02-15 07:00:00	SPY	ETF	152.12	152.16	152.11	152.11	109300.0
2013-02-15 07:05:00	SPY	ETF	152.12	152.12	152.1	152.1	2000.0
2013-02-15 07:10:00	SPY	ETF	152.09	152.12	152.08	152.12	20600.0
2013-02-15 07:15:00	SPY	ETF	152.08	152.08	152.08	152.08	100.0
2013-02-15 07:20:00	SPY	ETF	152.09	152.1	152.09	152.1	900.0
2013-02-15 07:25:00	SPY	ETF	152.08	152.1	152.04	152.1	7415.0
2013-02-15 07:30:00	SPY	ETF	152.08	152.1	152.08	152.09	9607.0
2013-02-15 07:35:00	SPY	ETF	152.1	152.12	152.09	152.12	5450.0
2013-02-15 07:40:00	SPY	ETF	152.12	152.14	152.095	152.095	3000.0
2013-02-15 07:45:00	SPY	ETF	152.12	152.12	152.095	152.12	23600.0
2013-02-15 07:50:00	SPY	ETF	152.13	152.13	152.09	152.12	61800.0
2013-02-15 07:55:00	SPY	ETF	152.1	152.13	152.09	152.1	54449.0
2013-02-15 08:00:00	SPY	ETF	152.1	152.1541	151.95	152.1	132857.0
2013-02-15 08:05:00	SPY	ETF	152.12	152.3	152.12	152.22	59399.0
2013-02-15 08:10:00	SPY	ETF	152.22	152.22	152.17	152.17	40700.0
2013-02-15 08:15:00	SPY	ETF	152.18	152.28	152.18	152.26	19193.0
2013-02-15 08:20:00	SPY	ETF	152.26	152.26	152.19	152.2	69516.0
2013-02-15 08:25:00	SPY	ETF	152.19	152.23	152.13	152.23	74039.0
2013-02-15 08:30:00	SPY	ETF	152.32	152.32	152.17	152.21	213214.0
2013-02-15 08:35:00	SPY	ETF	152.21	152.23	152.16	152.17	115936.0
2013-02-15 08:40:00	SPY	ETF	152.17	152.27	152.16	152.26	232333.0
2013-02-15 08:45:00	SPY	ETF	152.26	152.32	152.26	152.32	57050.0
2013-02-15 08:50:00	SPY	ETF	152.32	152.36	152.32	152.33	307917.0
2013-02-15 08:55:00	SPY	ETF	152.34	152.34	152.29	152.29	74350.0
2013-02-15 09:00:00	SPY	ETF	152.29	152.3	152.24	152.26	99490.0
2013-02-15 09:05:00	SPY	ETF	152.26	152.27	152.19	152.21	58840.0
2013-02-15 09:10:00	SPY	ETF	152.2	152.27	152.2	152.24	66541.0
2013-02-15 09:15:00	SPY	ETF	152.23	152.35	152.17	152.34	254385.0
2013-02-15 09:20:00	SPY	ETF	152.35	152.43	152.31	152.4	332495.0

> showing 50 of 39,136 rows — these rows as CSV

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