PREVIEW / etf_1hour / 2013-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-17.parquet
  size:    200 KB
  rows:    6,353

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-07-17 04:00:00	SPY	ETF	167.64	167.64	167.14	167.34	46400.0
2013-07-17 05:00:00	SPY	ETF	167.34	167.34	167.03	167.1	46450.0
2013-07-17 06:00:00	SPY	ETF	167.14	167.43	167.14	167.42	17600.0
2013-07-17 07:00:00	SPY	ETF	167.42	167.71	167.42	167.46	246392.0
2013-07-17 08:00:00	SPY	ETF	167.61	168.18	167.03	167.98	2684364.0
2013-07-17 09:00:00	SPY	ETF	167.98	168.28	167.76	167.98	13164066.0
2013-07-17 10:00:00	SPY	ETF	167.98	168.48	167.85	168.1	17582639.0
2013-07-17 11:00:00	SPY	ETF	168.11	168.26	167.75	167.88	9755047.0
2013-07-17 12:00:00	SPY	ETF	167.88	168.23	167.86	168.1499	6578435.0
2013-07-17 13:00:00	SPY	ETF	168.14	168.3	168.01	168.1501	6140490.0
2013-07-17 14:00:00	SPY	ETF	168.16	168.22	167.76	167.88	8013526.0
2013-07-17 15:00:00	SPY	ETF	167.871	168.07	167.73	167.96	19314949.0
2013-07-17 16:00:00	SPY	ETF	167.96	168.14	167.5513	167.99	6369085.0
2013-07-17 17:00:00	SPY	ETF	167.99	168.13	167.97	168.07	141636.0
2013-07-17 18:00:00	SPY	ETF	168.09	168.13	168.04	168.09	22424.0
2013-07-17 19:00:00	SPY	ETF	168.07	168.07	167.82	167.85	85045.0
2013-07-17 04:00:00	QQQ	ETF	75.45	75.45	75.32	75.36	8000.0
2013-07-17 05:00:00	QQQ	ETF	75.33	75.33	75.26	75.29	3100.0
2013-07-17 06:00:00	QQQ	ETF	75.29	75.38	75.29	75.38	4800.0
2013-07-17 07:00:00	QQQ	ETF	75.39	75.5	75.39	75.4	16325.0
2013-07-17 08:00:00	QQQ	ETF	75.49	75.62	75.42	75.56	137151.0
2013-07-17 09:00:00	QQQ	ETF	75.56	75.69	75.46	75.53	2496909.0
2013-07-17 10:00:00	QQQ	ETF	75.53	75.74	75.47	75.57	4525387.0
2013-07-17 11:00:00	QQQ	ETF	75.57	75.6298	75.39	75.5	1756088.0
2013-07-17 12:00:00	QQQ	ETF	75.5	75.68	75.5	75.61	1576119.0
2013-07-17 13:00:00	QQQ	ETF	75.6125	75.7	75.53	75.58	2835619.0
2013-07-17 14:00:00	QQQ	ETF	75.5896	75.6	75.35	75.435	1415407.0
2013-07-17 15:00:00	QQQ	ETF	75.43	75.59	75.4	75.55	3928099.0
2013-07-17 16:00:00	QQQ	ETF	75.56	75.7064	75.18	75.49	5502119.0
2013-07-17 17:00:00	QQQ	ETF	75.46	75.5	75.46	75.48	2980.0
2013-07-17 18:00:00	QQQ	ETF	75.47	75.48	75.46	75.48	8992.0
2013-07-17 19:00:00	QQQ	ETF	75.47	75.47	75.39	75.4	22365.0
2013-07-17 05:00:00	IWM	ETF	103.0	103.0	103.0	103.0	100.0
2013-07-17 06:00:00	IWM	ETF	102.98	103.08	102.98	103.08	25900.0
2013-07-17 07:00:00	IWM	ETF	103.13	103.32	103.13	103.13	29300.0
2013-07-17 08:00:00	IWM	ETF	103.16	103.63	102.85	103.5	400447.0
2013-07-17 09:00:00	IWM	ETF	103.53	103.66	103.24	103.45	2636405.0
2013-07-17 10:00:00	IWM	ETF	103.44	103.95	103.42	103.69	7405591.0
2013-07-17 11:00:00	IWM	ETF	103.69	103.82	103.36	103.38	3975772.0
2013-07-17 12:00:00	IWM	ETF	103.37	103.67	103.34	103.52	2003289.0
2013-07-17 13:00:00	IWM	ETF	103.52	103.6	103.42	103.55	1695642.0
2013-07-17 14:00:00	IWM	ETF	103.54	103.645	103.29	103.4	2425556.0
2013-07-17 15:00:00	IWM	ETF	103.39	103.49	103.31	103.47	3652004.0
2013-07-17 16:00:00	IWM	ETF	103.45	103.59	103.34	103.52	861030.0
2013-07-17 17:00:00	IWM	ETF	103.53	103.57	103.53	103.57	6800.0
2013-07-17 18:00:00	IWM	ETF	103.51	103.56	103.5	103.56	3252.0
2013-07-17 19:00:00	IWM	ETF	103.5	103.5	103.43	103.43	8400.0
2013-07-17 04:00:00	DIA	ETF	154.46	154.46	154.46	154.46	100.0
2013-07-17 08:00:00	DIA	ETF	154.11	154.59	154.1	154.58	39693.0
2013-07-17 09:00:00	DIA	ETF	154.55	154.75	154.3	154.51	742336.0

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

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