PREVIEW / etf_1min / 2013-05-22

all etf 1-min files

  file:    by_date/etf_1min/2013/2013-05-22.parquet
  size:    2.6 MB
  rows:    129,886

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-05-22 04:07:00	SPY	ETF	167.36	167.36	167.33	167.33	1585.0
2013-05-22 04:13:00	SPY	ETF	167.33	167.33	167.33	167.33	200.0
2013-05-22 04:14:00	SPY	ETF	167.31	167.31	167.31	167.31	100.0
2013-05-22 04:17:00	SPY	ETF	167.28	167.28	167.28	167.28	100.0
2013-05-22 04:24:00	SPY	ETF	167.4	167.4	167.4	167.4	2700.0
2013-05-22 04:29:00	SPY	ETF	167.38	167.38	167.38	167.38	300.0
2013-05-22 04:54:00	SPY	ETF	167.38	167.38	167.38	167.38	400.0
2013-05-22 04:55:00	SPY	ETF	167.37	167.37	167.34	167.34	1300.0
2013-05-22 04:57:00	SPY	ETF	167.34	167.34	167.33	167.33	680.0
2013-05-22 04:59:00	SPY	ETF	167.32	167.32	167.23	167.23	3500.0
2013-05-22 05:00:00	SPY	ETF	167.23	167.23	167.2	167.2	2400.0
2013-05-22 05:01:00	SPY	ETF	167.19	167.19	167.18	167.18	900.0
2013-05-22 05:03:00	SPY	ETF	167.18	167.18	167.18	167.18	300.0
2013-05-22 05:18:00	SPY	ETF	167.28	167.28	167.28	167.28	100.0
2013-05-22 05:31:00	SPY	ETF	167.24	167.24	167.17	167.17	800.0
2013-05-22 05:33:00	SPY	ETF	167.16	167.16	167.15	167.15	981.0
2013-05-22 05:34:00	SPY	ETF	167.14	167.14	167.14	167.14	400.0
2013-05-22 05:42:00	SPY	ETF	167.17	167.17	167.17	167.17	2000.0
2013-05-22 05:43:00	SPY	ETF	167.19	167.19	167.19	167.19	1000.0
2013-05-22 05:51:00	SPY	ETF	167.17	167.17	167.17	167.17	900.0
2013-05-22 06:01:00	SPY	ETF	167.17	167.22	167.17	167.22	20500.0
2013-05-22 06:03:00	SPY	ETF	167.2	167.2	167.2	167.2	200.0
2013-05-22 06:18:00	SPY	ETF	167.26	167.26	167.26	167.26	100.0
2013-05-22 06:25:00	SPY	ETF	167.26	167.26	167.26	167.26	150.0
2013-05-22 06:30:00	SPY	ETF	167.27	167.27	167.27	167.27	10000.0
2013-05-22 06:34:00	SPY	ETF	167.3	167.3	167.3	167.3	10000.0
2013-05-22 06:37:00	SPY	ETF	167.31	167.31	167.2	167.2	1200.0
2013-05-22 06:39:00	SPY	ETF	167.2	167.2	167.2	167.2	500.0
2013-05-22 06:44:00	SPY	ETF	167.22	167.22	167.22	167.22	10000.0
2013-05-22 06:46:00	SPY	ETF	167.25	167.25	167.25	167.25	100.0
2013-05-22 06:47:00	SPY	ETF	167.28	167.28	167.28	167.28	100.0
2013-05-22 06:48:00	SPY	ETF	167.32	167.32	167.32	167.32	5200.0
2013-05-22 06:49:00	SPY	ETF	167.31	167.31	167.31	167.31	200.0
2013-05-22 06:51:00	SPY	ETF	167.35	167.35	167.35	167.35	10100.0
2013-05-22 06:53:00	SPY	ETF	167.3	167.3	167.29	167.29	400.0
2013-05-22 06:54:00	SPY	ETF	167.28	167.3	167.28	167.3	500.0
2013-05-22 06:55:00	SPY	ETF	167.27	167.27	167.26	167.26	400.0
2013-05-22 06:58:00	SPY	ETF	167.28	167.28	167.28	167.28	200.0
2013-05-22 06:59:00	SPY	ETF	167.27	167.27	167.27	167.27	300.0
2013-05-22 07:02:00	SPY	ETF	167.27	167.32	167.27	167.3	8900.0
2013-05-22 07:03:00	SPY	ETF	167.3	167.3	167.24	167.25	8600.0
2013-05-22 07:04:00	SPY	ETF	167.26	167.27	167.26	167.27	700.0
2013-05-22 07:06:00	SPY	ETF	167.24	167.24	167.23	167.23	700.0
2013-05-22 07:07:00	SPY	ETF	167.22	167.24	167.21	167.21	1800.0
2013-05-22 07:09:00	SPY	ETF	167.26	167.31	167.26	167.29	9000.0
2013-05-22 07:10:00	SPY	ETF	167.3	167.3	167.3	167.3	400.0
2013-05-22 07:16:00	SPY	ETF	167.3	167.31	167.3	167.31	400.0
2013-05-22 07:17:00	SPY	ETF	167.3	167.31	167.3	167.31	300.0
2013-05-22 07:19:00	SPY	ETF	167.32	167.32	167.32	167.32	500.0
2013-05-22 07:20:00	SPY	ETF	167.32	167.32	167.32	167.32	100.0

> showing 50 of 129,886 rows — these rows as CSV

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