PREVIEW / etf_5min / 2013-04-26

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-04-26.parquet
  size:    902 KB
  rows:    38,735

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-04-26 04:15:00	SPY	ETF	158.3	158.3	158.3	158.3	10000.0
2013-04-26 04:35:00	SPY	ETF	158.2	158.2	158.2	158.2	2500.0
2013-04-26 04:45:00	SPY	ETF	158.1	158.2	158.1	158.2	2699.0
2013-04-26 04:55:00	SPY	ETF	158.2	158.2	158.2	158.2	100.0
2013-04-26 05:00:00	SPY	ETF	158.16	158.16	158.11	158.11	200.0
2013-04-26 05:05:00	SPY	ETF	158.08	158.08	158.08	158.08	200.0
2013-04-26 05:10:00	SPY	ETF	158.08	158.08	158.08	158.08	1160.0
2013-04-26 05:15:00	SPY	ETF	158.15	158.15	158.15	158.15	125.0
2013-04-26 05:20:00	SPY	ETF	158.1	158.1	158.08	158.08	8500.0
2013-04-26 05:25:00	SPY	ETF	158.08	158.09	158.08	158.09	1700.0
2013-04-26 05:35:00	SPY	ETF	158.18	158.18	158.18	158.18	4100.0
2013-04-26 05:40:00	SPY	ETF	158.14	158.15	158.14	158.15	250.0
2013-04-26 05:45:00	SPY	ETF	158.19	158.19	158.19	158.19	100.0
2013-04-26 05:50:00	SPY	ETF	158.18	158.18	158.18	158.18	200.0
2013-04-26 05:55:00	SPY	ETF	158.19	158.21	158.19	158.21	200.0
2013-04-26 06:00:00	SPY	ETF	158.18	158.18	158.18	158.18	3000.0
2013-04-26 06:05:00	SPY	ETF	158.18	158.18	158.13	158.13	12800.0
2013-04-26 06:10:00	SPY	ETF	158.15	158.16	158.11	158.16	10500.0
2013-04-26 06:15:00	SPY	ETF	158.18	158.18	158.18	158.18	100.0
2013-04-26 06:20:00	SPY	ETF	158.22	158.22	158.22	158.22	200.0
2013-04-26 06:25:00	SPY	ETF	158.17	158.17	158.17	158.17	10000.0
2013-04-26 06:35:00	SPY	ETF	158.16	158.16	158.12	158.12	8200.0
2013-04-26 06:40:00	SPY	ETF	158.13	158.13	158.0	158.08	13320.0
2013-04-26 06:45:00	SPY	ETF	158.11	158.11	158.11	158.11	6000.0
2013-04-26 06:50:00	SPY	ETF	158.15	158.19	158.15	158.15	3800.0
2013-04-26 06:55:00	SPY	ETF	158.15	158.16	158.12	158.16	3900.0
2013-04-26 07:00:00	SPY	ETF	158.18	158.2	158.12	158.12	14900.0
2013-04-26 07:05:00	SPY	ETF	158.15	158.16	158.13	158.15	7500.0
2013-04-26 07:10:00	SPY	ETF	158.18	158.23	158.18	158.23	3000.0
2013-04-26 07:15:00	SPY	ETF	158.23	158.27	158.2	158.27	6400.0
2013-04-26 07:20:00	SPY	ETF	158.27	158.33	158.27	158.33	15800.0
2013-04-26 07:25:00	SPY	ETF	158.28	158.31	158.2	158.2	275600.0
2013-04-26 07:30:00	SPY	ETF	158.2	158.24	158.19	158.21	88400.0
2013-04-26 07:35:00	SPY	ETF	158.21	158.22	158.2	158.22	3300.0
2013-04-26 07:40:00	SPY	ETF	158.2	158.2	158.18	158.19	28450.0
2013-04-26 07:45:00	SPY	ETF	158.19	158.25	158.19	158.25	11900.0
2013-04-26 07:50:00	SPY	ETF	158.25	158.25	158.23	158.23	19300.0
2013-04-26 07:55:00	SPY	ETF	158.25	158.29	158.2	158.2	66700.0
2013-04-26 08:00:00	SPY	ETF	158.2	158.27	158.01	158.23	708485.0
2013-04-26 08:05:00	SPY	ETF	158.17	158.2	158.13	158.15	54100.0
2013-04-26 08:10:00	SPY	ETF	158.15	158.2	158.15	158.2	38100.0
2013-04-26 08:15:00	SPY	ETF	158.21	158.52	158.21	158.26	417385.0
2013-04-26 08:20:00	SPY	ETF	158.26	158.31	158.25	158.25	53150.0
2013-04-26 08:25:00	SPY	ETF	158.28	158.36	158.23	158.31	174178.0
2013-04-26 08:30:00	SPY	ETF	158.23	158.23	157.91	158.11	355601.0
2013-04-26 08:35:00	SPY	ETF	158.1	158.15	158.0	158.14	100066.0
2013-04-26 08:40:00	SPY	ETF	158.17	158.24	158.09	158.13	128004.0
2013-04-26 08:45:00	SPY	ETF	158.14	158.15	158.06	158.06	83437.0
2013-04-26 08:50:00	SPY	ETF	158.05	158.2	158.05	158.19	71279.0
2013-04-26 08:55:00	SPY	ETF	158.19	158.22	158.14	158.2	74579.0

> showing 50 of 38,735 rows — these rows as CSV

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