PREVIEW / etf_1hour / 2014-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-25.parquet
  size:    223 KB
  rows:    7,325

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-25 04:00:00	SPY	ETF	198.51	198.54	198.45	198.45	1419.0
2014-07-25 05:00:00	SPY	ETF	198.46	198.46	198.31	198.36	6416.0
2014-07-25 06:00:00	SPY	ETF	198.3	198.32	198.08	198.19	13999.0
2014-07-25 07:00:00	SPY	ETF	198.2	198.39	198.14	198.33	224759.0
2014-07-25 08:00:00	SPY	ETF	198.31	198.4	198.2	198.27	525447.0
2014-07-25 09:00:00	SPY	ETF	198.26	198.26	197.75	198.125	10393242.0
2014-07-25 10:00:00	SPY	ETF	198.12	198.26	197.79	197.845	9291735.0
2014-07-25 11:00:00	SPY	ETF	197.85	198.17	197.33	197.67	15409685.0
2014-07-25 12:00:00	SPY	ETF	197.67	197.93	197.66	197.88	5000117.0
2014-07-25 13:00:00	SPY	ETF	197.875	197.88	197.5	197.53	6751590.0
2014-07-25 14:00:00	SPY	ETF	197.53	197.88	197.42	197.73	6564465.0
2014-07-25 15:00:00	SPY	ETF	197.725	197.76	197.48	197.71	14484151.0
2014-07-25 16:00:00	SPY	ETF	197.72	197.75	197.6	197.63	6166658.0
2014-07-25 17:00:00	SPY	ETF	197.61	197.64	197.55	197.55	167326.0
2014-07-25 18:00:00	SPY	ETF	197.55	197.72	197.48	197.65	44629.0
2014-07-25 19:00:00	SPY	ETF	197.6	197.65	197.55	197.58	9752.0
2014-07-25 04:00:00	QQQ	ETF	96.82	96.89	96.82	96.84	5600.0
2014-07-25 05:00:00	QQQ	ETF	96.77	96.79	96.75	96.79	22800.0
2014-07-25 06:00:00	QQQ	ETF	96.71	96.75	96.65	96.75	5100.0
2014-07-25 07:00:00	QQQ	ETF	96.75	96.82	96.74	96.8	23800.0
2014-07-25 08:00:00	QQQ	ETF	96.82	96.82	96.7	96.72	178171.0
2014-07-25 09:00:00	QQQ	ETF	96.72	96.78	96.44	96.72	4564553.0
2014-07-25 10:00:00	QQQ	ETF	96.73	96.87	96.41	96.46	3126762.0
2014-07-25 11:00:00	QQQ	ETF	96.46	96.5357	96.23	96.485	3591190.0
2014-07-25 12:00:00	QQQ	ETF	96.495	96.73	96.495	96.71	1670054.0
2014-07-25 13:00:00	QQQ	ETF	96.71	96.71	96.525	96.56	2046065.0
2014-07-25 14:00:00	QQQ	ETF	96.56	96.71	96.495	96.6	1557488.0
2014-07-25 15:00:00	QQQ	ETF	96.61	96.72	96.51	96.7099	4757491.0
2014-07-25 16:00:00	QQQ	ETF	96.71	97.1627	96.501	96.67	6905492.0
2014-07-25 17:00:00	QQQ	ETF	96.66	96.68	96.59	96.59	9048.0
2014-07-25 18:00:00	QQQ	ETF	96.63	96.64	96.63	96.64	3620.0
2014-07-25 19:00:00	QQQ	ETF	96.66	96.66	96.63	96.64	2700.0
2014-07-25 04:00:00	IWM	ETF	114.39	114.39	114.39	114.39	200.0
2014-07-25 05:00:00	IWM	ETF	113.96	113.96	113.95	113.95	200.0
2014-07-25 06:00:00	IWM	ETF	113.91	113.91	113.18	113.46	5350.0
2014-07-25 07:00:00	IWM	ETF	113.51	113.83	113.51	113.81	55750.0
2014-07-25 08:00:00	IWM	ETF	113.79	113.98	113.72	113.97	199773.0
2014-07-25 09:00:00	IWM	ETF	113.95	113.95	113.38	113.86	6719023.0
2014-07-25 10:00:00	IWM	ETF	113.88	114.01	113.61	113.68	4389924.0
2014-07-25 11:00:00	IWM	ETF	113.67	113.67	113.21	113.57	5639750.0
2014-07-25 12:00:00	IWM	ETF	113.56	113.83	113.52	113.75	1511151.0
2014-07-25 13:00:00	IWM	ETF	113.75	113.79	113.46	113.54	1879017.0
2014-07-25 14:00:00	IWM	ETF	113.53	113.8	113.43	113.71	1932685.0
2014-07-25 15:00:00	IWM	ETF	113.71	113.7802	113.45	113.57	6959491.0
2014-07-25 16:00:00	IWM	ETF	113.58	114.7595	113.4903	113.58	9307712.0
2014-07-25 17:00:00	IWM	ETF	113.58	113.66	113.52	113.66	70700.0
2014-07-25 18:00:00	IWM	ETF	113.51	113.51	113.5	113.5	450.0
2014-07-25 19:00:00	IWM	ETF	113.5	113.5	113.35	113.35	3480.0
2014-07-25 08:00:00	DIA	ETF	170.06	170.3	170.0	170.04	4120.0
2014-07-25 09:00:00	DIA	ETF	170.02	170.02	169.2	169.43	1012825.0

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

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