PREVIEW / etf_daily / 2013-09-19

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-19.parquet
  size:    42 KB
  rows:    1,023

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-09-19	SPY	ETF	173.52	173.6	172.59	172.76	146616900.0
2013-09-19	QQQ	ETF	79.54	79.685	79.36	79.5	26435609.0
2013-09-19	IWM	ETF	107.36	107.43	106.62	106.98	34775900.0
2013-09-19	DIA	ETF	156.87	156.92	156.22	156.32	7626600.0
2013-09-19	GLD	ETF	132.0	132.78	131.22	131.75	14353900.0
2013-09-19	TLT	ETF	105.05	105.09	104.16	104.37	11627800.0
2013-09-19	AADR	ETF	35.86	36.19	35.86	36.19	15300.0
2013-09-19	AAXJ	ETF	61.02	61.08	60.53	61.0	2027200.0
2013-09-19	ACTV	ETF	10.82	10.88	10.64	10.86	283993.0
2013-09-19	ACWI	ETF	55.16	55.24	54.94	55.02	1380700.0
2013-09-19	ACWV	ETF	63.18	63.24	62.78	62.91	24700.0
2013-09-19	ACWX	ETF	46.09	46.15	45.75	45.83	179728.0
2013-09-19	ADRE	ETF	38.53	38.6123	38.25	38.49	40976.0
2013-09-19	AFK	ETF	30.37	30.37	29.75	29.75	22780.0
2013-09-19	AGEM	ETF	23.36	23.4	23.1501	23.32	7280.0
2013-09-19	AGG	ETF	106.86	106.94	106.7	106.77	661800.0
2013-09-19	AGQ	ETF	92.52	94.04	90.72	91.08	787425.0
2013-09-19	AGZ	ETF	111.007	111.04	110.74	110.84	101135.0
2013-09-19	AIA	ETF	48.3	48.3	47.9	48.25	152156.0
2013-09-19	AIQ	ETF	25.34	25.43	24.78	24.85	47790.0
2013-09-19	AIVI	ETF	46.16	46.19	45.89	45.99	37100.0
2013-09-19	ALTL	ETF	30.91	30.91	30.71	30.71	4600.0
2013-09-19	AMJ	ETF	43.98	45.36	43.76	44.9	1648069.0
2013-09-19	AMLP	ETF	86.85	88.5	86.75	88.1	1380060.0
2013-09-19	ANGL	ETF	26.6	26.62	26.6	26.62	1400.0
2013-09-19	AOA	ETF	42.82	42.82	42.58	42.64	39300.0
2013-09-19	AOK	ETF	31.62	31.62	31.5	31.529	34077.0
2013-09-19	AOM	ETF	33.71	33.71	33.5501	33.6	24825.0
2013-09-19	AOR	ETF	37.42	37.42	37.23	37.25	44678.0
2013-09-19	ARB	ETF	47.47	47.92	47.45	47.72	997768.0
2013-09-19	ARGT	ETF	20.2	20.2	20.05	20.05	1600.0
2013-09-19	ASEA	ETF	17.45	17.53	17.42	17.5	58500.0
2013-09-19	ATMP	ETF	25.53	26.48	25.53	26.28	24700.0
2013-09-19	AVIV	ETF	23.3	23.87	23.2	23.41	222834.0
2013-09-19	AWAY	ETF	32.48	32.48	31.57	31.81	920882.0
2013-09-19	BAB	ETF	27.11	27.156	27.02	27.02	124990.0
2013-09-19	BAL	ETF	54.6799	54.72	53.87	54.1321	11722.0
2013-09-19	BALT	ETF	5.21	5.35	5.08	5.1	782920.0
2013-09-19	BBH	ETF	84.44	84.63	83.29	83.82	49400.0
2013-09-19	BCM	ETF	41.249	41.249	41.249	41.249	1014.0
2013-09-19	BFOR	ETF	6.8875	6.8875	6.8275	6.845	354400.0
2013-09-19	BIB	ETF	33.685	33.75	32.7835	33.2866	156476.0
2013-09-19	BICK	ETF	24.59	24.64	24.45	24.59	3400.0
2013-09-19	BIL	ETF	91.58	91.6	91.58	91.6	206200.0
2013-09-19	BIS	ETF	1000.0	1020.0	999.6	1018.0	451.5
2013-09-19	BIV	ETF	83.07	83.16	82.86	82.91	190900.0
2013-09-19	BIZD	ETF	20.66	20.66	20.55	20.58	10400.0
2013-09-19	BJK	ETF	47.95	48.04	47.75	47.81	26800.0
2013-09-19	BKF	ETF	38.87	38.88	38.511	38.7	98248.0
2013-09-19	BKLN	ETF	24.81	24.81	24.76	24.78	1996500.0

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

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