PREVIEW / etf_1hour / 2013-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-26.parquet
  size:    209 KB
  rows:    6,594

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-06-26 04:00:00	SPY	ETF	158.59	159.1	158.59	158.92	43911.0
2013-06-26 05:00:00	SPY	ETF	158.95	159.27	158.93	159.27	112453.0
2013-06-26 06:00:00	SPY	ETF	159.26	159.37	159.14	159.15	140592.0
2013-06-26 07:00:00	SPY	ETF	159.15	159.57	159.1	159.54	576032.0
2013-06-26 08:00:00	SPY	ETF	159.2	159.55	158.0	159.53	3142672.0
2013-06-26 09:00:00	SPY	ETF	159.53	160.16	159.42	159.96	21831055.0
2013-06-26 10:00:00	SPY	ETF	159.96	160.11	159.475	159.57	19766019.0
2013-06-26 11:00:00	SPY	ETF	159.56	159.72	159.25	159.4	17071557.0
2013-06-26 12:00:00	SPY	ETF	159.4	159.91	159.38	159.72	9214365.0
2013-06-26 13:00:00	SPY	ETF	159.72	160.22	159.64	160.05	12597371.0
2013-06-26 14:00:00	SPY	ETF	160.05	160.35	159.95	160.24	10809755.0
2013-06-26 15:00:00	SPY	ETF	160.24	160.5	160.08	160.14	32315766.0
2013-06-26 16:00:00	SPY	ETF	160.14	160.186	158.5913	160.03	5321638.0
2013-06-26 17:00:00	SPY	ETF	160.02	160.11	160.02	160.08	146438.0
2013-06-26 18:00:00	SPY	ETF	160.07	160.07	159.91	159.98	62096.0
2013-06-26 19:00:00	SPY	ETF	159.98	160.02	159.88	159.93	72909.0
2013-06-26 04:00:00	QQQ	ETF	70.31	70.48	70.3	70.38	13040.0
2013-06-26 05:00:00	QQQ	ETF	70.4	70.54	70.4	70.54	4800.0
2013-06-26 06:00:00	QQQ	ETF	70.56	70.61	70.52	70.52	9141.0
2013-06-26 07:00:00	QQQ	ETF	70.51	70.68	70.5	70.68	11300.0
2013-06-26 08:00:00	QQQ	ETF	70.68	70.68	69.97	70.65	162617.0
2013-06-26 09:00:00	QQQ	ETF	70.66	70.95	70.62	70.82	3209967.0
2013-06-26 10:00:00	QQQ	ETF	70.83	70.93	70.605	70.74	3343772.0
2013-06-26 11:00:00	QQQ	ETF	70.74	70.79	70.59	70.64	3347575.0
2013-06-26 12:00:00	QQQ	ETF	70.63	70.83	70.63	70.71	2173214.0
2013-06-26 13:00:00	QQQ	ETF	70.709	70.9	70.679	70.8	1599742.0
2013-06-26 14:00:00	QQQ	ETF	70.81	70.9	70.77	70.85	1274296.0
2013-06-26 15:00:00	QQQ	ETF	70.845	71.0	70.84	70.855	5381240.0
2013-06-26 16:00:00	QQQ	ETF	70.85	70.9598	70.1839	70.82	2653425.0
2013-06-26 17:00:00	QQQ	ETF	70.84	70.86	70.83	70.86	2260.0
2013-06-26 18:00:00	QQQ	ETF	70.86	70.86	70.77	70.82	6865.0
2013-06-26 19:00:00	QQQ	ETF	70.79	70.79	70.77	70.77	2100.0
2013-06-26 04:00:00	IWM	ETF	95.98	95.98	95.98	95.98	100.0
2013-06-26 06:00:00	IWM	ETF	96.08	96.14	96.08	96.12	4300.0
2013-06-26 07:00:00	IWM	ETF	96.09	96.37	96.09	96.35	135857.0
2013-06-26 08:00:00	IWM	ETF	96.33	96.37	96.15	96.36	504621.0
2013-06-26 09:00:00	IWM	ETF	96.37	96.63	96.24	96.35	5868840.0
2013-06-26 10:00:00	IWM	ETF	96.36	96.46	95.8	95.93	6394806.0
2013-06-26 11:00:00	IWM	ETF	95.93	96.06	95.65	95.755	4502384.0
2013-06-26 12:00:00	IWM	ETF	95.75	96.2	95.745	96.06	1916716.0
2013-06-26 13:00:00	IWM	ETF	96.06	96.29	96.03	96.16	2273294.0
2013-06-26 14:00:00	IWM	ETF	96.158	96.39	96.09	96.3	1907480.0
2013-06-26 15:00:00	IWM	ETF	96.3083	96.47	95.95	96.04	7498554.0
2013-06-26 16:00:00	IWM	ETF	96.03	96.1111	95.87	96.03	1498481.0
2013-06-26 17:00:00	IWM	ETF	96.03	96.07	96.0	96.0	2200.0
2013-06-26 18:00:00	IWM	ETF	96.02	96.02	96.0	96.0	777.0
2013-06-26 19:00:00	IWM	ETF	96.0	96.0	96.0	96.0	400.0
2013-06-26 05:00:00	DIA	ETF	147.65	147.85	147.65	147.85	16961.0
2013-06-26 06:00:00	DIA	ETF	147.87	147.93	147.87	147.93	6984.0
2013-06-26 07:00:00	DIA	ETF	147.9	148.03	147.9	148.03	7282.0

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

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