PREVIEW / etf_1hour / 2014-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-03.parquet
  size:    227 KB
  rows:    7,231

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-12-03 04:00:00	SPY	ETF	207.06	207.15	206.87	207.13	7729.0
2014-12-03 05:00:00	SPY	ETF	207.12	207.12	206.85	206.9	17590.0
2014-12-03 06:00:00	SPY	ETF	207.05	207.17	206.97	207.12	23665.0
2014-12-03 07:00:00	SPY	ETF	207.1	207.2	207.09	207.16	84945.0
2014-12-03 08:00:00	SPY	ETF	207.16	207.19	207.01	207.08	453624.0
2014-12-03 09:00:00	SPY	ETF	207.09	207.63	207.06	207.51	8562864.0
2014-12-03 10:00:00	SPY	ETF	207.52	207.77	207.3	207.65	10133773.0
2014-12-03 11:00:00	SPY	ETF	207.64	207.76	207.41	207.49	8832700.0
2014-12-03 12:00:00	SPY	ETF	207.495	207.61	207.335	207.6	5213956.0
2014-12-03 13:00:00	SPY	ETF	207.6	207.66	207.54	207.635	5545248.0
2014-12-03 14:00:00	SPY	ETF	207.64	207.78	207.59	207.69	6384356.0
2014-12-03 15:00:00	SPY	ETF	207.69	208.15	207.67	207.91	14809430.0
2014-12-03 16:00:00	SPY	ETF	207.91	207.94	207.72	207.83	7946424.0
2014-12-03 17:00:00	SPY	ETF	207.82	207.87	207.82	207.84	375468.0
2014-12-03 18:00:00	SPY	ETF	207.85	207.89	207.81	207.86	35691.0
2014-12-03 19:00:00	SPY	ETF	207.86	207.86	207.8	207.84	40458.0
2014-12-03 05:00:00	QQQ	ETF	105.23	105.23	105.15	105.15	1145.0
2014-12-03 06:00:00	QQQ	ETF	105.19	105.27	105.19	105.2	6626.0
2014-12-03 07:00:00	QQQ	ETF	105.24	105.27	105.18	105.27	1403.0
2014-12-03 08:00:00	QQQ	ETF	105.28	105.29	105.18	105.18	37764.0
2014-12-03 09:00:00	QQQ	ETF	105.22	105.52	105.08	105.14	4532483.0
2014-12-03 10:00:00	QQQ	ETF	105.15	105.2	104.7626	105.02	4861101.0
2014-12-03 11:00:00	QQQ	ETF	105.01	105.24	104.98	105.19	2581481.0
2014-12-03 12:00:00	QQQ	ETF	105.19	105.2425	105.09	105.17	1814864.0
2014-12-03 13:00:00	QQQ	ETF	105.175	105.4	105.155	105.39	1693861.0
2014-12-03 14:00:00	QQQ	ETF	105.39	105.44	105.33	105.37	1617134.0
2014-12-03 15:00:00	QQQ	ETF	105.36	105.565	105.36	105.42	4357065.0
2014-12-03 16:00:00	QQQ	ETF	105.42	105.5183	105.1596	105.39	2879035.0
2014-12-03 17:00:00	QQQ	ETF	105.34	105.341	105.34	105.341	655.0
2014-12-03 18:00:00	QQQ	ETF	105.36	105.41	105.36	105.39	46483.0
2014-12-03 19:00:00	QQQ	ETF	105.37	105.39	105.35	105.38	2542.0
2014-12-03 07:00:00	IWM	ETF	116.27	116.27	116.23	116.23	1800.0
2014-12-03 08:00:00	IWM	ETF	116.23	116.35	116.16	116.19	45186.0
2014-12-03 09:00:00	IWM	ETF	116.19	116.82	116.02	116.64	2912023.0
2014-12-03 10:00:00	IWM	ETF	116.64	117.49	116.405	117.475	5179535.0
2014-12-03 11:00:00	IWM	ETF	117.47	117.71	117.33	117.36	2653058.0
2014-12-03 12:00:00	IWM	ETF	117.3643	117.55	117.06	117.12	1370020.0
2014-12-03 13:00:00	IWM	ETF	117.11	117.26	116.96	117.13	1201618.0
2014-12-03 14:00:00	IWM	ETF	117.13	117.52	117.09	117.4	1638430.0
2014-12-03 15:00:00	IWM	ETF	117.41	117.65	117.34	117.37	5240702.0
2014-12-03 16:00:00	IWM	ETF	117.39	117.41	116.2459	117.37	2747743.0
2014-12-03 17:00:00	IWM	ETF	117.37	117.38	117.34	117.34	11046.0
2014-12-03 18:00:00	IWM	ETF	117.39	117.41	117.39	117.41	876.0
2014-12-03 09:00:00	DIA	ETF	178.49	178.814	178.41	178.74	1611564.0
2014-12-03 10:00:00	DIA	ETF	178.74	178.91	178.59	178.85	1267985.0
2014-12-03 11:00:00	DIA	ETF	178.85	178.92	178.63	178.75	1504448.0
2014-12-03 12:00:00	DIA	ETF	178.76	178.83	178.6	178.83	1044203.0
2014-12-03 13:00:00	DIA	ETF	178.83	178.86	178.765	178.82	364687.0
2014-12-03 14:00:00	DIA	ETF	178.82	178.9	178.8	178.85	487699.0
2014-12-03 15:00:00	DIA	ETF	178.85	179.14	178.82	178.95	1588291.0

> showing 50 of 7,231 rows — these rows as CSV

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