PREVIEW / etf_1hour / 2014-07-09

all etf 1-hour files

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

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-09 04:00:00	SPY	ETF	196.5	196.59	196.47	196.48	3400.0
2014-07-09 05:00:00	SPY	ETF	196.44	196.53	196.4	196.52	10501.0
2014-07-09 06:00:00	SPY	ETF	196.54	196.66	196.51	196.57	28726.0
2014-07-09 07:00:00	SPY	ETF	196.57	196.75	196.56	196.75	281210.0
2014-07-09 08:00:00	SPY	ETF	196.74	196.87	196.66	196.7	610373.0
2014-07-09 09:00:00	SPY	ETF	196.7	197.0	196.43	196.46	10030423.0
2014-07-09 10:00:00	SPY	ETF	196.47	196.99	196.31	196.81	12304077.0
2014-07-09 11:00:00	SPY	ETF	196.815	196.87	196.53	196.66	5973696.0
2014-07-09 12:00:00	SPY	ETF	196.66	196.78	196.61	196.7645	3647025.0
2014-07-09 13:00:00	SPY	ETF	196.765	196.88	196.7	196.81	3770192.0
2014-07-09 14:00:00	SPY	ETF	196.815	197.19	196.44	197.035	15742459.0
2014-07-09 15:00:00	SPY	ETF	197.039	197.295	197.0	197.13	14481355.0
2014-07-09 16:00:00	SPY	ETF	197.12	197.25	196.2143	197.23	5505960.0
2014-07-09 17:00:00	SPY	ETF	197.22	197.25	197.16	197.2	100065.0
2014-07-09 18:00:00	SPY	ETF	197.2	197.23	197.15	197.15	47482.0
2014-07-09 19:00:00	SPY	ETF	197.17	197.19	197.15	197.16	11205.0
2014-07-09 07:00:00	QQQ	ETF	94.49	94.51	94.49	94.51	7220.0
2014-07-09 08:00:00	QQQ	ETF	94.505	94.57	94.505	94.51	112380.0
2014-07-09 09:00:00	QQQ	ETF	94.52	94.78	94.29	94.35	5409568.0
2014-07-09 10:00:00	QQQ	ETF	94.35	94.85	94.24	94.76	4535911.0
2014-07-09 11:00:00	QQQ	ETF	94.77	94.84	94.62	94.74	2054533.0
2014-07-09 12:00:00	QQQ	ETF	94.74	94.82	94.685	94.7927	1254065.0
2014-07-09 13:00:00	QQQ	ETF	94.798	94.89	94.75	94.81	1450218.0
2014-07-09 14:00:00	QQQ	ETF	94.81	95.0	94.551	94.91	4633660.0
2014-07-09 15:00:00	QQQ	ETF	94.915	95.065	94.89	94.97	4110195.0
2014-07-09 16:00:00	QQQ	ETF	94.97	95.0	94.2672	94.99	2714381.0
2014-07-09 17:00:00	QQQ	ETF	94.99	95.01	94.95	94.97	6229.0
2014-07-09 18:00:00	QQQ	ETF	94.99	95.0	94.95	94.96	6120.0
2014-07-09 19:00:00	QQQ	ETF	94.95	94.96	94.95	94.95	5350.0
2014-07-09 08:00:00	IWM	ETF	116.65	116.82	116.64	116.69	96115.0
2014-07-09 09:00:00	IWM	ETF	116.68	117.09	116.09	116.13	4684997.0
2014-07-09 10:00:00	IWM	ETF	116.14	116.97	116.02	116.671	5277251.0
2014-07-09 11:00:00	IWM	ETF	116.672	116.69	116.24	116.37	2794939.0
2014-07-09 12:00:00	IWM	ETF	116.37	116.54	116.245	116.43	1759540.0
2014-07-09 13:00:00	IWM	ETF	116.44	116.62	116.365	116.49	1368599.0
2014-07-09 14:00:00	IWM	ETF	116.48	116.785	116.11	116.55	4443250.0
2014-07-09 15:00:00	IWM	ETF	116.55	116.66	116.325	116.49	3705802.0
2014-07-09 16:00:00	IWM	ETF	116.48	116.59	116.45	116.51	911599.0
2014-07-09 17:00:00	IWM	ETF	116.52	116.58	116.52	116.52	69635.0
2014-07-09 18:00:00	IWM	ETF	116.57	116.57	116.57	116.57	300.0
2014-07-09 07:00:00	DIA	ETF	169.0	169.0	169.0	169.0	314.0
2014-07-09 08:00:00	DIA	ETF	169.27	169.34	169.27	169.34	1309.0
2014-07-09 09:00:00	DIA	ETF	169.07	169.4	168.9001	168.94	522402.0
2014-07-09 10:00:00	DIA	ETF	168.96	169.3	168.86	169.16	431859.0
2014-07-09 11:00:00	DIA	ETF	169.17	169.22	169.01	169.0773	201327.0
2014-07-09 12:00:00	DIA	ETF	169.07	169.24	169.0599	169.22	153826.0
2014-07-09 13:00:00	DIA	ETF	169.22	169.34	169.19	169.29	263343.0
2014-07-09 14:00:00	DIA	ETF	169.28	169.629	169.02	169.56	759380.0
2014-07-09 15:00:00	DIA	ETF	169.54	169.73	169.45	169.57	855640.0
2014-07-09 16:00:00	DIA	ETF	169.57	169.64	169.56	169.57	143122.0

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

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