PREVIEW / etf_1hour / 2014-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-03.parquet
  size:    212 KB
  rows:    6,787

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-06-03 04:00:00	SPY	ETF	192.58	192.64	192.52	192.59	3704.0
2014-06-03 05:00:00	SPY	ETF	192.6	192.6	192.48	192.5	11864.0
2014-06-03 06:00:00	SPY	ETF	192.51	192.58	192.51	192.52	29607.0
2014-06-03 07:00:00	SPY	ETF	192.52	192.54	192.2	192.28	449687.0
2014-06-03 08:00:00	SPY	ETF	192.3	192.635	192.23	192.32	843309.0
2014-06-03 09:00:00	SPY	ETF	192.33	192.7	192.28	192.645	8924368.0
2014-06-03 10:00:00	SPY	ETF	192.64	192.83	192.36	192.4913	11009929.0
2014-06-03 11:00:00	SPY	ETF	192.49	192.57	192.25	192.435	9733385.0
2014-06-03 12:00:00	SPY	ETF	192.43	192.73	192.42	192.61	5174939.0
2014-06-03 13:00:00	SPY	ETF	192.62	192.77	192.6	192.76	3209168.0
2014-06-03 14:00:00	SPY	ETF	192.77	192.9	192.71	192.73	4594032.0
2014-06-03 15:00:00	SPY	ETF	192.73	192.87	192.63	192.81	11055413.0
2014-06-03 16:00:00	SPY	ETF	192.8	192.9009	192.76	192.88	7903037.0
2014-06-03 17:00:00	SPY	ETF	192.89	192.97	192.88	192.92	396906.0
2014-06-03 18:00:00	SPY	ETF	192.9	192.9	192.73	192.79	46323.0
2014-06-03 19:00:00	SPY	ETF	192.82	192.86	192.82	192.83	14670.0
2014-06-03 05:00:00	QQQ	ETF	91.03	91.04	90.98	91.04	400.0
2014-06-03 06:00:00	QQQ	ETF	91.0	91.0	90.97	90.97	1700.0
2014-06-03 07:00:00	QQQ	ETF	90.98	90.98	90.84	90.86	9950.0
2014-06-03 08:00:00	QQQ	ETF	90.87	90.92	90.85	90.89	111483.0
2014-06-03 09:00:00	QQQ	ETF	90.9	91.23	90.8	91.22	4004100.0
2014-06-03 10:00:00	QQQ	ETF	91.22	91.33	91.0	91.09	3829520.0
2014-06-03 11:00:00	QQQ	ETF	91.08	91.11	90.8601	90.9903	2011354.0
2014-06-03 12:00:00	QQQ	ETF	90.99	91.17	90.98	91.03	1409837.0
2014-06-03 13:00:00	QQQ	ETF	91.03	91.19	91.03	91.14	1037690.0
2014-06-03 14:00:00	QQQ	ETF	91.14	91.23	91.06	91.08	2096242.0
2014-06-03 15:00:00	QQQ	ETF	91.08	91.215	91.03	91.18	2763765.0
2014-06-03 16:00:00	QQQ	ETF	91.18	91.26	91.1212	91.26	3447243.0
2014-06-03 17:00:00	QQQ	ETF	91.25	91.31	91.24	91.27	25750.0
2014-06-03 18:00:00	QQQ	ETF	91.2	91.2	91.17	91.2	16010.0
2014-06-03 19:00:00	QQQ	ETF	91.22	91.25	91.22	91.23	6850.0
2014-06-03 05:00:00	IWM	ETF	111.83	111.83	111.83	111.83	100.0
2014-06-03 06:00:00	IWM	ETF	111.8	111.86	111.8	111.86	200.0
2014-06-03 07:00:00	IWM	ETF	111.73	111.73	111.48	111.56	79400.0
2014-06-03 08:00:00	IWM	ETF	111.6	111.7	111.55	111.67	145440.0
2014-06-03 09:00:00	IWM	ETF	111.68	112.15	111.38	112.12	3294520.0
2014-06-03 10:00:00	IWM	ETF	112.1	112.36	111.44	111.67	5225025.0
2014-06-03 11:00:00	IWM	ETF	111.66	111.71	111.11	111.2	4891584.0
2014-06-03 12:00:00	IWM	ETF	111.2	111.685	111.18	111.6	2447331.0
2014-06-03 13:00:00	IWM	ETF	111.6049	112.05	111.55	111.915	2601141.0
2014-06-03 14:00:00	IWM	ETF	111.92	112.17	111.865	111.91	2225592.0
2014-06-03 15:00:00	IWM	ETF	111.91	112.06	111.82	111.99	5276089.0
2014-06-03 16:00:00	IWM	ETF	112.0	112.08	111.47	111.92	1546094.0
2014-06-03 17:00:00	IWM	ETF	111.92	111.96	111.9	111.95	12100.0
2014-06-03 18:00:00	IWM	ETF	111.95	111.95	111.95	111.95	125.0
2014-06-03 19:00:00	IWM	ETF	111.92	111.92	111.85	111.91	3300.0
2014-06-03 04:00:00	DIA	ETF	167.07	167.07	167.07	167.07	500.0
2014-06-03 05:00:00	DIA	ETF	167.05	167.05	167.0	167.0	3000.0
2014-06-03 07:00:00	DIA	ETF	166.95	166.95	166.78	166.9	18300.0
2014-06-03 08:00:00	DIA	ETF	167.0	167.0	166.81	166.86	5801.0

> showing 50 of 6,787 rows — these rows as CSV

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