PREVIEW / etf_1hour / 2014-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-22.parquet
  size:    224 KB
  rows:    7,381

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-07-22 04:00:00	SPY	ETF	197.36	197.54	197.3	197.54	1833.0
2014-07-22 05:00:00	SPY	ETF	197.49	197.78	197.49	197.75	39343.0
2014-07-22 06:00:00	SPY	ETF	197.73	197.86	197.59	197.71	111095.0
2014-07-22 07:00:00	SPY	ETF	197.7	197.97	197.62	197.76	346927.0
2014-07-22 08:00:00	SPY	ETF	197.77	198.09	197.67	197.92	927203.0
2014-07-22 09:00:00	SPY	ETF	197.92	198.23	197.85	198.1	9472684.0
2014-07-22 10:00:00	SPY	ETF	198.1	198.43	198.1	198.35	11949837.0
2014-07-22 11:00:00	SPY	ETF	198.35	198.56	198.3	198.37	8788826.0
2014-07-22 12:00:00	SPY	ETF	198.36	198.55	198.35	198.36	5200300.0
2014-07-22 13:00:00	SPY	ETF	198.355	198.48	198.28	198.3799	4439015.0
2014-07-22 14:00:00	SPY	ETF	198.3796	198.47	198.0	198.19	8811982.0
2014-07-22 15:00:00	SPY	ETF	198.19	198.42	198.12	198.19	11693143.0
2014-07-22 16:00:00	SPY	ETF	198.2	198.3	197.77	197.77	5027230.0
2014-07-22 17:00:00	SPY	ETF	197.77	197.97	197.77	197.86	106723.0
2014-07-22 18:00:00	SPY	ETF	197.82	198.03	197.82	197.92	111895.0
2014-07-22 19:00:00	SPY	ETF	197.91	197.92	197.88	197.91	46553.0
2014-07-22 04:00:00	QQQ	ETF	96.13	96.2	96.07	96.2	10300.0
2014-07-22 05:00:00	QQQ	ETF	96.2	96.3	96.2	96.3	37150.0
2014-07-22 06:00:00	QQQ	ETF	96.3	96.3	96.26	96.27	3420.0
2014-07-22 07:00:00	QQQ	ETF	96.26	96.46	96.25	96.35	157859.0
2014-07-22 08:00:00	QQQ	ETF	96.36	96.48	96.28	96.39	182101.0
2014-07-22 09:00:00	QQQ	ETF	96.39	96.6	96.345	96.48	3374695.0
2014-07-22 10:00:00	QQQ	ETF	96.49	96.76	96.49	96.67	3309612.0
2014-07-22 11:00:00	QQQ	ETF	96.68	96.75	96.58	96.615	1653987.0
2014-07-22 12:00:00	QQQ	ETF	96.62	96.73	96.6	96.621	1334055.0
2014-07-22 13:00:00	QQQ	ETF	96.629	96.71	96.59	96.642	1186832.0
2014-07-22 14:00:00	QQQ	ETF	96.64	96.69	96.4	96.52	3906273.0
2014-07-22 15:00:00	QQQ	ETF	96.515	96.69	96.47	96.62	5398217.0
2014-07-22 16:00:00	QQQ	ETF	96.62	96.6602	96.31	96.38	3251588.0
2014-07-22 17:00:00	QQQ	ETF	96.39	96.5	96.36	96.42	275403.0
2014-07-22 18:00:00	QQQ	ETF	96.42	96.56	96.39	96.48	70749.0
2014-07-22 19:00:00	QQQ	ETF	96.46	96.47	96.44	96.44	19046.0
2014-07-22 06:00:00	IWM	ETF	114.2	114.2	114.2	114.2	100.0
2014-07-22 07:00:00	IWM	ETF	114.15	114.57	114.15	114.45	38000.0
2014-07-22 08:00:00	IWM	ETF	114.35	114.69	114.35	114.4	251691.0
2014-07-22 09:00:00	IWM	ETF	114.4	114.83	114.19	114.73	4162575.0
2014-07-22 10:00:00	IWM	ETF	114.73	115.15	114.7	115.105	6089089.0
2014-07-22 11:00:00	IWM	ETF	115.11	115.24	114.95	115.17	3036159.0
2014-07-22 12:00:00	IWM	ETF	115.17	115.25	115.02	115.02	1532056.0
2014-07-22 13:00:00	IWM	ETF	115.01	115.16	114.9	115.01	1327912.0
2014-07-22 14:00:00	IWM	ETF	115.0	115.06	114.4	114.61	3308496.0
2014-07-22 15:00:00	IWM	ETF	114.6	114.79	114.55	114.72	3936560.0
2014-07-22 16:00:00	IWM	ETF	114.71	114.7489	114.3	114.34	2171784.0
2014-07-22 17:00:00	IWM	ETF	114.32	114.54	114.31	114.5	18000.0
2014-07-22 18:00:00	IWM	ETF	114.54	114.54	114.54	114.54	2700.0
2014-07-22 19:00:00	IWM	ETF	114.5	114.5	114.4	114.4	4206.0
2014-07-22 04:00:00	DIA	ETF	170.3	170.3	170.3	170.3	1000.0
2014-07-22 05:00:00	DIA	ETF	170.6	170.6	170.6	170.6	500.0
2014-07-22 07:00:00	DIA	ETF	170.54	170.72	170.54	170.56	10371.0
2014-07-22 08:00:00	DIA	ETF	170.55	170.72	170.46	170.6	19100.0

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

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