PREVIEW / etf_1min / 2011-06-28

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-06-28.parquet
  size:    1.9 MB
  rows:    98,747

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
2011-06-28 04:00:00	SPY	ETF	128.18	128.18	128.18	128.18	500.0
2011-06-28 04:01:00	SPY	ETF	128.18	128.19	128.18	128.18	600.0
2011-06-28 04:03:00	SPY	ETF	128.25	128.25	128.25	128.25	200.0
2011-06-28 04:04:00	SPY	ETF	128.25	128.25	128.25	128.25	300.0
2011-06-28 04:06:00	SPY	ETF	128.14	128.14	128.14	128.14	500.0
2011-06-28 04:10:00	SPY	ETF	128.17	128.17	128.17	128.17	200.0
2011-06-28 04:11:00	SPY	ETF	128.17	128.17	128.17	128.17	300.0
2011-06-28 04:12:00	SPY	ETF	128.12	128.12	128.08	128.08	700.0
2011-06-28 04:13:00	SPY	ETF	128.05	128.05	128.05	128.05	300.0
2011-06-28 04:28:00	SPY	ETF	128.07	128.07	128.07	128.07	500.0
2011-06-28 04:45:00	SPY	ETF	128.08	128.08	128.08	128.08	100.0
2011-06-28 04:46:00	SPY	ETF	128.05	128.05	128.05	128.05	200.0
2011-06-28 04:49:00	SPY	ETF	128.0	128.0	128.0	128.0	100.0
2011-06-28 05:00:00	SPY	ETF	127.89	127.89	127.89	127.89	100.0
2011-06-28 05:01:00	SPY	ETF	127.95	127.95	127.95	127.95	100.0
2011-06-28 05:03:00	SPY	ETF	127.88	127.88	127.88	127.88	100.0
2011-06-28 05:06:00	SPY	ETF	127.89	127.9	127.89	127.9	600.0
2011-06-28 05:08:00	SPY	ETF	127.92	127.92	127.92	127.92	400.0
2011-06-28 05:14:00	SPY	ETF	127.81	127.81	127.81	127.81	100.0
2011-06-28 05:16:00	SPY	ETF	127.86	127.86	127.86	127.86	300.0
2011-06-28 05:18:00	SPY	ETF	127.85	127.85	127.85	127.85	100.0
2011-06-28 05:31:00	SPY	ETF	127.85	127.85	127.85	127.85	100.0
2011-06-28 05:34:00	SPY	ETF	127.8	127.8	127.8	127.8	200.0
2011-06-28 05:35:00	SPY	ETF	127.8	127.8	127.8	127.8	4650.0
2011-06-28 05:38:00	SPY	ETF	127.82	127.82	127.82	127.82	1000.0
2011-06-28 05:42:00	SPY	ETF	127.87	127.87	127.87	127.87	100.0
2011-06-28 05:44:00	SPY	ETF	127.87	127.87	127.87	127.87	1000.0
2011-06-28 05:45:00	SPY	ETF	127.87	127.87	127.87	127.87	1000.0
2011-06-28 05:46:00	SPY	ETF	127.87	127.87	127.87	127.87	1000.0
2011-06-28 05:53:00	SPY	ETF	127.87	127.87	127.87	127.87	5900.0
2011-06-28 05:58:00	SPY	ETF	127.75	127.75	127.75	127.75	300.0
2011-06-28 05:59:00	SPY	ETF	127.76	127.76	127.75	127.75	400.0
2011-06-28 06:01:00	SPY	ETF	127.8	127.8	127.8	127.8	100.0
2011-06-28 06:04:00	SPY	ETF	127.8	127.8	127.8	127.8	4900.0
2011-06-28 06:11:00	SPY	ETF	127.92	127.92	127.92	127.92	400.0
2011-06-28 06:20:00	SPY	ETF	127.93	127.93	127.87	127.87	2100.0
2011-06-28 06:22:00	SPY	ETF	127.88	127.88	127.88	127.88	500.0
2011-06-28 06:27:00	SPY	ETF	127.88	127.88	127.88	127.88	300.0
2011-06-28 06:33:00	SPY	ETF	127.88	127.88	127.85	127.85	500.0
2011-06-28 06:36:00	SPY	ETF	127.95	127.95	127.95	127.95	100.0
2011-06-28 06:50:00	SPY	ETF	127.85	127.85	127.85	127.85	100.0
2011-06-28 06:53:00	SPY	ETF	127.86	127.86	127.77	127.77	3900.0
2011-06-28 06:54:00	SPY	ETF	127.77	127.77	127.77	127.77	3500.0
2011-06-28 06:55:00	SPY	ETF	127.85	127.85	127.85	127.85	200.0
2011-06-28 06:58:00	SPY	ETF	127.83	127.83	127.83	127.83	200.0
2011-06-28 07:00:00	SPY	ETF	127.87	127.87	127.87	127.87	500.0
2011-06-28 07:01:00	SPY	ETF	127.89	127.89	127.87	127.87	2500.0
2011-06-28 07:02:00	SPY	ETF	127.87	127.87	127.87	127.87	900.0
2011-06-28 07:03:00	SPY	ETF	127.87	127.87	127.84	127.84	1500.0
2011-06-28 07:04:00	SPY	ETF	127.82	127.82	127.8	127.8	900.0

> showing 50 of 98,747 rows — these rows as CSV

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