PREVIEW / etf_daily / 2013-07-22

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-22.parquet
  size:    41 KB
  rows:    1,010

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2013-07-22	SPY	ETF	169.41	169.74	169.01	169.5	79428600.0
2013-07-22	QQQ	ETF	74.87	74.98	74.58	74.81	21135860.0
2013-07-22	IWM	ETF	104.48	104.76	104.13	104.53	25854900.0
2013-07-22	DIA	ETF	155.12	155.42	154.81	155.11	3165700.0
2013-07-22	GLD	ETF	127.65	129.46	127.59	128.84	10851900.0
2013-07-22	TLT	ETF	109.36	109.69	109.13	109.36	3972600.0
2013-07-22	AADR	ETF	33.83	34.0	33.79	34.0	12600.0
2013-07-22	AAXJ	ETF	55.86	56.35	55.86	56.29	227300.0
2013-07-22	ACTV	ETF	9.01	9.06	8.89	8.98	707747.0
2013-07-22	ACWI	ETF	52.68	52.81	52.56	52.76	1091600.0
2013-07-22	ACWV	ETF	62.22	62.26	61.95	62.25	61700.0
2013-07-22	ACWX	ETF	42.92	43.15	42.92	43.15	461773.0
2013-07-22	ADRE	ETF	34.93	35.422	34.93	35.39	59116.0
2013-07-22	AFK	ETF	29.0	29.27	28.92	29.27	54741.0
2013-07-22	AGEM	ETF	21.44	21.44	21.44	21.44	100.0
2013-07-22	AGG	ETF	107.53	107.69	107.52	107.66	684100.0
2013-07-22	AGQ	ETF	72.32	74.76	72.28	73.88	667575.0
2013-07-22	AGZ	ETF	111.28	111.4599	111.28	111.35	14799.0
2013-07-22	AIA	ETF	43.35	43.66	43.35	43.65	25590.0
2013-07-22	AIQ	ETF	18.25	18.63	18.25	18.46	61783.0
2013-07-22	AIVI	ETF	42.45	42.59	42.38	42.55	41300.0
2013-07-22	ALTL	ETF	29.96	29.99	29.94	29.95	2800.0
2013-07-22	AMJ	ETF	48.52	48.666	48.12	48.26	422442.0
2013-07-22	AMLP	ETF	90.3	90.75	90.1	90.5	363060.0
2013-07-22	ANGL	ETF	27.02	27.02	27.02	27.02	200.0
2013-07-22	AOA	ETF	41.52	41.6	41.49	41.57	22200.0
2013-07-22	AOK	ETF	31.25	31.33	31.25	31.33	5781.0
2013-07-22	AOM	ETF	33.0989	33.19	33.0989	33.19	16758.0
2013-07-22	AOR	ETF	36.54	36.64	36.54	36.63	134521.0
2013-07-22	ARB	ETF	46.42	46.42	46.35	46.41	65334.0
2013-07-22	ARGT	ETF	17.47	17.47	17.38	17.38	2500.0
2013-07-22	ASEA	ETF	17.21	17.39	17.13	17.39	36700.0
2013-07-22	ATMP	ETF	26.55	26.77	26.55	26.7	14000.0
2013-07-22	AVIV	ETF	26.05	26.29	25.63	25.68	134735.0
2013-07-22	AWAY	ETF	31.9	32.34	31.4	31.49	920188.0
2013-07-22	BAB	ETF	28.11	28.22	27.9901	28.02	126928.0
2013-07-22	BAL	ETF	55.132	55.3	54.93	55.278	2969.0
2013-07-22	BALT	ETF	3.76	3.82	3.76	3.8	50040.0
2013-07-22	BBH	ETF	78.5	78.77	77.83	78.34	78800.0
2013-07-22	BCM	ETF	40.32	40.32	40.32	40.32	123.0
2013-07-22	BFOR	ETF	6.5875	6.5875	6.5575	6.5775	128000.0
2013-07-22	BIB	ETF	28.82	29.042	28.405	28.8325	160504.0
2013-07-22	BICK	ETF	21.82	21.9	21.7801	21.9	1894.0
2013-07-22	BIL	ETF	91.6	91.6	91.58	91.6	421550.0
2013-07-22	BIS	ETF	1200.0	1205.2	1189.36	1205.2	216.5
2013-07-22	BIV	ETF	84.04	84.17	84.03	84.11	528900.0
2013-07-22	BIZD	ETF	20.42	20.5	20.42	20.47	3200.0
2013-07-22	BJK	ETF	42.17	42.33	42.04	42.29	5200.0
2013-07-22	BKF	ETF	34.95	35.319	34.89	35.27	60160.0
2013-07-22	BKLN	ETF	24.94	24.98	24.94	24.95	1989700.0

> showing 50 of 1,010 rows — these rows as CSV

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