PREVIEW / etf_1hour / 2014-11-26

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-26.parquet
  size:    224 KB
  rows:    7,124

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-11-26 04:00:00	SPY	ETF	207.51	207.55	207.44	207.55	900.0
2014-11-26 05:00:00	SPY	ETF	207.57	207.58	207.44	207.44	9900.0
2014-11-26 06:00:00	SPY	ETF	207.47	207.54	207.47	207.52	41150.0
2014-11-26 07:00:00	SPY	ETF	207.51	207.53	207.19	207.19	267284.0
2014-11-26 08:00:00	SPY	ETF	207.18	207.65	207.05	207.18	670560.0
2014-11-26 09:00:00	SPY	ETF	207.18	207.4	207.03	207.24	8508315.0
2014-11-26 10:00:00	SPY	ETF	207.24	207.38	207.06	207.28	7465866.0
2014-11-26 11:00:00	SPY	ETF	207.29	207.36	207.17	207.28	5526963.0
2014-11-26 12:00:00	SPY	ETF	207.28	207.43	207.23	207.36	3975727.0
2014-11-26 13:00:00	SPY	ETF	207.35	207.52	207.35	207.46	3594771.0
2014-11-26 14:00:00	SPY	ETF	207.46	207.49	207.35	207.43	5630189.0
2014-11-26 15:00:00	SPY	ETF	207.43	207.76	207.39	207.66	12254486.0
2014-11-26 16:00:00	SPY	ETF	207.64	208.06	207.47	207.96	12139860.0
2014-11-26 17:00:00	SPY	ETF	207.97	207.97	207.88	207.9	109956.0
2014-11-26 18:00:00	SPY	ETF	207.92	207.92	207.83	207.83	75786.0
2014-11-26 19:00:00	SPY	ETF	207.83	207.86	207.78	207.83	107970.0
2014-11-26 04:00:00	QQQ	ETF	105.0	105.11	105.0	105.1	4507.0
2014-11-26 06:00:00	QQQ	ETF	105.07	105.07	105.07	105.07	1000.0
2014-11-26 07:00:00	QQQ	ETF	105.09	105.09	104.93	104.93	34222.0
2014-11-26 08:00:00	QQQ	ETF	105.07	105.07	104.86	104.93	86043.0
2014-11-26 09:00:00	QQQ	ETF	104.93	105.11	104.834	105.02	2770982.0
2014-11-26 10:00:00	QQQ	ETF	105.01	105.235	104.92	105.17	2993126.0
2014-11-26 11:00:00	QQQ	ETF	105.17	105.2998	105.17	105.22	1906925.0
2014-11-26 12:00:00	QQQ	ETF	105.22	105.32	105.1766	105.255	1282903.0
2014-11-26 13:00:00	QQQ	ETF	105.26	105.395	105.26	105.38	976409.0
2014-11-26 14:00:00	QQQ	ETF	105.389	105.41	105.32	105.34	1090880.0
2014-11-26 15:00:00	QQQ	ETF	105.35	105.58	105.32	105.51	2932045.0
2014-11-26 16:00:00	QQQ	ETF	105.52	105.64	104.8127	105.63	2801021.0
2014-11-26 17:00:00	QQQ	ETF	105.64	105.68	105.58	105.58	11463.0
2014-11-26 18:00:00	QQQ	ETF	105.6	105.63	105.58	105.58	9381.0
2014-11-26 19:00:00	QQQ	ETF	105.57	105.6	105.55	105.55	11500.0
2014-11-26 08:00:00	IWM	ETF	117.97	118.11	117.9	118.0	71730.0
2014-11-26 09:00:00	IWM	ETF	118.01	118.15	117.84	118.07	1794767.0
2014-11-26 10:00:00	IWM	ETF	118.06	118.34	117.92	118.08	2675410.0
2014-11-26 11:00:00	IWM	ETF	118.09	118.25	117.899	118.18	1658735.0
2014-11-26 12:00:00	IWM	ETF	118.18	118.29	118.12	118.259	1263535.0
2014-11-26 13:00:00	IWM	ETF	118.2592	118.47	118.23	118.34	1429051.0
2014-11-26 14:00:00	IWM	ETF	118.34	118.42	118.21	118.365	1081711.0
2014-11-26 15:00:00	IWM	ETF	118.36	118.5	118.27	118.42	2761541.0
2014-11-26 16:00:00	IWM	ETF	118.42	118.67	118.4	118.63	1069993.0
2014-11-26 17:00:00	IWM	ETF	118.6	118.63	118.55	118.61	9125.0
2014-11-26 04:00:00	DIA	ETF	178.19	178.19	178.19	178.19	100.0
2014-11-26 08:00:00	DIA	ETF	177.91	177.91	177.82	177.82	700.0
2014-11-26 09:00:00	DIA	ETF	177.87	178.09	177.695	177.87	298235.0
2014-11-26 10:00:00	DIA	ETF	177.85	177.93	177.7	177.81	655385.0
2014-11-26 11:00:00	DIA	ETF	177.82	177.88	177.65	177.73	279861.0
2014-11-26 12:00:00	DIA	ETF	177.74	177.86	177.71	177.75	130218.0
2014-11-26 13:00:00	DIA	ETF	177.76	177.91	177.72	177.86	324810.0
2014-11-26 14:00:00	DIA	ETF	177.87	177.88	177.75	177.75	138148.0
2014-11-26 15:00:00	DIA	ETF	177.74	178.09	177.715	178.01	500153.0

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

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